Query Template: /baseball/players/yearly-stats.cfm:74 Execution Time: 53 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 = '8957' and proteam <> 'F/A' and proteam <> 'Ret' group by substring(period,1,4),proteam,feeds.player order by substring(period,1,4) asc
	ptsR	gmsR	ppgR	tbR	rbiR	runR	sbR	bbR	cR	b1R	b2R	ssR	b3R	outR	dhR	doubler	tripler	hrr	proteam	year
1	54	27	2	29	8	9	5	3	0	0	0	0	0	27	0	1	0	1	Col	2011
2	66	36	1.8333334	40	8	13	1	4	0	0	0	0	0	30	0	7	0	2	Col	2012
3	160	69	2.3188405	101	18	30	6	5	0	0	0	0	0	42	0	16	2	4	Col	2013
4	456	146	3.1232877	248	71	79	28	30	0	0	0	0	0	138	0	25	3	18	Col	2014
5	493	148	3.3310812	265	55	89	40	44	0	0	0	0	0	149	0	30	9	16	Col	2015
6	565	139	4.0647483	315	82	109	17	42	0	0	0	0	0	135	0	34	5	29	Col	2016
7	710	159	4.465409	390	104	137	14	65	0	0	0	0	0	158	0	36	14	37	Col	2017
8	574	156	3.6794872	314	70	119	12	59	0	0	0	0	0	151	1	31	7	29	Col	2018
9	574	138	4.1594205	334	86	112	2	40	0	0	0	0	0	133	2	42	7	32	Col	2019
10	190	59	3.220339	98	40	31	2	19	0	0	0	0	0	50	9	12	1	6	Col	2020
11	422	150	2.8133333	211	78	76	3	54	0	0	0	0	0	137	1	25	4	13	Col	2021
12	396	135	2.9333334	222	78	60	4	32	0	0	0	0	0	51	80	22	6	16	Col	2022
13	286	95	3.0105264	137	38	54	4	53	0	0	0	0	0	35	61	23	4	8	Col	2023
14	61	28	2.1785715	32	9	11	1	8	0	0	0	0	0	9	17	4	2	1	Col	2024

Mr. Sports

Charlie Blackmon

Outfielder
Colorado Rockies
Birthday: July 01, 1986 Age: 37

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	Col	54	27	2.00	1	0	1	29	8	9	5	3	0	0	0	0	0	27	0
2012	Col	66	36	1.83	7	0	2	40	8	13	1	4	0	0	0	0	0	30	0
2013	Col	160	69	2.32	16	2	4	101	18	30	6	5	0	0	0	0	0	42	0
2014	Col	456	146	3.12	25	3	18	248	71	79	28	30	0	0	0	0	0	138	0
2015	Col	493	148	3.33	30	9	16	265	55	89	40	44	0	0	0	0	0	149	0
2016	Col	565	139	4.06	34	5	29	315	82	109	17	42	0	0	0	0	0	135	0
2017	Col	710	159	4.47	36	14	37	390	104	137	14	65	0	0	0	0	0	158	0
2018	Col	574	156	3.68	31	7	29	314	70	119	12	59	0	0	0	0	0	151	1
2019	Col	574	138	4.16	42	7	32	334	86	112	2	40	0	0	0	0	0	133	2
2020	Col	190	59	3.22	12	1	6	98	40	31	2	19	0	0	0	0	0	50	9
2021	Col	422	150	2.81	25	4	13	211	78	76	3	54	0	0	0	0	0	137	1
2022	Col	396	135	2.93	22	6	16	222	78	60	4	32	0	0	0	0	0	51	80
2023	Col	286	95	3.01	23	4	8	137	38	54	4	53	0	0	0	0	0	35	61
2024	Col	61	28	2.18	4	2	1	32	9	11	1	8	0	0	0	0	0	9	17