Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 55.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))),
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 = '8996' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
1129572.263157879122675005600001012Hou2011
24171432.9160838229378032390014200003447Hou2012
33951462.7054794217526135300011500042925Hou2013
45211523.4276316292568454350015000024537Hou2014
54781453.29655172706078383200144000134314Hou2015
66121583.8734176326931052959001461001238524Hou2016
76061523.986842232281110325700148000239424Hou2017
84571373.33576632406184175500130000629213Hou2018
94711223.8606558266708864100119100227331Hou2019
10136462.956521767183221700460000905Hou2020
115631463.85616452928311756600144000132131Hou2021
125191393.73381327657102186600134000238028Hou2022
13373904.1444445188517614440088000121217Hou2023
14136353.885714378122571400340001907Hou2024
Mr. Sports

Jose Altuve

2nd Baseman
Houston Astros
Birthday: May 06, 1990   Age: 34
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
2011 Hou 129 57 2.26 10 1 2 79 12 26 7 5 0 0 56 0 0 0 0
2012 Hou 417 143 2.92 34 4 7 229 37 80 32 39 0 0 142 0 0 0 0
2013 Hou 395 146 2.71 29 2 5 217 52 61 35 30 0 0 115 0 0 0 4
2014 Hou 521 152 3.43 45 3 7 292 56 84 54 35 0 0 150 0 0 0 2
2015 Hou 478 145 3.30 34 3 14 270 60 78 38 32 0 0 144 0 0 0 1
2016 Hou 612 158 3.87 38 5 24 326 93 105 29 59 0 0 146 1 0 0 12
2017 Hou 606 152 3.99 39 4 24 322 81 110 32 57 0 0 148 0 0 0 2
2018 Hou 457 137 3.34 29 2 13 240 61 84 17 55 0 0 130 0 0 0 6
2019 Hou 471 122 3.86 27 3 31 266 70 88 6 41 0 0 119 1 0 0 2
2020 Hou 136 46 2.96 9 0 5 67 18 32 2 17 0 0 46 0 0 0 0
2021 Hou 563 146 3.86 32 1 31 292 83 117 5 66 0 0 144 0 0 0 1
2022 Hou 519 139 3.73 38 0 28 276 57 102 18 66 0 0 134 0 0 0 2
2023 Hou 373 90 4.14 21 2 17 188 51 76 14 44 0 0 88 0 0 0 1
2024 Hou 136 35 3.89 9 0 7 78 12 25 7 14 0 0 34 0 0 0 1