Date
2019-07-02 @ 18:00Type de partie
Saison régulière non cumulatifTerrain
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=10383 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=10383 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=10383 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=10383 AND gc.color='Y' AND r.teamid=
Cartons jaunes :