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

@@ שורה 26: / שורה 26: @@
 {{#ifeq: {{{קטגוריית מפעל|}}}| רשמי| AND c.Official = 1 }}
 {{#ifeq: {{{קטגוריית מפעל|}}}| יתר-רשמיים| AND (c.Official = 1 AND c.League = 0 AND c.Trophy = 0 AND c.International = 0) }}
-|fields=fg.Season=Season, COUNT(*)=Total Games, COUNT(CASE WHEN fg.Technical=-1 AND ge.Team=1 ge.EventType=3 AND ge.SubType!=33 THEN 1 ELSE NULL END)=Total Goals, COUNT(CASE WHEN ge.SubType=35 AND he.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(ResultOpponent)=Total Opponent Goals, COUNT(CASE WHEN ge.SubType=35 AND he.Team=2 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(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card, COUNT(CASE WHEN ge.SubType=72 ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card, COUNT(CASE WHEN ge.SubType=73 ge.Team=1 THEN 1 ELSE NULL END)=Direct Red Card
+|fields=fg.Season=Season,
+COUNT(*)=Total Games,
+COUNT(CASE WHEN fg.Technical=-1 AND ge.Team=1 AND ge.EventType=3 AND ge.SubType!=33 THEN 1 ELSE NULL END)=Total Goals,
+COUNT(CASE WHEN ge.SubType=35 AND he.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(ResultOpponent)=Total Opponent Goals,
+COUNT(CASE WHEN ge.SubType=35 AND he.Team=2 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(CASE WHEN ge.SubType=71 AND ge.Team=1 THEN 1 ELSE NULL END)=First Yellow Card,
+COUNT(CASE WHEN ge.SubType=72 ge.Team=1 THEN 1 ELSE NULL END)=Second Yellow Card,
+COUNT(CASE WHEN ge.SubType=73 ge.Team=1 THEN 1 ELSE NULL END)=Direct Red Card
 |group by=Season
 |order by=Season DESC

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