Dear Valued Customer, In conjunction with the Chinese New Year celebration, please note that orders placed between 22nd January till 2nd February 2025 on our online platform will be shipped starting 3rd February 2025 onwards. We apologize for any inconvenience this may cause and thank you for your understanding. Wishing you a prosperous Chinese New Year!
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.
