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=1659==========01

Men 3 in 1 All Condition Jacket NJB-3117037

Item no.NJB-3117037

Color:
Size:
S M L XL XXL

100% Polyester

Lining: Mesh in 100% Polyester

Fleece Jacket: 100% Polyester

Padded Vest: 100% Polyester

~"3 in 1" zip in jacket, with detachable fleece jacket and padded vest
~ 2 layers fabric with waterproof/breathability up to 3000g/m²/24Hrs
~Seam sealed technology
~Adjustable cuff, hem and hood       
~Detachable hood

No technology applied.
17FW