ID_, ESTIGATION_NAME_, SCORING_YEAR_, SCORING_QUARTER_, SCORING_MONTH_, SCORING_DATE_, SIGNIFICANT_, CLASSIFIED_, INVESTIGATION_CONCLUSION_, REMARKS_, STATUS_, AUDIT_TIME_, IS_DELE_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_DEPT_ID_, CREATE_DEPT_NAME_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_DEPT_ID_, UPDATE_DEPT_NAME_, UPDATE_TIME_, LAST_TIME_ select m.*,l.OPERATE_DATE_ from biz_reform_satisfaction_management m LEFT JOIN ( SELECT * FROM ( SELECT BIZ_ID_, OPERATE_DATE_, row_number() over ( PARTITION BY BIZ_ID_ ORDER BY CREATE_TIME_ DESC ) AS num FROM BIZ_ACHIEVE_STATUS_LOG WHERE STATUS_ = 1 ) WHERE num = 1 ) AS l ON m.ID_ = l.BIZ_ID_ ${ew.customSqlSegment} SELECT s.* FROM BIZ_REFORM_SATISFACTION_MANAGEMENT s inner join ( SELECT MAX(CREATE_TIME_)CREATE_TIME_ , SCORING_YEAR_, SCORING_QUARTER_ FROM BIZ_REFORM_SATISFACTION_MANAGEMENT WHERE STATUS_=5 AND IS_DELE_='0' GROUP BY SCORING_YEAR_, SCORING_QUARTER_ )tab on tab.CREATE_TIME_ =s.CREATE_TIME_ and s.SCORING_YEAR_=tab.SCORING_YEAR_ and s.SCORING_QUARTER_ = tab.SCORING_QUARTER_ WHERE s.STATUS_=5 AND s.IS_DELE_='0'