SELECT r.*, y.* FROM roster ro join clubgameyellowcards y ON y.RosterID = ro.RosterID JOIN clubgameredcards r ON r.GameID = y.GameID JOIN fixtures f ON f.FixtureID = y.GameID WHERE ro.RosterID = 142958 AND y.RosterID = 142958 AND r.RosterID = 142958 AND r.SecondYellow = 0 AND f.CompetitionStageID = 1425256 AND ro.Privacy = 0SELECT cgr.SecondYellow FROM clubgameredcards cgr left JOIN fixtures f ON f.FixtureID = cgr.GameID JOIN competitionstages cs ON cs.CompetitionStageID = f.CompetitionStageID JOIN competitions c ON c.CompetitionID = cs.CompetitionID WHERE cgr.RosterID = 142958 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 1425256NO: 0SELECT r.*, y.* FROM roster ro join clubgameyellowcards y ON y.RosterID = ro.RosterID JOIN clubgameredcards r ON r.GameID = y.GameID JOIN fixtures f ON f.FixtureID = y.GameID WHERE ro.RosterID = 142958 AND y.RosterID = 142958 AND r.RosterID = 142958 AND r.SecondYellow = 0 AND f.CompetitionStageID = 1498426 AND ro.Privacy = 0SELECT cgr.SecondYellow FROM clubgameredcards cgr left JOIN fixtures f ON f.FixtureID = cgr.GameID JOIN competitionstages cs ON cs.CompetitionStageID = f.CompetitionStageID JOIN competitions c ON c.CompetitionID = cs.CompetitionID WHERE cgr.RosterID = 142958 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 1498426NO: 1 Cyprus Football Association - Official Website

DIMITRIS MANDRITIS

Team AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’
Birthdate: 11/08/1986
lblCyprusClubJoinDate 01/09/2013
Shirt Number
15

ROSTER STATS 2013-2014

  • App : Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14
  • App : 4
  • As Substitute : 0
  • From Start : 4
  • : 0
  • Own : 0
  • 0
  • : 1
  • Minutes : 184

Player Record

Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14

Matches M I O
AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’
8 - 5
APEP Pelendrίou 		60'
STAIRAETOS AGLANTZIAS
3 - 3
AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’ 		4' 4'
AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’
6 - 3
E.N.A. ATHIAINOU 		60'
ELPIDA ASTROMERITI
4 - 3
AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’ 		60'
Team AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’
Birthdate: 11/08/1986
lblCyprusClubJoinDate 01/09/2013
Shirt Number
15

ROSTER STATS 2013-2014
Competition App As Substitute From Start Own Minutes
Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14 4 0 4 0 0 0 1 184
ΚΥΠΕΛΛΟ FUTSAL 2013-2014 Β ΦΑΣΗ 1 0 0 0 0 1 0 0

Player Record

Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14

Date Competition Home Team H    A Away Team Minutes In Out
23-01-2014 Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14 AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’ 8   5 APEP Pelendrίou 60'
30-01-2014 Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14 STAIRAETOS AGLANTZIAS 3   3 AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’ 4' 4'
07-03-2014 Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14 AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’ 6   3 E.N.A. ATHIAINOU 60'
27-03-2014 Παγκύπριο Πρωτάθλημα FUTSAL Β' Κατηγορίας 13/14 ELPIDA ASTROMERITI 4   3 AETOS SOLEAS FUTSAL ‘’FOIVOS IOANNOU’’ 60'



Αχαιών 10 2413 - Έγκωμη Λευκωσία Κύπρος

Tel. : +357 22352341 , +357 77771606

Fax : +357 22590544

Postal Address : Τ.Θ. 25071, 1306 - Λευκωσία Κύπρος

Email : info@cfa.com.cy

Ιστορικό

Οργανωτική Δομή

Επιτροπές

Πρώην Προέδροι

Σχολή Προπονητών

Ειδήσεις

Προγραμματισμένα Σεμινάρια

Διπλώματα Uefa

Ληψη Αρχείων

Previous Seasons

Subscribe to our Newsletter
Copyright © 2018 CFA | Privacy policy - Terms of Use - Cookie Policy | Developed and Hosted by Change your consent