ID_, PROJECT_ID_, PARENT_ID_, SPECIFIC_MEASURES_ID_, REFORM_SPECIFIC_MEASURES_, DISTRIBUTION_TYPE_, ITERATION_, ITERATION_ACCORDING_, ITERATION_YEAR_, ITERATION_QUARTER_, ITERATION_MONTH_, ITERATION_DATE_, STATUS_, REMARKS_, 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 h.REFORM_SPECIFIC_MEASURES_ AS newName, h.ITERATION_ACCORDING_ AS cause, j.REFORM_SPECIFIC_MEASURES_ AS oldName, h.CREATE_TIME_ AS time FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT m JOIN BIZ_PILOT_SPECIFIC_MEASURES_HISTORY h ON m.ID_ = h.PROJECT_ID_ JOIN BIZ_PILOT_SPECIFIC_MEASURES_HISTORY j ON h.SPECIFIC_MEASURES_ID_ = j.SPECIFIC_MEASURES_ID_ WHERE m.project_type_ = 1 AND m.CLOSING_ = 1 AND m.is_dele_ = '0' AND m.SEND_STATUS_ = 1 AND h.DISTRIBUTION_TYPE_ = 1 AND h.ITERATION_ = 1 AND h.IS_DELE_ = '0' AND h.STATUS_ = 5 AND j.ID_ IN (SELECT ID_ FROM (SELECT ID_,row_number() over ( PARTITION BY SPECIFIC_MEASURES_ID_ ORDER BY CREATE_TIME_ DESC ) AS num FROM BIZ_PILOT_SPECIFIC_MEASURES_HISTORY WHERE IS_DELE_ = '0' AND STATUS_ = 5 AND SPECIFIC_MEASURES_ID_ IS NOT NULL AND CREATE_TIME_ h.CREATE_TIME_) WHERE num = 1) AND m.ID_=#{projectId} AND h.ITERATION_YEAR_=#{year} AND h.ITERATION_MONTH_#{month} order by h.CREATE_TIME_ desc SELECT h.REFORM_SPECIFIC_MEASURES_ AS NAME, h.ITERATION_ACCORDING_ AS cause, h.CREATE_TIME_ AS time, m.ID_ FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT m JOIN BIZ_PILOT_SPECIFIC_MEASURES_HISTORY h ON m.ID_=h.PROJECT_ID_ WHERE m.project_type_=1 AND m.CLOSING_ =1 AND m.is_dele_='0' AND m.SEND_STATUS_ =1 AND h.STATUS_=5 AND h.DISTRIBUTION_TYPE_=1 AND h.ITERATION_=0 AND h.IS_DELE_='0' AND m.ID_=#{projectId} AND h.ITERATION_YEAR_=#{year} AND h.ITERATION_MONTH_#{month} order by h.CREATE_TIME_ desc