ID_, COMPANY_ID_, COMPANY_NAME_, ORDER_ID_, TYPE_, TYPE_NAME_, DIRECTION_, DIRECTION_NAME_, START_PEG_, END_PEG_, CATEGORY_ID_, SUBJECT_NAME_, DETAILS_ID_, DSUBJECT_NAME_, POSITION_, POSITION_NAME_, HANDLING_SITUATION_, DESCRIPTION_, PARAM_LENGTH_, PARAM_WIDTH_, PARAM_HEIGHT_, ROAD_ID_, ROAD_NAME_, RELEVANCE_TYPE_, TEMPORARY_, DEADLINE_, HANDLED_TIME_, JOB_NUMBER_, HANDLED_TIME_START_, HANDLED_TIME_END_, DEADLINE_START_, DEADLINE_END_, STATUS_, DEADLINE_STATUS_, RELEVANCE_ID_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_TIME_, UPDATE_BY_, CREATE_TIME_, TENANT_ID_ SELECT * FROM biz_disease ${ew.customSqlSegment} where 1=1 AND DEADLINE_START_>=#{map.deadlineStart,jdbcType=TIMESTAMP} AND DEADLINE_END_ <=#{map.deadlineEnd,jdbcType=TIMESTAMP} AND CHECK_DATE_>=#{map.beginCheckDate,jdbcType=TIMESTAMP} AND CHECK_DATE_ <=#{map.endCheckDate,jdbcType=TIMESTAMP} SELECT b.* FROM biz_bridge_often_check a INNER JOIN biz_disease b ON a.ID_ = b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_bridge_regular_check a INNER JOIN biz_disease b ON a.ID_ = b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_culvert_often_check a INNER JOIN biz_disease b ON a.ID_ =b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_culvert_regular_check a INNER JOIN biz_disease b ON a.ID_ =b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_tunnel_often_check a INNER JOIN biz_disease b ON a.ID_ =b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_tunnel_regular_check a INNER JOIN biz_disease b ON a.ID_ =b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_side_slope_often_check a INNER JOIN biz_disease b ON a.ID_ =b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT b.* FROM biz_side_slope_regular_check a INNER JOIN biz_disease b ON a.ID_ =b.RELEVANCE_ID_ ${ew.customSqlSegment} SELECT `value` FROM portal_sys_properties e WHERE e.alias = "disease_timeout_days"