Who are the 'highest quality' members on Wine Berserkers? đŸ€Ș

WINE TALK
1

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?

image
image1668×1952 389 KB

image
image1658×1874 376 KB

11 Likes
2

@Robert.A.Jr is not going to be happy one bit not seeing his name on here.

5 Likes
3

What does Post Count refer to in this report? It’s not their actual total post count.

4 Likes
4

the interval is 6 months

4 Likes
5

Where’s the metric for PWI? :thinking:

1 Like
6

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? :grin:

(well most threads seem to turn into a Burgundy thread).

2 Likes
7
2 Likes
8

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
9

How do you think I feel??

3 Likes
10

I’m proud to be a low-grade, middling, mediocre poster.

5 Likes
11

Results obviously reflect a bias
 the count was “stolen”


3 Likes
12

No idea what this means, but either humiliated or honored to be included.

5 Likes
13

So being a perpetual lurker doesn’t get me there. Fair enough.

3 Likes
14

How unexpected. Thank you Todd :cheers:

1 Like
15

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
16

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
17

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
18

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
 :joy: :rofl:

19

I can’t deny the fact that you like me. Right now, you like me.

4 Likes
20

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