kackbratzen.net - Counter-Strike: Global Offensive

Sections

Daily Awards (Monday 25 Sep)

AK47 No Award Winner 0 kills with ak47	Aug No Award Winner 0 kills with aug	AWP No Award Winner 0 kills with awp	Best Latency No Award Winner 0 ms average connection
Desert Eagle No Award Winner 0 kills with deagle	Dual Berretta Elites No Award Winner 0 kills with elite	Five Seven No Award Winner 0 kills with fiveseven	Fusil Automatique No Award Winner 0 kills with famas
G3 SG1 No Award Winner 0 kills with g3sg1	Galil No Award Winner 0 kills with galil	Glock No Award Winner 0 kills with glock	Headshot King No Award Winner 0 shots in the head
High Explosive Grenade No Award Winner 0 kills with grenade	Incendiary Grenade No Award Winner 0 kills with inferno	Knife Maniac No Award Winner 0 knifings	M249 No Award Winner 0 kills with m249
M4A4 No Award Winner 0 kills with m4a4	MAC-10 No Award Winner 0 kills with mac10	MAG-7 No Award Winner 0 kills with mag7	Most Kills No Award Winner 0 kills
Most Valuable Player No Award Winner 0 times earning Round MVP	MP7 No Award Winner 0 kills with mp7	MP9 No Award Winner 0 kills with mp9	Negev No Award Winner 0 kills with negev
Nova No Award Winner 0 kills with nova	P2000 No Award Winner 0 kills with p2000	P250 No Award Winner 0 kills with p250	P90 No Award Winner 0 kills with p90
PP-Bizon No Award Winner 0 kills with pp-bizon	Sawed-Off No Award Winner 0 kills with sawed-off	SCAR-20 No Award Winner 0 kills with scar-20	SG 553 No Award Winner 0 kills with sg553
SSG 08 No Award Winner 0 kills with ssg08	Suicides No Award Winner 0 suicides	Team Killer No Award Winner 0 team kills	Tec-9 No Award Winner 0 kills with Tec-9
Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top Hostage Killer No Award Winner 0 hostages killed	Top Hostage Rescuer No Award Winner 0 hostages rescued
UMP-45 No Award Winner 0 kills with ump45	XM automatic Shotgun No Award Winner 0 kills with xm1014	Zeus x27 No Award Winner 0 kills with taser

Global Awards

AK47 No Award Winner 0 kills with ak47	Aug No Award Winner 0 kills with aug	AWP No Award Winner 0 kills with awp	Best Latency No Award Winner 0 ms average connection	Desert Eagle No Award Winner 0 kills with deagle
Dual Berretta Elites No Award Winner 0 kills with elite	Five Seven No Award Winner 0 kills with fiveseven	Fusil Automatique No Award Winner 0 kills with famas	G3 SG1 No Award Winner 0 kills with g3sg1	Galil No Award Winner 0 kills with galil
Glock No Award Winner 0 kills with glock	Headshot King No Award Winner 0 shots in the head	High Explosive Grenade No Award Winner 0 kills with grenade	Incendiary Grenade No Award Winner 0 kills with inferno	Knife Maniac No Award Winner 0 knifings
M249 No Award Winner 0 kills with m249	M4A4 No Award Winner 0 kills with m4a4	MAC-10 No Award Winner 0 kills with mac10	MAG-7 No Award Winner 0 kills with mag7	Most Kills No Award Winner 0 kills
Most Valuable Player No Award Winner 0 times earning Round MVP	MP7 No Award Winner 0 kills with mp7	MP9 No Award Winner 0 kills with mp9	Negev No Award Winner 0 kills with negev	Nova No Award Winner 0 kills with nova
P2000 No Award Winner 0 kills with p2000	P250 No Award Winner 0 kills with p250	P90 No Award Winner 0 kills with p90	PP-Bizon No Award Winner 0 kills with pp-bizon	Sawed-Off No Award Winner 0 kills with sawed-off
SCAR-20 No Award Winner 0 kills with scar-20	SG 553 No Award Winner 0 kills with sg553	SSG 08 No Award Winner 0 kills with ssg08	Suicides No Award Winner 0 suicides	Team Killer No Award Winner 0 team kills
Tec-9 No Award Winner 0 kills with Tec-9	Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top Hostage Killer No Award Winner 0 hostages killed	Top Hostage Rescuer No Award Winner 0 hostages rescued
UMP-45 No Award Winner 0 kills with ump45	XM automatic Shotgun No Award Winner 0 kills with xm1014	Zeus x27 No Award Winner 0 kills with taser

ERROR

Database Error

Server Address: localhost
Server Username: hlxce

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlxce.hlstats_Ranks.rankId' 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
			rankName,
			minKills,
			rankId,
			count(playerId) AS obj_count
		FROM
			hlstats_Ranks
		INNER JOIN
			hlstats_Players
		ON (
           hlstats_Ranks.game=hlstats_Players.game
           )	
		WHERE
			kills>=minKills
			AND kills<=maxKills
			AND hlstats_Ranks.game='csgo'
		GROUP BY
			rankName,
			minKills