select r.curriculumId, r.curriculumName, c.ImageLogoID, r.curriculumText, c.courseid, rc.sequenceNumber courseSequence, c.coursename, c.descriptionText, m.moduleId, m.moduleName, r.SynopsisText, sms.lastSectionId, sms.quizCompleted, sms.lastSectionId, m.quizid, p.Image, COALESCE(r.ExplicitEnrollment, 'N') AS ExplicitEnrollment, COALESCE(r.GroupID, 0) AS GroupID from tbl_TRN_Courses c inner join tbl_TRN_Course_Modules cm on cm.courseid = c.courseid inner join tbl_TRN_Modules m on m.moduleid = cm.moduleid and m.ownerid = c.ownerid and m.ownerType = c.ownerType inner join tbl_TRN_Curriculum_Courses rc on rc.courseid = c.courseid inner join tbl_TRN_Curriculums r on r.curriculumid = rc.curriculumid left outer join qryImageFullPathLookup p ON c.ImageLogoId = p.ImageID left outer join ( select s.curriculumId, sm.moduleId, sm.quizCompleted, sm.lastSectionID from tbl_TRN_Students s inner join tbl_TRN_Student_Modules sm on sm.studentId = s.studentid where s.fspro_userid = ) sms on sms.moduleid = m.moduleId and sms.curriculumid = r.curriculumId where r.ownerid = and r.ownerType = and r.approvedFlag IN () and getdate() <= r.PublicationEndDate and getdate() >= r.PublicationStartDate order by r.SortRank, rc.sequenceNumber, c.courseName, cm.sequenceNumber, m.moduleName SELECT * FROM qcf_tempCurriculumSchedule WHERE ExplicitEnrollment = 'N' OR ( ExplicitEnrollment = 'Y' AND GroupID IN () )