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 = '238'
Antabax is well-known and respected among consumers and the industry, having received a slew of awards and accolades from 2010 to 2016, including The BrandLaureate Awards 2010-2016 for 'The Best Brands in Consumer - Personal Care' category, The Malay...sia Good Design 2011 Award, Cleo Magazine's The Beauty Hall of Fame 2011 Award for Best Antibacterial Soap', and Her World Beauty Awards 2010-2016 for 'Best Antibacterial Shower'.
