SELECT * FROM 1_Kampe WHERE LigaID = '241' 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
2016-08-01 Krasnodar 3-0 Tomsk 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
2016-08-08 Krasnodar 4-0 Akhmat Grozny 3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-13 Krylya Sovetov 1-1 Krasnodar 0/-2 1,00 0.00/2 0.00/2 0.00/0 0.00/2   7/7 3,50 3.00/2 3.00/2 3.00/2 0.00/0
2016-08-21 Spartak Moscow 2-0 Krasnodar 6/5 2,33 2.33/3 2.33/3 3.00/2 1.00/1   8/7 3,00 2.33/3 2.33/3 3.00/2 1.00/1
2016-08-28 Krasnodar 1-2 Lokomotiv Moscow 8/5 2,75 1.75/4 1.75/4 3.00/2 0.50/2   3/0 1,50 1.00/4 1.00/4 1.00/2 1.00/2
2016-09-11 Ufa 0-0 Krasnodar 2/-4 1,60 0.80/5 0.80/5 0.50/2 1.00/3   9/4 2,80 1.40/5 1.40/5 2.00/3 0.50/2
2016-09-18 Krasnodar 2-1 FK Rostov 9/4 2,33 1.33/6 1.33/6 2.00/3 0.67/3   9/3 2,50 1.67/6 1.67/6 2.50/4 0.00/2
2016-09-24 CSKA Moscow 1-1 Krasnodar 9/7 1,57 2.43/7 2.43/7 3.00/1 2.33/6   11/5 2,43 1.57/7 1.57/7 2.25/4 0.67/3
2016-10-02 Krasnodar 1-0 Rubin Kazan 12/5 2,38 1.50/8 1.50/8 2.25/4 0.75/4   9/-2 2,50 1.13/8 1.13/8 1.60/5 0.33/3
2016-10-16 Arsenal Tula 0-0 Krasnodar 3/-10 1,78 0.78/9 0.88/8 1.25/4 0.40/5   13/6 2,22 1.67/9 1.50/8 2.40/5 0.75/4
2016-10-23 Krasnodar 1-0 Amkar 13/6 2,00 1.60/10 1.25/8 2.40/5 0.80/5   8/3 1,30 1.70/10 1.63/8 2.20/5 1.20/5
2016-10-30 FK Anzi Makhackala 0-0 Krasnodar 10/1 1,73 1.45/11 1.50/8 1.20/5 1.67/6   14/7 1,91 1.73/11 1.50/8 2.50/6 0.80/5
2016-11-06 Krasnodar 3-3 Orenburg 14/7 1,75 1.67/12 1.63/8 2.50/6 0.83/6   7/-4 1,50 0.83/12 1.00/8 1.13/8 0.25/4
2016-11-20 Krasnodar 3-0 Ural 17/7 2,08 1.62/13 1.75/8 2.29/7 0.83/6   9/-8 2,00 0.77/13 0.63/8 0.57/7 1.00/6
2016-11-27 Krasnodar 2-1 Zenit 20/10 2,14 1.71/14 2.00/8 2.38/8 0.83/6   30/19 2,93 2.21/14 2.38/8 2.56/9 1.60/5
2016-12-01 Akhmat Grozny 2-1 Krasnodar 19/1 2,47 1.67/15 1.88/8 1.89/9 1.33/6   22/11 2,20 1.80/15 2.00/8 2.44/9 0.83/6
2016-12-05 Krasnodar 1-1 Krylya Sovetov 23/10 2,25 1.69/16 1.88/8 2.44/9 0.71/7   16/-3 2,19 0.88/16 1.38/8 1.50/8 0.25/8
2017-03-05 Krasnodar 2-2 Spartak Moscow 24/10 2,24 1.65/17 1.63/8 2.30/10 0.71/7   26/13 2,29 2.35/17 2.63/8 2.67/9 2.00/8
2017-03-13 Lokomotiv Moscow 1-2 Krasnodar 24/11 2,06 1.44/18 2.13/8 1.63/8 1.30/10   26/10 2,33 1.61/18 1.63/8 2.18/11 0.71/7
2017-03-19 Krasnodar 0-0 Ufa 28/11 2,37 1.68/19 1.63/8 2.18/11 1.00/8   14/1 1,42 1.63/19 2.25/8 1.44/9 1.80/10
2017-04-03 FK Rostov 0-0 Krasnodar 25/13 1,85 1.50/20 1.63/8 2.40/10 0.60/10   28/11 2,25 1.65/20 1.63/8 2.08/12 1.00/8
2017-04-09 Krasnodar 1-1 CSKA Moscow 28/11 2,14 1.62/21 1.63/8 2.08/12 1.00/9   28/16 1,90 2.00/21 2.50/8 2.20/10 1.82/11
2017-04-15 Rubin Kazan 0-1 Krasnodar 23/-1 2,14 1.27/22 1.13/8 1.73/11 0.82/11   29/11 2,14 1.59/22 1.38/8 2.00/13 1.00/9
2017-04-23 Krasnodar 2-0 Arsenal Tula 30/12 2,09 1.65/23 1.38/8 2.00/13 1.20/10   12/-22 2,00 0.78/23 1.13/8 1.36/11 0.25/12
2017-04-27 Amkar 0-2 Krasnodar 24/3 1,88 1.42/24 1.25/8 2.27/11 0.69/13   32/14 2,08 1.71/24 1.75/8 2.07/14 1.20/10
2017-05-01 Krasnodar 0-0 FK Anzi Makhackala 34/16 2,08 1.76/25 2.00/8 2.07/14 1.36/11   22/-8 2,08 1.12/25 1.00/8 1.08/13 1.17/12
2017-05-07 Orenburg 1-0 Krasnodar 21/-10 2,00 0.88/26 1.00/8 1.33/12 0.50/14   34/16 2,00 1.73/26 2.00/8 2.00/15 1.36/11
2017-05-13 Ural 1-1 Krasnodar 22/-18 2,30 1.07/27 1.50/8 1.46/13 0.71/14   34/15 1,96 1.67/27 1.63/8 2.00/15 1.25/12
2017-05-17 Zenit 1-0 Krasnodar 47/28 2,36 1.96/28 2.00/8 2.36/14 1.57/14   35/15 1,96 1.64/28 1.63/8 2.00/15 1.23/13
2017-05-21 Tomsk 1-5 Krasnodar 16/-43 2,59 0.48/29 0.25/8 0.79/14 0.20/15   35/14 1,93 1.59/29 1.50/8 2.00/15 1.14/14
2018-10-21 FK Krylya Sovetov Samara 1-3 Krasnodar 24/0 4,00 1.50/12 1.88/8 0.00/6 3.00/6   40/18 2,07 1.63/30 1.75/8 2.00/15 1.27/15
2018-10-21 Krasnodar 1-3 FK Krylya Sovetov Samara 43/20 2,13 1.68/31 1.38/8 2.00/15 1.38/16   54/-4 4,00 1.39/28 1.88/8 0.00/15 3.00/13