Getting an error with it in conjuntion w/1.01:
Quote:
Invalid SQL:
SELECT COUNT(games.highscorerid) AS count, user.username, user.userid FROM arcade_games AS games
LEFT JOIN user AS user ON user.userid = games.highscorerid
WHERE user.userid IS NOT NULL
GROUP BY user.username, user.userid ORDER BY count DESC, user.userid ASC LIMIT;
MySQL Error : 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 '' at line 4
Error Number : 1064
|