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!
