Comment by contravariant

Good luck trying to get the joins to work though.

Not that joins in SQL use a particularly intuitive notation. At the very least it doesn't make it obvious you can usually swap the order of joins around without affecting the end result.