Query Get Kurikulum by Semester

SELECT mkr.id_mk,mkr.id_kurikulum_sp, kr.nm_kurikulum_sp, mkr.smt, mk.kode_mk, mk.nm_mk, mkr.sks_mk,
        kr.nm_kurikulum_sp||' / '||mk.kode_mk||' - '||mk.nm_mk||' ('||mkr.sks_mk||' SKS)' as mk
FROM matkul_kurikulum AS mkr
LEFT JOIN kurikulum AS kr ON mkr.id_kurikulum_sp=kr.id_kurikulum_sp
LEFT JOIN mata_kuliah AS mk ON mkr.id_mk=mk.id_mk
WHERE mkr.soft_delete='0'
AND smt%2=0
ORDER BY mkr.smt ASC


Active Record CI
===========================================
$this->db->select('mkr.id_mk,mkr.id_kurikulum_sp, kr.nm_kurikulum_sp, mkr.smt, mk.kode_mk, mk.nm_mk, mkr.sks_mk,
                            kr.nm_kurikulum_sp||\' / \'||mk.kode_mk||\' - \'||mk.nm_mk||\' (\'||mkr.sks_mk||\' SKS)\' as mk',FALSE)
                ->from($this->table_mkr.' AS mkr')
                ->join($this->table_kr.' AS kr','mkr.id_kurikulum_sp=kr.id_kurikulum_sp','left')
                ->join($this->table_mk.' AS mk','mkr.id_mk=mk.id_mk','left')
                ->where('mkr.soft_delete','0')
                ->where('mkr.smt%2',0,FALSE)
                ->order_by('mkr.smt','ASC');