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 = '1421'
Selsun Blue is an over-the-counter brand of dandruff shampoo now owned by Sanofi. First made by Abbott Laboratories, the brand was bought by Chattem in 2002. Chattem was acquired by Sanofi in 2010, although in some markets, it is sold by Rohto Pharma...ceutical instead. Selsun Blue has been marketed as a more effective alternative to brand leader Head & Shoulders due to its superior performance in randomized trials.
