Great back-to-basics question and I got it wrong because I wasn't paying enough attention. Err...

I think there is a copy and paste mistake in SELECT #2 and SELECT #3 as both are the same code. I guess you meant one LEFT JOIN with the DISTINCT and the other without it, right?

BTW, thank you for the link with the article.