Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:category::Sheltered Accommodation]]
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='16717')
)
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='16717')
)
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 | 621 | 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 | |
---|---|---|---|---|---|
01224683783 | HILTON COURT LIMITED | Sheltered Accommodation | BLACKPOOL | webmaster@aberdeencity.gov.uk | http://www.aberdeencity.gov.uk |
01225700221 | RETIREMENT CARE GROUP LTD | Sheltered Accommodation | NEW MILTON | ||
01225867660 | BROADLEAF MANAGEMENT SERVICES LIMITED | Sheltered Accommodation | RINGWOOD | info@broadleaf.com | http://www.broadleaf.com |
01226370440 | WEAVERS COURT LTD | Sheltered Accommodation | GLASGOW | customersolutions@equityhousing.co.uk | http://www.equityhousing.co.uk |
01226748623 | ST. HELENS COURT LIMITED | Sheltered Accommodation | SOUTHSEA | ||
01228529540 | WALSINGHAM SUPPORT | Sheltered Accommodation | LONDON | http://www.walsingham.com | |
01234212282 | LILLIBET COURT LIMITED | Sheltered Accommodation | BEDFORDSHIRE | ||
01236429899 | ROSEHALL LIMITED | Sheltered Accommodation | COVENTRY | ||
01236452814 | WEST OF SCOTLAND HOUSING ASSOCIATION LIMITED | Sheltered Accommodation | GLASGOW | ||
01236769783 | LINK HOUSING ASSOCIATION LIMITED | Sheltered Accommodation | EDINBURGH | http://www.linkhousing.co.uk | |
01242519280 | BROMFORD GROUP LIMITED | Sheltered Accommodation | BIRMINGHAM | feedback@bromford.co.uk customerservices@bromford.co.uk hellofeedbackcentre@bromford.co.uk governanceteam@bromford.co.uk governance@bromford.co.uk | http://www.bromfordgroup.co.uk |
01242602558 | SEVERN VALE HOUSING ASSOCIATION LIMITED | Sheltered Accommodation | |||
01243374505 | MARTLET HOMES LIMITED | Sheltered Accommodation | |||
01243672483 | GREENCOURT LIMITED | Sheltered Accommodation | BIRMINGHAM | info@grangemanagement.com | http://www.grangemanagement.com |
01243860131 | VIRIDIAN HOUSING | Sheltered Accommodation | http://www.viridianhousing.org.uk | ||
01244348757 | BOWLING GREEN COURT LIMITED | Sheltered Accommodation | FELIXSTOWE | ||
01244681144 | CHESTER & DISTRICT HOUSING TRUST LIMITED | Sheltered Accommodation | http://www.cdht.org | ||
01245257792 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245258179 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245262071 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245262119 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245281587 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245284426 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chelmerhp.org.uk | ||
01245360626 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245420654 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245442661 | HOME GROUP LIMITED | Sheltered Accommodation | http://www.homegroup.org.uk | ||
01245443319 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245450600 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245460767 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245461048 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245467204 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245468909 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245474571 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chelmerhp.org.uk | ||
01245475108 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01245490839 | CHELMER HOUSING PARTNERSHIP LIMITED | Sheltered Accommodation | http://www.chp.org.uk | ||
01246452796 | PARKSIDE LTD | Sheltered Accommodation | LONDON | http://www.chesterfield.org.gov | |
01252544053 | ACCENT PEERLESS LIMITED | Sheltered Accommodation | CAMBERLEY | http://www.accentpeerless.co.uk | |
01252613995 | ALBANY COURT LTD | Sheltered Accommodation | PENYLAN | ||
01253406721 | GREAT PLACES HOUSING ASSOCIATION | Sheltered Accommodation | 20cat@greatplaces.org.uk cat@greatplaces.org.uk joanne.cullen@greatplaces.org.uk phil.elvy@greatplaces.org.uk 20john@guestgarsden.com john@guestgarsden.com claire.alcock@greatplaces.org.uk 20host@salford.gov.uk host@salford.gov.uk 20sarahlodge@greatplaces.org.uk sarahlodge@greatplaces.org.uk 20ellencourt@greatplaces.org.uk ellencourt@greatplaces.org.uk 20olivialodge@greatplaces.org.uk olivialodge@greatplaces.org.uk 20lornalodge@greatplaces.org.uk lornalodge@greatplaces.org.uk meadowlodge@greatplaces.org.uk pomonagardens@greatplaces.org.uk 20floatingsupportinleeds@greatplaces.org.uk floatingsupportinleeds@greatplaces.org.uk 20emma.wood@greatplaces.org.uk emma.wood@greatplaces.org.uk 20stepforward@greatplaces.org.uk stepforward@greatplaces.org.uk 20keri.berry@greatplaces.org.uk keri.berry@greatplaces.org.uk 20alyson.whyte@greatplaces.org.uk alyson.whyte@greatplaces.org.uk 20dochertyproject@greatplaces.org.uk dochertyproject@greatplaces.org.uk 20inpartnership@greatplaces.org.uk inpartnership@greatplaces.org.uk 20rodney@greatplaces.org.uk rodney@greatplaces.org.uk 20bluebellcourt@greatplaces.org.uk bluebellcourt@greatplaces.org.uk rebecca.jackson@greatplaces.org.uk verna.wilde@greatplaces.org.uk 20oldhampfi@greatplaces.org.uk oldhampfi@greatplaces.org.uk 20infooldhampfi@wates.co.uk infooldhampfi@wates.co.uk | http://www.greatplaces.org.uk | |
01254384440 | HYNDBURN HOMES LIMITED | Sheltered Accommodation | mail@contourhomes.co.uk | http://www.contourhousing.co.uk | |
01254398894 | HYNDBURN HOMES LIMITED | Sheltered Accommodation | mail@contourhomes.co.uk | http://www.contourhousing.co.uk | |
01254761642 | LIFEWAYS COMMUNITY CARE LIMITED | Sheltered Accommodation | LONDON | ||
01254875668 | CREATIVE SUPPORT LIMITED | Sheltered Accommodation | MANCHESTER | enquiries@creativesupport.co.uk | http://www.creativesupport.co.uk |
01254884462 | HYNDBURN HOMES LIMITED | Sheltered Accommodation | mail@contourhomes.co.uk | http://www.contourhousing.co.uk | |
01255429164 | HANOVER PROPERTY MANAGEMENT LTD | Sheltered Accommodation | LONDON | ||
01256321136 | ABBEYFIELD UK | Sheltered Accommodation | ST. ALBANS | ||
01256333635 | HAMPTON COURT LIMITED | Sheltered Accommodation | BOURNEMOUTH | http://www.sentinelha.org.uk | |
01257792961 | CHORLEY COMMUNITY HOUSING LIMITED | Sheltered Accommodation | |||
01258459960 | CHESTNUT HOUSE LTD | Sheltered Accommodation | LYTHAM ST. ANNES | ||
01262673795 | COSFORD HOUSE LIMITED | Sheltered Accommodation | SCARBOROUGH |