ID_, EFFECT_ID_, COMPLETION_DATE_, EFFECT_FORM_, SPECIFIC_DETAILS_,RESULT_,SOLVE_PROBLEM_, PROPULSIVE_DETAILED_, CLASSIFIED_, STATUS_, REMARKS_ SELECT edc.CREATE_ORG_ID_ orgId, ifnull(COUNT(ee.EFFECT_FORM_), 0) effectCount, ee.EFFECT_FORM_ effectType FROM BIZ_EFFECT_DRYING_COMPETITION edc LEFT JOIN BIZ_EFFECT_EFFECTIVENESS ee ON ee.EFFECT_ID_ = edc.id_ GROUP BY ee.EFFECT_FORM_, edc.CREATE_ORG_ID_ select e.create_org_id_ countyId, o.code_ countyCode, count(1) experienceCount from BIZ_EFFECT_EFFECTIVENESS e left join uc_org o on o.id_ = e.create_org_id_ where EFFECT_FORM_ = 1 and STATUS_ = 5 and EXTRACT(YEAR FROM COMPLETION_DATE_) = EXTRACT(YEAR FROM SYSDATE) and COMPLETION_DATE_ #{time} group by e.create_org_id_,o.code_ select * , ed.EFFECT_CARD_TOPIC_ effectTopic from BIZ_EFFECT_EFFECTIVENESS ee left join BIZ_EFFECT_DRYING_COMPETITION ed on ee.EFFECT_ID_ = ed.id_ ${ew.customSqlSegment} SELECT e.id_, c.EFFECT_CARD_TOPIC_ effectTopic, e.EFFECT_FORM_, e.COMPLETION_DATE_, e.SPECIFIC_DETAILS_, e.SOLVE_PROBLEM_, e.RESULT_ FROM BIZ_EFFECT_DRYING_COMPETITION c LEFT JOIN BIZ_EFFECT_EFFECTIVENESS e ON c.id_ = e.EFFECT_ID_ ${ew.customSqlSegment} WHERE 1=1 AND e.STATUS_ = 5 AND c.is_dele_ = 0 AND e.is_dele_ = 0 and c.CREATE_ORG_ID_ = #{unitId} and e.COMPLETION_YEAR_ = #{year} and e.COMPLETION_YEAR_ = to_char(sysdate, 'yyyy') and e.COMPLETION_QUARTER_ #{quarter}