Pasted

INSERT INTO collection SELECT 9999999999999, dataid, versionnum FROM dtree LEFT JOIN collection c ON dtree.dataid = c.dataid WHERE c.dataid IS NULL subtype IN (0, 130, 132, 133, 134, 136, 137, 138, 139, 141, 142, 143, 148, 154, 161, 162, 180, 196, 198, 199, 201, 202, 205, 206, 208, 209, 210, 211, 212, 233, 236, 268, 269, 270, 275, 276, 290, 336, 370, 397, 398, 405, 410, 411, 412, 413, 414, 415, 416, 417, 418, 421, 422, 423, 424, 426, 427, 428, 480, 481, 482, 483, 484, 541, 542, 550, 551, 552, 553, 554, 556, 557, 558, 559, 602, 690, 731, 732, 751, 829, 833, 870, 899, 900, 901, 905, 919, 2550, 3030, 3031, 3032, 3033, 8000, 31325, 31326, 31328, 31330, 31400, 31401, 31402, 31403, 31443, 3030783);