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

Sections

Clan Information

Statistics Summary
Clan:	GB
Home Page:
Activity:		62.70%
Members:	27 active members (156 total)
Avg. Member Points:	1,750
Total Kills:	8,311
Total Deaths:	104
Avg. Kills:	308
Kills per Death:	79.91
Kills per Minute:	6.61
Total Connection Time:	0d 20:57:22h
Avg. Connection Time:	0d 00:46:34h
Favorite Server:*	Locos Looney Toons
Favorite Map:*	glubtastic4_1
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Lucky Bugger [GB]	10,048		0d 09:05:19h	3,812		45.87%	27	141.19
2	⦮ ⦯ [GB]	3,230		0d 02:01:33h	947		11.39%	2	473.50
3	Hypenotic93TTV [GB]	2,176		0d 01:15:49h	453		5.45%	4	113.25
4	Distemper [GB]	2,039		0d 00:37:39h	375		4.51%	1	375.00
5	M̸̳̦̅ᔑ [GB]	1,961		0d 00:43:49h	372		4.48%	8	46.50
6	FlamingLibrarian [GB]	1,931		0d 00:56:32h	329		3.96%	2	164.50
7	Ur [GB]	1,816		0d 01:14:04h	317		3.81%	3	105.67
8	sundaebb [GB]	1,799		0d 00:44:31h	321		3.86%	2	160.50
9	Raptor16 [GB]	1,751		0d 00:52:46h	318		3.83%	3	106.00
10	MowgiKiChaddi [GB]	1,748		0d 00:22:16h	301		3.62%	10	30.10
11	ceegee [GB]	1,598		0d 00:51:52h	242		2.91%	15	16.13
12	Jill Sandwich [GB]	1,489		0d 00:24:05h	204		2.45%	10	20.40
13	niallsimpkintyrell2 [GB]	1,273		0d 00:18:31h	117		1.41%	7	16.71
14	gsimpkin09 [GB]	1,204		0d 00:18:31h	115		1.38%	6	19.17
15	Luisgamercool23 fan [GB]	1,101		0d 00:05:00h	33		0.40%	0	33.00
16	Big Nev [GB]	1,076		0d 00:05:13h	26		0.31%	0	26.00
17	shadow22646 [GB]	1,047		0d 00:38:16h	21		0.25%	3	7.00
18	jawdrop [GB]	1,014		0d 00:05:10h	4		0.05%	0	4.00
19	keelan18 [GB]	1,007		0d 00:02:34h	2		0.02%	0	2.00
20	Asphaarr2024 [GB]	1,002		0d 00:00:36h	1		0.01%	0	1.00

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot Kill	533 times	1,599
2	Friendly Fire	249 times	-747
3	Protected Teammate	197 times	591
4	Revived Teammate	70 times	210
5	Killed a Spitter	50 times	150
6	Killed a Charger	49 times	147
7	Killed a Jockey	47 times	141
8	Killed a Boomer	47 times	47
9	Killed a Hunter	45 times	90
10	Killed a Smoker	42 times	84
11	Killed a Tank	30 times	120
12	Used Adrenaline	22 times	44
13	Startled the Witch	15 times	-75
14	Healed Teammate	8 times	40
15	Killed a Witch	7 times	35
16	Tank Bilebombed	5 times	25
17	Hunter Punter (Melee a Hunter Mid-jump)	4 times	20
18	Rescued Teammate	2 times	6
19	No Survivors Died/Incapped by Tank	2 times	2
20	Defibrillated Teammate	2 times	20

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Survivors	110 times		43.14%

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(49 = 0, 1, 49) * 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