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:town::LEICESTER]]
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='519' AND t4.o_id='2009')
  )
  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_id_39const,const5971Using 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
01158228781LIFTING GEAR SUPPLIES LIMITEDLifting GearLEICESTERsales@liftinggearsuppliesltd.co.ukhttp://www.liftinggearsuppliesltd.co.uk
01158370709THE BOOZE STOP LIMITEDOff Licences & Wine MerchantsLEICESTER
01158379592SPRITE CONTRACTS LIMITEDJoinery ManufacturersLEICESTER
01158400822HEATWELL PLUMBING & HEATING SUPPLIES LIMITEDPlumbers' MerchantsLEICESTERsales@heatwell.co.ukhttp://www.heatwellplumbingandheating.co.uk
01158409405PEAK HOME IMPROVEMENTS LIMITEDDouble Glazing InstallersLEICESTER
01158451010INTERNATIONAL AUTOGRAPH AUCTIONS LIMITEDAuctioneers & ValuersLEICESTERinfo@autographauctions.co.ukhttp://www.autographauctions.co.uk
01158523040RDC AVIATION LIMITEDAirline Support ServicesLEICESTERhttp://www.rdcaviation.com
01159203190SHOE ZONE PLCShoe ShopsLEICESTERhttp://www.shoezone.com
01159213185RUDDINGTON GARAGE LIMITEDGarage ServicesLEICESTERhttp://www.ruddingtongarage.co.uk
01159243243INNES ENGLAND LIMITEDSurveyors & ValuersLEICESTERhttp://www.innes-england.com/home home.asp
01159244200DUNELM LIMITEDCurtains & Soft FurnishingsLEICESTERcustomerservices@dunelm.com
charity.enquiries@dunelm.com
press@dunelm.com
dunelm@mhpc.com
corporate@dunelm.com
http://www.dunelm.com
01159254049VICTORIA HOTEL LIMITEDPubsLEICESTER
01159274122STOR-A-FILE LIMITEDDocument ManagementLEICESTERinfo@storafile.co.ukhttp://www.storafile.co.uk
01159292765BROXTOWE FISHBAR LIMITEDTakeaway FoodLEICESTER
01159308630T.T.G. INNS LIMITEDClubs & AssociationsLEICESTER
01159312745LAMBLEY DAY NURSERY LIMITEDDay NurseriesLEICESTERhttp://www.lambleydaynursery.com
01159322830COTMANHAY FARM STORES LTDGrocers & Convenience StoresLEICESTER
01159374023PMS COURIERS LIMITEDCourier ServicesLEICESTER
01159389190BETTA-FIT AUTO CENTRE LIMITEDGarage ServicesLEICESTERhttp://www.bettafitauto.co.uk
01159411254GOLDSMITHS LIMITEDJewellersLEICESTERwebenquiries@goldsmiths.co.uk
webenquires@goldsmiths.co.uk
http://www.goldsmiths.co.uk
01159418123INSTAPRINT LIMITEDPrinters & LithographersLEICESTERinfo@instaprint.co.ukhttp://www.instaprint.co.uk
01159419114THE CHEESE SHOP NOTTINGHAM LIMITEDDelicatessensLEICESTERhttp://www.cheeseshop-nottingham.co.uk
01159423803DESIGNER WORKSHOP LIMITEDUpholsterersLEICESTERhttp://www.designerworkshop.co.uk/?utm source=yell&utm medium=referral&utm campaign=yell
01159443229R.G. BROWN LIMITEDExhibition StandsLEICESTER
01159443577INTELLIGENT FINANCIAL ADVICE LTDFinancial AdvisersLEICESTERinfo@ifalimited.co.ukhttp://www.ifalimited.co.uk
01159444754DUNELM LIMITEDDepartment StoresLEICESTERhttp://www.dunelm-mill.com
01159465691STUDIO ONE LTDHairdressersLEICESTERhttp://studioonelongeaton.co.uk/
01159469333WELBECK HOUSE LIMITEDUpholsterersLEICESTER
01159472888CASTLE EMBROIDERING LIMITEDPromotional Items & IncentivesLEICESTERinfo@castle-embroidering.comhttp://www.castle-embroidering.com
01159474907GOLDSMITHS LIMITEDJewellersLEICESTERwebenquiries@goldsmiths.co.uk
webenquires@goldsmiths.co.uk
http://www.goldsmiths.co.uk
01159500555THE WATCH LAB LTDClocks & Watches Retail & RepairsLEICESTERhttp://www.thewatchlab.co.uk
01159502639EAST MIDLANDS PROPERTY OWNERS LIMITEDProperty ManagementLEICESTERhttp://www.empo.co.uk
01159553181STUDENT LIVING LIMITEDLetting AgentsLEICESTERhttp://www.studentliving.com
01159583079SHOE ZONE PLCShoe ShopsLEICESTERhttp://www.shoezone.com
01159583444TARGET PROPERTY SERVICES LTDDomestic Maintenance & Repair ServicesLEICESTER
01159588230LEATHER WORLD LTDLeathergoodsLEICESTERhttp://www.leathercompany.co.uk
01159596930ENCORE PERSONNEL SERVICES LIMITEDRecruitment ConsultantsLEICESTERhttp://www.encorepersonnel.co.uk
01159597090LIPSY LIMITEDLadies Clothes ShopsLEICESTERhttp://www.lipsy.co.uk
01159610480TELECOM CARE LIMITEDTelecommunication ServicesLEICESTERinfo@telecomcare.nethttp://www.telecomcare.net
01159631844CREATIVE CARE LIMITEDResidential & Retirement HomesLEICESTER
01159632080J & M NEWS LIMITEDNewsagentsLEICESTER
01159663355CHARNWOOD DEVELOPMENTS LIMITEDProperty DevelopmentLEICESTER
01159728676SHOE ZONE PLCShoe ShopsLEICESTERhttp://www.shoezone.com
01159783822LANGDALE HOUSE LIMITEDResidential & Retirement HomesLEICESTER
01159786736PRIME LIFE LIMITEDResidential & Retirement HomesLEICESTER
01159794121AVERROES PHARMACY LTD.PharmaciesLEICESTER
01159794502SHOE ZONE PLCShoe ShopsLEICESTERhttp://www.shoezone.com
01159812123TINY TEDDIES DAY NURSERY LIMITEDDay NurseriesLEICESTER
01159815656P.T. ENGINEERING SERVICES LIMITEDConsulting EngineersLEICESTER
01159823980PROLUDIC LIMITEDPlayground EquipmentLEICESTERinfo@proludic.co.ukhttp://www.proludic.co.uk