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::Investment Consultants]]
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='8968')
  )
  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
  100
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt4refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const485Using 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
01489570861SECURITY CHANGE LIMITEDInvestment ConsultantsLONDON
01491628752P & S INVESTMENTS LTDInvestment ConsultantsLEWES
01492540022INVESTMENT & RETIREMENT SOLUTIONS LTDInvestment ConsultantsCOLWYN BAY
01512050872BISHOPGATE LIMITEDInvestment ConsultantsWATERLOOhttp://www.bishopgatelimited.co.uk
01512369771MERCER LIMITEDInvestment ConsultantsLONDONhttp://www.mercer.co.uk
01513472433ENERGY INNOVATION CENTRE LIMITEDInvestment ConsultantsELLESMERE PORThttp://www.energyinnocationcentre.co.uk
01513555540SOLUTIONS ASSET FINANCE LIMITEDInvestment ConsultantsELLESMERE PORTinfo@solutionsassetfinance.comhttp://www.solutionsassetfinance.com
01514276817CROMPTON INVESTMENTS LIMITEDInvestment ConsultantsLIVERPOOL
01517331132O'LOUGHLIN & CO LTDInvestment ConsultantsLIVERPOOL
01536529696PERFORMANCE FINANCE LIMITEDInvestment ConsultantsKETTERINGhttp://www.performancefinance.co.uk
01536790909RESIDENTIAL INVESTMENTS LIMITEDInvestment ConsultantsKETTERING
01539823041ETHICAL MONEY LIMITEDInvestment ConsultantsKENDALhttp://www.3dinvesting.com
01579343002MARCHINGTON WHITE FINANCIAL PLANNING LIMITEDInvestment ConsultantsLOSTWITHIEL
01582461122BPH WEALTH MANAGEMENT LLPInvestment ConsultantsHARPENDENbalance@bphwealth.co.ukhttp://www.bphwealth.co.uk
01582518871SDB MANAGEMENT LIMITEDInvestment ConsultantsBLACKPOOL
01600711955SHEPPARD DAVIES ASSET MANAGEMENT LTDInvestment ConsultantsMONMOUTHhttp://www.sheppard-davies.co.uk
01603251764LUXE PROPERTY LIMITEDInvestment ConsultantsLONDONhttp://www.luxeproperty.co.uk
01603627088GALAHAD BUSINESS CONSULTANCY LIMITEDInvestment ConsultantsHACKFORDteam@rockpool.uk.comhttp://www.rockpool.uk.com
01604211234INVESTOR PROFILE LIMITEDInvestment ConsultantsNORTHAMPTONme@investorprofile.co.ukhttp://www.investorprofile.co.uk
01612374470MIDAS LTDInvestment Consultantsinfo@midas.org.ukhttp://www.investinmanchester.com/contact
01612781819FPML ALTERNATIVES LIMITEDInvestment ConsultantsMANCHESTERronjehu@fpmlalternatives.co.uk
craiglamb@fpmlalternatives.co.uk
http://www.fpmlalternatives.co.uk
01613487867AMBER FINANCIAL INVESTMENTS LIMITEDInvestment ConsultantsWILMSLOWhttp://www.amberfinancial.eu
01616524722ELANTRA INVESTMENT LIMITEDInvestment ConsultantsHANDFORTHhttp://www.elantra-investment.co.uk
01618398229MGP INVESTMENT MANAGEMENT LIMITEDInvestment ConsultantsCASTLEFIELDhttp://www.mgp-investments.com
01618614110BROOKS MACDONALD GROUP PLCInvestment ConsultantsLONDONinfo@brooksmacdonald.com
edinburgh@brooksmacdonald.com
guernsey@brooksmacdonald.com
hampshire@brooksmacdonald.com
jersey@brooksmacdonald.com
leamingtonspa@brooksmacdonald.com
manchester@brooksmacdonald.com
taunton@brooksmacdonald.com
tunbridgewells@brooksmacdonald.com
york@brooksmacdonald.com
http://www.brooksmacdonald.com
01619209688CHINA ALLIANCE GROUP LIMITEDInvestment ConsultantsMANCHESTERhttp://www.chinagroup.co.uk
01619273113CORPACQ LIMITEDInvestment ConsultantsALTRINCHAM
01619290008HALE WEALTH MANAGEMENT LTDInvestment ConsultantsCHEADLEhttp://www.halewm.co.uk
01620825867MCINROY & WOOD LIMITEDInvestment ConsultantsEAST LOTHIANhttp://www.mcinroy-wood.co.uk
01622692269ATIME HOLDINGS LIMITEDInvestment ConsultantsMAIDSTONE
01622850957STRATEGIC INVESTMENT PLANNING LIMITEDInvestment ConsultantsKENT
01623883528NEWBRICK CONSULTANTS LIMITEDInvestment ConsultantsST ALBANSinvestors@newbrickconsultants.comhttp://www.newbrickconsultants.com
01625400108LEEF LTDInvestment ConsultantsBROADSTONE
01635521444AMR FINANCIAL MANAGEMENT LIMITEDInvestment ConsultantsNEWBURYinfo@amrh.co.uk
info@amrinvest.co.uk
http://www.amrinvest.co.uk
01642714765QUIGLEY & PARTNERS LIMITEDInvestment ConsultantsMIDDLESBROUGHfalling@happyleaves.com
quigleyandpartners@btconnect.com
http://www.quigleyandpartners.co.uk
01670504651D & P ASSET MANAGEMENT LIMITEDInvestment Consultantsinfo@dandpam.co.ukhttp://www.dandpam.co.uk
01684574773MERCIA CAPITAL PARTNERS LTDInvestment ConsultantsMALVERNhttp://www.merciacapital.com
01689880205PAS FINANCIAL PLANNING LIMITEDInvestment ConsultantsORPINGTONifa@pasfinancialplanning.co.ukhttp://www.pasfinancialplanning.co.uk
01695570949ASHGAR LIMITEDInvestment ConsultantsORMSKIRK
01698250007DIVERSE INVESTMENTS SCOTLAND LTDInvestment ConsultantsMOTHERWELL
01702551500CHEESMAN & GROVES LIMITEDInvestment ConsultantsBENFLEEThttp://www.cheesmangroves.co.uk
01707391000C-VIEW LIMITEDInvestment ConsultantsWATFORDenquiries@c-view.co.ukhttp://www.c-view.com
01721721724SIRIUSDAWN LIMITEDInvestment ConsultantsPEEBLES
01726833092BEACON WEALTH MANAGEMENT LIMITEDInvestment ConsultantsHUNTINGDONinfo@beaconwealth.co.uk
marketing@beaconwealth.co.uk
http://www.beaconwealth.co.uk
01732520780ASHCOURT ROWAN LIMITEDInvestment ConsultantsBRACKNELLhttp://www.ashcourtrowan.com
01732780252DE BRAE INVESTMENT MANAGEMENT LIMITEDInvestment ConsultantsSEVENOAKShttp://www.debrae.co.uk
01736350768PJ INVESTMENTS LIMITEDInvestment ConsultantsDEESIDE
01737227042INVESTUS LTDInvestment ConsultantsBIRMINGHAMhttp://www.investus.co.uk
01737551633BOND & HAYNES LIMITEDInvestment ConsultantsCOULSDON
01738553799DFS FINANCIAL CONSULTANCY LTD.Investment ConsultantsPERTHhttp://www.dfsfinancialconsultancy.co.uk