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
NoneCompanies:category | Companies:town | Companies:email | Companies:homepage | Companies:phone | |
---|---|---|---|---|---|
01159623714 | Residential & Retirement Homes | NOTTINGHAM | 01159623714 | ||
01159631844 | Residential & Retirement Homes | LEICESTER | 01159631844 | ||
01159638222 | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net | 01159638222 |
01159642721 | Residential & Retirement Homes | FARNBOROUGH | http://www.fote.org.uk | 01159642721 | |
01159665055 | Residential & Retirement Homes | MARKET HARBOROUGH | info@thefirslowdham.co.uk | http://www.thefirslowdham.co.uk | 01159665055 |
01159676135 | Residential & Retirement Homes | STOCKPORT | 01159676135 | ||
01159676735 | Residential & Retirement Homes | STOCKPORT | info@regalcarehomes.com | http://www.regalcarehomes.com | 01159676735 |
01159679619 | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net | 01159679619 |
01159783822 | Residential & Retirement Homes | LEICESTER | 01159783822 | ||
01159786736 | Residential & Retirement Homes | LEICESTER | 01159786736 | ||
01159818096 | Residential & Retirement Homes | ROTHERHAM | 01159818096 | ||
01159818733 | Residential & Retirement Homes | WORCESTER | 01159818733 | ||
01159818901 | Residential & Retirement Homes | NOTTINGHAM | 01159818901 | ||
01159861555 | Residential & Retirement Homes | NOTTINGHAM | 01159861555 | ||
01162207338 | Residential & Retirement Homes | LEICESTER | 01162207338 | ||
01162245971 | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net | 01162245971 |
01162246952 | Residential & Retirement Homes | LEICESTER | 01162246952 | ||
01162248888 | Residential & Retirement Homes | HUDDERSFIELD | http://www.hichcare.co.uk | 01162248888 | |
01162340519 | Residential & Retirement Homes | LONDON | 01162340519 | ||
01162355201 | 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 | 01162355201 |
01162368666 | 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 | 01162368666 |
01162393056 | Residential & Retirement Homes | http://www.portlandhouse-residentialcare.co.uk | 01162393056 | ||
01162413337 | Residential & Retirement Homes | LEICESTERSHIRE | 01162413337 | ||
01162419584 | Residential & Retirement Homes | LEICESTER | 01162419584 | ||
01162448624 | Residential & Retirement Homes | LEICESTER | 01162448624 | ||
01162513785 | Residential & Retirement Homes | LEICESTER | http://www.mauricare.com | 01162513785 | |
01162516112 | Residential & Retirement Homes | BOSTON | 01162516112 | ||
01162517441 | Residential & Retirement Homes | MORECAMBE | 01162517441 | ||
01162517567 | Residential & Retirement Homes | LEICESTER | 01162517567 | ||
01162518822 | Residential & Retirement Homes | MANCHESTER | 01162518822 | ||
01162531615 | Residential & Retirement Homes | MANCHESTER | 01162531615 | ||
01162540724 | Residential & Retirement Homes | LEICESTER | 01162540724 | ||
01162610663 | Residential & Retirement Homes | OXTED | 01162610663 | ||
01162662727 | Residential & Retirement Homes | PRESTON | 01162662727 | ||
01162703454 | Residential & Retirement Homes | LEICESTER | http://www.primelife.co.uk | 01162703454 | |
01162703482 | Residential & Retirement Homes | LEICESTER | 01162703482 | ||
01162707276 | Residential & Retirement Homes | LEICESTER | http://www.primelife.co.uk | 01162707276 | |
01162708911 | Residential & Retirement Homes | NOTTINGHAM | 01162708911 | ||
01162713955 | Residential & Retirement Homes | CHESTERFIELD | admin@heathcotes.net referrals@heathcotes.net recruitment@heathcotes.net | http://www.heathcotes.net | 01162713955 |
01162716014 | Residential & Retirement Homes | LEICESTER | http://www.primelife.co.uk | 01162716014 | |
01162719644 | Residential & Retirement Homes | LONDON | http://www.communitycaresolutions.com | 01162719644 | |
01162745400 | Residential & Retirement Homes | LEICESTER | info@lesterhallapartments.co.uk | http://www.lesterhallapartments.co.uk | 01162745400 |
01162750280 | Residential & Retirement Homes | LEICESTER | 01162750280 | ||
01162762186 | Residential & Retirement Homes | LEICESTER | 01162762186 | ||
01162781152 | Residential & Retirement Homes | PLYMOUTH | 01162781152 | ||
01162848306 | Residential & Retirement Homes | LONDON | 01162848306 | ||
01162855868 | Residential & Retirement Homes | LEICESTER | http://www.leicestercare.co.uk | 01162855868 | |
01162864271 | Residential & Retirement Homes | WEST GLAMORGAN | 01162864271 | ||
01162883170 | Residential & Retirement Homes | LEICESTER | 01162883170 | ||
01162915601 | Residential & Retirement Homes | LEICESTER | 01162915601 |