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::Farm Shops]]
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='1032')
  )
  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_id5const235Using 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
01325282828RMETS SERVICES LIMITEDFarm ShopsBROMBOROUGH
01325467141J.J. BLAIR & SONS LIMITEDFarm ShopsDARLINGTON
01328878174ORCHARD FARM LIMITEDFarm ShopsDEVONhttp://www.orchardfarmproducts.com
01332843032CROOTS FARM SHOP LIMITEDFarm ShopsBELPERhttp://www.croots.co.uk
01333423034R TODD & CO LIMITEDFarm ShopsFIFE
01334898145BALGOVE LARDER LIMITEDFarm ShopsST ANDREWSinfo@balgove.com
butchery@balgove.com
http://www.balgove.com
01337831222MUDDY BOOTS LIMITEDFarm ShopsMARLEY HILLhttp://www.muddybootsfife.com
01342810201OLD PLAW HATCH FARM LIMITEDFarm ShopsEAST GRINSTEADhttp://www.tablehurstandplawhatch.co.uk
01343546484ALLARBURN FARM DAIRY LIMITEDFarm ShopsELGIN
01366348175THE HERBARY LIMITEDFarm ShopsCHELMSFORD
01366388912A G LANDYMORE & SON LIMITEDFarm ShopsKINGS LYNN
01366501371THE FUNNY FARM LIMITEDFarm ShopsASHBOURNE
01367243562LITTLE LODGE LIMITEDFarm ShopsWESTERHAMhttp://www.wickleshamlodge.com
01371870256PRIORS HALL LIMITEDFarm ShopsROCHFORDinfo@priorshallfarm.co.ukhttp://www.priorshallfarm.co.uk
01373830798WHITE ROW COUNTRY FOODS LIMITEDFarm ShopsFROME
01376563953ABBEY FARM LIMITEDFarm ShopsORMSKIRKhttp://www.abbeyfarm.co.uk
01380848691NELSON & PRIEST LIMITEDFarm ShopsLYDEWAYenquiries@planksfarmshop.co.ukhttp://www.planksfarmshop.co.uk
01386423970MILLETS FARM SHOP LIMITEDFarm ShopsWILTSHIREenquiries@milletsfarmcentre.comhttp://www.milletsfarm.co.uk
01386446705CHADBURY FARMSHOP LIMITEDFarm ShopsEVESHAMhttp://chadburyfarmshop.co.uk/
01387253087KILNFORD FARM RETAIL LIMITEDFarm ShopsDUMFRIESinfo@kilnford.co.ukhttp://www.kilnford.co.uk
01392875587DARTS FARM LIMITEDFarm ShopsEXETERhttp://www.dartsfarm.co.uk
01392878205DARTS FARM LIMITEDFarm ShopsEXETERhttp://www.dartsfarm.co.uk
01394389599POPPY'S PANTRY LIMITEDFarm ShopsCOLCHESTERhttp://www.poppyspantry.co.uk
01395568286FOUR ELMS FRUIT FARM LIMITEDFarm ShopsSIDMOUTH
01397708686LOCHABER FARM SHOP LIMITEDFarm ShopsBY SPEAN BRIDGEinfo@lochaberfarmshop.comhttp://www.lochaberfarmshop.com
01409261440LIZZY'S LARDER LIMITEDFarm ShopsSOUTH GODSTONEhttp://www.lizzyslarder.co.uk
01420511513THE FLOWER GARDEN LTDFarm ShopsLOWER PEOVER
01420588671HAMPSHIRE FARMERS MARKETS LIMITEDFarm ShopsWINCHESTERhttp://www.hampshirefarmersmarkets.co.uk
01422201065ROBINSONS FARM SHOP LIMITEDFarm ShopsHALIFAXhttp://www.robinsonsfarmshop.co.uk
01422330333INGFIELD FARM SHOP LIMITEDFarm ShopsHALIFAXsales@ingfieldfarmshop.co.ukhttp://www.ingfieldfarmshop.co.uk
01423546111FODDER LTD.Farm ShopsLONDON
01424830357MANTEL FARM LIMITEDFarm ShopsCATSFIELDinfo@mantel-farm.co.ukhttp://www.mantel-farm.co.uk
01424892342HOPE COTTAGE FARM SHOP LTDFarm ShopsBEXHILL-ON-SEAhttp://www.hopecottagefarmshop.co.uk
01425618885DANESTREAM FARM SHOP LIMITEDFarm ShopsNEW MILTONhttp://www.danestreamfarmshop.co.uk
01425622964FERNDENE FARM SHOP LIMITEDFarm ShopsNEW MILTON
01430440322J G EVISON LIMITEDFarm ShopsBRIDLINGTON
01434633100BROCKSBUSHES LIMITEDFarm ShopsNORTHUMBERLANDhttp://www.brocksbushes.co.uk
01435866938MOLE COUNTRY STORES LTDFarm ShopsSOUTH MOLTONinfo@molecountrystores.co.ukhttp://www.molecountrystores.co.uk
01437779451GATE 2 PLATE FARMSHOP LTDFarm ShopsFISHGUARDa.llewellin@btinternet.comhttp://www.gate2platefarmshop.co.uk
01438869666HIGHBURY FARM LIMITEDFarm ShopsNEWHAVENhttp://www.highburyfarm.co.uk
01444881356WOBBLEGATE LIMITEDFarm ShopsHAYWARDS HEATHhttp://www.wobblegate.co.uk
01454228832CHERRY LODGE LTDFarm ShopsBURTON-ON-TRENT
01454773964FROME VALLEY FARM SHOP LIMITEDFarm ShopsBRISTOLhttp://www.fromevalleyfarmshop.co.uk
0146073451NORTH PERROTT FRUIT FARM LIMITEDFarm ShopsLONDONhttp://www.parrettbrand.co.uk
01461758086FARM DIRECT LIMITEDFarm ShopsTRING
01462685363THE FOOD BARN LTDFarm ShopsMARKET HARBOROUGHhttp://www.food-barn.co.uk
01466793405HARBRO LIMITEDFarm ShopsABERDEENSHIREinfo@harbro.co.ukhttp://www.harbro.co.uk
01473736407NEWBOURNE FARM SHOP LTDFarm ShopsWOODBRIDGEnewbournefarmshop@yahoo.co.uk
penny@newbournevegbox.co.uk
http://www.newbournefarmshop.co.uk
01473786610SUFFOLK FOOD HALL LIMITEDFarm ShopsIPSWICHhttp://www.suffolkfoodhall.co.uk
01480860335G.M.HUNTER LIMITEDFarm ShopsHUNTShunter@tilbrookgrange.co.ukhttp://www.tilbrookgrange.co.uk