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 = '83'
As one of the leading companies in the field of skin care – with more than 130 years of experience – our products always cater for the needs of our consumers, who place a great deal of faith in us. Learn more about us here. What began in 1911 as ...NIVEA Creme is today a huge brand family with over 500 products. Over the decades, NIVEA has developed many innovative skin care products, and the innovations keep coming! With Natural Balance NIVEA takes on the environmental issue, a matter close to many people's hearts. It is the first highly effective NIVEA range with mainly natural ingredients,
