ID_,COMPANY_ID_, COMPANY_IDS_, COMPANY_NAME_, ROAD_SEGMENT_ID_, ROAD_SEGMENT_NAME_, EVENTS_DESCRIBE_, EVENTS_NUM_, LAT_, LNG_, TP_BRIDGE_NAME_, TP_BRIDGE_ID_, DEVICE_ID_, WARN_TYPE_, EVENTS_STATE_, THRESHOLD_LIMIT_, THRESHOLD_NOW_, EVENTS_DATE_, DEAL_DATE_, 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_tp_warning_events ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} ) SELECT IFNULL(SUM(CASE WHEN WARN_TYPE_ = 1 AND EVENTS_STATE_ =1 THEN 1 ELSE 0 END),0) AS blueHandleCount, IFNULL(SUM(CASE WHEN WARN_TYPE_ = 1 AND EVENTS_STATE_ =0 THEN 1 ELSE 0 END),0) AS blueDisposedCount, IFNULL(SUM(CASE WHEN WARN_TYPE_ = 2 AND EVENTS_STATE_ =1 THEN 1 ELSE 0 END),0) AS yellowHandleCount, IFNULL(SUM(CASE WHEN WARN_TYPE_ = 2 AND EVENTS_STATE_ =0 THEN 1 ELSE 0 END),0) AS yellowDisposedCount, IFNULL(SUM(CASE WHEN WARN_TYPE_ = 3 AND EVENTS_STATE_ =1 THEN 1 ELSE 0 END),0) AS redHandleCount, IFNULL(SUM(CASE WHEN WARN_TYPE_ = 3 AND EVENTS_STATE_ =0 THEN 1 ELSE 0 END),0) AS redDisposedCount FROM biz_tp_warning_events ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} )