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

Women Super Light Jacket NJA-3277006

Item no.NJA-3277006

Color:
Size:
S M L XL XXL

~Water resistant and windproof super light fabric
~Attached hood, can stows in collar design
~Elastic cuff
~Drawcord adjustable hem
~Pack into back pocket

No technology applied.
17SS