Out of curiosity, can every LEFT JOIN be rewritten as a query with RIGHT JOINs? It seems to me that if you just take the "leftmost" table and use that in the FROM part of a SELECT that all subsequent LEFT JOINs would need to be RIGHT JOINs...
