select * from players where team = '1' and active = 'yes' and year = '#eyear#' order by position, last, first select * from players where team = '1' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '2' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '2' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '3' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '3' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '4' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '4' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '5' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '5' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '13' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '13' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '7' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '7' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '20' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '20' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '19' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '19' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '10' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '10' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '11' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '11' and year = '#eyear#' and active = 'no' order by position, last, first select * from players where team = '12' and year = '#eyear#' and active = 'yes' order by position, last, first select * from players where team = '12' and year = '#eyear#' and active = 'no' order by position, last, first

Current Rosters As of #DateFormat(Now(),"MM/DD/YY")#
No Love for Hoes	Roody Poo's	Chain Gang
QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#
Debo's	Como's	The Whipped Cream Heads
QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#
NC Nuggets	Horshoes	The Michael Vick Experience
QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#
Anal Penetrators	Chainsaw Wino's	The Liquidators
QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#	QB RB WR TE K DEF - #first# #last# IR - #first# #last#