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

Women All Condition Jacket NJB-3217041

Item no.NJB-3217041

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