SELECT * FROM 1_Kampe WHERE LigaID = '239' AND (Home='Zenit' OR Away='Zenit') ORDER BY Dato ASC;
Dato Home Score Away H Goals/Dif A Goals Av. H Avp/M H Avp Last/M H Avp Home/M H Avp Away/M   A Goals/Dif A Goals Av. A Avp/M A Avp Last/M A Avp Home/M A Avp Away/M
2018-07-29 Yenisey 0-2 Zenit 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-08-04 Zenit 1-0 Arsenal Tula 2/2 2,00 3.00/1 3.00/1 0.00/0 3.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-08-13 Rubin Kazan 0-1 Zenit 3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1   3/3 1,50 3.00/2 3.00/2 3.00/1 3.00/1
2018-08-19 Zenit 4-1 Ural 4/4 1,33 3.00/3 3.00/3 3.00/1 3.00/2   2/-2 2,00 0.33/3 0.33/3 0.33/3 0.00/0
2018-08-26 Ufa 0-2 Zenit 3/-1 1,75 1.00/4 1.00/4 1.33/3 0.00/1   8/7 2,25 3.00/4 3.00/4 3.00/2 3.00/2
2018-09-02 Zenit 0-0 Spartak Moscow 10/9 2,20 3.00/5 3.00/5 3.00/2 3.00/3   5/4 1,20 2.60/5 2.60/5 3.00/3 2.00/2
2018-09-16 Orenburg 1-2 Zenit 11/6 2,29 1.86/7 1.86/7 2.00/2 1.80/5   10/9 1,83 2.67/6 2.67/6 2.33/3 3.00/3
2018-09-23 Zenit 5-3 Lokomotiv Moscow 12/10 2,00 2.71/7 2.71/7 2.33/3 3.00/4   6/1 1,38 1.50/8 1.50/8 1.67/3 1.40/5
2018-09-30 FK Anzi Makhackala 2-1 Zenit 4/-11 2,11 0.67/9 0.38/8 0.00/2 0.86/7   17/12 2,75 2.75/8 2.75/8 2.50/4 3.00/4
2018-10-07 Zenit 2-1 Krasnodar 18/11 2,78 2.44/9 2.38/8 2.50/4 2.40/5   20/14 2,60 2.20/10 2.38/8 2.00/3 2.29/7
2018-10-21 Dynamo Moscow 1-0 Zenit 9/-2 1,82 0.91/11 0.88/8 1.75/4 0.43/7   20/12 2,80 2.50/10 2.38/8 2.60/5 2.40/5
2018-10-29 FK Krylya Sovetov Samara 0-1 Zenit 5/-10 1,82 1.00/11 0.88/8 1.17/6 0.80/5   20/11 2,64 2.27/11 2.00/8 2.60/5 2.00/6
2018-10-29 Krylya Sovetov 0-1 Zenit 5/-10 1,82 1.00/11 0.88/8 1.17/6 0.80/5   21/12 2,50 2.33/12 2.00/8 2.60/5 2.14/7
2018-11-04 Zenit 1-0 Akhmat Grozny 22/13 2,38 2.38/13 2.00/8 2.60/5 2.25/8   10/-2 1,83 1.33/12 1.50/8 1.67/6 1.00/6
2018-11-11 CSKA Moscow 2-0 Zenit 17/10 1,71 1.50/14 1.75/8 1.17/6 1.75/8   23/14 2,29 2.43/14 2.25/8 2.67/6 2.25/8
2018-11-25 Zenit 2-0 FK Rostov 23/12 2,27 2.27/15 1.88/8 2.67/6 2.00/9   14/5 1,53 1.53/15 1.25/8 1.33/9 1.83/6
2018-12-03 Arsenal Tula 4-2 Zenit 23/2 2,75 1.25/16 1.13/8 1.78/9 0.57/7   25/14 2,25 2.31/16 1.88/8 2.71/7 2.00/9
2018-12-09 Zenit 1-2 Rubin Kazan 27/12 2,47 2.18/17 1.88/8 2.71/7 1.80/10   17/3 1,82 1.47/17 1.38/8 1.90/10 0.86/7
2019-03-02 Ural 0-1 Zenit 19/-10 2,67 1.28/18 1.50/8 1.40/10 1.13/8   28/11 2,50 2.06/18 1.50/8 2.38/8 1.80/10
2019-03-10 Zenit 2-1 Ufa 29/12 2,42 2.11/19 1.88/8 2.38/8 1.91/11   14/-8 1,89 0.84/19 0.75/8 1.00/11 0.63/8
2019-03-17 Spartak Moscow 1-1 Zenit 27/8 2,30 1.75/20 2.00/8 1.73/11 1.78/9   31/13 2,45 2.15/20 1.88/8 2.44/9 1.91/11
2019-03-31 Zenit 3-1 Orenburg 32/13 2,43 2.10/21 1.63/8 2.44/9 1.83/12   23/5 2,05 1.45/20 1.38/8 1.56/9 1.36/11
2019-04-07 Lokomotiv Moscow 1-1 Zenit 32/11 2,30 1.83/23 1.75/8 2.00/11 1.67/12   35/15 2,50 2.14/22 1.63/8 2.50/10 1.83/12
2019-04-14 Zenit 5-0 FK Anzi Makhackala 36/15 2,48 2.09/23 1.75/8 2.50/10 1.77/13   11/-27 2,04 0.79/24 0.63/8 0.75/12 0.83/12
2019-04-20 Krasnodar 2-3 Zenit 45/27 2,52 1.92/25 1.63/8 2.08/13 1.75/12   41/20 2,58 2.13/24 1.75/8 2.55/11 1.77/13
2019-04-24 Zenit 2-0 Dynamo Moscow 44/21 2,68 2.16/25 2.13/8 2.55/11 1.86/14   22/2 1,62 1.19/26 1.38/8 1.62/13 0.77/13
2019-04-28 Zenit 4-2 FK Krylya Sovetov Samara 46/23 2,65 2.19/26 2.50/8 2.58/12 1.86/14   20/-11 2,04 1.08/25 1.13/8 1.23/13 0.92/12
2019-04-28 Zenit 4-2 Krylya Sovetov 50/25 2,78 2.22/27 2.50/8 2.62/13 1.86/14   20/-11 2,04 1.08/25 1.13/8 1.23/13 0.92/12
2019-05-04 Akhmat Grozny 1-1 Zenit 26/-2 2,00 1.41/27 1.50/8 1.25/12 1.53/15   54/27 2,89 2.25/28 2.50/8 2.64/14 1.86/14
2019-05-12 Zenit 3-1 CSKA Moscow 55/27 2,86 2.21/29 2.50/8 2.64/14 1.80/15   38/18 2,07 1.64/28 1.50/8 1.62/13 1.67/15
2019-05-19 FK Rostov 1-0 Zenit 24/0 1,60 1.27/30 1.13/8 1.40/15 1.13/15   58/29 2,90 2.23/30 2.50/8 2.67/15 1.80/15
2019-05-26 Zenit 4-1 Yenisey 58/28 2,84 2.16/31 2.38/8 2.67/15 1.69/16   24/-31 2,55 0.74/31 1.00/8 1.19/16 0.27/15