Accueil Contactez-nous Administration
U4M005
Inscriptions
Date
2019-06-17 @ 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=10393 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=10393 AND gc.color='Y' AND r.teamid=
Cartons jaunes :

Équipe B
(4 ans)SELECT COALESCE(SUM(gc.qty),0) FROM gamecard gc JOIN registration r ON r.registrationid=gc.registrationid WHERE gc.gameid=10393 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=10393 AND gc.color='Y' AND r.teamid=
Cartons jaunes :