Batting Split Finder

SELECT group_id, subgroup_id, split_name,
              name_common AS player,
CONCAT_WS(",",name_last, name_first) AS player_csk,
CONCAT('/players/',LOWER(LEFT(bio.player_ID,1)),'/',bio.player_ID,'.shtml') AS player_link
,
       A.year_game,
       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,
       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
,  A.HR  AS HR
       
       
  FROM bsplit AS A INNER JOIN bio on bio.player_ID=A.result_batter     INNER JOIN players on players.player_ID=A.result_batter 
       INNER JOIN view_bsl_meta AS v ON v.year_game=A.year_game AND v.result_batter=A.result_batter  AND v.total_season='T' 
 WHERE 
    1 > 0     
AND A.year_game >= 1901     
AND A.year_game <= 2020     
AND season_start >= 1     
AND season_end >= 1     
AND  group_id='dates'     
AND  subgroup_id='month'
 
 
 ORDER BY  A.HR  DESC
 LIMIT 0,300