Comment by jimlikeslimes

My mental model was always that the order of keywords mirrored the order the database engine applied them. So WHERE is processed first and SELECT last.