The dangerous subtleties of LEFT JOIN and COUNT() in SQL

http://www.xaprb.com/blog/2009/04/08/the-dangerous-subtleties-of-left-join-and-count-in-sql/