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 = '2728'
Sambucol® is the product of over 20 years of research that has been developed by scientists and is recommended by experts, making it the most extensively researched elderberry product in the world. It is clinically proven to support everyday immunit...y besides speeding up recovery and reduce the severity of cold and flu symptoms.
