Clan Information| Statistics Summary | ||
| Clan: | XA | |
| Home Page: | ||
| Activity: |
|
73.12% |
| Members: | 8 active members (15 total) | |
| Avg. Member Points: | 1,000 | |
| Total Kills: | 0 | |
| Total Deaths: | 0 | |
| Avg. Kills: | 0 | |
| Kills per Death: | - | |
| Kills per Minute: | 0.00 | |
| Total Connection Time: | 0d 03:03:10h | |
| Avg. Connection Time: | 0d 00:22:53h | |
| Favorite Server:* | Clanxa.com Xtreme Assassins Standard 2 | |
| Favorite Map:* | scoutzknivez | |
| Favorite Weapon:* | ||
| Player Locations | ||
Members| Rank | Name | Rank | Points | Activity | Time | Kills | Clan Kills | % | Deaths  |
Kpd |
| 1 |  =XA= AnGrY StEvE |
 |
1,000 | 0d 01:10:55h | 0 | 0.00% | 0 | 0.00 | ||
| 2 | =XA= Chuck |
|
1,000 | 0d 00:02:43h | 0 | 0.00% | 0 | 0.00 | ||
| 3 |  =XA= A$$-KicKeR |
|
1,000 | 0d 00:25:32h | 0 | 0.00% | 0 | 0.00 | ||
| 4 | =XA= R3D5K!N$ |
|
1,000 | 0d 00:22:25h | 0 | 0.00% | 0 | 0.00 | ||
| 5 | =XA= sig |
|
1,000 | 0d 00:14:11h | 0 | 0.00% | 0 | 0.00 | ||
| 6 | =XA=bmwsalesman |
|
1,000 | 0d 00:08:41h | 0 | 0.00% | 0 | 0.00 | ||
| 7 |  =XA= :GreenPeace |
|
1,000 | 0d 00:00:40h | 0 | 0.00% | 0 | 0.00 | ||
| 8 | =XA= cobbMySalad |
|
1,000 | 0d 00:38:03h | 0 | 0.00% | 0 | 0.00 |
| ERROR |
| Database Error Server Address: localhost Server Username: clannet_stats Error Diagnostic: Bad query. Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'clannet_stats.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(0 = 0, 1, 0) * 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='csp' AND hlstats_Players.clan=147 AND (hidden <>'1' OR hidden IS NULL) AND hlstats_Roles.game = 'csp' GROUP BY hlstats_Events_ChangeRole.role ORDER BY rolecount desc, name desc |