Kotelna - Deathmatch - Clan Details - [GG.GoNexT] GG.GoNexT

Sections

Clan Information

Statistics Summary
Clan:	GG.GoNexT
Home Page:
Activity:		95.00%
Members:	1 active members (1 total)
Avg. Member Points:	1,002
Total Kills:	42
Total Deaths:	49
Avg. Kills:	42
Kills per Death:	0.86
Kills per Minute:	0.91
Total Connection Time:	0d 00:45:59h
Avg. Connection Time:	0d 00:45:59h
Favorite Server:*	csko.cz \| Deathmatch
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[GG.GoNexT]JLMA	1,002		0d 00:45:59h	42		100.00%	49	0.86

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	5 times	5
2	Triple Kill (3 kills)	4 times	8
3	Headshot	2 times	2
4	Domination (4 kills)	2 times	6

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	5 times		71.43%
2	Terrorist	2 times		28.57%

ERROR

Database Error

Server Address: 192.168.1.22:3306
Server Username: webik

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8_czech_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Last SQL Query:

		SELECT
			IFNULL(hlstats_Roles.name, hlstats_Events_ChangeRole.role) AS name,
			IFNULL(hlstats_Roles.code, hlstats_Events_ChangeRole.role) AS code,
			COUNT(hlstats_Events_ChangeRole.id) AS rolecount,
			ROUND(COUNT(hlstats_Events_ChangeRole.id) / IF(0 = 0, 1, 0) * 100, 2) AS percent,
			killsTotal,
			deathsTotal,
			ROUND(killsTotal/if(deathsTotal=0,1,deathsTotal), 2) AS kpd
		FROM
			hlstats_Events_ChangeRole
		LEFT JOIN
			hlstats_Roles
		ON
			hlstats_Events_ChangeRole.role = hlstats_Roles.code
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_ChangeRole.serverId
		LEFT JOIN
			hlstats_Frags_as_res
		ON
			hlstats_Frags_as_res.role = hlstats_Events_ChangeRole.role
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId = hlstats_Events_ChangeRole.playerId
		WHERE
			hlstats_Servers.game='dm'
			AND hlstats_Players.clan=688027
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dm'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc