id_, user_id_, user_name_, study_file_id_, user_account_, learning_start_time_, learning_end_time_, learning_time_, learning_finish_status_, task_status_, file_type_, learning_start_pace_, learning_end_pace_ SELECT e.id_, e.code_, e.name_, e.parent_id_, e.full_id_, e.full_name_, e.has_children_, e.sn_, SUM(l.video_time_) as totalTime, SUM(l.study_time_) as studyTime, e.is_dele_ FROM exam_freshman_subject e LEFT JOIN biz_train_data_study_log l on e.id_ = l.subject_id_ WHERE (e.parent_id_ = '' or ISNULL(parent_id_)) -- 获取公司级 部门级顶层 OR l.task_id_ = #{taskId} GROUP BY e.id_ SELECT es.id_, es.code_, es.name_, es.parent_id_, es.full_id_, es.full_name_, es.has_children_, es.sn_, SUM(l.video_time_) as totalTime, SUM(l.study_time_) as studyTime, es.is_dele_ FROM exam_subject_info es LEFT JOIN biz_train_data_study_log l on es.id_ = l.subject_id_ WHERE (es.parent_id_ = '' or ISNULL(es.parent_id_)) -- 获取公司级 部门级顶层 OR l.task_id_ = #{taskId} GROUP BY es.id_