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 = 210406 AND y.RosterID = 210406 AND r.RosterID = 210406 AND r.SecondYellow = 0 AND f.CompetitionStageID = 7579469 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 = 210406 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 7579469NO: 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 = 210406 AND y.RosterID = 210406 AND r.RosterID = 210406 AND r.SecondYellow = 0 AND f.CompetitionStageID = 7681344 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 = 210406 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 7681344NO: 0 Cyprus Football Association - Official Website

GIORGOS MICHAEL

Team TROULLOI FC 2015
Birthdate: 03/11/1995
lblCyprusClubJoinDate 07/09/2017
Shirt Number
20

ROSTER STATS 2017-2018

  • App : Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18 - Β΄ Φάση
  • App : 1
  • As Substitute : 0
  • From Start : 1
  • : 0
  • Own : 0
  • 0
  • : 0
  • Minutes : 90

Player Record


Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18

Matches M I O
TROULLOI FC 2015
6 - 2
Α.Σ. ΜΑΝΔΡΙΩΝ
90'
TROULLOI FC 2015
0 - 1
ASPIS PILAS
54' 54'
Team TROULLOI FC 2015
Birthdate: 03/11/1995
lblCyprusClubJoinDate 07/09/2017
Shirt Number
20

ROSTER STATS 2017-2018
Competition App As Substitute From Start Own Minutes
Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18 - Β΄ Φάση 1 0 1 0 0 0 0 90
Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18 - Γ΄ Φάση 1 0 1 0 0 0 1 54

Player Record


Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18

Date Competition Home Team H    A Away Team Minutes In Out
13-05-2018 Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18 TROULLOI FC 2015 6   2 Α.Σ. ΜΑΝΔΡΙΩΝ 90'
20-05-2018 Πρωτάθλημα Ένταξης ΣΤΟΚ 2017/18 TROULLOI FC 2015 0   1 ASPIS PILAS 54' 54'



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

Tel. : +357 22352341 , +357 77771606

Fax : +357 22590544

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

Email : info@cfa.com.cy

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