Query Template: /baseball/players/yearly-stats.cfm:74 Execution Time: 26.9 ms Record Count: 10 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 = '8578' 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	108	3.3703704	207	69	58	0	30	76	30	0	0	0	0	0	24	2	18	SF	2010
2	122	45	2.711111	63	21	17	3	18	41	2	0	0	0	0	0	5	0	4	SF	2011
3	531	145	3.662069	284	100	77	1	69	110	28	0	0	0	0	2	38	1	23	SF	2012
4	416	142	2.9295774	229	72	59	2	54	102	18	0	0	0	0	3	33	1	15	SF	2013
5	457	142	3.2183099	248	85	67	0	44	106	33	0	0	0	0	2	25	2	20	SF	2014
6	470	142	3.309859	252	89	73	2	54	102	36	0	0	0	0	3	27	0	19	SF	2015
7	461	142	3.2464788	232	78	81	6	64	120	15	0	0	0	0	5	31	5	13	SF	2016
8	423	139	3.0431654	228	67	62	5	61	99	38	0	0	0	0	7	34	0	12	SF	2017
9	286	105	2.7238095	151	40	47	3	45	88	13	0	0	0	0	3	22	1	5	SF	2018
10	262	111	2.3603604	147	38	43	0	34	99	4	0	0	0	0	2	24	0	7	SF	2019

Mr. Sports

Buster Posey

Catcher

Birthday: March 27, 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
2010	SF	364	108	3.37	24	2	18	207	69	58	0	30	76	30	0	0	0	0	0
2011	SF	122	45	2.71	5	0	4	63	21	17	3	18	41	2	0	0	0	0	0
2012	SF	531	145	3.66	38	1	23	284	100	77	1	69	110	28	0	0	0	0	2
2013	SF	416	142	2.93	33	1	15	229	72	59	2	54	102	18	0	0	0	0	3
2014	SF	457	142	3.22	25	2	20	248	85	67	0	44	106	33	0	0	0	0	2
2015	SF	470	142	3.31	27	0	19	252	89	73	2	54	102	36	0	0	0	0	3
2016	SF	461	142	3.25	31	5	13	232	78	81	6	64	120	15	0	0	0	0	5
2017	SF	423	139	3.04	34	0	12	228	67	62	5	61	99	38	0	0	0	0	7
2018	SF	286	105	2.72	22	1	5	151	40	47	3	45	88	13	0	0	0	0	3
2019	SF	262	111	2.36	24	0	7	147	38	43	0	34	99	4	0	0	0	0	2