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 = '588'
Started as a pioneer in the Organic Food Industry for 23 years since its inception in 1998, Country Farms is laser- focused on its sole goal to promote healthier lifestyle by offering high quality and easily accessible health food, wellness products ...and consumer goods. Since 2018, Country Farms’ quest to deliver enrichment to our customers’ everyday life has driven us to explore into the Functional Food, Solution-based Offering and Plant-based Protein sphere, in addition to Organic and Natural products, that address the dietary science of food and wellness, delivering wellness and function
