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

Men Super Light Jacket NJA-3177003

Item no.NJA-3177003

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