SELECT COUNT( alias1.`col_float_unsigned_null` ) AS field1 FROM ( ( SELECT SQ1_alias1.* FROM `view_table100_aria_0` AS SQ1_alias1 WHERE SQ1_alias1.`col_int_unsigned_not_null` < 6 ) AS alias1, `table20_aria` AS alias2 ) WHERE alias1.`col_int_unsigned_not_null` NOT IN ( SELECT SQ2_alias1.`col_int_null` AS SQ2_ifield1 FROM ( `view_table20_myisam_0` AS SQ2_alias1, `table1_innodb` AS SQ2_alias2 ) WHERE alias2.`col_int_unsigned_not_null` IN ( ( SELECT C_SQ1_alias1.`col_int_unsigned_null` AS C_SQ1_ifield1 FROM `table20_innodb` AS C_SQ1_alias1 GROUP BY C_SQ1_ifield1 ) ) AND SQ2_alias2.`col_char_2_null` < SQ2_alias1.`col_varchar_64_null` ) HAVING field1 >= 4 ORDER BY field1;

field1

700

SET SESSION optimizer_switch = REPLACE( @@optimizer_switch, "=on", "=off" );

SET SESSION optimizer_switch = "in_to_exists=on";

SELECT COUNT( alias1.`col_float_unsigned_null` ) AS field1 FROM ( ( SELECT SQ1_alias1.* FROM `view_table100_aria_0` AS SQ1_alias1 WHERE SQ1_alias1.`col_int_unsigned_not_null` < 6 ) AS alias1, `table20_aria` AS alias2 ) WHERE alias1.`col_int_unsigned_not_null` NOT IN ( SELECT SQ2_alias1.`col_int_null` AS SQ2_ifield1 FROM ( `view_table20_myisam_0` AS SQ2_alias1, `table1_innodb` AS SQ2_alias2 ) WHERE alias2.`col_int_unsigned_not_null` IN ( ( SELECT C_SQ1_alias1.`col_int_unsigned_null` AS C_SQ1_ifield1 FROM `table20_innodb` AS C_SQ1_alias1 GROUP BY C_SQ1_ifield1 ) ) AND SQ2_alias2.`col_char_2_null` < SQ2_alias1.`col_varchar_64_null` ) HAVING field1 >= 4 ORDER BY field1;

field1

525