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 = '990'
Naturie is a brand that focuses on hydration and retention of the skin. Using natural ingredients like Hatomugi better known as Job's Tear extract and continuous development on their products. This lead to multi award-winning products. Naturie believ...es that moisture is the basis for creating beautiful skin.
