SQL: Subquery is invalid (Error 1825)

Something in the subquery is erroneous. For more information, see SELECT - SQL.