From now on I'll post here for all things related to stats, to prevent making too many threads, and to casually post new things. Until I make new versions of the following to put into the thread, here's what I've posted so far:

• User Stats thread - Compiled with data from 2016-06-05 • Game Stats thread - Compiled with data from 2016-04-21 • Black hole'd runs - Runs that don't exist on any leaderboard, regardless of obsoletion. Compiled with data sometime around 2016-05-09 • Games with co-op categories - Compiled with data sometime before 2016-05-13 • Runs that have been pending for a long time - Helpful for those looking to replace inactive moderators • Leaderboards with the least/most time with the most players/runs • Runs without videos, by ranking - Lists the runs with the highest positions by leaderboard that are missing videos, and in most cases actual proof. Take those runs with a grain of salt. Leaderboards with poorly organized times with/without loads make their positions inaccurate, so some runs are higher/missing as result. HiveMC DeathRun's runs were removed because of how they prove their runs. The Mario Kart series has quite a lot of world records without videos. Portal 1/2 also has this problem, among others. • Shortest Leaderboards - Lists the 1000 shortest full-game leaderboards for people who want to do an easy and quick run.

Note: Google Sheets seems to be somewhat buggy with the temporary filters (what you make when you sort).

Got a new one: Oldest World Records -- Contains all the records on site that are older than 1,000 days (2 years, 9 months).

A quick list of the oldest full game runs (over 4,000 days old/11 years): • Syberia - Any% • Who Framed Roger Rabbit? (NES) - Any% • Indiana Jones and the Last Crusade Taito - Any% • Adventures of Lolo 3 - Any% • Dino Crisis - any% • The Lone Ranger - Any% • Ultimate Doom - Knee Deep in the Dead {UV Speed}

Some of the more popular categories with long held records are: • Donkey Kong Country Returns - Any% • Kirby Super Star Ultra - Gourmet Race • Super Mario 3D Land - Any% • SSX Tricky - Tokyo Megaplex; Time Trial • Star Wars: Rogue Squadron - Rescue on Kessel; X-Wing

and the ones that are (somewhat) actively trying to be beaten: • Sparkster (SNES) - Normal • Mirror's Edge - Edge; Runs • Donkey Kong Country Returns - Any% • Mario Party DS - Boss Bash • Super Dodge Ball - Easy

Note: It doesn't take notice of multiple world record holders, so some may not be accurate. The ones I listed above are.

I misread this thread at first and I crunched how long it takes for a run to be approved.

25% of runs get approved within 1 hour 50% of runs get approved within 5 hours 80% of runs get approved within 24 hours 88% of runs get approved within 3 days 92% of runs get approved within 1 week (at this point you should try contacting the mod(s)) 95% of runs get approved within 3 weeks (if at this point you haven't had any response, ask to moderate the game yourself)

This excluded anything approved in under 5 seconds, which were mostly self-approved runs.

I probably won't make a new edition until the bug with how timing is saved is fixed. Currently games with 'time without loads' enabled causes the API to be inaccurate, as I've brought up on Github. I'd like to make something that returns things like previous world records and when a game was most active. I want to figure out how to do that.

Edit: Didn't take long, though I crunched it in Excel instead of Access. I'll post some tidbits for now and will have something better on the next full release. The following uses RunActivityAll, which isn't the same as what the site uses but similar.

The most active games on any given date:

1. SUPERHOT - 316.60 on 2016-03-07
2. Diddy Kong Racing - 285.19 on 2016-03-06
3. Star Wars: Rogue Squadron - 268.03 on 2005-02-25
4. Super Mario Sunshine - 201.74 on 2015-03-21
5. Metal Gear Solid V: The Phantom Pain - 163.09 on 2015-10-06
6. Polarity - 148.34 on 2015-05-16
7. Super Mario 64 - 140.30 on 2016-06-02 8) Kalimba - 135.26 on 2016-03-03
8. Undertale - 121.47 on 2016-01-30
9. PAYDAY 2 - 119.79 on 2015-07-28
10. Splatoon - 118.77 on 2015-06-13
11. EDGE - 115.03 on 2015-03-22
12. Portal - 105.24 on 2015-02-25
13. The Legend of Zelda: Ocarina of Time - 104.87 on 2016-02-13
14. Freedom Planet - 103.69 on 2016-04-16

Formerly active games that have fallen into oblivion: 4) The Legend of Zelda: The Lampshade of No Real Significance - 48.04 on 2015-07-19 5) Urban Chaos - 41.00 on 2015-06-25 6) Splashdown: Rides Gone Wild - 40.99 on 2015-02-17 7) Go Go Thomas - 36.11 on 2015-08-23 8) Blood - 35.81 on 2014-12-17 9) Enter The Matrix - 35.01 on 2015-08-30 10) Not the Robots - 32.24 on 2015-05-26 11) Konami Krazy Racers - 31.83 on 2015-09-14 12) Aerox - 31.00 on 2015-09-12 13) Hot Wheels: Micro Racers - 29.69 on 2015-02-25

