Kotelna - Deathmatch - Clan Details - SETB

Sections

Clan Information

Statistics Summary
Clan:	SETB
Home Page:
Activity:		67.52%
Members:	59 active members (405 total)
Avg. Member Points:	1,102
Total Kills:	2,962
Total Deaths:	3,037
Avg. Kills:	50
Kills per Death:	0.98
Kills per Minute:	0.79
Total Connection Time:	2d 14:27:46h
Avg. Connection Time:	0d 01:03:31h
Favorite Server:*	csko.cz \| Deathmatch
Favorite Map:*	de_dust
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	SETB \| Spawn	5,928		1d 07:24:11h	2,026		68.40%	1,934	1.05
2	SETB \| RENE RENDY	1,889		0d 03:23:29h	264		8.91%	228	1.16
3	SETB \| Mk	1,190		0d 04:44:39h	90		3.04%	88	1.02
4	SETB \| paliss	1,168		0d 00:53:24h	75		2.53%	73	1.03
5	SETB \| Sumik	1,036		0d 00:26:19h	38		1.28%	33	1.15
6	SETB \| Ayem	1,032		0d 00:48:04h	44		1.49%	46	0.96
7	SETB \| Pipinka na smotane	1,031		0d 00:10:18h	19		0.64%	11	1.73
8	SETB \| ferko	1,024		0d 00:17:34h	19		0.64%	18	1.06
9	SETB \| Majkoss	1,021		0d 01:01:21h	28		0.95%	30	0.93
10	SETB \| --MASSAMIKILL--	1,019		0d 00:20:34h	15		0.51%	13	1.15
11	SETB \| PAMPALINY	1,013		0d 00:14:37h	27		0.91%	27	1.00
12	SETB \| Greenhorne	1,011		0d 00:39:34h	52		1.76%	77	0.68
13	SETB \| Logofon36	1,008		0d 00:35:22h	13		0.44%	14	0.93
14	SETB \| samuelxqpz	1,007		0d 00:16:23h	11		0.37%	13	0.85
15	SETB \| DRUCUS	1,003		0d 00:05:23h	2		0.07%	1	2.00
16	SETB \| Pipinka	1,003		0d 00:10:13h	2		0.07%	1	2.00
17	SETB \| MATE STESTI ZE JDU KOLEM	1,003		0d 04:24:15h	19		0.64%	22	0.86
18	SETB \| Luhoo11	1,001		0d 00:34:54h	8		0.27%	11	0.73
19	SETB \| TescoMeetMan	1,000		0d 00:03:45h	2		0.07%	3	0.67
20	SETB \| Sofri_AK47_PELE	1,000		0d 00:01:01h	0		0.00%	0	0.00

Page: 1 2 3

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	445 times	445
2	Double Kill (2 kills)	225 times	225
3	Triple Kill (3 kills)	87 times	174
4	Domination (4 kills)	52 times	156
5	Rampage (5 kills)	23 times	92
6	Mega Kill (6 kills)	14 times	70
7	Ultra Kill (8 kills)	5 times	35
8	Ownage (7 kills)	3 times	18
9	Monster Kill (10 kills)	3 times	27
10	Killing Spree (9 kills)	2 times	16
11	Unstoppable (11 kills)	1 times	10
12	God Like (12+ kills)	1 times	11

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	107 times		50.95%
2	Terrorist	100 times		47.62%

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=680858
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dm'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc