ID_, PILOT_PROJECT_NAME_, DOC_NAME_, DOC_YEAR_, DOC_NUM_, DOC_NO_, DOCUMENT_BASIS_, LEAD_UNIT_NAME_, PILOT_SUPERVISOR_, PILOT_FIELD_, PILOT_RUNWAY_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, TIME_PERIOD_, START_TIME_, ACCEPTANCE_TIME_, PILOT_TARGET_, TASK_DETAILS_, CLASSIFIED_, PROPULSIVE_UPDATE_DATE_, 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.*,R.ID_ AS R_ID_,R.STATUS_ FROM BIZ_REFORM_PILOT_CITY_MANAGEMENT M LEFT JOIN (SELECT * FROM (SELECT *,ROW_NUMBER()OVER(PARTITION BY PILOT_ID_ ORDER BY CREATE_TIME_ DESC) AS NUM FROM BIZ_PILOT_ADVANCE_CITY_RECORD WHERE IS_DELE_='0') WHERE NUM=1) R ON M.ID_=R.PILOT_ID_ ${ew.customSqlSegment} ORDER BY R.STATUS_ ASC,R.LAST_TIME_ DESC SELECT M.*,R.*,RES.* FROM BIZ_REFORM_PILOT_CITY_MANAGEMENT M LEFT JOIN (SELECT * FROM (SELECT *,ROW_NUMBER()OVER(PARTITION BY PILOT_ID_ ORDER BY CREATE_TIME_ DESC) AS NUM FROM BIZ_PILOT_ADVANCE_CITY_RECORD WHERE IS_DELE_='0') WHERE NUM=1) R ON M.ID_=R.PILOT_ID_ LEFT JOIN BIZ_PILOT_ADVANCE_CITY_RESULT RES ON R.ID_=RES.RECORD_ID_ ${ew.customSqlSegment} ORDER BY R.STATUS_ ASC,R.LAST_TIME_ DESC