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

ERROR
Database Error

Server Address: localhost
Server Username: USER427675_stats

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_427675_2.hlstats_Awards.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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 = 'mp5navy' AND
			hlstats_Players.game = 'css' AND
			hlstats_Players.hideranking<>'1'
		GROUP BY
			flag,
			lastName,
			hlstats_Players.playerId
		HAVING
			COUNT(hlstats_Awards.name) >= 1  	
		ORDER BY
			numawards desc,
			playerName desc
		LIMIT 0,50