Bar in Buckland Monachorum

The current catalog of companies that belong to the category - Bar. We will help you find any company in Buckland Monachorum (England). You can find reviews, addresses and phone numbers, and also add your organization to the directory.

Quick go:

Types of companies

0SELECT * FROM `locality` WHERE url = 'buckland-monachorum-eng' LIMIT 1
0SELECT * FROM `region` WHERE id = 1 LIMIT 1
0SELECT * FROM `category` WHERE url = 'bar' LIMIT 1
3SELECT COUNT(*) FROM `category_item` WHERE locality_id = 1223 AND category_id = 18
2SELECT * FROM category_item INNER JOIN item ON category_item.item_id = item.id WHERE category_item.locality_id = 1223 AND category_item.category_id = 18 ORDER BY item.name LIMIT 0,24
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('1223') LIMIT 1
0SELECT * FROM `photos` WHERE `item_id` IN ('109928')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('109928')
0SELECT * FROM `category` WHERE id IN ('1','17','18','23') LIMIT 4
1SELECT locality_id, category_id FROM `category_item` WHERE locality_id = 1223 GROUP BY locality_id, category_id
0SELECT * FROM `category` WHERE `id` IN ('1','10','14','17','18','23') ORDER BY name
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'news'
3SELECT * FROM counts where updated="2020-09-23" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
3SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
7SELECT * FROM `item` WHERE `id` IN ('506516','546466','522544','577393','620935','581073','640560','59923','497377','803830','168779','766793')
0SELECT * FROM `region` WHERE id IN ('1','4') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('4093','11923','5369','8256','4078','1420','2714','2026','1916','4604','8482','7441') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('59923','168779','497377','506516','522544','546466','577393','581073','620935','640560','766793','803830')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('59923','168779','497377','506516','522544','546466','577393','581073','620935','640560','766793','803830')
0SELECT * FROM `category` WHERE id IN ('1','46','10','17','11','4') LIMIT 6
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('7555','2189','6093','10084','2288','3948','3957','1786','3290','6912','9676','11109','1852','3452','5899','8339','10471','5354','7673','1617','9723','10251') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'item'
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-09-23" and table_name like 'photos'