SELECT teampage.*, schools.school, schools.auto as school_id, schools.forum_id, schools.allnews FROM teampage INNER JOIN schools ON teampage.team = schools.Auto where team = #teamid# SELECT * FROM themenu <cfoutput>PigskinU #teamstuff.school#<cfif nt is "News"> News<cfelse> Recruiting News</cfif></cfoutput>
#teamstuff.flipad#