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::Healthcare Companies]]
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='2743')
  )
  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_id5const612Using 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
01214480608SURE HEALTH LIMITEDHealthcare CompaniesBIRMINGHAM
01214654030ADDACTION LIMITEDHealthcare CompaniesLONDONevents@addaction.org.uk
l.tootell@addaction.org.uk
s.black@addaction.org.uk
fundraising@addaction.org.uk
http://www.addaction.org.uk
01214727963GELPACKSDIRECT LTDHealthcare CompaniesTAMWORTHhttp://www.gelpacksdirect.co.uk
01215374645SOVA HEALTHCARE LTDHealthcare CompaniesBRADFORDleicester@sovahealthcare.co.uk
enquiries@sovahealthcare.co.uk
birmingham@sovahealthcare.co.uk
http://www.sovahealthcare.co.uk
01215549077STANFIELD CARE SERVICES LIMITEDHealthcare CompaniesBIRMINGHAMreferral@stanfieldcare.co.uk
admin@stanfieldcare.co.uk
http://www.stanfieldcare.co.uk
01215558446GHC (UK) LTDHealthcare CompaniesBIRMINGHAM
01216871350HEALTHTRUST EUROPE LLPHealthcare CompaniesLONDONhelpdesk@healthtrusteurope.comhttp://www.healthtrusteurope.com
01217090101SURGINS SURGICAL LTDHealthcare CompaniesSOLIHULLhttp://www.surgins.co.uk
01217444420HEALTH CHECK SOLUTIONS LTDHealthcare CompaniesSOLIHULLhttp://www.247professionalhealth.com
01223357647SIMPRINTS TECHNOLOGY LIMITEDHealthcare CompaniesCAMBRIDGEhttp://www.simprints.com
01223743170DOMAINEX LIMITEDHealthcare CompaniesSAFFRON WALDENenquiries@domainex.co.uk
recruitment2016@domainex.co.uk
http://www.domainex.co.uk
01223813549ORIAN (MIDDLE EAST) LIMITEDHealthcare CompaniesCAMBRIDGE
01223845200BREASTHEALTH UK LIMITEDHealthcare CompaniesCAMBRIDGEhttp://www.breasthealthuk.com
01224580843RIGRUN LIMITEDHealthcare CompaniesABERDEENhttp://www.rigrun.org
01225745737HEALTH CREATION LTDHealthcare CompaniesCOLEFORDhttp://www.healthcreation.co.uk
01226280555SURE HEALTHCARE LIMITEDHealthcare CompaniesSHEFFIELD
01226286665ROSTRA HEALTHCARE LTDHealthcare CompaniesSHEFFIELDinfo@rostrauk.comhttp://www.rostrauk.com
01226323670SUN HEALTHCARE LIMITEDHealthcare CompaniesBARNSLEYhttp://www.sunhealthcare.co.uk
01226704743GALPHARM INTERNATIONAL LIMITEDHealthcare CompaniesBRAUNTON
01226730052SCREEN 4 LLPHealthcare CompaniesBARNSLEYhttp://www.screen4.org
01226770134ORTHOTIC BIOMECHANICAL SOLUTIONS LIMITEDHealthcare CompaniesBARNSLEYhttp://www.orthoticbiomechanicalsolutions.com
01226814030BETTERYOU LIMITEDHealthcare CompaniesBARNSLEYhello@weareonestudio.co.uk
customerservices@betteryou.com
http://www.betteryou.com
01227787972PULMONARY VASCULAR RESEARCH INSTITUTEHealthcare CompaniesCANTERBURYhttp://www.pvri.info
01234223600EVOLUTION HOMECARE SERVICES LIMITEDHealthcare CompaniesCOVENTRYhttp://www.evolutionhomecare.co.uk
01235462820FISHAWACK COMMUNICATIONS LIMITEDHealthcare CompaniesKNUTSFORDhttp://www.fishawack.com
01236702082INVENT HEALTH LIMITEDHealthcare CompaniesHAMILTONhttp://www.inventhealth.co.uk
01242535910COBALT LIMITEDHealthcare CompaniesBROMLEYemailswitchboard@cobalthealth.co.uk
enquiries@cobalthealth.co.uk
fundraising@cobalthealth.co.uk
http://www.cobalthealth.co.uk
01244343106CARTWRIGHT FITNESS LIMITEDHealthcare CompaniesCHESTERsales@cartwrightfitness.co.ukhttp://www.cartwrightfitness.co.uk
01246455381THE SPINECORPORATION LIMITEDHealthcare CompaniesCHESTERFIELDinfo@spinecor.comhttp://www.spinecor.com
01252548774BLESSINGS HEALTHCARE SERVICES LIMITEDHealthcare CompaniesFARNBOROUGHhttp://www.blessingshealth.co.uk
01252849071SVM PHARMA LIMITEDHealthcare CompaniesHARTLEY WINTNEYhttp://www.svmpharma.com
01254682224AFFINITY MEDICAL SERVICES LTDHealthcare CompaniesBLACKBURNhttp://www.affinitymedicals.co.uk
01254708683SME SAFETY SOLUTIONS LIMITEDHealthcare CompaniesDARWENhttp://www.smesafetysolutions.co.uk
01256341660MEDICESS LIMITEDHealthcare CompaniesBASINGSTOKEhttp://www.medicess.co.uk
01256377738THE TRAVEL CLINIC LIMITEDHealthcare CompaniesASHBY-DE-LA-ZOUCHinfo@travelvacs.co.ukhttp://www.travelvacs.co.uk
01256841040MAYCARE LIMITEDHealthcare CompaniesBASINGSTOKEben@maycare.co.uk
nicola.hurley@maycare.co.uk
http://www.maycareltd.co.uk
01257418017CHORLEY MEDICS LIMITEDHealthcare CompaniesCHORLEYhttp://www.chorleymedics.co.uk
01271850904ALLIED HEALTHCARE LTDHealthcare CompaniesELGINhttp://www.alliedhealthcare.com
01273410471COASTAL HOMECARE (HOVE) LIMITEDHealthcare CompaniesHOVEinfo@coastalhomecare.co.ukhttp://www.coastalhomecare.co.uk
01273523777FISHAWACK FACILITATE LIMITEDHealthcare CompaniesKNUTSFORDhttp://www.facilitate-uk.com
01273596205SALTS HEALTHCARE LIMITEDHealthcare CompaniesBIRMINGHAMhttp://www.salts.co.uk
01273626596EKO CONSULTING LTDHealthcare CompaniesEAST SUSSEX
01273648580SCIENSUS LTDHealthcare CompaniesBURTON-ON-TRENThttp://www.sciensus.com
01274236873ARTERIUS LIMITEDHealthcare CompaniesLEEDSinfo@arterius.co.ukhttp://www.arterius.co.uk
01274739900AVAILL LIMITEDHealthcare CompaniesHUNTINGDONhttp://www.availl.co.uk
01274841130SOVEREIGN HEALTH CAREHealthcare CompaniesBRADFORDcharity@sovereignhealthcare.co.uk
sovereign@brand8pr.com
http://www.sovereignhealthcare.co.uk
01276409920BS24 LIMITEDHealthcare CompaniesCAMBERLEYoffice@bs24.co.ukhttp://www.bs24.co.uk
01276673311ALCON LIMITEDHealthcare CompaniesBIRMINGHAM
01278439510CARE SHOP LIMITEDHealthcare CompaniesBARNSLEYenquiries@careshop.co.ukhttp://www.careshop.co.uk
01279306222SECURE HEALTH LTDHealthcare CompaniesLUTONhttp://www.securehealth.com