Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 10.1 ms
Record Count: 18
Cached: No
Lazy: No
SQL:
SELECT ptsR=SUM(feeds.scored_points),
gmsR=SUM(feeds.games),
ppgR=(convert(real,SUM(feeds.scored_points)) / convert(real,SUM(feeds.games))),
wR=SUM(feeds.wins),
sR=SUM(feeds.saves),
cgR=SUM(feeds.complete_game),
wsbR=SUM(feeds.ws_points),
nwsR=SUM(feeds.nws_points),
nohR=SUM(feeds.no_hitter),
pfgR=SUM(feeds.perfect_game),startR=sum(feeds.starts),
reliefR=sum(feeds.relief),proteam,year=substring(period,1,4)
from feeds
WHERE player = '7048'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
1321.5000030002StL2005
2170592.881356210813200059StL2006
34243113.67742130013216200310StL2007
43132015.6511011148400200StL2008
56123517.485714190119821900350StL2009
66013318.212122200425212900330StL2010
74403213.75140315013500320StL2012
85583217.4375170522214100320StL2013
95763118.580645190425211400310StL2014
1070417.520026240031StL2015
113583211.187512007616200311StL2016
122692411.2083331200985100231StL2017
136688.2520022240080StL2018
143593011.96666614011328700300StL2019
151581015.8503504800100StL2020
165313316.090911702116818300330StL2021
173963212.375110111816800320StL2022
18145216.904762500326300210StL2023
Mr. Sports

Adam Wainwright

Starting Pitcher
Free Agent
Birthday: August 30, 1981   Age: 42
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2005 StL 3 2 1.50 0 0 0 0 3 0 0
2006 StL 170 59 2.88 2 1 0 8 132 0 0
2007 StL 424 31 13.68 13 0 0 132 162 0 0
2008 StL 313 20 15.65 11 0 1 114 84 0 0
2009 StL 612 35 17.49 19 0 1 198 219 0 0
2010 StL 601 33 18.21 20 0 4 252 129 0 0
2012 StL 440 32 13.75 14 0 3 150 135 0 0
2013 StL 558 32 17.44 17 0 5 222 141 0 0
2014 StL 576 31 18.58 19 0 4 252 114 0 0
2015 StL 70 4 17.50 2 0 0 26 24 0 0
2016 StL 358 32 11.19 12 0 0 76 162 0 0
2017 StL 269 24 11.21 12 0 0 98 51 0 0
2018 StL 66 8 8.25 2 0 0 22 24 0 0
2019 StL 359 30 11.97 14 0 1 132 87 0 0
2020 StL 158 10 15.80 5 0 3 50 48 0 0
2021 StL 531 33 16.09 17 0 21 168 183 0 0
2022 StL 396 32 12.38 11 0 1 118 168 0 0
2023 StL 145 21 6.90 5 0 0 32 63 0 0