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 = '1187'
Specifically designed for dry, sensitive skin, La'Miux Skin Therapist harmonizes scientific innovation with natural plant elements, striving to endow your skin with a healthy and vibrant allure. Meanwhile, La'Miux Hair Therapist, curated for your hai...r's well-being, marries science with premium ingredients, vowing to provide vibrant and strong hair after every use.
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia