SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Krasnodar 2' OR Away='Krasnodar 2') 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-10-21 Krasnodar 2 1-3 F. Voronezh 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   13/-2 4,00 1.29/7 1.13/8 0.00/4 3.00/3
2018-10-21 Krasnodar 2 1-3 Nizhny Novgorod 1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0   74/-4 4,00 1.42/38 1.13/8 0.00/20 3.00/18
2018-10-21 Krasnodar 2 1-3 T. Moscow 2/-4 4,00 0.00/2 1.50/8 0.00/2 0.00/0   48/-8 4,00 1.27/26 2.25/8 0.00/15 3.00/11
2018-10-21 M. Saransk 1-3 Krasnodar 2 38/-4 4,00 1.35/20 1.50/8 0.00/11 3.00/9   3/-6 4,00 0.00/3 1.50/8 0.00/3 0.00/0
2018-10-21 F. Voronezh 1-3 Krasnodar 2 47/-6 4,00 1.32/25 1.13/8 0.00/14 3.00/11   6/-4 4,00 0.75/4 1.50/8 0.00/3 3.00/1
2018-10-21 Krasnodar 2 1-3 M. Saransk 9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2   54/-4 4,00 1.39/28 1.50/8 0.00/15 3.00/13
2018-10-21 Nizhny Novgorod 1-3 Krasnodar 2 64/0 4,00 1.50/32 1.13/8 0.00/16 3.00/16   10/-4 4,00 1.00/6 1.50/8 0.00/4 3.00/2
2018-10-21 T. Moscow 1-3 Krasnodar 2 10/-4 4,00 1.00/6 2.25/8 0.00/4 3.00/2   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2019-07-09 Armavir 2-1 Krasnodar 2 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2019-07-13 Krasnodar 2 1-2 Luch 17/-1 3,89 1.33/9 1.13/8 0.00/4 2.40/5   18/-3 4,33 1.33/9 1.50/8 0.00/5 3.00/4
2019-07-20 Kursk 1-1 Krasnodar 2 16/-6 3,80 1.20/10 1.13/8 0.00/5 2.40/5   18/-2 3,80 1.20/10 0.75/8 0.00/5 2.40/5
2019-07-24 Krasnodar 2 1-1 Tekstilshtik 19/-2 3,64 1.18/11 0.88/8 0.00/5 2.17/6   19/-5 3,91 1.09/11 0.75/8 0.00/6 2.40/5
2019-07-28 Yenisey 0-1 Krasnodar 2 18/-7 3,58 1.25/12 1.13/8 0.00/5 2.14/7   20/-2 3,50 1.17/12 1.00/8 0.17/6 2.17/6
2019-08-03 Krasnodar 2 0-1 R. Volgograd 21/-1 3,31 1.31/13 1.38/8 0.17/6 2.29/7   26/6 3,54 1.69/13 2.00/8 0.67/6 2.57/7
2019-08-10 Khimki 3-0 Krasnodar 2 33/13 3,79 1.86/14 1.75/8 1.00/6 2.50/8   21/-2 3,14 1.21/14 1.38/8 0.14/7 2.29/7
2019-08-14 Chertanovo M. 1-2 Krasnodar 2 22/4 2,67 1.80/15 2.25/8 1.00/7 2.50/8   21/-5 3,13 1.13/15 1.00/8 0.14/7 2.00/8
2019-08-18 Krasnodar 2 0-1 Tomsk 23/-4 3,13 1.25/16 1.00/8 0.14/7 2.11/9   25/6 2,75 1.69/16 1.88/8 1.10/10 2.67/6
2019-08-25 Neftekhimik 1-0 Krasnodar 2 27/-1 3,24 1.24/17 0.75/8 0.25/8 2.11/9   23/-5 3,00 1.18/17 1.00/8 0.13/8 2.11/9
2019-08-31 Krasnodar 2 2-2 Shinnik Yaroslavl 23/-6 2,89 1.11/18 1.00/8 0.13/8 1.90/10   29/1 3,17 1.50/18 1.13/8 0.56/9 2.44/9
2019-09-07 Spartak Moscow 2 0-3 Krasnodar 2 31/3 3,11 1.42/19 1.38/8 0.78/9 2.00/10   25/-6 2,95 1.11/19 1.00/8 0.22/9 1.90/10
2019-09-14 Torpedo Moscow 2-1 Krasnodar 2 56/28 2,90 2.41/29 3.00/8 2.18/17 2.75/12   28/-3 2,95 1.20/20 1.25/8 0.22/9 2.00/11
2019-09-14 Torpedo Moscow 2-1 Krasnodar 2 54/27 2,89 2.39/28 3.00/8 2.13/16 2.75/12   29/-4 2,95 1.14/21 0.88/8 0.22/9 1.83/12
2019-09-21 FK Chayka 1-1 Krasnodar 2 28/2 2,57 1.38/21 1.50/8 0.78/9 1.83/12   30/-5 2,95 1.09/22 0.88/8 0.22/9 1.69/13
2019-09-30 Krasnodar 2 0-0 Fakel Voronezh 31/-5 2,91 1.09/23 1.00/8 0.22/9 1.64/14   13/-10 2,25 0.81/16 0.63/8 0.70/10 1.00/6
2019-10-05 Baltika 4-1 Krasnodar 2 35/4 2,87 1.48/23 2.00/8 0.70/10 2.08/13   31/-5 2,79 1.08/24 0.75/8 0.30/10 1.64/14
2019-10-12 Krasnodar 2 2-2 SKA Khabarovsk 32/-8 2,88 1.04/25 0.75/8 0.30/10 1.53/15   39/6 3,00 1.54/24 1.75/8 1.21/14 2.00/10
2019-10-19 FK Saransk 0-3 Krasnodar 2 21/-12 2,57 0.90/21 0.63/8 0.64/11 1.20/10   34/-8 2,92 1.04/26 0.88/8 0.36/11 1.53/15
2019-10-23 Krasnodar 2 2-2 Pari NN 37/-5 2,93 1.11/27 1.13/8 0.36/11 1.63/16   16/-3 1,94 1.33/18 1.50/8 1.50/10 1.13/8
2019-10-27 Luch 1-1 Krasnodar 2 37/-8 2,93 1.11/28 0.75/8 0.59/17 1.91/11   39/-5 2,96 1.11/28 0.88/8 0.42/12 1.63/16
2019-11-04 Krasnodar 2 1-0 Kursk 40/-5 2,93 1.10/29 1.00/8 0.42/12 1.59/17   36/-12 2,90 1.14/29 1.25/8 0.93/15 1.36/14
2019-11-09 Tekstilshtik 1-0 Krasnodar 2 39/-24 3,40 0.87/30 0.38/8 0.54/13 1.12/17   41/-4 2,87 1.17/30 1.38/8 0.62/13 1.59/17
2019-11-13 Krasnodar 2 4-0 Yenisey 41/-5 2,81 1.13/31 1.25/8 0.62/13 1.50/18   34/-16 2,71 1.10/31 1.75/8 0.71/14 1.41/17
2019-11-17 R. Volgograd 0-0 Krasnodar 2 53/15 2,84 1.88/32 2.50/8 1.33/15 2.35/17   45/-1 2,84 1.19/32 1.50/8 0.79/14 1.50/18
2019-11-23 Krasnodar 2 2-2 Khimki 45/-1 2,76 1.18/33 1.63/8 0.79/14 1.47/19   59/27 2,76 1.85/33 1.88/8 1.88/16 1.82/17
2020-03-10 Krasnodar 2 1-2 Chertanovo M. 47/-1 2,79 1.18/34 1.63/8 0.80/15 1.47/19   49/15 2,44 1.85/34 2.38/8 1.38/16 2.28/18
2020-03-15 Tomsk 2-1 Krasnodar 2 47/4 2,57 1.37/35 1.25/8 1.38/16 1.37/19   48/-2 2,80 1.14/35 1.25/8 0.75/16 1.47/19
2020-03-23 Krasnodar 2 0-0 Neftekhimik 49/-3 2,81 1.11/36 1.13/8 0.75/16 1.40/20   55/14 2,67 1.75/36 2.25/8 1.33/18 2.17/18
2020-03-29 Shinnik Yaroslavl 0-0 Krasnodar 2 59/6 3,03 1.49/37 1.63/8 1.00/17 1.90/20   49/-3 2,73 1.08/37 1.00/8 0.71/17 1.40/20
2020-04-04 Krasnodar 2 0-0 Spartak Moscow 2 49/-3 2,66 1.05/38 0.63/8 0.71/17 1.33/21   56/-8 3,16 1.00/38 0.38/8 0.74/19 1.26/19
2020-04-08 Krasnodar 2 0-0 Torpedo Moscow 49/-3 2,59 1.03/39 0.63/8 0.67/18 1.33/21   87/30 2,40 1.82/60 0.25/8 1.94/33 1.67/27
2020-04-08 Krasnodar 2 0-0 Torpedo Moscow 49/-3 2,53 1.00/40 0.13/8 0.63/19 1.33/21   87/30 2,36 1.79/61 0.00/8 1.94/33 1.61/28
2020-04-12 Krasnodar 2 0-0 FK Chayka 49/-3 2,46 0.98/41 0.13/8 0.60/20 1.33/21   48/1 2,38 1.25/40 1.00/8 1.10/20 1.40/20
2020-04-18 Fakel Voronezh 0-0 Krasnodar 2 18/-30 1,94 0.65/34 0.38/8 0.65/17 0.65/17   49/-3 2,40 0.95/42 0.00/8 0.57/21 1.33/21
2020-04-26 Krasnodar 2 0-0 Baltika 49/-3 2,35 0.93/43 0.00/8 0.57/21 1.27/22   50/11 2,17 1.34/41 0.50/8 1.10/21 1.60/20
2020-05-02 SKA Khabarovsk 0-0 Krasnodar 2 59/11 2,49 1.28/43 0.38/8 1.29/21 1.27/22   49/-3 2,30 0.91/44 0.00/8 0.55/22 1.27/22
2020-05-06 Krasnodar 2 0-0 FK Saransk 49/-3 2,24 0.89/45 0.00/8 0.55/22 1.22/23   29/-23 2,08 0.64/39 0.00/8 0.50/20 0.79/19
2020-05-10 Pari NN 0-0 Krasnodar 2 28/-1 1,58 1.00/36 0.00/8 0.94/18 1.06/18   49/-3 2,20 0.87/46 0.00/8 0.52/23 1.22/23
2020-05-16 Krasnodar 2 0-0 Armavir 49/-3 2,15 0.85/47 0.00/8 0.52/23 1.17/24   40/-7 1,89 0.91/46 0.00/8 0.96/23 0.87/23