ID_, FILL_ID_, PROJECT_ID_, PROMOTION_TYPE_, PROMOTION_CONTENT_, PROMOTION_DATE_, CLASSIFIED_, 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 * FROM BIZ_PILOT_EXPERIENCE_PUSH ${ew.customSqlSegment} SELECT p.* FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT m LEFT JOIN BIZ_PILOT_EXPERIENCE_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_ = 3 AND FILL_YEAR_=#{year} AND FILL_MONTH_ #{year} ) WHERE num = 1 ) AS f ON p.FILL_ID_ = f.ID_ WHERE 1=1 AND m.ID_=#{projectId} AND m.SEND_STATUS_ = 1 AND m.CLOSING_ = 1 AND m.PROJECT_TYPE_ = 1