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::Frozen Food]]
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='14499')
  )
  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_id5const411Using 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
01259218939ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01267230665D.J. FOODS LIMITEDFrozen FoodTENTERDEN
01269593436ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01269825557FRASER FOODS LIMITEDFrozen FoodSWANSEA
01273328008DTL FOODS LIMITEDFrozen FoodMIDDLESEXhttp://www.dtlfoods.co.uk
01273483450COOK LIMITEDFrozen FoodSWANSEAhttp://www.cookfood.net
01273616400ELITE FROZEN FOODS LIMITEDFrozen FoodSLOUGHinfo@elite-foods.co.ukhttp://www.elitefoodservice.co.uk
01274492240TROPICAL ICES LIMITEDFrozen FoodBRADFORDhttp://www.tropical-ices.co.uk
01274660888ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01274728013EDEN FARM LIMITEDFrozen FoodNORTH SHIELDShttp://www.eden-farm.co.uk
01275371317GOOD TASTE FOODS LIMITEDFrozen FoodSTOURPORT ON SEVERNinfo@goodtastefoods.comhttp://www.goodtastefoods.co.uk
01275371573APETITO LIMITEDFrozen FoodWILTSHIREinfo@apetito.co.uk
orders@apetito.co.uk
http://www.apetito.co.uk
01275371993WILTSHIRE FARM FOODS LIMITEDFrozen FoodWILTSHIREhttp://www.wiltshirefarmfoods.com
01277658160ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01278424244PENNY LANE FOODS LIMITEDFrozen FoodBRIDGWATERsales@pennylanefoods.comhttp://www.burgersandsausages.com
01279501484COOK LIMITEDFrozen FoodSWANSEAhttp://www.cookfood.net
01280730799COUSIN FROZEN FOODS LIMITEDFrozen FoodBUCKINGHAMhttp://www.cousinfrozenfoods.co.uk
01282416360ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01282437630WILTSHIRE FARM FOODS LIMITEDFrozen FoodWILTSHIREhttp://www.wiltshirefarmfoods.co.uk
01282691166PENDLE FROZEN FOODS LIMITEDFrozen FoodNELSONsales@pendlefrozenfoods.co.ukhttp://www.pendlefrozenfoods.co.uk
01284750570ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01286673063ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01293426688SPENCERS LIMITEDFrozen FoodCOLCHESTERhttp://www.spencersdirect.com
01293535787ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01296398738FESTIVAL CATERING SUPPLIES LTDFrozen FoodNORTHAMPTONhttp://www.festivalsupplies.co.uk
01299251090RICH PRODUCTS LIMITEDFrozen FoodANDOVER
01299271345KATERFRESH LIMITEDFrozen FoodKIDDERMINSTER
01302760070KINGASIA FOODS LIMITEDFrozen FoodDONCASTERhttp://www.kingasia.co.uk
01302834141PARAGON QUALITY FOODS LTDFrozen FoodDONCASTERsales@paragonqualityfoods.comhttp://www.paragonqualityfoods.com
01303850937ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01307462696ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01313327655FARMFOODS FREEZER CENTRES LIMITEDFrozen FoodCUMBERNAULDhttp://www.farmfoods.co.uk
01314534332ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01316661900ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01322229274PADDY'S FOODS LIMITEDFrozen FoodBEXLEYHEATH
01322280079KOWLOON FOODS LIMITEDFrozen FoodCHELMSFORD
01322611835CHEF NEMO LIMITEDFrozen FoodLONDONchefnemo@btconnect.comhttp://www.chefnemo.co.uk
01323760008WILTSHIRE FARM FOODS LIMITEDFrozen FoodWILTSHIREhttp://www.wiltshirefarmfoods.com
01324826926ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01325319039HARVEST FOODS LIMITEDFrozen FoodORPINGTONinfo@harvestfoods.co.ukhttp://www.harvestfoods.co.uk
01325463631HOPWELLS LTDFrozen FoodNOTTShttp://www.hopwells.com
01328863251HAIN FROZEN FOODS UK LIMITEDFrozen FoodLEEDSmedia.enquiries@haindaniels.comhttp://www.hain-celestial.co.uk
01332757204ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01342821000COOK LIMITEDFrozen FoodSWANSEAhttp://www.cookfood.net
01344867719WILTSHIRE FARM FOODS LIMITEDFrozen FoodWILTSHIREhttp://www.wiltshirefarmfoods.co.uk
01352792600COUNTRY STYLE FOODS LIMITEDFrozen FoodWEST YORKSHIREhttp://www.bakerware.com
01362695881ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01372631218COOK LIMITEDFrozen FoodSWANSEAhttp://www.cookfood.net
01373462642ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk
01375361311ICELAND FOODS LIMITEDFrozen FoodDEESIDEhttp://www.iceland.co.uk