ID_, COMPANY_ID_, COMPANY_IDS_, COMPANY_NAME_, ROAD_SEGMENT_ID_, ROAD_SEGMENT_NAME_, TP_BRIDGE_CODE_, TP_BRIDGE_ID_, TR_BRIDGE_ID_, HEALTH_ASSESSMENT_LEVEL_, ASSESSMENT_FAULT_, ASSESSMENT_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_BRIDGE_HEALTH ${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 HEALTH_ASSESSMENT_LEVEL_ = 1 THEN 1 ELSE 0 END),0) AS intactCount, IFNULL(SUM(CASE WHEN HEALTH_ASSESSMENT_LEVEL_ = 2 THEN 1 ELSE 0 END),0) AS minorCount, IFNULL(SUM(CASE WHEN HEALTH_ASSESSMENT_LEVEL_ = 3 THEN 1 ELSE 0 END),0) AS moderateCount, IFNULL(SUM(CASE WHEN HEALTH_ASSESSMENT_LEVEL_ = 4 THEN 1 ELSE 0 END),0) AS fatalCount FROM BIZ_TP_BRIDGE_HEALTH ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} )