Make it possible to query a game based on players' average_rating

[Crotalus]

I'm working on a bot command to show top rating replays for a specific period, i.e. list replays max 1 week old with high rated players.

The current poor man version is something like this: https://api.faforever.com/data/game?include=playerStats.player&sort=startTime&page[limit]=1&filter=startTime=gt=2021-08-01T11:58:02Z;playerStats.player.globalRating.rating=gt=2000 Then I at least get a game with at least one player having globalRating.Rating > 2000 but that could be a high rated player bashing noobs. Another problem is that it is the current rating, not the rating when the game was played.

What I really want is to be able to query and sort on the players average_rating of a game, I guess this would require a new column to game_stats which is then updated by the python server at game start?

[Sheikah45]

This is not really a trivial issue nor entirely clear how it should be done. With the new matchmaker games are allowed to affect more than one rating so there is not a single rating that can be computed as the average