DROP TABLE IF EXISTS `t1`; DROP TABLE IF EXISTS `t2`; CREATE TABLE `t1` (`c1` int,`c2` int,`c3` int ,KEY (`c1`),KEY(`c2`),KEY (`c3`)) ENGINE=MyISAM; CREATE TABLE `t2` (`c1` int) ENGINE=MyISAM; INSERT INTO `t1` VALUES (22,85,146); INSERT INTO `t1` VALUES (36,213,233); INSERT INTO `t1` VALUES (205,119,146); INSERT INTO `t1` VALUES (124,119,109); INSERT INTO `t1` VALUES (209,61,55); INSERT INTO `t1` VALUES (179,162,249); INSERT INTO `t1` VALUES (21,168,215); INSERT INTO `t1` VALUES (60,31,233); INSERT INTO `t1` VALUES (116,228,113); INSERT INTO `t1` VALUES (161,30,24); INSERT INTO `t1` VALUES (47,47,8); INSERT INTO `t1` VALUES (216,51,97); INSERT INTO `t1` VALUES (140,183,195); INSERT INTO `t1` VALUES (126,165,46); INSERT INTO `t1` VALUES (14,236,201); INSERT INTO `t1` VALUES (170,92,245); INSERT INTO `t1` VALUES (189,189,183); INSERT INTO `t1` VALUES (56,80,85); INSERT INTO `t1` VALUES (37,38,157); INSERT INTO `t1` VALUES (159,21,142); INSERT INTO `t1` VALUES (25,50,242); INSERT INTO `t1` VALUES (166,142,247); INSERT INTO `t1` VALUES (11,82,98); INSERT INTO `t1` VALUES (190,79,36); INSERT INTO `t1` VALUES (235,89,84); INSERT INTO `t1` VALUES (69,201,13); INSERT INTO `t1` VALUES (196,250,49); INSERT INTO `t1` VALUES (27,152,229); INSERT INTO `t1` VALUES (59,194,240); INSERT INTO `t1` VALUES (79,31,247); INSERT INTO `t1` VALUES (50,131,191); INSERT INTO `t1` VALUES (40,29,158); INSERT INTO `t1` VALUES (44,39,226); INSERT INTO `t1` VALUES (76,232,190); INSERT INTO `t1` VALUES (136,9,40); INSERT INTO `t1` VALUES (153,94,138); INSERT INTO `t1` VALUES (188,72,177); INSERT INTO `t1` VALUES (80,96,243); INSERT INTO `t1` VALUES (55,22,68); INSERT INTO `t1` VALUES (251,28,149); INSERT INTO `t1` VALUES (79,209,212); INSERT INTO `t1` VALUES (196,194,29); INSERT INTO `t1` VALUES (199,251,115); INSERT INTO `t1` VALUES (108,35,56); INSERT INTO `t1` VALUES (16,136,130); INSERT INTO `t1` VALUES (138,219,26); INSERT INTO `t1` VALUES (180,253,117); INSERT INTO `t1` VALUES (78,236,34); INSERT INTO `t1` VALUES (34,71,242); INSERT INTO `t1` VALUES (83,35,198); INSERT INTO `t1` VALUES (234,75,55); INSERT INTO `t1` VALUES (251,122,153); INSERT INTO `t1` VALUES (114,185,62); INSERT INTO `t1` VALUES (253,26,124); INSERT INTO `t1` VALUES (138,236,210); INSERT INTO `t1` VALUES (114,105,133); INSERT INTO `t1` VALUES (137,81,62); INSERT INTO `t1` VALUES (151,53,72); INSERT INTO `t1` VALUES (204,9,13); INSERT INTO `t1` VALUES (225,162,96); INSERT INTO `t1` VALUES (17,30,93); INSERT INTO `t1` VALUES (95,190,134); INSERT INTO `t1` VALUES (207,211,40); INSERT INTO `t1` VALUES (80,89,134); INSERT INTO `t1` VALUES (91,4,127); INSERT INTO `t1` VALUES (142,54,50); INSERT INTO `t1` VALUES (92,150,175); INSERT INTO `t1` VALUES (4,154,147); INSERT INTO `t1` VALUES (210,58,187); INSERT INTO `t1` VALUES (104,207,74); INSERT INTO `t1` VALUES (100,234,30); INSERT INTO `t1` VALUES (25,27,242); INSERT INTO `t1` VALUES (188,241,226); INSERT INTO `t1` VALUES (251,115,143); INSERT INTO `t1` VALUES (119,22,12); INSERT INTO `t1` VALUES (207,37,27); INSERT INTO `t1` VALUES (215,239,62); INSERT INTO `t1` VALUES (152,48,172); INSERT INTO `t1` VALUES (6,81,188); INSERT INTO `t1` VALUES (100,126,16); INSERT INTO `t1` VALUES (81,55,203); INSERT INTO `t1` VALUES (140,71,168); INSERT INTO `t1` VALUES (107,211,20); INSERT INTO `t1` VALUES (231,18,100); INSERT INTO `t1` VALUES (68,155,233); INSERT INTO `t1` VALUES (184,150,28); INSERT INTO `t1` VALUES (250,119,200); INSERT INTO `t1` VALUES (180,162,170); INSERT INTO `t1` VALUES (248,25,160); INSERT INTO `t1` VALUES (49,25,156); INSERT INTO `t1` VALUES (0,132,208); INSERT INTO `t1` VALUES (68,194,108); INSERT INTO `t1` VALUES (104,90,4); INSERT INTO `t1` VALUES (24,45,212); INSERT INTO `t1` VALUES (123,236,209); INSERT INTO `t1` VALUES (68,109,31); INSERT INTO `t1` VALUES (149,200,200); INSERT INTO `t1` VALUES (47,120,151); INSERT INTO `t1` VALUES (204,240,28); INSERT INTO `t1` VALUES (11,206,193); INSERT INTO `t1` VALUES (69,108,222); INSERT INTO `t1` VALUES (254,207,56); INSERT INTO `t1` VALUES (205,178,108); INSERT INTO `t1` VALUES (237,109,152); INSERT INTO `t1` VALUES (133,141,29); INSERT INTO `t1` VALUES (40,5,143); INSERT INTO `t1` VALUES (152,46,90); INSERT INTO `t1` VALUES (172,20,180); INSERT INTO `t1` VALUES (110,70,72); INSERT INTO `t1` VALUES (82,35,250); INSERT INTO `t1` VALUES (117,241,249); INSERT INTO `t1` VALUES (162,126,19); INSERT INTO `t1` VALUES (6,125,5); INSERT INTO `t1` VALUES (156,99,241); INSERT INTO `t1` VALUES (47,6,15); INSERT INTO `t1` VALUES (204,245,40); INSERT INTO `t1` VALUES (155,106,99); INSERT INTO `t1` VALUES (55,154,88); INSERT INTO `t1` VALUES (93,206,142); INSERT INTO `t1` VALUES (74,251,4); INSERT INTO `t1` VALUES (83,217,199); INSERT INTO `t1` VALUES (141,63,169); INSERT INTO `t1` VALUES (215,22,23); INSERT INTO `t1` VALUES (172,234,93); INSERT INTO `t1` VALUES (71,48,150); INSERT INTO `t1` VALUES (236,47,197); INSERT INTO `t1` VALUES (96,183,203); INSERT INTO `t1` VALUES (45,17,171); INSERT INTO `t1` VALUES (3,111,113); INSERT INTO `t1` VALUES (135,178,42); INSERT INTO `t1` VALUES (246,5,50); INSERT INTO `t1` VALUES (4,253,63); INSERT INTO `t1` VALUES (141,81,208); INSERT INTO `t1` VALUES (160,208,88); INSERT INTO `t1` VALUES (250,166,52); INSERT INTO `t1` VALUES (36,81,202); INSERT INTO `t1` VALUES (142,138,102); INSERT INTO `t1` VALUES (62,44,195); INSERT INTO `t1` VALUES (190,247,109); INSERT INTO `t1` VALUES (116,118,81); INSERT INTO `t1` VALUES (75,198,35); INSERT INTO `t1` VALUES (231,240,44); INSERT INTO `t1` VALUES (26,96,73); INSERT INTO `t1` VALUES (95,78,92); INSERT INTO `t1` VALUES (46,218,21); INSERT INTO `t1` VALUES (250,200,192); INSERT INTO `t1` VALUES (22,143,129); INSERT INTO `t1` VALUES (1,78,129); INSERT INTO `t1` VALUES (12,171,88); INSERT INTO `t1` VALUES (205,131,173); INSERT INTO `t1` VALUES (145,34,86); INSERT INTO `t1` VALUES (26,51,150); INSERT INTO `t1` VALUES (161,116,15); INSERT INTO `t1` VALUES (203,85,147); INSERT INTO `t1` VALUES (86,96,98); INSERT INTO `t1` VALUES (234,157,159); INSERT INTO `t1` VALUES (123,67,158); INSERT INTO `t1` VALUES (51,71,59); INSERT INTO `t1` VALUES (169,159,29); INSERT INTO `t1` VALUES (24,164,44); INSERT INTO `t1` VALUES (2,245,78); INSERT INTO `t1` VALUES (202,92,169); INSERT INTO `t1` VALUES (2,83,79); INSERT INTO `t1` VALUES (130,253,123); INSERT INTO `t1` VALUES (142,236,101); INSERT INTO `t1` VALUES (225,170,49); INSERT INTO `t1` VALUES (135,233,25); INSERT INTO `t1` VALUES (77,185,61); INSERT INTO `t1` VALUES (91,210,19); INSERT INTO `t1` VALUES (96,9,102); INSERT INTO `t1` VALUES (192,200,104); INSERT INTO `t1` VALUES (47,145,197); INSERT INTO `t1` VALUES (196,92,29); INSERT INTO `t1` VALUES (193,221,67); INSERT INTO `t1` VALUES (206,47,97); INSERT INTO `t1` VALUES (237,208,116); INSERT INTO `t1` VALUES (39,171,0); INSERT INTO `t1` VALUES (160,177,143); INSERT INTO `t1` VALUES (45,215,39); INSERT INTO `t1` VALUES (166,111,63); INSERT INTO `t1` VALUES (84,182,54); INSERT INTO `t1` VALUES (46,72,22); INSERT INTO `t1` VALUES (93,183,47); INSERT INTO `t1` VALUES (137,208,174); INSERT INTO `t1` VALUES (84,165,228); INSERT INTO `t1` VALUES (94,59,18); INSERT INTO `t1` VALUES (232,153,246); INSERT INTO `t1` VALUES (9,15,179); INSERT INTO `t1` VALUES (188,192,167); INSERT INTO `t1` VALUES (215,60,160); INSERT INTO `t1` VALUES (230,80,181); INSERT INTO `t1` VALUES (98,119,84); INSERT INTO `t1` VALUES (132,195,22); INSERT INTO `t1` VALUES (121,37,105); INSERT INTO `t1` VALUES (212,209,100); INSERT INTO `t1` VALUES (11,44,41); INSERT INTO `t1` VALUES (157,81,25); INSERT INTO `t1` VALUES (97,94,78); INSERT INTO `t1` VALUES (94,18,160); INSERT INTO `t1` VALUES (162,8,211); INSERT INTO `t1` VALUES (242,96,216); INSERT INTO `t1` VALUES (216,177,9); INSERT INTO `t1` VALUES (247,214,39); INSERT INTO `t1` VALUES (135,23,67); INSERT INTO `t1` VALUES (81,182,120); INSERT INTO `t1` VALUES (217,225,41); INSERT INTO `t1` VALUES (198,27,17); INSERT INTO `t1` VALUES (78,84,219); INSERT INTO `t1` VALUES (177,135,232); INSERT INTO `t1` VALUES (211,106,77); INSERT INTO `t1` VALUES (57,39,23); INSERT INTO `t1` VALUES (103,8,197); INSERT INTO `t1` VALUES (50,125,51); INSERT INTO `t1` VALUES (49,181,111); INSERT INTO `t1` VALUES (84,101,12); INSERT INTO `t1` VALUES (189,252,111); INSERT INTO `t1` VALUES (251,160,6); INSERT INTO `t1` VALUES (245,177,13); INSERT INTO `t1` VALUES (247,154,198); INSERT INTO `t1` VALUES (47,213,130); INSERT INTO `t1` VALUES (252,142,215); INSERT INTO `t1` VALUES (20,108,166); INSERT INTO `t1` VALUES (196,85,93); INSERT INTO `t1` VALUES (81,201,152); INSERT INTO `t1` VALUES (146,176,64); INSERT INTO `t1` VALUES (46,243,22); INSERT INTO `t1` VALUES (96,129,94); INSERT INTO `t1` VALUES (11,17,61); INSERT INTO `t1` VALUES (158,226,250); INSERT INTO `t1` VALUES (4,47,167); INSERT INTO `t1` VALUES (66,49,230); INSERT INTO `t1` VALUES (16,247,190); INSERT INTO `t1` VALUES (203,32,206); INSERT INTO `t1` VALUES (32,233,53); INSERT INTO `t1` VALUES (134,81,84); INSERT INTO `t1` VALUES (53,191,73); INSERT INTO `t1` VALUES (81,73,96); INSERT INTO `t1` VALUES (9,148,59); INSERT INTO `t1` VALUES (93,210,9); INSERT INTO `t1` VALUES (96,27,180); INSERT INTO `t1` VALUES (241,109,175); INSERT INTO `t1` VALUES (50,37,141); INSERT INTO `t1` VALUES (174,80,148); INSERT INTO `t1` VALUES (85,49,208); INSERT INTO `t1` VALUES (182,130,9); INSERT INTO `t1` VALUES (52,66,142); INSERT INTO `t1` VALUES (233,220,17); INSERT INTO `t1` VALUES (37,232,25); INSERT INTO `t1` VALUES (224,243,183); INSERT INTO `t1` VALUES (89,25,121); INSERT INTO `t1` VALUES (77,177,150); INSERT INTO `t1` VALUES (89,94,40); INSERT INTO `t1` VALUES (28,86,184); INSERT INTO `t1` VALUES (249,182,208); INSERT INTO `t1` VALUES (223,65,212); INSERT INTO `t1` VALUES (145,203,157); INSERT INTO `t1` VALUES (178,137,207); INSERT INTO `t1` VALUES (152,128,124); INSERT INTO `t1` VALUES (183,225,195); INSERT INTO `t1` VALUES (77,187,152); INSERT INTO `t1` VALUES (125,172,49); INSERT INTO `t1` VALUES (175,47,156); INSERT INTO `t1` VALUES (86,169,118); INSERT INTO `t1` VALUES (218,241,23); INSERT INTO `t1` VALUES (145,0,193); INSERT INTO `t1` VALUES (63,227,188); INSERT INTO `t1` VALUES (211,147,144); INSERT INTO `t1` VALUES (45,140,127); INSERT INTO `t1` VALUES (168,18,247); INSERT INTO `t1` VALUES (252,130,151); INSERT INTO `t1` VALUES (216,58,206); INSERT INTO `t1` VALUES (224,197,163); INSERT INTO `t1` VALUES (169,73,212); INSERT INTO `t1` VALUES (192,60,8); INSERT INTO `t1` VALUES (214,43,232); INSERT INTO `t1` VALUES (169,134,190); INSERT INTO `t1` VALUES (211,48,186); INSERT INTO `t1` VALUES (220,75,213); INSERT INTO `t1` VALUES (232,174,105); INSERT INTO `t1` VALUES (243,134,57); INSERT INTO `t1` VALUES (95,236,175); INSERT INTO `t1` VALUES (121,152,198); INSERT INTO `t1` VALUES (160,235,37); INSERT INTO `t1` VALUES (26,103,130); INSERT INTO `t1` VALUES (77,42,104); INSERT INTO `t1` VALUES (136,179,43); INSERT INTO `t1` VALUES (230,175,254); INSERT INTO `t1` VALUES (228,98,191); INSERT INTO `t1` VALUES (235,64,189); INSERT INTO `t1` VALUES (214,42,125); INSERT INTO `t1` VALUES (49,164,200); INSERT INTO `t1` VALUES (181,20,46); INSERT INTO `t1` VALUES (190,113,105); INSERT INTO `t1` VALUES (189,26,193); INSERT INTO `t1` VALUES (243,253,145); INSERT INTO `t1` VALUES (40,144,82); INSERT INTO `t1` VALUES (123,215,42); INSERT INTO `t1` VALUES (61,174,236); INSERT INTO `t1` VALUES (141,61,11); INSERT INTO `t1` VALUES (170,107,48); INSERT INTO `t1` VALUES (215,203,36); INSERT INTO `t1` VALUES (24,189,103); INSERT INTO `t1` VALUES (228,216,126); INSERT INTO `t1` VALUES (108,89,179); INSERT INTO `t1` VALUES (121,126,99); INSERT INTO `t1` VALUES (197,152,186); INSERT INTO `t1` VALUES (101,33,26); INSERT INTO `t1` VALUES (162,33,53); INSERT INTO `t1` VALUES (231,225,140); INSERT INTO `t1` VALUES (116,245,103); INSERT INTO `t1` VALUES (144,164,113); INSERT INTO `t1` VALUES (215,201,4); INSERT INTO `t1` VALUES (173,181,118); INSERT INTO `t1` VALUES (115,82,16); INSERT INTO `t1` VALUES (118,159,152); INSERT INTO `t1` VALUES (176,67,206); INSERT INTO `t1` VALUES (227,127,0); INSERT INTO `t1` VALUES (135,3,228); INSERT INTO `t1` VALUES (95,94,53); INSERT INTO `t1` VALUES (172,94,248); INSERT INTO `t1` VALUES (180,10,86); INSERT INTO `t1` VALUES (122,225,7); INSERT INTO `t1` VALUES (221,187,138); INSERT INTO `t1` VALUES (241,230,209); INSERT INTO `t1` VALUES (113,208,86); INSERT INTO `t1` VALUES (239,166,54); INSERT INTO `t1` VALUES (2,107,30); INSERT INTO `t1` VALUES (14,22,180); INSERT INTO `t1` VALUES (243,113,104); INSERT INTO `t1` VALUES (105,172,240); INSERT INTO `t1` VALUES (101,218,183); INSERT INTO `t1` VALUES (1,4,172); INSERT INTO `t1` VALUES (106,94,247); INSERT INTO `t1` VALUES (4,83,235); INSERT INTO `t1` VALUES (129,70,175); INSERT INTO `t1` VALUES (77,164,107); INSERT INTO `t1` VALUES (230,203,36); INSERT INTO `t1` VALUES (30,7,224); INSERT INTO `t1` VALUES (186,124,38); INSERT INTO `t1` VALUES (68,160,218); INSERT INTO `t1` VALUES (123,72,11); INSERT INTO `t1` VALUES (29,236,207); INSERT INTO `t1` VALUES (150,68,91); INSERT INTO `t1` VALUES (38,187,159); INSERT INTO `t1` VALUES (208,121,254); INSERT INTO `t1` VALUES (205,121,84); INSERT INTO `t1` VALUES (43,241,108); INSERT INTO `t1` VALUES (176,157,127); INSERT INTO `t1` VALUES (202,193,102); INSERT INTO `t1` VALUES (251,108,252); INSERT INTO `t1` VALUES (49,144,33); INSERT INTO `t1` VALUES (167,250,95); INSERT INTO `t1` VALUES (249,46,171); INSERT INTO `t1` VALUES (227,214,59); INSERT INTO `t1` VALUES (139,158,206); INSERT INTO `t1` VALUES (248,226,11); INSERT INTO `t1` VALUES (178,43,22); INSERT INTO `t1` VALUES (30,35,83); INSERT INTO `t1` VALUES (148,7,132); INSERT INTO `t1` VALUES (142,14,159); INSERT INTO `t1` VALUES (209,248,38); INSERT INTO `t1` VALUES (182,186,22); INSERT INTO `t1` VALUES (202,117,224); INSERT INTO `t1` VALUES (71,110,82); INSERT INTO `t1` VALUES (107,203,97); INSERT INTO `t1` VALUES (170,136,15); INSERT INTO `t1` VALUES (174,66,44); INSERT INTO `t1` VALUES (210,195,102); INSERT INTO `t1` VALUES (221,58,79); INSERT INTO `t1` VALUES (224,52,127); INSERT INTO `t1` VALUES (21,203,38); INSERT INTO `t1` VALUES (184,17,98); INSERT INTO `t1` VALUES (3,7,185); INSERT INTO `t1` VALUES (172,194,105); INSERT INTO `t1` VALUES (90,182,174); INSERT INTO `t1` VALUES (192,158,153); INSERT INTO `t1` VALUES (14,72,56); INSERT INTO `t1` VALUES (161,4,126); INSERT INTO `t1` VALUES (211,24,165); INSERT INTO `t1` VALUES (121,143,36); INSERT INTO `t1` VALUES (227,194,209); INSERT INTO `t1` VALUES (95,139,94); INSERT INTO `t1` VALUES (215,149,206); INSERT INTO `t1` VALUES (17,220,139); INSERT INTO `t1` VALUES (145,203,124); INSERT INTO `t1` VALUES (83,185,18); INSERT INTO `t1` VALUES (19,249,93); INSERT INTO `t1` VALUES (0,207,144); INSERT INTO `t1` VALUES (19,151,181); INSERT INTO `t1` VALUES (225,149,104); INSERT INTO `t1` VALUES (149,160,179); INSERT INTO `t1` VALUES (26,219,226); INSERT INTO `t1` VALUES (232,1,8); INSERT INTO `t1` VALUES (236,208,186); INSERT INTO `t1` VALUES (231,184,103); INSERT INTO `t1` VALUES (70,134,116); INSERT INTO `t1` VALUES (33,75,106); INSERT INTO `t1` VALUES (226,113,47); INSERT INTO `t1` VALUES (5,75,204); INSERT INTO `t1` VALUES (110,127,175); INSERT INTO `t1` VALUES (251,96,14); INSERT INTO `t1` VALUES (127,154,82); INSERT INTO `t1` VALUES (113,138,106); INSERT INTO `t1` VALUES (18,226,175); INSERT INTO `t1` VALUES (83,41,215); INSERT INTO `t1` VALUES (85,60,31); INSERT INTO `t1` VALUES (106,88,199); INSERT INTO `t1` VALUES (118,89,199); INSERT INTO `t1` VALUES (10,251,78); INSERT INTO `t1` VALUES (128,46,111); INSERT INTO `t1` VALUES (61,145,0); INSERT INTO `t1` VALUES (182,172,134); INSERT INTO `t1` VALUES (26,188,182); INSERT INTO `t1` VALUES (227,95,148); INSERT INTO `t1` VALUES (97,23,53); INSERT INTO `t1` VALUES (238,198,8); INSERT INTO `t1` VALUES (203,203,64); INSERT INTO `t1` VALUES (83,186,59); INSERT INTO `t1` VALUES (184,7,106); INSERT INTO `t1` VALUES (48,185,60); INSERT INTO `t1` VALUES (18,24,20); INSERT INTO `t1` VALUES (123,17,197); INSERT INTO `t1` VALUES (172,38,145); INSERT INTO `t1` VALUES (119,123,89); INSERT INTO `t1` VALUES (40,118,242); INSERT INTO `t1` VALUES (104,228,42); INSERT INTO `t1` VALUES (25,120,221); INSERT INTO `t1` VALUES (205,52,106); INSERT INTO `t1` VALUES (221,229,200); INSERT INTO `t1` VALUES (125,78,111); INSERT INTO `t1` VALUES (139,93,34); INSERT INTO `t1` VALUES (218,209,12); INSERT INTO `t1` VALUES (214,51,0); INSERT INTO `t1` VALUES (175,17,197); INSERT INTO `t1` VALUES (89,225,253); INSERT INTO `t1` VALUES (41,59,203); INSERT INTO `t1` VALUES (150,78,83); INSERT INTO `t1` VALUES (125,52,114); INSERT INTO `t2` VALUES (48011); DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=161 AND `t1`.`c3`= 164; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=152 AND `t1`.`c3`= 249; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=84 AND `t1`.`c3`= 82; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=217 AND `t1`.`c3`= 230; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=200 AND `t1`.`c3`= 167; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=209 AND `t1`.`c3`= 209; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=171 AND `t1`.`c3`= 107; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=193 AND `t1`.`c3`= 231; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=213 AND `t1`.`c3`= 207; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=178 AND `t1`.`c3`= 228; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=137 AND `t1`.`c3`= 85; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=99 AND `t1`.`c3`= 4; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=0 AND `t1`.`c3`= 126; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=194 AND `t1`.`c3`= 82; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=179 AND `t1`.`c3`= 97; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=63 AND `t1`.`c3`= 15; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=203 AND `t1`.`c3`= 159; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=238 AND `t1`.`c3`= 91; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=90 AND `t1`.`c3`= 148; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=106 AND `t1`.`c3`= 90; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=181 AND `t1`.`c3`= 119; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=220 AND `t1`.`c3`= 219; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=185 AND `t1`.`c3`= 164; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=217 AND `t1`.`c3`= 54; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=209 AND `t1`.`c3`= 20; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=60 AND `t1`.`c3`= 48; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=153 AND `t1`.`c3`= 10; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=166 AND `t1`.`c3`= 45; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=59 AND `t1`.`c3`= 67; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=26 AND `t1`.`c3`= 35; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=81 AND `t1`.`c3`= 196; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=186 AND `t1`.`c3`= 74; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=8 AND `t1`.`c3`= 11; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=201 AND `t1`.`c3`= 249; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=142 AND `t1`.`c3`= 208; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=68 AND `t1`.`c3`= 133; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=176 AND `t1`.`c3`= 197; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=12 AND `t1`.`c3`= 195; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=9 AND `t1`.`c3`= 13; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=42 AND `t1`.`c3`= 0; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=83 AND `t1`.`c3`= 74; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=83 AND `t1`.`c3`= 96; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=40 AND `t1`.`c3`= 50; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=229 AND `t1`.`c3`= 216; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=238 AND `t1`.`c3`= 119; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=51 AND `t1`.`c3`= 63; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=96 AND `t1`.`c3`= 105; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=224 AND `t1`.`c3`= 247; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=70 AND `t1`.`c3`= 191; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=138 AND `t1`.`c3`= 254; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=61 AND `t1`.`c3`= 41; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=183 AND `t1`.`c3`= 23; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=181 AND `t1`.`c3`= 135; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=116 AND `t1`.`c3`= 18; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=109 AND `t1`.`c3`= 254; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=127 AND `t1`.`c3`= 235; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=26 AND `t1`.`c3`= 10; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=226 AND `t1`.`c3`= 20; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=63 AND `t1`.`c3`= 58; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=122 AND `t1`.`c3`= 141; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=190 AND `t1`.`c3`= 195; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=228 AND `t1`.`c3`= 231; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=173 AND `t1`.`c3`= 20; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=114 AND `t1`.`c3`= 62; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=244 AND `t1`.`c3`= 28; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=120 AND `t1`.`c3`= 48; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=205 AND `t1`.`c3`= 110; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=55 AND `t1`.`c3`= 104; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=139 AND `t1`.`c3`= 69; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=84 AND `t1`.`c3`= 104; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=152 AND `t1`.`c3`= 114; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=31 AND `t1`.`c3`= 252; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=86 AND `t1`.`c3`= 73; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=32 AND `t1`.`c3`= 220; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=238 AND `t1`.`c3`= 158; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=46 AND `t1`.`c3`= 20; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=211 AND `t1`.`c3`= 163; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=150 AND `t1`.`c3`= 109; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=35 AND `t1`.`c3`= 48; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=242 AND `t1`.`c3`= 217; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=47 AND `t1`.`c3`= 208; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=145 AND `t1`.`c3`= 178; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=22 AND `t1`.`c3`= 24; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=8 AND `t1`.`c3`= 237; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=165 AND `t1`.`c3`= 125; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=166 AND `t1`.`c3`= 236; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=139 AND `t1`.`c3`= 85; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=240 AND `t1`.`c3`= 250; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=176 AND `t1`.`c3`= 254; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=241 AND `t1`.`c3`= 144; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=243 AND `t1`.`c3`= 124; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=23 AND `t1`.`c3`= 212; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=225 AND `t1`.`c3`= 199; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=233 AND `t1`.`c3`= 11; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=95 AND `t1`.`c3`= 103; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=135 AND `t1`.`c3`= 88; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=38 AND `t1`.`c3`= 171; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=139 AND `t1`.`c3`= 180; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=247 AND `t1`.`c3`= 186; DELETE `t1` FROM `t1` , `t2` WHERE `t1`.`c1`=99 AND `t1`.`c3`= 201; check table t1 extended; repair table t1;