id_, year_, position_id_, subject_ids_, sn_, memo_, is_dele_, create_by_, create_org_id_, create_time_, update_by_, update_time_, version_ SELECT o.user_id_, u.fullname_ AS userName, o.pos_id_, u.account_ FROM uc_org_user o LEFT JOIN uc_user u ON u.id_ = o.user_id_ WHERE o.pos_id_ = #{positionId} SELECT DISTINCT s.*,y.id_ as id,y.year_,s.id_ as subjectId FROM exam_subject_info s LEFT JOIN exam_year_assessment_sub y ON y.subject_ids_ = s.id_ LEFT JOIN exam_subject_pos po on po.subject_id_ = s.id_ ${ew.customSqlSegment}