ID_, REMARKS_, SIDE_SLOPE_ID_, RUMMAGER_, CHECK_DATE_, NOTE_TAKER_, WEATHER_, EVALUATE_, EVALUATE_VALUE_, WEATHER_VALUE_, CHECK_DETAIL_JSON_, COMPANY_ID_, COMPANY_NAME_, CREATE_BY_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_, TENANT_ID_ select * from BIZ_SIDE_SLOPE_OFTEN_CHECK a ${ew.customSqlSegment} AND a.CHECK_DATE_>=#{map.beginCheckDate,jdbcType=TIMESTAMP} AND a.CHECK_DATE_ <=#{map.endCheckDate,jdbcType=TIMESTAMP} select count(*) from BIZ_SIDE_SLOPE_OFTEN_CHECK where SIDE_SLOPE_ID_ in (${ids}) and date_format(CHECK_DATE_,'%Y-%m') = '${mouth}'