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   8/4 4,00 3.00/3 3.00/3 3.00/1 3.00/2
2012-08-10 Kuban 2-1 Krasnodar 4/0 2,00 1.50/4 1.50/4 3.00/2 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/-8 2,80 0.20/5 0.20/5 0.50/2 0.00/3
2012-08-26 Amkar 2-2 Krasnodar 5/1 1,50 1.33/6 1.33/6 1.67/3 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   13/7 2,71 2.14/7 2.14/7 2.25/4 2.00/3
2012-09-16 FK Anzi Makhackala 5-2 Krasnodar 16/6 3,25 2.13/8 2.13/8 2.60/5 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 Mordovia 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-09-21 Krasnodar 6-1 FK Saransk 16/2 3,33 1.22/9 1.38/8 2.00/5 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 14/-4 3,20 1.40/10 1.63/8 1.00/5 1.80/5   22/7 3,70 1.40/10 1.38/8 2.17/6 0.25/4
2012-10-07 Krasnodar 0-2 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
2012-10-20 Krasnodar 2-0 Alania Vladikavkaz 24/5 3,58 1.25/12 1.13/8 1.86/7 0.40/5   17/-2 3,00 0.92/12 0.88/8 1.33/6 0.50/6
2012-10-27 Volga N. Novgorod 1-1 Krasnodar 12/-15 3,00 0.54/13 0.50/8 0.57/7 0.50/6   26/7 3,46 1.38/13 1.38/8 2.00/8 0.40/5
2012-11-04 Krasnodar 2-0 Dynamo Moscow 27/7 3,36 1.36/14 1.38/8 2.00/8 0.50/6   15/-7 2,64 1.29/14 1.88/8 1.00/6 1.50/8
2012-11-11 Spartak Moscow 2-0 Krasnodar 30/10 3,33 1.87/15 2.00/8 2.50/6 1.44/9   29/9 3,27 1.47/15 1.75/8 2.11/9 0.50/6
2012-11-19 Krasnodar 3-0 Akhmat Grozny 29/7 3,19 1.38/16 1.75/8 2.11/9 0.43/7   22/0 2,75 1.94/16 1.50/8 2.25/8 1.63/8
2012-11-24 Lokomotiv Moscow 3-2 Krasnodar 26/6 2,71 1.65/17 1.13/8 1.38/8 1.89/9   32/10 3,18 1.47/17 1.75/8 2.20/10 0.43/7
2012-11-30 Krasnodar 2-1 Kuban 34/9 3,28 1.39/18 1.38/8 2.20/10 0.38/8   35/16 2,84 1.95/19 2.25/8 2.44/9 1.50/10
2012-12-07 FK Rostov 2-3 Krasnodar 20/-5 2,25 1.15/20 1.75/8 1.89/9 0.55/11   36/10 3,26 1.47/19 1.63/8 2.27/11 0.38/8
2013-03-08 Krasnodar 2-1 Amkar 39/11 3,35 1.55/20 2.00/8 2.27/11 0.67/9   20/-12 2,48 1.00/21 0.63/8 0.90/10 1.09/11
2013-03-17 CSKA Moscow 1-0 Krasnodar 40/22 2,64 2.36/22 2.38/8 2.45/11 2.27/11   41/12 3,33 1.62/21 2.00/8 2.33/12 0.67/9
2013-03-31 Krasnodar 4-0 FK Anzi Makhackala 41/11 3,23 1.55/22 1.88/8 2.33/12 0.60/10   39/14 2,78 1.96/23 1.25/8 2.50/12 1.36/11
2013-04-08 Mordovia Saransk 0-0 Krasnodar 22/-20 2,91 0.68/22 0.88/8 0.73/11 0.64/11   45/15 3,26 1.61/23 1.88/8 2.38/13 0.60/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   45/15 3,13 1.58/24 1.75/8 2.38/13 0.64/11
2013-04-13 Krasnodar 0-3 Krylya Sovetov 45/15 3,00 1.56/25 1.75/8 2.38/13 0.67/12   22/-24 2,72 0.80/25 0.50/8 0.46/13 1.17/12
2013-04-21 Zenit 1-0 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
2013-04-29 Alania Vladikavkaz 2-3 Krasnodar 27/-18 2,67 0.74/27 1.13/8 1.07/14 0.38/13   45/11 2,93 1.44/27 1.38/8 2.21/14 0.62/13
2013-05-05 Krasnodar 2-0 Volga N. Novgorod 48/12 3,00 1.50/28 1.38/8 2.21/14 0.79/14   29/-15 2,61 1.00/28 1.38/8 0.60/15 1.46/13
2013-05-11 Dynamo Moscow 1-1 Krasnodar 45/11 2,72 1.79/29 2.00/8 2.00/14 1.60/15   50/14 2,97 1.55/29 1.38/8 2.27/15 0.79/14
2013-05-18 Krasnodar 0-1 Spartak Moscow 51/14 2,93 1.53/30 1.50/8 2.27/15 0.80/15   51/10 3,07 1.60/30 1.13/8 2.00/15 1.20/15
2013-05-26 Rubin Kazan 2-0 Krasnodar 42/13 2,29 1.71/31 1.50/8 2.13/15 1.31/16   51/13 2,87 1.48/31 1.13/8 2.13/16 0.80/15
2018-10-21 Krasnodar 1-3 FK Krylya Sovetov Samara 51/11 2,84 1.44/32 1.00/8 2.13/16 0.75/16   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   52/9 2,88 1.39/33 1.25/8 2.00/17 0.75/16
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   55/11 2,91 1.44/34 1.25/8 2.00/17 0.88/17
2018-10-21 Krasnodar 1-3 M. Saransk 58/13 2,94 1.49/35 1.25/8 2.00/17 1.00/18   12/0 4,00 1.50/6 1.13/8 0.00/3 3.00/3