Fun Poster Data

I am not sure where what you describe exists. This is as close as I can get to it. I don’t discuss politics with many people in real life at all ever. Like, it’s impossible to even discuss the efficacy of wearing a mask in public in most places right now. It seems like what you are talking about is personal levels of conflict aversion and where the line of feeling safe to express yourself based on reaction is. How personally one takes that kind of discourse and how long it lasts.

I mean jfc. 6ix is one of my favorite posters to have around. I miss him when he is gone. He and I went at it when we first met and several times after. In public and even in pms. Look at NBZ and Cuse.

I guess I just wonder what you think is possible when discussing the most inflammatory topics possible in the most divided period we have all lived through?

1 Like
2 Likes

@jmakin we have a plugin that lets admins make SQL queries against the live database. If there are stats you can’t get easily however you’re doing it, you might be able to get them this way. I haven’t bothered to figure out how to make custom queries, but maybe it’s rally easy for someone who knows what they’re doing.

For example,

WITH pairs AS (
    SELECT p.user_id liked, pa.user_id liker
    FROM post_actions pa
    LEFT JOIN posts p ON p.id = pa.post_id
    WHERE post_action_type_id = 2
)
SELECT liker liker_user_id, liked liked_user_id, count(*)
FROM pairs
GROUP BY liked, liker
ORDER BY count DESC

returns

Which users like particular other users the most?
liker_user liked_user count
King_of_NY beetlejuice 1019
Smacc_25 beetlejuice 825
Smacc_25 microbet 822
oneeyedtripping beetlejuice 817
otatop Riverman 755
Smacc_25 RiskyFlush 695
beetlejuice RiskyFlush 688
otatop JohnnyTruant 677
Marksman RiskyFlush 671
Trolly Riverman 659
oneeyedtripping microbet 659
oneeyedtripping Riverman 646
Marksman Riverman 631
RiskyFlush Smacc_25 615
Namath Riverman 596
wirelessgrinder Riverman 589
Marksman kre8tive 578
Smacc_25 JohnnyTruant 577
Smacc_25 jalfrezi 575
otatop kre8tive 574
oneeyedtripping JohnnyTruant 564
otatop beetlejuice 554
JohnnyTruant RiskyFlush 545
RiskyFlush Trolly 520
ViridianDreams Riverman 499
Smacc_25 Trolly 498
otatop RiskyFlush 497
StimAbuser microbet 493
Smacc_25 kre8tive 487
wirelessgrinder RiskyFlush 483
RiskyFlush kre8tive 470
RiskyFlush JohnnyTruant 463
TrueNorth32 Riverman 459
JohnnyTruant beetlejuice 458
Marksman beetlejuice 456
beetlejuice Riverman 450
RiskyFlush Marksman 447
Smacc_25 Riverman 446
beetlejuice Smacc_25 446
oneeyedtripping 6ix 445
beetlejuice kre8tive 439
RiskyFlush suzzer99 435
otatop Smacc_25 429
Smacc_25 marty 422
JohnnyTruant microbet 419
oneeyedtripping Smacc_25 412
oneeyedtripping RiskyFlush 407
Namath RiskyFlush 401
RiskyFlush cuserounder 400
Rivaldo Rexx 400
skydiver8 cuserounder 400

Here’s more info on the plugin


3 Likes

I keep reading the title in Joey Ingram’s voice and expecting stats on the pro posters to be coming next.

1 Like

23d Time Read

realDonaldTrump Donald J. Trump
Impeached
694 Received
0 Given
0 Topics
6.1k Replies
3 Viewed
10 Read
5 Visits :point_left:Shiiiiiiiiiiiiiiite

