Μαρκούτσος Πέτρος
Ημιχρονο Sport
Ψητοπωλείο Παρθενών
Χυμοί Λακωνίας
Petroulis
Τεντοεξελιξη
Λέσχη Σπάρτης Σύμμετρον
Δημάκος
ΒΙΛΛΙΑΣ Γ. - ΝΤΟΒΟΛΟΣ Ι. Ο.Ε
Navis
Lampa
Πλαίσιο
ΑΓΡΟΤΙΚΟΣ ΣΥΝΕΤΑΙΡΙΣΜΟΣ ΜΟΛΑΩΝ ΠΑΚΙΩΝ
wecare-ambulance
Ταυγετος
Ανούσος

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


Λεπτομέρειες Αγώνα Περιόδου 2017-2018
Β΄ Κατηγορία
11η Αγωνιστική



Π.Α.Ο.ΚΟΚΚΙΝΟΡΑΧΗΣ-ΤΑΫΓΕΤΟΣ ΠΑΛΑΙΟΠΑΝΑΓΙΑΣ

1 - 0

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


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 = '8') - birthdate as age, CONCAT(( SELECT minute FROM substitution WHERE substitution.playerOutID = participation.playerID AND gameID = '7009' ), '\'') as minuteOut, CONCAT(( SELECT minute FROM substitution WHERE substitution.playerInID = participation.playerID AND gameID = '7009' ), '\'') 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 = '7009' AND player_team.teamID = '35' AND player_team.periodID = '8' AND player_team.date_from <= '2018-01-07' AND player_team.date_to >= '2018-01-07' AND started = '1' ORDER BY started DESC, participationID.