BTW good indenting reveals the structure of the query. Bad indenting makes it harder to see what goes with what. I would say the original version is bad. Even if you don't like my version I'm sure you can do better. But I wouldn't have spotted the fact that there is no `ON` for the `LEFT` on `F` in your version.