Awards History - Channa - DarkPyro's Servers

ERROR

Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dpgweb_stats.hlstats_Awards.awardId' 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
				MAX(hlstats_Players_Awards.awardTime) AS awardTime,
				hlstats_Awards.name,
				hlstats_Awards.verb,
				COUNT(verb) AS count,
				hlstats_Awards.awardId
			FROM
				hlstats_Players_Awards
			INNER JOIN
				hlstats_Awards
			ON
				hlstats_Awards.awardId = hlstats_Players_Awards.awardId
			WHERE
				hlstats_Players_Awards.playerId = 9430
			GROUP BY
				hlstats_Awards.name,
				hlstats_Awards.verb
			ORDER BY
				awardTime desc,
				name desc
			LIMIT
				0,50