CREATE TABLE ELEMENTADDITIONALINFO_BCKP_20251128 AS
SELECT * FROM ELEMENTADDITIONALINFO
where category in ('ASSOCIATION','ADJNODE')
AND ELEMENTTYPE IN ('SRanBS', 'eNodeB', 'BTS', 'BSC', 'RNC', 'NodeB')
AND VERSIONID = (SELECT VERSIONID FROM VERSION WHERE NAME = 'Actual_Network');

SELECT * FROM ELEMENTADDITIONALINFO
where category in ('ASSOCIATION','ADJNODE')
AND ELEMENTTYPE IN ('SRanBS', 'eNodeB', 'BTS', 'BSC', 'RNC', 'NodeB')
AND VERSIONID = (SELECT VERSIONID FROM VERSION WHERE NAME = 'Actual_Network');


commit;