id_, catalog_code_, zone_code_, code_, name_,platform_, aisle_, ip_, lgtd_, lttd_, address_, status_, sn_, create_by_, create_org_id_, create_time_, update_by_, update_time_, last_time_ DELETE res FROM device_video_point res LEFT JOIN device_video_zone z ON res.zone_code_ = z.code_ WHERE z.full_id_ LIKE concat('%',#{zoneCode},'%') SELECT r.*, e.type_, e.icon_, e.gis_area_, e.addvcd_, e.area_id_, a.code_ as areaCode,a.name_ as areaName, e.address_type_, e.floor_,e.supplier_company_id_, e.repair_company_id_, e.repair_user_id_, e.manager_company_id_, e.manager_user_id_,'摄像头' as proTypeName,'video' as proTypeCode FROM device_video_point r LEFT JOIN device_video_point_extend e on r.code_ = e.code_ LEFT JOIN device_base_area a on a.id_ = e.area_id_ and a.is_dele_='0' where r.code_ = #{videoCode}