#5179 [Stendhal Website] Hall of fame query slow

[Hendrik Brummermann]

EXPLAIN select distinct halloffame_archive.charname, halloffame_archive.rank, halloffame_archive.points, character_stats.outfit from halloffame_archive join character_stats on (charname=name) where name!="postman" and admin<=600 AND recent="0" and day = CURRENT_DATE() and fametype = "A" order by rank limit 10;

+----+-------------+--------------------+-------+---------------------------+---------------------------+---------+--------------------------------------+-------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+--------------------+-------+---------------------------+---------------------------+---------+--------------------------------------+-------+----------------------------------------------+
| 1 | SIMPLE | halloffame_archive | range | i_halloffame_day_charname | i_halloffame_day_charname | 39 | NULL | 77596 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | character_stats | ref | i_character_stats_name | i_character_stats_name | 34 | stendhal.halloffame_archive.charname | 1 | Using where |
+----+-------------+--------------------+-------+---------------------------+---------------------------+---------+--------------------------------------+-------+----------------------------------------------+
2 rows in set (0.01 sec)