ID_,COMPANY_ID_, COMPANY_IDS_, COMPANY_NAME_, ROAD_SEGMENT_ID_, ROAD_SEGMENT_NAME_, BRIDGE_NAME_, BRIDGE_CODE_, BRIDGE_ID_, DIRECTION_, DIRECTION_VALUE_, STATE_, TYPE_, EVALUATE_, 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 ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} ) SELECT * FROM BIZ_TP_BRIDGE where ID_ =#{id} and is_dele_ =0