Someone

SELECT * 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;