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::SHEFFIELD]]
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='2621')
  )
  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,const4820Using 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
01134573609AVANT GARDE RESTAURANTS LTDBistrosSHEFFIELDjoebloggs@mrnobody.co.ukhttp://www.mrnobody.co.uk
01138160025AA OFFICE SERVICES LTDBusiness & Industrial RemovalsSHEFFIELDfalling@happyleaves.com
sales@aaofficefurniture.co.uk
http://www.aaofficeservices.co.uk
01138680077CAGED BUTTERFLY LIMITEDTheatrical Services & SuppliesSHEFFIELDhttp://www.cagedbutterfly.co.uk
01138800979LEARNDIRECT CENTRES LIMITEDFurther EducationSHEFFIELDhttp://www.learndirect.co.uk
01138875009AA OFFICE SERVICES LTDPartitioning Services & EquipmentSHEFFIELD
01138878200BLOOM MEDIA (UK) LIMITEDMarketing & Advertising ConsultantsSHEFFIELDhttp://www.bloomagency.co.uk
01142010168REX ELECTRICAL SERVICES LIMITEDElectricians & Electrical ContractorsSHEFFIELDadmin@rexelectrical.co.uk
0168admin@rexelectrical.co.uk
http://www.rexelectrical.co.uk
01142012200PCI SYSTEMS LIMITEDComputer ServicesSHEFFIELDinfo@pcisystems.co.ukhttp://www.pciltd.co.uk
01142013950QUAD COMPUTER SERVICES LTDComputer ServicesSHEFFIELDhttp://www.quad.co.uk
01142014670SIMPLY CLEAN OVENS LIMITEDOven CleaningSHEFFIELDhttp://www.simplyclean-ovens.co.uk
01142015252S.Y.T.G. LIMITEDTraining ServicesSHEFFIELDhttp://www.sytgltd.com
01142018925LEARNING LIGHT LIMITEDTraining ServicesSHEFFIELDhttp://www.learninglight.com
01142055466FOOTPRINT PHOTOGRAPHY LTDAerial Photography & SurveysSHEFFIELDhttp://www.footprintphoto.biz
01142096105GILLFIELD PROJECTS LIMITEDProject Management ServicesSHEFFIELDhttp://www.gillfield.co.uk
01142131640OATES CONSULTANCY LTDManagement & Business ConsultantsSHEFFIELDinfo@oatesconsultancy.comhttp://www.oatesconsultancy.com
01142131750PRINCIPLE SUPPORT LTDHome Care ServicesSHEFFIELDinfo@principlesupportltd.co.ukhttp://www.principlesupportltd.co.uk
01142131919RANDOM ACTS LIMITEDTraining ServicesSHEFFIELD
01142132500MORGAN DIAS IMMIGRATION LIMITEDImmigration AdviceSHEFFIELDhttp://www.morgandias.com
01142132770OSSILA LTDElectronic ComponentsSHEFFIELDhttp://www.ossila.com
01142133322BLUE LIGHT SAFETY LIMITEDFire Protection EngineersSHEFFIELDinfo@bluelightsafety.co.ukhttp://www.bluelightsafety.co.uk
01142133693WORK PERMIT EXPERTS LIMITEDVisa ServicesSHEFFIELDhttp://www.workpermitexperts.co.uk
01142134050PURE PHYSIOTHERAPY LIMITEDPhysiotherapistsSHEFFIELD
01142134646TOTAL LINGUISTICS LTD.Translators & InterpretersSHEFFIELDask@total-linguistics.co.uk
ask@total-linguistics.com
http://www.total-linguistics.com/
01142134951WEALTH MANAGEMENT & GROWTH LIMITEDFinancial AdvisersSHEFFIELDhttp://www.wmgifa.co.uk
01142135003RIGHT MIX CONCRETE LIMITEDConcrete PumpingSHEFFIELDenquiries@right-mix.co.ukhttp://www.right-mix.co.uk
01142135026RIGHT MIX CONCRETE LIMITEDConcrete PumpingSHEFFIELDenquiries@right-mix.co.ukhttp://www.right-mix.co.uk
01142135328MILLHOUSES CONSTRUCTION LTDHealth & Safety ConsultantsSHEFFIELD
01142135355F.W. WALLACE LIMITEDCar Body RepairsSHEFFIELDhttp://www.fwwallace.com
01142138530SERENITI LIMITEDManagement & Business ConsultantsSHEFFIELDhttp://www.sereniti.co.uk
01142180470CHG ELECTRICAL LIMITEDElectrical EngineersSHEFFIELDhttp://www.chgelectrical.co.uk
01142180475LINK2 LIMITEDComputer Software DevelopmentSHEFFIELDhttp://www.link-2.biz
01142193000FIRTH RIXSON LIMITEDEngineersSHEFFIELDcolin.cave@alcoa.com
john.stephenson@alcoa.com
elizabeth.telford@alcoa.com
judit.vincze@alcoa.com
cary.dell@alcoa.com
http://www.firthrixson.com
01142193002FIRTH RIXSON METALS LIMITEDMetalsSHEFFIELDcolin.cave@alcoa.com
john.stephenson@alcoa.com
elizabeth.telford@alcoa.com
judit.vincze@alcoa.com
cary.dell@alcoa.com
http://www.firthrixson.com
01142200894DAVISON PROPERTY INVESTMENTS LTDProperty DevelopmentSHEFFIELDinfo@davisonpi.co.ukhttp://www.davisonpi.co.uk
01142202250DISTINCTIVE DOORS LIMITEDDomestic Door ManufacturersSHEFFIELD
01142202272HEELEY SURGICAL LIMITEDMedical SuppliesSHEFFIELDsales@heeleysurgical.comhttp://www.heeleysurgical.com
01142203678OPEN WATER DREDGING UK LIMITEDMarine Consultants & ServicesSHEFFIELDinfo@openwaterdredging.comhttp://www.openwaterdredging.com
01142203709ALTAVIA HTT LIMITEDPublishers & PublicationsSHEFFIELDhttp://www.altavia-htt.com
01142203777BLUE PORTAL TELECOM LIMITEDTelecommunication ConsultantsSHEFFIELDhttp://www.blueportal.co.uk
01142205554AZW CONSULTING LTDInvestment ConsultantsSHEFFIELDhttp://www.azw.co.uk
01142205602ANDREW LINDLEY ELECTRICAL LIMITEDElectricians & Electrical ContractorsSHEFFIELDhttp://www.a-l-e.co.uk
01142207051KJF ENGINEERING LTDEngineersSHEFFIELD
01142207530DATAMILLS (UK) LTDComputer ConsultancySHEFFIELDinfo@datamills.co.ukhttp://www.datamills.co.uk
01142210205DESQ LIMITEDComputer ServicesSHEFFIELDhttp://www.desq.co.uk
01142210285EQUINOX PUBLISHING LIMITEDPublishers & PublicationsSHEFFIELDhttp://www.equinoxpub.com
01142210378DIVA CREATIVE LIMITEDPublic Relations ConsultantsSHEFFIELD
01142210393LOVEBYTES LIMITEDArts OrganisationsSHEFFIELDhttp://www.lovebytes.co.uk
01142210514PUBLICSPEAKINGACADEMY LIMITEDEducational ServicesSHEFFIELDenquiry@publicspeakingacademy.co.ukhttp://www.publicspeakingacademy.co.uk
01142210540SKILLSLOGIC LTDComputer Software DevelopmentSHEFFIELDinfo@skillslogic.com
support@skillslogic.com
http://www.skillslogic.com
01142210550BENCHMARK RECRUIT LIMITEDRecruitment ConsultantsSHEFFIELDhttp://www.benchmarkrecruit.co.uk