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#