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 = '1441'
Chriszen is a proud Malaysian cosmetic and skin care brand that is established to create creative and quality beauty products that could cater the skin of Southeast Asian females. Our great vision is to become a distinctive beauty brand across Southe...ast Asia. We customize to make Southeast Asian women feel special! We study the regional skin tone, skin condition, weather experience, as well as the changing of beauty trend.
