--disable_abort_on_error set autocommit=1; DROP TABLE IF EXISTS A; CREATE TABLE A ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon; DROP TABLE IF EXISTS B; CREATE TABLE B ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon; INSERT INTO B ( int_nokey, int_key ) VALUES (0, 0); DROP TABLE IF EXISTS C; CREATE TABLE C ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon; INSERT INTO C ( int_nokey, int_key ) VALUES (5, 5); INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7); INSERT INTO C ( int_nokey, int_key ) VALUES (3, 3); INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7); INSERT INTO C ( int_nokey, int_key ) VALUES (4, 4); INSERT INTO C ( int_nokey, int_key ) VALUES (9, 9); INSERT INTO C ( int_nokey, int_key ) VALUES (7, 7); INSERT INTO C ( int_nokey, int_key ) VALUES (5, 5); INSERT INTO C ( int_nokey, int_key ) VALUES (0, 0); INSERT INTO C ( int_nokey, int_key ) VALUES (6, 6); DROP TABLE IF EXISTS D; CREATE TABLE D ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon; INSERT INTO D ( int_nokey, int_key ) VALUES (37, 37); INSERT INTO D ( int_nokey, int_key ) VALUES (7, 7); INSERT INTO D ( int_nokey, int_key ) VALUES (45, 45); INSERT INTO D ( int_nokey, int_key ) VALUES (78, 78); INSERT INTO D ( int_nokey, int_key ) VALUES (8, 8); INSERT INTO D ( int_nokey, int_key ) VALUES (52, 52); INSERT INTO D ( int_nokey, int_key ) VALUES (57, 57); INSERT INTO D ( int_nokey, int_key ) VALUES (84, 84); INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70); INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67); INSERT INTO D ( int_nokey, int_key ) VALUES (18, 18); INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98); INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85); INSERT INTO D ( int_nokey, int_key ) VALUES (72, 72); INSERT INTO D ( int_nokey, int_key ) VALUES (79, 79); INSERT INTO D ( int_nokey, int_key ) VALUES (4, 4); INSERT INTO D ( int_nokey, int_key ) VALUES (21, 21); INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67); INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81); INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43); INSERT INTO D ( int_nokey, int_key ) VALUES (74, 74); INSERT INTO D ( int_nokey, int_key ) VALUES (61, 61); INSERT INTO D ( int_nokey, int_key ) VALUES (56, 56); INSERT INTO D ( int_nokey, int_key ) VALUES (23, 23); INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81); INSERT INTO D ( int_nokey, int_key ) VALUES (2, 2); INSERT INTO D ( int_nokey, int_key ) VALUES (58, 58); INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48); INSERT INTO D ( int_nokey, int_key ) VALUES (73, 73); INSERT INTO D ( int_nokey, int_key ) VALUES (62, 62); INSERT INTO D ( int_nokey, int_key ) VALUES (10, 10); INSERT INTO D ( int_nokey, int_key ) VALUES (50, 50); INSERT INTO D ( int_nokey, int_key ) VALUES (11, 11); INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67); INSERT INTO D ( int_nokey, int_key ) VALUES (76, 76); INSERT INTO D ( int_nokey, int_key ) VALUES (42, 42); INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43); INSERT INTO D ( int_nokey, int_key ) VALUES (39, 39); INSERT INTO D ( int_nokey, int_key ) VALUES (55, 55); INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13); INSERT INTO D ( int_nokey, int_key ) VALUES (76, 76); INSERT INTO D ( int_nokey, int_key ) VALUES (40, 40); INSERT INTO D ( int_nokey, int_key ) VALUES (88, 88); INSERT INTO D ( int_nokey, int_key ) VALUES (51, 51); INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70); INSERT INTO D ( int_nokey, int_key ) VALUES (74, 74); INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13); INSERT INTO D ( int_nokey, int_key ) VALUES (71, 71); INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43); INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48); INSERT INTO D ( int_nokey, int_key ) VALUES (99, 99); INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13); INSERT INTO D ( int_nokey, int_key ) VALUES (62, 62); INSERT INTO D ( int_nokey, int_key ) VALUES (53, 53); INSERT INTO D ( int_nokey, int_key ) VALUES (60, 60); INSERT INTO D ( int_nokey, int_key ) VALUES (55, 55); INSERT INTO D ( int_nokey, int_key ) VALUES (9, 9); INSERT INTO D ( int_nokey, int_key ) VALUES (67, 67); INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98); INSERT INTO D ( int_nokey, int_key ) VALUES (34, 34); INSERT INTO D ( int_nokey, int_key ) VALUES (51, 51); INSERT INTO D ( int_nokey, int_key ) VALUES (70, 70); INSERT INTO D ( int_nokey, int_key ) VALUES (64, 64); INSERT INTO D ( int_nokey, int_key ) VALUES (36, 36); INSERT INTO D ( int_nokey, int_key ) VALUES (37, 37); INSERT INTO D ( int_nokey, int_key ) VALUES (66, 66); INSERT INTO D ( int_nokey, int_key ) VALUES (86, 86); INSERT INTO D ( int_nokey, int_key ) VALUES (11, 11); INSERT INTO D ( int_nokey, int_key ) VALUES (3, 3); INSERT INTO D ( int_nokey, int_key ) VALUES (12, 12); INSERT INTO D ( int_nokey, int_key ) VALUES (35, 35); INSERT INTO D ( int_nokey, int_key ) VALUES (79, 79); INSERT INTO D ( int_nokey, int_key ) VALUES (87, 87); INSERT INTO D ( int_nokey, int_key ) VALUES (41, 41); INSERT INTO D ( int_nokey, int_key ) VALUES (97, 97); INSERT INTO D ( int_nokey, int_key ) VALUES (81, 81); INSERT INTO D ( int_nokey, int_key ) VALUES (87, 87); INSERT INTO D ( int_nokey, int_key ) VALUES (71, 71); INSERT INTO D ( int_nokey, int_key ) VALUES (29, 29); INSERT INTO D ( int_nokey, int_key ) VALUES (13, 13); INSERT INTO D ( int_nokey, int_key ) VALUES (19, 19); INSERT INTO D ( int_nokey, int_key ) VALUES (28, 28); INSERT INTO D ( int_nokey, int_key ) VALUES (43, 43); INSERT INTO D ( int_nokey, int_key ) VALUES (75, 75); INSERT INTO D ( int_nokey, int_key ) VALUES (77, 77); INSERT INTO D ( int_nokey, int_key ) VALUES (6, 6); INSERT INTO D ( int_nokey, int_key ) VALUES (56, 56); INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85); INSERT INTO D ( int_nokey, int_key ) VALUES (65, 65); INSERT INTO D ( int_nokey, int_key ) VALUES (92, 92); INSERT INTO D ( int_nokey, int_key ) VALUES (73, 73); INSERT INTO D ( int_nokey, int_key ) VALUES (5, 5); INSERT INTO D ( int_nokey, int_key ) VALUES (45, 45); INSERT INTO D ( int_nokey, int_key ) VALUES (98, 98); INSERT INTO D ( int_nokey, int_key ) VALUES (57, 57); INSERT INTO D ( int_nokey, int_key ) VALUES (48, 48); INSERT INTO D ( int_nokey, int_key ) VALUES (86, 86); INSERT INTO D ( int_nokey, int_key ) VALUES (15, 15); INSERT INTO D ( int_nokey, int_key ) VALUES (39, 39); INSERT INTO D ( int_nokey, int_key ) VALUES (85, 85); DROP TABLE IF EXISTS E; CREATE TABLE E ( pk INTEGER AUTO_INCREMENT, int_nokey INTEGER, int_key INTEGER, filler blob, PRIMARY KEY (pk), KEY (int_key) ) ENGINE=Falcon; INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84); INSERT INTO E ( int_nokey, int_key ) VALUES (595, 595); INSERT INTO E ( int_nokey, int_key ) VALUES (552, 552); INSERT INTO E ( int_nokey, int_key ) VALUES (46, 46); INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93); INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939); INSERT INTO E ( int_nokey, int_key ) VALUES (507, 507); INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512); INSERT INTO E ( int_nokey, int_key ) VALUES (35, 35); INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727); INSERT INTO E ( int_nokey, int_key ) VALUES (317, 317); INSERT INTO E ( int_nokey, int_key ) VALUES (225, 225); INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204); INSERT INTO E ( int_nokey, int_key ) VALUES (751, 751); INSERT INTO E ( int_nokey, int_key ) VALUES (955, 955); INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543); INSERT INTO E ( int_nokey, int_key ) VALUES (530, 530); INSERT INTO E ( int_nokey, int_key ) VALUES (395, 395); INSERT INTO E ( int_nokey, int_key ) VALUES (296, 296); INSERT INTO E ( int_nokey, int_key ) VALUES (831, 831); INSERT INTO E ( int_nokey, int_key ) VALUES (363, 363); INSERT INTO E ( int_nokey, int_key ) VALUES (144, 144); INSERT INTO E ( int_nokey, int_key ) VALUES (260, 260); INSERT INTO E ( int_nokey, int_key ) VALUES (117, 117); INSERT INTO E ( int_nokey, int_key ) VALUES (142, 142); INSERT INTO E ( int_nokey, int_key ) VALUES (5, 5); INSERT INTO E ( int_nokey, int_key ) VALUES (560, 560); INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175); INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675); INSERT INTO E ( int_nokey, int_key ) VALUES (489, 489); INSERT INTO E ( int_nokey, int_key ) VALUES (564, 564); INSERT INTO E ( int_nokey, int_key ) VALUES (82, 82); INSERT INTO E ( int_nokey, int_key ) VALUES (75, 75); INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921); INSERT INTO E ( int_nokey, int_key ) VALUES (495, 495); INSERT INTO E ( int_nokey, int_key ) VALUES (533, 533); INSERT INTO E ( int_nokey, int_key ) VALUES (673, 673); INSERT INTO E ( int_nokey, int_key ) VALUES (49, 49); INSERT INTO E ( int_nokey, int_key ) VALUES (168, 168); INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60); INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371); INSERT INTO E ( int_nokey, int_key ) VALUES (534, 534); INSERT INTO E ( int_nokey, int_key ) VALUES (437, 437); INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591); INSERT INTO E ( int_nokey, int_key ) VALUES (208, 208); INSERT INTO E ( int_nokey, int_key ) VALUES (622, 622); INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956); INSERT INTO E ( int_nokey, int_key ) VALUES (652, 652); INSERT INTO E ( int_nokey, int_key ) VALUES (391, 391); INSERT INTO E ( int_nokey, int_key ) VALUES (875, 875); INSERT INTO E ( int_nokey, int_key ) VALUES (743, 743); INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347); INSERT INTO E ( int_nokey, int_key ) VALUES (395, 395); INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956); INSERT INTO E ( int_nokey, int_key ) VALUES (623, 623); INSERT INTO E ( int_nokey, int_key ) VALUES (525, 525); INSERT INTO E ( int_nokey, int_key ) VALUES (140, 140); INSERT INTO E ( int_nokey, int_key ) VALUES (119, 119); INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136); INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94); INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857); INSERT INTO E ( int_nokey, int_key ) VALUES (20, 20); INSERT INTO E ( int_nokey, int_key ) VALUES (77, 77); INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58); INSERT INTO E ( int_nokey, int_key ) VALUES (243, 243); INSERT INTO E ( int_nokey, int_key ) VALUES (21, 21); INSERT INTO E ( int_nokey, int_key ) VALUES (879, 879); INSERT INTO E ( int_nokey, int_key ) VALUES (999, 999); INSERT INTO E ( int_nokey, int_key ) VALUES (678, 678); INSERT INTO E ( int_nokey, int_key ) VALUES (986, 986); INSERT INTO E ( int_nokey, int_key ) VALUES (521, 521); INSERT INTO E ( int_nokey, int_key ) VALUES (259, 259); INSERT INTO E ( int_nokey, int_key ) VALUES (711, 711); INSERT INTO E ( int_nokey, int_key ) VALUES (458, 458); INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235); INSERT INTO E ( int_nokey, int_key ) VALUES (230, 230); INSERT INTO E ( int_nokey, int_key ) VALUES (145, 145); INSERT INTO E ( int_nokey, int_key ) VALUES (506, 506); INSERT INTO E ( int_nokey, int_key ) VALUES (734, 734); INSERT INTO E ( int_nokey, int_key ) VALUES (873, 873); INSERT INTO E ( int_nokey, int_key ) VALUES (920, 920); INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753); INSERT INTO E ( int_nokey, int_key ) VALUES (941, 941); INSERT INTO E ( int_nokey, int_key ) VALUES (792, 792); INSERT INTO E ( int_nokey, int_key ) VALUES (587, 587); INSERT INTO E ( int_nokey, int_key ) VALUES (420, 420); INSERT INTO E ( int_nokey, int_key ) VALUES (799, 799); INSERT INTO E ( int_nokey, int_key ) VALUES (944, 944); INSERT INTO E ( int_nokey, int_key ) VALUES (597, 597); INSERT INTO E ( int_nokey, int_key ) VALUES (397, 397); INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939); INSERT INTO E ( int_nokey, int_key ) VALUES (996, 996); INSERT INTO E ( int_nokey, int_key ) VALUES (328, 328); INSERT INTO E ( int_nokey, int_key ) VALUES (579, 579); INSERT INTO E ( int_nokey, int_key ) VALUES (64, 64); INSERT INTO E ( int_nokey, int_key ) VALUES (622, 622); INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982); INSERT INTO E ( int_nokey, int_key ) VALUES (108, 108); INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378); INSERT INTO E ( int_nokey, int_key ) VALUES (995, 995); INSERT INTO E ( int_nokey, int_key ) VALUES (99, 99); INSERT INTO E ( int_nokey, int_key ) VALUES (842, 842); INSERT INTO E ( int_nokey, int_key ) VALUES (433, 433); INSERT INTO E ( int_nokey, int_key ) VALUES (663, 663); INSERT INTO E ( int_nokey, int_key ) VALUES (762, 762); INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921); INSERT INTO E ( int_nokey, int_key ) VALUES (9, 9); INSERT INTO E ( int_nokey, int_key ) VALUES (895, 895); INSERT INTO E ( int_nokey, int_key ) VALUES (2, 2); INSERT INTO E ( int_nokey, int_key ) VALUES (653, 653); INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184); INSERT INTO E ( int_nokey, int_key ) VALUES (905, 905); INSERT INTO E ( int_nokey, int_key ) VALUES (809, 809); INSERT INTO E ( int_nokey, int_key ) VALUES (124, 124); INSERT INTO E ( int_nokey, int_key ) VALUES (446, 446); INSERT INTO E ( int_nokey, int_key ) VALUES (777, 777); INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501); INSERT INTO E ( int_nokey, int_key ) VALUES (810, 810); INSERT INTO E ( int_nokey, int_key ) VALUES (381, 381); INSERT INTO E ( int_nokey, int_key ) VALUES (970, 970); INSERT INTO E ( int_nokey, int_key ) VALUES (224, 224); INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435); INSERT INTO E ( int_nokey, int_key ) VALUES (401, 401); INSERT INTO E ( int_nokey, int_key ) VALUES (360, 360); INSERT INTO E ( int_nokey, int_key ) VALUES (757, 757); INSERT INTO E ( int_nokey, int_key ) VALUES (167, 167); INSERT INTO E ( int_nokey, int_key ) VALUES (609, 609); INSERT INTO E ( int_nokey, int_key ) VALUES (607, 607); INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728); INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745); INSERT INTO E ( int_nokey, int_key ) VALUES (929, 929); INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148); INSERT INTO E ( int_nokey, int_key ) VALUES (31, 31); INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60); INSERT INTO E ( int_nokey, int_key ) VALUES (190, 190); INSERT INTO E ( int_nokey, int_key ) VALUES (339, 339); INSERT INTO E ( int_nokey, int_key ) VALUES (940, 940); INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141); INSERT INTO E ( int_nokey, int_key ) VALUES (928, 928); INSERT INTO E ( int_nokey, int_key ) VALUES (642, 642); INSERT INTO E ( int_nokey, int_key ) VALUES (814, 814); INSERT INTO E ( int_nokey, int_key ) VALUES (182, 182); INSERT INTO E ( int_nokey, int_key ) VALUES (283, 283); INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591); INSERT INTO E ( int_nokey, int_key ) VALUES (696, 696); INSERT INTO E ( int_nokey, int_key ) VALUES (679, 679); INSERT INTO E ( int_nokey, int_key ) VALUES (612, 612); INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611); INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804); INSERT INTO E ( int_nokey, int_key ) VALUES (469, 469); INSERT INTO E ( int_nokey, int_key ) VALUES (231, 231); INSERT INTO E ( int_nokey, int_key ) VALUES (9, 9); INSERT INTO E ( int_nokey, int_key ) VALUES (115, 115); INSERT INTO E ( int_nokey, int_key ) VALUES (552, 552); INSERT INTO E ( int_nokey, int_key ) VALUES (455, 455); INSERT INTO E ( int_nokey, int_key ) VALUES (463, 463); INSERT INTO E ( int_nokey, int_key ) VALUES (831, 831); INSERT INTO E ( int_nokey, int_key ) VALUES (338, 338); INSERT INTO E ( int_nokey, int_key ) VALUES (338, 338); INSERT INTO E ( int_nokey, int_key ) VALUES (513, 513); INSERT INTO E ( int_nokey, int_key ) VALUES (819, 819); INSERT INTO E ( int_nokey, int_key ) VALUES (900, 900); INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148); INSERT INTO E ( int_nokey, int_key ) VALUES (481, 481); INSERT INTO E ( int_nokey, int_key ) VALUES (369, 369); INSERT INTO E ( int_nokey, int_key ) VALUES (267, 267); INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804); INSERT INTO E ( int_nokey, int_key ) VALUES (493, 493); INSERT INTO E ( int_nokey, int_key ) VALUES (299, 299); INSERT INTO E ( int_nokey, int_key ) VALUES (460, 460); INSERT INTO E ( int_nokey, int_key ) VALUES (426, 426); INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54); INSERT INTO E ( int_nokey, int_key ) VALUES (332, 332); INSERT INTO E ( int_nokey, int_key ) VALUES (260, 260); INSERT INTO E ( int_nokey, int_key ) VALUES (900, 900); INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656); INSERT INTO E ( int_nokey, int_key ) VALUES (192, 192); INSERT INTO E ( int_nokey, int_key ) VALUES (708, 708); INSERT INTO E ( int_nokey, int_key ) VALUES (254, 254); INSERT INTO E ( int_nokey, int_key ) VALUES (82, 82); INSERT INTO E ( int_nokey, int_key ) VALUES (424, 424); INSERT INTO E ( int_nokey, int_key ) VALUES (246, 246); INSERT INTO E ( int_nokey, int_key ) VALUES (565, 565); INSERT INTO E ( int_nokey, int_key ) VALUES (274, 274); INSERT INTO E ( int_nokey, int_key ) VALUES (909, 909); INSERT INTO E ( int_nokey, int_key ) VALUES (883, 883); INSERT INTO E ( int_nokey, int_key ) VALUES (751, 751); INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378); INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436); INSERT INTO E ( int_nokey, int_key ) VALUES (807, 807); INSERT INTO E ( int_nokey, int_key ) VALUES (571, 571); INSERT INTO E ( int_nokey, int_key ) VALUES (930, 930); INSERT INTO E ( int_nokey, int_key ) VALUES (824, 824); INSERT INTO E ( int_nokey, int_key ) VALUES (532, 532); INSERT INTO E ( int_nokey, int_key ) VALUES (368, 368); INSERT INTO E ( int_nokey, int_key ) VALUES (278, 278); INSERT INTO E ( int_nokey, int_key ) VALUES (549, 549); INSERT INTO E ( int_nokey, int_key ) VALUES (940, 940); INSERT INTO E ( int_nokey, int_key ) VALUES (11, 11); INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457); INSERT INTO E ( int_nokey, int_key ) VALUES (56, 56); INSERT INTO E ( int_nokey, int_key ) VALUES (825, 825); INSERT INTO E ( int_nokey, int_key ) VALUES (350, 350); INSERT INTO E ( int_nokey, int_key ) VALUES (637, 637); INSERT INTO E ( int_nokey, int_key ) VALUES (843, 843); INSERT INTO E ( int_nokey, int_key ) VALUES (747, 747); INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415); INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425); INSERT INTO E ( int_nokey, int_key ) VALUES (642, 642); INSERT INTO E ( int_nokey, int_key ) VALUES (889, 889); INSERT INTO E ( int_nokey, int_key ) VALUES (196, 196); INSERT INTO E ( int_nokey, int_key ) VALUES (40, 40); INSERT INTO E ( int_nokey, int_key ) VALUES (988, 988); INSERT INTO E ( int_nokey, int_key ) VALUES (22, 22); INSERT INTO E ( int_nokey, int_key ) VALUES (989, 989); INSERT INTO E ( int_nokey, int_key ) VALUES (393, 393); INSERT INTO E ( int_nokey, int_key ) VALUES (801, 801); INSERT INTO E ( int_nokey, int_key ) VALUES (865, 865); INSERT INTO E ( int_nokey, int_key ) VALUES (868, 868); INSERT INTO E ( int_nokey, int_key ) VALUES (397, 397); INSERT INTO E ( int_nokey, int_key ) VALUES (251, 251); INSERT INTO E ( int_nokey, int_key ) VALUES (750, 750); INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543); INSERT INTO E ( int_nokey, int_key ) VALUES (180, 180); INSERT INTO E ( int_nokey, int_key ) VALUES (846, 846); INSERT INTO E ( int_nokey, int_key ) VALUES (193, 193); INSERT INTO E ( int_nokey, int_key ) VALUES (808, 808); INSERT INTO E ( int_nokey, int_key ) VALUES (12, 12); INSERT INTO E ( int_nokey, int_key ) VALUES (818, 818); INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407); INSERT INTO E ( int_nokey, int_key ) VALUES (459, 459); INSERT INTO E ( int_nokey, int_key ) VALUES (547, 547); INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220); INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907); INSERT INTO E ( int_nokey, int_key ) VALUES (372, 372); INSERT INTO E ( int_nokey, int_key ) VALUES (893, 893); INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660); INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788); INSERT INTO E ( int_nokey, int_key ) VALUES (667, 667); INSERT INTO E ( int_nokey, int_key ) VALUES (31, 31); INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94); INSERT INTO E ( int_nokey, int_key ) VALUES (326, 326); INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184); INSERT INTO E ( int_nokey, int_key ) VALUES (281, 281); INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58); INSERT INTO E ( int_nokey, int_key ) VALUES (801, 801); INSERT INTO E ( int_nokey, int_key ) VALUES (970, 970); INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132); INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910); INSERT INTO E ( int_nokey, int_key ) VALUES (619, 619); INSERT INTO E ( int_nokey, int_key ) VALUES (37, 37); INSERT INTO E ( int_nokey, int_key ) VALUES (380, 380); INSERT INTO E ( int_nokey, int_key ) VALUES (247, 247); INSERT INTO E ( int_nokey, int_key ) VALUES (320, 320); INSERT INTO E ( int_nokey, int_key ) VALUES (190, 190); INSERT INTO E ( int_nokey, int_key ) VALUES (716, 716); INSERT INTO E ( int_nokey, int_key ) VALUES (298, 298); INSERT INTO E ( int_nokey, int_key ) VALUES (146, 146); INSERT INTO E ( int_nokey, int_key ) VALUES (376, 376); INSERT INTO E ( int_nokey, int_key ) VALUES (808, 808); INSERT INTO E ( int_nokey, int_key ) VALUES (544, 544); INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675); INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591); INSERT INTO E ( int_nokey, int_key ) VALUES (272, 272); INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811); INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371); INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141); INSERT INTO E ( int_nokey, int_key ) VALUES (570, 570); INSERT INTO E ( int_nokey, int_key ) VALUES (758, 758); INSERT INTO E ( int_nokey, int_key ) VALUES (871, 871); INSERT INTO E ( int_nokey, int_key ) VALUES (707, 707); INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611); INSERT INTO E ( int_nokey, int_key ) VALUES (5, 5); INSERT INTO E ( int_nokey, int_key ) VALUES (374, 374); INSERT INTO E ( int_nokey, int_key ) VALUES (697, 697); INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227); INSERT INTO E ( int_nokey, int_key ) VALUES (636, 636); INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907); INSERT INTO E ( int_nokey, int_key ) VALUES (249, 249); INSERT INTO E ( int_nokey, int_key ) VALUES (724, 724); INSERT INTO E ( int_nokey, int_key ) VALUES (480, 480); INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727); INSERT INTO E ( int_nokey, int_key ) VALUES (862, 862); INSERT INTO E ( int_nokey, int_key ) VALUES (530, 530); INSERT INTO E ( int_nokey, int_key ) VALUES (601, 601); INSERT INTO E ( int_nokey, int_key ) VALUES (866, 866); INSERT INTO E ( int_nokey, int_key ) VALUES (0, 0); INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745); INSERT INTO E ( int_nokey, int_key ) VALUES (652, 652); INSERT INTO E ( int_nokey, int_key ) VALUES (509, 509); INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592); INSERT INTO E ( int_nokey, int_key ) VALUES (969, 969); INSERT INTO E ( int_nokey, int_key ) VALUES (58, 58); INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592); INSERT INTO E ( int_nokey, int_key ) VALUES (717, 717); INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415); INSERT INTO E ( int_nokey, int_key ) VALUES (181, 181); INSERT INTO E ( int_nokey, int_key ) VALUES (783, 783); INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702); INSERT INTO E ( int_nokey, int_key ) VALUES (587, 587); INSERT INTO E ( int_nokey, int_key ) VALUES (88, 88); INSERT INTO E ( int_nokey, int_key ) VALUES (836, 836); INSERT INTO E ( int_nokey, int_key ) VALUES (872, 872); INSERT INTO E ( int_nokey, int_key ) VALUES (996, 996); INSERT INTO E ( int_nokey, int_key ) VALUES (162, 162); INSERT INTO E ( int_nokey, int_key ) VALUES (725, 725); INSERT INTO E ( int_nokey, int_key ) VALUES (116, 116); INSERT INTO E ( int_nokey, int_key ) VALUES (916, 916); INSERT INTO E ( int_nokey, int_key ) VALUES (466, 466); INSERT INTO E ( int_nokey, int_key ) VALUES (737, 737); INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702); INSERT INTO E ( int_nokey, int_key ) VALUES (325, 325); INSERT INTO E ( int_nokey, int_key ) VALUES (441, 441); INSERT INTO E ( int_nokey, int_key ) VALUES (904, 904); INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546); INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93); INSERT INTO E ( int_nokey, int_key ) VALUES (519, 519); INSERT INTO E ( int_nokey, int_key ) VALUES (360, 360); INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435); INSERT INTO E ( int_nokey, int_key ) VALUES (598, 598); INSERT INTO E ( int_nokey, int_key ) VALUES (663, 663); INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910); INSERT INTO E ( int_nokey, int_key ) VALUES (147, 147); INSERT INTO E ( int_nokey, int_key ) VALUES (47, 47); INSERT INTO E ( int_nokey, int_key ) VALUES (529, 529); INSERT INTO E ( int_nokey, int_key ) VALUES (845, 845); INSERT INTO E ( int_nokey, int_key ) VALUES (779, 779); INSERT INTO E ( int_nokey, int_key ) VALUES (479, 479); INSERT INTO E ( int_nokey, int_key ) VALUES (931, 931); INSERT INTO E ( int_nokey, int_key ) VALUES (669, 669); INSERT INTO E ( int_nokey, int_key ) VALUES (657, 657); INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132); INSERT INTO E ( int_nokey, int_key ) VALUES (37, 37); INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347); INSERT INTO E ( int_nokey, int_key ) VALUES (676, 676); INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378); INSERT INTO E ( int_nokey, int_key ) VALUES (323, 323); INSERT INTO E ( int_nokey, int_key ) VALUES (266, 266); INSERT INTO E ( int_nokey, int_key ) VALUES (790, 790); INSERT INTO E ( int_nokey, int_key ) VALUES (780, 780); INSERT INTO E ( int_nokey, int_key ) VALUES (616, 616); INSERT INTO E ( int_nokey, int_key ) VALUES (619, 619); INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130); INSERT INTO E ( int_nokey, int_key ) VALUES (69, 69); INSERT INTO E ( int_nokey, int_key ) VALUES (812, 812); INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60); INSERT INTO E ( int_nokey, int_key ) VALUES (128, 128); INSERT INTO E ( int_nokey, int_key ) VALUES (484, 484); INSERT INTO E ( int_nokey, int_key ) VALUES (465, 465); INSERT INTO E ( int_nokey, int_key ) VALUES (534, 534); INSERT INTO E ( int_nokey, int_key ) VALUES (417, 417); INSERT INTO E ( int_nokey, int_key ) VALUES (333, 333); INSERT INTO E ( int_nokey, int_key ) VALUES (555, 555); INSERT INTO E ( int_nokey, int_key ) VALUES (172, 172); INSERT INTO E ( int_nokey, int_key ) VALUES (586, 586); INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965); INSERT INTO E ( int_nokey, int_key ) VALUES (383, 383); INSERT INTO E ( int_nokey, int_key ) VALUES (283, 283); INSERT INTO E ( int_nokey, int_key ) VALUES (305, 305); INSERT INTO E ( int_nokey, int_key ) VALUES (984, 984); INSERT INTO E ( int_nokey, int_key ) VALUES (925, 925); INSERT INTO E ( int_nokey, int_key ) VALUES (213, 213); INSERT INTO E ( int_nokey, int_key ) VALUES (591, 591); INSERT INTO E ( int_nokey, int_key ) VALUES (445, 445); INSERT INTO E ( int_nokey, int_key ) VALUES (550, 550); INSERT INTO E ( int_nokey, int_key ) VALUES (309, 309); INSERT INTO E ( int_nokey, int_key ) VALUES (13, 13); INSERT INTO E ( int_nokey, int_key ) VALUES (477, 477); INSERT INTO E ( int_nokey, int_key ) VALUES (92, 92); INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204); INSERT INTO E ( int_nokey, int_key ) VALUES (471, 471); INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739); INSERT INTO E ( int_nokey, int_key ) VALUES (847, 847); INSERT INTO E ( int_nokey, int_key ) VALUES (239, 239); INSERT INTO E ( int_nokey, int_key ) VALUES (502, 502); INSERT INTO E ( int_nokey, int_key ) VALUES (245, 245); INSERT INTO E ( int_nokey, int_key ) VALUES (449, 449); INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263); INSERT INTO E ( int_nokey, int_key ) VALUES (210, 210); INSERT INTO E ( int_nokey, int_key ) VALUES (336, 336); INSERT INTO E ( int_nokey, int_key ) VALUES (309, 309); INSERT INTO E ( int_nokey, int_key ) VALUES (216, 216); INSERT INTO E ( int_nokey, int_key ) VALUES (375, 375); INSERT INTO E ( int_nokey, int_key ) VALUES (78, 78); INSERT INTO E ( int_nokey, int_key ) VALUES (697, 697); INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512); INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625); INSERT INTO E ( int_nokey, int_key ) VALUES (696, 696); INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745); INSERT INTO E ( int_nokey, int_key ) VALUES (78, 78); INSERT INTO E ( int_nokey, int_key ) VALUES (56, 56); INSERT INTO E ( int_nokey, int_key ) VALUES (144, 144); INSERT INTO E ( int_nokey, int_key ) VALUES (907, 907); INSERT INTO E ( int_nokey, int_key ) VALUES (103, 103); INSERT INTO E ( int_nokey, int_key ) VALUES (242, 242); INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764); INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425); INSERT INTO E ( int_nokey, int_key ) VALUES (760, 760); INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184); INSERT INTO E ( int_nokey, int_key ) VALUES (689, 689); INSERT INTO E ( int_nokey, int_key ) VALUES (502, 502); INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965); INSERT INTO E ( int_nokey, int_key ) VALUES (630, 630); INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84); INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263); INSERT INTO E ( int_nokey, int_key ) VALUES (151, 151); INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136); INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83); INSERT INTO E ( int_nokey, int_key ) VALUES (651, 651); INSERT INTO E ( int_nokey, int_key ) VALUES (91, 91); INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704); INSERT INTO E ( int_nokey, int_key ) VALUES (986, 986); INSERT INTO E ( int_nokey, int_key ) VALUES (875, 875); INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382); INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371); INSERT INTO E ( int_nokey, int_key ) VALUES (616, 616); INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235); INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753); INSERT INTO E ( int_nokey, int_key ) VALUES (592, 592); INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982); INSERT INTO E ( int_nokey, int_key ) VALUES (428, 428); INSERT INTO E ( int_nokey, int_key ) VALUES (214, 214); INSERT INTO E ( int_nokey, int_key ) VALUES (864, 864); INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394); INSERT INTO E ( int_nokey, int_key ) VALUES (206, 206); INSERT INTO E ( int_nokey, int_key ) VALUES (19, 19); INSERT INTO E ( int_nokey, int_key ) VALUES (934, 934); INSERT INTO E ( int_nokey, int_key ) VALUES (954, 954); INSERT INTO E ( int_nokey, int_key ) VALUES (246, 246); INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704); INSERT INTO E ( int_nokey, int_key ) VALUES (235, 235); INSERT INTO E ( int_nokey, int_key ) VALUES (723, 723); INSERT INTO E ( int_nokey, int_key ) VALUES (834, 834); INSERT INTO E ( int_nokey, int_key ) VALUES (356, 356); INSERT INTO E ( int_nokey, int_key ) VALUES (149, 149); INSERT INTO E ( int_nokey, int_key ) VALUES (664, 664); INSERT INTO E ( int_nokey, int_key ) VALUES (754, 754); INSERT INTO E ( int_nokey, int_key ) VALUES (872, 872); INSERT INTO E ( int_nokey, int_key ) VALUES (317, 317); INSERT INTO E ( int_nokey, int_key ) VALUES (657, 657); INSERT INTO E ( int_nokey, int_key ) VALUES (98, 98); INSERT INTO E ( int_nokey, int_key ) VALUES (883, 883); INSERT INTO E ( int_nokey, int_key ) VALUES (70, 70); INSERT INTO E ( int_nokey, int_key ) VALUES (867, 867); INSERT INTO E ( int_nokey, int_key ) VALUES (406, 406); INSERT INTO E ( int_nokey, int_key ) VALUES (413, 413); INSERT INTO E ( int_nokey, int_key ) VALUES (778, 778); INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703); INSERT INTO E ( int_nokey, int_key ) VALUES (208, 208); INSERT INTO E ( int_nokey, int_key ) VALUES (70, 70); INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501); INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611); INSERT INTO E ( int_nokey, int_key ) VALUES (946, 946); INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811); INSERT INTO E ( int_nokey, int_key ) VALUES (161, 161); INSERT INTO E ( int_nokey, int_key ) VALUES (286, 286); INSERT INTO E ( int_nokey, int_key ) VALUES (48, 48); INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268); INSERT INTO E ( int_nokey, int_key ) VALUES (753, 753); INSERT INTO E ( int_nokey, int_key ) VALUES (315, 315); INSERT INTO E ( int_nokey, int_key ) VALUES (500, 500); INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407); INSERT INTO E ( int_nokey, int_key ) VALUES (112, 112); INSERT INTO E ( int_nokey, int_key ) VALUES (231, 231); INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148); INSERT INTO E ( int_nokey, int_key ) VALUES (505, 505); INSERT INTO E ( int_nokey, int_key ) VALUES (903, 903); INSERT INTO E ( int_nokey, int_key ) VALUES (874, 874); INSERT INTO E ( int_nokey, int_key ) VALUES (719, 719); INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61); INSERT INTO E ( int_nokey, int_key ) VALUES (861, 861); INSERT INTO E ( int_nokey, int_key ) VALUES (400, 400); INSERT INTO E ( int_nokey, int_key ) VALUES (655, 655); INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382); INSERT INTO E ( int_nokey, int_key ) VALUES (563, 563); INSERT INTO E ( int_nokey, int_key ) VALUES (348, 348); INSERT INTO E ( int_nokey, int_key ) VALUES (437, 437); INSERT INTO E ( int_nokey, int_key ) VALUES (50, 50); INSERT INTO E ( int_nokey, int_key ) VALUES (36, 36); INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625); INSERT INTO E ( int_nokey, int_key ) VALUES (632, 632); INSERT INTO E ( int_nokey, int_key ) VALUES (743, 743); INSERT INTO E ( int_nokey, int_key ) VALUES (251, 251); INSERT INTO E ( int_nokey, int_key ) VALUES (746, 746); INSERT INTO E ( int_nokey, int_key ) VALUES (74, 74); INSERT INTO E ( int_nokey, int_key ) VALUES (777, 777); INSERT INTO E ( int_nokey, int_key ) VALUES (704, 704); INSERT INTO E ( int_nokey, int_key ) VALUES (250, 250); INSERT INTO E ( int_nokey, int_key ) VALUES (960, 960); INSERT INTO E ( int_nokey, int_key ) VALUES (60, 60); INSERT INTO E ( int_nokey, int_key ) VALUES (993, 993); INSERT INTO E ( int_nokey, int_key ) VALUES (57, 57); INSERT INTO E ( int_nokey, int_key ) VALUES (333, 333); INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656); INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130); INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919); INSERT INTO E ( int_nokey, int_key ) VALUES (45, 45); INSERT INTO E ( int_nokey, int_key ) VALUES (65, 65); INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703); INSERT INTO E ( int_nokey, int_key ) VALUES (949, 949); INSERT INTO E ( int_nokey, int_key ) VALUES (570, 570); INSERT INTO E ( int_nokey, int_key ) VALUES (273, 273); INSERT INTO E ( int_nokey, int_key ) VALUES (118, 118); INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728); INSERT INTO E ( int_nokey, int_key ) VALUES (506, 506); INSERT INTO E ( int_nokey, int_key ) VALUES (271, 271); INSERT INTO E ( int_nokey, int_key ) VALUES (987, 987); INSERT INTO E ( int_nokey, int_key ) VALUES (483, 483); INSERT INTO E ( int_nokey, int_key ) VALUES (577, 577); INSERT INTO E ( int_nokey, int_key ) VALUES (572, 572); INSERT INTO E ( int_nokey, int_key ) VALUES (965, 965); INSERT INTO E ( int_nokey, int_key ) VALUES (495, 495); INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54); INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438); INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457); INSERT INTO E ( int_nokey, int_key ) VALUES (798, 798); INSERT INTO E ( int_nokey, int_key ) VALUES (431, 431); INSERT INTO E ( int_nokey, int_key ) VALUES (300, 300); INSERT INTO E ( int_nokey, int_key ) VALUES (982, 982); INSERT INTO E ( int_nokey, int_key ) VALUES (712, 712); INSERT INTO E ( int_nokey, int_key ) VALUES (776, 776); INSERT INTO E ( int_nokey, int_key ) VALUES (934, 934); INSERT INTO E ( int_nokey, int_key ) VALUES (335, 335); INSERT INTO E ( int_nokey, int_key ) VALUES (958, 958); INSERT INTO E ( int_nokey, int_key ) VALUES (483, 483); INSERT INTO E ( int_nokey, int_key ) VALUES (462, 462); INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268); INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654); INSERT INTO E ( int_nokey, int_key ) VALUES (145, 145); INSERT INTO E ( int_nokey, int_key ) VALUES (184, 184); INSERT INTO E ( int_nokey, int_key ) VALUES (135, 135); INSERT INTO E ( int_nokey, int_key ) VALUES (46, 46); INSERT INTO E ( int_nokey, int_key ) VALUES (532, 532); INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804); INSERT INTO E ( int_nokey, int_key ) VALUES (923, 923); INSERT INTO E ( int_nokey, int_key ) VALUES (284, 284); INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148); INSERT INTO E ( int_nokey, int_key ) VALUES (107, 107); INSERT INTO E ( int_nokey, int_key ) VALUES (446, 446); INSERT INTO E ( int_nokey, int_key ) VALUES (191, 191); INSERT INTO E ( int_nokey, int_key ) VALUES (705, 705); INSERT INTO E ( int_nokey, int_key ) VALUES (666, 666); INSERT INTO E ( int_nokey, int_key ) VALUES (156, 156); INSERT INTO E ( int_nokey, int_key ) VALUES (791, 791); INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84); INSERT INTO E ( int_nokey, int_key ) VALUES (499, 499); INSERT INTO E ( int_nokey, int_key ) VALUES (407, 407); INSERT INTO E ( int_nokey, int_key ) VALUES (359, 359); INSERT INTO E ( int_nokey, int_key ) VALUES (608, 608); INSERT INTO E ( int_nokey, int_key ) VALUES (661, 661); INSERT INTO E ( int_nokey, int_key ) VALUES (821, 821); INSERT INTO E ( int_nokey, int_key ) VALUES (80, 80); INSERT INTO E ( int_nokey, int_key ) VALUES (733, 733); INSERT INTO E ( int_nokey, int_key ) VALUES (823, 823); INSERT INTO E ( int_nokey, int_key ) VALUES (300, 300); INSERT INTO E ( int_nokey, int_key ) VALUES (693, 693); INSERT INTO E ( int_nokey, int_key ) VALUES (863, 863); INSERT INTO E ( int_nokey, int_key ) VALUES (734, 734); INSERT INTO E ( int_nokey, int_key ) VALUES (768, 768); INSERT INTO E ( int_nokey, int_key ) VALUES (52, 52); INSERT INTO E ( int_nokey, int_key ) VALUES (793, 793); INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756); INSERT INTO E ( int_nokey, int_key ) VALUES (770, 770); INSERT INTO E ( int_nokey, int_key ) VALUES (644, 644); INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220); INSERT INTO E ( int_nokey, int_key ) VALUES (109, 109); INSERT INTO E ( int_nokey, int_key ) VALUES (976, 976); INSERT INTO E ( int_nokey, int_key ) VALUES (291, 291); INSERT INTO E ( int_nokey, int_key ) VALUES (729, 729); INSERT INTO E ( int_nokey, int_key ) VALUES (151, 151); INSERT INTO E ( int_nokey, int_key ) VALUES (604, 604); INSERT INTO E ( int_nokey, int_key ) VALUES (367, 367); INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71); INSERT INTO E ( int_nokey, int_key ) VALUES (515, 515); INSERT INTO E ( int_nokey, int_key ) VALUES (912, 912); INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625); INSERT INTO E ( int_nokey, int_key ) VALUES (402, 402); INSERT INTO E ( int_nokey, int_key ) VALUES (768, 768); INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654); INSERT INTO E ( int_nokey, int_key ) VALUES (675, 675); INSERT INTO E ( int_nokey, int_key ) VALUES (326, 326); INSERT INTO E ( int_nokey, int_key ) VALUES (888, 888); INSERT INTO E ( int_nokey, int_key ) VALUES (683, 683); INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94); INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175); INSERT INTO E ( int_nokey, int_key ) VALUES (265, 265); INSERT INTO E ( int_nokey, int_key ) VALUES (443, 443); INSERT INTO E ( int_nokey, int_key ) VALUES (345, 345); INSERT INTO E ( int_nokey, int_key ) VALUES (306, 306); INSERT INTO E ( int_nokey, int_key ) VALUES (399, 399); INSERT INTO E ( int_nokey, int_key ) VALUES (557, 557); INSERT INTO E ( int_nokey, int_key ) VALUES (59, 59); INSERT INTO E ( int_nokey, int_key ) VALUES (484, 484); INSERT INTO E ( int_nokey, int_key ) VALUES (429, 429); INSERT INTO E ( int_nokey, int_key ) VALUES (249, 249); INSERT INTO E ( int_nokey, int_key ) VALUES (728, 728); INSERT INTO E ( int_nokey, int_key ) VALUES (501, 501); INSERT INTO E ( int_nokey, int_key ) VALUES (307, 307); INSERT INTO E ( int_nokey, int_key ) VALUES (173, 173); INSERT INTO E ( int_nokey, int_key ) VALUES (520, 520); INSERT INTO E ( int_nokey, int_key ) VALUES (229, 229); INSERT INTO E ( int_nokey, int_key ) VALUES (583, 583); INSERT INTO E ( int_nokey, int_key ) VALUES (950, 950); INSERT INTO E ( int_nokey, int_key ) VALUES (412, 412); INSERT INTO E ( int_nokey, int_key ) VALUES (810, 810); INSERT INTO E ( int_nokey, int_key ) VALUES (586, 586); INSERT INTO E ( int_nokey, int_key ) VALUES (276, 276); INSERT INTO E ( int_nokey, int_key ) VALUES (256, 256); INSERT INTO E ( int_nokey, int_key ) VALUES (722, 722); INSERT INTO E ( int_nokey, int_key ) VALUES (419, 419); INSERT INTO E ( int_nokey, int_key ) VALUES (727, 727); INSERT INTO E ( int_nokey, int_key ) VALUES (180, 180); INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130); INSERT INTO E ( int_nokey, int_key ) VALUES (738, 738); INSERT INTO E ( int_nokey, int_key ) VALUES (148, 148); INSERT INTO E ( int_nokey, int_key ) VALUES (38, 38); INSERT INTO E ( int_nokey, int_key ) VALUES (346, 346); INSERT INTO E ( int_nokey, int_key ) VALUES (263, 263); INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804); INSERT INTO E ( int_nokey, int_key ) VALUES (584, 584); INSERT INTO E ( int_nokey, int_key ) VALUES (972, 972); INSERT INTO E ( int_nokey, int_key ) VALUES (485, 485); INSERT INTO E ( int_nokey, int_key ) VALUES (989, 989); INSERT INTO E ( int_nokey, int_key ) VALUES (22, 22); INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512); INSERT INTO E ( int_nokey, int_key ) VALUES (891, 891); INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756); INSERT INTO E ( int_nokey, int_key ) VALUES (284, 284); INSERT INTO E ( int_nokey, int_key ) VALUES (146, 146); INSERT INTO E ( int_nokey, int_key ) VALUES (270, 270); INSERT INTO E ( int_nokey, int_key ) VALUES (379, 379); INSERT INTO E ( int_nokey, int_key ) VALUES (371, 371); INSERT INTO E ( int_nokey, int_key ) VALUES (997, 997); INSERT INTO E ( int_nokey, int_key ) VALUES (624, 624); INSERT INTO E ( int_nokey, int_key ) VALUES (559, 559); INSERT INTO E ( int_nokey, int_key ) VALUES (690, 690); INSERT INTO E ( int_nokey, int_key ) VALUES (369, 369); INSERT INTO E ( int_nokey, int_key ) VALUES (625, 625); INSERT INTO E ( int_nokey, int_key ) VALUES (604, 604); INSERT INTO E ( int_nokey, int_key ) VALUES (340, 340); INSERT INTO E ( int_nokey, int_key ) VALUES (253, 253); INSERT INTO E ( int_nokey, int_key ) VALUES (316, 316); INSERT INTO E ( int_nokey, int_key ) VALUES (481, 481); INSERT INTO E ( int_nokey, int_key ) VALUES (572, 572); INSERT INTO E ( int_nokey, int_key ) VALUES (117, 117); INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512); INSERT INTO E ( int_nokey, int_key ) VALUES (94, 94); INSERT INTO E ( int_nokey, int_key ) VALUES (311, 311); INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788); INSERT INTO E ( int_nokey, int_key ) VALUES (281, 281); INSERT INTO E ( int_nokey, int_key ) VALUES (118, 118); INSERT INTO E ( int_nokey, int_key ) VALUES (26, 26); INSERT INTO E ( int_nokey, int_key ) VALUES (918, 918); INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660); INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394); INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739); INSERT INTO E ( int_nokey, int_key ) VALUES (342, 342); INSERT INTO E ( int_nokey, int_key ) VALUES (921, 921); INSERT INTO E ( int_nokey, int_key ) VALUES (365, 365); INSERT INTO E ( int_nokey, int_key ) VALUES (594, 594); INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764); INSERT INTO E ( int_nokey, int_key ) VALUES (788, 788); INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132); INSERT INTO E ( int_nokey, int_key ) VALUES (563, 563); INSERT INTO E ( int_nokey, int_key ) VALUES (131, 131); INSERT INTO E ( int_nokey, int_key ) VALUES (44, 44); INSERT INTO E ( int_nokey, int_key ) VALUES (868, 868); INSERT INTO E ( int_nokey, int_key ) VALUES (415, 415); INSERT INTO E ( int_nokey, int_key ) VALUES (335, 335); INSERT INTO E ( int_nokey, int_key ) VALUES (367, 367); INSERT INTO E ( int_nokey, int_key ) VALUES (221, 221); INSERT INTO E ( int_nokey, int_key ) VALUES (418, 418); INSERT INTO E ( int_nokey, int_key ) VALUES (108, 108); INSERT INTO E ( int_nokey, int_key ) VALUES (384, 384); INSERT INTO E ( int_nokey, int_key ) VALUES (569, 569); INSERT INTO E ( int_nokey, int_key ) VALUES (951, 951); INSERT INTO E ( int_nokey, int_key ) VALUES (206, 206); INSERT INTO E ( int_nokey, int_key ) VALUES (203, 203); INSERT INTO E ( int_nokey, int_key ) VALUES (68, 68); INSERT INTO E ( int_nokey, int_key ) VALUES (869, 869); INSERT INTO E ( int_nokey, int_key ) VALUES (827, 827); INSERT INTO E ( int_nokey, int_key ) VALUES (893, 893); INSERT INTO E ( int_nokey, int_key ) VALUES (271, 271); INSERT INTO E ( int_nokey, int_key ) VALUES (268, 268); INSERT INTO E ( int_nokey, int_key ) VALUES (319, 319); INSERT INTO E ( int_nokey, int_key ) VALUES (725, 725); INSERT INTO E ( int_nokey, int_key ) VALUES (948, 948); INSERT INTO E ( int_nokey, int_key ) VALUES (10, 10); INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204); INSERT INTO E ( int_nokey, int_key ) VALUES (714, 714); INSERT INTO E ( int_nokey, int_key ) VALUES (764, 764); INSERT INTO E ( int_nokey, int_key ) VALUES (828, 828); INSERT INTO E ( int_nokey, int_key ) VALUES (524, 524); INSERT INTO E ( int_nokey, int_key ) VALUES (324, 324); INSERT INTO E ( int_nokey, int_key ) VALUES (804, 804); INSERT INTO E ( int_nokey, int_key ) VALUES (950, 950); INSERT INTO E ( int_nokey, int_key ) VALUES (201, 201); INSERT INTO E ( int_nokey, int_key ) VALUES (568, 568); INSERT INTO E ( int_nokey, int_key ) VALUES (946, 946); INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457); INSERT INTO E ( int_nokey, int_key ) VALUES (185, 185); INSERT INTO E ( int_nokey, int_key ) VALUES (445, 445); INSERT INTO E ( int_nokey, int_key ) VALUES (634, 634); INSERT INTO E ( int_nokey, int_key ) VALUES (141, 141); INSERT INTO E ( int_nokey, int_key ) VALUES (204, 204); INSERT INTO E ( int_nokey, int_key ) VALUES (505, 505); INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546); INSERT INTO E ( int_nokey, int_key ) VALUES (491, 491); INSERT INTO E ( int_nokey, int_key ) VALUES (432, 432); INSERT INTO E ( int_nokey, int_key ) VALUES (471, 471); INSERT INTO E ( int_nokey, int_key ) VALUES (341, 341); INSERT INTO E ( int_nokey, int_key ) VALUES (24, 24); INSERT INTO E ( int_nokey, int_key ) VALUES (666, 666); INSERT INTO E ( int_nokey, int_key ) VALUES (574, 574); INSERT INTO E ( int_nokey, int_key ) VALUES (515, 515); INSERT INTO E ( int_nokey, int_key ) VALUES (100, 100); INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857); INSERT INTO E ( int_nokey, int_key ) VALUES (571, 571); INSERT INTO E ( int_nokey, int_key ) VALUES (366, 366); INSERT INTO E ( int_nokey, int_key ) VALUES (166, 166); INSERT INTO E ( int_nokey, int_key ) VALUES (411, 411); INSERT INTO E ( int_nokey, int_key ) VALUES (969, 969); INSERT INTO E ( int_nokey, int_key ) VALUES (862, 862); INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438); INSERT INTO E ( int_nokey, int_key ) VALUES (153, 153); INSERT INTO E ( int_nokey, int_key ) VALUES (839, 839); INSERT INTO E ( int_nokey, int_key ) VALUES (690, 690); INSERT INTO E ( int_nokey, int_key ) VALUES (931, 931); INSERT INTO E ( int_nokey, int_key ) VALUES (834, 834); INSERT INTO E ( int_nokey, int_key ) VALUES (674, 674); INSERT INTO E ( int_nokey, int_key ) VALUES (773, 773); INSERT INTO E ( int_nokey, int_key ) VALUES (581, 581); INSERT INTO E ( int_nokey, int_key ) VALUES (438, 438); INSERT INTO E ( int_nokey, int_key ) VALUES (6, 6); INSERT INTO E ( int_nokey, int_key ) VALUES (818, 818); INSERT INTO E ( int_nokey, int_key ) VALUES (737, 737); INSERT INTO E ( int_nokey, int_key ) VALUES (127, 127); INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436); INSERT INTO E ( int_nokey, int_key ) VALUES (101, 101); INSERT INTO E ( int_nokey, int_key ) VALUES (181, 181); INSERT INTO E ( int_nokey, int_key ) VALUES (783, 783); INSERT INTO E ( int_nokey, int_key ) VALUES (959, 959); INSERT INTO E ( int_nokey, int_key ) VALUES (170, 170); INSERT INTO E ( int_nokey, int_key ) VALUES (111, 111); INSERT INTO E ( int_nokey, int_key ) VALUES (574, 574); INSERT INTO E ( int_nokey, int_key ) VALUES (130, 130); INSERT INTO E ( int_nokey, int_key ) VALUES (935, 935); INSERT INTO E ( int_nokey, int_key ) VALUES (388, 388); INSERT INTO E ( int_nokey, int_key ) VALUES (771, 771); INSERT INTO E ( int_nokey, int_key ) VALUES (84, 84); INSERT INTO E ( int_nokey, int_key ) VALUES (898, 898); INSERT INTO E ( int_nokey, int_key ) VALUES (91, 91); INSERT INTO E ( int_nokey, int_key ) VALUES (896, 896); INSERT INTO E ( int_nokey, int_key ) VALUES (252, 252); INSERT INTO E ( int_nokey, int_key ) VALUES (773, 773); INSERT INTO E ( int_nokey, int_key ) VALUES (855, 855); INSERT INTO E ( int_nokey, int_key ) VALUES (735, 735); INSERT INTO E ( int_nokey, int_key ) VALUES (215, 215); INSERT INTO E ( int_nokey, int_key ) VALUES (544, 544); INSERT INTO E ( int_nokey, int_key ) VALUES (991, 991); INSERT INTO E ( int_nokey, int_key ) VALUES (626, 626); INSERT INTO E ( int_nokey, int_key ) VALUES (290, 290); INSERT INTO E ( int_nokey, int_key ) VALUES (24, 24); INSERT INTO E ( int_nokey, int_key ) VALUES (605, 605); INSERT INTO E ( int_nokey, int_key ) VALUES (718, 718); INSERT INTO E ( int_nokey, int_key ) VALUES (542, 542); INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61); INSERT INTO E ( int_nokey, int_key ) VALUES (209, 209); INSERT INTO E ( int_nokey, int_key ) VALUES (467, 467); INSERT INTO E ( int_nokey, int_key ) VALUES (234, 234); INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919); INSERT INTO E ( int_nokey, int_key ) VALUES (105, 105); INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71); INSERT INTO E ( int_nokey, int_key ) VALUES (432, 432); INSERT INTO E ( int_nokey, int_key ) VALUES (731, 731); INSERT INTO E ( int_nokey, int_key ) VALUES (514, 514); INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665); INSERT INTO E ( int_nokey, int_key ) VALUES (280, 280); INSERT INTO E ( int_nokey, int_key ) VALUES (670, 670); INSERT INTO E ( int_nokey, int_key ) VALUES (136, 136); INSERT INTO E ( int_nokey, int_key ) VALUES (59, 59); INSERT INTO E ( int_nokey, int_key ) VALUES (516, 516); INSERT INTO E ( int_nokey, int_key ) VALUES (154, 154); INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232); INSERT INTO E ( int_nokey, int_key ) VALUES (478, 478); INSERT INTO E ( int_nokey, int_key ) VALUES (127, 127); INSERT INTO E ( int_nokey, int_key ) VALUES (679, 679); INSERT INTO E ( int_nokey, int_key ) VALUES (983, 983); INSERT INTO E ( int_nokey, int_key ) VALUES (781, 781); INSERT INTO E ( int_nokey, int_key ) VALUES (745, 745); INSERT INTO E ( int_nokey, int_key ) VALUES (55, 55); INSERT INTO E ( int_nokey, int_key ) VALUES (849, 849); INSERT INTO E ( int_nokey, int_key ) VALUES (924, 924); INSERT INTO E ( int_nokey, int_key ) VALUES (882, 882); INSERT INTO E ( int_nokey, int_key ) VALUES (854, 854); INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992); INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232); INSERT INTO E ( int_nokey, int_key ) VALUES (416, 416); INSERT INTO E ( int_nokey, int_key ) VALUES (881, 881); INSERT INTO E ( int_nokey, int_key ) VALUES (784, 784); INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132); INSERT INTO E ( int_nokey, int_key ) VALUES (718, 718); INSERT INTO E ( int_nokey, int_key ) VALUES (668, 668); INSERT INTO E ( int_nokey, int_key ) VALUES (776, 776); INSERT INTO E ( int_nokey, int_key ) VALUES (337, 337); INSERT INTO E ( int_nokey, int_key ) VALUES (257, 257); INSERT INTO E ( int_nokey, int_key ) VALUES (261, 261); INSERT INTO E ( int_nokey, int_key ) VALUES (557, 557); INSERT INTO E ( int_nokey, int_key ) VALUES (786, 786); INSERT INTO E ( int_nokey, int_key ) VALUES (879, 879); INSERT INTO E ( int_nokey, int_key ) VALUES (392, 392); INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227); INSERT INTO E ( int_nokey, int_key ) VALUES (347, 347); INSERT INTO E ( int_nokey, int_key ) VALUES (802, 802); INSERT INTO E ( int_nokey, int_key ) VALUES (236, 236); INSERT INTO E ( int_nokey, int_key ) VALUES (97, 97); INSERT INTO E ( int_nokey, int_key ) VALUES (343, 343); INSERT INTO E ( int_nokey, int_key ) VALUES (556, 556); INSERT INTO E ( int_nokey, int_key ) VALUES (72, 72); INSERT INTO E ( int_nokey, int_key ) VALUES (2, 2); INSERT INTO E ( int_nokey, int_key ) VALUES (87, 87); INSERT INTO E ( int_nokey, int_key ) VALUES (216, 216); INSERT INTO E ( int_nokey, int_key ) VALUES (769, 769); INSERT INTO E ( int_nokey, int_key ) VALUES (711, 711); INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937); INSERT INTO E ( int_nokey, int_key ) VALUES (434, 434); INSERT INTO E ( int_nokey, int_key ) VALUES (186, 186); INSERT INTO E ( int_nokey, int_key ) VALUES (355, 355); INSERT INTO E ( int_nokey, int_key ) VALUES (153, 153); INSERT INTO E ( int_nokey, int_key ) VALUES (609, 609); INSERT INTO E ( int_nokey, int_key ) VALUES (507, 507); INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83); INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132); INSERT INTO E ( int_nokey, int_key ) VALUES (435, 435); INSERT INTO E ( int_nokey, int_key ) VALUES (623, 623); INSERT INTO E ( int_nokey, int_key ) VALUES (19, 19); INSERT INTO E ( int_nokey, int_key ) VALUES (292, 292); INSERT INTO E ( int_nokey, int_key ) VALUES (702, 702); INSERT INTO E ( int_nokey, int_key ) VALUES (884, 884); INSERT INTO E ( int_nokey, int_key ) VALUES (761, 761); INSERT INTO E ( int_nokey, int_key ) VALUES (993, 993); INSERT INTO E ( int_nokey, int_key ) VALUES (287, 287); INSERT INTO E ( int_nokey, int_key ) VALUES (531, 531); INSERT INTO E ( int_nokey, int_key ) VALUES (329, 329); INSERT INTO E ( int_nokey, int_key ) VALUES (919, 919); INSERT INTO E ( int_nokey, int_key ) VALUES (351, 351); INSERT INTO E ( int_nokey, int_key ) VALUES (692, 692); INSERT INTO E ( int_nokey, int_key ) VALUES (739, 739); INSERT INTO E ( int_nokey, int_key ) VALUES (254, 254); INSERT INTO E ( int_nokey, int_key ) VALUES (71, 71); INSERT INTO E ( int_nokey, int_key ) VALUES (873, 873); INSERT INTO E ( int_nokey, int_key ) VALUES (956, 956); INSERT INTO E ( int_nokey, int_key ) VALUES (888, 888); INSERT INTO E ( int_nokey, int_key ) VALUES (64, 64); INSERT INTO E ( int_nokey, int_key ) VALUES (945, 945); INSERT INTO E ( int_nokey, int_key ) VALUES (150, 150); INSERT INTO E ( int_nokey, int_key ) VALUES (705, 705); INSERT INTO E ( int_nokey, int_key ) VALUES (832, 832); INSERT INTO E ( int_nokey, int_key ) VALUES (7, 7); INSERT INTO E ( int_nokey, int_key ) VALUES (405, 405); INSERT INTO E ( int_nokey, int_key ) VALUES (411, 411); INSERT INTO E ( int_nokey, int_key ) VALUES (160, 160); INSERT INTO E ( int_nokey, int_key ) VALUES (429, 429); INSERT INTO E ( int_nokey, int_key ) VALUES (546, 546); INSERT INTO E ( int_nokey, int_key ) VALUES (332, 332); INSERT INTO E ( int_nokey, int_key ) VALUES (656, 656); INSERT INTO E ( int_nokey, int_key ) VALUES (410, 410); INSERT INTO E ( int_nokey, int_key ) VALUES (913, 913); INSERT INTO E ( int_nokey, int_key ) VALUES (289, 289); INSERT INTO E ( int_nokey, int_key ) VALUES (584, 584); INSERT INTO E ( int_nokey, int_key ) VALUES (624, 624); INSERT INTO E ( int_nokey, int_key ) VALUES (959, 959); INSERT INTO E ( int_nokey, int_key ) VALUES (132, 132); INSERT INTO E ( int_nokey, int_key ) VALUES (378, 378); INSERT INTO E ( int_nokey, int_key ) VALUES (758, 758); INSERT INTO E ( int_nokey, int_key ) VALUES (493, 493); INSERT INTO E ( int_nokey, int_key ) VALUES (401, 401); INSERT INTO E ( int_nokey, int_key ) VALUES (772, 772); INSERT INTO E ( int_nokey, int_key ) VALUES (787, 787); INSERT INTO E ( int_nokey, int_key ) VALUES (733, 733); INSERT INTO E ( int_nokey, int_key ) VALUES (981, 981); INSERT INTO E ( int_nokey, int_key ) VALUES (207, 207); INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937); INSERT INTO E ( int_nokey, int_key ) VALUES (660, 660); INSERT INTO E ( int_nokey, int_key ) VALUES (779, 779); INSERT INTO E ( int_nokey, int_key ) VALUES (124, 124); INSERT INTO E ( int_nokey, int_key ) VALUES (857, 857); INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93); INSERT INTO E ( int_nokey, int_key ) VALUES (414, 414); INSERT INTO E ( int_nokey, int_key ) VALUES (129, 129); INSERT INTO E ( int_nokey, int_key ) VALUES (165, 165); INSERT INTO E ( int_nokey, int_key ) VALUES (807, 807); INSERT INTO E ( int_nokey, int_key ) VALUES (408, 408); INSERT INTO E ( int_nokey, int_key ) VALUES (823, 823); INSERT INTO E ( int_nokey, int_key ) VALUES (512, 512); INSERT INTO E ( int_nokey, int_key ) VALUES (583, 583); INSERT INTO E ( int_nokey, int_key ) VALUES (687, 687); INSERT INTO E ( int_nokey, int_key ) VALUES (886, 886); INSERT INTO E ( int_nokey, int_key ) VALUES (382, 382); INSERT INTO E ( int_nokey, int_key ) VALUES (270, 270); INSERT INTO E ( int_nokey, int_key ) VALUES (339, 339); INSERT INTO E ( int_nokey, int_key ) VALUES (732, 732); INSERT INTO E ( int_nokey, int_key ) VALUES (121, 121); INSERT INTO E ( int_nokey, int_key ) VALUES (781, 781); INSERT INTO E ( int_nokey, int_key ) VALUES (11, 11); INSERT INTO E ( int_nokey, int_key ) VALUES (703, 703); INSERT INTO E ( int_nokey, int_key ) VALUES (227, 227); INSERT INTO E ( int_nokey, int_key ) VALUES (910, 910); INSERT INTO E ( int_nokey, int_key ) VALUES (611, 611); INSERT INTO E ( int_nokey, int_key ) VALUES (77, 77); INSERT INTO E ( int_nokey, int_key ) VALUES (585, 585); INSERT INTO E ( int_nokey, int_key ) VALUES (137, 137); INSERT INTO E ( int_nokey, int_key ) VALUES (452, 452); INSERT INTO E ( int_nokey, int_key ) VALUES (719, 719); INSERT INTO E ( int_nokey, int_key ) VALUES (425, 425); INSERT INTO E ( int_nokey, int_key ) VALUES (398, 398); INSERT INTO E ( int_nokey, int_key ) VALUES (939, 939); INSERT INTO E ( int_nokey, int_key ) VALUES (448, 448); INSERT INTO E ( int_nokey, int_key ) VALUES (38, 38); INSERT INTO E ( int_nokey, int_key ) VALUES (416, 416); INSERT INTO E ( int_nokey, int_key ) VALUES (556, 556); INSERT INTO E ( int_nokey, int_key ) VALUES (220, 220); INSERT INTO E ( int_nokey, int_key ) VALUES (169, 169); INSERT INTO E ( int_nokey, int_key ) VALUES (476, 476); INSERT INTO E ( int_nokey, int_key ) VALUES (122, 122); INSERT INTO E ( int_nokey, int_key ) VALUES (430, 430); INSERT INTO E ( int_nokey, int_key ) VALUES (175, 175); INSERT INTO E ( int_nokey, int_key ) VALUES (973, 973); INSERT INTO E ( int_nokey, int_key ) VALUES (436, 436); INSERT INTO E ( int_nokey, int_key ) VALUES (394, 394); INSERT INTO E ( int_nokey, int_key ) VALUES (129, 129); INSERT INTO E ( int_nokey, int_key ) VALUES (177, 177); INSERT INTO E ( int_nokey, int_key ) VALUES (654, 654); INSERT INTO E ( int_nokey, int_key ) VALUES (798, 798); INSERT INTO E ( int_nokey, int_key ) VALUES (525, 525); INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992); INSERT INTO E ( int_nokey, int_key ) VALUES (676, 676); INSERT INTO E ( int_nokey, int_key ) VALUES (286, 286); INSERT INTO E ( int_nokey, int_key ) VALUES (61, 61); INSERT INTO E ( int_nokey, int_key ) VALUES (357, 357); INSERT INTO E ( int_nokey, int_key ) VALUES (65, 65); INSERT INTO E ( int_nokey, int_key ) VALUES (830, 830); INSERT INTO E ( int_nokey, int_key ) VALUES (351, 351); INSERT INTO E ( int_nokey, int_key ) VALUES (941, 941); INSERT INTO E ( int_nokey, int_key ) VALUES (131, 131); INSERT INTO E ( int_nokey, int_key ) VALUES (54, 54); INSERT INTO E ( int_nokey, int_key ) VALUES (567, 567); INSERT INTO E ( int_nokey, int_key ) VALUES (918, 918); INSERT INTO E ( int_nokey, int_key ) VALUES (126, 126); INSERT INTO E ( int_nokey, int_key ) VALUES (716, 716); INSERT INTO E ( int_nokey, int_key ) VALUES (960, 960); INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665); INSERT INTO E ( int_nokey, int_key ) VALUES (439, 439); INSERT INTO E ( int_nokey, int_key ) VALUES (396, 396); INSERT INTO E ( int_nokey, int_key ) VALUES (496, 496); INSERT INTO E ( int_nokey, int_key ) VALUES (789, 789); INSERT INTO E ( int_nokey, int_key ) VALUES (142, 142); INSERT INTO E ( int_nokey, int_key ) VALUES (452, 452); INSERT INTO E ( int_nokey, int_key ) VALUES (139, 139); INSERT INTO E ( int_nokey, int_key ) VALUES (992, 992); INSERT INTO E ( int_nokey, int_key ) VALUES (784, 784); INSERT INTO E ( int_nokey, int_key ) VALUES (267, 267); INSERT INTO E ( int_nokey, int_key ) VALUES (610, 610); INSERT INTO E ( int_nokey, int_key ) VALUES (83, 83); INSERT INTO E ( int_nokey, int_key ) VALUES (228, 228); INSERT INTO E ( int_nokey, int_key ) VALUES (884, 884); INSERT INTO E ( int_nokey, int_key ) VALUES (93, 93); INSERT INTO E ( int_nokey, int_key ) VALUES (207, 207); INSERT INTO E ( int_nokey, int_key ) VALUES (278, 278); INSERT INTO E ( int_nokey, int_key ) VALUES (575, 575); INSERT INTO E ( int_nokey, int_key ) VALUES (599, 599); INSERT INTO E ( int_nokey, int_key ) VALUES (811, 811); INSERT INTO E ( int_nokey, int_key ) VALUES (646, 646); INSERT INTO E ( int_nokey, int_key ) VALUES (756, 756); INSERT INTO E ( int_nokey, int_key ) VALUES (772, 772); INSERT INTO E ( int_nokey, int_key ) VALUES (511, 511); INSERT INTO E ( int_nokey, int_key ) VALUES (115, 115); INSERT INTO E ( int_nokey, int_key ) VALUES (603, 603); INSERT INTO E ( int_nokey, int_key ) VALUES (294, 294); INSERT INTO E ( int_nokey, int_key ) VALUES (238, 238); INSERT INTO E ( int_nokey, int_key ) VALUES (966, 966); INSERT INTO E ( int_nokey, int_key ) VALUES (721, 721); INSERT INTO E ( int_nokey, int_key ) VALUES (665, 665); INSERT INTO E ( int_nokey, int_key ) VALUES (376, 376); INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543); INSERT INTO E ( int_nokey, int_key ) VALUES (305, 305); INSERT INTO E ( int_nokey, int_key ) VALUES (903, 903); INSERT INTO E ( int_nokey, int_key ) VALUES (232, 232); INSERT INTO E ( int_nokey, int_key ) VALUES (95, 95); INSERT INTO E ( int_nokey, int_key ) VALUES (282, 282); INSERT INTO E ( int_nokey, int_key ) VALUES (242, 242); INSERT INTO E ( int_nokey, int_key ) VALUES (785, 785); INSERT INTO E ( int_nokey, int_key ) VALUES (543, 543); INSERT INTO E ( int_nokey, int_key ) VALUES (478, 478); INSERT INTO E ( int_nokey, int_key ) VALUES (413, 413); INSERT INTO E ( int_nokey, int_key ) VALUES (937, 937); INSERT INTO E ( int_nokey, int_key ) VALUES (955, 955); INSERT INTO E ( int_nokey, int_key ) VALUES (517, 517); INSERT INTO E ( int_nokey, int_key ) VALUES (972, 972); INSERT INTO E ( int_nokey, int_key ) VALUES (457, 457); ; set autocommit=1; SET AUTOCOMMIT=0; UPDATE C AS X SET pk = 9 , filler = REPEAT ( ' X ' , ( SELECT 90 FROM ( SELECT COUNT( pk ) FROM C AS X WHERE X . int_nokey < 92 LIMIT 20 ) AS X WHERE X . int_nokey < 76 LIMIT 1 ) ) WHERE X . pk < 58 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT int_nokey FROM E AS X WHERE X . int_nokey < 93 LIMIT 1 ) , 16 ); START TRANSACTION; INSERT INTO D ( int_key , int_nokey ) VALUES ( 42 , ( SELECT AVG( int_key ) FROM E AS X WHERE X . int_key < 56 GROUP BY int_key LIMIT 1 ) ); INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT int_nokey FROM D AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . pk ) WHERE X . pk < 40 LIMIT 1 ) , 61 ); INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_key ) FROM A AS X LEFT JOIN D AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . pk < 33 GROUP BY int_nokey LIMIT 1 ) , ( SELECT int_key FROM E AS X LEFT JOIN B AS Y ON ( X . pk = Y . int_key ) WHERE X . pk < 42 GROUP BY int_key LIMIT 1 ) ); UPDATE E AS X SET int_nokey = ( SELECT AVG( int_key ) FROM E AS X WHERE X . pk < 38 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( pk ) FROM C AS X LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 46 GROUP BY pk LIMIT 1 ) ) WHERE X . int_nokey < 49 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( 19 , 73 ); START TRANSACTION; INSERT INTO D ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM B AS X LEFT JOIN D AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . pk < 54 LIMIT 1 ) , ( SELECT COUNT( int_key ) FROM B AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 14 LIMIT 1 ) ); INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT 84 FROM C AS X LEFT JOIN D AS Y ON ( X . pk = Y . pk ) WHERE X . pk < 52 GROUP BY int_nokey LIMIT 1 ) , 88 ); INSERT INTO C ( int_key , int_nokey ) VALUES ( ( SELECT 55 FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . pk ) WHERE X . int_nokey < 10 GROUP BY int_nokey LIMIT 1 ) , ( SELECT 63 FROM ( SELECT AVG( pk ) FROM ( SELECT ( SELECT int_nokey FROM D AS X LEFT JOIN C AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_nokey < 98 GROUP BY pk LIMIT 1 ) FROM B AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 74 LIMIT 20 ) AS X WHERE X . pk < 91 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 54 LIMIT 1 ) ); UPDATE A AS X SET int_nokey = 85 , filler = REPEAT ( ' X ' , 15 ) WHERE X . int_key < 17 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_key = 97 , filler = REPEAT ( ' X ' , ( SELECT 84 FROM B AS X WHERE X . pk < 62 LIMIT 1 ) ) WHERE X . int_nokey < 38 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET pk = 72 , filler = REPEAT ( ' X ' , 69 ) WHERE X . int_key < 46 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET int_key = ( SELECT AVG( int_nokey ) FROM ( SELECT AVG( pk ) FROM E AS X WHERE X . int_key < 87 LIMIT 20 ) AS X WHERE X . pk < 14 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT int_key FROM A AS X WHERE X . int_nokey < 66 LIMIT 1 ) ) WHERE X . int_nokey < 24 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_nokey = ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . pk < 83 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM A AS X WHERE X . pk < 58 LIMIT 1 ) ) WHERE X . int_nokey < 23 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_key = ( SELECT COUNT( pk ) FROM D AS X WHERE X . int_nokey < 79 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM D AS X LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 7 GROUP BY pk LIMIT 1 ) ) WHERE X . int_nokey < 82 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = 8 , filler = REPEAT ( ' X ' , 91 ) WHERE X . pk < 40 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = ( SELECT AVG( pk ) FROM E AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_key < 21 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( pk ) FROM A AS X LEFT JOIN A AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_key < 89 LIMIT 1 ) ) WHERE X . int_nokey < 68 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET pk = ( SELECT AVG( int_key ) FROM E AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . pk ) WHERE X . pk < 34 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT int_key FROM ( SELECT COUNT( int_key ) FROM C AS X LEFT JOIN B AS Y ON ( X . pk = Y . pk ) WHERE X . pk < 36 LIMIT 20 ) AS X WHERE X . int_key < 89 LIMIT 1 ) ) WHERE X . int_key < 87 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET int_key = ( SELECT 24 FROM D AS X LEFT JOIN D AS Y ON ( X . int_key = Y . pk ) WHERE X . int_key < 3 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM E AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 61 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 22 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( 74 , ( SELECT COUNT( int_nokey ) FROM D AS X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 86 GROUP BY int_nokey LIMIT 1 ) ); INSERT INTO A ( int_key , int_nokey ) VALUES ( 80 , ( SELECT ( SELECT AVG( pk ) FROM E AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_key < 44 LIMIT 1 ) FROM ( SELECT COUNT( int_key ) FROM E AS X WHERE X . pk < 85 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 24 LIMIT 1 ) ); UPDATE C AS X SET pk = 79 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM B AS X WHERE X . int_nokey < 97 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . pk < 85 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM D AS X LEFT JOIN C AS Y ON ( X . pk = Y . pk ) WHERE X . pk < 35 GROUP BY pk LIMIT 1 ) , ( SELECT AVG( int_nokey ) FROM C AS X WHERE X . int_key < 27 LIMIT 1 ) ); UPDATE C AS X SET int_key = 49 , filler = REPEAT ( ' X ' , 8 ) WHERE X . pk < 29 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_key = 46 , filler = REPEAT ( ' X ' , ( SELECT int_key FROM B AS X WHERE X . int_key < 97 LIMIT 1 ) ) WHERE X . int_key < 90 ORDER BY RAND ( ) LIMIT 20; INSERT INTO D ( int_key , int_nokey ) VALUES ( 98 , 25 ); INSERT INTO A ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( pk ) FROM E AS X LEFT JOIN C AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_nokey < 1 LIMIT 1 ) , 35 ); UPDATE A AS X SET int_nokey = ( SELECT AVG( pk ) FROM ( SELECT pk FROM C AS X LEFT JOIN D AS Y ON ( X . pk = Y . int_key ) WHERE X . int_nokey < 23 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 56 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM ( SELECT AVG( int_key ) FROM C AS X LEFT JOIN B AS Y ON ( X . int_key = Y . int_key ) WHERE X . pk < 7 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 92 LIMIT 1 ) ) WHERE X . int_nokey < 22 ORDER BY RAND ( ) LIMIT 20; INSERT INTO B ( int_key , int_nokey ) VALUES ( 23 , ( SELECT AVG( int_nokey ) FROM E AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_key ) WHERE X . pk < 88 LIMIT 1 ) ); INSERT INTO E ( int_key , int_nokey ) VALUES ( 43 , 42 ); ROLLBACK; UPDATE E AS X SET int_nokey = ( SELECT 98 FROM A AS X LEFT JOIN B AS Y ON ( X . pk = Y . int_key ) WHERE X . pk < 60 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 52 ) WHERE X . int_nokey < 57 ORDER BY RAND ( ) LIMIT 20; INSERT INTO B ( int_key , int_nokey ) VALUES ( 97 , ( SELECT AVG( int_key ) FROM ( SELECT COUNT( int_key ) FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_key ) WHERE X . pk < 9 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_nokey < 5 GROUP BY pk LIMIT 1 ) ); UPDATE C AS X SET int_nokey = 33 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT AVG( pk ) FROM C AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_nokey < 82 GROUP BY pk LIMIT 1 ) FROM C AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . pk < 3 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 85 ORDER BY RAND ( ) LIMIT 20; INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT COUNT( int_nokey ) FROM B AS X LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 60 LIMIT 1 ) , ( SELECT 92 FROM C AS X LEFT JOIN C AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . int_key < 1 LIMIT 1 ) ); UPDATE A AS X SET pk = 84 , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_key < 36 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET pk = 80 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . int_key < 82 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 70 ORDER BY RAND ( ) LIMIT 20; COMMIT; START TRANSACTION; UPDATE B AS X SET int_key = 0 , filler = REPEAT ( ' X ' , 69 ) WHERE X . int_nokey < 2 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET pk = ( SELECT COUNT( pk ) FROM D AS X LEFT JOIN A AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . pk < 71 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , 50 ) WHERE X . int_nokey < 96 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET pk = 38 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM ( SELECT COUNT( int_key ) FROM E AS X WHERE X . int_key < 98 LIMIT 20 ) AS X WHERE X . int_nokey < 58 LIMIT 1 ) ) WHERE X . pk < 28 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET pk = 87 , filler = REPEAT ( ' X ' , 66 ) WHERE X . pk < 40 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_key = ( SELECT pk FROM D AS X LEFT JOIN C AS Y ON ( X . int_key = Y . pk ) WHERE X . int_nokey < 90 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , 90 ) WHERE X . int_nokey < 51 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_key = 41 , filler = REPEAT ( ' X ' , 49 ) WHERE X . int_nokey < 38 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET pk = 84 , filler = REPEAT ( ' X ' , ( SELECT AVG( int_nokey ) FROM A AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 60 LIMIT 1 ) ) WHERE X . int_key < 94 ORDER BY RAND ( ) LIMIT 20; UPDATE A AS X SET int_key = ( SELECT int_nokey FROM A AS X LEFT JOIN D AS Y ON ( X . pk = Y . pk ) WHERE X . int_nokey < 47 GROUP BY pk LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT AVG( int_key ) FROM A AS X WHERE X . pk < 85 GROUP BY int_key LIMIT 1 ) ) WHERE X . int_nokey < 79 ORDER BY RAND ( ) LIMIT 20; UPDATE D AS X SET pk = ( SELECT COUNT( int_key ) FROM B AS X LEFT JOIN C AS Y ON ( X . pk = Y . int_key ) WHERE X . int_nokey < 64 LIMIT 1 ) , filler = REPEAT ( ' X ' , 0 ) WHERE X . pk < 74 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( ( SELECT AVG( int_nokey ) FROM B AS X WHERE X . pk < 97 GROUP BY int_nokey LIMIT 1 ) , ( SELECT ( SELECT COUNT( int_key ) FROM D AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_key < 83 GROUP BY pk LIMIT 1 ) FROM B AS X WHERE X . pk < 69 LIMIT 1 ) ); UPDATE E AS X SET int_key = 90 , filler = REPEAT ( ' X ' , ( SELECT ( SELECT int_nokey FROM C AS X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . pk < 58 LIMIT 1 ) FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . pk < 99 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . pk < 54 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET pk = 70 , filler = REPEAT ( ' X ' , 88 ) WHERE X . int_key < 74 ORDER BY RAND ( ) LIMIT 20; INSERT INTO A ( int_key , int_nokey ) VALUES ( 2 , 96 ); UPDATE A AS X SET int_nokey = 76 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM A AS X WHERE X . int_nokey < 56 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_nokey < 76 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_key = 93 , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_key ) FROM A AS X WHERE X . int_nokey < 77 GROUP BY pk LIMIT 1 ) ) WHERE X . pk < 66 ORDER BY RAND ( ) LIMIT 20; INSERT INTO B ( int_key , int_nokey ) VALUES ( ( SELECT int_key FROM ( SELECT pk FROM ( SELECT int_nokey FROM A AS X LEFT JOIN B AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . int_nokey < 63 GROUP BY int_nokey LIMIT 20 ) AS X WHERE X . pk < 88 GROUP BY int_key LIMIT 20 ) AS X WHERE X . int_key < 77 LIMIT 1 ) , ( SELECT COUNT( int_key ) FROM A AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 67 GROUP BY int_key LIMIT 1 ) ); UPDATE E AS X SET pk = ( SELECT COUNT( int_nokey ) FROM B AS X LEFT JOIN D AS Y ON ( X . pk = Y . int_nokey ) WHERE X . int_key < 74 GROUP BY int_nokey LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT ( SELECT pk FROM ( SELECT int_key FROM A AS X LEFT JOIN D AS Y ON ( X . int_key = Y . pk ) WHERE X . pk < 62 GROUP BY pk LIMIT 20 ) AS X WHERE X . int_nokey < 11 GROUP BY int_key LIMIT 1 ) FROM B AS X LEFT JOIN D AS Y ON ( X . int_nokey = Y . pk ) WHERE X . int_key < 10 LIMIT 1 ) ) WHERE X . int_key < 92 ORDER BY RAND ( ) LIMIT 20; START TRANSACTION; ROLLBACK; UPDATE E AS X SET int_nokey = 90 , filler = REPEAT ( ' X ' , 71 ) WHERE X . int_nokey < 83 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET pk = ( SELECT AVG( int_nokey ) FROM B AS X LEFT JOIN C AS Y ON ( X . int_key = Y . int_nokey ) WHERE X . int_key < 74 LIMIT 1 ) , filler = REPEAT ( ' X ' , 11 ) WHERE X . int_key < 23 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_key = 94 , filler = REPEAT ( ' X ' , ( SELECT 62 FROM ( SELECT 21 FROM C AS X WHERE X . int_key < 83 LIMIT 20 ) AS X WHERE X . int_nokey < 40 GROUP BY int_key LIMIT 1 ) ) WHERE X . pk < 48 ORDER BY RAND ( ) LIMIT 20; ROLLBACK; INSERT INTO A ( int_key , int_nokey ) VALUES ( 93 , 97 ); UPDATE A AS X SET int_nokey = 53 , filler = REPEAT ( ' X ' , 67 ) WHERE X . int_nokey < 4 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_nokey = 65 , filler = REPEAT ( ' X ' , 33 ) WHERE X . int_nokey < 31 ORDER BY RAND ( ) LIMIT 20; INSERT INTO E ( int_key , int_nokey ) VALUES ( 17 , ( SELECT AVG( int_nokey ) FROM E AS X LEFT JOIN E AS Y ON ( X . int_key = Y . int_key ) WHERE X . int_key < 90 GROUP BY int_nokey LIMIT 1 ) ); ROLLBACK; UPDATE E AS X SET int_key = ( SELECT pk FROM D AS X WHERE X . int_key < 39 LIMIT 1 ) , filler = REPEAT ( ' X ' , 71 ) WHERE X . int_key < 48 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_key = ( SELECT int_key FROM ( SELECT COUNT( pk ) FROM A AS X WHERE X . int_key < 42 GROUP BY int_key LIMIT 20 ) AS X WHERE X . pk < 88 LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( int_nokey ) FROM D AS X WHERE X . pk < 55 GROUP BY int_nokey LIMIT 1 ) ) WHERE X . int_key < 38 ORDER BY RAND ( ) LIMIT 20; UPDATE E AS X SET int_nokey = ( SELECT int_key FROM A AS X LEFT JOIN A AS Y ON ( X . pk = Y . int_nokey ) WHERE X . pk < 25 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , ( SELECT COUNT( pk ) FROM C AS X LEFT JOIN E AS Y ON ( X . int_nokey = Y . int_key ) WHERE X . int_nokey < 3 LIMIT 1 ) ) WHERE X . pk < 33 ORDER BY RAND ( ) LIMIT 20; UPDATE B AS X SET int_nokey = ( SELECT AVG( int_nokey ) FROM B AS X LEFT JOIN C AS Y ON ( X . int_nokey = Y . int_nokey ) WHERE X . int_nokey < 99 LIMIT 1 ) , filler = REPEAT ( ' X ' , 96 ) WHERE X . int_nokey < 5 ORDER BY RAND ( ) LIMIT 20; UPDATE C AS X SET int_key = ( SELECT AVG( int_nokey ) FROM E AS X WHERE X . int_nokey < 69 GROUP BY int_key LIMIT 1 ) , filler = REPEAT ( ' X ' , 59 ) WHERE X . int_nokey < 60 ORDER BY RAND ( ) LIMIT 20; ;;