$this->db->query("SELECT a.*,
                             n.*,

                             FROM tbl_systemstatus s
                             INNER JOIN newsystem n ON n.systemID = s.id

                             WHERE s.status = 'CISO Approved' ORDER BY s.id DESC LIMIT 1
                    ");