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::NANTWICH]]
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='15088')
  )
  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,const324Using 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
01270610105MCCARTHY'S SALONS LIMITEDHairdressersNANTWICH
01270610330SALON VIE HAIRDRESSING LIMITEDHairdressersNANTWICHnantwich@salon-vie.co.uk
tattenhall@salon-vie.co.uk
http://www.salon-vie.co.uk
01270610405MOLLARD MOTORS (CHESHIRE) LIMITEDGarage ServicesNANTWICHhttp://www.mollardmotors.co.uk
01270610414BETHELL CONTRACTING LTDRoofing ServicesNANTWICH
01270611106BOWCOCK CUERDEN LLPSolicitorsNANTWICHhttp://www.bowcockcuerden.co.uk
01270611112F.J. NEED (FOODS) LIMITEDDairy ProductsNANTWICHsales@needfoods.co.uk
careers@needfoods.co.uk
http://www.needfoods.co.uk
01270611119GARLANDS OF NANTWICH LIMITEDFloristsNANTWICHgarlandsofnantwich@gmail.com
garlandsofnantwich@gmail.coma
http://www.garlandsofnantwich.com
01270611161YOUNG GAS & OIL LIMITEDCentral Heating ServicesNANTWICHhttp://www.younggasandoil.co.uk
01270611177SUREFIRE MEDIA LTDWeb Design & DevelopmentNANTWICHinfo@surefiremedia.co.ukhttp://www.surefiremedia.co.uk
01270611212NANTWICH HEARING CENTRE LIMITEDHearing AidsNANTWICHtalktous@nantwichhearingcentre.co.ukhttp://www.nantwichhearingcentre.co.uk
01270611626BUCKLAND TREE CARE LIMITEDTree SurgeonsNANTWICH
01270611800POINT PROGRESS LTDComputer Software SalesNANTWICHexpenseteam@myexpensesonline.co.ukhttp://www.pointprogress.com
01270615999GATEWAY ELECTRONIC COMPONENTS LIMITEDElectronic ComponentsNANTWICHhttp://www.gatewaycando.com
01270618617M I T SOLUTIONS LIMITEDMobile Phone Repairs & ServicesNANTWICH
01270618951INSIDE PARADISE LIMITEDFurniture ShopsNANTWICHhttp://www.insideparadise.co.uk
01270619147SUDDENSTRIKE LIMITEDPest & Vermin Control ServicesNANTWICHmail@suddenstrike.co.ukhttp://www.suddenstrike.co.uk
01270620660ZYDA LAW LTDLegal ServicesNANTWICHhttp://www.zydalaw.com
01270621771NANTWICH TOWN FOOTBALL CLUB LIMITEDFootball ClubsNANTWICHfunctions@nantwichtownfc.comhttp://www.nantwichtownfc.com
01270623020DABBER CAT LIMITEDHotels & InnsNANTWICHhello@thecatatnantwich.comhttp://www.thecatat.com
01270623333SUNFLOWERS AT ST.ANNE'SDay NurseriesNANTWICHhttp://www.sunflowersatstannes.gov
01270623804MUSTARD SEED MARKETING LIMITEDMarketing & Advertising ConsultantsNANTWICHhello@mustardseedmarketing.co.uk
andy@mustardseedmarketing.co.uk
http://mustardseedmarketing.co.uk
01270623868STAPELEY WATER GARDENS LIMITEDGarden CentresNANTWICHhttp://www.stapeleywg.com
01270623978VANDERBILT WORLDWIDE LIMITEDChemical SuppliersNANTWICHinfo@vanderbiltinternational.comhttp://www.vanderbiltworldwide.com
01270624441CHESHIRE LAMONT LLPEstate AgentsNANTWICHtarporley@cheshirelamont.co.uk
nantwich@cheshirelamont.co.uk
http://www.cheshirelamont.co.uk
01270624907THE NANTWICH PET CENTRE LIMITEDPet ShopsNANTWICH
01270625122NANTWICH CANAL CENTRE LIMITEDBoat HireNANTWICHhttp://www.nantwichcc.co.uk
01270625130GRAHAM SHAPIRO DESIGN LIMITEDAdvertising & Graphic DesignersNANTWICHnantwich@gsd.net
london@gsd.net
hello@gsd.net
http://www.gsd.net
01270625178STITCH LTD.HaberdasheryNANTWICHhttp://www.stitchnantwuch.co.uk
01270625568D DAY TRAINING LTDLgv & Hgv TrainingNANTWICHhttp://ddaytraining.com
01270626434PROJECTS SB LIMITEDProject Management ServicesNANTWICH
01270626456ROMAZZINO LIMITEDItalian RestaurantsNANTWICHhttp://www.romazzino.co.uk
01270626555APPLEWOOD INDEPENDENT LTDFinancial AdvisersNANTWICHenquiries@applewoodindependent.co.ukhttp://www.applewoodindependent.co.uk
01270626624JG CREATIVE COMMUNICATIONS LIMITEDDesign ConsultantsNANTWICHhello@jg-creative.co.ukhttp://www.jg-creative.co.uk
01270626764J PARKER BUILDING & PLUMBING LIMITEDBuildersNANTWICH
01270626909NANTWICH FUNERAL SERVICES LIMITEDFuneral DirectorsNANTWICH
01270627072ADROIT TECHNOLOGIES LIMITEDComputer Software DevelopmentNANTWICHhttp://www.adroit-europe.com
01270627104NANTWICH MUSEUM TRUST LIMITED91020 - Museums activitiesNANTWICHenquiries@nantwichmuseum.org.ukhttp://www.nantwichmuseum.org.uk
01270627206OCC COMPUTER PERSONNEL (NORTHERN) LIMITEDRecruitment ConsultantsNANTWICHenquiries@occ-computing.co.uk
rosanne.meek@occ-computing.co.uk
http://www.occ-computing.co.uk
01270627421TOTAL TOOLS (NANTWICH) LTDTool & Equipment Hire ServicesNANTWICH
01270627676CALBARRIE (CHESHIRE) LIMITEDElectricians & Electrical ContractorsNANTWICHhttp://www.calbarrie.com
01270628614XTERNAL WORX LIMITEDArtificial Sports SurfacesNANTWICHhttp://www.lazylawn.co.uk/sandbach
01270628632JAMES STOTT LIMITEDProperty DevelopmentNANTWICH
01270628745LITTLE ANGELS CHILDCARE & NURSERIES LIMITEDDay NurseriesNANTWICHhttp://www.littleangelsnurseries.co.uk
01270628836MIA STANZA LIMITEDFurniture - RetailNANTWICHhttp://www.miastanza.co.uk
01270629139NANTWICH WINDOWS LIMITEDDouble Glazing InstallersNANTWICHhttp://www.nantwichwindows.com
01270629323BIO-OIL RESEARCH LIMITEDHealth Food SuppliersNANTWICHinfo@biooilresearch.co.ukhttp://www.biooilresearch.co.uk
01270629488BEDAZZLED LIMITEDBeauty Salons & ConsultantsNANTWICHhttp://www.bedazzled-beauty.com
01270629986G B DAVIES LIMITEDGarden ServicesNANTWICHreuben.davies@live.co.uk
enquiries@gbdaviesltd.co.uk
http://www.gbdaviesltd.co.uk
01270650749GORDON BENNETT TECHNOLOGIES LTDComputer ConsultancyNANTWICHhttp://www.gordonbennett.net
01270650979PCA SAFETY LIMITEDHealth & Safety ConsultantsNANTWICH