HLStatsX | The Black Market - Left 4 Dead 2

Daily Awards (Saturday 3 Jun)

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 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

ERROR

Database Error

Server Address: 192.168.1.101
Server Username: motd

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'tbm_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