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=1638==========01

Men Beach Slippers BS-5137025

Item no.BS-5137025

Color:
Size:

~Flip Flops design to fulfill convenience needs
~Durable and light PU materials
~Soft EVA  outsole for cushioning and comfortable

~Size: 39-44

No technology applied.
17SS