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::Medical Supplies]]
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='8166')
  )
  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_id5const1277Using 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
01159320144CREDENHILL LIMITEDMedical SuppliesDERBYSHIREhttp://www.daylong.co.uk
01159322403AIROSPRING MEDICAL LTDMedical SuppliesILKESTONsales@airospring.comhttp://www.airospring.com
01159338343MEDIBORD LIMITEDMedical SuppliesNOTTINGHAMinfo@medibord.comhttp://www.medibord.com
01159505721ORTHOGEM LIMITEDMedical SuppliesOLDHAM
01159664440MALEM MEDICAL LIMITEDMedical SuppliesNOTTINGHAMhttp://www.malem.co.uk
01159757254INDEPENDENCE PRODUCTS LTDMedical SuppliesBASFORDhttp://www.independenceproducts.co.uk
01159778370MEDI-DIRECT INTERNATIONAL LIMITEDMedical SuppliesNOTTINGHAMinfo@medi-direct.co.ukhttp://www.medi-direct.co.uk
01159815703GTA (UK) LTDMedical SuppliesNOTTINGHAMhttp://www.gta-uk.co.uk
01159861888AMI MEDICAL LIMITEDMedical SuppliesNOTTINGHAMsales@suportx.co.ukhttp://www.suportx.co.uk
01159870140COUNTRYWIDE SUPPLIES LIMITEDMedical SuppliesNOTTINGHAMorders@countrywidesupplies.co.uk
pearlandliz@hotmail.co.uk
http://www.countrywidesupplies.co.uk
01159892266G SHAW & SONS LIMITEDMedical SuppliesCROPWELL BISHOP
01162222555SUPRA ENTERPRISES LIMITEDMedical SuppliesCOSSINGTON
01162325146GMG EUROPE LTDMedical SuppliesLEICESTERhttp://www.gmg-europe.co.uk
01162376753LIFE LIFT (MEDICAL PRODUCTS) LTDMedical SuppliesDURHAM
01162396424TRIMEDICA LIMITEDMedical SuppliesLONDONhttp://www.trimedicaltd.co.uk
01162463153MEDICAL TECHNOLOGIES LIMITEDMedical SuppliesBLABY
01162516051PERSONAL CARE PACKS LIMITEDMedical SuppliesLEICESTERinfo@personalcarepacks.comhttp://www.personalcarepacks.com
01162554423ENDOSOFT LIMITEDMedical SuppliesLEICESTERhttp://www.endosoft.com
01162624333CUI INTERNATIONAL LIMITEDMedical SuppliesWINDERMEREcuwearinfo@gmail.comhttp://www.cuwear.com
01162709001KINGSLEY MEDICAL (U.K) LIMITEDMedical SuppliesLEICESTER
01162749000STERIS LIMITEDMedical SuppliesDERBYhttp://www.steris.com
01162766948MEDALIN LIMITEDMedical SuppliesLUTTERWORTHhttp://www.medalin.com
01162876104CORDATE HEALTHCARE LTDMedical SuppliesFLINTSHIREhttp://www.careessentials.co.uk
01173110500LIMBS & THINGS LIMITEDMedical SuppliesBRISTOLhttp://www.limbsandthings.com
01179116750MCADAM LLOYD LIMITEDMedical SuppliesBRISTOLhttp://www.bloccs.com
01179151286MICRIMA LIMITEDMedical SuppliesBRISTOLinfo@micrima.comhttp://www.micrima.com
01179324612SKIDMORE MEDICAL LIMITEDMedical SuppliesBATHhttp://www.skidmoremedical.com
01179374618Q-SURGICAL LTDMedical SuppliesBRISTOLhttp://www.q-surgical.com
01179413979ECTRON LIMITEDMedical SuppliesBRISTOLlucille@ectron.co.uk
alexjones@ectron.co.uk
enquiries@ectron.co.uk
http://www.ectron.co.uk
01179579140MEDEQUIP ASSISTIVE TECHNOLOGY LIMITEDMedical SuppliesWEST DRAYTONhttp://www.medequip-uk.com
01179608652SOUTH WEST MEDICAL LIMITEDMedical SuppliesNORTH SOMERSEThttp://www.southwestmedical.co.uk
01179728888P3 MEDICAL LIMITEDMedical Supplieshttp://www.p3medical.com
01179775588AAH PHARMACEUTICALS LIMITEDMedical SuppliesBELFASTenquiries@aah.co.uk
medinfo@peckforton.com
http://www.aah.co.uk
01179874100BIOINDUCTION LIMITEDMedical Supplieshttp://www.bioinduction.com
01189000570KLS MARTIN UK LIMITEDMedical SuppliesREADINGhttp://www.klsmartin.com/?L=2
01189357000BIOINTERACTIONS LIMITEDMedical SuppliesREADINGhttp://www.biointeractions.com
01189702100VERTEC SCIENTIFIC LIMITEDMedical SuppliesGUILDFORDhttp://www.vertec.co.uk
01189783663CODAN LIMITEDMedical SuppliesWOKINGHAMhttp://www.codan.de/index.asp?language=ENG
01189787373ASCOT AUTOCLAVES LTD.Medical SuppliesWOKINGHAMhttp://www.ascotautoclaves.com
01189844024HAEMAIR LIMITEDMedical SuppliesSWANSEAhttp://www.haemair.com
01202487885OSTEOTEC LIMITEDMedical SuppliesTHATCHAMsales@osteotec.co.ukhttp://www.osteotec.co.uk
01202534986APEXQUICK LIMITEDMedical SuppliesWIMBORNEdarryl@apexquick.com
info@apexquick.com
http://www.apexquick.com
01202573300COURTNEY-THORNE LTDMedical SuppliesBROADSTONEhttp://www.courtney-thorne.co.uk
01202581645GRAZEDEAN LIMITEDMedical SuppliesDORSETsales@grazedean.com
grazedean1@btconnect.com
http://www.grazedean.com
01202601177ALBERT WAESCHLE LIMITEDMedical SuppliesPOOLEhttp://www.aw-online.com
01202620839CHARNWOOD HEALTHCARE LIMITEDMedical SuppliesPOOLEhttp://www.charnwoodhealthcare.co.uk
01202631481ORTHOEUROPE LIMITEDMedical SuppliesABINGDON
01202798510SOLENTIM LTDMedical SuppliesWIMBORNEhttp://www.solentim.com
01202906494DORSET NURSING SUPPLIES LIMITEDMedical SuppliesDORSEThttp://www.dorsetnursing.co.uk
01202914916MEDICARE SYSTEMS LIMITEDMedical SuppliesWORKSOPinfo@medicaresystems.co.ukhttp://www.medicaresystems.co.uk