Mysql in cod2 query question

[IzNoGoD]

Thx for the help

It was not exactly what i wanted (asc/desc and double-limit hurtz my brainz), but this is what i actually wanted:

SELECT * from (SELECT * FROM (SELECT * FROM checkpoint_statistics WHERE cp_id = 1081 ORDER BY time_played ASC LIMIT 10) AS tmp ORDER BY time_played DESC) as tmp2 LIMIT 1

Edit: this also works and is less code:

 SELECT * FROM checkpoint_statistics WHERE cp_id = 1081 ORDER BY time_played ASC LIMIT 9,1