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 = '50'
At Citrex, we aim to shape a better future by empowering healthier lifestyle. One of our core values and we strive to provide superior health solutions and products that would enrich one’s health. We are committed and our products are crafted with ...consumers as our top priority.
