<td valign=top>
<table align=center class=style2 border=0 cellspacing=1 width=350px>
<tr align=center>
<th>#</th>
<th>Location</th>
<th>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 playerindex='%%player.playerindex%%' and killdata.targetlocation=subkilldata.targetlocation and killtype='SUICIDE') as suicidecount,(select count(*) from killdata as subkilldata where playerindex='%%player.playerindex%%' and killdata.targetlocation=subkilldata.targetlocation and killtype='TEAMKILL') as teamkillcount from killdata,location where playerindex='%%player.playerindex%%' and killtype='KILL' and location.idx=killdata.targetlocation group by targetlocation order by killcount desc limit %%MAXMAINPAGELOCATIONS%%$$
<tr>
<th id="ignore" height=27px width=15px align=center>$$statindex$$</th>
<td align=center onmouseover = "doButtons('locations/$$stat.image$$')" onmouseout = "doButtons('locations/player.jpg', 'locations/player.jpg')" >
$$stat.realname$$
</td>
<td id="ignore" align=center>$$stat.killcount$$</td>
</tr>
$$endloop stat$$
</table>
</td>
<td valign=top>
<table align=center cellspacing=0 border=0 class=style5  width=350px>
<tr align=center>	
</tr>
<tr>	
<td><img name=picture src="locations/player.jpg"></td>
</tr>
</table>
</td>





