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 8/3 2,17 1.67/6 1.67/6 2.00/2 1.50/4   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   5/0 1,43 1.29/7 1.29/7 1.67/3 1.00/4
2018-09-30 FK Anzi Makhackala 2-1 Zenit 4/-10 2,25 0.75/8 0.75/8 0.00/2 1.00/6   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   17/11 2,56 2.11/9 2.38/8 2.00/3 2.17/6
2018-10-21 Zenit 1-3 FK Krylya Sovetov Samara 20/12 2,80 2.50/10 2.38/8 2.60/5 2.40/5   37/-2 4,00 1.42/19 1.13/8 0.00/10 3.00/9
2018-10-21 FK Krylya Sovetov Samara 1-3 Zenit 7/2 4,00 2.00/3 1.13/8 0.00/1 3.00/2   21/10 2,91 2.27/11 1.63/8 2.17/6 2.40/5
2018-10-21 Dynamo Moscow 1-0 Zenit 13/-1 2,25 1.08/12 1.25/8 1.40/5 0.86/7   24/12 3,00 2.33/12 1.63/8 2.17/6 2.50/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   24/11 2,85 2.15/13 1.63/8 2.17/6 2.14/7
2018-11-04 Zenit 1-0 Akhmat Grozny 25/12 2,71 2.21/14 1.88/8 2.17/6 2.25/8   14/-2 2,14 1.36/14 1.50/8 1.43/7 1.29/7
2018-11-11 CSKA Moscow 2-0 Zenit 21/10 2,13 1.53/15 1.38/8 1.00/7 2.00/8   26/13 2,60 2.27/15 1.88/8 2.29/7 2.25/8
2018-11-25 Zenit 2-0 FK Rostov 26/11 2,56 2.13/16 1.50/8 2.29/7 2.00/9   18/6 1,88 1.63/16 1.38/8 1.33/9 2.00/7
2018-12-03 Arsenal Tula 4-2 Zenit 23/-2 2,82 1.18/17 1.38/8 1.44/9 0.88/8   28/13 2,53 2.18/17 1.88/8 2.38/8 2.00/9
2018-12-09 Zenit 1-2 Rubin Kazan 30/11 2,72 2.06/18 1.50/8 2.38/8 1.80/10   19/2 2,00 1.39/18 1.00/8 1.60/10 1.13/8
2019-03-02 Ural 0-1 Zenit 22/-10 2,84 1.32/19 1.63/8 1.30/10 1.33/9   31/10 2,74 1.95/19 1.50/8 2.11/9 1.80/10
2019-03-10 Zenit 2-1 Ufa 32/11 2,65 2.00/20 1.88/8 2.11/9 1.91/11   17/-7 2,05 0.95/20 1.13/8 1.00/11 0.89/9
2019-03-17 Spartak Moscow 1-1 Zenit 28/6 2,38 1.67/21 1.75/8 1.45/11 1.90/10   34/12 2,67 2.05/21 1.88/8 2.20/10 1.91/11
2019-03-31 Zenit 3-1 Orenburg 35/12 2,64 2.00/22 1.63/8 2.20/10 1.83/12   24/2 2,19 1.38/21 1.38/8 1.40/10 1.36/11
2019-04-07 Lokomotiv Moscow 1-1 Zenit 33/10 2,43 1.78/23 1.75/8 1.91/11 1.67/12   38/14 2,70 2.04/23 1.63/8 2.27/11 1.83/12
2019-04-14 Zenit 5-0 FK Anzi Makhackala 39/14 2,67 2.00/24 1.75/8 2.27/11 1.77/13   15/-24 2,25 0.92/24 0.75/8 0.75/12 1.08/12
2019-04-20 Krasnodar 2-3 Zenit 45/23 2,68 1.80/25 1.63/8 1.85/13 1.75/12   44/19 2,76 2.04/25 1.75/8 2.33/12 1.77/13
2019-04-24 Zenit 2-0 Dynamo Moscow 47/20 2,85 2.08/26 2.13/8 2.33/12 1.86/14   25/2 1,85 1.19/26 1.38/8 1.38/13 1.00/13
2019-04-28 Zenit 4-2 Krylya Sovetov 49/22 2,81 2.11/27 2.50/8 2.38/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 28/-3 2,11 1.36/28 1.50/8 1.15/13 1.53/15   53/24 2,93 2.14/28 2.50/8 2.43/14 1.86/14
2019-05-12 Zenit 3-1 CSKA Moscow 54/24 2,90 2.10/29 2.25/8 2.43/14 1.80/15   42/18 2,28 1.66/29 1.50/8 1.50/14 1.80/15
2019-05-19 FK Rostov 1-0 Zenit 28/2 1,80 1.37/30 1.13/8 1.40/15 1.33/15   57/26 2,93 2.13/30 2.50/8 2.47/15 1.80/15
2019-05-26 Zenit 4-1 Yenisey 57/25 2,87 2.06/31 2.13/8 2.47/15 1.69/16   27/-28 2,65 0.74/31 1.00/8 1.00/16 0.47/15