HLstatsX Community Edition - Clanxa.com Xtreme Assassins Standard - Ribbon Details

ERROR

Database Error

Server Address: localhost
Server Username: clannet_stats

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'clannet_stats.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 = 'galil' AND
			hlstats_Players.game = 'cstrike' AND
			hlstats_Players.hideranking<>'1'
		GROUP BY
			flag,
			lastName,
			hlstats_Players.playerId
		HAVING
			COUNT(hlstats_Awards.name) >= 30  	
		ORDER BY
			numawards asc,
			playerName asc
		LIMIT 0,50