DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (`c1` tinyint,`c2` int,`c3` int,`c4` int,`c5` bigint,`c6` bigint,`c7` datetime ,`c8` int,`c9` int ,KEY (`c4`),KEY (`c9`),KEY (`c1`)) ENGINE=MyISAM;
DROP TABLE IF EXISTS `t2`;
CREATE TABLE  `t2` (`c1` int) ENGINE=MyISAM;
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,2,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (1,1,1,1,1,1,'0000-00-00 00:00:00',1,1);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t1` VALUES (2,1,1,1,1,1,'0000-00-00 00:00:00',1,2);
INSERT INTO `t2` VALUES (1);
DELETE `t1` FROM  `t1` , `t2` WHERE `t1`.`c1`=1 AND  (`t1`.`c9`  = 1);