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::ALCESTER]]
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='1083')
  )
  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,const200Using 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
 Companies:company nameCompanies:categoryCompanies:townCompanies:emailCompanies:homepageCompanies:phone
01527893133REAL IDEAS CONSULTANCY LIMITEDMarketing & Advertising ConsultantsALCESTER01527893133
01527893220D B SPRINGS LIMITEDPest & Vermin Control SuppliesALCESTERhttp://www.fenntraps.co.uk01527893220
01527913972ROSSANO BENNETT GRAPHICS LIMITEDSign MakersALCESTERrossbenn2@btconnect.comhttp://www.exhibitiongraphics.uk.com01527913972
01563537388ROBERT SMITH ASSOCIATES LIMITEDCoaching & MentoringALCESTER01563537388
01564795959MILLER HUGHES CONSTRUCTION LTDBuildersALCESTERinfo@millerhughes.co.ukhttp://www.millerhughes.co.uk01564795959
01564796640OFFICE IMPRESSIONS LIMITEDPrinters' SuppliesALCESTERhttp://www.officeimpressions.co.uk01564796640
01600890325SPRINGMAKERS (REDDITCH) LIMITEDSprings & Shock AbsorbersALCESTER01600890325
01604644400VALE ENGINEERING LTDPrecision EngineersALCESTERsales@valeengineering.co.ukhttp://www.valeengineering.co.uk01604644400
01631564513VALE ENGINEERING LTDEngineersALCESTER01631564513
01691690287CONTRACT SERVICES LIMITEDQuantity SurveyorsALCESTER01691690287
01702309621REVIVE INTERIORS LIMITEDInterior DesignersALCESTER01702309621
01709879940M-TEC LIMITEDCar ElectricsALCESTER01709879940
01745797924LA GALLERIA LTDCafes & Coffee ShopsALCESTER01745797924
01763273296SHARPE PRINT LTDPrinters & LithographersALCESTERsales@sharpeprint.co.ukhttp://www.sharpeprint.co.uk01763273296
01782324454THE SMITH PARTNERSHIP LIMITEDSolicitorsALCESTERinfo@smithpartnership.co.uk
claire.twells@smithpartnership.co.uk
businessdevelopmentgroup@smithpartnership.co.uk
http://www.smithpartnership.co.uk01782324454
01785223913JOHN CHIVERS COMMERCIAL LIMITEDSurveyors & ValuersALCESTERhttp://www.chiverscommercial.co.uk01785223913
01789290626PROCO COATINGS & LAMINATES LIMITEDPaper & BoardALCESTER01789290626
01789295283GOLDHILL CONTRACTING LIMITEDCommercial CleaningALCESTERinfo@goldhillcontracting.co.ukhttp://www.goldhillcontracting.co.uk01789295283
01789330025INDUSTRIALMACHINES.NET LIMITEDPlant & Machinery DealersALCESTERsales@printandfinish.comt
sales@printandfinish.com
sales@printandfinish.comc
lily.zhao@jinnoc.com
http://www.IndustrialMachines.net01789330025
01789334087PLATO CATERING HIRE LIMITEDCatering Equipment HireALCESTERhttp://www.platohire.co.uk01789334087
01789334577PETER BARBER PLUMBING & HEATING LIMITEDPlumbersALCESTERinfo@pbarberplumbingandheating.co.ukhttp://www.pbarberplumbingandheating.co.uk01789334577
01789334716STEELFAST LIMITEDSteel StockholdersALCESTERinfo@steelfast.net
steve@steelfast.net
http://www.steelfast.co.uk/01789334716
01789334783STEWARTS MOT & REPAIR CENTRE LTDMot TestingALCESTERhttp://www.stewartsmot.co.uk/01789334783
01789387800BUZZEASY LIMITEDComputer Software DevelopmentALCESTERhttp://www.buzzeasy.com01789387800
01789400013ASTON ENVIRONMENTAL SERVICES LIMITEDWater TreatmentALCESTERhttp://www.astonenvironmental.co.uk01789400013
01789400031UK TOYS LIMITEDToy & Game WholesalersALCESTERhttp://www.toyzworld.co.uk01789400031
01789400044GREENMECH LIMITEDForestry ServicesALCESTERhttp://www.greenmech.co.uk01789400044
01789400077BLISSHOME LIMITEDFancy GoodsALCESTER01789400077
01789400137ARDEN CONSTRUCTION LIMITEDBuildersALCESTERenquiries@ardenconstruction.co.ukhttp://www.ardenconstruction.co.uk01789400137
01789400152LINDA ROSE LINGERIE LIMITEDLingerieALCESTER01789400152
01789400401CAL GAVIN LIMITEDIndustrial HeatingALCESTERhttp://www.calgavin.com01789400401
01789400428IDC AUDIO VISUAL LTDAudio-visual EquipmentALCESTERhttp://www.idc-audiovisual.co.uk01789400428
01789400446MINERVA MILL INNOVATION CENTRE LIMITEDOffice RentalALCESTERinfo@minervamill.co.ukhttp://www.minervamill.co.uk01789400446
01789400488IBO CONSTRUCTION LIMITEDBuildersALCESTERinfo@iboconstruction.co.ukhttp://www.iboconstruction.co.uk/index.php01789400488
01789400848ARROW CAR SERVICES LIMITEDMot TestingALCESTERarrowcommercial@hotmail.co.ukhttp://www.arrowcarsalesltd.co.uk01789400848
01789458009FOUR SHIRES CONTRACTING LIMITEDBuildersALCESTERhttp://www.fourshirescontracting.co.uk01789458009
01789488208LINFOOT COUNTRY HOMES LIMITEDProperty DevelopmentALCESTERhttp://www.linfoothomes.co.uk01789488208
01789488402ROBERT SMITH ASSOCIATES LIMITEDStructural EngineersALCESTER01789488402
01789490000FULCRO ENGINEERING SERVICES LIMITEDComputer Aided Design ServicesALCESTERinfo@fulcro.co.ukhttp://www.fulcro.co.uk01789490000
01789490233RHYTHM RECORDING SERVICES LIMITEDSound Recording ServicesALCESTERhttp://www.rhythmstudios.co.uk01789490233
01789490280ROSE HAMSON FLOWERS LIMITEDFloristsALCESTERhttp://www.rosehamsonflowers.co.uk01789490280
01789490591WARWICK DESIGN CONSULTANTS LIMITEDDesign ConsultantsALCESTERhttp://www.warwickdesign.com01789490591
01789491000STEELFAST LIMITEDSteel StockholdersALCESTERsteve@steelfast.nethttp://www.steelfast.net01789491000
01789491110SLANT RIGGS LIMITEDEmbroidery ServicesALCESTERsales@slantriggs.co.ukhttp://www.slantriggs.com01789491110
01789491133PLATO CATERING HIRE LIMITEDCatering Equipment HireALCESTERsales@platohire.co.ukhttp://www.platohire.com01789491133
01789491144CONVERGING SOLUTIONS LIMITEDConveyor Systems & BeltingALCESTERhttp://www.convergingsolutions.co.uk01789491144
01789491233JEWELL PODIATRY LIMITEDChiropodists & PodiatristsALCESTER01789491233
01789508188GT FLOORING & FURNISHINGS LTDFlooring MaterialsALCESTER01789508188
01789508283JR ADMIN ASSIST LTDSecretarial ServicesALCESTERinfo@jradminassist.co.ukhttp://www.jradminassist.co.uk01789508283
01789601824ATTOLLO CONSTRUCTION LTDBuildersALCESTERhttp://www.attolloconstruction.co.u01789601824