Team Batting Split Finder

/* mysql8 */
SELECT group_id, subgroup_id, split_name,
  IF(team_ID NOT LIKE '%TM' AND team_ID NOT LIKE 'TOT',CONCAT('/teams/',team_ID,'/',year_ID,'.shtml'),'') AS team_link,
  mt.team_ID AS team,
  mt.name AS team_title,
  mt.lg_ID AS lg_id,
  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,
  
  R as RProd,
  ROUND(IF( (HBP is NULL) or  (SH is NULL) or  (SF is NULL) or  (CS is NULL) or  (GIDP is NULL) or  (IBB is NULL), IF( (CS is NULL), (H + BB) * ((H+2B+(2*3B)+(3*HR))) / (AB + BB),  (H + BB - CS) * ( H + 2B + 2*3B + 3*HR + 0.55*SB ) / (AB + BB)  ),  (H + BB - CS + ifnull(HBP,0) - ifnull(GIDP,0)) * ( H + 2B + 2*3B + 3*HR + .26*(BB - ifnull(IBB,BB) + ifnull(HBP,0)) + 0.52*(SB + ifnull(SH,0) + ifnull(SF,0) ) ) / (AB + BB + ifnull(HBP + SH + SF,0))  ),1) as RC_split,
  (AB - IFNULL(H,0)  + IFNULL(GIDP,0) + IFNULL(SF,0) + IFNULL(SH,0) + IFNULL(CS,0)) as outs,
  (AB-HR-IFNULL(SO,0)+IFNULL(SF,0)) as bip,
  IF(SO=0 OR SO is NULL, NULL, ROUND(AB / SO,4)) as at_bats_per_strikeout,
  IF(SB+CS = 0 or SB+CS is null,NULL,ROUND(100*SB/(SB+CS),3)) as stolen_base_perc,
  SB+CS as SB_attempts,
  GS,
  ROE,
  tOPS,
  sOPS,
  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,
  ROUND(IF(AB = 0, NULL, ROUND(((H + 2B + (2 * 3B) + (3 * HR)) - H) / AB, 10)),3) as isolated_slugging_perc,
  IF(incomplete=1,'I','') AS incomplete_split
FROM tbsplit AS A
  LEFT JOIN majors_team_view mt on mt.team_ID=A.batting_team_id AND mt.year_ID=A.year_game  
WHERE 1 > 0 AND A.year_game >= 2025 AND A.year_game <= 2025 AND A.batting_team_id!="TOT" AND  group_id='locat' AND  subgroup_id='hmvis' AND  split_name='Home'
ORDER BY HR DESC, team ASC, A.year_game DESC
LIMIT 0, 300


$VAR1 = [];
/* mysql8 */
SELECT CONCAT(group_id,':',subgroup_id,':',split_name) as id, MAX(year_game) as max_year
FROM tbsplit
GROUP BY group_id, subgroup_id, split_name


$VAR1 = [];
/* mysql8 */
SELECT gid, sid, snm, split_order.spo, gid as group_id, sid AS subgroup_id, snm AS split_name
FROM bsplit_order as split_order
GROUP BY gid,sid,snm
ORDER BY split_order.spo


$VAR1 = [];
/* mysql8 */
SELECT gid, sid, min(split_order.spo) AS first
FROM bsplit_order as split_order
WHERE 1>0 
GROUP BY gid, sid
ORDER BY first ASC


$VAR1 = [];