Any way to list the top X commenters, by # of comments?

kovie's Avatar

kovie

19 May, 2017 04:32 AM

Someone posted such a list years ago, forgot who. Obviously it can be done on the back end (I've worked with SQL). The top 100 would be nice. Someone posted a diary about how Gooserock has 175k (which is insane btw), so my curiosity is piqued. Is there any way to do this via the search feature?

  1. 1 Posted by siab on 19 May, 2017 05:06 PM

    siab's Avatar

    Sure. Go to Search/Users, change By Activity: to Last Commented, and click the Search button. When you have the list of users who have commented, click the arrow above Comments to sort by number of comments. It should be high to low, but if it isn't, click the arrow again to change that.

    Search is currently not working (at least on my computer, so it may be a while)

  2. 2 Posted by siab on 19 May, 2017 05:09 PM

    siab's Avatar

    Correction - User search is working, but it times out on the full dataset. Hasn't in the past, so I assume it will be corrected.

  3. 3 Posted by siab on 19 May, 2017 05:12 PM

    siab's Avatar
  4. kovie closed this discussion on 20 Jul, 2017 01:46 AM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac