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 = '2008'
It’s been an incredible journey over the last 50 years, a time of exploration, discovery, excitement and courage. An unwavering search across the globe to find world-class ingredients, an ongoing evolution to stay at the forefront of innovation and... a never-changing commitment to support and lead change within the wellness industry. We’ve proudly done all this and more, so we can continue to create what sits at the very heart of Swisse. Premium quality products that support and assist wellbeing and health.