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 = '1028'
Since 1941, HO YAN HOR has strived in its innovation by creating more new herbal teas, to cater to the need of old and young; people of different lifestyles and needs; keeping its one sole objective of helping everybody in the family healthy, and for... generations. HO YAN HOR is about maintaining health through Natural Healing! The founder of HO YAN HOR Herbal Tea, Dr Ho Kai Cheong, was a chinese medical practitioner who graduated from Canton Wah Lam National Physicians Medical School. With the intention of helping people, he has formulated a unique concoction of 23 specially chosen herbs and cr
