create table ipdata_backup as (select * from ipdata);
create table ipdatav6_backup as (select * from ip_data_v6);
create table ipdata_backup as (
select *
  FROM ipdata WHERE ipdataid in
    (WITH a AS
       (SELECT nodeinterfaceid
        FROM nodeinterface
        UNION ALL SELECT subinterfaceid
        FROM subinterface
        UNION ALL SELECT hsrpid
        FROM hsrp) SELECT ipdataid
     FROM ipdata
     WHERE nodeid not in
         (SELECT *
          FROM a)));
          
DELETE FROM ipdata
WHERE ipdataid IN (
    SELECT ipdataid FROM ipdata_backup
);



create table ipdatav6_backup as (
select *
  FROM ip_data_V6 WHERE ipdataid in
    (WITH a AS
       (SELECT nodeinterfaceid
        FROM nodeinterface
        UNION ALL SELECT subinterfaceid
        FROM subinterface
        UNION ALL SELECT hsrpid
        FROM hsrp) SELECT ipdataid
     FROM ip_data_v6
     WHERE nodeid not in
         (SELECT *
          FROM a)));
          
DELETE FROM ip_data_v6
WHERE ipdataid IN (
    SELECT ipdataid FROM ipdatav6_backup
);

drop table ipdata_backup;
drop table ipdatav6_backup;


delete from ipdata where nodeid is null;
delete from ip_data_v6 where nodeid is null;


commit;