set sql_mode='';
drop table if exists `t1`;
create table `t1` (
  `a` int(11) default null,
  `b` varchar(20) default null,
  `c` int(11) default null,
  key `idx3` (`b`)
) engine=myisam default charset=latin1;

insert into `t1` values (1,'2',3);
insert into `t1` values (1,'2',3);
insert into `t1` values (2,'1',3);
insert into `t1` values (2,'1',3);
insert into `t1` values (1,'1',3);
insert into `t1` values (1,'1',3);
insert into `t1` values (2,'2',3);
insert into `t1` values (2,'2',3);


drop table if exists `t79`;
create table `t79` (
  `a79` int(10) unsigned zerofill not null,
  `col840` year(2) not null default '00',
  `col841` enum('pkbpkvqi','hbwerofo','knmk','szipqijyyb','psvrkts','gkzmtcd','fkysaxiay','irndebgww','vzjha') default null,
  primary key (`col840`) key_block_size=1532,
  unique key `idx723` (`col840`)
) engine=innodb default charset=latin1 min_rows=8263691 max_rows=3637854 checksum=1 delay_key_write=1 key_block_size=16;

insert into `t79` values (0000000009,00,'');
insert into `t79` values (0003059775,00,'');
insert into `t79` values (0000029513,01,'');
insert into `t79` values (0000000000,33,'');

drop table if exists `t53`;
create table `t53` (
  `a53` int(10) unsigned zerofill not null,
  `col585` double unsigned zerofill default null,
  `col586` varbinary(182) default null,
  `col587` double unsigned zerofill default null,
  `col588` varchar(171) default null,
  `col589` enum('ovpbmwp','sgaklmysys','itsmcjecz') default null,
  `col590` char(242) character set utf8 default null,
  `col591` timestamp not null default current_timestamp on update current_timestamp,
  `col592` char(189) default null,
  `col593` float default null,
  `col594` bit(25) default null,
  `col595` char(196) default null,
  `col596` binary(1) not null default '\0',
  `col597` time default null,
  `col598` timestamp not null default '0000-00-00 00:00:00',
  `col599` binary(1) default null,
  `col600` char(236) character set utf8 not null default '',
  `col601` date default null,
  `col602` tinyint(4) default null,
  `col603` binary(1) default null,
  `col604` year(4) default null,
  primary key (`col596`,`col600`(11)) key_block_size=3413,
  unique key `idx456` (`col601`) using hash,
  key `idx458` (`col602`,`col589`,`col588`) using btree,
  key `idx460` (`col596`,`col600`),
  key `idx462` (`col594`,`col593`) using hash
) engine=innodb default charset=latin1 min_rows=2281120 max_rows=1996818 pack_keys=0 checksum=1 key_block_size=1;

