Semantic search
From Who Called Me
SQLStore debug output
ASK Query
[[Category:Companies:CompanyContact]] [[Companies:category::Health Food Shops]]
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='8181')
)
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='8181')
)
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 | 1070 | 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 | |
---|---|---|---|---|---|
01204380660 | HEALTH RACK LIMITED | Health Food Shops | PRESTON | http://www.healthrack.co.uk | |
01204385954 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01205359712 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01206542844 | NATURAL FOODS LIMITED | Health Food Shops | MARLBOROUGH | ||
01206546009 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01206760441 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | http://www.hollandandbarrett.com | |
01206767058 | MATRIX FITNESS STORE LIMITED | Health Food Shops | COLCHESTER | http://www.msnsportsnutrition.com | |
01208892500 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01212367869 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01212382467 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01212502480 | HEALTHWORKS LTD | Health Food Shops | WARWICK | http://www.healthworks121.co.uk | |
01213087020 | HOUSE OF HEALTH LTD | Health Food Shops | LONDON | http://www.thehouseofhealth.co.uk | |
01213311599 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | http://www.hollandandbarrett.com | |
01213555776 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01213829897 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01214272567 | ORGANIC EVERYTHING LTD | Health Food Shops | KIDDERMINSTER | http://www.organiceverything.co.uk | |
01214276494 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01214343433 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01214447000 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01214485512 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01214754932 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01215234946 | THE GOOD HEALTH STORE LIMITED | Health Food Shops | HUDDERSFIELD | ||
01215254982 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01215726517 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01215850496 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01216343627 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01216436124 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01217050134 | REVITAL LIMITED | Health Food Shops | LONDON | enquiries@revital.com | http://www.revital.co.uk |
01217092153 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01217336880 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | http://www.hollandandbarrett.com | |
01217675832 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01223315603 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | http://www.hollandandbarrett.com | |
01223353524 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01223423177 | DAILY BREAD CO-OPERATIVE (CAMBRIDGE) LIMITED | Health Food Shops | CAMBRIDGE | http://www.dailybread.co.uk/cambridge | |
01224379911 | VITAMIN-SHOP LIMITED | Health Food Shops | LONDON | ||
01224515102 | OILEX LTD. | Health Food Shops | ABERDEEN | http://www.oilex.com | |
01224575215 | ZUMO LTD | Health Food Shops | LONDON | ||
01224581737 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01224634148 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01225400555 | GLM TRADING LIMITED | Health Food Shops | BATH | ||
01225776056 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01226770069 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01227281067 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01227504983 | KITCH LTD. | Health Food Shops | ASHFORD | http://www.kitchcafe.co.uk | |
01227787861 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01228522242 | PB SPORTS (CUMBRIA) LIMITED | Health Food Shops | CARLISLE | sales@pbsportsonline.co.uk | http://www.pbsportsonline.co.uk |
01228530827 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |
01229583394 | APPLESEEDS HEALTH STORE LIMITED | Health Food Shops | CUMBRIA | http://www.appleseedshealthstore.co.uk | |
01229833043 | PASTURES NEW LIMITED | Health Food Shops | KENT | enquiries@pasturesnewhealth.co.uk | http://www.pasturesnewhealth.co.uk |
01229835795 | HOLLAND & BARRETT LIMITED | Health Food Shops | NUNEATON | hollandandbarrett@pegasuspr.co.uk healthinformation@hollandandbarrett.com customerservices@hollandandbarrett.com | http://www.hollandandbarrett.com |