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=1606==========0123
~Water resistant and windproof super light fabric ~Zippered chest pocket, pack into pocket ~Attached adjustable hood ~Elastic cuff ~Drawcord adjustable hem ~Ventilative mesh patch at armpit ~Reflective print on back