SELECT i.*,c.color_name,c.color_image FROM va_items_images AS i LEFT JOIN va_colors AS c ON (i.color_id = c.color_id) WHERE i.item_id=1660==========01

Men All Condition Jacket NJB-3117038

Item no.NJB-3117038

Color:
Size:
S M L XL XXL

100%Polyester

Lining: Mesh in 100% Polyester

~Detachable down or fleece jacket
~ 2 layers fabric with waterproof/breathability up to 3000g/m²/24Hrs
~Seam sealed technology
~Adjustable hem and hood       
~Attached hood

No technology applied.
17FW