Train station in the UK

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

Quick go:

Types of companies in the UK

0SELECT * FROM `category` WHERE url = 'train-station' LIMIT 1
1SELECT category_id,region_id FROM `category_item` WHERE category_id = 81 GROUP BY category_id,region_id
0SELECT * FROM `region` WHERE `id` IN ('1','2','3','4') ORDER BY name
1SELECT * FROM `category` ORDER BY name
0SELECT * 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
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
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
4SELECT * FROM `item` WHERE `id` IN ('423330','264576','744517','577211','752671','481173','731455','275174','666016','117239','375401','473395')
0SELECT * FROM `region` WHERE id IN ('2','4','1') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('9135','11027','9076','3165','1117','7479','5879','5947','6940','5051','4839','4833') LIMIT 12
0SELECT * FROM `photos` WHERE `item_id` IN ('117239','264576','275174','375401','423330','473395','481173','577211','666016','731455','744517','752671')
4SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('117239','264576','275174','375401','423330','473395','481173','577211','666016','731455','744517','752671')
0SELECT * FROM `category` WHERE id IN ('1','11','4','24','62','35','26','27','44','17') LIMIT 10
0SELECT * FROM counts where updated="2020-09-29" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
0SELECT * FROM `locality` WHERE id IN ('7767','8961','10453','6967','3832','3764','469','10095','10448','563','3962','8026','4615','598','2030','376','1880','6347','2878','941','9611','1753') 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'