id_, subject_type_, subject_id_, data_type_, data_name_, data_url_, require_hours_, is_dele_, create_by_, create_name_, create_org_name_, create_company_id_, create_company_name_, create_org_id_, create_time_, update_by_, update_name_, update_company_name_, update_company_id_, update_org_id_, update_org_name_, update_time_, last_time_, tenant_id_ SELECT d.*,o.user_id_,u.fullname_ as userName,u.account_ as userAccount FROM biz_subject_data d LEFT JOIN exam_subject_info s ON d.subject_id_ = s.id_ LEFT JOIN exam_subject_pos sp ON sp.subject_id_ = s.id_ LEFT JOIN uc_org_user o ON o.pos_id_ = sp.position_id_ AND sp.org_id_ = o.org_id_ LEFT JOIN uc_user u on u.id_ = o.user_id_ WHERE d.is_dele_ != "1" AND d.train_type_ ='2' AND d.subject_type_ = 1 and sp.type_ ='1' AND s.is_dele_ != '1' AND o.is_dele_ != '1' AND o.user_id_ =#{userId} SELECT d.* FROM biz_subject_data d LEFT JOIN exam_freshman_subject s ON d.subject_id_ = s.id_ LEFT JOIN exam_subject_pos sp ON sp.subject_id_ = s.id_ WHERE d.is_dele_ = '0' AND sp.type_ = '2' AND ( sp.org_id_ IN #{orgId} AND sp.position_id_ IS NULL ) OR sp.position_id_ in #{positionId} GROUP BY d.id_ UNION ALL SELECT d.* FROM biz_subject_data d LEFT JOIN exam_subject_info si ON si.id_ = d.subject_id_ LEFT JOIN exam_subject_pos sp ON sp.subject_id_ = si.id_ WHERE d.is_dele_ = '0' AND sp.type_ = '1' AND sp.position_id_ in #{positionId} GROUP BY d.id_