select s.server_name, s.ip_address,
sg.stats_game_id, sg.game_type, sg.duration_seconds, sg.level_name, UNIX_TIMESTAMP(sg.insertion_date) as insertion_date, sg.is_team_game,
st.team_name, st.color_hex, st.team_score, st.result as team_result,
sp.player_name, sp.is_robot, sp.points, sp.kill_count, sp.death_count, sp.suicide_count, sp.is_authenticated, sp.result as player_result
from server s
join stats_game sg on s.server_id = sg.server_id
join stats_team st on sg.stats_game_id = st.stats_game_id
left join stats_player sp on st.stats_team_id = sp.stats_team_id
where sg.insertion_date between sysdate() - interval 1 day and sysdate()
and sg.stats_game_id in (
    select stats_game_id
    from stats_player
    where player_name = 'raptor'
    and insertion_date between sysdate() - interval 1 day and sysdate()
)
order by sg.insertion_date desc, sg.level_name, st.team_name, sp.is_robot asc, sp.points desc