ID_, DEMAND_ANALYSIS_LIBRARY_ID_, DEMAND_TOPIC_, DEMAND_DESCRIPTION_, DEMAND_SOURCE_CHANNEL_, DEMAND_FIELD_, DEMAND_RUNWAY_, RESPONSIBLE_UNIT_ID_, RESPONSIBLE_UNIT_NAME_, RESPONSIBLE_UNIT_TYPE_,COOPERATIVE_UNIT_NAME_, FEEDBACK_TIME_LIMIT_, MEETING_NAME_, MEETING_DATE_, DEMAND_NO_, PROPULSIVE_QUARTER_, PROPULSIVE_MONTH_, DEMAND_STATUS_, PROPULSIVE_STATUS_, PROPULSIVE_DETAILED_, EXISTING_PROBLEMS_, PROPULSIVE_UPDATE_DATE_, PROPULSIVE_UPDATE_STATUS_, REMARKS_,RESPONSIBLE_UNIT_CODE_, RESPONSIBLE_UNIT_GRADE_ SELECT a.ID_, a.DEMAND_TOPIC_, a.DEMAND_DESCRIPTION_, a.DEMAND_SOURCE_CHANNEL_, a.DEMAND_FIELD_, a.DEMAND_RUNWAY_, a.RESPONSIBLE_UNIT_ID_, a.RESPONSIBLE_UNIT_NAME_, a.PROPULSIVE_YEAR_,a.RESPONSIBLE_UNIT_TYPE_,a.COOPERATIVE_UNIT_NAME_, a.FEEDBACK_TIME_LIMIT_, a.MEETING_NAME_, a.MEETING_DATE_, a.DEMAND_NO_, a.DEMAND_STATUS_,a.RESPONSIBLE_UNIT_CODE_, a.RESPONSIBLE_UNIT_GRADE_,a.create_time_, r.status_, r.propulsive_status_,l.OPERATE_DATE_ FROM BIZ_REFORM_DEMAND_ASSIGNMENT a LEFT JOIN (SELECT a.* FROM BIZ_REFORM_DEMAND_ASSIGNMENT_RECORD a INNER JOIN (SELECT project_id_, REPORTING_UNIT_ID_, MAX(CREATE_TIME_)CREATE_TIME_ FROM BIZ_REFORM_DEMAND_ASSIGNMENT_RECORD where IS_DELE_='0' GROUP BY project_id_,REPORTING_UNIT_ID_ ) tab ON a.project_id_=tab.project_id_ AND a.REPORTING_UNIT_ID_=tab.REPORTING_UNIT_ID_ AND a.CREATE_TIME_ =tab.CREATE_TIME_ ) r ON a.id_=r.project_id_ 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 r.ID_ = l.BIZ_ID_ ${ew.customSqlSegment} SELECT a.*, (select count(*) from BIZ_REFORM_DEMAND_ASSIGNMENT_RECORD r where r.PROJECT_ID_ = a.id_ and r.IS_DELE_='0') recordSize FROM BIZ_REFORM_DEMAND_ASSIGNMENT a ${ew.customSqlSegment} SELECT a.ID_, a.DEMAND_TOPIC_, a.DEMAND_DESCRIPTION_, a.DEMAND_SOURCE_CHANNEL_, a.DEMAND_FIELD_, a.DEMAND_RUNWAY_, a.RESPONSIBLE_UNIT_TYPE_, a.RESPONSIBLE_UNIT_ID_, a.RESPONSIBLE_UNIT_NAME_,a.RESPONSIBLE_UNIT_CODE_,a.RESPONSIBLE_UNIT_GRADE_,a.COOPERATIVE_UNIT_NAME_, a.PROPULSIVE_YEAR_,a.PROPULSIVE_QUARTER_,a.PROPULSIVE_MONTH_, a.FEEDBACK_TIME_LIMIT_, a.MEETING_NAME_, a.MEETING_DATE_, a.DEMAND_NO_, a.DEMAND_STATUS_,a.create_time_, r.id_ recordId, r.WORK_PLAN_,r.status_, r.propulsive_status_,r.PROPULSIVE_DETAILED_, r.EXISTING_PROBLEMS_, r.REPORTING_TIME FROM BIZ_REFORM_DEMAND_ASSIGNMENT a LEFT JOIN (SELECT a.* FROM BIZ_REFORM_DEMAND_ASSIGNMENT_RECORD a INNER JOIN (SELECT project_id_, REPORTING_UNIT_ID_, MAX(CREATE_TIME_)CREATE_TIME_ FROM BIZ_REFORM_DEMAND_ASSIGNMENT_RECORD where IS_DELE_='0' GROUP BY project_id_,REPORTING_UNIT_ID_ ) tab ON a.project_id_=tab.project_id_ AND a.REPORTING_UNIT_ID_=tab.REPORTING_UNIT_ID_ AND a.CREATE_TIME_ =tab.CREATE_TIME_ ) r ON a.id_=r.project_id_ ${ew.customSqlSegment}