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 = '2256'
HOE Pharmaceuticals was founded in 1979. From our humble beginning, we have provided high quality products with affordable price. Our product range have expanded over the years through innovation. Combined with strong commitments to our customers, we... set the standards that have ingrained in our culture and practices. We have been focusing on dermatological products since those early days. Now, we have transformed the company into a modern, dynamic force with an objective of becoming one of the leading suppliers of dermatological products in the world.
