Optimizing table join order

Something i should have known (and didn't):

The join optimizer calculates the order in which tables should be joined. The table read order forced by LEFT JOIN or STRAIGHT_JOIN helps the join optimizer do its work much more quickly, because there are fewer table permutations to check.

http://dev.mysql.com/doc/refman/5.0/en/left-join-optimization.html