O'Reilly logo
  • Matthew Perkovic thinks this is interesting:

Subqueries are always processed starting with the innermost SELECT statement and working outward. When the preceding SELECT statement is processed, MySQL actually performs two operations.

From

Cover of MySQL® Crash Course

Note

Subqueries processed from right to left.