(SELECT Option_Type,Option_Name FROM dt_option WHERE Product_ID='85802' and Option_Name != '' and Displayed = 1 ORDER BY `Option_Name`)

SELECT Distinct d.`id`,d.`Name` as Category,d.`Parent_Id` as Parent FROM `dt_category-websites` a inner join `dt_category` d on d.id = a.Category_Id WHERE Website = 'garmsandswagga' and a.Displayed = 'Yes' AND d.Displayed = 'Yes'

(SELECT DISTINCT b.light_logo,b.dark_logo,b.light_logo_width,b.light_logo_height,b.dark_logo_width,b.dark_logo_height,a.Brand_Name , a.Brand_Name LIKE 'bench' as selectedBrand FROM `dt_product` a,`dt_brands` b WHERE b.`garmsandswagga` = 'on' AND a.Brand_Name=b.brand_name AND a.`Displayed` = "Yes"AND b.Displayed = 'Yes' AND a.Category IN() ORDER BY a.Brand_Name)

(SELECT DISTINCT a.id,a.depth,a.Parent_Id as Parent,a.Name as Category, REPLACE(REPLACE(a.Name,',',''),'-',' ') LIKE '' as Selected, REPLACE(LOWER(a.Name), '&', 'and') as CategoryURL,a.Weight,a.Womens_Product,a.Mens_Product, b.Mens_Total as mensTotal,b.Womens_Total as womensTotal,b.Unisex_Total as unisexTotal FROM `dt_category` a, `dt_category-websites` b WHERE a.Displayed='Yes' AND a.id=b.Category_Id AND b.Displayed='Yes' AND b.Website='garmsandswagga' AND (b.Womens_Total!=0 or b.Mens_Total!=0 or b.Unisex_Total != 0) ORDER BY a.Name ASC )

(SELECT DISTINCT a.id,a.depth,a.Parent_Id as Parent,a.Name as Category, REPLACE(REPLACE(a.Name,',',''),'-',' ') LIKE '' as Selected, REPLACE(LOWER(a.Name), '&', 'and') as CategoryURL,a.Weight,a.Womens_Product,a.Mens_Product, b.Mens_Total as mensTotal,b.Womens_Total as womensTotal,b.Unisex_Total as unisexTotal FROM `dt_category` a, `dt_category-websites` b,`dt_brands` d, `dt_product` e WHERE a.Displayed='Yes' AND a.id=b.Category_Id AND b.Displayed='Yes' AND b.Website='garmsandswagga' AND (b.Womens_Total!=0 or b.Mens_Total!=0 or b.Unisex_Total != 0)AND (d.Brand_Name LIKE 'bench' or d.Brand_Name LIKE 'bench') AND a.Name = e.Category AND d.displayed='Yes' AND e.Displayed = 'Yes' AND e.Brand_Name = d.Brand_Name ORDER BY a.Name ASC )

- | Garmsandswagga
Sharpest Fashions

Bench Black Mens Jacket Size L

Main Category -

Category -

Price: £55.00£$¥
Soft fabric with a water repellent finishRegular fitHood with stretchy drawstring and standing collar, two zip pockets on the front, the jacket can be folded down very small and stored in its own zipped compartment, stretchy sleeve cuffs, Bench print on the chest, stretchy drawstring on the hem100% polyesterMachine wash at 30°C; do not use bleaching agents; do not tumble dry; iron at low heat; do not dry cleanThe model is 1.89m tall (6’2”) and wears size M
Go To Bench Store
 

 

Share

.
Designed & Built by: Web Juice: Web Development