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 = '45'
Hovid (formerly known as Ho Yan Hor) is the leading pharmaceutical manufacturing company in Malaysia that produces more than 400 products in generic drugs, dietary supplements and consumer products. Hovid’s strength as a branded generic pharmaceuti...cal producer rests with proven capability in product research and development, distribution network in both local and export market for more than 50 countries. With the motto of "Continuous Innovation & Quality", Hovid is committed to ensuring a consistent level of quality in its products or services.
