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

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


ΛΙΒΙΕΡΑΤΟΣ ΕΛΕΥΘΕΡΙΟΣ

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

Πληροφορίες

Έτος Γέννησης: 2006
Σωματείο:


Στατιστικά

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

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