ΑΛΙΒΙΖΑΤΟΣ ΧΑΡΗΣ
Πληροφορίες
Στατιστικά
Α.Ο.Κ.Ι., αγωνιστική περίοδος 2023-2024
Error in query: SELECT
SUM(minutes) as minutes
FROM (
(
SELECT playerID,
CAST(duration AS SIGNED) as minutes
FROM game, participation, league
WHERE game.gameID = participation.gameID
AND game.leagueID = league.leagueID
AND periodID = '12'
AND finished = '1'
AND wout_play = '0'
AND started = '1'
)
UNION ALL
(
SELECT playerOutID,
IF(CAST(minute-duration-1 AS SIGNED)>0, 0, CAST(minute-duration-1 AS SIGNED)) as minutes
FROM game, substitution, league
WHERE game.gameID = substitution.gameID
AND game.leagueID = league.leagueID
AND periodID = '12'
AND finished = '1'
AND wout_play = '0'
)
UNION ALL
(
SELECT playerInID,
IF(CAST(duration-minute+1 AS SIGNED)<0, 0, CAST(duration-minute+1 AS SIGNED)) as minutes
FROM game, substitution, league
WHERE game.gameID = substitution.gameID
AND game.leagueID = league.leagueID
AND periodID = '12'
AND finished = '1'
AND wout_play = '0'
)
UNION ALL
(
SELECT playerID,
IF(CAST(minute-duration AS SIGNED)>0, 0, CAST(minute-duration AS SIGNED)) as minutes
FROM game, card, league
WHERE game.gameID = card.gameID
AND game.leagueID = league.leagueID
AND periodID = '12'
AND finished = '1'
AND wout_play = '0'
AND (color='secYellow' OR color='red')
)
) as minutes, player
WHERE player.playerID = minutes.playerID
AND player.playerID = '3753'.
