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#

Rapid Stats Baseball
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#