View splits adjusted to be per 162 games or 650 PAs

First column (I) indicates when a split may be incomplete due to missing play-by-play data. For all seasons after 1973, the play-by-play data is complete (summary of missing data for pre-1974). Note: There are 154 games from 1913 missing RBIs from one or both teams.
Display Query »
SELECT group_id, subgroup_id, split_name, result_batter as pid,
       "bat" as type_of_split,
       G, (PA) AS PA, AB,R, H,  H - (2B + 3B + HR) as 1B,2B, 3B, HR, RBI, SB, CS, BB, SO,
ROUND(IF(AB = 0, NULL, ROUND(H  / AB,10)),3) as batting_avg, ROUND(IF((AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)) = 0, NULL, ROUND((H + IFNULL(BB,0) + IFNULL(HBP,0)) / (AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)),10)),3) as onbase_perc, ROUND(IF(AB = 0, NULL, ROUND((H + 2B + (2 * 3B) + (3 * HR)) / AB, 10)),3) as slugging_perc, ROUND(IF((AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)) = 0, NULL, ROUND((H + IFNULL(BB,0) + IFNULL(HBP,0)) / (AB + IFNULL(BB,0) + IFNULL(HBP,0) + IFNULL(SF,0)),10)) + IF(AB = 0, NULL, ROUND((H + 2B + (2 * 3B) + (3 * HR)) / AB, 10)),3) as onbase_plus_slugging ,
(H + 2B + (2 * 3B) + (3 * HR)) AS TB, GIDP, HBP, SH, SF, IBB
,
       GS, ROE, "" AS year_id, 
       tOPS as onbase_plus_slugging_vs_total,
       sOPS as onbase_plus_slugging_vs_lg,
       ROUND(IF(AB-HR-IFNULL(SO,0)+IFNULL(SF,0) = 0, NULL, ROUND((H-HR)/(AB-HR-IFNULL(SO,0)+IFNULL(SF,0)),10)),3) AS batting_avg_bip,
       IF(incomplete=1,'I','') AS incomplete_split
  FROM bsplit AS split_table
 WHERE result_batter=? AND year_game=? 
 ORDER BY spo ASC

More Pages

ARRAY(0x6409370)
Support us without the ads? Go Ad-Free.