Semantic search

From Who Called Me
Condition
Printout selection
Options
Parameters [
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:town::FARNBOROUGH]]
SQL Query
SELECT DISTINCT
  t0.smw_id AS id,
  t0.smw_title AS t,
  t0.smw_namespace AS ns,
  t0.smw_iw AS iw,
  t0.smw_subobject AS so,
  t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
  `smw_object_ids` AS t0
INNER JOIN
  (`smw_fpt_inst` AS t2
INNER JOIN
  `smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.o_id='518'
   AND (t4.p_id='519' AND t4.o_id='9488')
  )
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC
LIMIT
  55
OFFSET
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39const,const619Using temporary; Using filesort
1SIMPLEt2refs_id,o_id,s_id_2,o_id_2s_id4callto_wikidb.t4.s_id1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4callto_wikidb.t4.s_id1Using where
Auxilliary Tables
No auxilliary tables used.
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
Phone numberCompanyBusiness categoryLocationE-mailCompany homepage
01252313305GREEN MILE LAWN CARE LIMITEDGarden ServicesFARNBOROUGHhttp://www.greenmilelawncare.co.uk
01252314025SILK SIGNS LIMITEDSign MakersFARNBOROUGH
01252315695SOUTHERN COUNTIES BUILDING SOLUTIONS LTDBuildersFARNBOROUGHhttp://www.scbsltd.co.uk
01252319670SEASONMASTER ALDERSHOT LIMITEDDouble Glazing InstallersFARNBOROUGHsales@seasonmaster.comhttp://www.seasonmaster.com
01252325147SUMNER SECURITY SERVICES LIMITEDSecurity Services & EquipmentFARNBOROUGH
01252330683IMPRINT COLOUR LTDPrinters & LithographersFARNBOROUGHhttp://www.imprintcolour.co.uk
01252333727DEANE AUSTIN ASSOCIATES LLPNoise & Vibration ConsultantsFARNBOROUGHhttp://www.tacitus.co.uk
01252336616CRAIG ALEXANDER ASSOCIATES LTDRecruitment ConsultantsFARNBOROUGHhttp://www.caarecruitment.co.uk
01252337338PSK LIMITEDSecurity Services & EquipmentFARNBOROUGHkevin@psksecurity.co.ukhttp://www.psksecurity.co.uk
01252342365TAURUS WASTE RECYCLING LIMITEDSkip HireFARNBOROUGHhttp://www.taurus-waste.com
01252344007WEL MEDICAL LTDMedical SuppliesFARNBOROUGHhttp://www.welmedical.com
01252350833PEREI GROUP LIMITEDCar Accessories & PartsFARNBOROUGHsales@perei.co.ukhttp://www.perei.co.uk
01252359760A. J. PRODUCTS (UK) LIMITEDOffice Equipment SuppliersFARNBOROUGHhttp://www.ajproducts.co.uk
01252362626PPG CRIMINAL LAW LTDLegal ServicesFARNBOROUGHhttp://www.ppg-solicitors.co.uk
01252362658CASCADE AEROSPACE ENGINEERING LIMITEDEngineersFARNBOROUGH
01252362660RUSHMOOR HEALTHY LIVINGCharitable & Voluntary OrganisationsFARNBOROUGHadmin@rhl.org.ukhttp://www.rushmoorhealthyliving.org.uk
01252370707OSBORNES INDEPENDENT ESTATE AGENTS LIMITEDEstate AgentsFARNBOROUGHinfo@osbornesestateagents.co.ukhttp://www.osbornesestateagents.co.uk
01252370728FAST ACTION SERVICES LIMITEDCommercial CleaningFARNBOROUGHhttp://www.cleankinguk.com
01252371181MEDFOR PRODUCTS LIMITEDLaboratory Facilities & ServicesFARNBOROUGHhttp://www.medfor.co.uk
01252371445PAUL FOOTE INK LIMITEDSign MakersFARNBOROUGHhttp://www.paulfoote.com
01252372140DATA PRODUCT SERVICES LIMITEDComputer ConsultancyFARNBOROUGHhello@dps.uk.comhttp://www.dps.uk.com
01252372222FLOOR24 CARPETS & FLOORING LIMITEDCarpets & Rugs Retail & RepairFARNBOROUGH
01252372422AUTOMATED GATE SOLUTIONS LIMITEDGates & RailingsFARNBOROUGHsales@automatedgatesolutions.co.uk
372422sales@automatedgatesolutions.co.uk
http://www.automatedgatesolutions.co.uk
01252372525SEARCH RECRUITMENT LIMITEDRecruitment ConsultantsFARNBOROUGHhttp://www.searchrecruitment.jobs
01252372605CAD AIR CONDITIONING LIMITEDAir Conditioning ServicesFARNBOROUGHhttp://www.cadairltd.co.uk
01252372717BENCHMARK HOME IMPROVEMENTS LTDDouble Glazing InstallersFARNBOROUGHalastair@benchmarkhomeimprovements.co.ukhttp://www.benchmarkhomeimprovements.co.uk
01252372788INTERNATIONAL JETCLUB LIMITEDAir Charter & RentalFARNBOROUGHhttp://www.jetclub.com
012523737972:09 EVENTS LIMITEDConference & Event ManagementFARNBOROUGHhttp://www.209events.com
01252375013UNITED SILICONES LIMITEDManufacturers' AgentsFARNBOROUGHsales@united-silicones.comhttp://www.united-silicones.com
01252375566DATA TECHNIQUES LIMITEDComputer Networking & CablingFARNBOROUGHhttp://www.datatechniques.co.uk
01252375600FARNBOROUGH AEROSPACE CONSORTIUM LIMITEDAirline Support ServicesFARNBOROUGH
01252376001DIGITAL TACHOGRAPH CENTRE LIMITEDCalibration ServicesFARNBOROUGH
01252377094AUSTIN PHOENIX LIMITEDCommercial Estate AgentsFARNBOROUGHhttp://www.austin-phoenix.com
01252377234FARNBOROUGH AIRCRAFT INTERIORS LIMITEDAircraft ServicesFARNBOROUGHhttp://www.aircraftinteriors.co.uk
01252377403NAMCO AUTOMOTIVE LIMITEDCar Accessories & PartsFARNBOROUGH
01252377519DSA GOLF LPPromotional Items & IncentivesFARNBOROUGHsales@dsagolf.co.ukhttp://www.dsagolf.co.uk
01252377600TECNOLOGIC UK LTDElectronic Systems & SuppliersFARNBOROUGHhttp://www.t-uk.co.uk
01252377677THE ART OF CRAFT LIMITEDArt & Craft ShopsFARNBOROUGHinfo@art-of-craft.co.ukhttp://www.art-of-craft.co.uk
01252377977TAG AVIATION (UK) LIMITEDAir Charter & RentalFARNBOROUGHhttp://www.tagaviation.com
01252412753FLOOR24 CARPETS & FLOORING LIMITEDWood, Timber & Laminate FlooringFARNBOROUGHinfo@floor24.co.ukhttp://www.floor24.co.uk
01252413080ENERGI RECRUITMENT SERVICES LIMITEDRecruitment ConsultantsFARNBOROUGHhttp://www.energi.uk.com
01252413277NEIL FOUNDATIONS SYSTEMS LIMITEDPile DrivingFARNBOROUGHpiling@neilfoundations.co.uk
980piling@neilfoundations.co.uk
http://www.neilfoundations.co.uk
01252415343BAMBOO GARDEN SERVICES LIMITEDGarden ServicesFARNBOROUGH
01252416075ACORN HOMECARE UK LIMITEDHome Care ServicesFARNBOROUGHinfo@acorn-homecare.co.ukhttp://www.acornhomecareuk.co.uk
01252419399STERLING BATHROOMS LTDKitchen Planning & InstallationFARNBOROUGHname@website.comhttp://www.sterlingbathrooms.com/
01252448324BUBBLEGUM BALLOONS LIMITEDParty & Promotional BalloonsFARNBOROUGH20@anna.corohttp://www.bubblegumballoons.co.uk
01252492723COZMIC COSMETIC LIMITEDCar Body RepairsFARNBOROUGHhttp://cozmiccosmetic.co.uk
01252494101SIMEOUS LTDLegal ServicesFARNBOROUGHhttp://www.simeous.com
01252500856MITCHELLWHEELER LIMITEDBuildersFARNBOROUGHhttp://www.mitchellwheeler.co.uk
01252504343SOLGROW LTDShipping & Forwarding AgentsFARNBOROUGHpeterb@solgrow.com
katyr@solgrow.com
http://www.solgrow.com