Clay Target

LEADERBOARD

Below is the leader board for this season. It is a overall review of award and acknowledgement. Season average tie scores are broken by Reserve Week Total. If the athletes tie after that point they both win an award for that place.
Athletes are required to participate in all competition weeks to qualify.

Overall Individual High Average.

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 KEAGLE BEAU Hibbing Community College 24.90 48

Blue Division

Clay Target Season Division Team Standings

Place Team Name Team Total
1 Northland Community & Technical College 298.50
2 Dakota College at Bottineau 277.50

Mens’s Division, Clay Target Season Individual

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 BRODERIUS WILL Dakota College at Bottineau 24.40 40
2 KOLAND ALEX Northland Community & Technical College 24.10 48
2 KEHOE TAYLOR Itasca Community College 24.10 46

Women’s Division, Clay Target Season Individual

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 YODER MONICA Dakota College at Bottineau 23.20 46
2 KASPRICK JORDYN Northland Community & Technical College 22.60 47
3 CHRISTIANSON NEVAEH Dakota College at Bottineau 20.90 42

Red Division

Clay Target Season Division Team Standings

Place Team Name Team Total
1 Southwest Wisconsin Technical College 2,544.00
2 Lake Superior College 2,129.50

Mens’s Division, Clay Target Season Individual

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 LEE BRODY Southwest Wisconsin Technical College 24.80 50
2 SCHWEIGER JOHN Southwest Wisconsin Technical College 24.60 49
3 CEYNAR CLAY Williston State College 24.40 50

Women’s Division, Clay Target Season Individual

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 MALECHA ABIGAIL Lake Superior College 24.00 48
2 MEGER RHIANNA Lake Superior College 23.60 47
3 BAUER SAMANTHA Bismark State College 23.20 48
3 VOSS RILEY Lake Superior College 23.20 48

White Division

Clay Target Season Division Team Standings

Place Team Name Team Total
1 North Dakota State College of Science 5,224.50
2 Vermilion Community College 3,468.50

Mens’s Division, Clay Target Season Individual

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 KEAGLE BEAU Hibbing Community College 24.90 48
2 EARL JOSEPH Vermilion Community College 24.30 48
2 BUSHLACK ZALE North Dakota State College of Science 24.30 44

Women’s Division, Clay Target Season Individual

Place Athlete Last Name Athlete First Name Team Name Season AVG Reserve Week Total
1 HUGHES EMMA Vermilion Community College 23.20 46
2 PAGEL EMMALEE North Dakota State College of Science 22.80 44
3 KALISCH ELLA Hibbing Community College 22.70 44

Buttons

About The Conference

Minnesota College Athletic Conference
851 30th Ave SE, Rochester MN 55904
Phone: 218-322-2394
Chair: Justin Lamppa – MCAC Executive Committee representative
Office Email: justin.lamppa@itascacc.edu
Web: www.mcacsports.org

---> Select u.`last_name` AS `LastName` , u.`first_name` AS `FirstName` , spt.`teamMemberID` AS `member_id` , spt.`teamUserID` , tu.`schoolCity` , tm.`regAthleteGender` AS `gender` , tc.`conferenceID` , c.`conferenceName` , ( SELECT DISTINCT SUM( se.`week_0_round1` + se.`week_0_round2`) FROM `score_entries` AS se WHERE se.`season_id` = spt.`season_id` AND se.`athlete_id` = spt.`teamMemberID` AND se.`discipline_id` = spt.`discipline_id` AND se.`region_id` = spt.`region_id` ) AS `reservetotal` ,( SELECT DISTINCT IFNULL(spt1.`weekTotalScore`,0) FROM `SPTData` AS spt1 WHERE spt1.`weekNbr` = 1 AND spt1.`teamMemberID` = spt.`teamMemberID` AND spt1.`season_id` = spt.`season_id` LIMIT 1 ) AS week1 ,( SELECT DISTINCT IFNULL(spt2.`weekTotalScore`,0) FROM `SPTData` AS spt2 WHERE spt2.`weekNbr` = 2 AND spt2.`teamMemberID` = spt.`teamMemberID` AND spt2.`season_id` = spt.`season_id` LIMIT 1 ) AS week2 ,( SELECT DISTINCT IFNULL(spt3.`weekTotalScore`,0) FROM `SPTData` AS spt3 WHERE spt3.`weekNbr` = 3 AND spt3.`teamMemberID` = spt.`teamMemberID` AND spt3.`season_id` = spt.`season_id` LIMIT 1 ) AS week3 ,( SELECT DISTINCT IFNULL(spt4.`weekTotalScore`,0) FROM `SPTData` AS spt4 WHERE spt4.`weekNbr` = 4 AND spt4.`teamMemberID` = spt.`teamMemberID` AND spt4.`season_id` = spt.`season_id` LIMIT 1 ) AS week4 ,( SELECT DISTINCT IFNULL(spt5.`weekTotalScore`,0) FROM `SPTData` AS spt5 WHERE spt5.`weekNbr` = 5 AND spt5.`teamMemberID` = spt.`teamMemberID` AND spt5.`season_id` = spt.`season_id` LIMIT 1 ) AS week5 , 5 as weeks , ( SELECT DISTINCT IFNULL(SUM(spt91.`weekTotalScore`), 0) FROM `SPTData` AS spt91 WHERE spt91.`season_id` = spt.`season_id` AND spt91.`region_id` = spt.`region_id` AND spt91.`teamMemberID` = spt.`teamMemberID` AND spt91.`weekNbr` > 0 AND spt91.`weekNbr` <= 5 ) AS `SUM` ,( SELECT DISTINCT SUM(IF(spt92.`weekTotalScore` > 0, 1, 0)) FROM `SPTData` AS spt92 WHERE spt92.`season_id` = spt.`season_id` AND spt92.`region_id` = spt.`region_id` AND spt92.`teamMemberID` = spt.`teamMemberID` AND spt92.`weekNbr` > 0 ) AS `divider` FROM `SPTData` AS spt JOIN `TeamUser` AS tu ON tu.id = spt.teamUserID JOIN `TeamMember` AS tm ON tm.id = spt.teamMemberID JOIN `score_entries` AS se ON se.`athlete_id` = spt.teamMemberID AND se.`season_id` = spt.`season_id` JOIN `TeamConference` AS tc ON tc.teamUserID = spt.teamUserID AND tc.`season_id` = spt.`season_id` AND tc.`discipline_id` = spt.`discipline_id` JOIN `Conference` AS c ON c.id = tc.conferenceID JOIN `users` AS u ON u.`id` = tm.`UserID` WHERE spt.`season_id` = 21 AND spt.`region_id` = 65 AND spt.`weekNbr` > 0 AND spt.`weekNbr` <= 5 GROUP BY spt.`teamMemberID` ORDER BY `SUM` DESC , u.`last_name` , u.`first_name` <---