A SQL query optimzation issue with ORDER BY
The only way you are going to avoid a filesort on this one is if you maintain a materialized view of a JOIN between Game and GamePosition, so that you can create an index across (fen, white_elo).