MySQL Query processing order

http://zhangzhaoaaa.iteye.com/blog/1689412 reference: "MySQL Technology insider SQL Programming"

SELECT DISTINCT <selectlist>

From lefttable

<join-type>join <righttable>

On <join_condition>

Where<where_condition>

Group By<groupbylist>

with{cube| ROLLUP}

Having

Order by<orderbylist>

Limit<limitnumber>

Processing order

1. From
2. On
3. Join
4. where
5. GROUP BY
6. Cube|rollup
7. Having
8. Select
9. Distinct
10. ORDER BY
11. Limit

MySQL Query processing order