⚠️ Process #22600671 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
7
Sending data
SELECT
b.PlayerID,
b.PlayerName,
b.Season,
'Away' 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
WHERE b.Team = g.AwayTeam
GROUP BY
b.PlayerID,
b.Season