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=1668==========

Women Fleece Jacket NJB-3227049

Item no.NJB-3227049

Size:
S M L XL XXL

100% Polyester

~Thicken and warmth fabric
~Attached hood with drawcord

No technology applied.
17FW