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

ΓΙΩΡΓΟΣ ΧΑΡΗΣ

Team ΕΘΝΙΚΟΣ ΛΑΤΣΙΩΝ
Birthdate: 08/02/1999
Shirt Number
28

ROSTER STATS 2024 - 2025

  • App : Παγκύπριο Πρωτάθλημα Γ΄ Κατηγορίας 2024/25 - Α΄ Φάση
  • App : 0
  • As Substitute : 0
  • From Start : 0
  • : 0
  • Own : 0
  • 0
  • : 0
  • Minutes : 0
Team ΕΘΝΙΚΟΣ ΛΑΤΣΙΩΝ
Birthdate: 08/02/1999
Shirt Number
28

ROSTER STATS 2024 - 2025
Competition App As Substitute From Start Own Minutes
Παγκύπριο Πρωτάθλημα Γ΄ Κατηγορίας 2024/25 - Α΄ Φάση 0 0 0 0 0 0 0 0
Παγκύπριο Πρωτάθλημα Γ΄ Κατηγορίας 2024/25 - Β΄ Φάση Α΄ Όμιλος 0 0 0 0 0 0 0 0



Αχαιών 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