SELECT * FROM 1_Kampe WHERE LigaID = '239' 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-29 Rubin Kazan 2-1 Krasnodar 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-08-04 Ural 1-2 Krasnodar 0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0   1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1
2018-08-13 Ufa 0-1 Krasnodar 3/3 1,50 2.00/2 2.00/2 2.00/2 0.00/0   3/0 3,00 1.50/2 1.50/2 0.00/0 1.50/2
2018-08-18 Krasnodar 0-1 Spartak Moscow 4/1 2,33 2.00/3 2.00/3 0.00/0 2.00/3   2/2 0,67 2.33/3 2.33/3 3.00/2 1.00/1
2018-08-26 Orenburg 1-1 Krasnodar 10/8 2,40 2.40/5 2.40/5 3.00/1 2.25/4   4/0 2,00 1.50/4 1.50/4 0.00/1 2.00/3
2018-09-01 Krasnodar 2-1 Lokomotiv Moscow 5/0 2,00 1.40/5 1.40/5 0.00/1 1.75/4   4/2 1,00 1.83/6 1.83/6 2.00/2 1.75/4
2018-09-16 FK Anzi Makhackala 0-4 Krasnodar 3/-8 2,00 0.43/7 0.43/7 0.00/1 0.50/6   7/1 2,17 1.67/6 1.67/6 1.50/2 1.75/4
2018-09-24 FK Krylya Sovetov Samara 0-3 Krasnodar 2/-7 1,57 1.00/7 1.00/7 1.00/4 1.00/3   11/5 2,43 1.86/7 1.86/7 1.50/2 2.00/5
2018-09-24 Krylya Sovetov 0-3 Krasnodar 2/-7 1,57 1.00/7 1.00/7 1.00/4 1.00/3   14/8 2,50 2.00/8 2.38/8 1.50/2 2.17/6
2018-09-30 Krasnodar 3-0 Dynamo Moscow 17/11 2,56 2.11/9 2.38/8 1.50/2 2.29/7   9/3 1,88 1.25/8 1.25/8 1.75/4 0.75/4
2018-10-07 Zenit 2-1 Krasnodar 18/11 2,78 2.44/9 2.38/8 2.50/4 2.40/5   20/14 2,60 2.20/10 2.38/8 2.00/3 2.29/7
2018-10-21 Krasnodar 0-1 Akhmat Grozny 21/13 2,64 2.00/11 2.00/8 2.00/3 2.00/8   9/-3 2,10 1.20/10 1.13/8 1.80/5 0.60/5
2018-10-28 CSKA Moscow 1-2 Krasnodar 16/11 1,75 1.67/12 2.13/8 1.40/5 1.86/7   21/12 2,50 1.83/12 2.00/8 1.50/4 2.00/8
2018-11-04 Krasnodar 2-2 FK Rostov 23/13 2,54 1.92/13 2.25/8 1.50/4 2.11/9   12/5 1,46 1.62/13 1.50/8 1.38/8 2.00/5
2018-11-11 Krasnodar 3-0 Yenisey 25/13 2,64 1.86/14 2.00/8 1.40/5 2.11/9   8/-13 2,07 0.64/14 0.25/8 1.00/8 0.17/6
2018-11-25 Krasnodar 3-0 Arsenal Tula 28/16 2,67 1.93/15 2.00/8 1.67/6 2.11/9   23/5 2,73 1.33/15 1.50/8 1.78/9 0.67/6
2018-12-02 Krasnodar 2-0 Ural 31/19 2,69 2.00/16 2.00/8 1.86/7 2.11/9   19/-4 2,63 1.44/16 1.88/8 1.40/10 1.50/6
2018-12-09 Krasnodar 1-1 Ufa 33/21 2,65 2.06/17 2.00/8 2.00/8 2.11/9   12/-7 1,82 0.88/17 0.88/8 1.10/10 0.57/7
2019-03-03 Spartak Moscow 1-1 Krasnodar 25/7 2,39 1.72/18 1.63/8 1.80/10 1.63/8   34/21 2,61 2.00/18 1.75/8 1.89/9 2.11/9
2019-03-11 Krasnodar 2-2 Orenburg 35/21 2,58 1.95/19 1.88/8 1.89/9 2.00/10   20/4 2,00 1.39/18 1.38/8 1.38/8 1.40/10
2019-03-17 Lokomotiv Moscow 1-0 Krasnodar 30/9 2,43 1.71/21 1.50/8 1.90/10 1.55/11   37/21 2,65 1.90/20 2.00/8 1.80/10 2.00/10
2019-03-31 Krasnodar 5-0 FK Anzi Makhackala 37/20 2,57 1.81/21 1.63/8 1.80/10 1.82/11   10/-22 1,91 0.82/22 0.63/8 0.73/11 0.91/11
2019-04-06 Krasnodar 1-0 FK Krylya Sovetov Samara 42/25 2,68 1.86/22 1.88/8 1.91/11 1.82/11   19/-9 2,24 1.14/21 1.25/8 1.18/11 1.10/10
2019-04-06 Krasnodar 1-0 Krylya Sovetov 43/26 2,61 1.91/23 1.88/8 2.00/12 1.82/11   19/-9 2,24 1.14/21 1.25/8 1.18/11 1.10/10
2019-04-14 Dynamo Moscow 1-1 Krasnodar 19/0 1,65 1.04/23 1.00/8 1.40/10 0.77/13   44/27 2,54 1.96/24 1.88/8 2.08/13 1.82/11
2019-04-20 Krasnodar 2-3 Zenit 45/27 2,52 1.92/25 1.63/8 2.08/13 1.75/12   41/20 2,58 2.13/24 1.75/8 2.55/11 1.77/13
2019-04-24 Akhmat Grozny 1-1 Krasnodar 25/-2 2,08 1.44/25 1.63/8 1.27/11 1.57/14   47/26 2,62 1.85/26 1.50/8 1.93/14 1.75/12
2019-04-28 Krasnodar 2-0 CSKA Moscow 48/26 2,59 1.81/27 1.50/8 1.93/14 1.69/13   36/20 2,00 1.73/26 1.75/8 1.67/12 1.79/14
2019-05-05 FK Rostov 1-1 Krasnodar 23/0 1,64 1.29/28 1.38/8 1.43/14 1.14/14   50/28 2,57 1.86/28 1.75/8 2.00/15 1.69/13
2019-05-11 Yenisey 0-4 Krasnodar 22/-27 2,45 0.76/29 1.00/8 1.29/14 0.27/15   51/28 2,55 1.83/29 1.88/8 2.00/15 1.64/14
2019-05-19 Arsenal Tula 0-3 Krasnodar 42/15 2,30 1.70/30 2.25/8 2.13/15 1.27/15   55/32 2,60 1.87/30 1.88/8 2.00/15 1.73/15
2019-05-26 Krasnodar 1-0 Rubin Kazan 58/35 2,61 1.90/31 1.88/8 2.00/15 1.81/16   26/-5 1,84 1.26/31 0.75/8 1.75/16 0.73/15