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 = '472'
Shokubutsu Monogatari is a Japanese word that means plant story. It symbolizes the founding ideal of Lion Japan, which is to produce mild, high-quality body washes using only plant-based ingredients. In 1992, Lion Japan introduced the Shokubutsu Mono...gatari brand of cosmetic soaps. As the first body wash comprised entirely of cleansing plant materials, Shokubutsu was introduced in Malaysia in 1998. Shokubutsu strives to provide the most pleasurable showering experience possible, with opulent foam volume, simple rinsing, and a revitalizing after-shower sensation. Shokubutsu Fresh Rice is synonym
