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 = 12590006 AND y.RosterID = 12590006 AND r.RosterID = 12590006 AND r.SecondYellow = 0 AND f.CompetitionStageID = 46259039 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 = 12590006 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 46259039NO: 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 = 12590006 AND y.RosterID = 12590006 AND r.RosterID = 12590006 AND r.SecondYellow = 0 AND f.CompetitionStageID = 47105481 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 = 12590006 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 47105481NO: 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 = 12590006 AND y.RosterID = 12590006 AND r.RosterID = 12590006 AND r.SecondYellow = 0 AND f.CompetitionStageID = 47235839 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 = 12590006 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 47235839NO: 1SELECT 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 = 12590006 AND y.RosterID = 12590006 AND r.RosterID = 12590006 AND r.SecondYellow = 0 AND f.CompetitionStageID = 47699403 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 = 12590006 AND c.SeasonID = 75 AND cgr.GameID = f.FixtureID AND cs.CompetitionStageID = 47699403NO: 1 Cyprus Football Association - Official Website

ΡΑΦΑΗΛ ΔΗΜΗΤΡΙΟΥ

Team THOI PIRGOU
Birthdate: 18/06/1993
Shirt Number
8

ROSTER STATS 2021 - 2022

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

Player Record

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

Matches M I O
K.N. AEK KALAVASOU
0 - 3
THOI PIRGOU 		63' 63'
K.N. PRASTEIOU
2 - 3
THOI PIRGOU 		59' 59'
A.O. THIELLA AG. THEODOROU LARNAKAS
2 - 1
THOI PIRGOU 		74' 74' 31'
ΑΝΟΡΘΩΣΙΣ ΜΟΥΤΤΑΓΙΑΚΑΣ
2 - 0
THOI PIRGOU 		0' 46' 0'
Team THOI PIRGOU
Birthdate: 18/06/1993
Shirt Number
8

ROSTER STATS 2021 - 2022
Competition App As Substitute From Start Own Minutes
Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 - Α΄ Φάση 1 0 1 0 0 0 0 63
Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 - Β΄ Φάση 1 0 1 0 0 0 0 59
Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 - Προημιτελική Φάση 1 0 1 0 0 1 0 74
Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 - Αγώνες Κατάταξης (Θέσεις 5-8) 1 0 1 0 0 1 1 0

Player Record

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

Date Competition Home Team H    A Away Team Minutes In Out
14-05-2022 Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 K.N. AEK KALAVASOU 0   3 THOI PIRGOU 63' 63'
18-05-2022 Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 K.N. PRASTEIOU 2   3 THOI PIRGOU 59' 59'
25-05-2022 Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 A.O. THIELLA AG. THEODOROU LARNAKAS 2   1 THOI PIRGOU 74' 74' 31'
04-06-2022 Πρωτάθλημα Ένταξης ΣΤΟΚ 2021/22 ΑΝΟΡΘΩΣΙΣ ΜΟΥΤΤΑΓΙΑΚΑΣ 2   0 THOI PIRGOU 0' 46' 0'



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