Μπαράτσας
Hall of brands
Γκλινάβος
Παπαμάνος
Δωδώνη
Lexis Edu
Παπαδόπουλος Βικος

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


Λεπτομέρειες Αγώνα Περιόδου 2019-2020
Hall of brands Ε.Π.Σ.ΗΠ. Α Κατηγορια 2019-20
6η Αγωνιστική



Α.Ο.ΚΟΣΜΗΡΑΣ-Π.Α.Σ.ΜΕΤΣΟΒΟΥ

2 - 3

Διακύμανση Αποτελέσματος


Error in query: SELECT participation.playerID as player_id, player_team.teamID as playerTeam_id, CONCAT(surname, ' ', name) as onomateponimo, birthdate, (SELECT YEAR(startDate) FROM period WHERE periodID = '6') - birthdate as age, CONCAT(( SELECT minute FROM substitution WHERE substitution.playerOutID = participation.playerID AND gameID = '13454' ), '\'') as minuteOut, CONCAT(( SELECT minute FROM substitution WHERE substitution.playerInID = participation.playerID AND gameID = '13454' ), '\'') as minuteIn FROM game, participation, player, player_team WHERE game.gameID = participation.gameID AND participation.playerID = player.playerID AND player.playerID = player_team.playerID AND game.gameID = '13454' AND player_team.teamID = '47' AND player_team.periodID = '6' AND player_team.date_from <= '2019-10-27' AND player_team.date_to >= '2019-10-27' AND started = '0' ORDER BY started DESC, participationID.