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, p.Image 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 getdate() <= r.PublicationEndDate and getdate() >= r.PublicationStartDate order by rc.sequenceNumber, c.courseName, cm.sequenceNumber, m.moduleName