Как получить 2 строки, которым соответствует 1 ID?
SELECT t1.*, t2.*, (t1.scores+t2.scores) as score_sum FROM talbe t1
JOIN table t2 ON t1.gameID = t2.gameID AND t2.id <> t1.id
ORDER BY score_sum DESC
LIMIT 100
как-то так...
можно, что-то вроде такого:select gameID, sum(scores) as sum_score, group_concat(name order by name separator '; ') as gamers from table group by gameId order by sum_score limit 100