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 = '1813'
Procter & Gamble launches Safeguard Deodorant and Antibacterial soap in the U.S. in response to increasing consumer demands for odor and germ protection. Clinical tests reveal that Safeguard reduces bacterial skin count by 99.3%. Learn more about the... relationship between germs and body odor.
