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 = '1482'
Valens Nutrition is a range of science-based nutrition products and solutions that has been widely used by healthcare professionals and institutions for over 15 years.
Valens collaborates closely with leading medical and nutrition experts in develop...ing and distributing all of its products. Valens products are also widely used in hospitals and long-term care facilities for oncology, surgery, wound care, ICU, paediatrics, geriatrics, dialysis and more.
