SELECT p.id, p.name, p.code, p.description, p.product_group, p.image, p.image_gallery, p.size_chart, p.visible, p.insert_date, g.group_title, c.pdf_path FROM product p INNER JOIN product_group g ON g.id = p.product_group LEFT JOIN size_chart c ON p.size_chart = c.id WHERE p.id = 35 Route One Solutions /Track Bottoms / Bespoke Clothing for Sports Clubs, Teams and Corporate Customers

Track Bottoms

Stadium Pants
C1
135gsm high density full dull polyester Classic design ideal for contact training and general use Heavy duty 3/4 length side zip Side pockets and elasticated, drawcord waistband Soft jersey lining Concealed hem cord system 2 colour options
Get a Quote Now
View Size Chart
©2021  | Designed by Shedload Creative