3 Likes
Top topics past month
topic category reply_count
The Presidency of Donald J. Trump: Unconstitutional Slop (10009) Politics & News 5005
COVID-19: Chapter 5 - BACK TO SCHOOL (9057) Politics & News 2915
Covering the President: The Trials and Tribulations of Daniel Dale, Esq. (Assisted by Aaron Rupar) (9970) Politics & News 2383
The DNC 2020 (2281) Politics & News 2291
The 2020 Republican National Convention: There will be blood. And soil. (2287) Politics & News 2291
LC Thread 2020: Flowers and bunnies are back (7354) Politics & News 2175
POTUS BOWL 2020: Smoking Them Out (1335) Politics & News 1122
Joe Biden’s VP pick — Kamala Harris (1868) Politics & News 1120
Bailout / Stimulus Discussion (Hints Missed & Shartz Fired) (3283) Politics & News 957
Police Murder George Floyd Then Riot Nationwide (Links to Streams in OP) (10016) Politics & News 891
Major League Baseball (1394) Sports & Other Games 606
The Presidency of Donald J. Trump: Losers and Suckers Sink Ships (1682) Politics & News 497
National Basketball Association (731) Sports & Other Games 440
In Soviet Russia, Television Streams You! (4272) Sundry Chitchat 434
Massive explosion in Beirut (404) Politics & News 412
Investing (aka STONKS and other financial happenings) (4621) Politics & News 321
Walrus Grab Bag 2 - The Walrus Strikes Back (313) Sports & Other Games 308
Video Games (1199) Sports & Other Games 295
Individual Economics in the Age of COVID-19 (738) Sundry Chitchat 289
Football thread: HERE WE GO 10 IN A ROW (388) Sports & Other Games 281
“Get used to me staying”: The Journal of Alexandria Ocasio-Cortez, 2-term Congresswoman (2705) Politics & News 272
Cooking Good Food (2338) Sundry Chitchat 259
Bread Thread aka How to Make the Perfect Sourdough Bread (438) Sundry Chitchat 258
It’s the little things in life that make you smile in dark times (Steve Bannon arrested for boater fraud) (236) Politics & News 234
Why Did This Forum Split from 2+2 (2020) French BBV 231
LOL Democrats - How do you do, fellow kids? (556) Politics & News 229
2020 Senate + House Races (841) Politics & News 202
Moderation and English Grammer Discussion Thread (1721) About Unstuck 198
Leaving The US (402) Sundry Chitchat 184
Whereupon We Pontificate About Poor Media Outlet Choices (1754) Politics & News 183
Do we need a Q thread? (181) Politics & News 180
Movies (1858) Sundry Chitchat 176
Metallica Tournament (299) Sundry Chitchat 176
Weekday Pandemic Trivia (933) Sports & Other Games 149
Poker Hands (1261) Sports & Other Games 141
lapka-zarapka’s view of the world. (1389) French BBV 128
Dealing with Deplorable Family and Friends (871) Politics & News 123
George Floyd Uprisings - Fighting Fascism (433) Politics & News 122
It’s time to delete Facebook (124) Politics & News 118
The National Football League (4501) Sports & Other Games 110
What is the most obscure thing you do regularly? (210) Sundry Chitchat 109
So do I go to urgent care or ER? (106) Sundry Chitchat 108
Getting fat is a science, not an art (518) Sundry Chitchat 103
College Football 2020: An Abbreviated Thread (123) Sports & Other Games 96
Leftist Memes for Seizing the Means (1219) Politics & News 93
Golf (376) Sports & Other Games 93
Unstuck Summer Weight Loss Challenge (Potatoes Not Included) (306) Sundry Chitchat 91
Tropical Storm Laura: It’s Really Bad Guys - now a Tropical Depression (89) Politics & News 89
Movie Night Watch Party and Hamilton Appreciation Thread (2524) Sundry Chitchat 86
COVID-19: memes and goofs thread (1943) Politics & News 85
Best and Worst Airports (85) Sundry Chitchat 85
Marijuana: This is a therapy (941) Sundry Chitchat 82
The beer, wine, and spirits thread (257) Sundry Chitchat 79
******ginger cool cat LC****** (1648) Sundry Chitchat 78
Land of Hope & Glory? - UK Politics and other stuff (3344) Politics & News 77
Belarus: Just a prelude to November or another bad result for 10 millions Belarusians? (74) Politics & News 72
Led Zeppelin Tournament Bracket (627) Sundry Chitchat 70
Auto Repair (132) Sundry Chitchat 69
5 Likes

Micro has the most posts? Would not have guessed that

1 Like

It

2 Likes

doesn’t

2 Likes

surprise

2 Likes

me.

