ID_, NEWS_TYPE_, TITLE_, IS_URL_, URL_, CONTENT_, EXCELLENT_, END_TIME_, IS_TOP_, DRAFTER_, PAGE_HEIGHT_, 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 b.*,l.OPERATE_DATE_ FROM BIZ_WORK_NEWS b 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 b.ID_ = l.BIZ_ID_ ${ew.customSqlSegment} ORDER BY b.STATUS_ ASC,b.CREATE_TIME_ DESC SELECT n.* FROM BIZ_WORK_NEWS n JOIN UC_ORG o ON n.CREATE_ORG_ID_=o.ID_ ${ew.customSqlSegment} ORDER BY n.STATUS_ ASC,n.CREATE_TIME_ DESC