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

Men Super Light Jacket NJA-3177002

Item no.NJA-3177002

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

No technology applied.
17SS