אין תקציר עריכה |
אין תקציר עריכה |
||
| שורה 18: | שורה 18: | ||
|fields= | |fields= | ||
CONCAT('[[עונת_', Football_Games.Season, ']]')=Season, | CONCAT('[[עונת_', Football_Games.Season, ']]')=Season, | ||
SUM(CASE when Games_Events.EventType=5 then 1 else 0 end)=Substitutions, | ROUND(SUM(CASE when Games_Events.EventType=5 then 1 else 0 end), 0)=Substitutions, | ||
SUM(CASE when Games_Events.EventType=3 AND Games_Events.SubType!=33 then 1 else 0 end)=Goals, | SUM(CASE when Games_Events.EventType=3 AND Games_Events.SubType!=33 then 1 else 0 end)=Goals, | ||
SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | SUM(CASE when Games_Events.SubType=35 then 1 else 0 end)=GoalsPenalties, | ||
גרסה מ־02:17, 16 באפריל 2023
אירועים לפי עונה
| Season | Substitutions | Goals | GoalsPenalties | Assists | YellowCards | RedCards |
|---|---|---|---|---|---|---|
| Season | Substitutions | Goals | GoalsPenalties | Assists | YellowCards | RedCards |
| עונת_1922 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| עונת_1925 | 0 | 2.0 | 0.0 | 1.0 | 0.0 | 0.0 |
| עונת_1926 | 1 | 16.0 | 2.0 | 5.0 | 0.0 | 0.0 |
| עונת_1927 | 0 | 4.0 | 0.0 | 2.0 | 0.0 | 0.0 |
| עונת_1928 | 0 | 5.0 | 2.0 | 2.0 | 0.0 | 0.0 |
| עונת_1928/29 | 0 | 9.0 | 1.0 | 0.0 | 0.0 | 0.0 |
| עונת_1929/30 | 0 | 5.0 | 0.0 | 1.0 | 0.0 | 0.0 |
| עונת_1930/31 | 0 | 8.0 | 0.0 | 1.0 | 0.0 | 0.0 |
| עונת_1931/32 | 0 | 13.0 | 1.0 | 1.0 | 0.0 | 2.0 |
| עונת_1932/33 | 0 | 1.0 | 0.0 | 1.0 | 0.0 | 0.0 |
| עונת_1933/34 | 0 | 16.0 | 3.0 | 0.0 | 0.0 | 0.0 |
| עונת_1934/35 | 0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| עונת_1935/36 | 4 | 53.0 | 2.0 | 3.0 | 0.0 | 1.0 |
| עונת_1937 | 0 | 39.0 | 1.0 | 3.0 | 0.0 | 1.0 |
| עונת_1938 | 1 | 51.0 | 4.0 | 4.0 | 0.0 | 1.0 |
| עונת_1939 | 10 | 123.0 | 4.0 | 10.0 | 0.0 | 2.0 |
| עונת_1940 | 0 | 66.0 | 3.0 | 3.0 | 0.0 | 1.0 |
| עונת_1941 | 0 | 12.0 | 0.0 | 3.0 | 0.0 | 0.0 |
| עונת_1941/42 | 0 | 58.0 | 2.0 | 1.0 | 0.0 | 1.0 |
| עונת_1943/44 | 0 | 53.0 | 2.0 | 3.0 | 0.0 | 0.0 |
| עונת_1944/45 | 1 | 23.0 | 0.0 | 4.0 | 0.0 | 0.0 |
| עונת_1945/46 | 0 | 33.0 | 2.0 | 2.0 | 0.0 | 0.0 |
| עונת_1946/47 | 1 | 113.0 | 4.0 | 6.0 | 0.0 | 3.0 |
| עונת_1949/50 | 2 | 119.0 | 5.0 | 13.0 | 0.0 | 9.0 |
| עונת_1950/51 | 0 | 32.0 | 0.0 | 1.0 | 0.0 | 2.0 |
| עונת_1951/52 | 0 | 96.0 | 5.0 | 3.0 | 0.0 | 1.0 |
| עונת_1953/54 | 0 | 70.0 | 3.0 | 6.0 | 0.0 | 1.0 |
| עונת_1955 | 0 | 107.0 | 6.0 | 45.0 | 0.0 | 4.0 |
| עונת_1955/56 | 0 | 46.0 | 3.0 | 22.0 | 0.0 | 1.0 |
| עונת_1956/57 | 0 | 45.0 | 1.0 | 35.0 | 0.0 | 3.0 |
| עונת_1957/58 | 0 | 62.0 | 4.0 | 37.0 | 0.0 | 0.0 |
| עונת_1958/59 | 0 | 57.0 | 5.0 | 34.0 | 0.0 | 3.0 |
| עונת_1959/60 | 0 | 62.0 | 3.0 | 25.0 | 0.0 | 0.0 |
| עונת_1960/61 | 7 | 35.0 | 3.0 | 22.0 | 0.0 | 1.0 |
| עונת_1961/62 | 0 | 47.0 | 2.0 | 15.0 | 0.0 | 1.0 |
| עונת_1962/63 | 0 | 24.0 | 4.0 | 3.0 | 0.0 | 0.0 |
| עונת_1963/64 | 0 | 69.0 | 4.0 | 10.0 | 0.0 | 1.0 |
| עונת_1964/65 | 0 | 68.0 | 6.0 | 9.0 | 0.0 | 3.0 |
| עונת_1965/66 | 24 | 55.0 | 4.0 | 11.0 | 0.0 | 4.0 |
| עונת_1966/68 | 48 | 97.0 | 5.0 | 17.0 | 0.0 | 4.0 |
| עונת_1968/69 | 32 | 69.0 | 0.0 | 22.0 | 0.0 | 2.0 |
| עונת_1969/70 | 44 | 61.0 | 0.0 | 24.0 | 0.0 | 1.0 |
| עונת_1970/71 | 53 | 53.0 | 4.0 | 14.0 | 1.0 | 1.0 |
| עונת_1971/72 | 48 | 51.0 | 0.0 | 19.0 | 7.0 | 1.0 |
| עונת_1972/73 | 59 | 39.0 | 1.0 | 32.0 | 14.0 | 2.0 |
| עונת_1973/74 | 78 | 63.0 | 4.0 | 38.0 | 9.0 | 1.0 |
| עונת_1974/75 | 47 | 26.0 | 0.0 | 16.0 | 7.0 | 0.0 |
| עונת_1975/76 | 51 | 49.0 | 3.0 | 31.0 | 7.0 | 1.0 |
| עונת_1976/77 | 32 | 60.0 | 4.0 | 30.0 | 3.0 | 0.0 |
| עונת_1977/78 | 37 | 61.0 | 4.0 | 32.0 | 9.0 | 0.0 |
| עונת_1978/79 | 49 | 65.0 | 2.0 | 47.0 | 12.0 | 0.0 |
| עונת_1979/80 | 44 | 41.0 | 3.0 | 24.0 | 21.0 | 2.0 |
| עונת_1980/81 | 56 | 44.0 | 4.0 | 27.0 | 49.0 | 2.0 |
| עונת_1981/82 | 52 | 28.0 | 2.0 | 21.0 | 24.0 | 1.0 |
| עונת_1982/83 | 50 | 40.0 | 4.0 | 25.0 | 45.0 | 2.0 |
| עונת_1983/84 | 55 | 56.0 | 2.0 | 43.0 | 40.0 | 0.0 |
| עונת_1984/85 | 68 | 46.0 | 3.0 | 31.0 | 38.0 | 1.0 |
| עונת_1985/86 | 73 | 76.0 | 4.0 | 52.0 | 43.0 | 3.0 |
| עונת_1986/87 | 78 | 70.0 | 7.0 | 49.0 | 38.0 | 0.0 |
| עונת_1987/88 | 80 | 67.0 | 7.0 | 49.0 | 49.0 | 2.0 |
| עונת_1988/89 | 82 | 56.0 | 5.0 | 44.0 | 37.0 | 3.0 |
| עונת_1989/90 | 85 | 67.0 | 10.0 | 51.0 | 51.0 | 0.0 |
| עונת_1990/91 | 65 | 60.0 | 4.0 | 45.0 | 50.0 | 2.0 |
| עונת_1991/92 | 99 | 107.0 | 13.0 | 71.0 | 58.0 | 3.0 |
| עונת_1992/93 | 104 | 109.0 | 9.0 | 83.0 | 67.0 | 1.0 |
| עונת_1993/94 | 124 | 114.0 | 11.0 | 80.0 | 62.0 | 4.0 |
| עונת_1994/95 | 93 | 90.0 | 6.0 | 56.0 | 58.0 | 10.0 |
| עונת_1995/96 | 112 | 76.0 | 5.0 | 59.0 | 47.0 | 5.0 |
| עונת_1996/97 | 124 | 75.0 | 10.0 | 53.0 | 65.0 | 7.0 |
| עונת_1997/98 | 114 | 64.0 | 6.0 | 45.0 | 60.0 | 9.0 |
| עונת_1998/99 | 117 | 109.0 | 12.0 | 76.0 | 63.0 | 6.0 |
| עונת_1999/00 | 119 | 82.0 | 9.0 | 31.0 | 78.0 | 4.0 |
| עונת_2000/01 | 121 | 90.0 | 12.0 | 59.0 | 75.0 | 6.0 |
| עונת_2001/02 | 138 | 83.0 | 6.0 | 45.0 | 53.0 | 3.0 |
| עונת_2002/03 | 167 | 105.0 | 11.0 | 48.0 | 60.0 | 6.0 |
| עונת_2003/04 | 130 | 46.0 | 1.0 | 29.0 | 78.0 | 10.0 |
| עונת_2004/05 | 160 | 64.0 | 6.0 | 33.0 | 102.0 | 7.0 |
| עונת_2005/06 | 153 | 53.0 | 9.0 | 34.0 | 76.0 | 11.0 |
| עונת_2006/07 | 134 | 57.0 | 4.0 | 42.0 | 96.0 | 4.0 |
| עונת_2007/08 | 143 | 58.0 | 0.0 | 50.0 | 76.0 | 4.0 |
| עונת_2008/09 | 138 | 48.0 | 0.0 | 39.0 | 95.0 | 9.0 |
| עונת_2009/10 | 148 | 71.0 | 2.0 | 54.0 | 73.0 | 7.0 |
| עונת_2010/11 | 165 | 76.0 | 7.0 | 57.0 | 116.0 | 4.0 |
| עונת_2011/12 | 168 | 84.0 | 4.0 | 64.0 | 117.0 | 7.0 |
| עונת_2012/13 | 169 | 103.0 | 9.0 | 72.0 | 83.0 | 3.0 |
| עונת_2013/14 | 179 | 92.0 | 11.0 | 64.0 | 103.0 | 4.0 |
| עונת_2014/15 | 209 | 114.0 | 13.0 | 79.0 | 103.0 | 5.0 |
| עונת_2015/16 | 195 | 114.0 | 16.0 | 80.0 | 121.0 | 6.0 |
| עונת_2016/17 | 215 | 103.0 | 8.0 | 80.0 | 133.0 | 3.0 |
| עונת_2017/18 | 194 | 93.0 | 11.0 | 62.0 | 126.0 | 6.0 |
| עונת_2018/19 | 192 | 109.0 | 8.0 | 77.0 | 88.0 | 4.0 |
| עונת_2019/20 | 196 | 79.0 | 7.0 | 58.0 | 78.0 | 2.0 |
| עונת_2020/21 | 255 | 92.0 | 15.0 | 74.0 | 114.0 | 6.0 |
| עונת_2021/22 | 287 | 98.0 | 7.0 | 69.0 | 101.0 | 7.0 |
| עונת_2022/23 | 242 | 96.0 | 6.0 | 77.0 | 98.0 | 8.0 |
| עונת_2023/24 | 252 | 121.0 | 14.0 | 89.0 | 105.0 | 1.0 |
| עונת_2024/25 | 245 | 114.0 | 13.0 | 87.0 | 121.0 | 5.0 |
| עונת_2025/26 | 91 | 33.0 | 6.0 | 29.0 | 37.0 | 2.0 |