Yilber Diaz TRABL Career Statistics
Selected in the 7th round (#148 overall) of the 2025 Annual Draft.




TRABL Regular Season Batting Stats SELECT lgyear AS [YR], lgteam AS [TEAM], Format (BA, '.000') AS AVG, Format (OBP, '.000') AS OBP, Format (SLG, '.000') AS SLG, Format((OBP + SLG), '.000') AS OPS, G, PA, AB, R, H, DB AS '2B', [TR] AS '3B', HR, RBI, SB, CS, SO, BB, IBB, HBP, SH, SF, GDP, TB FROM s_careerbatting WHERE lg_id = 28 AND player_id = 'diazyi01' ORDER BY lgyear, lastname, firstname ASC
YR TEAM AVG OBP SLG OPS G PA AB R H 2B 3B HR RBI SB CS SO BB IBB HBP SH SF GDP TB

TRABL Regular Season Career Batting Totals SELECT DISTINCT Count(lgyear) AS [TOT],'Seasons' AS [STATS], dbo.uf_get_avg(Sum(AB), Sum(H)) AS AVG, dbo.uf_get_obp(Sum(AB), Sum(H), Sum(BB), Sum(HBP), Sum(SF)) AS OBP, dbo.uf_get_slg(Sum(AB), Sum(TB)) AS SLG, dbo.uf_get_ops(Sum(AB), Sum(H), Sum(BB), Sum(HBP), Sum(SF), Sum(TB)) AS OPS, Sum(G) AS G, Sum(PA) AS PA, Sum(AB) AS AB, Sum(R) AS R, Sum(H) AS H, Sum(DB) AS '2B', Sum(TR) AS '3B', Sum(HR) AS [HR], Sum(RBI) AS RBI, Sum(SB) AS SB, Sum(CS) AS CS, Sum(SO) AS SO, Sum(BB) AS BB, Sum(IBB) AS IBB, Sum(HBP) AS HBP, Sum(SH) AS SH, Sum(SF) AS SF, Sum(GDP) AS GDP, Sum(TB) AS TB FROM s_careerbatting WHERE lg_id = 28 GROUP BY player_id HAVING player_id = 'diazyi01'
TOT STATS AVG OBP SLG OPS G PA AB R H 2B 3B HR RBI SB CS SO BB IBB HBP SH SF GDP TB

TRABL Playoff Batting Stats SELECT lgyear AS [YR], lgteam AS [TEAM], cb.lgsegment AS [SEG], Format (BA, '.000') AS AVG, Format (OBP, '.000') AS OBP, Format (SLG, '.000') AS SLG, Format((OBP + SLG), '.000') AS OPS, G, PA, AB, R, H, DB AS '2B', TR AS '3B', HR, RBI, TB, SO, BB, SB, CS, IBB, HBP, SH, SF, GDP FROM s_careerbattingpo cb INNER JOIN playoffsort po ON cb.lgsegment = po.Segment WHERE lg_id = 28 AND player_id = 'diazyi01' ORDER BY lgyear, lastname, firstname, po.SortID ASC
YR TEAM SEG AVG OBP SLG OPS G PA AB R H 2B 3B HR RBI TB SO BB SB CS IBB HBP SH SF GDP

TRABL Playoff Career Batting Totals SELECT DISTINCT Count(lgyear) AS [TOT],'Segments' AS [STATS], dbo.uf_get_avg(Sum(AB), Sum(H)) AS AVG, dbo.uf_get_obp(Sum(AB), Sum(H), Sum(BB), Sum(HBP), Sum(SF)) AS OBP, dbo.uf_get_slg(Sum(AB), Sum(TB)) AS SLG, dbo.uf_get_ops(Sum(AB), Sum(H), Sum(BB), Sum(HBP), Sum(SF), Sum(TB)) AS OPS, Sum(G) AS G, Sum(PA) AS PA, Sum(AB) AS AB, Sum(R) AS R, Sum(H) AS H, Sum(DB) AS '2B', Sum(TR) AS '3B', Sum(HR) AS [HR], Sum(RBI) AS RBI, Sum(TB) AS TB, Sum(SO) AS SO, Sum(BB) AS BB, Sum(SB) AS SB, Sum(CS) AS CS, Sum(IBB) AS IBB, Sum(HBP) AS HBP, Sum(SH) AS SH, Sum(SF) AS SF, Sum(GDP) AS GDP FROM s_careerbattingpo WHERE lg_id = 28 GROUP BY player_id HAVING player_id = 'diazyi01'
TOT STATS AVG OBP SLG OPS G PA AB R H 2B 3B HR RBI TB SO BB SB CS IBB HBP SH SF GDP

MLB Stats SELECT m.mlb_year AS YEAR, m.age AS AGE, m.mlb_team AS MLB, a.pos AS POS, a.d AS D, (CASE WHEN a.pos = 'C' OR a.pos= 'C+' THEN a.th ELSE a.arm END) AS ARM, Format (m.ba, '.000') AS 'AVG', Format (m.OBP, '.000') AS OBP, Format (m.slg, '.000') AS SLG, Format (m.ops, '.000') AS OPS, m.g AS G, m.pa AS PA, m.ab AS AB, m.r AS R, m.h AS H, m.db as '2B', m.tr AS '3B', m.hr AS HR, m.rbi AS RBI, m.sb AS SB, m.cs AS CS, m.so AS SO, m.bb as BB, COALESCE(m.sf, 0) AS SF, COALESCE(m.hbp, 0) AS HBP, m.tb AS TB, Format(m.war, '0.0') AS WAR, Format(Cast(COALESCE(m.mlb_salary, dbo.uf_get_min_salary(m.mlb_year)) AS INT), '$#,##0;($#,##0)') AS SALARY FROM mlb_hitters m LEFT JOIN v_apba_players a ON m.player_id = a.player_id AND m.mlb_year = a.year WHERE m.player_id = 'diazyi01' ORDER BY m.mlb_year
YEAR AGE MLB POS D ARM AVG OBP SLG OPS G PA AB R H 2B 3B HR RBI SB CS SO BB SF HBP TB WAR SALARY

MLB Stat Totals SELECT DISTINCT Count(m.mlb_year) AS [TOT], 'Seasons' AS [STATS], dbo.uf_get_avg(Sum(AB), Sum(H)) AS AVG, dbo.uf_get_obp(Sum(AB), Sum(H), Sum(BB), Sum(HBP), Sum(SF)) AS OBP, dbo.uf_get_slg(Sum(AB), Sum(TB)) AS SLG, dbo.uf_get_ops(Sum(AB), Sum(H), Sum(BB), Sum(HBP), Sum(SF), Sum(TB)) AS OPS, Sum(m.G) AS G, Sum(m.PA) AS PA, Sum(m.AB) AS AB, Sum(m.R) AS R, Sum(m.H) AS H, Sum(m.db) AS [2B], Sum(m.tr) AS [3B], Sum(m.HR) AS [HR], Sum(m.RBI) AS RBI, Sum(m.SB) AS SB, Sum(m.CS) AS CS, Sum(m.SO) AS SO, Sum(m.BB) AS BB, Sum(COALESCE(m.sf, 0)) AS SF, Sum(COALESCE(m.hbp, 0)) AS HBP, Sum(m.TB) AS TB, Format(Sum(m.war), '0.0') AS WAR, Format(Sum(Cast(m.mlb_salary AS INT)), '$#,##0;($#,##0)') AS SALARY FROM mlb_hitters m LEFT JOIN v_apba_players a ON m.player_id = a.player_id AND m.mlb_year = a.year GROUP BY m.player_id HAVING m.player_id ='diazyi01'
TOT STATS AVG OBP SLG OPS G PA AB R H 2B 3B HR RBI SB CS SO BB SF HBP TB WAR SALARY