SELECT * FROM GamertagMedals WHERE MedalID = 14 AND Ranked = 1 ORDER BY Count DESC, Gamertag ASC LIMIT 0, 30

Is there any way to index it? I notice problem when I mix ordering by ASC and DESC. How do I get around this?