Query Template: /baseball/players/yearly-stats.cfm:74 Execution Time: 1405 ms Record Count: 16 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 = '8401' 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	364	143	2.5454545	179	40	72	33	40	0	0	0	145	0	0	0	17	8	6	Tex	2009
2	396	147	2.6938775	177	35	88	32	64	0	0	0	148	0	0	0	15	3	0	Tex	2010
3	461	150	3.0733333	212	60	96	37	56	0	0	0	148	0	0	1	27	3	5	Tex	2011
4	457	153	2.986928	237	61	85	21	53	0	0	0	148	0	0	4	31	9	3	Tex	2012
5	437	148	2.9527028	196	65	85	40	51	0	0	0	118	0	0	9	17	4	4	Tex	2013
6	379	151	2.5099337	198	39	71	26	45	0	0	0	147	0	0	4	34	1	2	Tex	2014
7	387	150	2.58	197	55	65	20	44	0	0	0	149	0	0	0	31	2	7	Tex	2015
8	437	143	3.055944	224	67	75	24	47	0	0	0	144	0	0	0	30	9	8	Tex	2016
9	554	158	3.506329	303	88	100	25	38	0	0	0	157	0	0	1	44	4	20	Tex	2017
10	263	97	2.7113402	144	33	53	5	28	0	0	0	97	0	0	0	20	3	6	Tex	2018
11	446	145	3.0758622	234	72	79	29	32	0	0	0	144	0	0	1	27	4	12	Tex	2019
12	63	28	2.25	34	7	11	3	8	0	0	0	29	0	0	0	5	0	3	Tex	2020
13	299	143	2.090909	159	37	60	12	31	0	0	0	143	0	0	0	25	2	3	Oak	2021
14	154	42	3.6666667	83	27	24	10	10	0	0	0	42	0	0	0	33	0	16	ChA	2022
15	233	103	2.262136	129	28	40	7	29	0	0	0	99	0	0	3	33	0	16	Oak	2022
16	254	110	2.3090909	134	44	39	12	25	0	0	63	51	3	0	1	20	1	6	ChA	2023

Mr. Sports

Elvis Andrus

Shortstop
Free Agent
Birthday: August 26, 1988 Age: 35

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
2009	Tex	364	143	2.55	17	8	6	179	40	72	33	40	0	0	0	145	0	0	0
2010	Tex	396	147	2.69	15	3	0	177	35	88	32	64	0	0	0	148	0	0	0
2011	Tex	461	150	3.07	27	3	5	212	60	96	37	56	0	0	0	148	0	0	1
2012	Tex	457	153	2.99	31	9	3	237	61	85	21	53	0	0	0	148	0	0	4
2013	Tex	437	148	2.95	17	4	4	196	65	85	40	51	0	0	0	118	0	0	9
2014	Tex	379	151	2.51	34	1	2	198	39	71	26	45	0	0	0	147	0	0	4
2015	Tex	387	150	2.58	31	2	7	197	55	65	20	44	0	0	0	149	0	0	0
2016	Tex	437	143	3.06	30	9	8	224	67	75	24	47	0	0	0	144	0	0	0
2017	Tex	554	158	3.51	44	4	20	303	88	100	25	38	0	0	0	157	0	0	1
2018	Tex	263	97	2.71	20	3	6	144	33	53	5	28	0	0	0	97	0	0	0
2019	Tex	446	145	3.08	27	4	12	234	72	79	29	32	0	0	0	144	0	0	1
2020	Tex	63	28	2.25	5	0	3	34	7	11	3	8	0	0	0	29	0	0	0
2021	Oak	299	143	2.09	25	2	3	159	37	60	12	31	0	0	0	143	0	0	0
2022	Oak	154	42	3.67	33	0	16	83	27	24	10	10	0	0	0	42	0	0	0
	ChA	233	103	2.26	33	0	16	129	28	40	7	29	0	0	0	99	0	0	3
2023	ChA	254	110	2.31	20	1	6	134	44	39	12	25	0	0	63	51	3	0	1