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 = 37
Route One Solutions /Track Bottoms / Bespoke Clothing for Sports Clubs, Teams and Corporate Customers
220gsm ultra soft full dull double knit polyester fabric
Contrast stretch rib fabric for comfort fit and ease of movement
Tapered, slim fit design with ankle zips
Two front zip pockets
2 colour options
Kids and adult sizes