Open main menu

Semantic search

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::SUNDERLAND]]
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='2028')
  )
  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,const744Using 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
01287624383SELDONS LEISUREWORLD LIMITEDEntertainmentsSUNDERLAND
01290550456BK JOINERY LTDBuildersSUNDERLAND
01293523273NASA SERVICES LTDReikiSUNDERLANDhttp://www.reikiwell-being.co.uk
01293547852NASA SERVICES LTDAerial Services & SuppliesSUNDERLANDhttp://www.nasaservices.co.uk
01294471128PRETTY POOCHES LTDDog & Cat GroomingSUNDERLAND
01302858401S B HARRIS LIMITEDTelecommunication ServicesSUNDERLAND
01305834252ANCURLEY LTDCarpet FittersSUNDERLAND
01313341283D.M CARS LTDGarage ServicesSUNDERLAND
01313464555STITCH EXPRESS LIMITEDTailor AlterationsSUNDERLAND
01315100662TRIDENT SURVEYING LTDAsbestos ServicesSUNDERLANDhttp://www.tridentsurveying.co.uk
01324716360HOMESEAL WINDOWS LIMITEDDouble Glazing InstallersSUNDERLANDmairsheila@hotmail.co.uk
info@homesealwindows.co.uk
http://www.homesealwindows.co.uk
01324808504HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDhttp://www.haystravel.co.uk/tracyrebecca
01325311112PIZZA COTTAGE LTDPizza Delivery & TakeawaySUNDERLAND
01325320611HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01325351517D & H JEWELLERS LIMITEDJewellersSUNDERLANDhttp://www.taprich.co.uk
01325486131HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.hays-travel.co.uk
01325521291NORTH EAST ACCIDENT REPAIR CENTRES LIMITEDCar Body RepairsSUNDERLANDinfo.sunderland@nearc.co.uk
info.darlington@nearc.co.uk
info.newcastle@nearc.co.uk
http://www.northeastarc.co.uk
01326250775BK JOINERY LTDCarpenters & JoinersSUNDERLAND
01332296700PIZZA COTTAGE LTDCaterersSUNDERLAND
01332792595ONE CALL TRAINING LTDTraining ServicesSUNDERLANDinfo@onecalltraining.co.ukhttp://www.onecalltraining.co.uk
01352757000HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDmold@hays-travel.co.ukhttp://www.haystravel.co.uk/mold-branch
01352761000HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLAND
01355231470DRIVE WELL DRIVER TRAINING LTDDriving SchoolsSUNDERLAND
01355888232HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLAND
01373454026HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDhttp://www.hays-travel.co.uk/karenlambert
01382226602ROBERTSON SMITH LTDSolicitorsSUNDERLAND
01383621515CLUB LIFE LIMITEDNight Clubs & BarsSUNDERLAND
01388663777HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.hays-travel.co.uk
01388766166HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01388777000HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01388819297HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01389720384YOUNG'S NEWSAGENTS LTDNewsagentsSUNDERLAND
01392202066HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01392343529BENCHMARK SURVEYS LIMITEDLand & Hydrographic SurveyorsSUNDERLAND
01395331478HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01395513402HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01417722034NIKE (UK) LIMITEDFactory OutletsSUNDERLAND
01419521144ROMA RESTAURANT LIMITEDItalian RestaurantsSUNDERLANDhttp://www.romaclydebank.co.uk
01422202073MEDICHEM LIMITEDPharmaciesSUNDERLAND
01422206947HUNGRY HIPPO LTDSandwich Shops & DeliverySUNDERLAND
01422371099YORKSHIRE TIGER LIMITEDTravel Agents & ServicesSUNDERLAND
01423508100STITCH EXPRESS LIMITEDTailor AlterationsSUNDERLAND
01425383818HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLAND
01425383819HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLAND
01425383821HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLAND
01429869891HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLANDcustomer.services@hays-travel.co.ukhttp://www.haystravel.co.uk
01434267658HAYS TRAVEL LIMITEDTravel Agents & ServicesSUNDERLAND
01444230415BOOKKEEPING & ACCOUNTANCY SERVICES LIMITEDBookkeeping ServicesSUNDERLAND
01449744951CONTAINER SALES (UK) LIMITEDContainer Services & SuppliesSUNDERLANDinfo@containersalesuk.comhttp://www.containersalesuk.com
01453826854MC COMPUTERS LTDComputer ServicesSUNDERLAND