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 = '913'
Pantene is a brand of hair care products owned by Procter & Gamble. The product line was first introduced in Europe in 1945 by Hoffmann-La Roche, which branded the name based on panthenol as a shampoo ingredient. It was purchased by Procter & Gamble ...in 1985 in order to compete in the "beauty product" market rather than only functional products. The brand's best-known product became the 2-in-1 shampoo and conditioning formula, Pantene Pro-V (Pantene Pro-Vitamin). The product became most noted due to an advertising campaign in the 1989.
