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 = '3373'
Treecell, a lifestyle brand under Mediheal beauty science.
Treecell- Refresh Moments.
Daily- We present moments full of energy and satisfaction in your daily life so you would not follow the standards made by others but live as yourself.
Liv...ely- Treecell believes that it is most important to keep treecell products close and always together for the energy-filled daily life of all of us.
Only- To this end, we provide the most functional, aesthetic products through repeated and complete tests as well as using natural ingredients and fragrances.
