RECORDS (Since #dateformat(statdate,'mmm d')#) SELECT StatOrder.StatKey, Statistics.StatID, Statistics.StatLeagueID, Statistics.StatPosition, Statistics.StatCategory, Statistics.StatPlayer, Statistics.StatTeam, Statistics.Stat, Statistics.StatDate, stat/100 AS ERA FROM Statistics INNER JOIN StatOrder ON (Statistics.StatPosition = StatOrder.StatPosition) AND (Statistics.StatCategory = StatOrder.StatCategory) where Statistics.statcategory <> 'ERA' order by StatKey, StatCategory, Stat desc #statcategory# .#stat# #statplayer# #statteam# SELECT StatOrder.StatKey, Statistics.StatID, Statistics.StatLeagueID, Statistics.StatPosition, Statistics.StatCategory, Statistics.StatPlayer, Statistics.StatTeam, Statistics.Stat, Statistics.StatDate, stat/100 AS ERA FROM Statistics INNER JOIN StatOrder ON (Statistics.StatPosition = StatOrder.StatPosition) AND (Statistics.StatCategory = StatOrder.StatCategory) where Statistics.statcategory = 'ERA' order by Stat #statcategory# #era# #statplayer# #statteam#

SELECT DISTINCT teamid FROM gamebatters ORDER BY RAND() LIMIT 10

RECENT RESULTS SELECT Leagues.*, Statistics.* FROM Leagues INNER JOIN Statistics ON Leagues.LeagueID = Statistics.StatLeagueID order by leagueid desc LEAGUE #leagueid# CHAMP #leaguewinner# (#wins#-#losses#) Cy Young Award: #statplayer#, #statteam# Most Valuable Player: #statplayer#, #statteam#