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 = '89'
For over 90 years, Hansaplast has been committed to serving the actual needs of real people and providing them with the highest possible product quality. From discovering the first plaster to becoming the world’s number one trusted plaster expert, ...Hansaplast has always had an open ear for feedback from consumers and professionals alike, actively integrating their requests in the product design.
Today, Hansaplast is sold in more than 90 countries, with products now ranging from wound healing to pain relief, from footcare to noise reduction. We are dedicated to globally facilitating the liv
