Ristretto Cafe - Coffee Mill
Mirabel CityCenter Hotel
IONION P. LINES

Επισκέπτες αυτή τη στιγμή:


ΜΠΑΣΔΕΚΗΣ ΙΩΑΝΝΗΣ

Πρώτο Προηγούμενο 2790 από 4368 Επόμενο Τελευταίο

Πληροφορίες

Έτος Γέννησης: 1992
Σωματείο: ΑΠΣ ΠΥΛΑΡΙΑΚΟΣ


Στατιστικά

ΑΠΣ ΠΥΛΑΡΙΑΚΟΣ, αγωνιστική περίοδος 2024-2025

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 = '13' 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 = '13' 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 = '13' 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 = '13' AND finished = '1' AND wout_play = '0' AND (color='secYellow' OR color='red') ) ) as minutes, player WHERE player.playerID = minutes.playerID AND player.playerID = '3931'.