Date
2019-07-22 @ 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=10398 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=10398 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=10398 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=10398 AND gc.color='Y' AND r.teamid=
Cartons jaunes :