drop table  if exists tt;
create table tt(`c` bigint(20) DEFAULT NULL,`d` datetime DEFAULT NULL,KEY `c` (`c`),KEY `d` (`d`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
insert into tt values  
(-7631461,'1900-09-25 05:46:08'),(-1468397 ,'2028-09-06 19:28:16'),
(6891401,'2086-05-11 19:23:12'), (5697394,'2072-01-07 16:39:10'),
(-6506813,'2050-09-07 01:26:50'),(NULL,'2062-01-01 02:16:35'),
(-4334103,'1916-06-11 17:58:28'),(986230,'1964-07-11 03:59:42'),
(NULL,'1910-09-11 00:53:20');


drop table if exists tt1;
create table `tt1` (`col0` char(113) DEFAULT NULL,`col1` float DEFAULT NULL,`col2` bigint(20) DEFAULT NULL,`col3` decimal(10,0) DEFAULT NULL,`col4` blob,`col5` longtext,`col6` set('test1','test2','test3') DEFAULT NULL,`col7` bigint(20) DEFAULT NULL,`col8` bigint(20) DEFAULT NULL,`col9` tinyblob) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='generated';
insert into `tt1` values ('vilifying',3.12766e+006,-1610574,NULL,0xF06306E162DE33391BF5EC5DFC2D916F3C2EC9E165DB2D0C99BE2C807D2E4B36705AE98D5D2AE439AC0E6639DE69372896BDE173B01E23F3786EC6E2C7846CC6AA1F2DE314DDDC03E12E75C2A55AEDC32CAFDC2AB4EEC9D8123CE72D4B3E6FCC31F241B44BE12AAB3551EE0F330C82AB2339D9C208721F39788C2AE138F0236B96609A2D6F6A56B3BAD7D5774B71C6C3BC787DF0600CA5E21E8DA3C39F21829B719F5064AAF396E4F5ED999C2805EB1EE4EB556D88153FD2A56605BD8CC915A4ABDB51C3F7BF526CD678662E819F7296E9AEC7CFEAED648CE7C937170C249BF2BEC02AC3F0F6B36FF5FA2D,'rl lKfrP7E164aY0g.sFLGXTet4xjUmg7ua1E9nyuGHsc7m9iI4k YQUIVaBF53:     4pyXCsZX6UxS ZiezPQ10komq.r\ncaTdYfp',NULL,NULL,3895915,0x14DDDC03E12E75C2A55AEDC32CAFDC2AB4EEC9D8123CE72D4B3E6FCC31F241B44BE12AAB3551EE0F330C82AB2339D9C208721F39788C2AE138F0236B96609A2D6F6A56B3BAD7D5774B71C6C3BC787DF0600CA5E21E8DA3C39F21829B719F5064AAF396E4F5ED999C2805EB1EE4EB556D88153FD2A56605BD8CC915A4ABDB51C3F7BF526CD67866);
insert into `tt1` values ('disconnectedness\'s',4.2873e+009,3603832,NULL,0x60D291C4D241F063BEF0F4BE62E6B7C68EF6368AE9ED5093447C6690050D0F0C98DD0FD3BC21876D18882EF355E971DF2EBD971BB9052E8A699B54E4B7B71BB4ABE163952E8447863CBA84F049DD401EF09755B92AAA45EF2EDE30AF4221DAC6EF1FFC30D5117AEAD2F92E843CC32E051E2DBE303FB479374F6A2E860C9FCABD3C5A2E8B0141395A18932E874D9663B9A6C3C3D23F2DBFCB7A96801B60443CB7BA57F0A52E9FDBED758F3FA61EDDC3E41C,'eTf2f,saW14 V7ghaQ,F     K:W:X:s3LEl1GjuQo;7gY201D\nQ9xQW7DfD9HIXUS,7HmH,\nC\nK :8dBjDgqvYSmLtIp0CMCano 1Q\nLAPL u7AM30AHWEClHFe l;AiLekLfGWgRuxfbo\nvRE NHBxlw1D473hJVKV.:bT2EabT7x\njV3oGAvagScjz DaFl.bqVIL2z592Ku5EIL;uEz7ec,uJ8e48t','',4928857,1281875,'');
insert into `tt1` values ('dilettantish',4.28757e+009,7362075,'1196029',0xF34236BE88D27A87E7F069AA96B479443139EFC9B0CF99B9B5F1370C0517C166328528D7FC242E425ACC66885D210F5A752DEBB7D77E77DCC2B5D8D952DE214E63E1D5B9C3B1BE5A9B872E,'sdDdW7Ihs4uL05 4Gl0N.glYIaJFGqDm odkBI\naQPGfF2uH8 EqbcQdXA0aEv9Y54 GyvQU4S.6nSooqo5;l;FO, JKJZFBt0hZlAM6N di2;za3gGd B1qBgO6D0EiXzff FqT lg.4Bsx1GW xyZPHlYSF7w2rf 1krU1x7.0 oj I1Gd84bUfts;1RYVmQr8EF8LIWxV8bJT N;aYDeXdajw nmHzV2Hl2u3M.LgAgXhe6azsW','',904884,-2149748,0xC3B1BE5A9B872E2829E72E19E105870F2DDCDA1864152E1999283C2EEC193591CCA569128A434AB12D786657AE7977F3C5EB2E362E49B078322E38373F8E37B7E737E1B555889D2E8DA0D9D7B0999F12F91E0BD5D720E62F82D236452E704B2E794B8730AEC35A730D1EA5D2EB566A57D0A3B44BDBAD013981D2CE87D166F5B06CE24B09ED1562B42EEAAA33774E872D69DA692E396E39637770F04687CF9B2D98D68AB2EA7212FCD407CF4EAA3B0F6D394BE479F8A497737B37);
insert into `tt1` values (NULL,4.16634e+006,-6080773,'2804387',0x5EE90F1B0CD5D2D2B82118A28C7AD2CC2E4BCCC1CB3369EEB01EE86915EA994D4B8D235A38F6813C90A0BC1B55694B66E4D2F28731C9D1C5FB2E3BF52E7AD2DF812EBECB832EA1A5B75EEE886397649347B56023BDC22DCD73F6CF932E2EF846CC9FE1BBE1D2D244CDC337ED5B57C181A9AA9636DB3189C48F7692780CD524ED0EF36FBDAB7BCD788F2EBF36BE1B37ABDFA53C4B8214F5212695D8EE2E4537E131CDF2382EB496B42EE60E0E122E32A8D7F5C80399ABE5E18469994BE90F4259BA9A12C02E464B261C541EA5E46C883378CFFADED42E2DF07718E6D0612F6FFA77,'rN;c:pESds','',4136676,1796512,NULL);
insert into `tt1` values ('preening',5.82788e+006,6795151,NULL,0xC9626450589648A2E31767AE2E2D21E42E4DDE3C1E43024284F0BC39F5124BE82E3F10C93B662EB4BDE173B9A568D2A58302588756B42EAAA3E499E3432E4880AED5B4A081F49CABAD2EE1FB54A557321839A18D125ABA78217B5DCF2DD7870F2E162EE1A59B89B4DF,'OTDd7xej7uKh ao6Lrwl7rHLfDAo4LL9LzR.I.U31r3fzEgoU\nBrMl fHb',NULL,-205945,685372,0x81F49CABAD2EE1FB54A557321839A18D125ABA78217B5DCF2DD7870F2E162EE1A59B89B4DF5A5A06D81C9AB52E78742B6009D23E99F006244244B4214D0F8E062EB04E11D6EB9590CEF33D722D302DE9C521C3842199D57FB4CE9CAEE29BF214BE7DE62EC8775D8EE8F09CE142BFCE9A35BC15AFCC10556D6C82A5);
insert into `tt1` values ('Harbird',NULL,118166,'1826194',0x37B44C1E642D19C72EBD6F160613A2D65A55C1162435132555E1CB6C3335425D8521B10C2EE7AECDCDBA411EF044467A12C4B82DE70E033C2BE9540974DDF62EA1335F66B71B75A877C1892ED20CAD55EB87C03C5AB4F909B4B11255D2BDF22B55997B71D2CECC9FB0C38C999B50E18D9765F532731EACB2B731519F05BFEB92C2904C320606E186D7362E7130DFADF36EEA239F0F45,'Kuh,jh:; ;kIkK        4 SEIje1u5CzbT;Et,q12 eznLGEXBp','',4707253,6118316,0xB71B75A877C1892ED20CAD55EB87C03C5AB4F909B4B11255D2BDF22B55997B71D2CECC9FB0C38C999B50E18D9765F532731EACB2B731519F05BFEB92C2904C320606E186D7362E);
insert into `tt1` values ('conjectures',5.34493e+006,-3385194,'6258010',0x872E59E7B27878D8C49C6D348709FCFE62CD8EDC19558754E66C87EA210D159CA5BA4194EA4DAA21A0A0A38D7A9C9FF06C0F1B551E,'tKat9bB3E ppePjPeQFIZgeu9m3nU\nadt2DN     9LoC.8NzO7o2cluLkDAlU:1puXmXmfO Hk7xv   wEf;Df2cWp4,yDQuUyFAJ19.yqnG  3Ippb6l6,z3XGUMdv4oX;ybRftHaea1   y,7wH;.efJq 3MLlbuk72 RoIG0NO;BoOE2Znhq4FeR     CPzb4r;0Um0nnsqVkHRECbP4q Po hVOfqGQp,EBG5QNALgH85P,S;2u7Ww X,','',NULL,344482,0x13BE78BE3824412E70DDBFDBB430C823A9EF4639532E127E2E6E55218BD22ECCD3C37B4346C619163C2EEA5D41021ECC96A51DD91968462B96A7D9A5B2C6506BFEA24279E3F54445C3F367B8B2429C08843D2E9DB443486ED7B6A545AE8A757BB1EB69BA2AC7BB75A5A8FCB0660B6F2E75F0CFD57573);
insert into `tt1` values ('toaster\'s',564428,557636,'4289374416',0x3DD76ACC87E9417642782E72ED51CBB014449C66C739193F79C543C4A56F8A5EEE33C337AC5F304E75DDE87DBEC11E10653278A2F0D2C30DC8A0D2AB55749FF5949205638EAFB12D5336C56E97A32D4B96847F63783DDDEB0FDE30217560AA3637A2E887FBCC4E96B2E8E9C3CD9E33E1108711D5D806CCDE0C78DE59E16AEE695D2D33CAD0CC6FAE662D0FB54053901EE7998785A02E8F2D16E6871C14A0ED999650AB2E7BF3544604B90FFAD2D2D541ABC324C644338132987D7688465AC12EAA66B1823B334A5510AEB4E8C073ECCFA39FC35BB11B99116B69D5ED8AB2D7DCA63E0B960941782E2D6962829E36F8030F3CE7B4,'o,B cgvR5cG.e6 GBM\nyD0PoRmMmDHdIVBctiwYGOwj\nzU1ZA.:L5 Vw5J','',NULL,-2132602,0x8EAFB12D5336C56E97A32D4B96847F63783DDDEB0FDE30217560AA3637A2E887FBCC4E96B2E8E9C3CD9E);
insert into `tt1` values ('bxs',4.28777e+009,-4407098,'4290289900',0x2E5FC32E47C184A50F4C2DE3F1F658AAE1A47B79D85A6FFA305F5191A968BD36575B577FD89935CF2802B7929506FA9969422EE75590B324D2F06643B701B454AC7A9EA52E32963F3259394D8220CCCD29C38B2EFB78313CF8DC36A5FC9A17E1E78A41F0FA2E4D78905D722F2FCDD2AC6FF6E12485B4C0,'4K.jiMZtS3b142P','',7666762,6108988,0x2E32963F3259394D8220CCCD29C38B2EFB78313CF8DC36A5FC9A17E1E78A41F0FA2E4D78905D722F2FCDD2AC6FF6E12485B4C0C36E39CF43CD332BCF052980938362C3EB41EEFEA4F01124D29642032F7D411E502EB5DC319FB92EB17B542E7344282EF6710503F928D2172E879ADD7BF0E193724DA683DB2ED2B451F52A2E6C96F9336635AC8799EA669672A557AA896EC34660C2B437663C1B55BC9BB8622F2E6E696254EA0860D9B12E2EB40F0F12C5331FDEE1);



drop table if exists tt2;
create table tt2
(
`col30` smallint(6) DEFAULT NULL,
`col60` longblob
)engine=myisam;

INSERT INTO `tt2` VALUES (-5554,NULL);
INSERT INTO `tt2` VALUES (2962,0x9FF1E99A0C965A6D159ADB144F9F5FB0FBCB2E2E0FE1A878C3E1F020249B142ED08A6E125096546984DBFB78A57CA54DB1724BC9075112A839D8544155CF17B02412DFB4ADDD7C996E8D991491C0F0FD0996B91D91C6121BB9247B33);
INSERT INTO `tt2` VALUES (15791,0x2A15B7891E8B7277B498414B0CE9A2D5BD873F86417EC3C8E15D87AA2A246AAACC7BBCD22E1B55A3ED24C11E2EF01229BAF372F02E24554715AA2EC3E796919F3B3C1FCF64DA45914B067B4B2D513C172E99B439F3F07C28F9CAD1513F4E6F45DDE0D7E19DEBA38B42B4572B1B3033F9EA60ABE287A8694EBC3787FA03EC55F8D22E04ACEF79C31EB4E47F3F3CE03280B42E175D3C866AD7B6D705A46969372E2E2DCDF68738114E078FF5724B0C540F5DCC);


select 
        `a_table2_4`.`col60`
from
        tt as `a_t2_0`, 
        tt2 as `a_table2_4`
where 
        `a_table2_4`.`col30` in
        (
                select
	                sqrt(`a_table1_3`.`col3`) as `d_a_table1_3_col3_101` 	
                from
 	                tt as `a_t2_0`,
		        tt1 as `a_table1_3`  
                where
	                `a_table1_3`.`col8` * uuid()
	 )
	 and 
        `a_table2_4`.`col30` in 
	 (
	        select
	                sqrt(`a_table1_3`.`col3`) as `d_a_table1_3_col3_101` 	
                from
 	                tt as `a_t2_0`,
		        tt1 as `a_table1_3`  
	 )
;