Query Template: /baseball/players/yearly-stats.cfm:74 Execution Time: 27.4 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 = '9186' 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	58	39	1.4871795	32	12	8	0	6	9	18	0	0	8	4	2	4	0	3	Tor	2012
2	227	79	2.8734176	131	34	42	2	18	59	1	0	0	0	0	3	18	2	10	Cle	2013
3	372	127	2.929134	221	71	58	0	22	122	0	0	0	0	0	6	25	3	20	Cle	2014
4	215	88	2.4431818	127	40	36	0	12	85	0	0	0	0	0	4	19	0	11	Cle	2015
5	145	65	2.2307692	80	34	22	0	9	71	0	0	0	0	0	1	10	1	9	Cle	2016
6	266	104	2.5576923	136	56	43	0	31	103	0	0	0	0	0	0	15	0	14	Cle	2017
7	292	108	2.7037036	174	47	51	0	20	108	0	0	0	0	0	1	26	0	16	Cle	2018
8	10	4	2.5	7	1	1	0	1	4	0	0	0	0	0	0	26	0	16	Was	2018
9	239	95	2.5157895	122	43	35	2	37	92	1	0	0	0	0	0	16	0	12	Was	2019
10	93	31	3	56	14	16	1	6	31	0	0	0	0	0	0	6	1	4	Was	2020
11	267	101	2.6435645	147	52	49	0	19	92	0	0	0	0	0	6	15	1	14	ChN	2021
12	163	84	1.9404762	99	31	23	2	8	68	0	0	0	0	0	9	11	0	8	ChN	2022
13	280	113	2.4778762	154	60	44	1	21	103	0	0	0	0	0	12	20	2	10	ChN	2023
14	25	19	1.3157895	18	3	4	0	0	19	0	0	0	0	0	0	1	0	2	ChN	2024

Mr. Sports

Yan Gomes

Catcher
Chicago Cubs
Birthday: July 19, 1987 Age: 36

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
2012	Tor	58	39	1.49	4	0	3	32	12	8	0	6	9	18	0	0	8	4	2
2013	Cle	227	79	2.87	18	2	10	131	34	42	2	18	59	1	0	0	0	0	3
2014	Cle	372	127	2.93	25	3	20	221	71	58	0	22	122	0	0	0	0	0	6
2015	Cle	215	88	2.44	19	0	11	127	40	36	0	12	85	0	0	0	0	0	4
2016	Cle	145	65	2.23	10	1	9	80	34	22	0	9	71	0	0	0	0	0	1
2017	Cle	266	104	2.56	15	0	14	136	56	43	0	31	103	0	0	0	0	0	0
2018	Cle	292	108	2.70	26	0	16	174	47	51	0	20	108	0	0	0	0	0	1
	Was	10	4	2.50	26	0	16	7	1	1	0	1	4	0	0	0	0	0	0
2019	Was	239	95	2.52	16	0	12	122	43	35	2	37	92	1	0	0	0	0	0
2020	Was	93	31	3.00	6	1	4	56	14	16	1	6	31	0	0	0	0	0	0
2021	ChN	267	101	2.64	15	1	14	147	52	49	0	19	92	0	0	0	0	0	6
2022	ChN	163	84	1.94	11	0	8	99	31	23	2	8	68	0	0	0	0	0	9
2023	ChN	280	113	2.48	20	2	10	154	60	44	1	21	103	0	0	0	0	0	12
2024	ChN	25	19	1.32	1	0	2	18	3	4	0	0	19	0	0	0	0	0	0