insert into `t53` values (0000000097,0000000000000000000013,'�',0000000000000000000000,'oycoi','','kqng','2010-09-16 07:31:13','phk',9.22337e18,'\0\0\0
','qdqm','\0','20:27:46','2011-06-17 04:10:49','�','ch','2011-01-21',127,'�',0000);

drop table if exists `t52`;
create table `t52` (
  `a52` int(10) unsigned zerofill not null,
  `col582` char(230) character set utf8 default null,
  `col583` varchar(12) character set utf8 not null default '',
  `col584` binary(1) default null,
  primary key (`col583`(5)) using hash key_block_size=1693,
  key `idx450` (`col583`) using hash,
  key `idx451` (`col583`) using btree
) engine=innodb default charset=latin1 min_rows=8500366 max_rows=7365704 pack_keys=1 checksum=1 delay_key_write=1 key_block_size=1024;

insert into `t52` values (0681150770,'cymej','','z');
insert into `t52` values (0000038017,'yv','ef',';');
insert into `t52` values (0000000001,'ivpos','iquaf','�');
insert into `t52` values (0000013431,'fhjg','vhak','');

drop table if exists `t65`;
create table `t65` (
  `a65` int(11) not null,
  `col710` double unsigned zerofill default null,
  `col711` date default null,
  `col712` time default null,
  `col713` bigint(20) not null default '0',
  `col714` tinyblob,
  `col715` int(10) unsigned default null,
  `col716` date not null default '0000-00-00',
  `col717` datetime default null,
  primary key (`col713`,`a65`,`col716`) key_block_size=22552,
  unique key `idx594` (`col716`,`col715`) using btree,
  unique key `idx606` (`col713`,`a65`,`col716`),
  unique key `idx607` (`col712`) using hash,
  unique key `idx608` (`col711`,`col714`(153),`col712`) using btree,
  key `idx595` (`col711`,`a65`),
  key `idx596` (`col716`) using btree
) engine=innodb default charset=latin1 min_rows=6855434 max_rows=7694032 delay_key_write=1 key_block_size=4;


drop table if exists `t25`;
create table `t25` (
  `a25` int(10) unsigned zerofill not null,
  `col278` date default null,
  `col279` varbinary(198) not null default '',
  `col280` double unsigned zerofill default null,
  `col281` time not null default '00:00:00',
  `col282` timestamp not null default current_timestamp on update current_timestamp,
  primary key (`col281`,`col279`(1)) key_block_size=15040,
  unique key `idx235` (`col281`,`col279`),
  unique key `idx237` (`col278`) using hash,
  unique key `idx241` (`col281`,`col278`) using hash,
  unique key `idx244` (`col279`,`col278`),
  key `idx234` (`col278`,`col279`,`col281`) using hash,
  key `idx236` (`col278`),
  key `idx240` (`col282`,`col281`) using hash,
  key `idx242` (`col278`) using hash,
  key `idx243` (`col281`,`col282`) using btree
) engine=innodb default charset=latin1 min_rows=2072906 max_rows=8516784 pack_keys=0 key_block_size=1024;

insert into `t25` values (0000000000,'2010-11-16','^.',00000000000000000.3442,'02:46:37','2010-11-07 07:04:45');
insert into `t25` values (0000000000,'2011-01-15','>��',00000000000000000.7488,'18:29:41','2010-12-13 07:36:32');

drop table if exists `t28`;
create table `t28` (
  `a28` int(10) unsigned not null,
  `col308` blob,
  `col309` mediumint(8) unsigned default null,
  `col310` tinytext,
  `col311` int(10) unsigned zerofill default null,
  `col312` time default null,
  `col313` double unsigned default null,
  `col314` mediumblob,
  `col315` bigint(20) default null,
  `col316` time default null,
  `col317` timestamp not null default current_timestamp on update current_timestamp,
  `col318` tinyblob,
  `col319` timestamp not null default '0000-00-00 00:00:00',
  primary key (`a28`) using btree key_block_size=10748,
  unique key `idx263` (`col319`) using hash,
  unique key `idx270` (`a28`) using btree,
  unique key `idx260` (`col309`) using btree,
  unique key `idx271` (`col313`) using hash,
  key `idx259` (`col308`(122)) using hash,
  key `idx264` (`col311`) using btree,
  key `idx266` (`col318`(16)) using btree,
  key `idx272` (`a28`) using hash,
  key `idx274` (`col312`) using hash
) engine=innodb default charset=latin1 min_rows=5834545 max_rows=9929516 pack_keys=1 checksum=1 delay_key_write=1 key_block_size=16;

drop table if exists `t23`;
create table `t23` (
  `a23` int(10) unsigned zerofill not null,
  `col248` time default null,
  `col249` int(10) unsigned zerofill default null,
  `col250` char(71) character set utf8 default null,
  `col251` year(4) default null,
  `col252` set('q','yjzdpkh','kzfhrwwgjq','vs','rqf','aysmcfy','ujuospxqc','vy','uy','') default null,
  `col253` text not null,
  `col254` smallint(5) unsigned zerofill not null default '00000',
  `col255` varchar(160) character set utf8 default null,
  `col256` tinytext,
  `col257` datetime default null,
  `col258` date default null,
  `col259` tinytext,
  `col260` set('bukuyhe','aokhfzyo','qrroz','nvwpbw','tismnpz','ocyi','x','idw') default null,
  `col261` year(2) default null,
  primary key (`col254`,`a23`,`col253`(239)) using hash key_block_size=20923,
  unique key `idx229` (`col256`(189),`col259`(86)) using hash,
  key `idx227` (`col256`(72),`col248`) using btree,
  key `idx228` (`col254`,`a23`,`col253`(237)) using hash
) engine=innodb default charset=latin1 min_rows=9931468 max_rows=7363452 pack_keys=0 delay_key_write=1 key_block_size=1;

insert into `t23` values (0000000000,'02:29:24',0000000029,'bxusr',0000,'yjzdpkh,kzfhrwwgjq,rqf,ujuospxqc,uy,','',00241,'f','bxbf','2011-01-21 00:00:00','2011-06-12','gto','',00);
insert into `t23` values (0000000001,'10:54:04',0004204397,'nce',0000,'q,yjzdpkh,vs,aysmcfy,ujuospxqc,vy,uy','pf',65535,'t','awzqc','2011-09-16 18:34:21','2010-03-29','yh','',00);

drop table if exists `t73`;
create table `t73` (
  `a73` int(10) unsigned not null,
  `col787` float unsigned zerofill default null,
  `col788` date default null,
  `col789` year(2) default null,
  `col790` datetime default null,
  `col791` time default null,
  `col792` mediumint(8) unsigned zerofill default null,
  `col793` datetime default null,
  `col794` decimal(48,24) default null,
  `col795` char(183) default null,
  `col796` varbinary(172) default null,
  `col797` bigint(20) unsigned zerofill default null,
  `col798` year(2) default null,
  `col799` year(2) default null,
  `col800` tinytext,
  `col801` date default null,
  `col802` double unsigned zerofill default null,
  `col803` date default null,
  `col804` char(169) default null,
  `col805` varchar(51) character set utf8 default null
) engine=innodb default charset=latin1 min_rows=8425872 max_rows=8791238 pack_keys=0 checksum=1 delay_key_write=1 key_block_size=4096;

insert into `t73` values (0,000000000000,'2011-01-21',00,'2010-03-08 22:28:45','04:37:36',00017537,'2011-11-28 17:19:02',18191.000000000000000000000000,'iafk','�',00000000000004072363,00,16,'zzkmw','2011-01-10',0000000000000000000000,'2011-12-08','tmqcb','pwk');


set session optimizer_join_cache_level=3;

select 1 from `t1` as `t1_0` 
natural left outer join `t79` as `t79_1`  
natural left join `t52` as `t52_2`  
natural left join `t23` as `t23_3`
left join `t65` as `t65_4` on 1 like `t23_3`.`col253`
left outer join `t25` as `t25_5` on `t65_4`.`col712` is null
left outer join `t28` as `t28_6` on `t1_0`.`b` <=>`t28_6`.`col319`
left outer join `t73`on `t52_2`.`col582` <=  1;