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-08-31 M. Saransk 0-3 Zenit 7/-4 3,00 0.67/6 0.67/6 1.00/3 0.33/3   17/13 3,00 2.29/7 2.38/8 2.25/4 2.33/3
2012-09-14 Zenit 0-2 Akhmat Grozny 20/16 3,00 2.38/8 2.38/8 2.25/4 2.50/4   11/1 2,63 2.13/8 2.13/8 3.00/3 1.60/5
2012-09-22 FK Krylya Sovetov Samara 2-2 Zenit 12/-4 3,11 1.44/9 1.50/8 1.00/4 1.80/5   20/14 2,89 2.11/9 2.00/8 1.80/5 2.50/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   22/14 3,00 2.00/10 1.50/8 1.80/5 2.20/5
2012-09-29 Zenit 1-1 Lokomotiv Moscow 24/14 3,09 1.91/11 1.50/8 1.80/5 2.00/6   23/10 3,27 2.27/11 2.00/8 2.17/6 2.40/5
2012-10-07 Krasnodar 0-2 Zenit 26/7 3,75 1.33/12 1.25/8 2.17/6 0.50/6   25/14 3,00 1.83/12 1.25/8 1.67/6 2.00/6
2012-10-20 Zenit 1-0 Kuban 27/16 2,92 1.92/13 1.50/8 1.67/6 2.14/7   21/5 2,85 1.69/13 2.00/8 2.67/6 0.86/7
2012-10-27 Alania Vladikavkaz 2-3 Zenit 19/-4 3,00 0.86/14 0.63/8 1.29/7 0.43/7   28/17 2,79 2.00/14 1.88/8 1.86/7 2.14/7
2012-11-02 Zenit 2-1 FK Rostov 31/18 2,93 2.07/15 1.88/8 1.86/7 2.25/8   11/-14 2,40 0.67/15 1.00/8 1.14/7 0.25/8
2012-11-11 Volga N. Novgorod 1-2 Zenit 16/-12 2,75 0.88/16 1.25/8 0.63/8 1.13/8   33/19 2,94 2.13/16 1.88/8 2.00/8 2.25/8
2012-11-17 Dynamo Moscow 3-0 Zenit 18/-6 2,47 1.41/17 2.25/8 1.50/8 1.33/9   35/20 2,94 2.18/17 2.25/8 2.00/8 2.33/9
2012-11-26 Zenit 1-1 CSKA Moscow 35/17 2,94 2.06/18 2.13/8 2.00/8 2.10/10   36/23 2,72 2.50/18 2.63/8 2.40/10 2.63/8
2012-11-30 Spartak Moscow 2-4 Zenit 39/13 3,42 1.84/19 2.00/8 2.25/8 1.55/11   36/17 2,89 2.00/19 2.13/8 1.89/9 2.10/10
2012-12-10 Zenit 1-1 FK Anzi Makhackala 40/19 3,05 2.05/20 2.38/8 1.89/9 2.18/11   39/19 2,95 2.30/20 2.13/8 2.64/11 1.89/9
2013-03-10 Rubin Kazan 1-0 Zenit 31/11 2,43 1.76/21 2.00/8 1.90/10 1.64/11   41/19 3,00 2.00/21 2.13/8 1.80/10 2.18/11
2013-03-17 Zenit 1-0 M. Saransk 41/18 2,91 1.91/22 1.75/8 1.80/10 2.00/12   20/-21 3,05 0.60/20 0.50/8 0.73/11 0.44/9
2013-03-17 Zenit 1-0 FK Saransk 42/19 2,83 1.96/23 1.75/8 1.91/11 2.00/12   22/-22 3,14 0.57/21 0.50/8 0.67/12 0.44/9
2013-03-31 Akhmat Grozny 0-3 Zenit 27/-5 2,57 1.61/23 1.38/8 2.00/11 1.25/12   43/20 2,75 2.00/24 1.75/8 2.00/12 2.00/12
2013-04-07 Zenit 1-0 Krylya Sovetov 46/23 2,76 2.04/25 1.75/8 2.00/12 2.08/13   19/-22 2,73 0.77/22 0.50/8 0.50/12 1.10/10
2013-04-07 Zenit 1-0 FK Krylya Sovetov Samara 47/24 2,69 2.08/26 2.38/8 2.08/13 2.08/13   22/-23 2,79 0.83/24 0.50/8 0.46/13 1.27/11
2013-04-13 Lokomotiv Moscow 0-1 Zenit 34/7 2,35 1.62/26 1.38/8 1.50/12 1.71/14   48/25 2,63 2.11/27 2.38/8 2.14/14 2.08/13
2013-04-21 Zenit 1-0 Krasnodar 49/26 2,57 2.14/28 2.38/8 2.14/14 2.14/14   47/9 3,04 1.43/28 1.38/8 2.07/15 0.69/13
2013-04-28 Kuban 2-2 Zenit 48/19 2,66 1.69/29 1.13/8 2.07/14 1.33/15   50/27 2,52 2.17/29 2.63/8 2.20/15 2.14/14
2013-05-04 Zenit 4-0 Alania Vladikavkaz 52/27 2,57 2.13/30 2.75/8 2.20/15 2.07/15   32/-20 2,80 0.70/30 0.88/8 1.00/16 0.36/14
2013-05-12 FK Rostov 1-1 Zenit 29/-13 2,29 1.00/31 0.63/8 1.33/15 0.69/16   56/31 2,61 2.16/31 2.75/8 2.25/16 2.07/15
2013-05-19 Zenit 3-1 Volga N. Novgorod 57/31 2,59 2.13/32 2.50/8 2.25/16 2.00/16   32/-15 2,47 1.09/32 1.38/8 0.76/17 1.47/15
2013-05-26 Amkar 0-0 Zenit 37/-17 2,76 1.00/33 0.75/8 1.06/16 0.94/17   60/33 2,64 2.15/33 2.50/8 2.29/17 2.00/16