Establishment in the UK

We bring to your attention the most complete list of Establishment companies of the UK.

Quick go:

Types of companies in the UK

0SELECT * FROM `category` WHERE url = 'establishment' LIMIT 1
2SELECT category_id,region_id FROM `category_item` WHERE category_id = 1 GROUP BY category_id,region_id
0SELECT * FROM `region` WHERE `id` IN ('1','2','3','4') ORDER BY name
2SELECT * FROM `category` ORDER BY name
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'news'
3SELECT * FROM counts where updated="2020-09-26" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
2SELECT * 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
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
2SELECT * FROM `item` WHERE `id` IN ('387048','892691','634','906972','203652','107298','713648','528224','589487','715777','68490','877700')
0SELECT * FROM `region` WHERE id IN ('1','2') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('4161','6399','8342','3404','4376','4833','7600','1799','4598','732','3484','9135') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('634','68490','107298','203652','387048','528224','589487','713648','715777','877700','892691','906972')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('634','68490','107298','203652','387048','528224','589487','713648','715777','877700','892691','906972')
0SELECT * FROM `category` WHERE id IN ('1','6','46','48','17','13','14','4','21','31','40','8','11','39','44') LIMIT 15
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('8352','4264','6031','306','6120','5110','3002','2585','10571','6034','6991','6182','6239','4994','9578','9158','8131','9266','9232','5929','10732','5160') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'item'
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'photos'