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

ΙΑΚΩΒΟΣ ΙΩΑΝΝΟΥ

Team SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ
Birthdate: 30/05/1985
Shirt Number
3

ROSTER STATS 2020 - 2021

  • App : Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21
  • App : 4
  • As Substitute : 0
  • From Start : 4
  • : 4
  • Own : 0
  • 3
  • : 1
  • Minutes : 155

Player Record


Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21

Matches M I O
ΟΜΟΝΟΙΑ ΛΕΥΚΩΣΙΑΣ
6 - 3
SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ
40'
SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ
1 - 5
ΑΕΛ ΛΕΜΕΣΟΥ
35' 34' 35' 31'
ΟΜΟΝΟΙΑ ΛΕΥΚΩΣΙΑΣ
5 - 2
SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ
40'
SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ
1 - 2
AGBU ARARAT
40' 38'
Team SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ
Birthdate: 30/05/1985
Shirt Number
3

ROSTER STATS 2020 - 2021
Competition App As Substitute From Start Own Minutes
Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21 4 0 4 4 0 3 1 155
Κύπελλο Futsal Ανδρών 2020/21 - Α' Φάση 0 0 0 0 0 0 0 0

Player Record


Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21

Date Competition Home Team H    A Away Team Minutes In Out
17-12-2020 Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21 ΟΜΟΝΟΙΑ ΛΕΥΚΩΣΙΑΣ 6   3 SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ 40'
21-01-2021 Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21 SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ 1   5 ΑΕΛ ΛΕΜΕΣΟΥ 35' 34' 35' 31'
11-03-2021 Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21 ΟΜΟΝΟΙΑ ΛΕΥΚΩΣΙΑΣ 5   2 SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ 40'
25-03-2021 Παγκύπριο Πρωτάθλημα Futsal Ανδρών 2020/21 SKYLINK ΑΕΚ ΛΑΡΝΑΚΑΣ 1   2 AGBU ARARAT 40' 38'



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