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 = '1797'
Sudocrem is an over-the-counter medicinal cream that is primarily used to treat diaper rash. It has a water-repellent basis (oils/waxes), protecting and emollient agents, antibacterial and antifungal agents, and a mild anaesthetic. It can also be use...d to treat eczema, bedsores, minor burns, surface wounds, sunburn, and chilblains in addition to nappy rash.
