Also ich habe folgende Daten angelegt...
Code:
user_id | username | score | land
1 | 1 | 1 | 1
2 | 2 | 2 | 2
3 | 3 | 3 | 3
4 | 4 | 4 | 4
11 | 11 | 11 | 11
21 | 21 | 21 | 21
32 | 32 | 32 | 32
Abfrage...
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 = 4))) LIMIT 5
liefert...
Code:
user_id | username | score | land
2 | 2 | 2 | 2
3 | 3 | 3 | 3
4 | 4 | 4 | 4
11 | 11 | 11 | 11
21 | 21 | 21 | 21
Das sieht doch richtig aus?