SELECT * FROM 1_Kampe WHERE LigaID = '244' AND (Home='Krasnodar' OR Away='Krasnodar') 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 Krasnodar 34/-1 2,38 1.28/29 0.38/8 1.71/14 0.87/15   44/7 2,79 1.69/29 1.88/8 1.73/15 1.64/14
2018-07-13 Krasnodar 3-1 Tomsk 19/5 2,75 1.75/12 2.13/8 1.83/6 1.67/6   9/-11 2,42 0.67/12 1.00/8 0.67/6 0.67/6
2018-07-13 Ural 3-1 Krasnodar 10/-12 2,91 0.64/11 0.75/8 0.29/7 1.25/4   17/3 2,82 1.64/11 1.75/8 1.83/6 1.40/5
2018-07-13 Krasnodar 3-1 Rubin Kazan 16/2 3,00 1.50/10 1.75/8 1.60/5 1.40/5   10/3 1,70 1.30/10 1.13/8 1.20/5 1.40/5
2018-07-13 Spartak Moscow 3-1 Krasnodar 17/10 2,67 2.22/9 2.13/8 2.33/3 2.17/6   14/3 2,78 1.67/9 1.88/8 1.60/5 1.75/4
2018-07-13 Akhmat Grozny 3-1 Krasnodar 3/-6 1,50 0.38/8 0.38/8 0.75/4 0.00/4   13/2 3,00 1.50/8 1.50/8 1.60/5 1.33/3
2018-07-13 Krasnodar 3-1 FK Krylya Sovetov Samara 46/7 2,83 1.67/30 1.63/8 1.73/15 1.60/15   13/-2 4,00 1.29/7 1.13/8 0.00/4 3.00/3
2018-07-13 Krasnodar 3-1 Volga N. Novgorod 9/-1 3,17 1.33/6 1.33/6 1.33/3 1.33/3   7/-5 3,17 1.17/6 1.17/6 1.00/3 1.33/3
2018-07-13 FK Anzi Makhackala 3-1 Krasnodar 4/-5 2,60 0.40/5 0.40/5 0.50/2 0.33/3   7/-2 3,20 1.00/5 1.00/5 1.33/3 0.50/2
2018-07-13 Krasnodar 3-1 Dynamo Moscow 6/-2 3,50 1.00/4 1.00/4 1.50/2 0.50/2   6/-1 3,25 1.75/4 1.75/4 1.75/4 0.00/0
2018-07-13 Lokomotiv Moscow 3-1 Krasnodar 5/0 3,33 1.33/3 1.33/3 0.00/1 2.00/2   5/0 3,33 1.33/3 1.33/3 1.50/2 1.00/1
2018-07-13 Krasnodar 3-1 Amkar 3/-1 3,50 0.50/2 0.50/2 0.00/1 1.00/1   3/2 2,00 2.00/2 2.00/2 3.00/1 1.00/1
2018-07-13 FK Rostov 3-1 Krasnodar 2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0   1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2018-07-13 Krasnodar 3-1 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
2018-07-13 Krylya Sovetov 3-1 Krasnodar 17/-5 2,29 1.06/17 1.13/8 0.89/9 1.25/8   29/6 3,06 1.76/17 1.88/8 1.89/9 1.63/8
2018-07-13 CSKA Moscow 3-1 Krasnodar 12/-3 2,08 1.62/13 1.25/8 2.17/6 1.14/7   23/9 2,85 1.85/13 2.38/8 2.00/7 1.67/6
2018-07-13 Krasnodar 3-1 Kuban 24/5 3,07 1.71/14 2.00/8 2.00/7 1.43/7   17/-2 2,57 1.21/14 1.00/8 1.71/7 0.71/7
2018-07-13 Krasnodar 3-1 FK Anzi Makhackala 43/6 2,86 1.64/28 1.63/8 1.64/14 1.64/14   25/-15 2,32 0.71/28 1.13/8 0.93/14 0.50/14
2018-07-13 Volga N. Novgorod 3-1 Krasnodar 21/-39 3,00 0.78/27 0.38/8 1.15/13 0.43/14   42/5 2,93 1.59/27 1.25/8 1.64/14 1.54/13
2018-07-13 Krasnodar 3-1 Lokomotiv Moscow 41/7 2,88 1.65/26 1.63/8 1.77/13 1.54/13   47/29 2,50 2.12/26 2.00/8 2.21/14 2.00/12
2018-07-13 Dynamo Moscow 3-1 Krasnodar 45/16 2,96 1.84/25 2.13/8 2.00/14 1.64/11   39/6 2,88 1.60/25 1.25/8 1.77/13 1.42/12
2018-07-13 Zenit 3-1 Krasnodar 50/25 3,13 2.08/24 1.75/8 2.25/12 1.92/12   38/9 2,79 1.67/24 1.63/8 1.77/13 1.55/11
2018-07-13 Krasnodar 3-1 FK Rostov 38/11 2,83 1.74/23 2.00/8 1.92/12 1.55/11   30/2 2,52 1.39/23 1.88/8 1.25/12 1.55/11
2018-07-13 Kuban 3-1 Krasnodar 27/-2 2,55 1.18/22 1.13/8 1.60/10 0.83/12   35/9 2,77 1.68/22 1.63/8 1.92/12 1.40/10
2018-07-13 Krasnodar 3-1 Spartak Moscow 31/5 2,71 1.62/21 1.25/8 1.82/11 1.40/10   39/16 2,95 1.90/21 1.63/8 2.10/10 1.73/11
2018-07-13 Tomsk 3-1 Krasnodar 13/-15 2,05 0.80/20 1.00/8 0.89/9 0.73/11   30/5 2,75 1.65/20 1.50/8 1.82/11 1.44/9
2018-07-13 Krasnodar 3-1 Ural 30/6 2,84 1.74/19 1.88/8 2.00/10 1.44/9   16/-21 2,79 0.63/19 0.63/8 0.27/11 1.13/8
2018-07-13 Krasnodar 3-1 CSKA Moscow 29/5 2,94 1.67/18 1.88/8 1.89/9 1.44/9   24/6 2,33 1.89/18 1.63/8 2.44/9 1.33/9
2018-07-13 FK Krylya Sovetov Samara 3-1 Krasnodar 55/2 4,00 1.56/27 1.13/8 0.00/13 3.00/14   47/5 2,87 1.61/31 1.63/8 1.63/16 1.60/15
2018-07-13 Krasnodar 3-1 Akhmat Grozny 26/5 2,94 1.69/16 1.88/8 1.75/8 1.63/8   8/-11 1,69 0.56/16 0.75/8 0.88/8 0.25/8
2018-07-13 Rubin Kazan 3-1 Krasnodar 17/4 2,00 1.13/15 0.75/8 1.29/7 1.00/8   25/4 3,07 1.60/15 1.63/8 1.75/8 1.43/7
2018-07-13 Krasnodar 3-1 Krylya Sovetov 12/2 3,14 1.57/7 1.57/7 1.75/4 1.33/3   5/-1 1,57 1.00/7 1.00/7 1.25/4 0.67/3