id_, platform_, code_, name_, type_, sn_, create_by_, create_org_id_, create_time_, update_by_, update_time_, last_time_ SELECT r.* FROM device_video_point r LEFT JOIN device_video_zone z on z.code_ = r.zone_code_ LEFT JOIN device_video_base b on b.code_ = r.catalog_code_ ${ew.customSqlSegment} SELECT r.* FROM device_video_point r LEFT JOIN device_video_zone z ON z.code_ = r.zone_code_ LEFT JOIN device_video_base b ON b.code_ = r.catalog_code_ WHERE 1=1 and r.name_ like concat('%',#{vo.name},'%') and z.full_id_ like concat('%',#{vo.zoneCode},'%') order by b.CREATE_TIME_ desc SELECT r.*, r.zone_code_ AS parentId FROM device_video_point r WHERE 1=1 select code_ from device_video_base where is_dele_='0' and platform_=#{platform}