HLStatsX | The Black Market - Left 4 Dead 2

Daily Awards (Thursday 26 May)

Adrenaline Junkie Ze̸rø T̷w̸͙̽ø™★ 2 adrenaline shots used	AK-47 iha19 296 kills with the AK-47	Akimbo Assassin pacoeltaco 37 kills with Dual Pistols	Ammo Saver Desshomaru 52 kills with Pistol	Automation Desshomaru 91 kills with Auto Shotgun
AWP WinterMint15195 44 kills with awp	BANG Headshot. No Award Winner 0 kills with the Frying Pan	Barf Bagged ★★ BLU3ST4R ★★ 15 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 pacoeltaco 72 headshot kills	Bumrush Thwarter ★★ BLU3ST4R ★★ 8 killed Chargers	Burger Tank Ze̸rø T̷w̸͙̽ø™★ 4 kills with Tank's Claws	Chain Smoker EternalParadox 1 kills with Smoker's Claws
Cheerio. No Award Winner 0 kills with the Cricket Bat	Chrome Shotgun *Luis Miguel* 109 kills with the Chrome Shotgun	Combat Rifle WinterMint15195 153 kills with the Combat Rifle	Combat Shotgun WinterMint15195 228 kills with the Combat Shotgun	Commando Desshomaru 45 kills with M16 Assault Rifle
Crowbar iha19 37 kills with the Crowbar	Dead Wreckening Ze̸rø T̷w̸͙̽ø™★ 13 downed Survivors	Dr. Shocker No Award Winner 0 teammates defibrillated	Drag & Drop Ze̸rø T̷w̸͙̽ø™★ 10 constricted Survivors	Field Medic pacoeltaco 2 healed Survivors
Fight fire with an axe SinInsultosPlox 71 kills with the Fireaxe	Fists of RAGGEE No Award Winner 0 melee kills	Free to Fly Ze̸rø T̷w̸͙̽ø™★ 7 pounced Survivors	GET OFF MY LAWN No Award Winner 0 gnome smash kills	Going for a ride! Ze̸rø T̷w̸͙̽ø™★ 8 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 iha19 113 kills with Hunting Rifle	Helping Hand EternalParadox 6 revived Survivors
Hi Dr. Nick! EternalParadox 1 kills with a First Aid Kit	Hulk Smash! Ze̸rø T̷w̸͙̽ø™★ 6 pummelings as a charger	Hunter Punter Ze̸rø T̷w̸͙̽ø™★ 9 killed Hunters	Hunter Punter Ze̸rø T̷w̸͙̽ø™★ 10 killed Jockeys	Hunter Punter *Luis Miguel* 3 hunter punts
Inquisitor WinterMint15195 3 killed Witches	Katana WinterMint15195 52 kills with the Katana	Knife iha19 24 kills with the Knife	Little Man Claws ★★ BLU3ST4R ★★ 2 kills with Jockey's Claws	Lowest Ping Desshomaru 49 ms average connection
M60 No Award Winner 0 kills with M60	Machete No Award Winner 0 kills with the Machete	Magnum DieGallo 1 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 Ze̸rø T̷w̸͙̽ø™★ 12 killed Smokers	Open Season Ze̸rø T̷w̸͙̽ø™★ 1 kills with Hunter's Claws	Protector iha19 132 hunter punts	Pump It! Tetsuky McFly 8 kills with Pump Shotgun	Pyromaniac iha19 38 cremated Infected
Pyrotechnician iha19 30 blown up Infected	Rock Star Ze̸rø T̷w̸͙̽ø™★ 1 kills with Tank's Rock	Safety First pacoeltaco 42 kills with Uzi	Scout Elite No Award Winner 0 kills with scout	SG 552 No Award Winner 0 kills with sg552
Slice and Dice LaQuesadilla 46 kills with the Chainsaw	Snap Crackle Pop WinterMint15195 17 kills with fire crackers	Sniper Rifle Fîdêl RDZ 103 kills with the Sniper Rifle	Spit shine No Award Winner 0 spitter acid attacks	Spittle Splatter Ze̸rø T̷w̸͙̽ø™★ 10 Spitters Splated
Stomach Upset Ze̸rø T̷w̸͙̽ø™★ 18 killed Boomers	TAAN... What is this?! Ze̸rø T̷w̸͙̽ø™★ 2 kills with Charger's Claws	Tankbuster iha19 3 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) Ze̸rø T̷w̸͙̽ø™★ 143 kills with the Uzi (silenced)	Wayne's world party on! EternalParadox 36 kills with the Electric Guitar

Global Awards

