SELECT

           <!--关联班级 -->

              tc.id AS tb_class_id,tc.number,tc.name AS tc_class_name,

           <!--关联小组 -->

            sg.group_id,sg.group_name,

            <!--关联实验 -->

            e.experiment_id,e.experiment_name,e.experiment_presentation,

            <!--关联成员 -->

            sgs.group_student_id,

            <!--学生个人 -->

            si.id AS stu_id,si.name AS stu_name,

            <!--学号 -->

            u.username,

            <!--考勤 -->

              ci.clocking_id,ci.status,ci.clocking_time,

           <!--成绩 -->

              sef.submit_experiment_file_id,sef.submit_status

       FROM tb_class tc

       LEFT JOIN scourse_group sg ON sg.class_id = tc.id

       LEFT JOIN experiment e ON e.experiment_id = sg.experiment_id

       LEFT JOIN scourse_group_student sgs ON sgs.group_id = sg.group_id

       LEFT JOIN student_info si ON si.id = sgs.group_student_id

       LEFT JOIN USER u ON u.id = si.id

       LEFT JOIN clocking_in ci ON ci.student_id = si.id

       LEFT JOIN submit_experiment_file sef ON sef.submitter_id = si.id

       WHERE tc.id IN (

                  SELECT

                    DISTINCT(class_id)

                     FROM scourse_group

                     WHERE schedule_id = #{scheduleId}

              )

       AND  tc.stealth=2  AND sg.schedule_id=#{scheduleId}

       AND ci.schedule_id=#{scheduleId} AND sef.schedule_id=#{scheduleId}