HLstatsX ~TAMBOV-WOLF~ - - Clan Details

Clan Information

Statistics Summary
Clan:
Home Page:
Activity:		75.00%
Members:	1 active members (1 total)
Avg. Member Points:	8,778
Total Kills:	2,021
Total Deaths:	2,292
Avg. Kills:	2,021
Kills per Death:	0.88
Kills per Minute:	0.54
Total Connection Time:	2d 14:55:41h
Avg. Connection Time:	2d 14:55:41h
Favorite Server:*	~TAMBOFF-WOLF [NIGHT VIP] PUBLIC NOSTEAM~
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	☆☆☆CARAMBA☆☆☆		8,778		2d 14:55:41h	2,021		100.00%	2,292	0.88

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Pick up the Bomb	10 times	20
2	Headshot	10 times	10
3	Drop the Bomb	4 times	-8
4	Triple Kill (3 kills)	2 times	4
5	Round MVP	2 times	0
6	Plant the Bomb	2 times	20

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1	Ak47	165	14	930	7	8	8.0000	8.5%	66.4	20.6
2	Deagle	13	2	144	1	2	2.0000	15.4%	72.0	6.5
3	Glock	6	1	40	1	1	1.0000	16.7%	40.0	6.0
4	M4a1	1	1	22	0	0	0.0000	100.0%	22.0	0.0
5	Knife	1	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1	Ak47	14	28.6%	71.4%	0.0%
2	Deagle	2	0.0%	100.0%	0.0%
3	M4a1	1	0.0%	100.0%	0.0%
4	Glock	1	0.0%	100.0%	0.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: 192.168.1.189
Server Username: hlstatsxce

Error Diagnostic:
Bad query.

Server Error: (1052) Column 'map' in order clause is ambiguous

Last SQL Query:

		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 2021 * 100, 2) AS kpercent,
			ROUND(headshots / 1154 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc