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::WEDNESBURY]]
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='13884')
  )
  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,const321Using 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
01215057770B.T.C. ACTIVEWEAR LIMITEDClothing Manufacturers & WholesalersWEDNESBURYbtcquotes@btcactivewear.co.ukhttp://www.btcactivewear.co.uk
01215058771STAR PRECISION TOOLS LIMITEDTool Suppliers & ServicesWEDNESBURY
01215059970KUKA ROBOTICS UK LTDAutomation Systems & EquipmentWEDNESBURYhttp://www.kuka-robotics.co.uk
01215061080TOP TUBES LIMITEDSteel FabricationsWEDNESBURYhttp://www.toptubes.co.uk
01215064000MONKS & CRANE INDUSTRIAL GROUP LIMITEDIndustrial Protective ClothingWEDNESBURYhttp://www.monks-crane.com
01215207766MICRO DRIVE CONTROLS LIMITEDComputer ConsumablesWEDNESBURY
01215222945H & R LIMITEDFixings & FasteningsWEDNESBURY
01215248403S L D TRANSPORT LIMITEDRoad Haulage ServicesWEDNESBURYhttp://www.sldtransportltd.co.uk
01215262880BARNFATHER WIRE (MIDLANDS) LIMITEDWire ProductsWEDNESBURYsales@barnfatherwire.co.ukhttp://www.barnfatherwire.co.uk
01215263222PREMIER GATES LIMITEDGates & RailingsWEDNESBURY
01215263585T K D FABRICATIONS LIMITEDSteel FabricationsWEDNESBURY
01215264010S & J SIGNS & GRAPHICS LTD.Sign MakersWEDNESBURYhttp://www.sandjsigns.net
01215264313WELDED PRESSWORK (1982) LIMITEDMetal WorkersWEDNESBURYhttp://www.weldedpresswork.co.uk
01215264839ALL CLEAR SERVICES LIMITEDAsbestos RemovalWEDNESBURYenquiries@allclearenv.comhttp://www.allclearenv.com
01215265151PAL ADHESIVE PRODUCTS LIMITEDAdhesive & Industrial TapesWEDNESBURYhttp://www.palgroup.co.uk
01215265250INDUSTRIAL METAL FINISHERS LIMITEDElectroplaters & Metal FinishersWEDNESBURYinfo@imfltd.comhttp://www.imfltd.com
01215265666K.V. STEEL SERVICES LIMITEDSteel StockholdersWEDNESBURY
01215265669MC QUALITY PACKING LIMITEDContract PackersWEDNESBURY
01215266099MANN JITT WEEKLY LIMITEDNewspapers & MagazinesWEDNESBURYhttp://www.mannjittweekly.co.uk
01215266400MIDLAND SPECIALIST COATINGS LIMITEDPaint, Varnish & LacquerWEDNESBURY
01215266845M.T.B. BUILDING SERVICES LTDBuildersWEDNESBURYinfo@mtbbuildingservices.co.uk
mickeyhodgy@yahoo.co.uk
http://www.mtbbuildingservices.co.uk
01215267305GIOMANI DESIGNS LTDFurniture ShopsWEDNESBURY
01215310263PREMIER GATES LIMITEDGates & RailingsWEDNESBURY
01215311968LINK 21 LTDMarketing & Advertising ConsultantsWEDNESBURY
01215315003NEW STREET AUTOS LTDGarage ServicesWEDNESBURYhttp://www.newstautos.co.uk
01215317566PREMIER INDUSTRIAL SERVICES 2000 LIMITEDSteel FabricationsWEDNESBURY
01215549876SPECS EYE CENTRE LIMITEDOphthalmic OpticiansWEDNESBURYhttp://www.specseyecentre.co.uk
01215560275PRITCHARD GEARS LIMITEDGear Cutters & MakersWEDNESBURYnigel@pritchardgearsltd.co.ukhttp://www.pritchardgearsltd-wednesbury.co.uk
01215560359WOODGREEN STORES LIMITEDOff Licences & Wine MerchantsWEDNESBURY
01215560379SPECS EYE CENTRE LIMITEDDispensing OpticiansWEDNESBURYhttp://www.specseyecentre.co.uk
01215560400G.C. RICKARDS LIMITEDCommercial Vehicle Dealers & ManufacturersWEDNESBURY
01215560420THE WESLEY CENTRE FOR ALL LIMITEDCommunity CentresWEDNESBURYcentre.manager@wesleycentreforall.comhttp://www.wesleycentreforall.com
01215560714D.J.L.ENGINEERING LIMITEDEngineersWEDNESBURY
01215560865SLOTTED NUT SERVICE LIMITEDNuts & BoltsWEDNESBURY
01215561471QUEEN ANNE TABLEWARE LIMITEDGoldsmiths & SilversmithsWEDNESBURYinfo@queenanneuk.comhttp://www.queenanneuk.com
01215561497COSWORTH STUD FEEDS LIMITEDPet SuppliesWEDNESBURYhttp://www.cosworthstudfeeds.co.uk
01215561774C. ADAMS & SONS LIMITEDNuts & BoltsWEDNESBURYsales@c-adams.co.ukhttp://www.c-adams.co.uk
01215561999TOTAL CONTROL RACING LIMITEDMotor SportsWEDNESBURYhttp://www.totalcontrolracing.com
01215562011B.H. TRANSMISSION SERVICES LIMITEDGear BoxesWEDNESBURYhttp://www.bhtransmission.co.uk
01215562070IMPACT PRECISION MANUFACTURING LIMITEDPrecision EngineersWEDNESBURY
01215562500NEW CROWN GARAGEMot TestingWEDNESBURY
01215562958ROPE TASK LIMITEDAbseilingWEDNESBURYadmin@ropetask.comhttp://www.ropetask.com
01215564109WEDNESBURY COACHCRAFT LIMITEDGarage ServicesWEDNESBURY
01215564131WOOD GREEN ACADEMYSchools & CollegesWEDNESBURYhttp://www.woddgreenacademy.co.uk
01215565194MICALINE ELECTRICAL SYSTEMS LIMITEDControl Panels & EquipmentWEDNESBURY
01215565700COMPLEX COLD FORMING LIMITEDMotor FactorsWEDNESBURYhttp://www.complexcf.com
01215566979THE WONDER YEARS DAY NURSERY LIMITEDDay NurseriesWEDNESBURYhttp://www.the-wonder-years-day-nursery.co.uk
01215567181LISTER GASES LIMITEDBottled Gas & EquipmentWEDNESBURYsupport@primus.sehttp://www.primus.se
01215568288YOKO INTERNATIONAL LIMITEDIndustrial Protective ClothingWEDNESBURYhttp://www.yokointernational.com
01215569631T. J. PLANT & LIFTING SERVICES LIMITEDTool & Equipment Hire ServicesWEDNESBURYhttp://www.tjplant.com