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::Industrial Protective Clothing]]
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='16824')
  )
  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_id5const164Using 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
01283225503CARTERS CONSUMABLES LIMITEDIndustrial Protective ClothingBOLTONhttp://www.cartersconsumablesltd.com
01293525955GREENHAM LTDIndustrial Protective ClothingMARPLEhttp://www.greenham.com
01304842030MAIN MAN SUPPLIES LIMITEDIndustrial Protective ClothingCRADLEY HEATHhttp://www.mmsgroup.co.uk
01324474744LION SAFETY LIMITEDIndustrial Protective ClothingGRANGEMOUTHsales@lionsafety.co.uk
info@lionsafety.co.uk
http://www.lionsafety.co.uk
01324489136C.T.S. (GRANGEMOUTH) LIMITEDIndustrial Protective ClothingSTIRLINGSHIREmilesw@lineone.nethttp://www.cts-limited.com
01327702104REDBACKS CUSHIONING LTDIndustrial Protective ClothingDAVENTRYinfo@redbackscushioning.comhttp://www.redbackscushioning.com
01332298988DERBY UNITEX LIMITEDIndustrial Protective ClothingDERBYhttp://www.derbyunitex.com
01332874797ABURNET LIMITEDIndustrial Protective ClothingILKESTONinfo@aburnet.co.ukhttp://www.aburnet.co.uk
01349854050S E R SUPPLIES LIMITEDIndustrial Protective ClothingINVERNESSinfo@sersupplies.co.ukhttp://www.sersupplies.co.uk
01355238161CORSTON SINCLAIR LIMITEDIndustrial Protective ClothingEAST KILBRIDE
01382203111DP&L GROUP LIMITEDIndustrial Protective ClothingDUNDEE
01384411101MAIN MAN SUPPLIES LIMITEDIndustrial Protective ClothingCRADLEY HEATHhttp://www.mainmanshop.co.uk
01392288900PARKER MERCHANTING LIMITEDIndustrial Protective ClothingSHELDONdevelopment@neweysonline.co.uk
pminternetsales@parkermerchanting.co.uk
http://www.parker-direct.com
01412377472WORKLINE SAFETY LTD.Industrial Protective ClothingGLASGOWhttp://www.worklinesafety.co.uk
01430478140LAKELAND INDUSTRIES EUROPE LIMITEDIndustrial Protective ClothingBROUGHhttp://www.lakeland.com
01442248797MICROLIN COOPER LTDIndustrial Protective ClothingHEMEL HEMPSTEADsales@microlincooper.co.ukhttp://www.microlincooper.co.uk
01444232579BLACKBURN SAFETYWEAR LTDIndustrial Protective ClothingHAYWARDS HEATHinfo@blackburnsafetywear.co.ukhttp://www.blackburnsafetywear.co.uk
01452709004ANDREW BIRD HEARING LTDIndustrial Protective ClothingCHELTENHAMhttp://www.andrewbirdindustrial.co.uk
01457237300MAJIC MERCHANTS LIMITEDIndustrial Protective ClothingBUXTONhttp://www.majicmerchants.co.uk
01461202452ALPHA SOLWAY LIMITEDIndustrial Protective ClothingLERWICKsales@alphasolway.com
sales@alphasolway.comt
http://www.alphasolway.com
01472314000ICF LPIndustrial Protective ClothingGLASGOWhttp://www.icfgrimsby.co.uk
01482223745I. W. S. LIMITEDIndustrial Protective ClothingPRESTON
01482625444ANSELL MICROGARD LIMITEDIndustrial Protective ClothingWILLERBYhttp://www.microgard.com
01482679600PROGARM LIMITEDIndustrial Protective ClothingBROUGHhttp://www.progarm.ue
01482795770R & C COMPONENTS LIMITEDIndustrial Protective ClothingEAST YORKSHIREinfo@randccomponents.co.ukhttp://randccomponents.co.uk
01493802257KIRKLANDS LIMITEDIndustrial Protective ClothingNORWICH
01494417229PPEKIT LIMITEDIndustrial Protective ClothingMOOR PARKhttp://ppekit.co.uk
01514272868TRANSAL LTDIndustrial Protective ClothingBLACKBURN
01530279996SCILABUB LIMITEDIndustrial Protective ClothingMEASHAMhttp://www.scilabub.com
01543417146U GROUP S.R.L.Industrial Protective ClothingPARUZZAROhttp://www.u-power.it
01543466655ELITE WORKWEAR LIMITEDIndustrial Protective ClothingRUGBYsales@eliteworkwear.co.ukhttp://www.eliteworkwear.co.uk
01580891300ACE INDUSTRIAL SUPPLIES LIMITEDIndustrial Protective ClothingTONBRIDGEsales@aceindustrial.co.ukhttp://www.aceindustrial.co.uk
01592630450SEAHAWK APPAREL LIMITEDIndustrial Protective ClothingDUNFERMLINE
01592657457STRATHALLAN SAFETY LLPIndustrial Protective ClothingKINROSSsales@strathallansafety.comhttp://www.strathallansafety.com
01603628891D.D. HEALTH & SAFETY SUPPLIES LIMITEDIndustrial Protective ClothingNORWICHsales@ddhss.co.ukhttp://ddhss.co.uk
01606882386INDUSTRIAL HOLDINGS LTDIndustrial Protective ClothingGILFORD
01614569873DSM HEALTHCARE LTDIndustrial Protective ClothingREIGATE
01619451333LONGWORTH LTDIndustrial Protective ClothingMANCHESTERinfo@longworth.co.ukhttp://www.longworth.co.uk
01634253487SUNDRIDGE HOLDINGS LIMITEDIndustrial Protective ClothingROCHESTERhttp://www.sundridge.co.uk
01634711122GREENHAM LTDIndustrial Protective ClothingMARPLEhttp://www.greenham.com
01634719422CRITICAL ENVIRONMENT SOLUTIONS LTDIndustrial Protective ClothingSWINDONhttp://www.criticalenvironmentsolutions.co.uk
01639813878PARKER MERCHANTING LIMITEDIndustrial Protective ClothingSHELDONhttp://www.parker-mechanting.com
01642608608GREENHAM LTDIndustrial Protective ClothingMARPLEhttp://www.greenham.com
01642769111M.I. SUPPLIES LIMITEDIndustrial Protective ClothingSTOCKTON-ON-TEEShttp://www.misupplies.co.uk
01652635023SOUTH HUMBERSIDE INDUSTRIAL SUPPLIES LIMITEDIndustrial Protective Clothingsales@shisupplies.co.ukhttp://www.shisupplies.co.uk
01695720241NEWTON SAFETY PRODUCTS LIMITEDIndustrial Protective ClothingLANCASHIRE
01698810761GREENHAM LTDIndustrial Protective ClothingMARPLEhttp://www.greenham.com
01702746363BRITANNIA SAFETY LIMITEDIndustrial Protective ClothingSOUTHEND-ON-SEAbritanniasafety@hotmail.comhttp://www.britsafe.limited
01708381499SAFETY INDUSTRIES (OAKWOOD) LIMITEDIndustrial Protective ClothingROMFORDwebmaster@safetyindustries.comhttp://www.safetyindustries.co.uk
01726742642CORNISH INDUSTRIAL SUPPLIES LTDIndustrial Protective ClothingST. AUSTELL