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::NORWICH]]
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='2496')
  )
  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,const3540Using 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
01179566880VICTORIA VETERINARY CLINIC LIMITEDVetsNORWICHinfo@victoria-vets.co.ukhttp://www.victoria-vets.co.uk
01179657416MATTHEW SMITH LTD.General PhotographersNORWICHhttp://www.studioten.biz
01179779959BEWELL LIMITEDSports Injury ClinicsNORWICH
01179822622REGIONAL FREIGHT SERVICES LIMITEDShipping & Forwarding AgentsNORWICHhttp://www.regionalfreight.co.uk
01189272999ACTIVE VETCARE LIMITEDVetsNORWICHhttp://www.activevetcare.co.uk
01189349934ACTIVE VETCARE LIMITEDVetsNORWICHhttp://www.activevetcare.co.uk
01189723821MSVETS LIMITEDVetsNORWICH
01189724041WATERLAND MANAGEMENT LIMITEDWater Garden ServicesNORWICHhttp://www.water-land.co.uk
01189742500ARCHANT LIMITEDPublishers & PublicationsNORWICHhttp://www.archant.co.uk
01189751155SIGNS EXPRESS LIMITEDSign MakersNORWICH
01189867222UNDER WRAPS LTDEntertainersNORWICHhttp://www.underwraps.co.uk
01189873421JAMES WHITE ENGINEERING LIMITEDSheet Metal WorkNORWICHsales@jwegroup.co.ukhttp://www.jameswhiteengineering.co.uk
012022490051ST CLASS BUILDING SERVICES LTDBuildersNORWICH
01202460470THE MAINTENANCE DEPARTMENT (UK) LTDDomestic Maintenance & Repair ServicesNORWICHhttp://www.tmdresponse.com
01202579515CHURCH FARM COTTAGES LIMITEDSelf Catering Holiday AccommodationNORWICHhttp://www.churchfarmcottages.co.uk
01202657019CREATIVE DRIVEWAYS LIMITEDPaving & DrivewaysNORWICH
01202697100MY FOOD LIFESTYLE LTDDieting & Weight ControlNORWICHhttp://www.myfood.co.uk
01202722757WOODPARK CONSTRUCTION LIMITEDBuildersNORWICH
01202748312SALTWATER SOLUTIONS LTDEngineersNORWICHhttp://www.saltwatersolutions.co.uk
01204393171ANGLIAN WINDOW CENTRES LIMITEDDouble Glazing InstallersNORWICHhttp://www.anglianhomeinprovements.co.uk
01204493852KINGFISHER DECORATORS LIMITEDPainters & DecoratorsNORWICH
01204652690CHINA INN LIMITEDFish & Chip Shops & RestaurantsNORWICH
01204842860CHINA PALACE LTDTakeaway FoodNORWICH
01204861915MOBILE MONEY LIMITEDLoansNORWICHhttp://www.mobilemoney.co.uk
01205750810P.A.JOHNSON LTDGarden ServicesNORWICH
01206266667COTMAN HOUSING ASSOCIATION LIMITEDHousing Associations & TrustsNORWICHequalityanddiversity@placesforpeople.co.uk
office@cotman-housing.org.uk
emailpurchasing@placesforpeople.co.uk
amanda.marsh@cotman-housing.org.uk
amanda.marsh@placesforpeople.co.uk
cotmancustomerfeedback@cotman-housing.org.uk
cotman.feedback@cotman-housing.org.uk
recruitment@placesforpeople.co.uk
press.enquiries@placesforpeople.co.uk
orcustomerliaison@cotman-housing.org.uk
http://www.cotman-housing.org.uk
01206303655ABSOLUTE ASBESTOS SOLUTIONS LIMITEDAsbestos ServicesNORWICHhttp://www.aasltd.uk.com
01206366199CATTEN COLLEGE LIMITEDTraining ServicesNORWICHhttp://www.cattencollege.co.uk
01206562186WORLD OF BEDS LIMITEDBeds & BeddingNORWICH
01206573490SANDS & SON LIMITEDLuggage & BagsNORWICHhttp://www.sandsandson.co.uk
01206582748SHRED STATION LIMITEDDocument & Data Destruction ServicesNORWICHhttp://www.shredstation.co.uk
01206582909LARKING GOWEN LLPTax AdvisersNORWICHinfo@larking-gowen.co.uk
brd@larking-gowen.co.uk
businessadvice@larking-gowen.co.uk
luke.morris@larking-gowen.co.uk
accounts@larking-gowen.co.uk
david.whitehead@larking-gowen.co.uk
norwich@larking-gowen.co.uk
ipswich@larking-gowen.co.uk
dereham@larking-gowen.co.uk
diss@larking-gowen.co.uk
fakenham@larking-gowen.co.uk
holt@larking-gowen.co.uk
bungay@larking-gowen.co.uk
cromer@larking-gowen.co.uk
colchester@larking-gowen.co.uk
http://www.larking-gowen.co.uk
01206583928LARKING GOWEN LLPInsolvency PractitionersNORWICHinfo@larking-gowen.co.uk
brd@larking-gowen.co.uk
businessadvice@larking-gowen.co.uk
luke.morris@larking-gowen.co.uk
accounts@larking-gowen.co.uk
david.whitehead@larking-gowen.co.uk
norwich@larking-gowen.co.uk
ipswich@larking-gowen.co.uk
dereham@larking-gowen.co.uk
diss@larking-gowen.co.uk
fakenham@larking-gowen.co.uk
holt@larking-gowen.co.uk
bungay@larking-gowen.co.uk
cromer@larking-gowen.co.uk
colchester@larking-gowen.co.uk
http://www.larking-gowen.co.uk
01206767494MATTRESSMAN LTDBeds & BeddingNORWICHhttp://www.mattressman.co.uk
01206769313SWALLOW GAMES LTD.Computer GamesNORWICHquotes@swallowgames.com
sales@swallowgames.com
http://www.swallowgames.com
01206863379THE FOUNDRY ARMS LIMITEDBars & Wine BarsNORWICH
01206878770CATCH 22 LIMITEDCharitable & Voluntary OrganisationsNORWICHhttp://www.catch-22.org.uk
01206960032SHEPPARDS REMOVALS & STORAGE LIMITEDDomestic Removals & StorageNORWICHhttp://www.sheppardsremovals.com
01208895216PERFECT EXAMPLE LIMITEDCommercial CleaningNORWICHhttp://www.perfectexample.co.uk
01209701293CDG PLUMBING & HEATING LIMITEDPlumbersNORWICH
01209704338CDG PLUMBING & HEATING LIMITEDBathroom Design & InstallationNORWICH
01209711933CLIFTON VILLA VETERINARY SERVICES LIMITEDVetsNORWICHemail@provider.comhttp://www.clifton-villa.co.uk
01209716700THE JEWELLERY WORKSHOP LTDJewellersNORWICHhttp://www.jewelleryworkshop.co.uk
01209861930LARGE DIAMETER DRILLING LIMITEDMarine Consultants & ServicesNORWICHinfo@lddrill.comhttp://www.lddrill.com
01212015890A.C. ENVIRONMENTAL SERVICES LIMITEDAsbestos RemovalNORWICH
01212965249I T DISTRIBUTION UK LTDRoad Haulage ServicesNORWICHdeliveries@itdexpress.co.ukhttp://www.itdexpress.co.uk
01213087744TAXASSIST ACCOUNTANTS LIMITEDPayroll ServicesNORWICH
01213267636CALUMET PHOTOGRAPHIC LTDPhotographic EquipmentNORWICHhttp://www.calphoto.co.uk
01213541122SIMLA RESTAURANT LTD.Indian RestaurantsNORWICH
01214453012BRANDBANK LIMITEDDress AgenciesNORWICH