Query Template: /baseball/players/yearly-stats.cfm:74 Execution Time: 33.8 ms Record Count: 17 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 = '8171' 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	339	108	3.1388888	187	52	63	4	33	0	0	0	0	0	105	0				Cin	2008
2	308	99	3.1111112	162	58	47	3	38	0	0	0	0	0	98	0	15	2	22	Cin	2009
3	464	147	3.1564627	251	70	80	5	58	0	0	0	0	0	146	0	23	5	25	Cin	2010
4	537	157	3.4203823	277	97	84	8	71	0	0	0	0	0	155	0	27	2	32	Cin	2011
5	542	151	3.5894039	285	98	89	9	61	0	0	0	0	0	148	0	35	5	34	Cin	2012
6	557	154	3.616883	296	106	89	5	59	0	0	0	0	0	128	0	42	1	30	Cin	2013
7	371	130	2.853846	180	65	70	12	44	0	3	0	0	0	128	0	21	1	18	Cin	2014
8	454	147	3.0884354	240	80	69	9	56	0	0	0	0	0	143	2	33	4	25	Cin	2015
9	372	94	3.9574468	206	79	59	4	24	0	0	0	0	0	92	1	24	6	33	Cin	2016
10	114	47	2.4255319	64	19	14	0	17	0	0	0	0	0	43	1	24	6	33	NYN	2016
11	138	45	3.0666666	71	26	21	1	19	0	1	0	0	0	43	1	29	2	36	Cle	2017
12	385	101	3.8118813	211	75	61	0	38	0	11	0	0	0	90	2	29	2	36	NYN	2017
13	221	89	2.483146	116	36	30	2	37	0	17	0	0	0	63	2	19	1	9	NYN	2018
14	9	5	1.8	3	1	1	0	4	0	4	0	0	0	1	0	19	1	9	Sea	2018
15	124	51	2.4313726	74	31	16	0	3	0	0	0	0	0	31	3	17	0	26	Phi	2019
16	160	47	3.4042554	88	28	27	1	16	0	16	0	0	0	28	4	17	0	26	Sea	2019
17	78	31	2.516129	46	14	11	0	7	0	2	0	0	0	17	10	5	2	6	Phi	2020

Mr. Sports

Jay Bruce

1st Baseman

Birthday: April 03, 1987 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
2008	Cin	339	108	3.14	*	*	*	187	52	63	4	33	0	0	0	0	0	105	0
2009	Cin	308	99	3.11	15	2	22	162	58	47	3	38	0	0	0	0	0	98	0
2010	Cin	464	147	3.16	23	5	25	251	70	80	5	58	0	0	0	0	0	146	0
2011	Cin	537	157	3.42	27	2	32	277	97	84	8	71	0	0	0	0	0	155	0
2012	Cin	542	151	3.59	35	5	34	285	98	89	9	61	0	0	0	0	0	148	0
2013	Cin	557	154	3.62	42	1	30	296	106	89	5	59	0	0	0	0	0	128	0
2014	Cin	371	130	2.85	21	1	18	180	65	70	12	44	0	3	0	0	0	128	0
2015	Cin	454	147	3.09	33	4	25	240	80	69	9	56	0	0	0	0	0	143	2
2016	Cin	372	94	3.96	24	6	33	206	79	59	4	24	0	0	0	0	0	92	1
	NYN	114	47	2.43	24	6	33	64	19	14	0	17	0	0	0	0	0	43	1
2017	NYN	138	45	3.07	29	2	36	71	26	21	1	19	0	1	0	0	0	43	1
	Cle	385	101	3.81	29	2	36	211	75	61	0	38	0	11	0	0	0	90	2
2018	NYN	221	89	2.48	19	1	9	116	36	30	2	37	0	17	0	0	0	63	2
	Sea	9	5	1.80	19	1	9	3	1	1	0	4	0	4	0	0	0	1	0
2019	Sea	124	51	2.43	17	0	26	74	31	16	0	3	0	0	0	0	0	31	3
	Phi	160	47	3.40	17	0	26	88	28	27	1	16	0	16	0	0	0	28	4
2020	Phi	78	31	2.52	5	2	6	46	14	11	0	7	0	2	0	0	0	17	10