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
Results 1 to 7 of 7
Thread: Mysql in cod2 query question
Threaded View
-
11th January 2013, 11:05 #2Assadministrator
- Join Date
- Jun 2012
- Location
- trailerpark
- Posts
- 2,011
- Thanks
- 2,102
- Thanked 1,084 Times in 753 Posts
timescale 0.01
-
The Following User Says Thank You to kung foo man For This Useful Post:
IzNoGoD (11th January 2013)
Reply With Quote