How do I make the most efficient statement in MySQL?

nkbsbl · (#1 (**permalink**))

SItuation:

Table containing many rows that each include a GameID and a Unix Timestamp (for when the game is played). What's the most efficient way to select all rows after a certain date (I know how to do that part) that orders by the GameID's that are most prevalant for that time period (not sure)? Can this be done in a single statement?

michael k · (#2 (**permalink**))

Not sure about this...but try

SELECT * FROM games WHERE date > startdate ORDER BY COUNT(gameid)