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::Caravan Parks]]
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='16764')
  )
  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_id5const382Using 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
 Companies:categoryCompanies:townCompanies:emailCompanies:homepageCompanies:phone
01292479261Caravan ParksPRESTWICKhttp://www.carvanandcamping.co.uk01292479261
01294604615Caravan ParksST ASAPH01294604615
01295810605Caravan ParksBANBURYhttp://www.bo-peep.co.uk01295810605
01297560154Caravan ParksBRIDPORT01297560154
01297560259Caravan ParksCHARMOUTHenq@newlandsholidays.co.ukhttp://www.newlandsholidays.co.uk01297560259
0129822988Caravan ParksBRECON0129822988
0129884261Caravan Parks0129884261
01299266400Caravan ParksWORCESTERSHIREpark@littlelakesleisure.co.ukhttp://www.littlelakespark.co.uk01299266400
01299266460Caravan ParksBEWDLEY01299266460
01299401251Caravan ParksNEAR BEWDLEY01299401251
01299824400Caravan ParksSTOURPORT ON SEVERNenquiries@stourportcaravanpark.co.ukhttp://www.stourportcaravanpark.co.uk01299824400
01299871041Caravan ParksSTOURPORT ON SEVERNhttp://www.lickhillmanor.co.uk01299871041
01301704224Caravan ParksCAIRNDOWhttp://www.lochlomond-lodges.co.uk01301704224
01304373373Caravan ParksWALMER01304373373
01304612681Caravan ParksCHATHAMhttp://www.sandwichleisurepark.co.uk01304612681
01304822831Caravan ParksWALLSEND01304822831
01305852313Caravan ParksBOURNEMOUTHhttp://www.warmwellcarvanpark.co.uk01305852313
01305852677Caravan ParksKINGS LANGLEYhttp://www.wdlh.co.uk01305852677
01305852839Caravan ParksDORCHESTERlittlebirchcaravansite@hotmail.co.ukhttp://www.littlebirchcaravansite.co.uk01305852839
01308897361Caravan ParksKINGS LANGLEYhttp://www.wdlh.co.uk01308897361
01323768688Caravan ParksTUNBRIDGE WELLSholidays@bay-view.co.uk
enquiries@bay-view.co.uk
http://www.bay-view.co.uk01323768688
01326290533Caravan ParksHELSTONhttp://www.kennack.co.uk01326290533
01326290635Caravan ParksBEXHILL-ON-SEAhttp://www.seaviewcaravanpark.com01326290635
01328878305Caravan ParksFAKENHAMenquiries@old-brick-kilns.co.uk
878305enquiries@old-brick-kilns.co.uk
http://www.old-brick-kilns.co.uk01328878305
01330822246Caravan Parks01330822246
01333330283Caravan ParksDUNFERMLINEelie@abbeyford.com
standrews@abbeyford.com
stmonans@abbeyford.com
wales@abbeyford.com
http://www.abbeyford.com01333330283
01333427888Caravan ParksLEVEN01333427888
01333450383Caravan ParksANSTRUTHERhttp://www.balcomielinks.co.uk01333450383
01334475959Caravan ParksEDINBURGHhttp://www.craigtounmeadows.co.uk01334475959
01334870242Caravan ParksST. ANDREWSinfo@clayton-caravan-park.com
enquiries@clayton-caravan-park.com
http://www.clayton-caravan-park.co.uk01334870242
01335300598Caravan ParksNORTHWICHhttp://www.woodlandcaravanpark.co.uk01335300598
01341247269Caravan ParksBARMOUTHinfo@islawrffordd.co.uk
emailinfo@islawrffordd.co.uk
http://www.islawrffordd.co.uk01341247269
01341247301Caravan ParksNR BARMOUTH GWYNEDDhttp://www.sunnysands.co.uk01341247301
01341250263Caravan ParksSOLIHULLinfo@allenscaravans.com
abbots@allenscaravans.com
leedons@allenscaravans.com
overstone@allenscaravans.com
severnside@allenscaravans.com
sunbeach@allenscaravans.com
springs@allenscaravans.com
weir@allenscaravans.com
http://www.allenscaravans.com01341250263
01343542813Caravan ParksCROWTHORNE01343542813
01348811260Caravan ParksPEMBROKE01348811260
01348872462Caravan ParksPEMBROKESHIREhttp://www.howellsleisure.co.uk01348872462
01352720625Caravan ParksNR MOLDhttp://www.barlowscaravanparknorthwales.co.uk01352720625
01352740365Caravan ParksELLESMERE PORThttp://www.pantymwyncaravanpark.co.uk01352740365
01359270121Caravan ParksTHORNABYhttp://www.thedellcaravanpark.co.uk01359270121
01361884075Caravan ParksDENBIGHSHIRE01361884075
0136472177Caravan ParksLONDONhttp://www.edeswellfarm.co.uk0136472177
01369840086Caravan ParksARGYLLhttp://www.argyllholidays.com01369840086
01369840351Caravan ParksCUMBRIA01369840351
01382532837Caravan ParksANGUSinfo@tayview.info
enquiries@tayview.info
http://www.tayview.info01382532837
01386751958Caravan ParksTREARDDUR BAY01386751958
01386861851Caravan ParksSOLIHULLinfo@allenscaravans.com
abbots@allenscaravans.com
leedons@allenscaravans.com
overstone@allenscaravans.com
severnside@allenscaravans.com
sunbeach@allenscaravans.com
springs@allenscaravans.com
weir@allenscaravans.com
http://www.allenscaravans.com01386861851
01386870039Caravan ParksEVESHAMwendy@manorfarmleisure.co.ukhttp://www.manorfarmleisure.co.uk01386870039
01387830226Caravan ParksDUMFRIEShttp://www.bordercaravans.co.uk01387830226
01388488230Caravan ParksBRIDLINGTONhttp://www.wittoncastlecountrypark.co.uk01388488230