a.ID_ AS "bridgeOftenCheck.id", a.REMARKS_ AS "bridgeOftenCheck.remarks", a.BRIGE_ID_ AS "bridgeOftenCheck.brigeId", a.BRIGE_NAME_ AS "bridgeOftenCheck.brigeName", a.COMPANY_ID AS "bridgeOftenCheck.companyId", a.COMPANY_NAME_ AS "bridgeOftenCheck.companyName", a.RUMMAGER_ AS "bridgeOftenCheck.rummager", a.CHECK_DATE_ AS "bridgeOftenCheck.checkDate", a.NOTE_TAKER_ AS "bridgeOftenCheck.noteTaker", a.WEATHER_ AS "bridgeOftenCheck.weather", a.EVALUATE_ AS "bridgeOftenCheck.evaluate", a.EVALUATE_VALUE_ AS "bridgeOftenCheck.evaluateValue", a.WEATHER_VALUE_ AS "bridgeOftenCheck.weatherValue", a.CHECK_DETAIL_JSON_ AS "bridgeOftenCheck.checkDetailJson", b.ID_ AS "bridgeOftenCheckDetail.id", b.BRIDGE_OFTEN_CHECK_ID_ AS "bridgeOftenCheckDetail.bridgeOftenCheckId", b.NAME_ AS "bridgeOftenCheckDetail.name", b.DEFECT_SCOPE_ AS "bridgeOftenCheckDetail.defectScope", b.DEFECT_TYPE_ AS "bridgeOftenCheckDetail.defectType", b.SPECIAL_CHECK_ AS "bridgeOftenCheckDetail.specialCheck", b.MAINTAIN_ADVICE_ AS "bridgeOftenCheckDetail.maintainAdvice", b.PROCESS_MODE_ AS "bridgeOftenCheckDetail.processMode" SELECT * FROM biz_bridge_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_bridge_often_check where BRIGE_ID_ in (${ids}) and date_format(CHECK_DATE_,"%Y-%m") = '${mouth}'