HLstatsX Community Edition
  • CSTRIKE
  • CSP
  • Contents
  • Search
  • Help

Banner
  Player Information

Player Profile

Steam Community Avatar
United States n3 | twitch.tv/Calexil
Location: Newark, United States
Steam: STEAM_0:0:63352256
Status: Offline
Click here to add as friend
Karma: In good standing
Member of Clan:  Calexil
Real Name: (Not Specified)
E-mail Address: (Not Specified)
Home Page: (Not Specified)
MM Rank: rank
Last Connect:* Wed. Apr. 10th, 2024 @ 21:47:51
Total Connection Time: 1d 01:18:46h
Average Ping:* 54 ms (Latency: 27 ms)
Favorite Server:* Clanxa.com Xtreme Assassins Standard
Favorite Map:* de_cpl_fire_32
Favorite Weapon:*
ERROR
Database Error

Server Address: localhost
Server Username: clannet_stats

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'clannet_stats.hlstats_Weapons.name' 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
									hlstats_Events_Frags.weapon,
									hlstats_Weapons.name,
									COUNT(hlstats_Events_Frags.weapon) AS kills,
									SUM(hlstats_Events_Frags.headshot=1) as headshots
								FROM
									hlstats_Events_Frags
								LEFT JOIN
									hlstats_Weapons
								ON
									hlstats_Weapons.code = hlstats_Events_Frags.weapon
								WHERE
									hlstats_Events_Frags.killerId=1196
								GROUP BY
									hlstats_Events_Frags.weapon
								ORDER BY
									kills desc, headshots desc
								LIMIT
									1