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 = '3001'
Kafen
Kafen's hair care products specialize in hydrating, locking in moisture, cleansing the scalp and keeping your hair healthy. Kafen products have been backed by a number of notable Taiwanese celebrities like Ina Yen and Amber Chen.
Happening Now
FREE SHIPPING
Enjoy RM6 OFF on Shipping Fee for orders over RM100, available for both West and East Malaysia