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 = '972'
Head & Shoulders helps eliminate scalp dryness, itch and irritation, for hair that's 100% flake-free with regular use. Since 1950, Head & Shoulders has been at the forefront of scalp and hair science, significantly advancing the treatment of dandruff... and leaving scalp in good condition and moisture balanced. Along with professional advice and expert insight, head & shoulders has a wide range of products to care for your scalp and nurture your hair.
