A little wisdom on using sensible and logical aliases for your tables, instead of a / b / c / d.

See a couple of reasons you should stop using old join syntax (FROM t1, t2).