DROP TABLE IF EXISTS `table0000`;
CREATE TABLE `table0000` (
  `col00` float DEFAULT NULL,
  `col01` char(246) DEFAULT NULL,
  `col02` tinyint(4) DEFAULT NULL,
  `col03` longtext,
  `col04` year(4) DEFAULT NULL,
  `col05` char(203) DEFAULT NULL,
  `col06` int(11) DEFAULT NULL,
  KEY `idx00` (`col04`),
  KEY `idx01` (`col00`),
  KEY `idx02` (`col06`,`col04`,`col05`),
  KEY `idx03` (`col05`,`col06`,`col02`,`col03`(106)),
  KEY `idx07` (`col06`),
  KEY `idx08` (`col03`(74))
) ENGINE=innodb DEFAULT CHARSET=latin1 ;

INSERT INTO `table0000` VALUES (NULL,'Dahlia\'s',NULL,'riotousness\'s',2141,'spot\'s',15057);
INSERT INTO `table0000` VALUES (20296,'Blondell',-128,'quarryings',2084,NULL,-29344);
INSERT INTO `table0000` VALUES (NULL,'kidney',127,'depressives',2118,'laze',8302);
INSERT INTO `table0000` VALUES (16729,'liqueur\'s',-128,'accretion',2011,'nymphet\'s',-12353);
INSERT INTO `table0000` VALUES (15682,'lewdest',-128,NULL,2149,'Celine\'s',9637);
INSERT INTO `table0000` VALUES (5721,'shinier',-128,NULL,NULL,'threshes',-15003);

DROP TABLE IF EXISTS `table0021`;
CREATE TABLE `table0021` (
  `col00` decimal(10,0) DEFAULT NULL,
  `col01` tinyint(4) DEFAULT NULL,
  `col02` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `col03` blob,
  `col04` int(11) DEFAULT NULL,
  `col05` year(4) DEFAULT NULL,
  `col06` mediumblob,
  `col07` tinytext,
  `col08` mediumblob,
  `col09` double DEFAULT NULL,
  `col10` double DEFAULT NULL,
  `col11` mediumint(9) DEFAULT NULL,
  `col12` tinyint(4) DEFAULT NULL,
  `col13` longblob,
  `col14` double DEFAULT NULL,
  `col15` int(11) DEFAULT NULL,
  `col16` longblob,
  `col17` bigint(20) DEFAULT NULL,
  `col18` decimal(10,0) DEFAULT NULL,
  `col19` tinyint(4) DEFAULT NULL,
  `col20` mediumint(9) DEFAULT NULL,
  `col21` tinytext,
  `col22` time DEFAULT NULL,
  `col23` varchar(150) DEFAULT NULL,
  `col24` tinyblob,
  KEY `idx06` (`col23`)
) ENGINE=innodb DEFAULT CHARSET=latin1;


INSERT INTO `table0021` VALUES ('-3691',-128,'0000-00-00 00:00:00','',9712,1917,'','',NULL,-3593,9502,NULL,-128,'',-1657,-14547,'',-788,'31097',127,-27137,'',NULL,'','');
INSERT INTO `table0021` VALUES ('23871',-128,'0000-00-00 00:00:00','',NULL,2089,'','','',-29984,21981,16060,127,'',8332,-10151,'',-27173,NULL,-128,-28928,'',NULL,'','');
INSERT INTO `table0021` VALUES ('-27158',127,'2010-01-19 13:42:40','',20323,1915,'','','',23590,21372,NULL,-128,'',-8726,23412,'',NULL,'19725',127,-7240,'','00:00:00','','');

select 1
from
        table0000
        natural join table0021 force index (idx06)
where  
        row('1',table0000.col00 )
     <> row( '1' , '1' ) and not 
        table0000.col06 = '1' and 
        table0000.col03 >'1' 
;