Report question

Question: MySQL query with dependent subquery takes too long