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 = '414'
BONLIFE offers balanced natural products for you. Enjoy organic, wholesome milk and supplements. At Bonlife, we create the Art of Balanced Living. We aim to create a healthy nation by creating awareness and educating the public at large on the import...ance of health care which encom passes health food consumption, lifestyle and caring for the environment. Furthermore, we continue to expand the efforts in research and development to produce quality health food for optimum health.
