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::Camping & Outdoor Equipment]]
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='10672')
  )
  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_id5const508Using 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
01227207385BLACKS LIMITEDCamping & Outdoor EquipmentLONDONcustomercare@blacks.co.uk
customerchampions@jdplc.com
http://www.blacks.co.uk
01227266020MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01227766818MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDONcareers@mountainwarehouse.com
jobs@mountainwarehouse.com
http://www.mountainwarehouse.com
01228527504VIKING TRADING LIMITEDCamping & Outdoor EquipmentNOTTINGHAM
01228536818MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01233626004MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01233659038TOG 24 LIMITEDCamping & Outdoor EquipmentHECKMONDWIKEmailorder@tog24.com
returns@tog24.com
tog24@tog24.com
michaelwood@tog24.com
http://www.tog24.com
01234351006WOODLAND WAYS LIMITEDCamping & Outdoor EquipmentMATLOCKhttp://www.woodland-ways.co.uk
01236440702MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01237429100MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDONcareers@mountainwarehouse.com
jobs@mountainwarehouse.com
http://www.mountainwarehouse.com
01239613287POPPIT CAMPERS LTDCamping & Outdoor EquipmentCRYMYCHsales@poppitcampers.co.ukhttp://www.poppitcampers.co.uk
01239652800TEIFI VALLEY CAMPING PODS LIMITEDCamping & Outdoor EquipmentCARMARTHENhttp://www.teifivalleycampingpods.co.uk
01241871797BASECAMP LTDCamping & Outdoor EquipmentLLANBERIShttp://www.basecamparbroath.com
01242501008MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01242509855BLACKS LIMITEDCamping & Outdoor EquipmentLONDONcustomercare@blacks.co.uk
customerchampions@jdplc.com
http://www.blacks.co.uk
01242674477CLEEVE OUTDOORS LIMITEDCamping & Outdoor EquipmentCHELTENHAMhello@cleeveoutdoors.co.ukhttp://www.cleeveoutdoors.co.uk
01243216627BLACKS LIMITEDCamping & Outdoor EquipmentLONDONcustomercare@blacks.co.uk
customerchampions@jdplc.com
http://www.blacks.co.uk
01243380058MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01243528882D.W. CAMPING LIMITEDCamping & Outdoor EquipmentEMSWORTHhttp://www.dwcamping.co.uk
01244564337MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01245262999MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDONcareers@mountainwarehouse.com
jobs@mountainwarehouse.com
http://www.mountainwarehouse.com
01245329933SUNNCAMP LIMITEDCamping & Outdoor EquipmentBRENTWOODhttp://www.sunncamp.co.uk
01246415040CORE CLIMBING LTDCamping & Outdoor EquipmentDRONFIELDhttp://www.coreclimbing.co.uk
01246559072YEOMANS OUTDOORS LIMITEDCamping & Outdoor EquipmentSHIREBROOKhttp://www.yeomansoutdoors.co.uk
01248667263MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01249472533MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01252316649CAMPING & LEISURE WORLD LIMITEDCamping & Outdoor EquipmentALDERSHOThttp://www.campingworld.co.uk
01252342788H.M. SUPPLIES LIMITEDCamping & Outdoor EquipmentSURREYmilitary@hmsupplies.comhttp://www.hmsupplies.com
01252418419MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01252418563MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01252724347BREAKING FREE LIMITEDCamping & Outdoor EquipmentFARNHAMhttp://www.breakingfree.co.uk
01252795293CAMPING & LEISURE WORLD LIMITEDCamping & Outdoor EquipmentALDERSHOThttp://www.campingworld.co.uk
01254671945OUTDOOR ACTION LTDCamping & Outdoor EquipmentBLACKBURNhttp://www.outdooraction.co.uk
01255433322MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDONcareers@mountainwarehouse.com
jobs@mountainwarehouse.com
http://www.mountainwarehouse.com
01255860253VAN BEDS LIMITEDCamping & Outdoor EquipmentKIRBY CROSShttp://www.vanbeds.co.uk
01256637642BLACKS LIMITEDCamping & Outdoor EquipmentLONDONcustomercare@blacks.co.uk
customerchampions@jdplc.com
http://www.blacks.co.uk
01257272575CHILL FACTOR LIMITEDCamping & Outdoor EquipmentBISHOPS STORTFORD
01259751366YEOMANS OUTDOORS LIMITEDCamping & Outdoor EquipmentSHIREBROOKhttp://www.yeomansoutdoors.co.uk
01259753940MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDONcareers@mountainwarehouse.com
jobs@mountainwarehouse.com
http://www.mountainwarehouse.com
01263519006MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01263710639MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01264316877MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01268293712ALLWEATHERS LIMITEDCamping & Outdoor EquipmentESSEXsales@allweathers.co.ukhttp://www.allweathers.co.uk
01270449123MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01271440937MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01273202577KATHMANDU (U.K.) LIMITEDCamping & Outdoor EquipmentBOURNEMOUTHhttp://www.kathmandu.co.uk
01273727580MOUNTAIN WAREHOUSE LIMITEDCamping & Outdoor EquipmentLONDON
01273964665MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk
01273964920BLACKS LIMITEDCamping & Outdoor EquipmentLONDONcustomercare@blacks.co.uk
customerchampions@jdplc.com
http://www.blacks.co.uk
01274720984MILLETS LIMITEDCamping & Outdoor EquipmentBURYhttp://www.millets.co.uk