SELECT `sport`,`school_list`.`longname`,`school_list`.`shortname` FROM `rosters`,`school_list` WHERE `sport`='FB' AND `school_list`.`id`=`rosters`.`school_id` GROUP BY `rosters`.`school_id` ORDER BY `school_list`.`longname` ASC; d3photography.com

Searching for Track and Field, Cross Country, or Swimming and Diving photos?

Football

Dubuque
Finlandia
Hanover
Hope
John Carroll
Monmouth
North Central (Ill.)
UW-River Falls
UW-Whitewater
Wartburg