ID_, DEMAND_ANALYSIS_LIBRARY_ID_,PROJECT_ID_, EFFECT_CARD_TOPIC_, SIGNIFICANT_, EFFECT_FIELD_, EFFECT_RUNWAY_, PROPULSIVE_UPDATE_DATE_, 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.*, r.status_, r.COMPLETION_DATE_, r.EFFECT_FORM_, r.SPECIFIC_DETAILS_, r.SOLVE_PROBLEM_, r.RESULT_ FROM BIZ_EFFECT_DRYING_COMPETITION a INNER JOIN ( SELECT a.* FROM BIZ_EFFECT_EFFECTIVENESS a INNER JOIN ( SELECT EFFECT_ID_, CREATE_ORG_ID_, MAX(CREATE_TIME_)REPORTING_TIME FROM BIZ_EFFECT_EFFECTIVENESS where IS_DELE_='0' GROUP BY EFFECT_ID_,CREATE_ORG_ID_ ) tab ON a.EFFECT_ID_=tab.EFFECT_ID_ AND a.CREATE_ORG_ID_=tab.CREATE_ORG_ID_ AND a.CREATE_TIME_ =tab.REPORTING_TIME ) r ON a.id_=EFFECT_ID_ ${ew.customSqlSegment}