Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:category::Residential & Retirement Homes]]
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='2243')
)
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
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='2243')
)
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
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 2675 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id,o_id,s_id_2,o_id_2 | s_id | 4 | callto_wikidb.t4.s_id | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | callto_wikidb.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:3Query-Depth:1
Errors and Warnings
NonePhone number | Company | Business category | Location | Company homepage | |
---|---|---|---|---|---|
01159623714 | MAPPLETON HOUSE CARE HOMES LIMITED | Residential & Retirement Homes | NOTTINGHAM | ||
01159631844 | CREATIVE CARE LIMITED | Residential & Retirement Homes | LEICESTER | ||
01159638222 | HEATHCOTES CARE LIMITED | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net |
01159642721 | SHERWOOD HOUSE LTD | Residential & Retirement Homes | FARNBOROUGH | http://www.fote.org.uk | |
01159665055 | THE FIRS RESIDENTIAL CARE HOME LIMITED | Residential & Retirement Homes | MARKET HARBOROUGH | info@thefirslowdham.co.uk | http://www.thefirslowdham.co.uk |
01159676135 | HAWTHORN LODGE LIMITED | Residential & Retirement Homes | STOCKPORT | ||
01159676735 | HAWTHORN LODGE LIMITED | Residential & Retirement Homes | STOCKPORT | info@regalcarehomes.com | http://www.regalcarehomes.com |
01159679619 | HEATHCOTES CARE LIMITED | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net |
01159783822 | LANGDALE HOUSE LIMITED | Residential & Retirement Homes | LEICESTER | ||
01159786736 | PRIME LIFE LIMITED | Residential & Retirement Homes | LEICESTER | ||
01159818096 | JUBILEE CARE HOME LIMITED | Residential & Retirement Homes | ROTHERHAM | ||
01159818733 | BROADOAK GROUP LIMITED | Residential & Retirement Homes | WORCESTER | ||
01159818901 | BECAUSE WE CARE LIMITED | Residential & Retirement Homes | NOTTINGHAM | ||
01159861555 | BECAUSE WE CARE LIMITED | Residential & Retirement Homes | NOTTINGHAM | ||
01162207338 | ROMAN PARK LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162245971 | HEATHCOTES CARE LIMITED | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net |
01162246952 | ONKAR CARE HOME LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162248888 | MEADOW COURT LIMITED | Residential & Retirement Homes | HUDDERSFIELD | http://www.hichcare.co.uk | |
01162340519 | LANSDOWNE ROAD LIMITED | Residential & Retirement Homes | LONDON | ||
01162355201 | DIAMOND HOUSE LIMITED | Residential & Retirement Homes | NOTTINGHAM | enquiries@minstercaregroup.co.uk manager.abbeywell@minstercaregroup.co.uk admin.abbeywell@minstercaregroup.co.uk valmy@minstercaregroup.co.uk manager.amberleyhouse@minstercaregroup.co.uk admin.amberleyhouse@minstercaregroup.co.uk amanda@minstercaregroup.co.uk manager.ancliffe@minstercaregroup.co.uk admin.ancliffe@minstercaregroup.co.uk paul.nicholls@minstercaregroup.co.uk manager.ashgrove@minstercaregroup.co.uk admin.ashgrove@minstercaregroup.co.uk manager.attleecourt@minstercaregroup.co.uk admin.attleecourt@minstercaregroup.co.uk cerri.phillips@minstercaregroup.co.uk manager.broadgate@minstercaregroup.co.uk admin.broadgate@minstercaregroup.co.uk warren.canicon@minstercaregroup.co.uk manager.croftwood@minstercaregroup.co.uk admin.croftwood@minstercaregroup.co.uk manager.diamondhouse@abbotsfordcarehomes.co.uk admin.diamondhouse@abbotsfordcarehomes.co.uk manager.duncotehall@minstercaregroup.co.uk admin.duncotehall@minstercaregroup.co.uk manager.emmanuelhouse@minstercaregroup.co.uk admin.emmanuelhouse@minstercaregroup.co.uk manager.erylfryn@minstercaregroup.co.uk admin.erylfryn@minstercaregroup.co.uk cathywatson@minstercaregroup.co.uk manager.falconhouse@minstercaregroup.co.uk admin.falconhouse@minstercaregroup.co.uk manager.freeland@minstercaregroup.co.uk admin.freeland@minstercaregroup.co.uk manager.garswood@minstercaregroup.co.uk admin.garswood@minstercaregroup.co.uk manager.grayscourt@minstercaregroup.co.uk admin.grayscourt@minstercaregroup.co.uk manager.golborne@minstercaregroup.co.uk admin.golborne@minstercaregroup.co.uk manager.greenacres@minstercaregroup.co.uk admin.greenacres@minstercaregroup.co.uk manager.hamshawcourt@minstercaregroup.co.uk admin.hamshawcourt@minstercaregroup.co.uk manager.hourigan@minstercaregroup.co.uk admin.hourigan@minstercaregroup.co.uk manager.idealhome@minstercaregroup.co.uk admin.idealhome@minstercaregroup.co.uk colin@minstercaregroup.co.uk manager.karamcourt@minstercaregroup.co.uk admin.karamcourt@minstercaregroup.co.uk manager.lakelands@minstercaregroup.co.uk admin.lakelands@minstercaregroup.co.uk manager.littleport@minstercaregroup.co.uk admin.littleport@minstercaregroup.co.uk manager.loxleyhall@minstercaregroup.co.uk admin.loxleyhall@minstercaregroup.co.uk manager.lyndhurst@minstercaregroup.co.uk admin.lyndhurst@minstercaregroup.co.uk manager.mowbray@minstercaregroup.co.uk admin.mowbray@minstercaregroup.co.uk manager.mulberrymanor@minstercaregroup.co.uk admin.mulberrymanor@minstercaregroup.co.uk manager.saffronhouse@minstercaregroup.co.uk admin.saffronhouse@minstercaregroup.co.uk manager.sovereignhouse@minstercaregroup.co.uk admin.sovereignhouse@minstercaregroup.co.uk manager.stanstyhouse@minstercaregroup.co.uk admin.stanstyhouse@minstercaregroup.co.uk manager.themeadows@minstercaregroup.co.uk admin.themeadows@minstercaregroup.co.uk manager.shrubbery@minstercaregroup.co.uk admin.shrubbery@minstercaregroup.co.uk manager.thorley@minstercaregroup.co.uk admin.thorley@minstercaregroup.co.uk manager.threeelms@minstercaregroup.co.uk admin.threeelms@minstercaregroup.co.uk manager.waterside@minstercaregroup.co.uk admin.waterside@minstercaregroup.co.uk manager.westhaven@minstercaregroup.co.uk admin.westhaven@minstercaregroup.co.uk enquiries@mistercaregroup.co.uk manager.woodlands@minstercaregroup.co.uk admin.woodlands@minstercaregroup.co.uk manager.wordsleyhall@minstercaregroup.co.uk admin.wordsleyhall@minstercaregroup.co.uk | http://www.minstercaregroup.co.uk |
01162368666 | CROFT HOUSE LIMITED | Residential & Retirement Homes | SIDCUP | referrals@voyagecare.com kevindavison@voyagecare.com rachelmcgarry@voyagecare.com colettemorgan@voyagecare.com louisecrowton@voyagecare.com chrisrogers@voyagecare.com philalexis@voyagecare.com jackieslabbert@voyagecare.com elainebennett@voyagecare.com clairewhitney@voyagecare.com info@voyagecare.com vacancies@voyagecare.com voyagewhistleblowing@rlb-law.com saysomething@voyagecare.com complaints@voyagecare.com compliments@voyagecare.com | http://www.voyagecare.com |
01162393056 | PORTLAND HOUSE LIMITED | Residential & Retirement Homes | http://www.portlandhouse-residentialcare.co.uk | ||
01162413337 | HAMRA ASSOCIATES LIMITED | Residential & Retirement Homes | LEICESTERSHIRE | ||
01162419584 | BESTCARE LTD | Residential & Retirement Homes | LEICESTER | ||
01162448624 | PRIME LIFE LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162513785 | MAURICARE LIMITED | Residential & Retirement Homes | LEICESTER | http://www.mauricare.com | |
01162516112 | NEWTON HOUSE LIMITED | Residential & Retirement Homes | BOSTON | ||
01162517441 | MERE LODGE LIMITED | Residential & Retirement Homes | MORECAMBE | ||
01162517567 | CHERRE RESIDENTIAL CARE LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162518822 | FOSSE COURT LIMITED | Residential & Retirement Homes | MANCHESTER | ||
01162531615 | EASTERN CARE LTD | Residential & Retirement Homes | MANCHESTER | ||
01162540724 | HAMILTON COMMUNITY HOMES LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162610663 | SYCAMORE COURT LIMITED | Residential & Retirement Homes | OXTED | ||
01162662727 | CENTURY CARE LIMITED | Residential & Retirement Homes | PRESTON | ||
01162703454 | PRIME LIFE LIMITED | Residential & Retirement Homes | LEICESTER | http://www.primelife.co.uk | |
01162703482 | WELFORD COURT LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162707276 | PRIME LIFE LIMITED | Residential & Retirement Homes | LEICESTER | http://www.primelife.co.uk | |
01162708911 | PENDENE HOUSE RESIDENTIAL HOME LIMITED | Residential & Retirement Homes | NOTTINGHAM | ||
01162713955 | HEATHCOTES CARE LIMITED | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net |
01162716014 | PRIME LIFE LIMITED | Residential & Retirement Homes | LEICESTER | http://www.primelife.co.uk | |
01162719644 | SOCIAL CARE SOLUTIONS LIMITED | Residential & Retirement Homes | LONDON | http://www.communitycaresolutions.com | |
01162745400 | LESTER HALL APARTMENTS LIMITED | Residential & Retirement Homes | LEICESTER | info@lesterhallapartments.co.uk | http://www.lesterhallapartments.co.uk |
01162750280 | MAURICARE (ENDERBY) LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162762186 | LANGDALE VIEW LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162781152 | VISTA LTD | Residential & Retirement Homes | PLYMOUTH | ||
01162848306 | CHATAWAY RESIDENTIAL HOME LIMITED | Residential & Retirement Homes | LONDON | ||
01162855868 | PINE VIEW CARE HOMES LTD | Residential & Retirement Homes | LEICESTER | http://www.leicestercare.co.uk | |
01162864271 | TY GWYN LIMITED | Residential & Retirement Homes | WEST GLAMORGAN | ||
01162883170 | CONIFER LODGE LIMITED | Residential & Retirement Homes | LEICESTER | ||
01162915601 | MAGNUM CARE LIMITED | Residential & Retirement Homes | LEICESTER |