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

Women Quick dry Polo T-Shirt NTA-3247014

Item no.NTA-3247014

Color:
Size:
S M L XL XXL

~High moisture absorbency knitted fabric
~Bamboo fiber with odor neutralization
~Quick dry materials
~Zippered chest pocket
~3 button placket

No technology applied.
17SS