Kotelna - Dust2 only - Clan Details - SETB

Sections

Clan Information

Statistics Summary
Clan:	SETB
Home Page:
Activity:		51.03%
Members:	33 active members (632 total)
Avg. Member Points:	1,059
Total Kills:	355
Total Deaths:	826
Avg. Kills:	11
Kills per Death:	0.43
Kills per Minute:	0.20
Total Connection Time:	1d 06:12:01h
Avg. Connection Time:	0d 00:54:54h
Favorite Server:*	csko.cz \| dust2 only
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	SETB \| Klaudy	1,281		0d 02:32:32h	37		10.42%	64	0.58
2	SETB \| Laci_Majer	1,261		0d 03:08:17h	28		7.89%	104	0.27
3	SETB \| Gigga Nigga	1,218		0d 02:18:07h	41		11.55%	83	0.49
4	SETB \| DENGEL	1,146		0d 00:41:25h	29		8.17%	25	1.16
5	SETB \| ja ti dam>:D	1,142		0d 05:45:24h	33		9.30%	140	0.24
6	SETB \| skoricovy_trdelnik	1,127		0d 01:18:31h	20		5.63%	33	0.61
7	SETB \| Martin Looter Kling	1,102		0d 01:15:51h	14		3.94%	31	0.45
8	SETB \| kadet BOHUMIL Kulomet	1,099		0d 00:41:56h	23		6.48%	24	0.96
9	SETB \| [SuperBOOST]CS-DOWNLOAD	1,091		0d 00:38:17h	17		4.79%	21	0.81
10	SETB \| dedo kexo :D	1,090		0d 01:43:24h	22		6.20%	34	0.65
11	SETB \| jecte jogurty	1,073		0d 00:36:41h	10		2.82%	22	0.45
12	SETB \| jasemgrut	1,071		0d 04:08:59h	23		6.48%	59	0.39
13	SETB \| gamedoctor46	1,052		0d 01:51:07h	8		2.25%	72	0.11
14	SETB \| Borovicka	1,050		0d 00:08:57h	2		0.56%	7	0.29
15	SETB \| Velky slonu curak BIMBO	1,037		0d 00:43:59h	13		3.66%	24	0.54
16	SETB \| MINCO30	1,035		0d 00:16:48h	6		1.69%	9	0.67
17	SETB \| NEGR1337	1,019		0d 00:06:02h	6		1.69%	4	1.50
18	SETB \| seruNato	1,019		0d 00:22:48h	3		0.85%	12	0.25
19	SETB \| erikjenej	1,013		0d 00:27:14h	7		1.97%	18	0.39
20	SETB \| Albertyno	1,010		0d 00:04:31h	1		0.28%	3	0.33

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Spawn with the Bomb	71 times	142
2	Headshot	65 times	65
3	Drop the Bomb	52 times	-104
4	Double Kill (2 kills)	28 times	28
5	Plant the Bomb	26 times	390
6	Pick up the Bomb	24 times	48
7	Triple Kill (3 kills)	4 times	8
8	Start Defusing the Bomb With a Defuse Kit	4 times	0
9	Defuse the Bomb	4 times	60
10	Domination (4 kills)	2 times	6
11	Start Defusing the Bomb Without a Defuse Kit	1 times	0

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	70 times		50.36%
2	Counter-Terrorist	64 times		46.04%

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