BLUE STAR FERRIES
HELLENIC SEAWAYS
Επίσημο Fan Club της Εθνικής Ομάδας Ποδοσφαίρου
EKO
EIKONA
WINDOOR
MOLTEN
ΔΩΜΑΤΕΙΑ SOUL
ΠΕΡΙΦΕΡΕΙΑ ΝΟΤΙΟΥ ΑΙΓΑΙΟΥ
BIOCLEAN
AVANCE CAR RENTAL
HAUSBRANDT
SEAJETS
MINOAN LINES
FAST FERRIES
ZANTE FERRIES

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


ΑΛΜΠΑΝΗΣ ΧΑΡΑΛΑΜΠΟΣ

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

Πληροφορίες

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


Στατιστικά

Α.Ο. ΜΥΚΟΝΟΥ, αγωνιστική περίοδος 2019-2020

ΓκολΑυτογκόλΚίτρινεςΚόκκινεςΛεπτά συμμετοχής
0000218'
Γκολ κάθεΑυτογκόλ κάθεΚίτρινη κάθεΚόκκινη κάθε
----

Α.Ο. ΜΥΚΟΝΟΥ, αγωνιστική περίοδος 2018-2019

ΓκολΑυτογκόλΚίτρινεςΚόκκινεςΛεπτά συμμετοχής
2000388'
Γκολ κάθεΑυτογκόλ κάθεΚίτρινη κάθεΚόκκινη κάθε
194'---

Α.Ο. ΜΥΚΟΝΟΥ, αγωνιστική περίοδος 2017-2018

ΓκολΑυτογκόλΚίτρινεςΚόκκινεςΛεπτά συμμετοχής
6000565'
Γκολ κάθεΑυτογκόλ κάθεΚίτρινη κάθεΚόκκινη κάθε
94'---

Error in query: SELECT period.title as periodTitle, game.gameID, game.leagueID as league_id, league.title as leagueTitle, homeTeamID, ( SELECT team_titles.title FROM team_titles, period as inner_period WHERE inner_period.periodID = team_titles.period_id AND inner_period.periodID = period.periodID AND team_id = homeTeamID ) as homeTeamTitle, awayTeamID, ( SELECT team_titles.title FROM team_titles, period as inner_period WHERE inner_period.periodID = team_titles.period_id AND inner_period.periodID = period.periodID AND team_id = awayTeamID ) as awayTeamTitle, cancelled, interrupted, finished, homeGoals, awayGoals, extraTime, homeGoalsET, awayGoalsET, penaltyKick, homeGoalsPK, awayGoalsPK, CONCAT( '', CASE WHEN cancelled = 1 THEN 'Αναβλήθηκε' WHEN interrupted = 1 THEN 'Διακόπηκε' WHEN penaltyKick = 1 THEN CONCAT(homeGoalsET, '-', awayGoalsET, ' (πεν: ', homeGoalsPK, '-', awayGoalsPK, ')' ) WHEN extraTime = 1 THEN CONCAT(homeGoalsET, '-', awayGoalsET, ' παρ.') WHEN finished = 1 THEN CONCAT(homeGoals, '-', awayGoals) END, IF(wout_play, ' α.α.', ''), '' ) as result, started, DATE_FORMAT(startDateTime, '%d-%m-%y') as startDate, ( SELECT COUNT(goalID) FROM goal WHERE goal.gameID = game.gameID AND goal.playerID = participation.playerID AND owngoal = 0 AND penalty = 0 ) as goals, ( SELECT COUNT(goalID) FROM goal WHERE goal.gameID = game.gameID AND goal.playerID = participation.playerID AND owngoal = 0 AND penalty = 1 ) as penalties, ( SELECT COUNT(goalID) FROM goal WHERE goal.gameID = game.gameID AND goal.playerID = participation.playerID AND owngoal = 1 ) as owngoals, ( SELECT COUNT(cardID) FROM card WHERE card.gameID = game.gameID AND card.playerID = participation.playerID AND color = 'yellow' ) as yellowCards, ( SELECT COUNT(cardID) FROM card WHERE card.gameID = game.gameID AND card.playerID = participation.playerID AND color = 'secYellow' ) as secYellowCards, ( SELECT COUNT(cardID) FROM card WHERE card.gameID = game.gameID AND card.playerID = participation.playerID AND color = 'red' ) as redCards, ( SELECT COUNT(cardID) FROM card WHERE card.gameID = game.gameID AND card.playerID = participation.playerID AND color = 'blue' ) as blueCards, duration, ( SELECT minute FROM card WHERE card.gameID = game.gameID AND playerID = participation.playerID AND (color = 'red' OR color = 'secYellow') ) as redMinutes, ( SELECT minute FROM substitution WHERE substitution.gameID = game.gameID AND playerInID = participation.playerID ) as subInMinutes, ( SELECT minute FROM substitution WHERE substitution.gameID = game.gameID AND playerOutID = participation.playerID ) as subOutMinutes FROM game, period, league, participation WHERE game.leagueID = league.leagueID AND period.periodID = league.periodID AND participation.gameID = game.gameID AND league.publish = '1' AND playerID = '5747' ORDER BY period.startDate DESC, startDateTime.