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 = '1900'
We’re a social skincare brand focusing on the new generation. Fun-driven, cross-over trends, styled designs and all innovative topics and products surrounding the life of the young are motivating us forward. We look forward to building a platform f...or conversations with you that create beauty inspirations and explore more profound and rich skincare experiences. We are loyal to the rule of never play by the rules. Ujelly is a brand born with audacity for experiments, passion for the pursuit of beauty, and interest in surprises. Imperfection can be fun along the journey. Skincare rituals are in
