select m.manufacturers_id, m.manufacturers_name, m.address_key, mi.manufacturers_meta_title, mi.manufacturers_meta_descp, mp.manufacturersportion_image from manufacturers m left join manufacturers_portion mp on m.manufacturers_id = mp.manufacturers_id and mp.manufacturersportion_position = 'Left Menu', manufacturers_info mi where m.manufacturers_id = mi.manufacturers_id and m.manufacturers_id = '319'
BATISTE
"We're Batiste, the in-between washes hair care experts. Batiste is the world's No.1 dry shampoo brand. We exist to create hair care routines with convenient, in-between washes solutions for fabulous looking and feeling hair (yes, you heard!). ...
WhatsApp
Item added to your cart.





Checkout Continue Shopping
This item has been saved to your wishlist.



View My Wishlist Continue Shopping