SELECT * FROM 1_Kampe WHERE LigaID = '244' 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
2013-07-17 Krasnodar 1-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
2013-07-21 Rubin Kazan 2-1 Zenit 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1
2013-07-26 Zenit 1-1 Kuban 3/0 3,00 1.50/2 1.50/2 0.00/0 1.50/2   3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1
2013-08-03 Volga N. Novgorod 1-3 Zenit 5/0 3,33 1.33/3 1.33/3 0.00/1 2.00/2   4/0 2,67 1.33/3 1.33/3 1.00/1 1.50/2
2013-08-17 Zenit 3-0 FK Anzi Makhackala 7/2 3,00 1.75/4 1.75/4 1.00/1 2.00/3   5/-2 2,40 0.60/5 0.60/5 0.50/2 0.67/3
2013-08-24 Dynamo Moscow 1-1 Zenit 7/-1 3,00 1.60/5 1.60/5 1.75/4 1.00/1   10/5 3,00 2.00/5 2.00/5 2.00/2 2.00/3
2013-09-01 Zenit 2-1 Lokomotiv Moscow 11/5 2,83 1.83/6 1.83/6 2.00/2 1.75/4   14/8 3,33 2.17/6 2.17/6 2.00/3 2.33/3
2013-09-14 Zenit 2-0 Akhmat Grozny 13/6 2,86 2.00/7 2.00/7 2.33/3 1.75/4   3/-4 1,43 0.43/7 0.43/7 0.75/4 0.00/3
2013-09-22 FK Rostov 0-4 Zenit 13/3 2,88 1.75/8 1.75/8 2.50/4 1.00/4   15/8 2,75 2.13/8 2.13/8 2.50/4 1.75/4
2013-09-25 FK Krylya Sovetov Samara 1-4 Zenit 7/-1 1,67 1.00/9 1.13/8 1.20/5 0.75/4   19/12 2,89 2.22/9 2.13/8 2.50/4 2.00/5
2013-09-25 Krylya Sovetov 1-4 Zenit 7/-1 1,67 1.00/9 1.13/8 1.20/5 0.75/4   23/15 3,10 2.30/10 2.75/8 2.50/4 2.17/6
2013-09-28 Zenit 4-2 Spartak Moscow 27/18 3,27 2.36/11 2.75/8 2.50/4 2.29/7   22/12 2,91 2.36/11 2.13/8 2.50/4 2.29/7
2013-10-06 Tomsk 0-3 Zenit 9/-9 2,25 0.67/12 1.00/8 0.80/5 0.57/7   31/20 3,50 2.42/12 2.75/8 2.60/5 2.29/7
2013-10-18 Zenit 2-0 CSKA Moscow 34/23 3,46 2.46/13 2.75/8 2.60/5 2.38/8   14/0 2,15 1.85/13 1.63/8 2.29/7 1.33/6
2013-10-26 Ural 1-2 Zenit 12/-14 2,71 0.64/14 0.50/8 0.25/8 1.17/6   36/25 3,36 2.50/14 3.00/8 2.67/6 2.38/8
2013-11-02 Zenit 1-1 Amkar 38/26 3,33 2.53/15 3.00/8 2.67/6 2.44/9   17/4 2,00 1.60/15 1.75/8 2.14/7 1.13/8
2013-11-10 Spartak Moscow 4-2 Zenit 28/11 2,81 2.06/16 2.00/8 2.00/7 2.11/9   39/26 3,25 2.44/16 2.75/8 2.43/7 2.44/9
2013-11-22 Zenit 0-2 FK Rostov 41/24 3,41 2.29/17 2.38/8 2.43/7 2.20/10   22/-3 2,76 1.18/17 0.75/8 1.33/9 1.00/8
2013-12-01 Akhmat Grozny 1-1 Zenit 10/-13 1,83 0.50/18 0.75/8 0.78/9 0.22/9   41/22 3,33 2.17/18 2.00/8 2.13/8 2.20/10
2013-12-06 Zenit 2-1 Ural 42/22 3,26 2.11/19 1.75/8 2.13/8 2.09/11   17/-20 2,70 0.70/20 0.75/8 0.33/12 1.25/8
2014-03-09 Zenit 0-0 Tomsk 44/23 3,25 2.15/20 1.75/8 2.22/9 2.09/11   13/-16 2,10 0.75/20 0.88/8 0.89/9 0.64/11
2014-03-15 CSKA Moscow 1-0 Zenit 28/4 2,48 1.76/21 1.63/8 2.50/10 1.09/11   44/23 3,10 2.10/21 1.50/8 2.10/10 2.09/11
2014-03-24 Zenit 2-1 FK Krylya Sovetov Samara 44/22 3,00 2.00/22 1.13/8 2.10/10 1.92/12   21/-6 2,29 1.14/21 1.38/8 1.00/11 1.30/10
2014-03-24 Zenit 2-1 Krylya Sovetov 46/23 3,00 2.04/23 1.38/8 2.18/11 1.92/12   21/-6 2,29 1.14/21 1.38/8 1.00/11 1.30/10
2014-03-29 Amkar 1-2 Zenit 30/6 2,35 1.57/23 1.50/8 2.27/11 0.92/12   48/24 3,00 2.08/24 1.38/8 2.25/12 1.92/12
2014-04-06 Zenit 6-2 Rubin Kazan 50/25 3,00 2.12/25 1.75/8 2.25/12 2.00/13   26/7 1,88 1.21/24 1.38/8 1.33/12 1.08/12
2014-04-12 Zenit 4-1 Krasnodar 56/29 3,19 2.15/26 2.13/8 2.31/13 2.00/13   39/8 2,69 1.58/26 1.25/8 1.71/14 1.42/12
2014-04-19 FK Anzi Makhackala 1-2 Zenit 21/-17 2,27 0.65/26 1.13/8 0.83/12 0.50/14   60/32 3,26 2.19/27 2.38/8 2.36/14 2.00/13
2014-04-26 Zenit 2-0 Volga N. Novgorod 62/33 3,25 2.21/28 2.38/8 2.36/14 2.07/14   24/-38 3,07 0.79/28 0.38/8 1.07/14 0.50/14
2014-05-04 Lokomotiv Moscow 1-1 Zenit 54/32 2,62 2.14/29 2.25/8 2.27/15 2.00/14   64/35 3,21 2.24/29 2.63/8 2.40/15 2.07/14
2014-05-11 Zenit 0-3 Dynamo Moscow 65/35 3,17 2.20/30 2.75/8 2.40/15 2.00/15   53/18 2,93 1.83/30 1.38/8 1.94/16 1.71/14
2014-05-15 Kuban 1-4 Zenit 43/5 2,61 1.35/31 1.88/8 1.67/15 1.06/16   65/32 3,16 2.13/31 2.38/8 2.25/16 2.00/15