Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 14.4 ms
Record Count: 16
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 = '8650'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
187184.8333335110105700216StL2011
24083511.65714318001626600305StL2012
34053212.65625140013612900320StL2013
44953215.46875150115418600311StL2014
53662813.071428110013012600261StL2015
64303313.030303110011021000321StL2017
7195209.75700626300200Min2018
896109.620022540091NYA2018
914114100400001Tex2018
104473213.96875150114415300320Tex2019
112001315.384615605666900130Tex2020
123952814.1071421101311216800280ChA2021
132502111.904762801809000210ChA2022
14167208.35600386900200ChA2023
151591213.25700563300120LAD2023
167071010012480070StL2024
Mr. Sports

Lance Lynn

Starting Pitcher
St. Louis Cardinals
Birthday: May 12, 1987   Age: 36
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2011 StL 87 18 4.83 1 1 0 10 57 0 0
2012 StL 408 35 11.66 18 0 0 162 66 0 0
2013 StL 405 32 12.66 14 0 0 136 129 0 0
2014 StL 495 32 15.47 15 0 1 154 186 0 0
2015 StL 366 28 13.07 11 0 0 130 126 0 0
2017 StL 430 33 13.03 11 0 0 110 210 0 0
2018 Min-NYA-Tex 195 20 9.75 7 0 0 62 63 0 0
2018 Min-NYA-Tex 96 10 9.60 2 0 0 22 54 0 0
2018 Min-NYA-Tex 14 1 14.00 1 0 0 4 0 0 0
2019 Tex 447 32 13.97 15 0 1 144 153 0 0
2020 Tex 200 13 15.38 6 0 5 66 69 0 0
2021 ChA 395 28 14.11 11 0 13 112 168 0 0
2022 ChA 250 21 11.90 8 0 1 80 90 0 0
2023 ChA-LAD 167 20 8.35 6 0 0 38 69 0 0
2023 ChA-LAD 159 12 13.25 7 0 0 56 33 0 0
2024 StL 70 7 10.00 1 0 0 12 48 0 0