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 = '1245'
Lux has been composing beauty products since 1924, when it launched the world's first mass-market beauty soap, “made like the costliest French soap”. Since then, it has been associated with over 400 of the world’s most glamorous celebrities fro...m Brigitte Bardot to Marilyn Monroe to Aishwarya Rai to become the world’s best selling soap bar, delighting women in over 100 countries every day
