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

Daily Awards (Saturday 31 May)

Adrenaline Junkie No Award Winner 0 adrenaline shots used	AK-47 No Award Winner 0 kills with the AK-47	Akimbo Assassin r1chardd_p 23 kills with Dual Pistols	Ammo Saver r1chardd_p 48 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 r1chardd_p 12 kills with the Grenade Launcher
Boom! No Award Winner 0 kills with Boomer's Claws	Brain Salad r1chardd_p 75 headshot kills	Bumrush Thwarter r1chardd_p 4 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 r1chardd_p 42 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 r1chardd_p 110 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 r1chardd_p 2 killed Hunters	Hunter Punter Gutalax 5 killed Jockeys	Hunter Punter No Award Winner 0 hunter punts
Inquisitor r1chardd_p 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 r1chardd_p 45 ms average connection
M60 No Award Winner 0 kills with M60	Machete No Award Winner 0 kills with the Machete	Magnum Gutalax 89 kills with the Magnum	MP5 Navy Gutalax 88 kills with mp5	No One Left Behind No Award Winner 0 kills with Mounted Machine Gun
No Smoking Section Gutalax 2 killed Smokers	Open Season No Award Winner 0 kills with Hunter's Claws	Protector No Award Winner 0 hunter punts	Pump It! r1chardd_p 20 kills with Pump Shotgun	Pyromaniac Gutalax 20 cremated Infected
Pyrotechnician Gutalax 26 blown up Infected	Rock Star No Award Winner 0 kills with Tank's Rock	Safety First Gutalax 57 kills with Uzi	Scout Elite No Award Winner 0 kills with scout	SG 552 Gutalax 14 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 r1chardd_p 4 Spitters Splated
Stomach Upset r1chardd_p 4 killed Boomers	TAAN... What is this?! No Award Winner 0 kills with Charger's Claws	Tankbuster Gutalax 1 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 Kitler 60 kills with the AK-47	Akimbo Assassin r1chardd_p 23 kills with Dual Pistols	Ammo Saver r1chardd_p 48 kills with Pistol	Automation No Award Winner 0 kills with Auto Shotgun
AWP Engineer Prime 7 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 Kitler 41 kills with the Grenade Launcher
Boom! No Award Winner 0 kills with Boomer's Claws	Brain Salad r1chardd_p 75 headshot kills	Bumrush Thwarter r1chardd_p 4 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 r1chardd_p 42 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 Peepo_Incognito 49 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 r1chardd_p 110 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 Kitler 2 killed Hunters	Hunter Punter Gutalax 5 killed Jockeys	Hunter Punter No Award Winner 0 hunter punts
Inquisitor r1chardd_p 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 Engineer Prime 39 ms average connection
M60 Kitler 52 kills with M60	Machete No Award Winner 0 kills with the Machete	Magnum Kitler 182 kills with the Magnum	MP5 Navy Gutalax 88 kills with mp5	No One Left Behind No Award Winner 0 kills with Mounted Machine Gun
No Smoking Section Peepo_Incognito 3 killed Smokers	Open Season No Award Winner 0 kills with Hunter's Claws	Protector No Award Winner 0 hunter punts	Pump It! r1chardd_p 20 kills with Pump Shotgun	Pyromaniac Gutalax 20 cremated Infected
Pyrotechnician Gutalax 26 blown up Infected	Rock Star No Award Winner 0 kills with Tank's Rock	Safety First Gutalax 57 kills with Uzi	Scout Elite No Award Winner 0 kills with scout	SG 552 Gutalax 14 kills with sg552
Slice and Dice Peepo_Incognito 27 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 r1chardd_p 4 Spitters Splated
Stomach Upset r1chardd_p 4 killed Boomers	TAAN... What is this?! No Award Winner 0 kills with Charger's Claws	Tankbuster Gutalax 1 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

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