Accueil Contactez-nous Administration
U6F-003
Inscriptions
Date
2019-06-05 @ 18:00

Type de partie
Saison régulière non cumulatif

Terrain
N.P. Lapierre

Équipe A
(Ecole de soccer)SELECT COALESCE(SUM(gc.qty),0) FROM gamecard gc JOIN registration r ON r.registrationid=gc.registrationid WHERE gc.gameid=10367 AND gc.color='R' AND r.teamid=
Cartons rouges : SELECT COALESCE(SUM(gc.qty),0) FROM gamecard gc JOIN registration r ON r.registrationid=gc.registrationid WHERE gc.gameid=10367 AND gc.color='Y' AND r.teamid=
Cartons jaunes :

Équipe B
(6 ans)SELECT COALESCE(SUM(gc.qty),0) FROM gamecard gc JOIN registration r ON r.registrationid=gc.registrationid WHERE gc.gameid=10367 AND gc.color='R' AND r.teamid=
Cartons rouges : SELECT COALESCE(SUM(gc.qty),0) FROM gamecard gc JOIN registration r ON r.registrationid=gc.registrationid WHERE gc.gameid=10367 AND gc.color='Y' AND r.teamid=
Cartons jaunes :