|
Longest threads (none of these include archives which I can query separately)pre:+------------+----------+-----------------------------------------------------------------------------------+ | replycount | threadid | title | +------------+----------+-----------------------------------------------------------------------------------+ | 563483 | 3680205 | TRUMP: holy gently caress its november 8th | | 508056 | 3579076 | ADTRW Cargo Cult Thread | | 307589 | 3810864 | TRUMP116: https://www.youtube.com/watch?v=vUz9xCTOPRw | | 301657 | 3601551 | Giant Bomb 2017 - Gerstmann Wins! | | 287044 | 3796979 | TRUMP (28): but it's cardboard ha ha ha | | 286101 | 3807005 | Post itt every time you lol that Trump is a C-SPAM mod (the laughter gets louder) | | 283605 | 3717961 | Bernie 2016: Hitlery | | 283421 | 3824002 | OLD TRUMP THREAD GO TO THE NEW ONE | | 281400 | 3690783 | Work Crew: thread page double sex number, nice | | 278727 | 3650476 | PWM: RIP | +------------+----------+-----------------------------------------------------------------------------------+
|
# ? Apr 3, 2020 20:29 |
|
|
# ? May 30, 2024 12:16 |
|
lmao that there's a 200,000 post gap between trump/anime and everything else
|
# ? Apr 3, 2020 20:29 |
|
Thanks for keeping the site's pageviews up, Mr. President!
|
# ? Apr 3, 2020 20:33 |
|
Jeffrey of YOSPOS posted:lmao that there's a 200,000 post gap between trump/anime and everything else Here's a challenge: could you find out which thread has the highest reply count / time open ratio?
|
# ? Apr 3, 2020 20:35 |
|
People should stop posting about Trump so much IMO.
|
# ? Apr 3, 2020 21:27 |
|
In Training posted:People should stop posting about Trump so much IMO. I agree.
|
# ? Apr 3, 2020 21:28 |
|
Does the new xbox have the right kind of RAM?
|
# ? Apr 3, 2020 21:44 |
|
Jeff. Can you show the top ten bookmarked threads in gbs?
|
# ? Apr 3, 2020 21:59 |
|
Jeffrey of YOSPOS posted:Most viewed threads: Wow, 10 different HIV strains!
|
# ? Apr 3, 2020 22:13 |
|
Arrhythmia posted:Here's a challenge: could you find out which thread has the highest reply count / time open ratio? pre:+----------+--------+------------+---------------------------------------------------------------------------+----------+ | datespan | rate | replycount | title | threadid | +----------+--------+------------+---------------------------------------------------------------------------+----------+ | 8636 | 0.4515 | 3899 | Sony E3 2014 Conference: Kaz Hirai's Twitter is Real | 3641829 | | 20595 | 0.4358 | 8975 | Super Bowl 50 Official GDT: Poop and toenail fungus | 3763436 | | 20450 | 0.3867 | 7909 | GB@SEA NFCCG GDT: Don't listen to 'em Marshawn, wear the gold cleats! | 3695380 | | 2577 | 0.3353 | 864 | Hello, posters of cspam. | 3909802 | | 17306 | 0.3304 | 5718 | [Wildcard GDT] Pittsburgh Steelers vs. Cincinnati Bengals | 3759446 | | 18962 | 0.3300 | 6258 | Super Bowl LIV GDT - You want the ball? | 3913180 | | 25152 | 0.3090 | 7772 | NFL Draft Game Day Thread 1st round ONLY | 3632643 | | 12717 | 0.2954 | 3757 | NFL Week 7: EARLY GAME MEGATHREAD GDT | 3674327 | | 18392 | 0.2875 | 5288 | The Ultimate Geezer Showdown: PV=nRT @ C39H60N8O13, AFC Championship Game | 3761457 | | 19063 | 0.2810 | 5357 | NFL Week 1 Early GDT - CBS hopes you wanted to watch the Texans | 3741616 | +----------+--------+------------+---------------------------------------------------------------------------+----------+
|
# ? Apr 3, 2020 22:52 |
|
Jeffrey of YOSPOS posted:This is a hack job and I used the time between the first post and the first post on the last page for expediency: Lol that was the overlong cspam IK resignation letter
|
# ? Apr 3, 2020 23:01 |
|
Oh it was the one PPJ posted himself actually, I thought it was the GBS one.
|
# ? Apr 3, 2020 23:09 |
|
Which threads had the most unique posters?
|
# ? Apr 3, 2020 23:44 |
|
Loving these stats.
|
# ? Apr 4, 2020 01:19 |
|
Leperflesh posted:Which threads had the most unique posters? Sorry for no thread titles but: pre:+----------+------------------------+ | threadid | count(distinct userid) | +----------+------------------------+ | 2584158 | 9276 | | 1633340 | 5778 | | 140694 | 4419 | | 2341562 | 4211 | | 3651576 | 3869 | | 3680205 | 3833 | | 3390388 | 3773 | | 1457686 | 3762 | | 1903899 | 3692 | | 2175822 | 3388 | +----------+------------------------+
|
# ? Apr 4, 2020 01:54 |
|
Jeffrey of YOSPOS posted:Sorry for no thread titles but: 1. Private Game Servers Steam Community IDs and requests. 2. The Hell Circus Your family reunion 3. Feedback & Discussion Positive / negative seller comment form: 4. Automotive Insanity AI Stupid Question Thread II -- READ THE FIRST POST BEFORE ASKING YOUR QUESTION 5. Games Steam Thread: you're not a kid any more and you want what you had when you were a kid 6. The Goodmine TRUMP: holy gently caress its november 8th 7. Dunning & Kruger Middle East Thread of Despair: More Broken Than Syria 8. SA-Mart SA Goon specials-Big John's Beef Jerky 9. Post Your Favorite (or Request): Stop! Collate and LISTen COMPLETELY 100% OFFICIAL 'REQUEST IMAGES' THREAD, part two 10. The Book Bran What Did You Just Finish?
|
# ? Apr 4, 2020 02:12 |
|
Athanatos posted:2. The Hell Circus Your family reunion Lol
|
# ? Apr 4, 2020 02:20 |
|
Athanatos posted:8. SA-Mart SA Goon specials-Big John's Beef Jerky Lol
|
# ? Apr 4, 2020 02:25 |
|
Jeffrey of YOSPOS posted:This is a hack job and I used the time between the first post and the first post on the last page for expediency: I am very pleased to see that GB@SEA game in this list.
|
# ? Apr 4, 2020 02:28 |
|
Athanatos posted:1. Private Game Servers Steam Community IDs and requests.
|
# ? Apr 4, 2020 02:37 |
|
This is the most interesting thread on the forums and it makes me happy
|
# ? Apr 4, 2020 03:49 |
|
Athanatos posted:1. Private Game Servers › Steam Community IDs and requests. AI making an appearance helping other goons fix their shitboxes.
|
# ? Apr 4, 2020 04:20 |
|
It's very good jerky
|
# ? Apr 4, 2020 06:15 |
|
GRINDCORE MEGGIDO posted:Jeff. Can you show the top ten bookmarked threads in gbs? pre:+-----------+----------+-------------------------------------------------------------------------------+ | bookmarks | threadid | title | +-----------+----------+-------------------------------------------------------------------------------+ | 2921 | 3792330 | /r/relationships: Memento Mori Lasagna | | 2515 | 3763899 | OSHA: definitely bent in the straight places | | 2110 | 3833370 | Cursed images: include a cursed image, dumbass | | 1810 | 3904642 | OSHA IV: Safety would make it impossible. There's no money in it | | 1739 | 3910844 | r/relationships: Oompa-Loompa body rear end bitch | | 1674 | 3897718 | Schadenfreude: The bridge that keeps on giving | | 1571 | 3911826 | We Are All Gonna Die: its time | | 1326 | 3847325 | Pics that show how #blessed you are :justpost: | | 1274 | 3633652 | OSHA - Big government interference in small business.... and how to stop them | | 1229 | 3695572 | Japan.jpg (Anime Free Zone) | +-----------+----------+-------------------------------------------------------------------------------+
|
# ? Apr 6, 2020 05:46 |
|
Bernie toxx makes me wonder what is the greatest number of bans in a single day.
|
# ? Apr 8, 2020 19:16 |
|
Jeffery, any way you can run some numbers on reregs from todays bans, and how long it took the average person to rereg?
|
# ? Apr 8, 2020 23:21 |
|
dee eight posted:Bernie toxx makes me wonder what is the greatest number of bans in a single day. i'm assuming it's 1) this 2) hillary toxx ban 3) avenatti toxx ban? am i forgetting one?
|
# ? Apr 9, 2020 01:14 |
|
I thought the Hillary toxxes didn't happen? Or there was some other drama around it.
|
# ? Apr 9, 2020 01:17 |
|
In Training posted:I thought the Hillary toxxes didn't happen? Or there was some other drama around it. the original kerfluffle was letting people donate :tenbux: to charity instead of getting banned but that didn't go through
|
# ? Apr 9, 2020 01:18 |
|
Tetramin posted:Jeffery, any way you can run some numbers on reregs from todays bans, and how long it took the average person to rereg?
|
# ? Apr 9, 2020 01:27 |
|
Jeffrey of YOSPOS posted:The forums database and the store databases are separate and on separate servers, making this harder. I'm also a lot less inclined to screw around querying the store database, since while we do not retain any credit card information, purchase records are a sensitive thing by nature. Is today the biggest forums bloodbath in terms of people banned within 24 hours then?
|
# ? Apr 9, 2020 03:48 |
|
In Training posted:I thought the Hillary toxxes didn't happen? Or there was some other drama around it. They were all banned after Lowtax stepped in and said although toxxes are stupid, they've always been enforceable and you can't change the rules ex post facto. I think that intervention spurred a mass mod exodus if I'm remembering the events correctly.
|
# ? Apr 10, 2020 04:38 |
|
Son of Sam-I-Am posted:They were all banned after Lowtax stepped in and said although toxxes are stupid, they've always been enforceable and you can't change the rules ex post facto. I think that intervention spurred a mass mod exodus if I'm remembering the events correctly. It's more complicated than this and the mod exodus happened in at least two waves, is my understanding. Most of the mod threads about these topics are archived now so I can't read them, but I've pieced together from speaking to former mods that it was more about other stuff that was happening at the same time. Mod drama occurs in cycles, it is inevitable like the seasons or the tides. Anyway the Hillary toxxes did eventually go through (I was banned for that!).
|
# ? Apr 10, 2020 14:58 |
|
Of course it's the stats thread where I run afoul of the correlation/causation fallacy
|
# ? Apr 11, 2020 03:25 |
|
Jeffrey of YOSPOS posted:The forums database and the store databases are separate and on separate servers, making this harder. I'm also a lot less inclined to screw around querying the store database, since while we do not retain any credit card information, purchase records are a sensitive thing by nature.
|
# ? Apr 11, 2020 06:50 |
|
Here's one: what day(s) saw the most posts made?
|
# ? Apr 11, 2020 22:02 |
|
Anne Whateley posted:Is there a way to compare the ban list against whether an account is currently banned, instead of directly against purchases?
|
# ? Apr 11, 2020 22:19 |
|
Craig K posted:i'm assuming it's Years ago there was a day when all probs were a ban, and a bunch of different forums also had ban me games, it wouldn't surprise me if that got up there, because the forums were way more active then.
|
# ? Apr 16, 2020 01:04 |
|
See if you can guess what these each were! I just used the date of the time processed so sometimes these are one day grouped into two entries, such as 2007-04-(11,12) and 2016-11-(10,11).pre:+-----------------+------+ | DATE(date_proc) | Bans | +-----------------+------+ | 2020-04-08 | 497 | | 2016-11-11 | 219 | | 2018-12-04 | 181 | | 2006-12-12 | 144 | | 2010-05-24 | 104 | | 2016-11-10 | 93 | | 2012-11-06 | 89 | | 2007-04-11 | 77 | | 2010-05-31 | 65 | | 2007-04-12 | 64 | +-----------------+------+
|
# ? Apr 16, 2020 09:53 |
|
|
# ? May 30, 2024 12:16 |
|
Jeffrey of YOSPOS posted:See if you can guess what these each were! I just used the date of the time processed so sometimes these are one day grouped into two entries, such as 2007-04-(11,12) and 2016-11-(10,11). 1. Bernie toxxes 2. Hillary toxxes no idea after that, except 7 (McCain toxxes) ninjedit: I see the note about grouping - then 6 would be Hillary toxxes contd.
|
# ? Apr 16, 2020 11:22 |