ID_, BELONG_AREA_ID_, BELONG_AREA_CODE_, BELONG_AREA_NAME_, ROAD_ID_, ROAD_NAME_, ROAD_CODE_, DIRECTION_, WARNING_TIME_, WARNING_TYPE, LOCATION_STATION_NUMBER_, LOCATION_CAT_UNCLE_, WARNING_LEVEL_, WARNING_CONTENT_, PUBLISH_DEVICE_NAME_, PUBLISH_DEVICE_TYPE_, NATIONAL_STANDARD_CODE_, LNG_, LAT_, CREATE_BY_, CREATE_ORG_ID_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_NAME_, 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 cr.adcode_ AS adcode, cr.lat_ AS lat, cr.lng_ AS lng, w.section_name AS roadName, w.id AS roadId, w.section_code AS roadCode, start_peg AS pegSVal, end_peg AS pegEVal, formatted_address_ AS adname FROM bs_runmoitor_early w JOIN bs_cytq_regional cr ON w.weather_node_code=cr.adcode_ AND w.id=#{roadId} SELECT * FROM biz_early_warning_management WHERE is_dele_ = '0' AND NOT EXISTS ( SELECT 1 FROM biz_early_warning_call_management WHERE is_dele_ = '0' AND early_id_ = biz_early_warning_management.id_ ) AND road_id_ = #{roadId}