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:category::Bus, Coach & Tram Services]]
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='524' AND t4.o_id='3135')
  )
  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_id5const226Using where; Using 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
 Companies:categoryCompanies:townCompanies:emailCompanies:homepageCompanies:phone
01329316500Bus, Coach & Tram ServicesSOUTHAMPTONhttp://www.firstgroup.com01329316500
01339755422Bus, Coach & Tram Services01339755422
01341422385Bus, Coach & Tram ServicesMACHYNLLETHinfo@lloydscoaches.com
jobs@lloydscoaches.com
tacsi@machtaxis.com
taxi@machtaxi.com
http://www.lloydscoaches.com01341422385
01342715222Bus, Coach & Tram ServicesBROMLEYhttp://www.southdownpsv.co.uk01342715222
01352710489Bus, Coach & Tram ServicesHOLYWELL01352710489
01353771362Bus, Coach & Tram ServicesELYlordstravelely@gmail.comhttp://www.lords-travel.co.uk01353771362
01362851210Bus, Coach & Tram ServicesNEWCASTLE UPON TYNEfeedback@konectbus.co.uk
david.read@exterionmedia.co.uk
http://www.konectbus.co.uk01362851210
01376503050Bus, Coach & Tram ServicesLEIGH ON SEAhttp://www.stephensonsofessex.com01376503050
01379647300Bus, Coach & Tram ServicesDISS01379647300
01382201121Bus, Coach & Tram Serviceshttp://www.travelwishart.co.uk01382201121
01384411111Bus, Coach & Tram ServicesLLANDOW COWBRIDGEsales@shelters.co.ukhttp://www.shelters.co.uk01384411111
01384441325Bus, Coach & Tram ServicesSTOURBRIDGEhttp://www.premetro.co.uk01384441325
01384555500Bus, Coach & Tram ServicesBIRMINGHAMtravelcare@nationalexpress.com
buspass@nationalexpress.com
http://www.nxbus.co.uk01384555500
01384555529Bus, Coach & Tram Serviceshttp://www.nationalexpress.com01384555529
01392427711Bus, Coach & Tram ServicesSTOCKPORThttp://www.stagecoachbus.com01392427711
01392439439Bus, Coach & Tram ServicesSTOCKPORThttp://www.stagecoachbus.com01392439439
01395272395Bus, Coach & Tram ServicesSTOCKPORThttp://www.stagecoachbus.com01395272395
01414207600Bus, Coach & Tram ServicesGLASGOWhttp://www.firstgroup.com01414207600
01419522727Bus, Coach & Tram ServicesCLYDEBANKhttp://www.avondalecoaches.co.uk01419522727
01423339600Bus, Coach & Tram ServicesYORKcraig@connexionsbuses.comhttp://www.harrogatecoachtravel.com01423339600
01423566061Bus, Coach & Tram ServicesHARROGATEhello@harrogatebus.co.uk
enquiries2@transdevplc.co.uk
m-ticket@lancashirebus.co.uk
atenquiries2@transdevplc.co.uk
http://www.harrogateanddistrict.co.uk01423566061
01424222820Bus, Coach & Tram ServicesHASTINGShttp://www.bexhillcommunitybus.co.uk01424222820
01429837077Bus, Coach & Tram ServicesTADWORTH01429837077
01437405009Bus, Coach & Tram ServicesWHITLANDinfo@joneslogin.co.uk
endaf@joneslogin.co.uk
geinor@joneslogin.co.uk
hannah@joneslogin.co.uk
chris@joneslogin.co.uk
http://www.joneslogin.co.uk01437405009
01443478013Bus, Coach & Tram ServicesMOUNTAIN ASH01443478013
01444400212Bus, Coach & Tram ServicesHANDCROSS01444400212
01463718282Bus, Coach & Tram ServicesINVERNESS01463718282
01473253734Bus, Coach & Tram ServicesNORWICHhttp://www.firstgroup.com01473253734
01473355873Bus, Coach & Tram ServicesHADLEIGHhttp://www.beestons.co.uk/01473355873
01474361199Bus, Coach & Tram ServicesUPMINSTERhttp://www.londonbusandtruck.co.uk01474361199
01475530555Bus, Coach & Tram ServicesISLE OF CUMBRAEmastermason1@hotmail.co.ukhttp://www.gloverstone.co.uk01475530555
01475530954Bus, Coach & Tram ServicesISLE OF CUMBRAE01475530954
01482325679Bus, Coach & Tram ServicesNEWCASTLE UPON TYNEhttp://www.eyms.co.uk01482325679
01482327142Bus, Coach & Tram ServicesNEWCASTLE UPON TYNEhttp://www.eyms.co.uk01482327142
01482667366Bus, Coach & Tram ServicesNEWCASTLE UPON TYNEhttp://www.eyms.co.uk01482667366
01482719600Bus, Coach & Tram ServicesHULLhttp://www.ehct.co.uk01482719600
01491837988Bus, Coach & Tram ServicesESHERoffice@thames-travel.co.ukhttp://www.thames-travel.co.uk01491837988
01493855570Bus, Coach & Tram ServicesLIVERPOOLhttp://www.firstgroup.com01493855570
01494450151Bus, Coach & Tram ServicesNEWCASTLE UPON TYNEinfo@carouselbuses.co.ukhttp://www.carouselbuses.co.uk01494450151
01502711109Bus, Coach & Tram ServicesNEWCASTLE UPON TYNEcustomerservices@anglianbus.co.uk
david.read@exterionmedia.co.uk
http://www.anglianbus.co.uk01502711109
01509815637Bus, Coach & Tram ServicesDERBYSHIREhttp://www.kinchbus.co.uk01509815637
01514233333Bus, Coach & Tram ServicesBRIGHTONhttp://www.haltontransport.co.uk01514233333
01516088000Bus, Coach & Tram ServicesPRENTON01516088000
01516458661Bus, Coach & Tram ServicesLIVERPOOLhttp://www.firstgroup.com01516458661
01525719719Bus, Coach & Tram ServicesBEDFORDhttp://www.grantpalmer.com01525719719
01527872556Bus, Coach & Tram ServicesLONDONhttp://www.minibushirebromsgroveredditch.co.uk/01527872556
01530817444Bus, Coach & Tram ServicesKETTERINGoperations@robertscoaches.co.uk
recruitment@robertscoaches.co.uk
garage@robertscoaches.co.uk
paul.owen@robertscoaches.co.uk
info@robertsholidays.co.uk
http://www.robertstravelgroup.co.uk01530817444
01535603284Bus, Coach & Tram ServicesHARROGATEhttp://www.keighleyanddistrict.co.uk01535603284
01535680654Bus, Coach & Tram Servicesprepayments@westyorks-ca.gov.ukhttp://www.wymetro.com01535680654
01536742182Bus, Coach & Tram ServicesLEICESTERhttp://www.centrebus.com01536742182