Adrenaline Junkie Iforgot42 9 adrenaline shots used	AK-47 E_PlusOne 316 kills with the AK-47	Akimbo Assassin KekoXD 48 kills with Dual Pistols	Ammo Saver Desshomaru 52 kills with Pistol	Automation Desshomaru 143 kills with Auto Shotgun
AWP VIPER 111 kills with awp	BANG Headshot. André-Pierre Gignac 24 kills with the Frying Pan	Barf Bagged Albedo Kenshin Nyuu 36 vomited on Survivors	Batter Up! Genio 75 kills with the Baseball Bat	Black Scottish Psyclops imagepicman 491 kills with the Grenade Launcher
Boom! Profesor Utonio 1 kills with Boomer's Claws	Brain Salad pacoeltaco 72 headshot kills	Bumrush Thwarter Profesor Utonio 20 killed Chargers	Burger Tank R_Williams 8 kills with Tank's Claws	Chain Smoker Variable 3 kills with Smoker's Claws
Cheerio. Sarventa 15 kills with the Cricket Bat	Chrome Shotgun Naͣya. 214 kills with the Chrome Shotgun	Combat Rifle El Alcalde 157 kills with the Combat Rifle	Combat Shotgun WinterMint15195 228 kills with the Combat Shotgun	Commando Josh 120 kills with M16 Assault Rifle
Crowbar mercuryruiz12 52 kills with the Crowbar	Dead Wreckening Profesor Utonio 20 downed Survivors	Dr. Shocker elecтυѕ 1 teammates defibrillated	Drag & Drop El Alcalde 16 constricted Survivors	Field Medic VIPER 6 healed Survivors
Fight fire with an axe Albedo Kenshin Nyuu 108 kills with the Fireaxe	Fists of RAGGEE No Award Winner 0 melee kills	Free to Fly Albedo Kenshin Nyuu 14 pounced Survivors	GET OFF MY LAWN No Award Winner 0 gnome smash kills	Going for a ride! Albedo Kenshin Nyuu 15 jockey rides
Golf Club /-$ 80 kills with the Golf Club	Green can't be healthy.. elecтυѕ 1 tank bilebombs	Ground Cover Iforgot42 1 rescued Survivors	Hawk Eye R_Williams 128 kills with Hunting Rifle	Helping Hand IISlayerII 11 revived Survivors
Hi Dr. Nick! PacoGTR 1 kills with a First Aid Kit	Hulk Smash! Albedo Kenshin Nyuu 14 pummelings as a charger	Hunter Punter elecтυѕ 18 killed Hunters	Hunter Punter E_PlusOne 16 killed Jockeys	Hunter Punter まふまふ 9 hunter punts
Inquisitor PERRO-TOXICO 5 killed Witches	Katana Levi 99 kills with the Katana	Knife iha19 24 kills with the Knife	Little Man Claws MeatBallz 3 kills with Jockey's Claws	Lowest Ping Player Slot Available 37 ms average connection
M60 elecтυѕ 16 kills with M60	Machete FPG majneto 46 kills with the Machete	Magnum Genio 96 kills with the Magnum	MP5 Navy El Alcalde 86 kills with mp5	No One Left Behind No Award Winner 0 kills with Mounted Machine Gun
No Smoking Section Profesor Utonio 24 killed Smokers	Open Season Profesor Utonio 6 kills with Hunter's Claws	Protector Meriyein 146 hunter punts	Pump It! ✯あおき✯ 130 kills with Pump Shotgun	Pyromaniac Zar 77 cremated Infected
Pyrotechnician elecтυѕ 67 blown up Infected	Rock Star Zar 2 kills with Tank's Rock	Safety First Meriyein 76 kills with Uzi	Scout Elite Genio 75 kills with scout	SG 552 09 KHK 42 kills with sg552
Slice and Dice AshKitt 48 kills with the Chainsaw	Snap Crackle Pop WinterMint15195 17 kills with fire crackers	Sniper Rifle lLlLlLlL 189 kills with the Sniper Rifle	Spit shine No Award Winner 0 spitter acid attacks	Spittle Splatter Profesor Utonio 18 Spitters Splated
Stomach Upset Profesor Utonio 26 killed Boomers	TAAN... What is this?! Albedo Kenshin Nyuu 5 kills with Charger's Claws	Tankbuster Naͣya. 4 killed Tanks	Those nails could kill elecтυѕ 1 kills with Spitter's Claws	Tonfa Nevets1992 29 kills with the Tonfa
Uzi (Silenced) 09 KHK 174 kills with the Uzi (silenced)	Wayne's world party on! CastleHearth 70 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