HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

ERROR
Database Error

Server Address: server3.ip-net.sk
Server Username: cstrike

Error Diagnostic:
Bad query.

Server Error: ()

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