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 = '1491'
Skincode AG, a Swiss-based company founded in 1998 by a team of professionals with profound knowledge and experience in the cosmetics industry, reinforces Switzerland’s reputation for state-of-the-art skincare. The Skincode range includes two resul...ts-oriented lines to answer to your needs and to suit your personal preferences. Built on the principle that the skin is a living organ and its genetic “code” must be respected, the collections provide consumers with high-performance, innovative skincare products reflecting the precision, purity and quality that are synonymous with Switzerland.
