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::Insurance Intermediaries]]
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='4645')
  )
  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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const1304Using 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
01132054660BEAUMONTS INSURANCE BROKERS LTD.Insurance IntermediariesLONDON
01132185600BLUEFIN INSURANCE SERVICES LIMITEDInsurance IntermediariesLONDONhttp://www.bluefingroup.co.uk
01132381888CGB INSURANCE BROKERS LIMITEDInsurance IntermediariesBATLEY
01132437230ZODIAC FINANCE LIMITEDInsurance IntermediariesLEEDShttp://www.wdennis.com
01132471717ALBION LEGAL SERVICES LIMITEDInsurance IntermediariesPRESTONenquiries@albionlegal.co.ukhttp://www.albionlegal.co.uk
01132521200PETER BATCHELOR INSURANCE SERVICE LIMITEDInsurance IntermediariesLEEDShttp://www.batchelorinsurance.co.uk
01132558070BELMONTE LIMITEDInsurance IntermediariesISLE OF MANenquiries@commercialinsuranceleeds.co.ukhttp://www.belmonteltd.co.uk
01132588155SENIOR WRIGHT INSURANCE SERVICES LIMITEDInsurance IntermediariesLONDONhttp://www.seniorwright.co.uk
01132615088HENDERSON INSURANCE BROKERS LIMITEDInsurance IntermediariesLEEDSinfo@hibl.co.ukhttp://www.hibl.co.uk
01132820821WOODLAND INSURANCE SERVICES LIMITEDInsurance IntermediariesLEEDS
01133220166LAWRENCE FRASER BROKERS LIMITEDInsurance IntermediariesLEEDShttp://www.lfbrokers.co.uk
01133503330RAVENHALL RISK SOLUTIONS LIMITEDInsurance IntermediariesLEEDSenquiries@ravenhallgroup.co.ukhttp://www.ravenhallgroup.co.uk
01133942250BLUEFIN INSURANCE SERVICES LIMITEDInsurance IntermediariesLONDONhttp://www.bluefingroup.co.uk
01138800869MARQUIS INSURANCE BROKERS LIMITEDInsurance IntermediariesLEEDShttp://www.marquisinsurancebrokers.co.uk
01138871006MOTORCADE LTDInsurance IntermediariesLONDON
01142221519RISK2VALUE LIMITEDInsurance IntermediariesSHEFFIELDenquiry@risk2value.comhttp://www.risk2value.com
01142439914PROAKTIVE LTDInsurance IntermediariesDONCASTERinfo@proaktive.co.ukhttp://www.proaktive.co.uk
01142439915C LLOYD INSURANCE BROKERS LTDInsurance IntermediariesSHEFFIELDenquiries@clloydinsurance.co.ukhttp://www.clloydinsurance.co.uk
01142571671ASSURED INSURANCE SOLUTIONS LIMITEDInsurance IntermediariesROTHERHAMhttp://www.lets-insure-it.co.uk
01142612020JOSEPH W. BURLEY & PARTNERS (UK) LTDInsurance IntermediariesCREWEinfo@theburleygroup.co.ukhttp://www.theburleygroup.co.uk
01142668121S.J.ADAMS & CO.(INSURANCE)LIMITEDInsurance IntermediariesSOUTH YORKSHIRE
01158400300FIRTH & SCOTT (INSURANCE BROKERS) LIMITEDInsurance IntermediariesNOTTINGHAMhttp://insurance.firthandscott.co.uk
01159228181JRT INSURANCE BROKERS LIMITEDInsurance IntermediariesNOTTINGHAMinfo@jrt-insurance.co.ukhttp://www.jrt-insurance.co.uk
01159312800RS INSURANCE BROKERS LTD.Insurance IntermediariesNOTTINGHAMhttp://www.rs-insurance.co.uk
01159517030DARWIN CLAYTON (UK) LIMITEDInsurance IntermediariesTUNBRIDGE WELLSinfo@dcuk.co.uk
riskmanagement@dcuk.co.uk
http://www.darwinclayton.co.uk
01159625620ASTRELLE INSURANCE SERVICES LIMITEDInsurance IntermediariesNOTTINGHAM
01159706877UNIQUE INSURANCE SERVICES LTDInsurance IntermediariesNOTTINGHAMenquiries@unique-insurance.co.ukhttp://www.unique-insurance.co.uk
01159734437ROUTEN CHAPLIN LIMITEDInsurance IntermediariesNOTTINGHAMfinance@routenchaplin.co.uk
insurance@routenchaplin.co.uk
firm.queries@fca.org.uk
scott.miles@routen.chaplin.co.uk
734437insurance@routenchaplin.co.uk
http://www.routenchaplin.co.uk
01162228290AMBER INSURANCE MANAGEMENT LTDInsurance IntermediariesLEICESTERhttp://www.amberinsurance.co.uk
01162333815MARTIN BOWN & CO LTD.Insurance IntermediariesLOUGHBOROUGHinsurance@martinbown.co.ukhttp://www.martinbown.co.uk
01162388874FORBES INSURANCE LIMITEDInsurance IntermediariesLEICESTERinfo@forbesbrokers.comhttp://www.forbesbrokers.com
01162388875C.J. BOTT INSURANCE BROKERS LIMITEDInsurance IntermediariesMERIDIAN BUSINESS PARKhttp://www.cjbott.com
01162425887BERKELEY INSURANCE GROUP LIMITEDInsurance IntermediariesLEICESTER
01162614747BERKELEY INSURANCE GROUP LIMITEDInsurance IntermediariesLEICESTERinfo@berkeleyinsurancegroup.co.ukhttp://www.berkeleyinsurancegroup.co.uk
01162621304BALE INSURANCE BROKERS (LEICESTER) LIMITEDInsurance IntermediariesNOTTINGHAMSHIRE
01162777526BRADGATE FINANCIAL SOLUTIONS LTDInsurance IntermediariesLEICESTER
01162785881WHITMAN GOWDRIDGE LIMITEDInsurance IntermediariesWIGSTONinfo@whitmangowdridge.co.ukhttp://www.whitmangowdridge.co.uk
01162791919THE BECKETT INVESTMENT MANAGEMENT GROUP LIMITEDInsurance IntermediariesBURY ST EDMUNDSweb@beckettinvest.com
ian.white@beckettinvest.com
web@beckettinvest.comc
http://www.beckettinvest.com
01162815960ABACO INSURANCE BROKERS LIMITEDInsurance IntermediariesLEICESTERinfo@abacoinsurance.co.ukhttp://www.abacoinsurance.co.uk
01162882609R. JONES (INSURANCE BROKERS) LTDInsurance IntermediariesLEICESTERSHIREhttp://www.rjonesinsurance.co.uk
01163440040CORNERSTONE BUSINESS INSURANCE LIMITEDInsurance IntermediariesLEICESTERadmin@cornerstoneinsurance.co.ukhttp://www.cornerstoneinsurance.co.uk
01173252224BRUNEL PROFESSIONAL RISKS LIMITEDInsurance IntermediariesBRISTOLhttp://www.brunelpi.co.uk
01179065000LOCKTON COMPANIES LLPInsurance IntermediariesLONDONthiggins@lockton.com
penright@lockton.com
michael.goudime@uk.lockton.com
http://www.lockton.com/international
01179084001BLUEFIN INSURANCE SERVICES LIMITEDInsurance IntermediariesLONDONhttp://www.bluefingroup.co.uk
01179171680ARAG PLCInsurance IntermediariesBRISTOLben.parkinson@arag.co.uk
hannah.woolley@arag.co.uk
ateunderwriting@arag.co.uk
enquiries@arag.co.uk
tony.buss@arag.co.uk
paul.hurley@arag.co.uk
david.haynes@arag.co.uk
bob.moreton@arag.co.uk
paul.upton@arag.co.uk
chris.millward@arag.co.uk
andy.talbot@arag.co.uk
matt.warren@arag.co.uk
peter.collins@arag.co.uk
jason.howse@arag.co.uk
paul.cottenham@arag.co.uk
colin.fennelly@arag.co.uk
george.bladon@arag.co.uk
chris.french@arag.co.uk
lisa.abrahams@arag.co.uk
brett.storey@arag.co.uk
mike.knight@arag.co.uk
sian.thomas@arag.co.uk
newclaims@arag.co.uk
customerrelations@arag.co.uk
pressoffice@arag.co.uk
ateschemes@arag.co.uk
jobs@arag.co.uk
http://www.arag.co.uk
01179220420PRECISION BROKING LIMITEDInsurance IntermediariesBRISTOLteam@barnesgraham.com
enquiries@precisionbroking.com
murray.torrible@precisionbroking.com
http://www.precisionbroking.com
01179294001AON CONSULTING LIMITEDInsurance IntermediariesFARNBOROUGHhttp://www.aon.co.uk
01179299381HAYES PARSONS LIMITEDInsurance IntermediariesBRISTOLenquiries@hayesparsons.co.uk
marine@hayesparsons.co.uk
commercial@hayesparsons.co.uk
privateclient@hayesparsons.co.uk
claims@hayesparsons.co.uk
accounts@hayesparsons.co.uk
nanny@hayesparsons.co.uk
cmtia@hayesparsons.co.uk
n.rawlings@hayesparsons.co.uk
http://www.hayesparsons.co.uk
01179453900CASTLEMEAD INSURANCE BROKERS LIMITEDInsurance IntermediariesBRISTOLinfo@castlemead.com
richard.ingleby@castlemead.com
nick.frost@castlemead.com
clive.gamlin@castlemead.com
rachael.beech@castlemead.com
adrian.webb@castlemead.com
http://www.castlemead.com
01179463800SWINTON GROUP LIMITEDInsurance IntermediariesSALFORDintroducer.webleads@swinton.co.uk
online.work.requests@swinton.co.uk
http://www.swinton.co.uk