תבנית:פרופיל כדורגל/הצגת סטטיסטיקה עונתית/איש צוות/שליפה: הבדלים בין גרסאות בדף

@@ שורה 31: / שורה 31: @@
 COUNT(CASE WHEN ge.SubType=35 AND ge.Team=1 THEN 1 ELSE NULL END)=Penalty Goals,
 COUNT(CASE WHEN ge.EventType=4 AND ge.Team=1 THEN 1 ELSE NULL END)=Assists,
-SUM(fg.ResultOpponent * (ge._ID = (SELECT MIN(_ID) FROM ge WHERE ge._pageName=fg._pageName))) = Total Opponent Goals
+SUM(fg.ResultOpponent) = Total Opponent Goals
 COUNT(CASE WHEN ge.SubType=35 AND ge.Team=0 THEN 1 ELSE NULL END)=Total Opponent Penalty Goals,
-COUNT(CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals,
+COUNT(DISTINCT CASE WHEN fg.ResultOpponent=0 THEN 1 ELSE NULL END)=Games Without Opponent Goals,
 COUNT(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card,
 COUNT(CASE WHEN ge.SubType=72 AND ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card,

גרסה מ־21:46, 17 ביוני 2025