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

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


ΤΣΑΝΗ ΓΕΩΡΓΙΟΣ

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

Πληροφορίες

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


Στατιστικά

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

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

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

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

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 = '5084' ORDER BY period.startDate DESC, startDateTime.