ID_, DEMAND_ANALYSIS_LIBRARY_ID_, BLOCKAGE_CARD_TOPIC_, BLOCKAGE_CARD_DESCRIPTION_, BLOCKAGE_SOURCE_CHANNEL_, BLOCKAGE_FIELD_, BLOCKAGE_RUNWAY_, BLOCKAGE_DATE_, BLOCKAGE_YEAR_, BLOCKAGE_QUARTER_, BLOCKAGE_MONTH_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, FEEDBACK_TIME_LIMIT_, PROPULSIVE_STATUS_, PROPULSIVE_DETAILED_, EXISTING_PROBLEMS_, PROPULSIVE_UPDATE_DATE_, PROPULSIVE_YEAR_, PROPULSIVE_QUARTER_, PROPULSIVE_MONTH_, PROPULSIVE_UPDATE_STATUS_, 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_, VERSION_ SELECT a.ID_,a.BLOCKAGE_CARD_TOPIC_, a.BLOCKAGE_CARD_DESCRIPTION_, a.BLOCKAGE_SOURCE_CHANNEL_, a.BLOCKAGE_FIELD_, a.BLOCKAGE_RUNWAY_, a.UNIT_ID_, a.UNIT_NAME_,a.UNIT_CODE_,a.UNIT_GRADE_, a.FEEDBACK_TIME_LIMIT_,a.CREATE_TIME_, r.status_,r.PROPULSIVE_STATUS_ FROM BIZ_BLOCKAGE_CARD_TRANSFER a LEFT JOIN ( SELECT a.* FROM BIZ_BLOCKAGE_CARD_TRANSFER_RECORD a INNER JOIN ( SELECT project_id_, UNIT_ID_, MAX(create_time_)create_time_ FROM BIZ_BLOCKAGE_CARD_TRANSFER_RECORD where IS_DELE_='0' GROUP BY project_id_,UNIT_ID_ ) tab ON a.project_id_=tab.project_id_ AND a.UNIT_ID_=tab.UNIT_ID_ AND a.create_time_ =tab.create_time_ ) r ON a.id_=r.project_id_ ${ew.customSqlSegment} SELECT a.*, (select count(r.id_) from BIZ_BLOCKAGE_CARD_TRANSFER_RECORD r where r.PROJECT_ID_ = a.Id_ and r.is_dele_='0') as recordSize FROM BIZ_BLOCKAGE_CARD_TRANSFER a ${ew.customSqlSegment} SELECT t.BLOCKAGE_CARD_TOPIC_, t.BLOCKAGE_SOURCE_CHANNEL_, t.BLOCKAGE_FIELD_, t.BLOCKAGE_RUNWAY_, t.BLOCKAGE_DATE_, r.PROPULSIVE_DETAILED_ FROM BIZ_BLOCKAGE_CARD_TRANSFER t LEFT JOIN BIZ_BLOCKAGE_CARD_TRANSFER_RECORD r ON t.id_ = r.PROJECT_ID_ WHERE r.STATUS_=5 AND r.PROPULSIVE_STATUS_=3 AND r.is_dele_=0 AND t.is_dele_=0 and t.UNIT_CODE_ = #{unitCode} and t.BLOCKAGE_YEAR_ = #{year} and t.BLOCKAGE_YEAR_ = to_char(sysdate, 'yyyy') and t.BLOCKAGE_QUARTER_ #{quarter} SELECT a.ID_,a.BLOCKAGE_CARD_TOPIC_, a.BLOCKAGE_CARD_DESCRIPTION_, a.BLOCKAGE_SOURCE_CHANNEL_, a.BLOCKAGE_FIELD_, a.BLOCKAGE_RUNWAY_,a.FEEDBACK_TIME_LIMIT_,a.CREATE_TIME_, r.UNIT_ID_, r.UNIT_NAME_,r.UNIT_CODE_,r.UNIT_GRADE_,r.PROPULSIVE_DETAILED_, r.EXISTING_PROBLEMS_, r.REPORTING_TIME,r.STATUS_,r.PROPULSIVE_STATUS_,r.CLASSIFIED_ FROM BIZ_BLOCKAGE_CARD_TRANSFER a LEFT JOIN ( SELECT a.* FROM BIZ_BLOCKAGE_CARD_TRANSFER_RECORD a INNER JOIN ( SELECT project_id_, UNIT_ID_, MAX(create_time_)create_time_ FROM BIZ_BLOCKAGE_CARD_TRANSFER_RECORD where IS_DELE_='0' GROUP BY project_id_,UNIT_ID_ ) tab ON a.project_id_=tab.project_id_ AND a.UNIT_ID_=tab.UNIT_ID_ AND a.create_time_ =tab.create_time_ ) r ON a.id_=r.project_id_ ${ew.customSqlSegment}