One of the interesting data reports is the following:
Top 50 Quality Users
(based on post score calculated using reply count, likes, incoming links, bookmarks, time spent and read count)
So who are our ‘highest quality’ users?
11 Likes
What does Post Count refer to in this report? It’s not their actual total post count.
4 Likes
the interval is 6 months
4 Likes
Where’s the metric for PWI? 
1 Like
Interesting.
Not exactly sure how those parameters count? But it sounds like i could get a top spot for writing long provocative posts about Burgundy in every single Burgundy thread? 
(well most threads seem to turn into a Burgundy thread).
2 Likes
2 Likes
Wish I had the time available in the day to be be on that list and spend that much of my day thinking about wine!
1 Like
How do you think I feel??
3 Likes
I’m proud to be a low-grade, middling, mediocre poster.
5 Likes
Results obviously reflect a bias… the count was “stolen”…
3 Likes
No idea what this means, but either humiliated or honored to be included.
5 Likes
So being a perpetual lurker doesn’t get me there. Fair enough.
3 Likes
How unexpected. Thank you Todd 
1 Like
there’s a list for that, as well! ‘Most Active Lurkers’…but you aren’t on that, either (however, three other Jens on that list). I can find a list you are part of, trophies abound!
3 Likes
Hmm, and here I thought that was from a non-PC rap song!
I demand a recount!!! Todd’s dominion and control has been hacked from Venezuela!
2 Likes
Remember I shared the code with you, feel free to utilize it to generate the results you want! You have so many badges, Chris should be very proud of your success here!
SELECT sum(p.score) / count(p) AS “average score per post”,
count(p.id) AS post_count,
p.user_id
FROM posts p
JOIN users u ON u.id = p.user_id
WHERE p.created_at >= CURRENT_DATE - INTERVAL ‘6 month’
AND NOT u.admin
AND u.active
GROUP BY user_id,
u.views
HAVING count(p.id) > 50
ORDER BY sum(p.score) / count(p) DESC
LIMIT 50
1 Like
Wait, I’m on this list? Someone more “high quality” than me said something about refusing to join any club that would have me as a member… 
I can’t deny the fact that you like me. Right now, you like me.
4 Likes
Darn you stole my joke!
But I was going to use it to emphasize that I’m glad I’m not on the list!
2 Likes