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

CHARALAMPOS PITTAKAS

Team ΑΡΗΣ ΛΕΜΕΣΟΥ
Birthdate: 22/03/1982
Origin Country: CYPRUS
Nationality Country: CYPRUS
lblCyprusClubJoinDate 28/08/2012
Shirt Number
99

ROSTER STATS 2014-2015

  • App : Πρωτάθλημα Β΄ Κατηγορίας 14/15
  • App : 2
  • As Substitute : 2
  • From Start : 0
  • : 0
  • Own : 0
  • 0
  • : 0
  • Minutes : 14

Player Record


Πρωτάθλημα Β΄ Κατηγορίας 14/15

Matches M I O
DIGENIS OROKLINIS
0 - 1
ΑΡΗΣ ΛΕΜΕΣΟΥ
4' 86'
ΑΕΖ ΖΑΚΑΚΙΟΥ
1 - 0
ΑΡΗΣ ΛΕΜΕΣΟΥ
10' 80'

ΚΥΠΕΛΛΟ Α',Β' ΚΑΤΗΓΟΡΙΑΣ 14/15

Matches M I O
ΕΘΝΙΚΟΣ ΑΧΝΑΣ
3 - 0
ΑΡΗΣ ΛΕΜΕΣΟΥ
23' 67'
Team ΑΡΗΣ ΛΕΜΕΣΟΥ
Birthdate: 22/03/1982
Origin Country: CYPRUS
Nationality Country: CYPRUS
lblCyprusClubJoinDate 28/08/2012
Shirt Number
99

ROSTER STATS 2014-2015
Competition App As Substitute From Start Own Minutes
Πρωτάθλημα Β΄ Κατηγορίας 14/15 2 2 0 0 0 0 0 14
ΚΥΠΕΛΛΟ Α'-Β' / Α΄ Γύρος 1 1 0 0 0 0 0 23

Player Record


Πρωτάθλημα Β΄ Κατηγορίας 14/15

Date Competition Home Team H    A Away Team Minutes In Out
04-10-2014 Πρωτάθλημα Β΄ Κατηγορίας 14/15 DIGENIS OROKLINIS 0   1 ΑΡΗΣ ΛΕΜΕΣΟΥ 4' 86'
11-10-2014 Πρωτάθλημα Β΄ Κατηγορίας 14/15 ΑΕΖ ΖΑΚΑΚΙΟΥ 1   0 ΑΡΗΣ ΛΕΜΕΣΟΥ 10' 80'

ΚΥΠΕΛΛΟ Α',Β' ΚΑΤΗΓΟΡΙΑΣ 14/15

Date Competition Home Team H    A Away Team Minutes In Out
05-11-2014 ΚΥΠΕΛΛΟ Α',Β' ΚΑΤΗΓΟΡΙΑΣ 14/15 ΕΘΝΙΚΟΣ ΑΧΝΑΣ 3   0 ΑΡΗΣ ΛΕΜΕΣΟΥ 23' 67'



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