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 = '94'
For over 100 years, Scott’s has been dedicated to helping families embrace the daily possibilities in life. Driven by our values of trust, quality and tradition, embodied by the iconic fisherman, we work tirelessly to provide the very best in every...day nutritional healthcare, keeping families healthy, protected and prepared, so they can make the most of every moment together.
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia