create table ipdata_backup_160525 as (
select *
  FROM ipdata WHERE versionid='F4E40A20A3B643618C08D2F3D7AEF045' and 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_160525
);

commit;