Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 38.3 ms
Record Count: 14
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 = '9057'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
12145.250000210040Min2011
2117167.312510089900151Min2012
36296.88888910010420090Min2013
45787.1251008390071Min2014
5180563.214285650010120001739Tor2015
684392.1538463000084001425Oak2016
727132.076923100002700121Tor2016
8172702.4571428410811400763Oak2017
948251.9200004800817Oak2018
10449755.986666742505410500273Oak2019
11214248.9166673140321200024Oak2020
12579698.3913048380744500069ChA2021
13496578.7017554360663000057ChA2022
143757.4210430005ChA2023
Mr. Sports

Liam Hendriks

Relief Pitcher
Boston Red Sox
Birthday: February 10, 1989   Age: 35
Yearly Stats
General Info Pitching Breakdown
Year Proteam Points Games PPG W S CG W/S+ Non W/S+ ` No Hitter Perfect Game
2011 Min 21 4 5.25 0 0 0 0 21 0 0
2012 Min 117 16 7.31 1 0 0 8 99 0 0
2013 Min 62 9 6.89 1 0 0 10 42 0 0
2014 Min 57 8 7.13 1 0 0 8 39 0 0
2015 Tor 180 56 3.21 5 0 0 10 120 0 0
2016 Tor-Oak 84 39 2.15 0 0 0 0 84 0 0
2016 Tor-Oak 27 13 2.08 0 0 0 0 27 0 0
2017 Oak 172 70 2.46 4 1 0 8 114 0 0
2018 Oak 48 25 1.92 0 0 0 0 48 0 0
2019 Oak 449 75 5.99 4 25 0 54 105 0 0
2020 Oak 214 24 8.92 3 14 0 32 12 0 0
2021 ChA 579 69 8.39 8 38 0 74 45 0 0
2022 ChA 496 57 8.70 4 36 0 66 30 0 0
2023 ChA 37 5 7.40 2 1 0 4 3 0 0