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 = '1761'
Sunsweet is the world’s largest and most famous brand of dried tree fruits including prunes, apricots, mangos, and more. Sunsweet Growers Inc. a grower-owned cooperative represents more than 25% of the prune market worldwide. We process nearly 60,0...00 tons of famous Sunsweet Prunes a year! Staying close to our customers is important. That’s why Sunsweet products can be purchased at most supermarkets, or online.
