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;