id_, sys_id_, pos_id_, job_id_ SELECT sp.*, s.name_ AS majorName, sp.pos_id_ as positionId, op.code_ as positionCode, op.pos_name_ AS positionName FROM exam_pos_sys sp LEFT JOIN exam_equipment_sys s ON s.id_ = sp.sys_id_ LEFT JOIN uc_org_post op ON op.id_ = sp.pos_id_ WHERE sp.sys_id_ =#{id} SELECT op.pos_name_ AS positionName, op.id_ AS positionId FROM uc_org_post op INNER JOIN ( SELECT DISTINCT sp.pos_id_ AS positionId FROM exam_pos_sys sp where sp.sys_id_ in #{id} ) s on s.positionId = op.id_ SELECT org_id_ FROM uc_org_post WHERE id_ = #{positionId} SELECT id_ FROM uc_org where name_ = #{orgName} SELECT count(*) as orgCount FROM uc_org WHERE is_dele_='0' SELECT count(*) as userCount FROM uc_user WHERE is_dele_='0' SELECT count(u.*) as roleCount FROM uc_user_role u LEFT JOIN uc_role r on u.role_id_ = r.id_ WHERE r.code_='jly' and r.is_dele_='0' SELECT count(*) as sysCount FROM exam_equipment_sys WHERE is_dele_='0' SELECT count(*) as subjectCount FROM exam_subject_info WHERE is_dele_='0'