Loco's Looney HLStatsX Toons - Left 4 Dead 2 - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	GB
Home Page:
Activity:		28.33%
Members:	18 active members (196 total)
Avg. Member Points:	2,492
Total Kills:	11,233
Total Deaths:	78
Avg. Kills:	624
Kills per Death:	144.01
Kills per Minute:	8.39
Total Connection Time:	0d 22:19:11h
Avg. Connection Time:	0d 01:14:23h
Favorite Server:*	Locos Looney Toons
Favorite Map:*	resort_map2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Lucky Bugger [GB]	15,470		0d 13:21:23h	6,273		55.84%	31	202.35
2	♥ Kuura ♥ [GB]	4,896		0d 02:16:48h	1,525		13.58%	9	169.44
3	the mushypea [GB]	3,191		0d 01:12:39h	858		7.64%	1	858.00
4	OridiusMorphius [GB]	2,744		0d 01:11:01h	720		6.41%	4	180.00
5	Digital Hipster [GB]	2,623		0d 00:53:46h	708		6.30%	5	141.60
6	SROYST [GB]	2,022		0d 00:57:31h	360		3.20%	9	40.00
7	Reanu Keeves [GB]	2,016		0d 00:57:31h	409		3.64%	9	45.44
8	Bra_tan_suka [GB]	1,383		0d 00:44:09h	201		1.79%	7	28.71
9	walmartshroud [GB]	1,365		0d 00:12:55h	140		1.25%	1	140.00
10	Soup [GB]	1,082		0d 00:09:41h	14		0.12%	1	14.00
11	imtherealsuda [GB]	1,032		0d 00:03:15h	13		0.12%	0	13.00
12	georgemulliss [GB]	1,028		0d 00:03:22h	12		0.11%	0	12.00
13	RevolutionSphere [GB]	1,000		0d 00:00:19h	0		0.00%	0	0.00
14	Aidhnio [GB]	1,000		0d 00:03:49h	0		0.00%	0	0.00
15	CRACK CORLEONE [GB]	1,000		0d 00:03:54h	0		0.00%	1	0.00
16	GliTcHeD V0iDz [GB]	1,000		0d 00:00:44h	0		0.00%	0	0.00
17	maclad [GB]	1,000		0d 00:00:52h	0		0.00%	0	0.00
18	austin [GB]	1,000		0d 00:05:32h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	526 times	1,578
2	Friendly Fire	213 times	-639
3	Protected Teammate	166 times	498
4	Revived Teammate	60 times	180
5	Killed a Spitter	59 times	177
6	Killed a Charger	59 times	177
7	Killed a Boomer	55 times	55
8	Killed a Smoker	52 times	104
9	Killed a Jockey	50 times	150
10	Killed a Hunter	50 times	100
11	Killed a Witch	33 times	165
12	Killed a Tank	26 times	104
13	Healed Teammate	18 times	90
14	Used Adrenaline	17 times	34
15	Startled the Witch	16 times	-80
16	Tank Bilebombed	7 times	35
17	Rescued Teammate	7 times	21
18	No Survivors Died/Incapped by Tank	7 times	7
19	Hunter Punter (Melee a Hunter Mid-jump)	5 times	25
20	Defibrillated Teammate	5 times	50

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	70 times		42.17%

ERROR

Database Error

Server Address: localhost
Server Username: gunnys

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gunnys.hlstats_Frags_as_res.killsTotal' 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
			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(28 = 0, 1, 28) * 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='l4d2'
			AND hlstats_Players.clan=652
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'l4d2'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc