Hi Aulex, I wouldn't really want to search by rating. I'd be more interested in all 1vs1 games and their results.
Without knowing FAF db schema exactly (and pls forgive my rusty sql), I suspect I'd like something similar to:
select replay.id, replay.map_name, replay.time_start, replay.time_end, replay.duration, replay.game_type,
player.name, (player.uniqueID so as not to be confused by name changes??), player.score, player.faction, player.rating_mean, player.rating_stdev
from replays
join player on replay.id=player.replayid
where replay.game_type=1vs1
But for good measure, I'd like all the custom games too, for later on
Infact, maybe its better if I can just get my hands on a backup of the whole db
:D