Return to Question

On the RPG Data Explorer ... I've made a query of the number of comments per user.

The results, especially done as a ratio of comments over posts is fascinating. At this point, I will simply encourage users to contemplate their comment activity versus their more productive activity. Refer to the site comment policy here: Why are site comments being deleted?

Are there any ways I can improve this query, to help members of this site self-moderate?

Other queries:

• Number of comments per tag
• Average and Standard Deviation of comment to post raito per user (1.62 +- 1.66)
• Worst comments per user sorted on (for all comments in a post: sum of age in days - comment upvotes) Posts with multiple, old, unscored comments on them will have a high "score". My worst, at time of writing, was 7150, and was a back and forth thread that should have been purged long ago.

Dont:

On the RPG Data Explorer ... I've made a query of the number of comments per user.

The results, especially done as a ratio of comments over posts is fascinating. At this point, I will simply encourage users to contemplate their comment activity versus their more productive activity. Refer to the site comment policy here: Why are site comments being deleted?

Are there any ways I can improve this query, to help members of this site self-moderate?

Other queries:

• Number of comments per tag
• Average and Standard Deviation of comment to post ratio per user (1.62 +- 1.66)
• Worst comments per user sorted on (for all comments in a post: sum of age in days - comment upvotes) Posts with multiple, old, unscored comments on them will have a high "score". My worst, at time of writing, was 7150, and was a back and forth thread that should have been purged long ago.

Dont:

On the RPG Data Explorer ... I've made a query of the number of comments per user.

The results, especially done as a ratio of comments over posts is fascinating. At this point, I will simply encourage users to contemplate their comment activity versus their more productive activity. Refer to the site comment policy here: http://meta.rpg.stackexchange.com/questions/1174/why-are-site-comments-being-deleted

Are there any ways I can improve this query, to help members of this site self-moderate?

Other queries:

• Number of comments per tag
• Average and Standard Deviation of comment to post raito per user (1.62 +- 1.66)
• Worst comments per user sorted on (for all comments in a post: sum of age in days - comment upvotes) Posts with multiple, old, unscored comments on them will have a high "score". My worst, at time of writing, was 7150, and was a back and forth thread that should have been purged long ago.

Dont:

On the RPG Data Explorer ... I've made a query of the number of comments per user.

The results, especially done as a ratio of comments over posts is fascinating. At this point, I will simply encourage users to contemplate their comment activity versus their more productive activity. Refer to the site comment policy here: Why are site comments being deleted?

Are there any ways I can improve this query, to help members of this site self-moderate?

Other queries:

• Number of comments per tag
• Average and Standard Deviation of comment to post raito per user (1.62 +- 1.66)
• Worst comments per user sorted on (for all comments in a post: sum of age in days - comment upvotes) Posts with multiple, old, unscored comments on them will have a high "score". My worst, at time of writing, was 7150, and was a back and forth thread that should have been purged long ago.

Dont: