SELECT * FROM 1_Kampe WHERE LigaID = '245' 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
2012-07-22 Zenit 2-0 Amkar 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
2012-07-28 Zenit 2-0 Dynamo Moscow 2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0   0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1
2012-08-04 CSKA Moscow 1-3 Zenit 2/-1 2,50 1.50/2 1.50/2 3.00/1 0.00/1   4/4 2,00 3.00/2 3.00/2 3.00/2 0.00/0
2012-08-11 Zenit 5-0 Spartak Moscow 7/6 2,67 3.00/3 3.00/3 3.00/2 3.00/1   8/6 3,33 3.00/3 3.00/3 3.00/1 3.00/2
2012-08-19 FK Anzi Makhackala 1-1 Zenit 5/1 2,25 1.75/4 1.75/4 3.00/2 0.50/2   12/11 3,25 3.00/4 3.00/4 3.00/3 3.00/1
2012-08-25 Zenit 1-2 Rubin Kazan 13/11 3,00 2.60/5 2.60/5 3.00/3 2.00/2   9/3 3,00 1.80/5 1.80/5 3.00/2 1.00/3
2012-08-31 FK Saransk 0-3 Zenit 7/-4 3,00 0.67/6 0.67/6 1.00/3 0.33/3   14/10 3,00 2.17/6 2.17/6 2.25/4 2.00/2
2012-09-14 Zenit 0-2 Akhmat Grozny 17/13 3,00 2.29/7 2.29/7 2.25/4 2.33/3   10/1 2,71 2.29/7 2.29/7 3.00/3 1.75/4
2012-09-22 Krylya Sovetov 2-2 Zenit 9/-5 2,88 1.25/8 1.25/8 1.00/4 1.50/4   17/11 2,88 2.00/8 2.00/8 1.80/5 2.33/3
2012-09-29 Zenit 1-1 Lokomotiv Moscow 19/11 3,00 1.89/9 1.75/8 1.80/5 2.00/4   18/7 3,22 2.11/9 2.00/8 2.00/5 2.25/4
2012-10-07 Krasnodar 0-2 Zenit 18/2 3,40 1.20/10 1.13/8 2.00/5 0.40/5   20/11 2,90 1.80/10 1.50/8 1.67/6 2.00/4
2012-10-20 Zenit 1-0 Kuban 22/13 2,82 1.91/11 1.50/8 1.67/6 2.20/5   19/5 3,00 1.73/11 2.00/8 2.60/5 1.00/6
2012-10-27 Alania Vladikavkaz 2-3 Zenit 16/-4 3,00 0.83/12 0.75/8 1.33/6 0.33/6   23/14 2,67 2.00/12 1.50/8 1.86/7 2.20/5
2012-11-02 Zenit 2-1 FK Rostov 26/15 2,85 2.08/13 1.75/8 1.86/7 2.33/6   10/-10 2,31 0.77/13 1.00/8 1.33/6 0.29/7
2012-11-11 Volga N. Novgorod 1-2 Zenit 15/-11 2,93 0.79/14 1.00/8 0.71/7 0.86/7   28/16 2,86 2.14/14 2.13/8 2.00/8 2.33/6
2012-11-17 Dynamo Moscow 3-0 Zenit 15/-8 2,53 1.20/15 1.88/8 1.29/7 1.13/8   30/17 2,87 2.20/15 2.13/8 2.00/8 2.43/7
2012-11-26 Zenit 1-1 CSKA Moscow 30/14 2,88 2.06/16 2.13/8 2.00/8 2.13/8   30/17 2,69 2.44/16 2.63/8 2.33/9 2.57/7
2012-11-30 Spartak Moscow 2-4 Zenit 32/6 3,41 1.71/17 1.63/8 2.14/7 1.40/10   31/14 2,82 2.00/17 2.13/8 1.89/9 2.13/8
2012-12-10 Zenit 1-1 FK Anzi Makhackala 35/16 3,00 2.06/18 2.38/8 1.89/9 2.22/9   33/16 2,78 2.22/18 2.13/8 2.60/10 1.75/8
2013-03-10 Rubin Kazan 1-0 Zenit 26/7 2,37 1.63/19 1.63/8 1.78/9 1.50/10   36/16 2,95 2.00/19 2.13/8 1.80/10 2.22/9
2013-03-17 Zenit 1-0 FK Saransk 36/15 2,85 1.90/20 1.75/8 1.80/10 2.00/10   20/-21 3,05 0.60/20 0.50/8 0.73/11 0.44/9
2013-03-31 Akhmat Grozny 0-3 Zenit 24/-6 2,57 1.57/21 1.00/8 1.90/10 1.27/11   37/16 2,76 1.95/21 1.75/8 1.91/11 2.00/10
2013-04-07 Zenit 1-0 Krylya Sovetov 40/19 2,77 2.00/22 1.75/8 1.91/11 2.09/11   19/-22 2,73 0.77/22 0.50/8 0.50/12 1.10/10
2013-04-13 Lokomotiv Moscow 0-1 Zenit 28/3 2,30 1.43/23 1.38/8 1.36/11 1.50/12   41/20 2,70 2.04/23 1.75/8 2.00/12 2.09/11
2013-04-21 Zenit 1-0 Krasnodar 42/21 2,63 2.08/24 2.13/8 2.00/12 2.17/12   39/7 2,96 1.46/24 1.63/8 2.15/13 0.64/11
2013-04-28 Kuban 2-2 Zenit 39/13 2,60 1.60/25 1.13/8 1.92/12 1.31/13   43/22 2,56 2.12/25 2.38/8 2.08/13 2.17/12
2013-05-04 Zenit 4-0 Alania Vladikavkaz 45/22 2,62 2.08/26 2.13/8 2.08/13 2.08/13   25/-21 2,73 0.62/26 0.75/8 0.86/14 0.33/12
2013-05-12 FK Rostov 1-1 Zenit 24/-13 2,26 0.93/27 0.63/8 1.31/13 0.57/14   49/26 2,67 2.11/27 2.38/8 2.14/14 2.08/13
2013-05-19 Zenit 3-1 Volga N. Novgorod 50/26 2,64 2.07/28 2.50/8 2.14/14 2.00/14   27/-16 2,50 1.00/28 1.38/8 0.80/15 1.23/13
2013-05-26 Amkar 0-0 Zenit 34/-17 2,93 0.97/29 0.75/8 1.14/14 0.80/15   53/28 2,69 2.10/29 2.50/8 2.20/15 2.00/14
2018-10-21 Zenit 1-3 FK Krylya Sovetov Samara 53/28 2,60 2.07/30 2.25/8 2.20/15 1.93/15   45/-2 4,00 1.43/23 1.88/8 0.00/12 3.00/11
2018-10-21 FK Krylya Sovetov Samara 1-3 Zenit 11/2 4,00 1.80/5 1.88/8 0.00/2 3.00/3   54/26 2,65 2.00/31 1.75/8 2.06/16 1.93/15
2018-10-21 Zenit 1-3 M. Saransk 57/28 2,69 2.03/32 1.75/8 2.06/16 2.00/16   48/0 4,00 1.50/24 1.13/8 0.00/12 3.00/12
2018-10-21 M. Saransk 1-3 Zenit 16/0 4,00 1.50/8 1.13/8 0.00/4 3.00/4   58/26 2,73 1.97/33 1.75/8 1.94/17 2.00/16