Re: GROUP BY ,ORDER BY optimization help

[Rick James]

First, does "GROUP BY order" give you the 'right' answer?
Based on the SELECT, I would expect you to need
GROUP BY g.id, g.name, g.playcount, g.rating, g.desc, g.nameid

I see no obvious reason for using LEFT; maybe use plain JOIN?

The first of these is redundant, and can be DROPped:
> KEY `active` (`active`,`unhacked`),
> KEY `active_2` (`active`,`unhacked`,`order`),
> KEY `active_3` (`active`,`unhacked`,`playcount`),

> int(25)
The 25 is nonsense. INT has a range of plus/minus 2 billion, regardless of the number after it.