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 = '343'
Betadine® has been the trusted brand in hospitals for over 50 years and is your first line of defense to help prevent infection when treating a minor cut, scrape or burn. Betadine contains the active ingredient povidone-iodine (PVP-I), to help treat... and prevent infection in minor cuts, scrapes and burns. Iodine in PVP-I gives Betadine the signature golden-brown color that lets you know where the product has been applied and that it is working. Betadine products do not contain alcohol or hydrogen peroxide, which can sting when applied. Betadine has a no-sting promise.