4 Likes
Top 50 Quality Users based on post score calculated using reply count, likes, incoming links, bookmarks, time spent and read count.
average score per post post_count user
190.5066666666667 60 Preet_Bharara
163.0276923076923 65 TJ_Eckleburg12
111.2652173913043 138 poopypants
95.05165562913906 151 hobbes9324
94.3883597883598 189 IrishRunner
86.49411764705881 306 Will1530
84.7864077669903 103 Soulman
82.89430894308941 615 Fatboy8
79.33968253968254 189 pvn
77.84367046215665 1493 kre8tive
75.20877419354841 775 geewhysee
74.5634705332086 4276 Riverman
73.94517453798768 974 Coasterbrad
71.08028895768834 969 LFS
71.05255319148937 940 otatop
70.60999999999999 60 TimBuktuuf
70.4409523809524 210 GermanGuy
69.86919431279621 211 amead
69.63687635574838 461 hokie
68.58119062697902 3158 JohnnyTruant
68.12421875000001 256 Nononocantsleep
67.44376130198911 553 Mr_Unstoppable
66.72153846153847 130 dbvm
65.56476964769648 369 m_reed05
65.43571428571428 84 Sogge
64.67318295739346 399 MimosaDef
64.44842105263157 95 Spinetta
64.05751072961375 233 Ikioi
63.63157894736845 133 Lostrich
63.50909090909092 231 sriracha
62.79772727272727 88 MaxCut
62.79136690647483 139 imjosh
62.75641025641027 78 Guillotine
62.29855394883204 899 jwax13
62.23760984182777 2845 beetlejuice
62.1588235294118 1530 dlk9s
61.95555555555556 117 joltinjake
61.60857787810384 1329 StimAbuser
61.57626459143969 514 Huehuecoyotl
61.15155555555557 450 JordanIB
61.03333333333333 72 von_Internet
60.94853896103896 1232 ChrisV
60.94436090225565 532 Rugby
60.86234177215189 632 Bigoldnit
60.77991631799162 478 TheDuker
60.73333333333334 417 SirOsis
60.64313725490197 51 vaya1
60.55846338535414 833 StrontiumDog
60.29405405405405 185 whosnext
59.92919254658386 161 tomrh3
2 Likes

Me

2 Likes

Either

2 Likes

I think this is wrong, no reasons other than feelings. :eyes:

1 Like

Posting like that is going to play hell with my like ratio.

3 Likes
Top 50 Quality Users with > 500 posts
average score per post post_count user
82.89430894308943 615 Fatboy8
77.84367046215668 1493 kre8tive
75.2087741935484 775 geewhysee
74.56347053320862 4276 Riverman
73.94517453798765 974 Coasterbrad
71.08028895768832 969 LFS
71.05255319148935 940 otatop
68.58119062697902 3158 JohnnyTruant
67.44376130198913 553 Mr_Unstoppable
62.29855394883204 899 jwax13
62.23760984182776 2845 beetlejuice
62.1588235294118 1530 dlk9s
61.60857787810383 1329 StimAbuser
61.5762645914397 514 Huehuecoyotl
60.94853896103896 1232 ChrisV
60.94436090225564 532 Rugby
60.8623417721519 632 Bigoldnit
60.55846338535414 833 StrontiumDog
59.48359788359787 945 econophile
59.24254090471606 1039 Devil
59.19936507936509 945 ViridianDreams
59.16729323308272 532 champ
59.00445151033389 1258 MrWookie
58.8124369747899 595 Tilted
58.76608887488182 3173 Danspartan
58.57240398293029 703 catfacemeowmers
58.39775891341252 2945 WichitaDM
58.24927745664745 1384 PocketChads
57.83247496423463 1398 simplicitus
57.06976521322477 2087 skydiver8
56.56893772893773 1365 MattyLice
56.53395638629285 1284 jman220
55.87642276422767 861 spidercrab
54.50265210608423 641 grue
54.19461655662774 1969 eyebooger
54.1656928838951 1335 MichaelDavis
54.12168396770473 3468 Trolly
52.04080749819753 1387 oneeyedtripping
51.79798994974875 1194 tabbaker
51.57796030116357 2922 mosdef
51.54991134751779 2256 Namath
50.97274939172748 822 Watevs
50.45289256198345 968 DrChesspain
50.42626970227673 571 bobman0330
49.91325966850832 1810 6ix
49.56422360248447 805 Chippa58
49.29417022140971 4923 Marksman
49.15304150085278 1759 goofyballer
48.23410404624278 692 ripdog
48.06272634096342 5854 cuserounder
1 Like

As I’ve said repeatedly, I think wishcasting is dangerous in these times and I don’t want to let it go unchallenged.

2 Likes

Is there a reason these post counts don’t line up with our actual post counts?

1 Like

Give my boy time. Soon Preet will dominate all categories.

3 Likes