Sections
Player Information| Player Profile |
 |
|
 Distant Dreamer [US] |
||
| Location: Amarillo, United States | ||
| Steam: STEAM_0:0:634099256 | ||
| Status: Online | ||
| Click here to add as friend | ||
| Karma: In good standing | ||
| Member of Clan: | US | |
| Real Name: | (Not Specified) | |
| E-mail Address: | (Not Specified) | |
| Home Page: | (Not Specified) | |
| Last Connect:* | Sun. Sep. 13th, 2026 @ 19:13:22 | |
| Total Connection Time: | 0d 00:48:07h | |
| Average Ping:* | 41 ms (Latency: 21 ms) | |
| Favorite Server:* | Gunnys Hooch | |
| Favorite Map:* | cf_m3_evac | |
| Favorite Weapon:* |
| ERROR |
| Database Error Server Address: localhost Server Username: gunnys2 Error Diagnostic: Bad query. Server Error: (1055) Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gunnys2.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=94724 GROUP BY hlstats_Events_Frags.weapon ORDER BY kills desc, headshots desc LIMIT 1 |