HLstatsX Community Edition
  • Contents
  • Search
  • Help

ERROR
Database Error

Server Address: 31.133.0.163
Server Username: hlstatsx

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 = '5' 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