3 ms·
I don't think it's public (it might not even be saved) but something akin to Reddit's "controversial" would be interesting as well. I've seen my comments go fro
by pc86 8mo ago
I don't think it's public (it might not even be saved) but something akin to Reddit's "controversial" would be interesting as well. I've seen my comments go from double-digit positive to double-digit negative, and vice versa, in contentious threads on divisive topics. It'd be interesting to see who has the most votes regardless of +/- but the lowest total karma. Who amongst us is just pissing off everyone?
- Imustaskforhelp 8mo agohttps://news.ycombinator.com/user?id=proven https://news.ycombinator.com/user?id=proven Here's the Query that I ran on play.clickhouse.com (Please note that both the queries that I am about to give are AI generated) SELECT id, argMax(karma, update_time) AS current_karma FROM hackernews_changes_profiles GROUP BY id ORDER BY current_karma ASC LIMIT 5 № id current_karma1 1 Proven -247 2 VentureHawk -89 3 adamyormark -50 4 oldpersonintx2 -45 5 sevenstar -35 So proven has the lowest karma. While at it, Here's the query for the most upvoted (karma) people on hackernews SELECT id, argMax(karma, update_time) AS current_karma FROM hackernews_changes_profiles GROUP BY id ORDER BY current_karma DESC LIMIT 5 id current_karma 1 tptacek 414947 2 jacquesm 235042 3 ingve 214146 4 todsacerdoti 204814 5 rbanffy 184030 I remember tptacek because he is the second person of all the people (behind dragonwriter) and he has written 14.37 Volumes worth of game of thrones. Hope this helps. I just ran the query because I was curious to find the results :D I can add this query to the website, but one of my worries (even with this post) is that people might try to now benchmark it which wasn't my intention & it will fail to be a good measure (someone mentioned the goodhart's law which is correct/apt here)