⚠️ Process #22599711 already ended (no action needed).
MySQL Process Manager
🧠 MySQL Process Manager
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
22603092
bobnet_horseplay
localhost
bobnet_Baseball
Query
12
Creating sort index
SELECT
b.PlayerID,
b.PlayerName,
b.Season,
CASE
WHEN pb.ThrowSide='L'
THEN 'vsLHP'
ELSE 'vsRHP'
END AS SplitType,
COUNT(DISTINCT b.GameID) AS Games,
SUM(b.AtBats) AS AB,
SUM(b.Hits) AS Hits,
SUM(b.Singles) AS Singles,
SUM(b.Doubles) AS Doubles,
SUM(b.Triples) AS Triples,
SUM(b.HomeRuns) AS HomeRuns,
SUM(b.Walks) AS Walks,
SUM(b.HBP) AS HBP,
SUM(b.SacFlies) AS SacFlies,
SUM(b.StolenBases) AS StolenBases
FROM MLB_BatterBoxscores b
INNER JOIN MLB_Games g
ON b.GameID = g.GameID
INNER JOIN MLB_StartingPitchers sp
ON (
(b.Team = g.HomeTeam
AND sp.GameID = g.GameID
AND sp.HomeAway='away')
OR
(b.Team = g.AwayTeam
AND sp.GameID = g.GameID
AND sp.HomeAway='home')
)
INNER JOIN MLB_PlayerBio pb
ON sp.PitcherID = pb.PlayerID
WHERE pb.ThrowSide IN ('L','R')
GROUP BY
b.PlayerID,
b.Season,
pb.ThrowSide
ORDER BY
b.PlayerID,
b.Season