Report question

Question: Why can't MySQL optimize this query?