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
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...
Happening Now!!
WhatsApp
Item added to your cart.





Checkout Continue Shopping
This item has been saved to your wishlist.



View My Wishlist Continue Shopping