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
2018-07-13 Amkar 3-1 Zenit 35/-17 2,81 0.97/31 0.75/8 1.13/15 0.81/16   57/32 2,65 2.16/31 2.50/8 2.25/16 2.07/15
2018-07-13 Krasnodar 3-1 Zenit 24/7 3,73 1.36/11 1.13/8 2.17/6 0.40/5   23/14 2,91 1.91/11 1.50/8 1.67/6 2.20/5
2018-07-13 Zenit 3-1 Lokomotiv Moscow 22/14 3,00 2.00/10 1.75/8 1.80/5 2.20/5   21/8 3,40 2.20/10 2.00/8 2.00/5 2.40/5
2018-07-13 FK Krylya Sovetov Samara 3-1 Zenit 11/2 4,00 1.80/5 1.88/8 0.00/2 3.00/3   57/32 2,56 2.13/32 2.25/8 2.25/16 2.00/16
2018-07-13 Zenit 3-1 Akhmat Grozny 20/16 3,00 2.38/8 2.38/8 2.25/4 2.50/4   10/1 2,71 2.29/7 2.29/7 3.00/3 1.75/4
2018-07-13 M. Saransk 3-1 Zenit 16/0 4,00 1.50/8 1.13/8 0.00/4 3.00/4   62/30 2,69 2.03/35 1.75/8 2.00/18 2.06/17
2018-07-13 Zenit 3-1 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
2018-07-13 FK Anzi Makhackala 3-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
2018-07-13 Zenit 3-1 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
2018-07-13 CSKA Moscow 3-1 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
2018-07-13 Zenit 3-1 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
2018-07-13 Zenit 3-1 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
2018-07-13 Zenit 3-1 FK Saransk 40/19 2,77 2.00/22 1.75/8 1.91/11 2.09/11   20/-21 3,05 0.60/20 0.50/8 0.73/11 0.44/9
2018-07-13 FK Saransk 3-1 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
2018-07-13 Zenit 3-1 Krylya Sovetov 44/23 2,71 2.08/24 1.75/8 2.00/12 2.17/12   22/-23 2,79 0.83/24 0.50/8 0.46/13 1.27/11
2018-07-13 Krylya Sovetov 3-1 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
2018-07-13 Zenit 3-1 Mordovia Saransk 39/18 2,86 1.95/21 1.75/8 1.80/10 2.09/11   20/-21 3,05 0.60/20 0.50/8 0.73/11 0.44/9
2018-07-13 Zenit 3-1 Kuban 25/16 2,83 2.00/12 1.50/8 1.67/6 2.33/6   20/6 2,83 1.83/12 2.00/8 2.67/6 1.00/6
2018-07-13 Alania Vladikavkaz 3-1 Zenit 17/-4 2,92 0.85/13 0.50/8 1.33/6 0.43/7   26/17 2,69 2.08/13 1.75/8 1.86/7 2.33/6
2018-07-13 Zenit 3-1 Volga N. Novgorod 54/30 2,60 2.13/30 2.50/8 2.20/15 2.07/15   30/-16 2,53 1.03/30 1.38/8 0.75/16 1.36/14
2018-07-13 FK Rostov 3-1 Zenit 26/-14 2,28 0.97/29 0.63/8 1.43/14 0.53/15   53/30 2,62 2.17/29 2.75/8 2.20/15 2.14/14
2018-07-13 Zenit 3-1 Alania Vladikavkaz 49/26 2,57 2.14/28 2.38/8 2.14/14 2.14/14   29/-19 2,75 0.71/28 1.00/8 1.00/15 0.38/13
2018-07-13 Kuban 3-1 Zenit 43/17 2,56 1.70/27 1.13/8 2.00/13 1.43/14   47/26 2,52 2.19/27 2.38/8 2.14/14 2.23/13
2018-07-13 Zenit 3-1 Krasnodar 46/25 2,58 2.15/26 2.38/8 2.08/13 2.23/13   45/12 3,00 1.50/26 1.75/8 2.21/14 0.67/12
2018-07-13 Lokomotiv Moscow 3-1 Zenit 31/4 2,42 1.50/24 1.38/8 1.36/11 1.62/13   45/24 2,64 2.12/25 2.13/8 2.08/13 2.17/12
2018-07-13 Zenit 3-1 FK Krylya Sovetov Samara 61/32 2,65 2.09/34 1.75/8 2.12/17 2.06/17   45/-2 4,00 1.43/23 1.88/8 0.00/12 3.00/11
2018-07-13 Akhmat Grozny 3-1 Zenit 26/-5 2,59 1.64/22 1.38/8 2.00/11 1.27/11   41/20 2,70 2.04/23 1.75/8 2.00/12 2.09/11
2018-07-13 Zenit 3-1 M. Saransk 60/34 2,61 2.15/33 1.75/8 2.25/16 2.06/17   48/0 4,00 1.50/24 1.13/8 0.00/12 3.00/12
2018-07-13 Rubin Kazan 3-1 Zenit 29/9 2,45 1.70/20 2.00/8 1.78/9 1.64/11   39/19 2,95 2.05/20 2.13/8 1.80/10 2.30/10
2018-07-13 Zenit 3-1 FK Anzi Makhackala 38/19 3,00 2.11/19 2.38/8 1.89/9 2.30/10   37/18 2,95 2.26/19 2.13/8 2.64/11 1.75/8
2018-07-13 Spartak Moscow 3-1 Zenit 34/8 3,33 1.78/18 1.63/8 2.25/8 1.40/10   34/17 2,83 2.06/18 2.13/8 1.89/9 2.22/9
2018-07-13 Zenit 3-1 CSKA Moscow 33/17 2,88 2.12/17 2.13/8 2.00/8 2.22/9   33/20 2,71 2.47/17 2.63/8 2.33/9 2.63/8
2018-07-13 Dynamo Moscow 3-1 Zenit 17/-7 2,56 1.31/16 2.25/8 1.29/7 1.33/9   33/20 2,88 2.25/16 2.13/8 2.00/8 2.50/8
2018-07-13 Volga N. Novgorod 3-1 Zenit 15/-13 2,87 0.73/15 0.88/8 0.63/8 0.86/7   31/19 2,87 2.20/15 2.13/8 2.00/8 2.43/7
2018-07-13 Zenit 3-1 FK Rostov 29/18 2,86 2.14/14 2.13/8 1.86/7 2.43/7   10/-13 2,36 0.71/14 1.00/8 1.33/6 0.25/8
2018-07-13 Mordovia Saransk 3-1 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