Someone
public text v1 · immutableSELECT * FROM
(SELECT character_name,charater_level
FROM armory_ranking
WHERE character_level
<(SELECT character_level
FROM armory_ranking
WHERE character_name='Molri' )
ORDER BY character_level DESC
LIMIT 100
UNION ALL
SELECT character_name,character_level
FROM armory_ranking
WHERE character_score >=
(SELECT character_level
FROM armory_ranking
WHERE character_name='Molri')
ORDER BY character_level
LIMIT 101) AS foo
ORDER BY character_level;