Database error: Invalid SQL: SELECT sum( stats_player_kills.Kills) as TotalKills, stats_player_kills.PLAYERID FROM stats_player_kills WHERE stats_player_kills.ROUNDID=286186 AND stats_player_kills.PLAYERID IN (335784180, 784133087, 2315510570, 1653394089, 10895671, 2474190332, 388436921, ) AND stats_player_kills.PLAYERID NOT IN (3997358212, 1168882415, 3747034681, 2654015945, 20739507, 3055501901, 484760987, 2224737733, 4122156512, 3430206373) GROUP BY stats_player_kills.PLAYERID ORDER BY TotalKills DESC
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND stats_player_kills.PLAYERID NOT IN (3997358212, 1168882415, 3747034681,...' at line 1
mysql error number: 1064
Date: 02.01.2026 @ 00:43
Script: /rounds-detail.php?id=286186
Referer:
=SA= CoD4 Server statistics :: UltraStats :: Round Details for ID '286186'
 Select Server 
 
 Select Language 
 Select a Style 
 Skin made by  deltaray
Home Admin Center About UltraStats  
 
 Select time span 
 
 
 
 
Rounddetails for Round ID '286186'
Axis Axis Team Points

0

 Axis Allies Team Points

0
No. Name Kills/Deaths Ratio
1 UFO 55  18 
2 vick1 41  25 
3 DirtyRat=SA= 34  15 
4 BiT=SA= 26  34 
5 Happy 16  26 
6 bigpappa=SA= 14  34 
7 LoxopeD 2  6 
No. Name Kills/Deaths Ratio
Players who did not finish the round
No. Name Kills/Deaths Ratio No. Name Kills/Deaths Ratio
1 Thorlinger 47  30 
2 VirtualRat 39  29 
3 {ESC}NewYrPony 33  30 
4 ToroCro 30  30 
5 SuicideSam=SA= 29  34 
6 CptLuder=SA= 26  29 
7 Tina =SA= 26  25 
8 [-|DeD|-]IndO 21  28 
9 Why_Me 20  26 
10 MajorYahoo 19  30 
11 Raptor 9  21 
12 Brother*Lusio 9  17 
13 martin-dk 4  12 
14 Deymh 2  3 
15 BADDger 0  0 
 
Round Awards
Most Kills
{PLAYER_FinalMapDisplayName}
UFO
Kills: 55
Most Deaths
{PLAYER_FinalMapDisplayName}
BiT=SA=
Deaths: 34
Round Summary
Played Map
Gametype Freeze Tag
Date/Time played at 2026-01-01 22:24:08
Played 00:43:47

Round Actions
AC130 launched Name Count
-Topalias unknown- 1 
Airstrike launched Name Count
-Topalias unknown- 5 
Artillery launched Name Count
-Topalias unknown- 2 
Helicopter launched Name Count
-Topalias unknown- 1 
Counter UAV launched Name Count
-Topalias unknown- 1 
Predator launched Name Count
-Topalias unknown- 1 
UAV activated Name Count
-Topalias unknown- 1 
Car activated Name Count
-Topalias unknown- 37 
Sentrygun called Name Count
-Topalias unknown- 6 
Smartbomb launched Name Count
-Topalias unknown- 1 
 

Chatlog of this Round


Created 2005-2008 - By deltaray  Support Forums |  Ultrastats Version 0.3.16  Sponsors: CallOfDuty: World at War was made by Treyarch and published by Activision  
Page rendered in: 0.0265 seconds  | DB queries: 22  | GZIP enabled: yes  | Script Timeout: 60 seconds