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 = '502'
Love Earth providing healthy food products, to maintain one's health. We embarked on this journey back in March 2011. With a simple mindset of "We want to make this world a better place. We want everyone to be healthier.", we thought we would be able... to conquer the world. We are distributing to more than 1,000 outlets. Trusted by more than 1,000,000 consumers. Sell 3 units every 1 minute.
