id_, code_, name_, train_type_, train_level_, user_type_, major_id_, pos_id_, memo_, sn_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_ SELECT e.id_ as id, e.name_, '0' AS parent_id_, e.create_time_, '1' as type FROM exam_subject_sys t LEFT JOIN exam_equipment_sys e ON T.major_id_ = e.id_ WHERE e.is_dele_ = '0' GROUP BY e.name_ ,e.id_ UNION ALL SELECT o.id_ as id, o.pos_name_ as name, e.sys_id_ AS parent_id_, o.create_time_, '2' as type FROM exam_pos_sys e LEFT JOIN uc_org_post o ON o.id_ = e.pos_id_ WHERE o.is_dele_ = '0' GROUP BY o.pos_name_ ,o.id_,e.sys_id_ SELECT s.* FROM exam_subject_info s LEFT JOIN exam_subject_pos p on p.subject_id_ = s.id_ where p.major_id_ in #{id} SELECT sp.*, s.name_ AS majorName, op.pos_name_ AS positionName, op.code_ as positionCode FROM exam_subject_pos sp LEFT JOIN exam_equipment_sys s ON s.id_ = sp.major_id_ LEFT JOIN uc_org_post op ON op.id_ = sp.position_id_ where sp.subject_id_ = #{id} SELECT DISTINCT s.* FROM exam_subject_info s LEFT JOIN exam_subject_sys sp on sp.subject_id_ = s.id_ LEFT JOIN exam_subject_pos po on po.subject_id_ = s.id_ ${ew.customSqlSegment} SELECT u.id_ AS userId, u.FULLNAME_ AS userName, u.account_ as account, ou.pos_id_ AS positionId FROM uc_user u inner JOIN uc_org_user ou ON ou.user_id_ = u.id_ inner JOIN (SELECT s.position_id_ FROM exam_subject_pos s WHERE s.subject_id_ IN #{id} GROUP BY s.position_id_) sp on sp.position_id_ = ou.pos_id_ SELECT s.* FROM exam_equipment_sys s LEFT JOIN exam_subject_sys sp ON sp.major_id_ = s.id_ WHERE sp.subject_id_ = #{id} SELECT DISTINCT s.* FROM (SELECT s.* FROM exam_subject_info s WHERE s.id_ not in (SELECT subject_id_ FROM exam_paper_base WHERE paper_type_ ='2' and is_dele_ ='0' and id_ != '1597796798347481088' AND create_time_> date_trunc('year', now()) and date_trunc('year', now()) +interval '1 year' > create_time_)) s LEFT JOIN exam_subject_sys sp on sp.subject_id_ = s.id_ ${ew.customSqlSegment} SELECT id_ FROM uc_org_job WHERE name_ =#{userTypeId} SELECT id_ FROM uc_org_post WHERE pos_name_ IN #{posName} SELECT count(DISTINCT s.*) FROM exam_subject_info s left JOIN exam_subject_pos p on p.subject_id_ = s.id_ -- left JOIN exam_subject_sys ss on ss.subject_id_ = s.id_ WHERE s.name_ = #{name} and s.id_ != #{id} and p.position_id_ in #{positionId} and ss.major_id_ in #{majorId} SELECT s.*,sp.subject_id_ as subjectId FROM exam_equipment_sys s LEFT JOIN exam_subject_sys sp ON sp.major_id_ = s.id_ WHERE sp.subject_id_ in #{subjectId} SELECT DISTINCT s.* FROM exam_subject_info s left JOIN exam_subject_pos p on p.subject_id_ = s.id_ left JOIN uc_org_post op on op.id_ = p.position_id_ left JOIN exam_subject_sys ss on ss.subject_id_ = s.id_ WHERE s.name_ = #{subjectName} and op.pos_name_ =#{positionName} and ss.name_ =#{majorName} and s.is_dele_ = '0' SELECT DISTINCT s.id_ AS id, s.name_ AS name, ss.major_id_ AS majorId, sp.position_id_ AS positionId, sp.org_id_ as orgId FROM exam_subject_info s LEFT JOIN exam_subject_sys ss ON ss.subject_id_ = s.id_ LEFT JOIN exam_subject_pos sp ON sp.subject_id_ = s.id_ where s.is_dele_ ='0' ORDER BY s.name_ desc SELECT o.* FROM uc_org o WHERE o.is_dele_ = '0' SELECT DISTINCT s.id_ as id, s.name_ AS name, ps.org_id_ AS parentId FROM exam_equipment_sys s LEFT JOIN exam_pos_sys ps ON ps.sys_id_ = s.id_ WHERE s.is_dele_ = '0' SELECT p.id_ as id,p.pos_name_ as name,p.org_id_ as orgId FROM uc_org_post p WHERE p.is_dele_ = '0' SELECT s.id_ FROM uc_org_post s WHERE s.pos_name_ = #{positonNames} AND s.org_id_ =#{orgId} SELECT * FROM ( SELECT u.id_ as id, u.fullname_ AS userName, u.phone_ AS phone, u.account_ as account, u.sex_ AS sex ,s.subjectName FROM uc_user u INNER JOIN uc_user_role ur ON u.ID_ = ur.USER_ID_ INNER JOIN UC_ROLE r ON ur.ROLE_ID_ = r.ID_ LEFT JOIN ( SELECT coach_id_, string_agg ( name_, ',' ) AS subjectName FROM exam_subject_info GROUP BY coach_id_ ) s on s.coach_id_ = u.id_ WHERE u.IS_DELE_ != '1' AND ur.IS_DELE_ != '1' AND r.IS_DELE_ != '1' AND u.STATUS_ = 1 AND r.code_ = 'jly') s ${ew.customSqlSegment}