Change Currency: 
 
100% High quality Military C$ja-38776 - Outerwear - TB577 Men - Scotch & Soda Down Parka - Clothing 2011,2001,2010,2018,2008

100% High quality Military C$ja-38776 - Outerwear - TB577 Men - Scotch & Soda Down Parka - Clothing 2011,2001,2010,2018,2008

C $352.12  C $190.33


Take Your Choose:



Add to Cart:

  • jklshjl-80638776
  • 101 Units in Stock

A heavy-duty Scotch & Soda parka crafted in padded technical twill. An inset wire shapes the lined drawstring hood. Heavy-duty front zip and 4 front pockets. Double-button cuffs. Down-filled quilted lining.Fabric : Technical twill.Shell : 55% polyester/45% cotton.Lining : 100% nylon.Fill : 70% feathers/30% down.Dry clean.Made in Portugal.MeasurementsLength : 32in / 81cmSleeve : 33in / 84cmChest : 43.25in / 110cmMeasurements from size M

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'taxrexzf_jhc1zy.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '7220' and opa.orders_id = opb.orders_id and opb.products_id != '7220' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]