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 = 11
Route One Solutions /CONTACT TOP / Bespoke Clothing for Sports Clubs, Teams and Corporate Customers
105gsm pu coated lightweight polyester dobby textured fabric
Soft brushed mesh lining
Drawcord at hem and reinforced seams throughout
Available in 10 colour options.
Sizes from kids to adult available.
