Player Information| Player Profile |
 |
|
 2agr0 |
||
| Location: Kansas City, United States | ||
| Steam: STEAM_0:1:12919496 | ||
| Status: Offline | ||
| Click here to add as friend | ||
| Karma: In good standing | ||
| Member of Clan: | (None) | |
| Real Name: | (Not Specified) | |
| E-mail Address: | (Not Specified) | |
| Home Page: | (Not Specified) | |
| MM Rank: |
 |
|
| Last Connect:* | Sat. Apr. 13th, 2024 @ 01:56:29 | |
| Total Connection Time: | 2d 08:15:20h | |
| Average Ping:* | 38 ms (Latency: 19 ms) | |
| Favorite Server:* | Clanxa.com Xtreme Assassins Standard | |
| Favorite Map:* | de_azteq | |
| 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=43 GROUP BY hlstats_Events_Frags.weapon ORDER BY kills desc, headshots desc LIMIT 1 |