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

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