All companies in the UK

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

Quick go:

Types of companies in the UK

0SELECT * FROM `region` ORDER BY name
2SELECT * FROM `category` ORDER BY name
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'news'
1SELECT * FROM counts where updated="2020-09-29" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
6SELECT * 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 ('384298','350243','189479','820714','904031','884632','391075','37007','25380','481776','497450','586840')
0SELECT * FROM `region` WHERE id IN ('1','3','2') LIMIT 3
1SELECT * FROM `locality` WHERE id IN ('8244','8821','5762','10363','4595','8246','4833','9414','606','732','7212') LIMIT 11
0SELECT * FROM `photos` WHERE `item_id` IN ('25380','37007','189479','350243','384298','391075','481776','497450','586840','820714','884632','904031')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('25380','37007','189479','350243','384298','391075','481776','497450','586840','820714','884632','904031')
0SELECT * FROM `category` WHERE id IN ('1','6','8','44','4','24','17','18','45') LIMIT 9
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
1SELECT * FROM `locality` WHERE id IN ('9095','6184','8821','11271','5217','7481','8473','10777','1652','535','7440','1685','8910','4699','10405','6308','3647','4072','7940','7887','5782','2503') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'item'
1SELECT * FROM counts where updated="2020-09-29" and table_name like 'reviews'
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'photos'