ID_, COMPANY_ID_, COMPANY_NAME_, SN_, NUMBER_, ROAD_SEGMENT_ID_, ROAD_SEGMENT_NAME_, OFFICE_ID_, OFFICE_NAME_, NAME_, TYPE_, PEG_, DIRECTION_, EXPOUND_, PEG_K_, 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_ SELECT * FROM biz_roadside_facilities ${ew.customSqlSegment} AND ROAD_SEGMENT_ID_ IN ( SELECT ID_ FROM biz_road_section WHERE IS_DELE_ = '0' AND ROUTE_ID_ =#{map.routeId} )