ID_, PROJECT_ID_, FILL_DATE_, FILL_YEAR_, FILL_QUARTER_, FILL_MONTH_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, 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_, FLOW_TYPE_ SELECT f.* FROM BIZ_PILOT_PROJECT_FILL f LEFT JOIN BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT p ON f.PROJECT_ID_ = p.ID_ ${ew.customSqlSegment} SELECT p.id_ PROJECT_ID_, p.PROJECT_NAME_, p.PROJECT_TYPE_, p.LEADER_, p.PROJECT_FIELD_, p.PROJECT_RUNWAY_, p.UNIT_ID_, p.UNIT_NAME_, p.UNIT_CODE_, p.UNIT_GRADE_, a.id_, a.FILL_DATE_, a.FILL_YEAR_, a.FILL_QUARTER_, a.FILL_MONTH_, a.flow_type_, a.status_, a.create_time_ FROM BIZ_MUNICIPAL_MAJOR_PROJECT_MANAGEMENT p LEFT JOIN( SELECT f.* FROM BIZ_PILOT_PROJECT_FILL f INNER JOIN( SELECT f.project_id_, f.flow_type_, MAX(f.create_time_) create_time_ FROM BIZ_PILOT_PROJECT_FILL f WHERE f.is_dele_='0' GROUP BY f.project_id_, f.flow_type_ )tab ON tab.project_id_=f.project_id_ AND tab.flow_type_=f.flow_type_ AND tab.create_time_= f.create_time_ WHERE f.flow_type_=#{flowType} )a ON a.project_id_=p.id_ ${ew.customSqlSegment}