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

MID LAYER

QUARTER ZIP MID LAYER
C2
Premium ΒΌ zip midlayer 220gsm full dull flat knit polyester with antipill fleece reverse Contoured arm panel in two tone contrast mesh fabric Scooped hem with contrast colour reversed zipper tape Available in kids and adult sizes. 9 colour options to choose from.
Get a Quote Now
View Size Chart
©2021  | Designed by Shedload Creative