Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 267 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))),
tbR=SUM(feeds.total_bases),
rbiR=SUM(feeds.rbi),
runR=SUM(feeds.runs),
sbR=SUM(feeds.stolen_bases),
bbR=SUM(feeds.bb),
cR=SUM(feeds.c_games),
b1R=SUM(feeds.fb_games),
b2R=SUM(feeds.sb_games),
ssR=SUM(feeds.ss_games),
b3R=SUM(feeds.tb_games),
outR=SUM(feeds.of_games),
dhR=SUM(feeds.dh_games),
(select sum(dailystats.doubles) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as doubler,
(select sum(dailystats.triples) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as tripler,
(select sum(dailystats.hr) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as hrr,
proteam,year=substring(period,1,4)
from feeds
WHERE player = '9468' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1133502.6663824162200025000821Hou2013
2177772.29870138726291718000770041226Hou2014
385461.84782614491679003211173512Hou2015
421102.1924060001000034318Hou2016
55231433.657342724859865971001195420034318Mil2016
62921192.4537816150404923300098006118111Mil2017
7174533.2830188822328202100341900014114Bal2018
8178852.094117697222614190074000014114Mil2018
95741623.5432098289731114061001119700132524Bal2019
1077292.65517234289810001015023502Mia2020
1139221.772727314637900147003502Tor2020
123541422.49295781894263144600926970018218ChN2021
13102452.2666667501519612002921601623ChN2022
142412211361300001200623LAA2022
Mr. Sports

Jonathan Villar

3rd Baseman
Free Agent
Birthday: May 02, 1991   Age: 33
Yearly Stats
General Info Hitting Breakdown Games by Position Breakdown
Year Proteam Points Games PPG Doubles Triples HR Total Bases RBI Run SB BB C 1B 2B SS 3B OF DH
2013 Hou 133 50 2.66 8 2 1 63 8 24 16 22 0 0 0 25 0 0 0
2014 Hou 177 77 2.30 12 2 6 87 26 29 17 18 0 0 0 77 0 0 4
2015 Hou 85 46 1.85 5 1 2 44 9 16 7 9 0 0 3 21 11 7 3
2016 Hou 21 10 2.10 34 3 18 9 2 4 0 6 0 0 0 10 0 0 0
Mil 523 143 3.66 34 3 18 248 59 86 59 71 0 0 11 95 42 0 0
2017 Mil 292 119 2.45 18 1 11 150 40 49 23 30 0 0 98 0 0 6 1
2018 Mil 174 53 3.28 14 1 14 82 23 28 20 21 0 0 34 19 0 0 0
Bal 178 85 2.09 14 1 14 97 22 26 14 19 0 0 74 0 0 0 0
2019 Bal 574 162 3.54 32 5 24 289 73 111 40 61 0 0 111 97 0 0 1
2020 Mia 77 29 2.66 5 0 2 42 8 9 8 10 0 0 10 15 0 2 3
Tor 39 22 1.77 5 0 2 14 6 3 7 9 0 0 14 7 0 0 3
2021 ChN 354 142 2.49 18 2 18 189 42 63 14 46 0 0 9 26 97 0 0
2022 ChN 102 45 2.27 6 2 3 50 15 19 6 12 0 0 29 2 16 0 1
LAA 24 12 2.00 6 2 3 11 3 6 1 3 0 0 0 0 12 0 0