<table cellspacing=1 border=0 class=style4>
<tr>
<th height=35px>#</th>	
<th>Totals</th>
<th width=80px>Kills</th>
<th width=60px>Suicides</th>
</tr>
$$loop row as stat index as statindex select count(*) as killcount,id,playerclass,realname,image,(select count(*) from killdata as subkilldata where killdata.playerclass=subkilldata.playerclass and killtype='SUICIDE') as suicidecount,(select count(*) from killdata as subkilldata where killdata.playerclass=subkilldata.playerclass and killtype='TEAMKILL') as teamkillcount from killdata,class where killtype='KILL' and class.idx=killdata.playerclass group by playerclass order by killcount desc limit %%MAXMAINPAGECLASSES%%$$
<tr align=center>
<th width=15px>$$statindex$$</th>	
<td width=180px>
<b>Server</b>
</td>
<td>$$stat.killcount$$</td>
<td>$$stat.suicidecount$$</td>
</tr>
$$endloop stat$$
</table>


