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 = 22
Route One Solutions /JACKETS/Gilets / Bespoke Clothing for Sports Clubs, Teams and Corporate Customers
110gsm pu coated textured polyester fabric combined with high loft 140gsm thermal wadding
Internal powerstretch cuffs
Internal pocket and zipped side pockets
Gathered lining to enhance overall fit
Available in kids and adult sizes.