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::Plant & Machinery Hire]]
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='1254')
  )
  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_id5const1608Using where; Using 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
01202822398J. BASCOMBE CONTRACTORS LIMITEDPlant & Machinery HireWIMBORNEbascombecontractors@uk2k.comhttp://www.bascombecontractors.co.uk
01202822842GUY'S PLANT HIRE LIMITEDPlant & Machinery HireWIMBORNEguysplant@hotmail.co.ukhttp://guysplanthire.co.uk
01202823895SELWOOD LTDPlant & Machinery HireEASTLEIGHhttp://www.selwood.co.uk
01202824766CUTLER BROS. LTD.Plant & Machinery HireWIMBORNE
01202907682J. BASCOMBE CONTRACTORS LIMITEDPlant & Machinery HireWIMBORNE
01204371144TORRENT TRACKSIDE LIMITEDPlant & Machinery HireOTLEY ROAD HARROGATEmail@torrent.co.ukhttp://www.torrent.co.uk
01204667358FYLDE CONTRACTORS LIMITEDPlant & Machinery HireBLACKPOOL
01206250558HIRE STATION LIMITEDPlant & Machinery HireOTLEY ROAD HARROGATEhttp://www.hirestation.com
01206255221M & M GRABHIRE SERVICES LIMITEDPlant & Machinery HireKELVENDONhttp://www.mandmgrabhireservicesltd.co.uk
01206582901F L B PLANT HIRE LIMITEDPlant & Machinery HireCOLCHESTERlewin768@btinternet.comhttp://www.planthirecolchester.com
01206584182WORMELL PLANT HIRE LIMITEDPlant & Machinery HireSAXMUNDHAMwormellplant@aol.co.ukhttp://wormellplanthire.com
01206823448SIBBONS (ALRESFORD) LIMITEDPlant & Machinery HireIPSWICHsales@sibbons.co.ukhttp://www.sibbons.co.uk
01206866222GAP GROUP LIMITEDPlant & Machinery HireGATESHEADhttp://www.gap-group.co.uk
0120874187MACSALVORS (PLANT HIRE) LIMITEDPlant & Machinery HireCORNWALLhttp://www.macsalvors-towbars.co.uk
01209831584MICHAEL MUDGE LIMITEDPlant & Machinery HireCORNWALL
01209843413JOHN WICKS PLANT HIRE LIMITEDPlant & Machinery HireREDRUTH
01213258686CHARLES WILSON ENGINEERS LIMITEDPlant & Machinery HireST ALBANShttp://www.cwplant.co.uk/location/birmingham
01213281100R. SAVAGE PLANT HIRE CO. LIMITEDPlant & Machinery HireBIRMINGHAMhttp://www.savageplanthire.co.uk
01213604161VHS PLANT HIRE LIMITEDPlant & Machinery HireBIRMINGHAMhttp://www.vhsplanthire.co.uk
01213827111CASTLEGATE UK LIMITEDPlant & Machinery HireSUTTON COLDFIELDinfo@castlegateuk.co.ukhttp://www.castlegateuk.co.uk
01215025583MATTS GRAB HIRE LIMITEDPlant & Machinery HireHAGLEY
01215222142SELWOOD LTDPlant & Machinery HireEASTLEIGHinfo@selwood.co.ukhttp://www.selwoodgroup.co.uk
01216618712ST. CLEMENTS PLANT LIMITEDPlant & Machinery HireBIRMINGHAMstclementsplant@btconnect.comhttp://stclementsplanthire.co.uk
01217077566TERRY & THOMAS CONSTRUCTION LIMITEDPlant & Machinery HireBIRMINGHAM
01223424676NEWMARKET PLANT HIRE LIMITEDPlant & Machinery HireSUFFOLKenquiries@nphgroup.co.ukhttp://www.newmarketplant.co.uk
01223855332H. E. SERVICES (PLANT HIRE) LTDPlant & Machinery HireROCHESTERhttp://www.heservices.co.uk
01224455498EMCO SERVICES LIMITEDPlant & Machinery HireELLONinfo@emcoservices.co.ukhttp://www.emcoservices.co.uk
01224687006GAP GROUP LIMITEDPlant & Machinery HireGATESHEADhttp://www.gap-group.co.uk
01224723803MARWOOD GROUP LIMITEDPlant & Machinery HireLONDONhttp://www.marwoodgroup.co.uk
01224782601PALMARIS PLANT HIRE LIMITEDPlant & Machinery HireCOATBRIDGEhttp://www.palmaris-services.com
01224790900ABERCLEAN PLANT & SWEEPER HIRE LIMITEDPlant & Machinery HireWESTHILLinfo@aberclean.comhttp://www.aberclean.com
01224823424BUCKHURST PLANT HIRE LIMITEDPlant & Machinery HireBOLTONinfo@buckhurstplanthire.co.uk
leeds@buckhurstplanthire.co.uk
scotland@buckhurstplanthire.co.uk
info@bphsp.com
leeds@bphsp.com
scotland@bphsp.com
http://www.bphsp.com
01226734100WORDSWORTH CRUSHING LIMITEDPlant & Machinery HireBARNSLEY
01226763874PICKFORD CONTRACTING LIMITEDPlant & Machinery HireSHEFFIELDhttp://www.pickfordcontracting.co.uk
01227761279BLEAN MACHINE HIRE LIMITEDPlant & Machinery HireWHITSTABLE
01228523374R HARRISON LTDPlant & Machinery HireNOTTINGHAM
01228597281A PLANT LTDPlant & Machinery HireHALIFAXinfo@aplant.com
enquiries@aplant.com
aplanttraining@aplant.com
press@aplant.com
http://www.aplant.com
01228674717ALAN TUER LIMITEDPlant & Machinery HireCARLISLEhttp://www.alantuerltd.co.uk
01228810810GAP GROUP LIMITEDPlant & Machinery HireGATESHEADhttp://www.gap-group.co.uk
01229465665RAWLINSON CONTRACTORS LIMITEDPlant & Machinery HireULVERSTON
01229813428THE NEIL MARTIN GROUP LIMITEDPlant & Machinery HireMANCHESTERhttp://www.theneilmartingroup.co.uk
01229830369MARSH PLANT HIRE LIMITEDPlant & Machinery HireHAVANT
01229861475LUSCOMBE PLANT HIRE LIMITEDPlant & Machinery HireULVERSTONhttp://www.luscombeplanthire.co.uk
01233639831H. E. SERVICES (PLANT HIRE) LTDPlant & Machinery HireROCHESTERhttp://www.heservices.co.uk
01233860647I.G. PILCHER LIMITEDPlant & Machinery HireASHFORD
01234376532WHITMORE PLANT LIMITEDPlant & Machinery HireBEDFORD
01234750047SHINER PLANT HIRE LIMITEDPlant & Machinery HireMARSTON MORETAINEhttp://www.diggersforhire.co.uk
01234781882SPECIALIST PLANT ASSOCIATES LIMITEDPlant & Machinery HireORSETThttp://www.specialistplant.co.uk/?utm source=yell&utm medium=referral&utm campaign=yell
01235523107JD WRIGHT LTDPlant & Machinery HireOAKHAM
01235769984K & B CRUSHERS LTDPlant & Machinery HirePORTSMOUTHhttp://www.kandbcrushers.co.uk