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 = '173'
Made for your loved ones, Agnesia’s range of products are specially formulated to help relieve skin irritation, yet is gentle even on sensitive skin. Agnesia has been part of the daily routine that bridges generations. Such joy to see the young one...s smile. Relieved, comforted, they now in turn show you their love and appreciation.
