$$loop row as awarddef index as awarddefindex select * from awarddefinition$$
	$$pointsrecorded="0"$$
	$$loop row as awardpoints index as awardpointsindex select count(*) from view_awardpoints where awardindex='%%awarddef.awardindex%%'$$
		$$pointsrecorded=awardpoints.0$$
	$$endloop awardpoints$$
	$$if (pointsrecorded !EQUALS "0")$$
		$$loop row as awardpoints index as awardpointsindex select sum(score) as awardscore,playername from view_awardpoints where awardindex='%%awarddef.awardindex%%' group by playerindex order by awardscore desc limit 1$$
			$$MessageCentre("AWARD%%awarddef.name%%",awardpoints.playername,awardpoints.awardscore)$$
		$$endloop awardpoints$$
	$$endif$$
$$endloop awarddef$$