Mysql in cod2 query question

[IzNoGoD]

Hey guys,

Im currently developing a jumpmod with mysql support (thx to kung for porting mysql to cod2) and am in need of a certain query.

What i have: A table filled with statistics for a certain checkpoint (checkpoint_statistics)
What i want: the 10th time_played from that table for a certain cp_id

What i think might work, but doesnt:

SELECT time_played FROM (SELECT * FROM checkpoint_statistics WHERE cp_id = 1081 ORDER BY time_played DESC LIMIT 10) LIMIT 1

Please help me