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=1608==========012

Women Super Light Jacket NJA-3277005

Item no.NJA-3277005

Color:
Size:
S M L XL XXL

~Water resistant and windproof super light fabric
~Attached pouch, easy to carry
~Attached hood
~Adjustable cuff, hem & hat
~Waist slim cut design with drawcord

No technology applied.
17SS