Where is the author? Where are the folks who defended the data collection query as harmless?
Steven993 said the query is fine. I think I have shown it's not fine.
Brian O'Leary pronounced the effect of the bug to be nothing worse than showing duplicate rows. I think I have shown the effect is much worse.
Where is the discussion? Can a few more people weigh in to confirm or refute (with some evidence) the problem? The article is rated 4+ stars, but I'm afraid the core query is fundamentally flawed.