ID_, PROJECT_NAME_, PROJECT_TYPE_, LEADER_, START_DATE_, END_DATE_, PROJECT_FIELD_, PROJECT_RUNWAY_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, CLOSING_TIME_, CLOSING_,STATUS_, SEND_STATUS_,SEND_TIME_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 m.*, l.OPERATE_DATE_ as thisTime FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT AS 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}