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::BUCKINGHAMSHIRE]]
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='1248')
  )
  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,const552Using 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
01279658393FALCON HOUSE CARE LIMITEDResidential & Retirement HomesBUCKINGHAMSHIREhttp://www.falconhouseresidentialhome.co.uk
01280706832RUSSELL & BUTLER LIMITEDEstate AgentsBUCKINGHAMSHIREhttp://www.russellandbutler.com
01280812180KEYHOLE DATA LIMITEDComputer Software DevelopmentBUCKINGHAMSHIRE
01280815999RUSSELL & BUTLER LIMITEDEstate AgentsBUCKINGHAMSHIREhttp://www.russellandbutler.com
01280847775LANDFRAME PROJECT MANAGEMENT LIMITEDProperty DevelopmentBUCKINGHAMSHIRE
01280860248F & F DAIRY SUPPLIES LIMITEDDairiesBUCKINGHAMSHIRE
01282853377EDEN LIMITEDHairdressersBUCKINGHAMSHIRE
01283760449EDEN LIMITEDHairdressersBUCKINGHAMSHIRE
01295251111BEARING TRADERS LIMITEDBearingsBUCKINGHAMSHIREinfo@bearingtraders.comhttp://www.bearingtraders.com
01296322751KKJ GENERAL SERVICES LTDGarden ServicesBUCKINGHAMSHIREhttp://www.kkjcleaver.co.uk
01296325948ATLAS DIRECT LIMITEDAerial Services & SuppliesBUCKINGHAMSHIREsales@atlas-direct.com
9994243sales@atlas-direct.com
http://www.atlas-direct.com
01296330961KEMPSON ELECTRICAL SERVICES LIMITEDElectricians & Electrical ContractorsBUCKINGHAMSHIREhttp://www.kempsonelectrical.co.uk
01296381200SYTEL LIMITEDComputer Software DevelopmentBUCKINGHAMSHIREinfo@sytel.com
sales@sytelco.com
info@sytelco.com
kenb@sytelco.com
jonathanb@sytelco.com
richardc@sytelco.com
hr@sytelco.com
north.america@sytel.com
support@sytel.com
http://www.sytelco.com
01296381290MJW FENCING LTDFencing ServicesBUCKINGHAMSHIREmjwfencing@btconnect.comhttp://www.mjwfencing.com
01296392808FOXHILL INDOOR BOWLS CLUB LIMITEDSports Clubs & AssociationsBUCKINGHAMSHIREhttp://www.foxhill.org.uk
01296395366LET'S RENT PROPERTIES LTDLetting AgentsBUCKINGHAMSHIREhttp://www.letsrentaylesbury.co.uk
01296399330PERFECT PIPEWORK LIMITEDPipework ContractorsBUCKINGHAMSHIREhttp://www.perfectpipework.co.uk
01296420336E-T-A CIRCUIT BREAKERS LTDElectrical Components & WiringBUCKINGHAMSHIREinfo@remove-this.e-t-a.co.uk
info@remove-this.e-t-a.de
josef.strohmayer@remove-this.e-t-a.at
peter.vollmann@remove-this.e-t-a.at
ingenieria@remove-this.nollmann.com.ar
cn@remove-this.e-t-a.com.cn
info@remove-this.radel.co.za
info@remove-this.e-t-a.com.au
http://www.e-t-a.co.uk
01296422057PINELEIGH CONSULTANTS LIMITEDConsulting EngineersBUCKINGHAMSHIRE
01296432537BEARING TRADERS LIMITEDBearingsBUCKINGHAMSHIREinfo@bearingtraders.comhttp://www.bearingtraders.com
01296433277SKY PERSONNEL LIMITEDRecruitment ConsultantsBUCKINGHAMSHIREenquiries@skypersonnel.co.ukhttp://www.skypersonnel.co.uk
01296433754NYLON COLOURS LIMITEDPaint, Varnish & LacquerBUCKINGHAMSHIREsales@nyloncolours.co.ukhttp://www.nyloncolours.co.uk
01296434445STEVE PITCHER LIMITEDGas InstallersBUCKINGHAMSHIRE
01296434731FRIARS MANAGEMENT LIMITEDMusic Management & PromotionBUCKINGHAMSHIREinfo@fmlmusic.comhttp://www.fmlmusic.com
01296437111HARDMETAL TECHNOLOGY LIMITEDPrecision EngineersBUCKINGHAMSHIREoffice@hardtechltd.co.ukhttp://www.hardtechltd.co.uk
01296486391INTERNATIONAL SHELVING SERVICES LIMITEDShelving, Racking & Storage ProductsBUCKINGHAMSHIRE
01296489190ROMEO TRAVEL LIMITEDTravel Agents & ServicesBUCKINGHAMSHIRE
01296489250D N R HAIR DESIGNS LIMITEDHairdressersBUCKINGHAMSHIRE
01296612201VALE TRAINING SERVICES LIMITEDTraining ServicesBUCKINGHAMSHIREhttp://www.valetrainingservices.co.uk
01296620768DOVE NETWORKS LIMITEDComputer ServicesBUCKINGHAMSHIREhttp://www.dovenetworks.ltd.uk
01296624924ROBERT WALLBANK ASSOCIATES LIMITEDConsulting EngineersBUCKINGHAMSHIREengineer@rwaconsulting.co.ukhttp://www.rwaconsulting.co.uk
01296628180NEESHAM PUBLIC RELATIONS LIMITEDPublic Relations ConsultantsBUCKINGHAMSHIREinfo@neesham.co.ukhttp://www.neesham.co.uk
01296630124CIRCUIT FIX LTDElectricians & Electrical ContractorsBUCKINGHAMSHIREhttp://www.electricianaylesbury.com
01296641868STEPHEN BAKER FINANCIAL CONSULTANTS LIMITEDFinancial AdvisersBUCKINGHAMSHIREinfo@sbfinancial.co.ukhttp://www.sbfinancial.co.uk
01296641928KAW SERVICES LTDComputer Networking & CablingBUCKINGHAMSHIREadam@kaw-services.co.ukhttp://www.kaw-services.co.uk
01296655999ON YER BIKE LIMITEDMotorcycle & Scooter DealersBUCKINGHAMSHIREhttp://www.onyerbike.net
01296658422B S MOTORSPORT LIMITEDMotor SportsBUCKINGHAMSHIREwebmaster@racecar.co.uk
info@bsmotorsport.co.uk
http://www.bsmotorsport.co.uk
01296681313ASPEN MEDIA LIMITEDAudio-visual EquipmentBUCKINGHAMSHIREhttp://www.aspen-media.com
01296682878MECATECH UK LIMITEDCar Accessories & PartsBUCKINGHAMSHIREenquiries@mecatech.co.ukhttp://www.mecatech.co.uk
01296712364M.R.M. GRAPHICS LIMITEDPrinters & LithographersBUCKINGHAMSHIREkeith@mrmgraphics.co.uk
lees@mrmgraphics.co.uk
stuart@mrmgraphics.co.uk
http://www.mrmgraphics.co.uk
01296713310SOUTHERN CERAMIC SUPPLIES LIMITEDFire Protection EngineersBUCKINGHAMSHIREsales@ceramicglass.co.ukhttp://www.ceramicglass.co.uk
01296720255JH BONHAM & SON LIMITEDRoad Haulage ServicesBUCKINGHAMSHIRE
01296720256SWANBOURNE HOME FARMSFarmersBUCKINGHAMSHIRE
01296730556LIME TREE COURT LIMITEDResidential & Retirement HomesBUCKINGHAMSHIREhttp://www.limetreecourt.co.uk
01296747057GOLLINS CONTRACTORS LIMITEDAgricultural ContractorsBUCKINGHAMSHIRE
01296747274GLEBE ELECTRICAL INSTALLATIONS LIMITEDElectricians & Electrical ContractorsBUCKINGHAMSHIRE
01296770970FISHER PLANT HIRE LIMITEDPlant & Machinery HireBUCKINGHAMSHIRE
0129823114PAVILION GARDENS LTDTourist AttractionsBUCKINGHAMSHIREpaviliongardens@highpeak.gov.uk
23114paviliongardens@highpeak.gov.uk
http://www.paviliongardens.co.uk
01299827061ALL OCCASIONS LTDLadies Clothes ShopsBUCKINGHAMSHIRE
01312203372EDEN LIMITEDGift ShopsBUCKINGHAMSHIRE