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 = '2682'
With an in-house team of medical education experts and gynaecologists, UUcare has made women's health its main objective. From sanitary pads to intimate wear, UUcare aims to provide women across Asia and beyond with the comfort, health and product sa...fety they truly deserve.