Using a VERY strict formula for activity (user activity doesn't stack):

1. Barney's Hide & Seek Game - any% - 59.24 on 2015-07-15
2. Super Mario Sunshine - Any% {Normal} - 58.80 on 2015-04-13
3. Clustertruck - Alpha All Levels - 41.81 on 2016-02-24
4. Super Mario World - All Castles - 34.19 on 2016-05-31
5. The Legend of Zelda: Ocarina of Time - Any% - 34.03 on 2013-09-01
6. Portal - No OoB - 31.54 on 2015-02-13
7. The Legend of Zelda: A Link to the Past - No Major Glitches - 29.96 on 2016-04-10 8) Super Mario 64 - 16 Star - 29.42 on 2016-06-03
8. Super Mario 64 - 70 Star - 28.48 on 2016-05-31
9. Splatoon - Any% - 26.85 on 2015-07-29
10. Ori and the Blind Forest - Any% - 25.71 on 2015-04-10
11. Super Mario World - 11 Exit - 25.25 on 2015-09-14
12. Mario Kart 8 - 32 Tracks {150cc} - 23.84 on 2014-06-20
13. Kirby's Dream Land - Beat the Game - 23.43 on 2015-08-30
14. SUPERHOT - Any% {Normal} - 23.27 on 2016-03-08

I don't know when the API update is rolling out but I plan on updating everything soon.

Given that large updates never tend to go completely smoothly, I decided against rolling it out until AGDQ is over at least.

I'll be making a new thread once I've created the database~~, but in the meantime, Lighnat0r compiled a list of games by 'active players':

https://gist.githubusercontent.com/Lighnat0r/14f5566ddb7f8fa48d55c1038df702e5/raw/ba9a97122556bb8f2d72b0da78681a479a91c0c9/Player%2520activity%2520lower%2520decay%25202017-01-02.log

1. Super Mario 64 with 44
2. Super Metroid with 40
3. Refunct with 39
4. The Legend of Zelda: A Link to the Past with 38
5. Super Mario Bros. with 30
6. Super Mario Sunshine with 30
7. Destiny with 26 8) Undertale with 24
8. Counter-Strike: Global Offensive with 24
9. Super Mario World with 22
10. SpongeBob SquarePants: Battle for Bikini Bottom with 22
11. Shantae: Half-Genie Hero with 21
12. Portal with 19
13. Dishonored 2 with 19
14. Piano Tiles with 16~~

The algorithm's been changed.

Haven't settled on a formula but this one seems alright for now. Here's a small list of games currently trending:

1. Star Revenge 5: Neo Blue Realm
2. Shadow Tactics: Blades of the Shogun
3. Shantae: Half-Genie Hero
4. Resident Evil 7 biohazard
5. Multiple Mario Games
6. Mega Man X5
7. Pikmin 2 8) Super Mario Run
8. Spyro: Year of the Dragon
9. Mario Party 5
10. Dragon Ball: XenoVerse 2
11. Don't Shit Your Pants
12. Shovel Knight
13. Mega Man X4
14. Ori and the Blind Forest Definitive Edition
15. Paper Mario
16. Banjo-Tooie
17. Final Fantasy XV
18. Super Mario Bros. Memes
19. Super Smash Bros.

Hey there!

Hopefully I am posting in the correct thread, but I am really interested in the Activity stat on an individual game's statistics page, mostly just to see which games are trending at any given time. Is there any possible way we can add an activity filter/sort on the "All Games" page so that anyone can check this out without the need to wait for whoever has access to this to post in this thread, please? I feel like I may have seen a screenshot of that feature being a thing in an older thread last year, but not sure if that was on the site temporarily and then removed or if it was just something tested locally.

Thanks! :)

Me and lighnat0r talked about that a few days ago and managed to make a better formula that can be understood. There's a good chance it'll be included in the next big update.

On another note: I've crawled the site again and have all the data, I'm just fixing my queries before releasing a new sheet, as well as doing some analysis of N64 games.

Oh cool, that's great news! I am quite looking forward to that update then. :)

I remember seeing that 1st spreadsheet and loved digging through that. If you could add other criteria to your new one, such as consoles, year, etc, that would be cool as well, but it's just a random thought. Could be interesting to see what's trending in speedruns on retro consoles like NES, SNES, PS, etc., considering no new games are coming out for them ignoring homebrew.

Thanks, ROMaster2!