ERROR |
Database Error Server Address: 185.80.128.218 Server Username: statsx Error Diagnostic: Bad query. Server Error: (1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY numawards desc, playerName desc LIMIT 0,50' at line 31 Last SQL Query: SELECT flag, lastName AS playerName, hlstats_Players.playerId, hlstats_Awards.name as awardName, COUNT(hlstats_Awards.name) AS numawards FROM hlstats_Players INNER JOIN hlstats_Players_Awards ON ( hlstats_Players_Awards.playerId=hlstats_Players.playerId AND hlstats_Players_Awards.game=hlstats_Players.game ) INNER JOIN hlstats_Awards ON ( hlstats_Players_Awards.awardId=hlstats_Awards.awardId AND hlstats_Players_Awards.game=hlstats_Awards.game ) WHERE hlstats_Awards.code = '' AND hlstats_Players.game = 'cstrike' AND hlstats_Players.hideranking<>'1' GROUP BY flag, lastName, hlstats_Players.playerId HAVING COUNT(hlstats_Awards.name) >= ORDER BY numawards desc, playerName desc LIMIT 0,50 |