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:category::Builders]]
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='524' AND t4.o_id='695')
  )
  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,const26544Using 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
01132862238CHRISLIND SERVICES LIMITEDBuildersLITTLE PRESTON
01132866955WHEATLEY CONSTRUCTION LIMITEDBuildersLONDONhttp://www.wheatleyconstruction.com
01132867220SUREBUILD CONSTRUCTION LIMITEDBuildersASHTON-UNDER-LYNEhttp://www.surebuildconstruction.co.uk
01132873359BARROWBY CONSTRUCTION LIMITEDBuildersLEEDS
01132874455MCINERNEY HOMES LIMITEDBuildersMANCHESTERhttp://www.mcinerneyhomes.com
01132878860BALFOUR BEATTY CONSTRUCTION NORTHERN LIMITEDBuildersLONDONveena.hudson@balfourbeatty.com
tracksupplies@bbrail.com
shareholder.services@capita.co.uk
peter.h.young@balfourbeatty.com
pressoffice@balfourbeatty.com
info@balfourbeatty.com
emergingtalent@balfourbeatty.com
momrod@bbcgrp.com
vivienne.dunn@balfourbeatty.com
http://www.balfourbeatty.com
01132892526MAKIN BUILDERS LIMITEDBuildersDERBYSHIRE
01132941589MARTIN MULLEN BUILDING CONTRACTORS LIMITEDBuildersLEEDS
01133201970CASTLES SPECIAL PROJECTS LIMITEDBuildersMEXBOROUGHinfo@castlesllp.co.uk
vcard@castlesllp.co.uk
http://www.castlesllp.co.uk
01133227718C D ROE BUILDERS LIMITEDBuildersWETHERBYcolin@cdroe.co.ukhttp://www.cdroebuilders.co.uk
01133505564NORTHERN BRICKWORK LTDBuildersMANCHESTERhttp://www.northernbrickwork.com
01133571100STONEBRIDGE PROJECTS LIMITEDBuildersLEEDShttp://www.stonebridgehomes.co.uk
01133807860TRAD SAFETY SYSTEMS LIMITEDBuildersBROMLEYhttp://www.trad-safety-systems.co.uk
01133853850LNT GROUP LIMITEDBuildersGARFORTH LEEDShttp://www.lntgroup.co.uk
01133854609ASHTREE FINE DEVELOPMENTS LTDBuildersLEEDSinfo@ashtreefinedevelopments.co.ukhttp://www.ashtreefinedevelopments.co.uk
01133918220MARLBOROUGH BRICKWORK LIMITEDBuildersWEST YORKSHIREhttp://www.thinkmarlborough.com
01134147957CLEARWATER CONSTRUCTION LIMITEDBuildersESSEXhttp://www.clearwaterconstruction.co.uk
01138152181KORENDON CONSTRUCTION UK LTDBuildersLEEDSinfo@korendon.co.ukhttp://www.korendon.co.uk
01138187840RIVA HOMES LIMITEDBuildersLONDONhttp://www.rivahomes.co.uk
01138875045M D CONSTRUCTION (BRADFORD) LIMITEDBuildersBRADFORDinfo@md-construction.co.ukhttp://www.md-construction.co.uk?utm source=yell&utm medium=referral&utm campaign=yell
01138875328ATKINSON BUILDERS LTDBuildersPICKERINGleonard.atkinson@btconnect.com
philip.atkinsonllp@btconnect.com
http://www.atkinsonbuildersleeds.co.uk
01138878886KRAFTWORK CONTRACT SOLUTIONS LTDBuildersLEEDShttp://www.kraftworksolutions.com
01138879629KESTREL PROPERTY SERVICES LIMITEDBuildersLEEDSinfo@kestrel-builders.co.ukhttp://www.kestrel-builders.co.uk
01142010114BRICKWORK SERVICES LIMITEDBuildersHARTLEPOOL
01142013472ADVANTAGE PROJECTS LIMITEDBuildersALTRINCHAM
01142134460SIMPLICITY CONSTRUCTION LTD.BuildersSHEFFILEDhttp://www.simplicity-construction.co.uk
01142219996SM CONSTRUCTION LTDBuildersSHEFFIELDhttp://www.smcontruct.co.uk
01142312304R C BUILDING SERVICES LTDBuildersBOLTON
01142314721H M BUILDERS LTDBuildersILFORD
01142333511ASK COMPLETE BUILDING SERVICES LIMITEDBuildersSHEFFIELDinfo@askbuilders.co.ukhttp://www.askbuilders.com
01142335076IBN BUILDING & JOINERY LIMITEDBuildersSHEFFIELDhttp://www.i-b-n.com
01142341607BARDEN & HALL LIMITEDBuildersbardenandhall@hotmail.co.ukhttp://www.bardenandhall.co.uk
01142352225F J F CONSTRUCTION LIMITEDBuildersinfo@fjfconstruction.co.ukhttp://www.fjfhomes.com
01142353314M WOOLHOUSE BUILDERS LIMITEDBuildersSHEFFIELDhttp://www.mwoolhousebuilders.com
01142353339RICHARDSON BUILDERS LIMITEDBuildersSHEFFIELDmarkrich1@yahoo.comhttp://www.richardsonbuilders-sheffield.co.uk
01142378385LELECTRICAL LTDBuildersBOURNEMOUTHhttp://www.churchltd.wordpress.com
01142400388SHEPWORTH CONSTRUCTION LIMITEDBuildersSHEFFIELDhttp://www.shepworthconstruction.co.uk
01142401522NEWAYS LTDBuildersCHELTENHAMinfo@newayspropertycare.co.ukhttp://www.newayspropertycare.co.uk
01142403000BDB DESIGN BUILD LIMITEDBuildersSHEFFIELDadmin@bdbdesignbuild.co.uk
admin@bdb.co.uk
http://www.bdbdesignbuild.co.uk
01142433806RICHMOND CONSTRUCTION LIMITEDBuildersSOUTH YORKSHIRE
01142447059BLACKTHORNE BUILDING & DESIGN LTDBuildersSHEFFIELDhttp://www.blackthornebuildingdesign.co.uk
01142458048A & S CONSTRUCTION LTDBuildersLONDON
01142462221H P CONSTRUCTION LIMITEDBuildersSHEFFIELDhttp://www.hpconstruction.co.uk
01142462950LSM BUILDERS LTDBuildersSHEFFIELDadmin@lsmbuilders.co.ukhttp://www.lsmbuilders.co.uk
01142479100S. & A. PARSONS (BUILDING CONTRACTORS) LIMITEDBuildersSHEFFIELD
01142479699ASHTON BUILDING SERVICES LIMITEDBuildersGLASGOW
01142480055DENDALE LIMITEDBuildersSHEFFIELDinfo@dendale.comhttp://www.dendale.com
01142484876P. & J. CONTRACTORS LIMITEDBuildersWEST SUSSEX
01142487500G S BUILDERS LTDBuildersHAYES
01142500622GRAHAM STUART CONSTRUCTION LIMITEDBuildersS YORKSHIREhttp://www.grahamstuart.co.uk