<body>
<table cellspacing=0 border=0 class=style4>
<table align=left cellspacing=1 border=0 class=style4>
<tr>	
<th height=35px width=15px>#</th>
<th width=200px>Location</th>
<th width=100px>Kills</th>
</tr>
$$loop row as stat index as statindex select count(*) as killcount,id,targetlocation,realname,image,(select count(*) from killdata as subkilldata where killdata.targetlocation=subkilldata.targetlocation and killtype='SUICIDE') as suicidecount,(select count(*) from killdata as subkilldata where killdata.targetlocation=subkilldata.targetlocation and killtype='TEAMKILL') as teamkillcount from killdata,location where killtype='KILL' and location.idx=killdata.targetlocation group by targetlocation order by killcount desc limit %%MAXMAINPAGELOCATIONS%%$$
<tr>
<th id="ignore" height=27px align=center>$$statindex$$</th>
<td align=center onmouseover = "doButtons('locations/$$stat.image$$')" onmouseout = "doButtons('locations/player.jpg', 'locations/player.jpg')"><b>$$stat.realname$$</b></td>
<td id="ignore" align=center>$$stat.killcount$$</td>
</tr>
$$endloop stat$$
</table>
<table valign=center cellspacing=0 border=0 class=style5 width=250px>
<tr>
<td width=250px height=434px><img name=picture src="locations/player.jpg"></td>
</tr>
</table>
</table>
</body>

