Brent Ozar knows when a query is going to be bad:
I open it up and the first thing I see is a comment with a changelog showing a long list of dates and author initials.
Oh I know, you think documentation is a good thing, but:
Read on for the reasoning. Admittedly, this is a pretty good sign of pretty bad code.