HLstatsX Community Edition

  Daily Awards (Tuesday 18 Aug)

AK47

ak47

No Award Winner
0 kills with ak47
AWP

awp

No Award Winner
0 kills with awp
Best Latency

latency

No Award Winner
0 ms average connection
Colt M4A1 Carbine

m4a1

No Award Winner
0 kills with m4a1
Desert Eagle

deagle

No Award Winner
0 kills with deagle
Dual Berretta Elites

elite

No Award Winner
0 kills with elite
Five Seven

fiveseven

No Award Winner
0 kills with fiveseven
Fusil Automatique

famas

No Award Winner
0 kills with famas
G3 SG1

g3sg1

No Award Winner
0 kills with g3sg1
Galil

galil

No Award Winner
0 kills with galil
Glock

glock

No Award Winner
0 kills with glock
Headshot King

headshot

No Award Winner
0 shots in the head
Knife Maniac

knife

No Award Winner
0 knifings
M3 Shotgun

m3

No Award Winner
0 kills with m3 shotgun
Mac 10

mac10

No Award Winner
0 kills with mac10
Most Kills

mostkills

No Award Winner
0 kills
Most Valuable Player

round_mvp

No Award Winner
0 times earning Round MVP
MP5 Navy

mp5navy

No Award Winner
0 kills with mp5
P 228

p228

No Award Winner
0 kills with p228
P 90

p90

No Award Winner
0 kills with p90
Para

m249

No Award Winner
0 kills with m249
Scout Elite

scout

No Award Winner
0 kills with scout
SG 550

sg550

No Award Winner
0 kills with sg550
SG 552

sg552

No Award Winner
0 kills with sg552
Steyr Aug

aug

No Award Winner
0 kills with aug
Suicides

suicide

No Award Winner
0 suicides
Team Killer

teamkills

No Award Winner
0 team kills
TMP

tmp

No Award Winner
0 kills with tmp
Top Defuser

Defused_The_Bomb

No Award Winner
0 bomb defusions
Top Demolitionist

Planted_The_Bomb

No Award Winner
0 bomb plantings
Top grenadier

hegrenade

No Award Winner
0 kills with grenade
Top Hostage Killer

Killed_A_Hostage

No Award Winner
0 hostages killed
Top Hostage Rescuer

Rescued_A_Hostage

No Award Winner
0 hostages rescued
UMP 45

ump45

No Award Winner
0 kills with ump45
USP Master

usp

No Award Winner
0 kills with usp
XM automatic Shotgun

xm1014

No Award Winner
0 kills with xm1014
    
  Global Awards

AK47

ak47

United Kingdom   camwil
6 kills with ak47
AWP

awp

Finland   Calig
19 kills with awp
Best Latency

latency

Russia   Дай дыхания
65 ms average connection
Colt M4A1 Carbine

m4a1

Hashemite Kingdom of Jordan   B1
8 kills with m4a1
Desert Eagle

deagle

Hashemite Kingdom of Jordan   B1
12 kills with deagle
Dual Berretta Elites

elite

Hashemite Kingdom of Jordan   B1
3 kills with elite
Five Seven

fiveseven

No Award Winner
0 kills with fiveseven
Fusil Automatique

famas

United Kingdom   camwil
6 kills with famas
G3 SG1

g3sg1

Sweden   tAP
2 kills with g3sg1
Galil

galil

Russia   XAM
1 kills with galil
Glock

glock

United Arab Emirates   | kEMOSABE |
5 kills with glock
Headshot King

headshot

Hashemite Kingdom of Jordan   B1
68 shots in the head
Knife Maniac

knife

Finland   Calig
32 knifings
M3 Shotgun

m3

Finland   Calig
24 kills with m3 shotgun
Mac 10

mac10

United Arab Emirates   | kEMOSABE |
8 kills with mac10
Most Kills

mostkills

Pakistan   renko
328 kills
Most Valuable Player

round_mvp

United Arab Emirates   | kEMOSABE |
34 times earning Round MVP
MP5 Navy

mp5navy

Belgium   Red.
8 kills with mp5
P 228

p228

Denmark   Heinz
3 kills with p228
P 90

p90

Greece   Sinagrida
35 kills with p90
Para

m249

Finland   Calig
12 kills with m249
Scout Elite

scout

Hashemite Kingdom of Jordan   B1
9 kills with scout
SG 550

sg550

Russia   aic
3 kills with sg550
SG 552

sg552

Sweden   tAP
1 kills with sg552
Steyr Aug

aug

Hashemite Kingdom of Jordan   B1
5 kills with aug
Suicides

suicide

Pakistan   renko
688 suicides
Team Killer

teamkills

Morocco   DOC™
1 team kills
TMP

tmp

United Kingdom   camwil
5 kills with tmp
Top Defuser

Defused_The_Bomb

No Award Winner
0 bomb defusions
Top Demolitionist

Planted_The_Bomb

No Award Winner
0 bomb plantings
Top grenadier

hegrenade

Greece   Sinagrida
8 kills with grenade
Top Hostage Killer

Killed_A_Hostage

No Award Winner
0 hostages killed
Top Hostage Rescuer

Rescued_A_Hostage

No Award Winner
0 hostages rescued
UMP 45

ump45

United Kingdom   camwil
3 kills with ump45
USP Master

usp

United Kingdom   camwil
4 kills with usp
XM automatic Shotgun

xm1014

Russia   Я мусулман
2 kills with xm1014
    
ERROR
Database Error

Server Address: 10.0.0.3
Server Username: web

Error Diagnostic:
Bad query.

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