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 = '510'
CHAMPS is a leading child health supplement brand with strong heritage in Malaysia. CHAMPS offers with a wide range of Vitamin C and Multivitamins products in a variety of different flavours and tablet format. CHAMPS launched the first children effer...vescent vitamin C supplement in Malaysia, 2018.
