Rail Logos T-Shirt

£29.99
Select Colour -
Claret product image
Navy product image
Black product image
Select Size -

Size guide for Chest

Size S M L XL XXL XXXL
Inches 34-36 38-40 42-44 46-48 50-52 54-56

This print has been designed and developed in house and each one is hand Printed.

Printed on our own 100% Cotton Short sleeve, Brit Fit crew neck tee.

Featuring 'Rail' design, & Logo hem and neck woven labels

(default) 41 queries took 31 ms
#QueryEA#T
1SELECT `Colour`.`id`, `Colour`.`parent_id`, `Colour`.`lft`, `Colour`.`rght`, `Colour`.`name`, `Colour`.`description`, `Colour`.`swatch`, `Colour`.`code`, `Colour`.`deleted`, `Colour`.`created`, `Colour`.`modified` FROM `test_terrace`.`colours` AS `Colour` WHERE 1 = 1 ORDER BY `Colour`.`lft` ASC23231
2SELECT `Size`.`id`, `Size`.`size_group_id`, `Size`.`parent_id`, `Size`.`lft`, `Size`.`rght`, `Size`.`name`, `Size`.`description`, `Size`.`deleted`, `Size`.`created`, `Size`.`modified` FROM `test_terrace`.`sizes` AS `Size` WHERE 1 = 1 ORDER BY `Size`.`lft` ASC18181
3SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1330
4SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (1) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
5SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (2) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
6SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (3) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1110
7SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`friendly`, `Product`.`name`, `Product`.`purchase_price`, `Product`.`sale_price`, `Product`.`tax_class_id`, `Product`.`default_colour_id`, `Product`.`deleted`, `Product`.`hidden`, `Product`.`control_stock`, `Product`.`low_stock_threshold`, `Product`.`description` FROM `test_terrace`.`products` AS `Product` WHERE `Product`.`parent_id` IS NULL AND `Product`.`hidden` = '0' AND `Product`.`deleted` = '0' AND `Product`.`is_stock_base` = '0' AND `Product`.`friendly` = 'Rail-Logos-T-Shirt'111
8SELECT `ChildProduct`.`id`, `ChildProduct`.`parent_id`, `ChildProduct`.`colour_id`, `ChildProduct`.`size_id`, `ChildProduct`.`deleted` FROM `test_terrace`.`products` AS `ChildProduct` WHERE `ChildProduct`.`deleted` = '0' AND `ChildProduct`.`parent_id` = (15840)17171
9SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15841 AND `CurrentStock`.`current` = '1'001
10SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15842 AND `CurrentStock`.`current` = '1'000
11SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15843 AND `CurrentStock`.`current` = '1'001
12SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15844 AND `CurrentStock`.`current` = '1'001
13SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15845 AND `CurrentStock`.`current` = '1'000
14SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15846 AND `CurrentStock`.`current` = '1'000
15SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15847 AND `CurrentStock`.`current` = '1'001
16SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15848 AND `CurrentStock`.`current` = '1'000
17SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15849 AND `CurrentStock`.`current` = '1'001
18SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15850 AND `CurrentStock`.`current` = '1'001
19SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15851 AND `CurrentStock`.`current` = '1'001
20SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15852 AND `CurrentStock`.`current` = '1'001
21SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15853 AND `CurrentStock`.`current` = '1'001
22SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15854 AND `CurrentStock`.`current` = '1'000
23SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15855 AND `CurrentStock`.`current` = '1'000
24SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15856 AND `CurrentStock`.`current` = '1'000
25SELECT `CurrentStock`.`id`, `CurrentStock`.`product_id`, `CurrentStock`.`extended_product_id`, `CurrentStock`.`user_id`, `CurrentStock`.`basket_item_id`, `CurrentStock`.`rma_item_id`, `CurrentStock`.`product_stock_audit_type_id`, `CurrentStock`.`adjustment`, `CurrentStock`.`stock_level`, `CurrentStock`.`current`, `CurrentStock`.`created` FROM `test_terrace`.`product_stock_audits` AS `CurrentStock` WHERE `CurrentStock`.`product_id` = 15857 AND `CurrentStock`.`current` = '1'000
26SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`colour_id`, `ProductImage`.`image`, `ProductImage`.`full_image`, `ProductImage`.`alternate_text`, `ProductImage`.`title_text` FROM `test_terrace`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = (15840) ORDER BY `ProductImage`.`id` ASC331
27SELECT `Discount`.`id`, `Discount`.`description`, `Discount`.`is_percentage`, `Discount`.`value`, `Discount`.`start_date`, `Discount`.`end_date`, `Discount`.`revoked`, `Discount`.`created`, `Discount`.`modified`, `DiscountsProduct`.`discount_id`, `DiscountsProduct`.`product_id` FROM `test_terrace`.`discounts` AS `Discount` JOIN `test_terrace`.`discounts_products` AS `DiscountsProduct` ON (`DiscountsProduct`.`product_id` = 15840 AND `DiscountsProduct`.`discount_id` = `Discount`.`id`) WHERE NOW() between `Discount`.`start_date` AND `Discount`.`end_date` AND `Discount`.`revoked` = '0'001
28SELECT `SizeGroup`.`id`, `SizeGroup`.`name`, `SizeGroup`.`description`, `SizeGroup`.`created`, `SizeGroup`.`modified` FROM `test_terrace`.`size_groups` AS `SizeGroup` WHERE `SizeGroup`.`id` = 1 LIMIT 1111
29SELECT `Size`.`id`, `Size`.`size_group_id`, `Size`.`parent_id`, `Size`.`lft`, `Size`.`rght`, `Size`.`name`, `Size`.`description`, `Size`.`deleted`, `Size`.`created`, `Size`.`modified` FROM `test_terrace`.`sizes` AS `Size` WHERE `Size`.`size_group_id` = (1) ORDER BY `Size`.`lft` ASC991
30SELECT `ProductsProduct`.`to_product_id` FROM `test_terrace`.`products_products` AS `ProductsProduct` WHERE `ProductsProduct`.`product_id` = 15840441
31SELECT `Colour`.`id`, `Colour`.`parent_id`, `Colour`.`lft`, `Colour`.`rght`, `Colour`.`name`, `Colour`.`description`, `Colour`.`swatch`, `Colour`.`code`, `Colour`.`deleted`, `Colour`.`created`, `Colour`.`modified` FROM `test_terrace`.`colours` AS `Colour` WHERE 1 = 1 ORDER BY `Colour`.`lft` ASC23231
32SELECT `Size`.`id`, `Size`.`size_group_id`, `Size`.`parent_id`, `Size`.`lft`, `Size`.`rght`, `Size`.`name`, `Size`.`description`, `Size`.`deleted`, `Size`.`created`, `Size`.`modified` FROM `test_terrace`.`sizes` AS `Size` WHERE 1 = 1 ORDER BY `Size`.`lft` ASC18181
33SELECT `TaxClass`.`id`, `TaxClass`.`name`, `TaxClass`.`created`, `TaxClass`.`modified` FROM `test_terrace`.`tax_classes` AS `TaxClass` WHERE 1 = 1331
34SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (1) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
35SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (2) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
36SELECT `EffectiveTaxRate`.`id`, `EffectiveTaxRate`.`tax_class_id`, `EffectiveTaxRate`.`effective_date`, `EffectiveTaxRate`.`rate`, `EffectiveTaxRate`.`created` FROM `test_terrace`.`tax_rates` AS `EffectiveTaxRate` WHERE `EffectiveTaxRate`.`effective_date` < NOW() AND `EffectiveTaxRate`.`tax_class_id` = (3) ORDER BY `EffectiveTaxRate`.`effective_date` DESC LIMIT 1111
37SELECT `Product`.`id`, `Product`.`parent_id`, `Product`.`friendly`, `Product`.`name`, `Product`.`purchase_price`, `Product`.`sale_price`, `Product`.`tax_class_id`, `Product`.`default_colour_id`, `Product`.`deleted`, `Product`.`hidden`, `Product`.`control_stock`, `Product`.`low_stock_threshold` FROM `test_terrace`.`products` AS `Product` WHERE `Product`.`parent_id` IS NULL AND `Product`.`hidden` = '0' AND `Product`.`deleted` = '0' AND `Product`.`is_stock_base` = '0' AND `Product`.`id` IN (14004, 15253, 15580, 15761)331
38SELECT `ChildProduct`.`id`, `ChildProduct`.`parent_id`, `ChildProduct`.`colour_id`, `ChildProduct`.`size_id`, `ChildProduct`.`deleted` FROM `test_terrace`.`products` AS `ChildProduct` WHERE `ChildProduct`.`deleted` = '0' AND `ChildProduct`.`parent_id` IN (14004, 15253, 15761)18181
39SELECT `ProductImage`.`id`, `ProductImage`.`product_id`, `ProductImage`.`colour_id`, `ProductImage`.`image`, `ProductImage`.`full_image`, `ProductImage`.`alternate_text`, `ProductImage`.`title_text` FROM `test_terrace`.`product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` IN (14004, 15253, 15761) ORDER BY `ProductImage`.`id` ASC771
40SELECT `Discount`.`id`, `Discount`.`description`, `Discount`.`is_percentage`, `Discount`.`value`, `Discount`.`start_date`, `Discount`.`end_date`, `Discount`.`revoked`, `Discount`.`created`, `Discount`.`modified`, `DiscountsProduct`.`discount_id`, `DiscountsProduct`.`product_id` FROM `test_terrace`.`discounts` AS `Discount` JOIN `test_terrace`.`discounts_products` AS `DiscountsProduct` ON (`DiscountsProduct`.`product_id` IN (14004, 15253, 15761) AND `DiscountsProduct`.`discount_id` = `Discount`.`id`) WHERE NOW() between `Discount`.`start_date` AND `Discount`.`end_date` AND `Discount`.`revoked` = '0'001
41SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`friendly`, `Category`.`meta_description`, `Category`.`meta_keywords`, `Category`.`name`, `Category`.`description`, `Category`.`image`, `Category`.`template`, `Category`.`hidden`, `Category`.`created`, `Category`.`modified` FROM `test_terrace`.`categories` AS `Category` WHERE `Category`.`parent_id` IS NULL AND `Category`.`hidden` = '0' ORDER BY `Category`.`lft` ASC661