Some minor anonymization happened, so things like SELECT blah FROM [a] AS a doesn't count. Anyway, this is the final result of a ~2K LOC method that creates this query.