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::KIDDERMINSTER]]
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='10130')
  )
  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,const713Using 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
01256368500CONTRACTAIR LTD.Recruitment ConsultantsKIDDERMINSTERhttp://www.resourcegroup.co.uk
01256368585RESOURCE CONSULTING LIMITEDRecruitment ConsultantsKIDDERMINSTERhttp://www.resourcegroup.co.uk
01258471185TRANQUILITY LIMITEDComplementary TherapiesKIDDERMINSTERmail@newtonforge.co.ukhttp://www.newtonforge.co.uk
01259750469J DAWSON LTDFarmersKIDDERMINSTER
01264772052L RAWLINGS LIMITEDPlant & Machinery HireKIDDERMINSTER
01274655694DISTINCTIVE FLOORING LIMITEDWood, Timber & Laminate FlooringKIDDERMINSTERinfo@distinctiveflooring.co.ukhttp://www.distinctiveflooring.co.uk
01274879532STEPHEN CARROLL LTDCarpenters & JoinersKIDDERMINSTER
01279504507D BAYLISS LTDPainters & DecoratorsKIDDERMINSTER
01284762711MICHAEL K LIMITEDGift ShopsKIDDERMINSTER
01284787289J BOREHAM LTDFarmersKIDDERMINSTER
01288353431RAINBOWS DAY NURSERY LIMITEDDay NurseriesKIDDERMINSTER
01289302067STUART CAMPBELL LTDElectricians & Electrical ContractorsKIDDERMINSTER
01290661967J DAWSON LTDButchersKIDDERMINSTER
01294277464SHEAR PERFECTION LIMITEDHairdressersKIDDERMINSTER
01294464569TRANQUILITY LIMITEDComplementary TherapiesKIDDERMINSTER
01295269600RAINBOWS DAY NURSERY LIMITEDDay NurseriesKIDDERMINSTERhttp://www.rainbowsdaynursery.co.uk
01296426948TRANQUILITY LIMITEDComplementary TherapiesKIDDERMINSTER
01296642070HMX CORPORATE COMMUNICATION LIMITEDTv, Film & Video Production ServicesKIDDERMINSTERtimhorrox@hmx.cc
info@hmx.cc
http://www.hmx.cc
01297442849CHRIS WEIR LTDAdvertising & Graphic DesignersKIDDERMINSTERhttp://www.brandlettering.co.uk/
01298214006CREATIVE FILMS LIMITEDShipping & Forwarding AgentsKIDDERMINSTERhttp://www.creativefilms.co.uk
01298872190EDGESCALE LTDComputer ConsultancyKIDDERMINSTER
01299250221GREENER OPTIONS LIMITEDWashroom ServicesKIDDERMINSTERhttp://www.greeneroptions.co.uk
01299250466DCA EQUIPMENT LTDCatering Equipment SuppliersKIDDERMINSTERhttp://www.dcaequipment.co.uk
01299250493RAZOR DESIGN LIMITEDMarketing & Advertising ConsultantsKIDDERMINSTERcontact@razordesign.co.ukhttp://www.razordesign.co.uk
01299250834PARTITIONS CEILINGS & INTERIORS LIMITEDPartitioning Services & EquipmentKIDDERMINSTER
01299250943STYLES PRECISION LIMITEDPrecision EngineersKIDDERMINSTERinfo@stylesprecision.co.ukhttp://www.stylesprecision.co.uk
01299251076SHAMS (U.K.) LTD.Textile Services & SuppliesKIDDERMINSTER
01299251115MKH BUILDING SERVICES LIMITEDBuilding Services EngineeringKIDDERMINSTER
01299251130WIPER BLADES LIMITEDCar Accessories & PartsKIDDERMINSTERinfo@wiperblades.co.uk
help@wiperblades.co.uk
http://www.wiperblades.co.uk
01299251374CENTRAL STORAGE SYSTEMS LIMITEDMezzanine FloorsKIDDERMINSTERsales@central-storage.comhttp://www.central-storage.com/
01299251384TIC PRODUCTS LIMITEDGeneral PhotographersKIDDERMINSTERwelcome@i360uk.comhttp://www.i360uk.com/
01299251442AMBA LEGAL SERVICES LIMITEDWillsKIDDERMINSTERadvice@ambawills.co.ukhttp://www.ambawills.co.uk
01299251750BENWELDSECURE LTDSecurity Services & EquipmentKIDDERMINSTERsales@benweld.co.ukhttp://www.benweld.co.uk
01299251988INN HOUSE ASSOCIATES LIMITEDManagement & Business ConsultantsKIDDERMINSTER
01299252480ANDERMAN CERAMICS LIMITEDPottery Suppliers & ServicesKIDDERMINSTERenglish@earthwaterfire.com
ussales@earthwaterfire.com
info@andermanceramics.com
customerservice@earthwaterfire.com
jennifer_anderman@163.com
esso.avangard@yahoo.com
http://www.earthwaterfire.com
01299252616FOREST SAWMILLS LIMITEDGarden Equipment SuppliersKIDDERMINSTERhttp://www.forestgarden.co.uk
01299252990T.E.C. ELECTRIC MOTORS LIMITEDEngineersKIDDERMINSTERorders@tecmotors.co.ukhttp://www.tecmotors.co.uk
01299253084GREENFIELD COMPUTER SYSTEMS LIMITEDComputer ConsultancyKIDDERMINSTERhttp://www.greenfieldcomputers.com
01299253144SEVERN VALLEY FASTENERS LTDNuts & BoltsKIDDERMINSTERsales@svfast.comhttp://www.svfast.com
01299253394KENTMASTER LIMITEDCommercial Food Processing EquipmentKIDDERMINSTERhttp://www.kentmaster.com
01299253990MAPLE AION LIMITEDBuildersKIDDERMINSTERinfo@mapleaion.co.ukhttp://www.mapleaion.co.uk
01299254090CONCEPT FURNITURE INTERNATIONAL LTDFurniture HireKIDDERMINSTERhttp://www.conceptfurniture.co.uk
01299254254AIRTUBE TECHNOLOGIES LIMITEDSecurity Services & EquipmentKIDDERMINSTERsales@airtubegroup.co.ukhttp://www.airtubegroup.co.uk
01299266211NEW CROWN BAKERY LIMITEDRetail BakersKIDDERMINSTER
01299269437LEWIS CLEANSING LTDCommercial CleaningKIDDERMINSTERinfo@lewiscleansing.co.ukhttp://www.lewiscleansing.co.uk
01299270055DOLPHIN CORPORATE CONSULTANTS LTDConference & Event ManagementKIDDERMINSTERhttp://www.dolphin-corporate.com
01299270210MFG SOLICITORS LLPLegal ServicesKIDDERMINSTERinfo@mfgsolicitors.comhttp://www.mfgsolicitors.com
01299270271MULLER ENGLAND LIMITEDPrecision EngineersKIDDERMINSTERsales@muller-england.co.uk
andy.styles@muller-england.co.uk
wednesbury@muller-england.co.uk
stephen.lock@muller-england.co.uk
sales@muller-redditch.co.uk
dbarrettmeade@muller-redditch.co.uk
http://www.muller-england.co.uk
01299270297SHW CONTAINERS LIMITEDCardboard BoxesKIDDERMINSTERhttp://www.shwcontainers.co.uk
01299270570QUALITY FOCUSManagement & Business ConsultantsKIDDERMINSTER