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 = '310'
SAFI is a leading Halal brand which consists of a unique and comprehensive range of skincare, personal care and toiletry products developed exclusively to meet the needs of modern Muslim women and men. Made with the finest natural ingredients that co...nfirm to Syarak requirements and certified HALAL by JAKIM, SAFI is firmly steeped in Muslims traditions with products that are alcohol and gelatin-free. With the tagline Selamat dan Suci, which means “Safe and Pure”, as the driving force behind the brand, SAFI ensures that its products are stringently developed to care for the well-being of its
