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 = '2174'
Established in 1925, Megmilk Snow Brand Co Ltd is one of Japan’s leading dairy foods manufacturer. With over 90 years of experience in producing dairy products, Megmilk Snow Brand has demonstrated an unwavering commitment to the research, innovatio...n, and development of quality dairy products. With a mission to contribute to society, Megmilk Snow Brand aims to bring healthier and happier lives to people around the world by harnessing the goodness of milk.
