ID: 6891561 | User: michael | Host: 100.64.0.24:56224 | DB: recherche | Command: Sleep | Time: 350 | State:
SQL:
ID: 6891563 | User: michael | Host: 100.64.0.24:56225 | DB: recherche | Command: Sleep | Time: 335 | State:
SQL:
ID: 7029410 | User: michael | Host: 100.64.0.214:55058 | DB: recherche | Command: Sleep | Time: 395 | State:
SQL:
ID: 7032352 | User: michael | Host: 100.64.0.214:51784 | DB: recherche | Command: Sleep | Time: 1 | State:
SQL:
ID: 7032361 | User: michael | Host: 100.64.0.214:51810 | DB: recherche | Command: Execute | Time: 0 | State: Sending data
SQL: DELETE mt
FROM recherche.monitor_team_players_total mt
LEFT JOIN (
SELECT DISTINCT gps.team_id, gps.player_id
FROM liga1.game_player_stats gps
INNER JOIN liga1.viw_gameplans gp
ON gp.id = gps.game_id
) src
ON src.team_id = mt.team_id
AND src.player_id = mt.player_id
WHERE mt.league = 'BBL'
AND mt.round_code = 1
AND src.player_id IS NULL
ID: 7032375 | User: michael | Host: 100.64.0.214:51812 | DB: recherche | Command: Sleep | Time: 0 | State:
SQL:
ID: 7032430 | User: michael | Host: 100.64.0.214:51826 | DB: liga1 | Command: Query | Time: 0 | State: starting
SQL: SHOW FULL PROCESSLIST