How can I improve this query to remove "Using Temporary" and "Using Filesort"

This qu开发者_StackOverflow中文版ery takes quite a long time to run, is there anything I could do to improve upon it?

SELECT b.* FROM games_tags bt, games b, tags t 
WHERE bt.tag_id = t.tag_id AND (t.tag_text IN ('flash')) 
  AND b.gameid = bt.game_id AND b.status ='1' 
GROUP BY b.gameid ORDER by rating DESC limit 5952, 16

---

Please try using JOIN to join tables correctly in your query