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 = '1337'
With a portfolio of famous products that improve the lives of both men and women globally, Revlon Consumer Products LLC is a prominent global beauty corporation. Through a diverse portfolio of 15+ brands marketed in more than 150 countries, our compa...ny makes and promotes colour cosmetics, hair colour and care, skincare, beauty care, and fragrances.
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia