ID_, PILOT_ID_, PROPULSIVE_STATUS_, WORK_PLAN_, EXISTING_PROBLEMS_, PROPULSIVE_DETAILS_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, STATUS_, 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_, ACTUAL_TIME_ SELECT p.* FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT m LEFT JOIN BIZ_PILOT_BRAND_PUSH p on m.ID_=p.PROJECT_ID_ JOIN ( SELECT * FROM ( SELECT *,row_number() over ( PARTITION BY PROJECT_ID_, FILL_YEAR_, FILL_MONTH_ ORDER BY CREATE_TIME_ DESC ) AS num FROM BIZ_PILOT_PROJECT_FILL WHERE IS_DELE_ = '0' AND STATUS_ = 5 AND FLOW_TYPE_ = 4 AND FILL_YEAR_=#{year} AND FILL_MONTH_ #{year} ) WHERE num = 1 ) AS f ON p.FILL_ID_ = f.ID_ WHERE 1=1 AND m.IS_DELE_='0' AND m.ID_=#{projectId} SELECT p.* FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT m LEFT JOIN BIZ_PILOT_BRAND_PUSH p on m.ID_=p.PROJECT_ID_ JOIN ( SELECT * FROM ( SELECT *,row_number() over ( PARTITION BY PROJECT_ID_, FILL_YEAR_, FILL_MONTH_ ORDER BY CREATE_TIME_ DESC ) AS num FROM BIZ_PILOT_PROJECT_FILL WHERE IS_DELE_ = '0' AND STATUS_ = 5 AND FLOW_TYPE_ = 4 AND FILL_YEAR_=#{year} AND FILL_MONTH_ #{year} ) ) AS f ON p.FILL_ID_ = f.ID_ WHERE 1=1 AND m.IS_DELE_='0' AND m.ID_=#{projectId}