Anonymous

SQL-forespørgsel:  

DELETE FROM hp_duel_challenges WHERE id IN (

SELECT id
FROM hp_duel_challenges except
SELECT id
FROM (

SELECT id, time
FROM hp_duel_challenges
ORDER BY time DESC 
LIMIT 10 
) AS F
) 

MySQL returnerede:  

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select id from (select id, time from hp_duel_challenges order by time desc limit' at line 1