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:

Code:
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