What's wrong with this query?
There's nothing wrong with the query
It isn't using the table aliases when accessing columns in the condition
There's nothing wrong with the query.