SQL: benachbarte Datensätze mitselektieren

[omata]

Hier noch mal ein Vorschlag...

SQL-Code:

SELECT username, score, land 
FROM user
WHERE score >= (SELECT MAX(score)
                FROM user 
                WHERE score < (SELECT MAX(score)
                               FROM user 
                               WHERE score < (SELECT score
                                              FROM user 
                                              WHERE user_id = 1))) LIMIT 5

Edit: Korrektur!