String sql = "select * from ( "
                    + " select MES.KSTUDBUSENTID, "
                    + " P.SURNAME || ', ' || P.INITIALS || ' ' || CD.CODESHORTDESCRIPTION STUDENTNAME, "
                    + " MES.KENROLSTUDID, "
                    + " MPOU.FMODULEAPID MODULEAPID, "
                    + " C.COURSECODE || ' ' || CL.COURSELEVEL || ' ' || M.COURSEMODULE MODULENAME, "
                    + " MES.DATEENROL REGISTRATIONDATE, "
                    + " OUN.KORGUNITNUMBER CAMPUSID, "
                    + " OUN.SHORTNAME CAMPUS, "
                    + " PL.FLANGUAGECODEID MODULELANGID, "
                    + " CD2.CODESHORTDESCRIPTION MODULELANG, "
                    + " POUEPC.KENROLMENTPRESENTATIONID, "
                    + " (select count(1) "
                    + "   from MODULEENROLPRESENTCATEGORY MEPC "
                    + "   left join MODULESTUDYMATERIAL MSM on MSM.KACADEMICPROGRAMID = MEPC.FSTUDYMATERIALAPID "
                    + "   where MEPC.FENROLMENTPRESENTATIONID = POUEPC.KENROLMENTPRESENTATIONID "
                    + "   and MEPC.STARTDATE >= ? and (MEPC.ENDDATE is null or MEPC.ENDDATE >= ?) "
                    + "   and MEPC.FSTUDYMATERIALAPID is not null "
                    + "   and MSM.STARTDATE >= ? and (MSM.ENDDATE is null or MSM.ENDDATE >= ?)) STUDMATCNT "
                    + " from MODULEENROLSTUD MES "
                    + " left join STUDENTMODULESTUDYMATERIAL SMSM on MES.KENROLSTUDID = SMSM.KENROLSTUDID "
                    + " left join MODULESTUDYMATERIAL MSM on MSM.KACADEMICPROGRAMID = SMSM.KMODULESTUDYMATERIALAPID "
                    + "      and MSM.STARTDATE >= ? and (MSM.ENDDATE is null or MSM.ENDDATE >= ?) "
                    + " left join PARTY P on P.KBUSINESSENTITYID = MES.KSTUDBUSENTID "
                    + " left join PRESENTOUENROLPRESENTCAT POUEPC on POUEPC.KENROLMENTPRESENTATIONID = MES.FENROLMENTPRESENTATIONID "
                    + "      and POUEPC.STARTDATE <= ? and (POUEPC.ENDDATE is null or POUEPC.ENDDATE >= ?) "
                    + " left join MODULEPRESENTINGOU MPOU on MPOU.KPRESENTINGOUID = POUEPC.FMODULEPRESENTINGOUID "
                    + "      and MPOU.STARTDATE <= ? and (MPOU.ENDDATE is null or MPOU.ENDDATE >= ?) "
                    + " left join MODULE M on M.KACADEMICPROGRAMID = MPOU.FMODULEAPID "
                    + " left join ORGUNITINSTANCE OUI on OUI.KBUSINESSENTITYID = MPOU.FBUSINESSENTITYID "
                    + "      and OUI.STARTDATE <= ? and (OUI.ENDDATE is null or OUI.ENDDATE >= ?) "
                    + " left join ORGUNITNAME OUN on OUN.KORGUNITNUMBER = OUI.FSITEORGUNITNUMBER "
                    + "      and OUN.KSYSTEMLANGUAGECODEID = ? and OUN.KSYSTEMLANGUAGECODEID = ? "
                    + "      and OUN.KSTARTDATE <= ? and (OUN.ENDDATE is null or OUN.ENDDATE >= ?) "
                    + " left join CODEDESCRIPTION CD on P.FTITLECODEID = CD.KCODEDESCID and CD.KSYSTEMLANGUAGECODEID = ? "
                    + " left join COURSELEVEL CL on CL.KACADEMICPROGRAMID = M.FCOURSELEVELAPID "
                    + " left join COURSE C on C.KACADEMICPROGRAMID = CL.FCOURSEAPID "
                    + " left join PRESENTATIONLANGUAGE PL on PL.KPRESENTATIONLANGUAGEID = MES.FPRESENTATIONLANGUAGEID "
                    + "      and PL.STARTDATE <= ? and (PL.ENDDATE is null or PL.ENDDATE >= ?) "
                    + " left join CODEDESCRIPTION CD2 on CD2.KCODEDESCID = PL.FLANGUAGECODEID and CD2.KSYSTEMLANGUAGECODEID = ? "
                    + " where MES.STARTDATE >= ? and (MES.ENDDATE is null or MES.ENDDATE <= ?) "
                    + " and SMSM.KSTUDMODSTUDYMATERIALID is null and MSM.FITEMCODE is null "
                    + " and MES.FACKTYPECODEID = 0) "
                    + " where STUDMATCNT > 0 "
                    + " order by MODULENAME, KSTUDBUSENTID ";