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=1664==========

Women 2 in 1 All Condition Jacket vNJB-3217042

Item no.NJB-3217042

Size:
S M L XL XXL

Shell: 100%Polyester

Lining: Mesh in 100% Polyester

Fleece: 100% Polyester

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

No technology applied.
17FW