HLstatsX :: Game-server.sk - Left 4 Dead 2

Daily Awards (Sunday 19 May)

Adrenaline Junkie No Award Winner 0 adrenaline shots used	AK-47 No Award Winner 0 kills with the AK-47	Akimbo Assassin No Award Winner 0 kills with Dual Pistols	Ammo Saver No Award Winner 0 kills with Pistol	Automation No Award Winner 0 kills with Auto Shotgun
AWP No Award Winner 0 kills with awp	BANG Headshot. No Award Winner 0 kills with the Frying Pan	Barf Bagged No Award Winner 0 vomited on Survivors	Batter Up! No Award Winner 0 kills with the Baseball Bat	Black Scottish Psyclops No Award Winner 0 kills with the Grenade Launcher
Boom! No Award Winner 0 kills with Boomer's Claws	Brain Salad No Award Winner 0 headshot kills	Bumrush Thwarter No Award Winner 0 killed Chargers	Burger Tank No Award Winner 0 kills with Tank's Claws	Chain Smoker No Award Winner 0 kills with Smoker's Claws
Cheerio. No Award Winner 0 kills with the Cricket Bat	Chrome Shotgun No Award Winner 0 kills with the Chrome Shotgun	Combat Rifle No Award Winner 0 kills with the Combat Rifle	Combat Shotgun No Award Winner 0 kills with the Combat Shotgun	Commando No Award Winner 0 kills with M16 Assault Rifle
Crowbar No Award Winner 0 kills with the Crowbar	Dead Wreckening No Award Winner 0 downed Survivors	Dr. Shocker No Award Winner 0 teammates defibrillated	Drag & Drop No Award Winner 0 constricted Survivors	Field Medic No Award Winner 0 healed Survivors
Fight fire with an axe No Award Winner 0 kills with the Fireaxe	Fists of RAGGEE No Award Winner 0 melee kills	Free to Fly No Award Winner 0 pounced Survivors	GET OFF MY LAWN No Award Winner 0 gnome smash kills	Going for a ride! No Award Winner 0 jockey rides
Golf Club No Award Winner 0 kills with the Golf Club	Green can't be healthy.. No Award Winner 0 tank bilebombs	Ground Cover No Award Winner 0 rescued Survivors	Hawk Eye No Award Winner 0 kills with Hunting Rifle	Helping Hand No Award Winner 0 revived Survivors
Hi Dr. Nick! No Award Winner 0 kills with a First Aid Kit	Hulk Smash! No Award Winner 0 pummelings as a charger	Hunter Punter No Award Winner 0 killed Hunters	Hunter Punter No Award Winner 0 killed Jockeys	Hunter Punter No Award Winner 0 hunter punts
Inquisitor No Award Winner 0 killed Witches	Katana No Award Winner 0 kills with the Katana	Knife No Award Winner 0 kills with the Knife	Little Man Claws No Award Winner 0 kills with Jockey's Claws	Lowest Ping No Award Winner 0 ms average connection
M60 No Award Winner 0 kills with M60	Machete No Award Winner 0 kills with the Machete	Magnum No Award Winner 0 kills with the Magnum	MP5 Navy No Award Winner 0 kills with mp5	No One Left Behind No Award Winner 0 kills with Mounted Machine Gun
No Smoking Section No Award Winner 0 killed Smokers	Open Season No Award Winner 0 kills with Hunter's Claws	Protector No Award Winner 0 hunter punts	Pump It! No Award Winner 0 kills with Pump Shotgun	Pyromaniac No Award Winner 0 cremated Infected
Pyrotechnician No Award Winner 0 blown up Infected	Rock Star No Award Winner 0 kills with Tank's Rock	Safety First No Award Winner 0 kills with Uzi	Scout Elite No Award Winner 0 kills with scout	SG 552 No Award Winner 0 kills with sg552
Slice and Dice No Award Winner 0 kills with the Chainsaw	Snap Crackle Pop No Award Winner 0 kills with fire crackers	Sniper Rifle No Award Winner 0 kills with the Sniper Rifle	Spit shine No Award Winner 0 spitter acid attacks	Spittle Splatter No Award Winner 0 Spitters Splated
Stomach Upset No Award Winner 0 killed Boomers	TAAN... What is this?! No Award Winner 0 kills with Charger's Claws	Tankbuster No Award Winner 0 killed Tanks	Those nails could kill No Award Winner 0 kills with Spitter's Claws	Tonfa No Award Winner 0 kills with the Tonfa
Uzi (Silenced) No Award Winner 0 kills with the Uzi (silenced)	Wayne's world party on! No Award Winner 0 kills with the Electric Guitar

Global Awards

