Click 'Kill' to end a process. Processes with long run times use more CPU.
ID
User
Host
DB
Command
Time (sec)
State
Info
CPU (est)
Action
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/bobnet/baseball/mysql_process_manager.php on line 83
61605248
bobnet_horseplay
localhost
bobnet_Baseball
Sleep
0
—
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/bobnet/baseball/mysql_process_manager.php on line 83
SELECT
game_year AS Season,
game_date AS GameDate,
pitcher AS PitcherID,
MAX(player_name) AS PitcherName,
COUNT(
DISTINCT CONCAT(
game_pk,
'-',
pitcher,
'-',
at_bat_number
)
) AS BattersFaced,
COUNT(
DISTINCT CASE
WHEN events='strikeout'
THEN CONCAT(
game_pk,
'-',
pitcher,
'-',
at_bat_number
)
END
) AS StrikeOuts,
COUNT(
DISTINCT CASE
WHEN events IN ('walk','intent_walk')
THEN CONCAT(
game_pk,
'-',
pitcher,
'-',
at_bat_number
)
END
) AS Walks,
COUNT(
DISTINCT CASE
WHEN events IN
(
'single',
'double',
'triple',
'home_run'
)
THEN CONCAT(
game_pk,
'-',
pitcher,
'-',
at_bat_number
)
END
) AS HitsAllowed,
COUNT(
DISTINCT CASE
WHEN events='home_run'
THEN CONCAT(
game_pk,
'-',
pitcher,
'-',
at_bat_number
)
END
) AS HomeRunsAllowed,
ROUND(AVG(release_speed),2) AS AvgVelocity,
ROUND(AVG(release_spin_rate),2) AS AvgSpinRate,
ROUND(
AVG(
CASE
WHEN launch_speed IS NOT NULL
THEN launch_speed
END
),
2
) AS AvgExitVelocityAllowed,
SUM(
CASE
WHEN launch_speed >= 95
THEN 1
ELSE 0
END
) AS HardHitBallsAllowed,
ROUND(
100 *
SUM(
CASE
WHEN launch_speed >= 95
THEN 1
ELSE 0
END
)
/
NULLIF(
SUM(
CASE
WHEN launch_speed IS NOT NULL
THEN 1
ELSE 0
END
),
0
),
2
) AS HardHitPctAllowed,
SUM(
CASE
WHEN launch_speed_angle = 6
THEN 1
ELSE 0
END
) AS BarrelsAllowed,
ROUND(
100 *
SUM(
CASE
WHEN launch_speed_angle = 6
THEN 1
ELSE 0
END
)
/
NULLIF(
SUM(
CASE
WHEN launch_speed IS NOT NULL
THEN 1
ELSE 0
END
),
0
),
2
) AS BarrelPctAllowed,
SUM(
CASE
WHEN description IN
(
'swinging_strike',
'swinging_strike_blocked'
)
THEN 1
ELSE 0
END
) AS Whiffs,
ROUND(
100 *
SUM(
CASE
WHEN description IN
(
'swinging_strike',
'swinging_strike_blocked'
)
THEN 1
ELSE 0
END
)
/
NULLIF(COUNT(*),0),
2
) AS WhiffPct,
0 AS ChasePitches,
0 AS ChasePct,
SUM(
CASE
WHEN zone BETWEEN 1 AND 9
THEN 1
ELSE 0
END
) AS ZonePitches
FROM StatcastData s
INNER JOIN
(
SELECT DISTINCT
PlayerID,
GameDate
FROM MLB_PitcherBoxscores
) pb
ON pb.PlayerID = s.pitcher
AND pb.GameDate = s.game_date
WHERE game_year = ?
GROUP BY
game_year,
game_date,
pitcher
ORDER BY
game_date,
pitcher
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in /home/bobnet/baseball/mysql_process_manager.php on line 83