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 = '1832'
Sunmaid
Sun-Maid is the timeless and trusted go-to snack that's simple, healthy and versatile. Remember the childhood snack that generations have grown up with.
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia
FREE 1 x Ocean Spray Dried Cranberries (Blueberry) 142g
with min spending of RM25 & above