$$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%%$$ $$endloop stat$$

#	Location	Kills
$$statindex$$	$$stat.realname$$	$$stat.killcount$$