ID_, SATISFACTION_ID_, UNIT_ID_, UNIT_NAME_, UNIT_CODE_, UNIT_GRADE_, SATISFACTION_, ECO_FIELD_, ECO_ZS_, ECO_CY_, ECO_YL_, ECO_JY_, ECO_ST_, DEM_FIELD_, DEM_YS_, DEM_BS_, CUL_FIELD_, CUL_WH_, CUL_AG_, PEACE_FIELD_, PEACE_SF_, PEACE_ZA_, PARTY_FIELD_, PARTY_GB_, PARTY_QL_, REGION_SN_, ALL_SN_, HOLD_NUM_, TENANT_ID_ SELECT d.* FROM BIZ_REFORM_SATISFACTION_DISTRICTS d LEFT JOIN BIZ_REFORM_SATISFACTION_MANAGEMENT m ON m.id_ = d.SATISFACTION_ID_ WHERE m.is_dele_ = '0' AND m.SCORING_QUARTER_ = #{scoringQuarter} AND m.SCORING_YEAR_ = #{scoringYear} AND d.HOLD_NUM_ >= 0 SELECT s.SCORING_YEAR_ scoringYear, s.SCORING_QUARTER_ scoringQuarter, s.SCORING_MONTH_ scoringMonth, s.SCORING_DATE_ scoringDate, sd.SATISFACTION_, sd.ALL_SN_, sd.HOLD_NUM_, sd.REGION_SN_, sd.UNIT_CODE_, sd.UNIT_NAME_, sd.UNIT_GRADE_, sd.UNIT_ID_ FROM BIZ_REFORM_SATISFACTION_DISTRICTS sd LEFT JOIN BIZ_REFORM_SATISFACTION_MANAGEMENT s ON s.id_ = sd.SATISFACTION_ID_ WHERE s.is_dele_ = '0' and s.status_=5 and s.SCORING_YEAR_=#{year} and s.SCORING_QUARTER_=#{quarter} and sd.unit_code_!='500000' SELECT s.SCORING_YEAR_ scoringYear, s.SCORING_QUARTER_ scoringQuarter, s.SCORING_MONTH_ scoringMonth, s.SCORING_DATE_ scoringDate, sd.SATISFACTION_, sd.ALL_SN_, sd.HOLD_NUM_, sd.REGION_SN_, sd.UNIT_CODE_, sd.UNIT_NAME_, sd.UNIT_GRADE_, sd.UNIT_ID_ FROM BIZ_REFORM_SATISFACTION_DISTRICTS sd LEFT JOIN BIZ_REFORM_SATISFACTION_MANAGEMENT s ON s.id_ = sd.SATISFACTION_ID_ WHERE s.is_dele_ = '0' and s.status_=5 and s.SCORING_YEAR_ #{year} and s.SCORING_QUARTER_ #{quarter} and sd.unit_code_ =#{unitCode} order by s.SCORING_DATE_ desc limit 1 SELECT m.SCORING_YEAR_, m.SCORING_QUARTER_, d.UNIT_NAME_, d.UNIT_CODE_, d.ECO_FIELD_, d.DEM_FIELD_, d.CUL_FIELD_, d.PEACE_FIELD_, d.PARTY_FIELD_ FROM BIZ_REFORM_SATISFACTION_DISTRICTS d INNER JOIN BIZ_REFORM_SATISFACTION_MANAGEMENT m ON d.SATISFACTION_ID_ = m.id_ where m.is_dele_='0' and m.status_=5 and d.UNIT_CODE_ = #{unitCode} and ((m.SCORING_YEAR_ = (#{scoringYear}-1) and m.SCORING_QUARTER_ ]]> #{scoringQuarter}) or (m.SCORING_YEAR_ = #{scoringYear} and m.SCORING_QUARTER_ #{scoringQuarter})) order by m.SCORING_YEAR_,m.SCORING_QUARTER_