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::Doctors (medical Practitioners)]]
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='10473')
  )
  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_id5const376Using 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
Phone numberCompanyBusiness categoryLocationE-mailCompany homepage
01273517000CHAPEL STREET SURGERY LIMITEDDoctors (medical Practitioners)BRENTWOODhttp://www.chapelstreetgpsurgery.net
01273555999THEHAVEN LTDDoctors (medical Practitioners)GREAT MISSENDENbhccg.thehaven@nhs.nethttp://www.thehavenpractice.co.uk
01273592723THE MANOR PRACTICE LIMITEDDoctors (medical Practitioners)ROMSEYhttp://www.manorpractice.co.uk
01274322400BEVAN HEALTHCARE C.I.C.Doctors (medical Practitioners)BRADFORDenquiries@bevanhealthcare.nhs.uk
enquiries@bradford.nhs.uk
http://www.bevanhealthcare.nhs.uk
01274568255BRADFORD ANAESTHETIC SERVICES LTDDoctors (medical Practitioners)BINGLEY
01276670056A. BROOKS LTDDoctors (medical Practitioners)POULTON LE FYLDEhttp://www.parkroadsurgery.co.uk
01276691199CLINICIAN360 LIMITEDDoctors (medical Practitioners)LONDONhttp://www.clinician360.co.uk
01277221254DR T W KOH LTDDoctors (medical Practitioners)TONBRIDGE
01277315815CHAPEL STREET SURGERY LIMITEDDoctors (medical Practitioners)BRENTWOODhttp://www.chapelstreetsurgery.co.uk
01278444666EAST QUAY VISION LIMITEDDoctors (medical Practitioners)BRIDGWATERreception@eastquaymc.nhs.ukhttp://www.eastquaymedicalcentre.com
01279602652HERTS & ESSEX UROLOGY LTDDoctors (medical Practitioners)MANCHESTERhttp://www.hertsandessexurology.co.uk
01285652056PHOENIX SURGERY LTDDoctors (medical Practitioners)RUTHINhttp://www.thephoenixsurgery.com
01292532500RIVERSIDE MEDICAL PRACTICE LLPDoctors (medical Practitioners)MUSSELBURGHhttp://www.riversidemedicalpractice.scot.nhs.uk
01293775336CENTRELINE AVIATION MEDICAL SERVICES LTDDoctors (medical Practitioners)HORLEYreception@amsgatwick.comhttp://www.amsgatwick.com
01295256261WEST BAR SURGERY LIMITEDDoctors (medical Practitioners)BANBURYwestbar.contact@nhs.net
westbar.scripts@nhs.net
http://www.westbarsurgery.co.uk/
01303813430C V S HEALTH LIMITEDDoctors (medical Practitioners)EASTBOURNEhttp://www.cvshealthcare.co.uk
01305265018DORSET PRIVATE MEDICAL CLINIC LLPDoctors (medical Practitioners)POOLEhttp://www.dorsetpmc.co.uk
01308421896BRIDPORT MEDICAL CENTRE LIMITEDDoctors (medical Practitioners)BOURNEMOUTH
01312255656YOUR GP LIMITEDDoctors (medical Practitioners)LONDONreception@your.gp
aberdeen@your.gp
http://www.your.gp
01316033610YOUR GP LIMITEDDoctors (medical Practitioners)LONDONreception@your.gp
aberdeen@your.gp
http://www.your-gp.com
01323434101EASTBOURNE HEALTHCARE PARTNERSHIP LIMITEDDoctors (medical Practitioners)EASTBOURNEhttp://www.eastbournehpl.co.uk
01323736607STONEBUSTERS LTDDoctors (medical Practitioners)WOKING
01324861380AVONBRIDGE LIMITEDDoctors (medical Practitioners)AYLESBURY
01325735000INTRAHEALTH LIMITEDDoctors (medical Practitioners)PETERLEElesley.auston@intrahealth.co.ukhttp://www.intrahealth.co.uk
01332332530FBA MEDICAL LIMITEDDoctors (medical Practitioners)NOTTINGHAMhttp://www.regentstreetclinic.net
01334474209CROFTWELL CONSULTING LIMITEDDoctors (medical Practitioners)ST ANDREWShttp://www.gpmed.co.uk.
01334477477BLACKFRIARS MEDICAL PRACTICE LTD.Doctors (medical Practitioners)LONDON
01372277527STEPHEN BLACK VASCULAR LIMITEDDoctors (medical Practitioners)WILMSLOW
01376331839ESSEX ORTHOPAEDICS (BRAINTREE) LIMITEDDoctors (medical Practitioners)BRAINTREEhttp://www.essexorthopaedics.co.uk
01383418931PARK ROAD PRACTICE LIMITEDDoctors (medical Practitioners)LONDONhttp://www.parkroad.gpsurgery.net
01384252729ST. JAMES MEDICAL PRACTICE LTDDoctors (medical Practitioners)LONDON
01384322222LION HEALTH LIMITEDDoctors (medical Practitioners)LONDONhttp://www.lion-health.co.uk
01392367519SOUTH WEST INDEPENDENT MEDICAL SERVICES LIMITEDDoctors (medical Practitioners)SOLIHULL
01394670107HAVEN HEALTH LTDDoctors (medical Practitioners)LONDONhttp://www.havenhealth.nhs.uk
01415318365DR. BERRY LIMITEDDoctors (medical Practitioners)LONDON
01415318470BLACKWOOD PARTNERSHIP LIMITEDDoctors (medical Practitioners)EDINBURGH
01418831166RESOLVE MEDICOLEGAL LIMITEDDoctors (medical Practitioners)GLASGOWinfo@resolvemedicolegal.co.ukhttp://www.resolvemedicolegal.co.uk
01419565928TPHG CONSULTING LTD.Doctors (medical Practitioners)GLASGOW
01423330030SPRINGBANK SURGERY LIMITEDDoctors (medical Practitioners)YORKhttp://www.springbankhealth.co.uk
01425472515CORNERWAYS MEDICAL CENTRE LIMITEDDoctors (medical Practitioners)BOOTLEhttp://www.cornerwaysmedicalcentre.co.uk
01429223195INTRAHEALTH LIMITEDDoctors (medical Practitioners)PETERLEEhttp://www.intrahealth.ltd.co.uk
01429285117MPI LOCUM SERVICES LIMITEDDoctors (medical Practitioners)HARTLEPOOL
01433639100PEAK MEDICAL PRACTICE LIMITEDDoctors (medical Practitioners)MATLOCKaparker@medicolegal2000.co.ukhttp://www.entsurgeon.biz
01442501053DOCTOR NOW LIMITEDDoctors (medical Practitioners)BEACONSFIELDinfo@doctornow.orghttp://www.doctornow.org
01443710586OAKLANDS SURGERY LIMITEDDoctors (medical Practitioners)TREHARRIS
01451600900CONCIERGE MEDICAL PRACTICE LIMITEDDoctors (medical Practitioners)WARWICKinfo@conciergemedical.co.ukhttp://www.conciergemedical.co.uk
01463715999RIVERSIDE MEDICAL PRACTICE LLPDoctors (medical Practitioners)MUSSELBURGHhttp://www.riversidemed.co.uk
01472255111ASHWOOD SURGERY LIMITEDDoctors (medical Practitioners)GATESHEAD
01472691033BEACON MEDICAL LTDDoctors (medical Practitioners)WIGANhttp://www.beaconmedical.nhs.uk
01473226966ST HELENS HEALTHCARE LIMITEDDoctors (medical Practitioners)CHESTER