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 = '2898'
Makarizo is empowering the exploration and transformation of beauty. The complete range of Makarizo products suit different types of hair. MAKARIZO divided into two, Hair Energy (for consumer use) and Professional (for salon use). MAKARIZO Hair Energ...y awalys offers liveliness and audacity for those who are eager for something Fun and Energetic yet Sincere! Hair Energy series has a fresh new take on everything from its ingredients’ story, to its youthful, eye-popping Orange packaging, sensorial and surprising formulations and scents!
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia