Query
Template: /baseball/players/yearly-stats.cfm:56
Execution Time: 6.84 ms
Record Count: 7
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 = '9642'
group by substring(period,1,4),proteam
order by substring(period,1,4) asc
ptsRgmsRppgRwRsRcgRwsbRnwsRnohRpfgRstartRreliefRproteamyear
13531918.57894713021446900190NYA2014
23292214.95454511021109900220NYA2015
34273014.233334130213815900280NYA2016
43753012.5130113810200280NYA2017
53412812.178572120111410200280NYA2018
63613111.645162110111413200310NYA2019
71101011301245100100NYA2020
Mr. Sports

Masahiro Tanaka

Starting Pitcher

Birthday: November 01, 1988   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
2014 NYA 353 19 18.58 13 0 2 144 69 0 0
2015 NYA 329 22 14.95 11 0 2 110 99 0 0
2016 NYA 427 30 14.23 13 0 2 138 159 0 0
2017 NYA 375 30 12.50 13 0 1 138 102 0 0
2018 NYA 341 28 12.18 12 0 1 114 102 0 0
2019 NYA 361 31 11.65 11 0 1 114 132 0 0
2020 NYA 110 10 11.00 3 0 1 24 51 0 0