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 = '3238'
SKINTIFIC is a skincare brand formulated by a group of scientists who are committed and research-proven to provide fast and safe results for all skin types, including sensitive skin. We based all our formulation on the TTE Technology (Trilogy Triangl...e Effect) that uses precise active ingredients, quickly diminish skin problem but also, intensively hydrating and calming the skin and effectively protect and improve skin barrier.
