Slightly simplified version of the test query:
EXPLAIN SELECT * FROM ( SELECT * FROM t2 ) AS a2 WHERE (SELECT distinct SUM(distinct f3 ) FROM t1);
Slightly simplified version of the test query:
EXPLAIN
SELECT *
FROM ( SELECT * FROM t2 ) AS a2
WHERE (SELECT distinct SUM(distinct f3 ) FROM t1);