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
2013-07-17 Krasnodar 1-2 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
2013-07-21 FK Rostov 2-2 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
2013-07-29 Krasnodar 2-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
2013-08-05 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
2013-08-18 Krasnodar 1-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
2013-08-24 FK Anzi Makhackala 1-2 Krasnodar 5/-5 2,50 0.50/6 0.50/6 0.50/2 0.50/4   7/-2 3,20 1.00/5 1.00/5 1.33/3 0.50/2
2013-08-31 Krasnodar 3-0 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
2013-09-14 Krasnodar 1-1 FK Krylya Sovetov Samara 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
2013-09-14 Krasnodar 1-1 Krylya Sovetov 13/2 3,00 1.50/8 1.63/8 1.60/5 1.33/3   5/-1 1,57 1.00/7 1.00/7 1.25/4 0.67/3
2013-09-21 Akhmat Grozny 0-1 Krasnodar 3/-6 1,50 0.38/8 0.38/8 0.75/4 0.00/4   14/2 2,89 1.44/9 1.63/8 1.50/6 1.33/3
2013-09-25 Spartak Moscow 3-2 Krasnodar 19/11 2,70 2.30/10 2.13/8 2.33/3 2.29/7   15/3 2,70 1.60/10 1.88/8 1.50/6 1.75/4
2013-09-29 Krasnodar 1-0 Rubin Kazan 17/2 2,91 1.45/11 1.50/8 1.50/6 1.40/5   11/3 1,73 1.27/11 1.13/8 1.17/6 1.40/5
2013-10-05 Ural 0-2 Krasnodar 11/-12 2,83 0.67/12 0.50/8 0.29/7 1.20/5   18/3 2,75 1.58/12 1.88/8 1.71/7 1.40/5
2013-10-19 Krasnodar 4-0 Tomsk 20/5 2,69 1.69/13 2.13/8 1.71/7 1.67/6   9/-12 2,31 0.62/13 1.00/8 0.67/6 0.57/7
2013-10-27 CSKA Moscow 5-1 Krasnodar 14/-2 2,14 1.71/14 1.25/8 2.29/7 1.14/7   24/9 2,79 1.79/14 2.13/8 1.88/8 1.67/6
2013-11-03 Krasnodar 1-2 Kuban 25/5 3,00 1.67/15 1.75/8 1.88/8 1.43/7   17/-2 2,40 1.20/15 1.00/8 1.71/7 0.75/8
2013-11-10 Rubin Kazan 0-1 Krasnodar 18/4 2,00 1.13/16 0.75/8 1.25/8 1.00/8   26/4 3,00 1.56/16 1.63/8 1.67/9 1.43/7
2013-11-25 Krasnodar 3-2 Akhmat Grozny 27/5 2,88 1.65/17 1.88/8 1.67/9 1.63/8   8/-12 1,65 0.53/17 0.75/8 0.78/9 0.25/8
2013-12-01 FK Krylya Sovetov Samara 1-0 Krasnodar 17/-5 2,29 1.06/17 1.13/8 0.89/9 1.25/8   30/6 3,00 1.72/18 1.88/8 1.80/10 1.63/8
2013-12-01 Krylya Sovetov 1-0 Krasnodar 17/-5 2,29 1.06/17 1.13/8 0.89/9 1.25/8   30/5 2,89 1.63/19 1.50/8 1.80/10 1.44/9
2013-12-06 Krasnodar 1-0 CSKA Moscow 30/4 2,80 1.55/20 1.50/8 1.80/10 1.30/10   26/7 2,37 1.95/19 1.63/8 2.50/10 1.33/9
2014-03-08 Krasnodar 0-1 Ural 31/5 2,71 1.62/21 1.50/8 1.91/11 1.30/10   18/-21 2,71 0.67/21 0.75/8 0.33/12 1.11/9
2014-03-17 Tomsk 1-1 Krasnodar 13/-16 2,00 0.76/21 1.00/8 0.89/9 0.67/12   31/4 2,64 1.55/22 1.13/8 1.75/12 1.30/10
2014-03-22 Krasnodar 4-0 Spartak Moscow 32/4 2,61 1.52/23 1.25/8 1.75/12 1.27/11   41/17 2,95 1.95/22 1.63/8 2.10/10 1.83/12
2014-03-30 Kuban 1-3 Krasnodar 27/-2 2,43 1.17/23 1.13/8 1.60/10 0.85/13   36/8 2,67 1.58/24 1.63/8 1.85/13 1.27/11
2014-04-06 Krasnodar 0-2 FK Rostov 39/10 2,72 1.64/25 1.63/8 1.85/13 1.42/12   33/3 2,52 1.40/25 1.88/8 1.15/13 1.67/12
2014-04-12 Zenit 4-1 Krasnodar 56/29 3,19 2.15/26 2.13/8 2.31/13 2.00/13   39/8 2,69 1.58/26 1.25/8 1.71/14 1.42/12
2014-04-20 Dynamo Moscow 1-2 Krasnodar 49/19 2,93 1.93/27 2.13/8 2.07/15 1.75/12   40/5 2,78 1.52/27 1.25/8 1.71/14 1.31/13
2014-04-26 Krasnodar 1-3 Lokomotiv Moscow 42/6 2,79 1.57/28 1.63/8 1.71/14 1.43/14   51/30 2,57 2.11/28 2.25/8 2.27/15 1.92/13
2014-05-02 Volga N. Novgorod 0-1 Krasnodar 24/-40 3,03 0.76/29 0.38/8 1.07/14 0.47/15   43/4 2,83 1.52/29 1.25/8 1.60/15 1.43/14
2014-05-11 Krasnodar 1-0 FK Anzi Makhackala 44/5 2,77 1.57/30 1.63/8 1.60/15 1.53/15   26/-15 2,31 0.72/29 1.13/8 0.93/14 0.53/15
2014-05-15 Amkar 2-2 Krasnodar 36/-1 2,35 1.26/31 0.38/8 1.67/15 0.88/16   45/6 2,71 1.61/31 1.88/8 1.69/16 1.53/15