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 = 31 Route One Solutions /SHORTS / Bespoke Clothing for Sports Clubs, Teams and Corporate Customers

SHORTS

Unisex Gym shorts
C1E
180gsm ultra soft performance polyester knit Full dull, high count microdot fabric Quick dry function Traditional design with stylish modern features Available in 8 colour options Unisex cut Kids and adult sizes
Get a Quote Now
View Size Chart
©2021  | Designed by Shedload Creative