There is no "SORT BY" in MySQL, instead use "ORDER BY".
Also give the subtable a name with "AS":
SELECT
time_played
FROM
(SELECT * FROM checkpoint_statistics WHERE cp_id = 1081 ORDER BY time_played DESC LIMIT 10) AS tmp
LIMIT 1
There is no "SORT BY" in MySQL, instead use "ORDER BY".
Also give the subtable a name with "AS":
SELECT
time_played
FROM
(SELECT * FROM checkpoint_statistics WHERE cp_id = 1081 ORDER BY time_played DESC LIMIT 10) AS tmp
LIMIT 1
timescale 0.01
IzNoGoD (11th January 2013)