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

Women Polo T-shirt NTA-3247020

Item no.NTA-3247020

Color:
Size:
S M L XL XXL

~Soft, comfortable, lightweight cotton knited fabric
~Easy-care fabric
~3 button placket

No technology applied.
17SS