Adrenaline Junkie No Award Winner 0 adrenaline shots used	AK-47 W2r 24 kills with the AK-47	Akimbo Assassin Imot 16 kills with Dual Pistols	Ammo Saver squatvia_pug abtobusa 20 kills with Pistol	Automation Baros 17 kills with Auto Shotgun
AWP No Award Winner 0 kills with awp	BANG Headshot. No Award Winner 0 kills with the Frying Pan	Barf Bagged No Award Winner 0 vomited on Survivors	Batter Up! No Award Winner 0 kills with the Baseball Bat	Black Scottish Psyclops squatvia_pug abtobusa 12 kills with the Grenade Launcher
Boom! No Award Winner 0 kills with Boomer's Claws	Brain Salad altan 34 headshot kills	Bumrush Thwarter squatvia_pug abtobusa 2 killed Chargers	Burger Tank No Award Winner 0 kills with Tank's Claws	Chain Smoker No Award Winner 0 kills with Smoker's Claws
Cheerio. No Award Winner 0 kills with the Cricket Bat	Chrome Shotgun altan 10 kills with the Chrome Shotgun	Combat Rifle squatvia_pug abtobusa 4 kills with the Combat Rifle	Combat Shotgun Radašin iz Petlovac 15 kills with the Combat Shotgun	Commando OptimusBlyat 21 kills with M16 Assault Rifle
Crowbar No Award Winner 0 kills with the Crowbar	Dead Wreckening No Award Winner 0 downed Survivors	Dr. Shocker No Award Winner 0 teammates defibrillated	Drag & Drop No Award Winner 0 constricted Survivors	Field Medic No Award Winner 0 healed Survivors
Fight fire with an axe No Award Winner 0 kills with the Fireaxe	Fists of RAGGEE sunge 27 melee kills	Free to Fly No Award Winner 0 pounced Survivors	GET OFF MY LAWN No Award Winner 0 gnome smash kills	Going for a ride! No Award Winner 0 jockey rides
Golf Club No Award Winner 0 kills with the Golf Club	Green can't be healthy.. No Award Winner 0 tank bilebombs	Ground Cover No Award Winner 0 rescued Survivors	Hawk Eye squatvia_pug abtobusa 34 kills with Hunting Rifle	Helping Hand No Award Winner 0 revived Survivors
Hi Dr. Nick! No Award Winner 0 kills with a First Aid Kit	Hulk Smash! No Award Winner 0 pummelings as a charger	Hunter Punter OptimusBlyat 1 killed Hunters	Hunter Punter squatvia_pug abtobusa 2 killed Jockeys	Hunter Punter No Award Winner 0 hunter punts
Inquisitor Radašin iz Petlovac 1 killed Witches	Katana No Award Winner 0 kills with the Katana	Knife No Award Winner 0 kills with the Knife	Little Man Claws No Award Winner 0 kills with Jockey's Claws	Lowest Ping sunge 28 ms average connection
M60 altan 6 kills with M60	Machete No Award Winner 0 kills with the Machete	Magnum squatvia_pug abtobusa 106 kills with the Magnum	MP5 Navy altan 12 kills with mp5	No One Left Behind No Award Winner 0 kills with Mounted Machine Gun
No Smoking Section OptimusBlyat 1 killed Smokers	Open Season No Award Winner 0 kills with Hunter's Claws	Protector No Award Winner 0 hunter punts	Pump It! Panda Poo 24 kills with Pump Shotgun	Pyromaniac sunge 51 cremated Infected
Pyrotechnician Panda Poo 23 blown up Infected	Rock Star No Award Winner 0 kills with Tank's Rock	Safety First Marques 26 kills with Uzi	Scout Elite No Award Winner 0 kills with scout	SG 552 BlueNIGGAZ 11 kills with sg552
Slice and Dice No Award Winner 0 kills with the Chainsaw	Snap Crackle Pop No Award Winner 0 kills with fire crackers	Sniper Rifle No Award Winner 0 kills with the Sniper Rifle	Spit shine No Award Winner 0 spitter acid attacks	Spittle Splatter squatvia_pug abtobusa 2 Spitters Splated
Stomach Upset altan 4 killed Boomers	TAAN... What is this?! No Award Winner 0 kills with Charger's Claws	Tankbuster No Award Winner 0 killed Tanks	Those nails could kill No Award Winner 0 kills with Spitter's Claws	Tonfa No Award Winner 0 kills with the Tonfa
Uzi (Silenced) Radašin iz Petlovac 30 kills with the Uzi (silenced)	Wayne's world party on! No Award Winner 0 kills with the Electric Guitar

ERROR

Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlstatsx.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='l4d2'
		GROUP BY
			rankName,
			minKills