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::Wine, Beer, Spirit & Cider Suppliers]]
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='773')
  )
  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_id5const689Using 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
01215442874THEWHISKYTRADER LTD.Wine, Beer, Spirit & Cider SuppliersOLDBURYhttp://www.thewhiskytrader.co.uk/
01215517831SOHO CASH & CARRY LIMITEDWine, Beer, Spirit & Cider SuppliersLONDON
01215655021BOOZE FACTORY (UK) LTD.Wine, Beer, Spirit & Cider SuppliersLONDONcontact@boozefactory.co.uk
ziggi@boozefactory.co.uk
jas@boozefactory.co.uk
rupi@boozefactory.co.uk
tomasz@boozefactory.co.uk
http://www.boozefactory.co.uk
01216680506BEERCO LIMITEDWine, Beer, Spirit & Cider SuppliersBIRMINGHAMinfo@beer.co.uk
info@beerco.co.uk
http://www.beerco.co.uk
01217064404BOOZEBURST LTDWine, Beer, Spirit & Cider SuppliersBIRMINGHAM
01217093734CONNOLLY'S (WINE MERCHANTS) LIMITEDWine, Beer, Spirit & Cider SuppliersSNOW HILLhttp://www.connollyswine.co.uk
01217738249PAUL ROBERTS WINES LIMITEDWine, Beer, Spirit & Cider SuppliersBIRMINGHAMhttp://www.paulrobertswines.co.uk
01217882214VICOMTE BERNARD DE ROMANET LIMITEDWine, Beer, Spirit & Cider SuppliersLUTONhttp://www.romanet.co.uk
01217882497PIEROTH LIMITEDWine, Beer, Spirit & Cider SuppliersLUTONhttp://www.pieroth.com
01223354459ROBERT GRAHAM LIMITEDWine, Beer, Spirit & Cider SuppliersDALKEITHhttp://www.whisky-cigars.co.uk
01223493460J.V. TRADING LIMITEDWine, Beer, Spirit & Cider SuppliersLOWESTOFThttp://www.jvtrading.co.uk
01225340636INDEPENDENT SPIRIT OF BATH LIMITEDWine, Beer, Spirit & Cider SuppliersBATHhttp://www.independentspiritofbath.co.uk
01225862289RUBY RED LTDWine, Beer, Spirit & Cider SuppliersBINGLEY
01227451422LE MOUTON ROUGE LTDWine, Beer, Spirit & Cider SuppliersCANTERBURYhttp://lemoutonrouge.co.uk
01227833888MANOR WINES LIMITEDWine, Beer, Spirit & Cider SuppliersCANTERBURYhttp://www.manorwines.com
01228541177BOOZE BUSTER LTDWine, Beer, Spirit & Cider SuppliersMANCHESTER
01233713020JONATHANS LTDWine, Beer, Spirit & Cider SuppliersBURYjon@jonathans-audio.co.ukhttp://www.jonathans-audio.co.uk
01235512278DEDICATED WINES LTDWine, Beer, Spirit & Cider SuppliersDIDCOT
01235841583DGB EUROPE LIMITEDWine, Beer, Spirit & Cider SuppliersABINGDONinfo@dgb.co.za
production@dgb.co.za
roderic@awn.com.sg
lipotentia@163.com
tablemountain@163.com
fico-wines@sunwahgroup.com
flkorea@flkorea.co.kr
emmadong@foxmail.com
sparkyhun@naver.com
32107984@qq.com
rebecca@montrosechina.com
kenny@montrose.com.hk
lavinia@montrose.com.hk
orders@dgb.co.za
http://www.dgb.co.za
01236421444WALLACES EXPRESS LIMITEDWine, Beer, Spirit & Cider SuppliersIRVINEhttp://www.wallacesexpress.com
01242220485FAVOURITE BEERS LIMITEDWine, Beer, Spirit & Cider SuppliersGLOUCESTERleigh.norwood@favouritebeers.com
rosie@favouritebeers.com
http://www.favouritebeers.com
01242229630OFF-PISTE WINES LIMITEDWine, Beer, Spirit & Cider SuppliersCHELTENHAMhttp://www.offpisteiwines.com
01243265007LORELEI FINE WINES LIMITEDWine, Beer, Spirit & Cider SuppliersWEST SUSSEX
01243512151COMPASS SUPPLY SOLUTIONS LIMITEDWine, Beer, Spirit & Cider SuppliersFAREHAMhttp://www.compass-uk.com
01244320321DEVA WINE LIMITEDWine, Beer, Spirit & Cider SuppliersCHESTER
01245475454LAURENCE PHILIPPE WINES LIMITEDWine, Beer, Spirit & Cider SuppliersCHELMSFORD
01246216000GLOBAL BRANDS LIMITEDWine, Beer, Spirit & Cider SuppliersCHESTERFIELDhttp://www.globalbrands.com
01246237003PREMIER EXPRESS LTDWine, Beer, Spirit & Cider SuppliersCHESHIRE
01246556678HUTTON & MITCHELL LICENSED TRADERS LIMITEDWine, Beer, Spirit & Cider SuppliersSHEFFIELD
01253622997NEWS & BOOZE LTDWine, Beer, Spirit & Cider SuppliersLEEDS
01253733081THE HAWKVIEW AGENCY LIMITEDWine, Beer, Spirit & Cider SuppliersBLACKPOOLinfo@hawkview.co.ukhttp://www.hawkview.co.uk
01253854625BOOZE BUSTER LTDWine, Beer, Spirit & Cider SuppliersMANCHESTER
01254262938BOOZE BUSTER LTDWine, Beer, Spirit & Cider SuppliersMANCHESTER
01254265096BOOZE BUSTER LTDWine, Beer, Spirit & Cider SuppliersMANCHESTER
01254398703BOOZE BUSTER LTDWine, Beer, Spirit & Cider SuppliersMANCHESTER
01254772111B & B DRINKS LTDWine, Beer, Spirit & Cider SuppliersBOLTON
01254777080BEER EXPRESS LIMITEDWine, Beer, Spirit & Cider SuppliersCOCKERMOUTH
01254872090INATUBE DRINKS LTDWine, Beer, Spirit & Cider SuppliersACCRINGTON
01255435536BOOTLEGGERS OFF LICENCE LIMITEDWine, Beer, Spirit & Cider SuppliersSTOKE ON TRENT
01255677943CONNOISSEUR WINES LTDWine, Beer, Spirit & Cider SuppliersYORK
01256772233CARTE BLANCHE WINES LIMITEDWine, Beer, Spirit & Cider SuppliersMONMOUTHhttp://www.carteblanchewines.com
01268533999LONDON CELLAR LIMITEDWine, Beer, Spirit & Cider SuppliersLONDONinfo@london-cellar.comhttp://www.london-cellar.com
01268772611HILLS PROSPECT PLCWine, Beer, Spirit & Cider SuppliersROMFORDhttp://www.hillsprospect.com
01270212200RODNEY DENSEM WINES LIMITEDWine, Beer, Spirit & Cider SuppliersTELFORDsales@rdwines.com
sales@telfordwines.co.uk
retail@rdwines.com
http://www.rodneydensemwines.com
01270760113THE BEER EMPORIUM LIMITEDWine, Beer, Spirit & Cider SuppliersSANDBACHhttp://www.thebeeremporium.com
01270764923N R WINES LIMITEDWine, Beer, Spirit & Cider SuppliersSANDBACH
01271321241OSTLERS CIDER MILL LIMITEDWine, Beer, Spirit & Cider SuppliersBARNSTAPLEinfo@ostlerscidermill.co.ukhttp://www.ostlerscidermill.co.uk
01273513780CROWN DRINKS LIMITEDWine, Beer, Spirit & Cider SuppliersBRIGHTONcrowndrinks@yahoo.co.ukhttp://www.crowndrinks.co.uk
01273514882HARP WINES & SPIRITS LTDWine, Beer, Spirit & Cider SuppliersHAILSHAM
01273553353QUAFF 2 LIMITEDWine, Beer, Spirit & Cider SuppliersHOVEtoby@quaffwine.com
fiveways@quaffwine.com
sales@quaffwine.com
http://www.quaffit.com