What's wrong with this query?

It isn't using the table aliases when accessing columns in the SELECT statementIt aliases tables, which is not allowedIt's not using the table aliases in the condition

It isn't using the table aliases when accessing columns in the SELECT statement.