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 = '287'
Aveeno is an American brand of skin care and hair care products owned by American consumer goods and pharmaceutical company Johnson & Johnson. Aveeno was founded in 1945 by brothers Albert and Sidney Musher, and its first product was their Soothing B...ath Treatment. The active ingredients in all Aveeno products are colloidal oats or oat extracts — avenanthramides, which have been branded as "active naturals". The brand slogan is "Better Ingredients. Better Skincare: Aveeno." Aveeno offers products to treat skin conditions such as eczema, psoriasis, urushiol-induced contact dermatitis, pruritus
