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 = '81'
Listerine is an American brand of antiseptic mouthwash that is promoted with the slogan "Kills germs that cause bad breath", Named after Joseph Lister, who pioneered antiseptic surgery at the Glasgow Royal Infirmary in Scotland, Listerine was develop...ed in 1879 by Joseph Lawrence, a chemist in St. Louis, Missouri. Originally marketed by the Lambert Pharmacal Company (which later became Warner–Lambert), Listerine has been manufactured and distributed by Johnson & Johnson since that company's acquisition of Pfizer's consumer healthcare division on December 20, 2006. The Listerine brand name is
