SELECT * FROM 1_Kampe WHERE LigaID = '241' 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
2016-07-30 Zenit 0-0 Lokomotiv Moscow 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
2016-08-06 Ufa 0-0 Zenit 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2016-08-12 Zenit 3-2 FK Rostov 0/0 0,00 1.00/2 1.00/2 1.00/1 1.00/1   1/1 0,50 2.00/2 2.00/2 2.00/2 0.00/0
2016-08-20 Zenit 1-1 CSKA Moscow 3/1 1,67 1.67/3 1.67/3 2.00/2 1.00/1   2/2 0,67 2.33/3 2.33/3 0.00/0 2.33/3
2016-08-27 Zenit 3-0 Amkar 4/1 1,75 1.50/4 1.50/4 1.67/3 1.00/1   3/3 0,75 2.00/4 2.00/4 3.00/2 1.00/2
2016-09-11 Arsenal Tula 0-5 Zenit 2/-4 1,60 1.00/5 1.00/5 2.00/2 0.33/3   7/4 2,00 1.80/5 1.80/5 2.00/4 1.00/1
2016-09-19 Zenit 4-1 Rubin Kazan 12/9 2,50 2.00/6 2.00/6 2.00/4 2.00/2   6/0 2,00 1.00/6 1.00/6 1.25/4 0.50/2
2016-09-25 FK Anzi Makhackala 2-2 Zenit 4/-1 1,29 1.57/7 1.57/7 1.33/3 1.75/4   16/12 2,86 2.14/7 2.14/7 2.20/5 2.00/2
2016-10-02 Zenit 4-2 Spartak Moscow 18/12 3,00 2.00/8 2.00/8 2.20/5 1.67/3   14/11 2,13 2.38/8 2.38/8 2.40/5 2.33/3
2016-10-16 Ural 0-2 Zenit 6/-2 1,56 1.00/9 0.75/8 1.00/4 1.00/5   22/14 3,33 2.11/9 2.25/8 2.33/6 1.67/3
2016-10-24 Zenit 1-0 Orenburg 24/16 3,20 2.20/10 2.50/8 2.33/6 2.00/4   6/-4 1,60 0.70/10 0.88/8 0.86/7 0.33/3
2016-10-30 Zenit 1-0 Tomsk 25/17 3,00 2.27/11 2.50/8 2.43/7 2.00/4   7/-12 2,36 0.73/11 0.50/8 1.40/5 0.17/6
2016-11-06 Akhmat Grozny 2-1 Zenit 17/1 2,75 1.75/12 1.75/8 2.17/6 1.33/6   26/18 2,83 2.33/12 2.75/8 2.50/8 2.00/4
2016-11-20 Zenit 3-1 Krylya Sovetov 27/17 2,85 2.15/13 2.38/8 2.50/8 1.60/5   8/-8 1,85 0.62/13 0.75/8 1.00/6 0.29/7
2016-11-27 Krasnodar 2-1 Zenit 20/10 2,14 1.71/14 2.00/8 2.38/8 0.83/6   30/19 2,93 2.21/14 2.38/8 2.56/9 1.60/5
2016-11-30 Zenit 2-0 Ufa 31/18 2,93 2.07/15 2.00/8 2.56/9 1.33/6   11/0 1,47 1.47/15 1.75/8 1.00/7 1.88/8
2016-12-03 FK Rostov 0-0 Zenit 19/7 1,94 1.50/16 1.38/8 2.75/8 0.25/8   33/20 2,88 2.13/16 2.25/8 2.60/10 1.33/6
2017-03-04 CSKA Moscow 0-0 Zenit 21/10 1,88 1.88/17 1.75/8 2.14/7 1.70/10   33/20 2,71 2.06/17 2.00/8 2.60/10 1.29/7
2017-03-12 Amkar 1-0 Zenit 16/3 1,61 1.50/18 1.25/8 2.50/8 0.70/10   33/20 2,56 2.00/18 1.75/8 2.60/10 1.25/8
2017-03-19 Zenit 2-0 Arsenal Tula 33/19 2,47 1.89/19 1.38/8 2.60/10 1.11/9   8/-18 1,79 0.79/19 0.75/8 1.33/9 0.30/10
2017-04-02 Rubin Kazan 0-2 Zenit 21/1 2,05 1.35/20 1.50/8 1.90/10 0.80/10   35/21 2,45 1.95/20 1.38/8 2.64/11 1.11/9
2017-04-08 Zenit 1-1 FK Anzi Makhackala 37/23 2,43 2.00/21 1.75/8 2.64/11 1.30/10   16/-7 1,86 1.10/21 0.75/8 1.18/11 1.00/10
2017-04-16 Spartak Moscow 2-1 Zenit 36/17 2,50 2.32/22 2.13/8 2.73/11 1.91/11   38/23 2,41 1.95/22 1.50/8 2.50/12 1.30/10
2017-04-22 Zenit 2-0 Ural 39/22 2,43 1.87/23 1.50/8 2.50/12 1.18/11   19/-10 2,09 1.26/23 2.25/8 1.58/12 0.91/11
2017-04-26 Orenburg 0-1 Zenit 20/-9 2,04 0.92/24 1.25/8 1.45/11 0.46/13   41/24 2,42 1.92/24 1.50/8 2.54/13 1.18/11
2017-05-01 Tomsk 0-2 Zenit 15/-37 2,68 0.56/25 0.63/8 1.00/11 0.21/14   42/25 2,36 1.96/25 1.75/8 2.54/13 1.33/12
2017-05-07 Zenit 0-1 Akhmat Grozny 44/27 2,35 2.00/26 2.00/8 2.54/13 1.46/13   32/2 2,38 1.50/26 1.38/8 1.73/15 1.18/11
2017-05-13 Krylya Sovetov 1-3 Zenit 27/-6 2,22 0.93/27 1.25/8 1.23/13 0.64/14   44/26 2,30 1.93/27 2.00/8 2.36/14 1.46/13
2017-05-17 Zenit 1-0 Krasnodar 47/28 2,36 1.96/28 2.00/8 2.36/14 1.57/14   35/15 1,96 1.64/28 1.63/8 2.00/15 1.23/13
2017-05-21 Lokomotiv Moscow 0-2 Zenit 39/14 2,21 1.45/29 1.50/8 1.36/14 1.53/15   48/29 2,31 2.00/29 2.00/8 2.40/15 1.57/14
2018-10-21 FK Krylya Sovetov Samara 1-3 Zenit 33/-2 4,00 1.41/17 1.88/8 0.00/9 3.00/8   50/31 2,30 2.03/30 2.25/8 2.40/15 1.67/15
2018-10-21 Zenit 1-3 FK Krylya Sovetov Samara 53/33 2,35 2.06/31 2.25/8 2.40/15 1.75/16   1/-2 4,00 0.00/1 1.88/8 0.00/1 0.00/0