SELECT * FROM 1_Kampe WHERE LigaID = '245' 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
2012-07-23 Krasnodar 2-1 Rubin Kazan 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-30 Akhmat Grozny 1-0 Krasnodar 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-08-04 Krasnodar 3-1 Lokomotiv Moscow 2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1   5/3 3,50 3.00/2 3.00/2 3.00/1 3.00/1
2012-08-10 Kuban 2-1 Krasnodar 3/-1 2,33 1.00/3 1.00/3 3.00/1 0.00/2   5/2 2,67 2.00/3 2.00/3 3.00/2 0.00/1
2012-08-18 Krasnodar 0-0 FK Rostov 6/1 2,75 1.50/4 1.50/4 3.00/2 0.00/2   3/-5 2,75 0.25/4 0.25/4 0.50/2 0.00/2
2012-08-26 Amkar 2-2 Krasnodar 5/1 1,80 1.40/5 1.40/5 2.00/2 1.00/3   6/1 2,20 1.40/5 1.40/5 2.33/3 0.00/2
2012-09-02 Krasnodar 0-1 CSKA Moscow 8/1 2,50 1.33/6 1.33/6 2.33/3 0.33/3   10/4 2,67 2.00/6 2.00/6 2.25/4 1.50/2
2012-09-16 FK Anzi Makhackala 5-2 Krasnodar 12/4 2,86 2.00/7 2.00/7 2.50/4 1.33/3   8/0 2,29 1.14/7 1.14/7 1.75/4 0.33/3
2012-09-21 Krasnodar 6-1 FK Saransk 10/-3 2,88 1.00/8 1.00/8 1.75/4 0.25/4   9/-8 3,25 0.50/8 0.50/8 0.60/5 0.33/3
2012-10-01 Krylya Sovetov 2-2 Krasnodar 11/-5 3,00 1.22/9 1.25/8 1.00/5 1.50/4   16/2 3,33 1.22/9 1.00/8 2.00/5 0.25/4
2012-10-07 Krasnodar 0-2 Zenit 18/2 3,40 1.20/10 1.13/8 2.00/5 0.40/5   20/11 2,90 1.80/10 1.50/8 1.67/6 2.00/4
2012-10-20 Krasnodar 2-0 Alania Vladikavkaz 18/0 3,27 1.09/11 0.75/8 1.67/6 0.40/5   16/-2 3,09 0.91/11 0.88/8 1.33/6 0.40/5
2012-10-27 Volga N. Novgorod 1-1 Krasnodar 12/-13 3,08 0.58/12 0.50/8 0.67/6 0.50/6   20/2 3,17 1.25/12 1.13/8 1.86/7 0.40/5
2012-11-04 Krasnodar 2-0 Dynamo Moscow 21/2 3,08 1.23/13 1.13/8 1.86/7 0.50/6   13/-8 2,62 1.15/13 1.88/8 1.00/6 1.29/7
2012-11-11 Spartak Moscow 2-0 Krasnodar 28/8 3,43 1.79/14 1.63/8 2.40/5 1.44/9   23/4 3,00 1.36/14 1.38/8 2.00/8 0.50/6
2012-11-19 Krasnodar 3-0 Akhmat Grozny 23/2 2,93 1.27/15 1.38/8 2.00/8 0.43/7   20/-1 2,73 1.87/15 1.50/8 2.14/7 1.63/8
2012-11-24 Lokomotiv Moscow 3-2 Krasnodar 23/5 2,56 1.56/16 1.13/8 1.38/8 1.75/8   26/5 2,94 1.38/16 1.75/8 2.11/9 0.43/7
2012-11-30 Krasnodar 2-1 Kuban 28/4 3,06 1.29/17 1.38/8 2.11/9 0.38/8   31/12 2,94 1.82/17 2.25/8 2.38/8 1.33/9
2012-12-07 FK Rostov 2-3 Krasnodar 18/-4 2,22 1.11/18 1.38/8 1.75/8 0.60/10   30/5 3,06 1.39/18 1.63/8 2.20/10 0.38/8
2013-03-08 Krasnodar 2-1 Amkar 33/6 3,16 1.47/19 2.00/8 2.20/10 0.67/9   19/-12 2,63 1.00/19 0.50/8 0.89/9 1.10/10
2013-03-17 CSKA Moscow 1-0 Krasnodar 35/18 2,60 2.30/20 2.38/8 2.40/10 2.20/10   35/7 3,15 1.55/20 2.00/8 2.27/11 0.67/9
2013-03-31 Krasnodar 4-0 FK Anzi Makhackala 35/6 3,05 1.48/21 1.88/8 2.27/11 0.60/10   35/14 2,67 2.00/21 1.63/8 2.45/11 1.50/10
2013-04-08 FK Saransk 0-0 Krasnodar 22/-20 2,91 0.68/22 0.88/8 0.73/11 0.64/11   39/10 3,09 1.55/22 1.88/8 2.33/12 0.60/10
2013-04-13 Krasnodar 0-3 Krylya Sovetov 39/10 2,96 1.52/23 2.00/8 2.33/12 0.64/11   19/-23 2,65 0.74/23 0.50/8 0.50/12 1.00/11
2013-04-21 Zenit 1-0 Krasnodar 42/21 2,63 2.08/24 2.13/8 2.00/12 2.17/12   39/7 2,96 1.46/24 1.63/8 2.15/13 0.64/11
2013-04-29 Alania Vladikavkaz 2-3 Krasnodar 23/-20 2,64 0.64/25 0.75/8 0.92/13 0.33/12   39/6 2,88 1.40/25 1.63/8 2.15/13 0.58/12
2013-05-05 Krasnodar 2-0 Volga N. Novgorod 42/7 2,96 1.46/26 1.63/8 2.15/13 0.77/13   26/-15 2,58 0.96/26 1.38/8 0.64/14 1.33/12
2013-05-11 Dynamo Moscow 1-1 Krasnodar 40/8 2,67 1.70/27 2.00/8 1.92/13 1.50/14   44/9 2,93 1.52/27 1.63/8 2.21/14 0.77/13
2013-05-18 Krasnodar 0-1 Spartak Moscow 45/9 2,89 1.50/28 1.38/8 2.21/14 0.79/14   48/9 3,11 1.61/28 1.25/8 1.93/14 1.29/14
2013-05-26 Rubin Kazan 2-0 Krasnodar 37/10 2,21 1.62/29 1.50/8 2.07/14 1.20/15   45/8 2,83 1.45/29 1.38/8 2.07/15 0.79/14
2018-10-21 Krasnodar 1-3 FK Krylya Sovetov Samara 45/6 2,80 1.40/30 1.00/8 2.07/15 0.73/15   42/-4 4,00 1.36/22 1.88/8 0.00/12 3.00/10
2018-10-21 M. Saransk 1-3 Krasnodar 44/0 4,00 1.50/22 1.13/8 0.00/11 3.00/11   46/4 2,84 1.35/31 1.25/8 1.94/16 0.73/15
2018-10-21 FK Krylya Sovetov Samara 1-3 Krasnodar 10/4 4,00 2.25/4 1.88/8 0.00/1 3.00/3   49/6 2,88 1.41/32 1.25/8 1.94/16 0.88/16
2018-10-21 Krasnodar 1-3 M. Saransk 52/8 2,91 1.45/33 1.25/8 1.94/16 1.00/17   12/0 4,00 1.50/6 1.13/8 0.00/3 3.00/3