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