Accueil Contactez-nous Administration
U13F-026
Inscriptions
Date
2019-08-28 @ 18:30

Type de partie
Grande finale

Terrain
Synthétique

Équipe A
(Gagnant OR Ste-Julie)SELECT COALESCE(SUM(gc.qty),0) FROM gamecard gc JOIN registration r ON r.registrationid=gc.registrationid WHERE gc.gameid=10484 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=10484 AND gc.color='Y' AND r.teamid=
Cartons jaunes :

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