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 = '1345'
Since it was first launched in March 2006 in Japan, Tsubaki has created a new category of high added value hair care products. This " beautiful hair care" brand centers on making hair beautiful and shiny and has managed to pull the market along in it...s direction. The brand is focused on the idea of helping every woman unleash their hairs' potential to become beautiful.
Tsubaki or Camellia is a recognized symbol that embodies Shiseido's spirit of pursuing optimal beauty. By fusing the trademark with high-purity Tsubaki Oil EX, and new melanin reparative ingredients- Arginine, Tsubaki is designe
