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 = '1577'
It all began when Allliance Cosmetics noticed that the mass color cosmetics market was dominated by international brands and decided to launch its own brand.
In May 2005, SILKYGIRL cosmetics was launched simultaneously across Malaysia, Singapore and... Brunei.
SILKYGIRL is created specially for young Asian women, with the desire to help them define their own unique personality through a fusion of products and colors.
