Courthouse in the UK

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

Quick go:

Types of companies in the UK

2SELECT * FROM `category` WHERE url = 'courthouse' LIMIT 1
7SELECT category_id,region_id FROM `category_item` WHERE category_id = 87 GROUP BY category_id,region_id
2SELECT * FROM `region` WHERE `id` IN ('1','2','3','4') ORDER BY name
1SELECT * FROM `category` ORDER BY name
1SELECT * FROM counts where updated="2020-09-29" and table_name like 'news'
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
1SELECT * 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
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
1SELECT * 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
3SELECT * FROM `item` WHERE `id` IN ('269386','429233','622506','659475','451373','38082','469997','265546','307605','286132','556668','355944')
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('2150','1619','1875','2080','7447','2034','4595','5253','4238','7638','4011','4850') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('38082','265546','269386','286132','307605','355944','429233','451373','469997','556668','622506','659475')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('38082','265546','269386','286132','307605','355944','429233','451373','469997','556668','622506','659475')
0SELECT * FROM `category` WHERE id IN ('1','22','4','24','21','17','49','37','83','28','11') LIMIT 11
1SELECT * FROM counts where updated="2020-09-29" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
1SELECT * FROM `locality` WHERE id IN ('6926','2638','8945','2913','5380','5573','5488','8099','7127','677','10845','2970','450','11276','5165','3849','3719','4171','5895','7781','8261','3118') 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'
0SELECT * 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'