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