SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Chertanovo M.' OR Away='Chertanovo M.') 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 Chertanovo M. 1-3 M. Saransk 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   75/-6 4,00 1.38/39 1.50/8 0.00/21 3.00/18
2018-10-21 M. Saransk 1-3 Chertanovo M. 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0
2018-10-21 Chertanovo M. 1-3 F. Voronezh 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   67/-6 4,00 1.37/35 1.13/8 0.00/19 3.00/16
2018-10-21 Chertanovo M. 1-3 Nizhny Novgorod 5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1   46/-4 4,00 1.38/24 1.13/8 0.00/13 3.00/11
2018-10-21 Nizhny Novgorod 1-3 Chertanovo M. 12/0 4,00 1.50/6 1.13/8 0.00/3 3.00/3   6/-4 4,00 0.75/4 1.50/8 0.00/3 3.00/1
2018-10-21 F. Voronezh 1-3 Chertanovo M. 31/-6 4,00 1.24/17 1.13/8 0.00/10 3.00/7   9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2
2018-10-21 Chertanovo M. 1-3 T. Moscow 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   37/-10 4,00 1.14/21 2.25/8 0.00/13 3.00/8
2018-10-21 T. Moscow 1-3 Chertanovo M. 1/-2 4,00 0.00/1 2.25/8 0.00/1 0.00/0   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2019-07-07 FK Chayka 0-1 Chertanovo M. 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 Chertanovo M. 2-1 Yenisey 17/1 3,67 1.67/9 1.50/8 0.00/4 3.00/5   17/1 3,67 1.67/9 1.50/8 0.00/4 3.00/5
2019-07-20 Fakel Voronezh 0-0 Chertanovo M. 4/-1 2,25 1.00/4 1.00/4 0.33/3 3.00/1   19/2 3,60 1.80/10 1.88/8 0.60/5 3.00/5
2019-07-24 Chertanovo M. 1-0 R. Volgograd 19/2 3,27 1.73/11 2.00/8 0.60/5 2.67/6   25/7 3,91 1.91/11 2.25/8 0.60/5 3.00/6
2019-07-28 Baltika 1-2 Chertanovo M. 18/-3 3,25 1.25/12 1.13/8 0.00/6 2.50/6   20/3 3,08 1.83/12 2.38/8 1.00/6 2.67/6
2019-08-03 Chertanovo M. 0-0 Khimki 22/4 3,08 1.92/13 2.38/8 1.00/6 2.71/7   33/13 4,08 1.92/13 2.00/8 1.00/6 2.71/7
2019-08-10 SKA Khabarovsk 0-0 Chertanovo M. 24/3 3,21 1.57/14 2.00/8 0.75/8 2.67/6   22/4 2,86 1.86/14 2.13/8 1.00/7 2.71/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 Mordovia Saransk 2-3 Chertanovo M. 6/-4 2,00 1.00/8 1.00/8 1.00/4 1.00/4   23/3 2,69 1.69/16 1.88/8 0.88/8 2.50/8
2019-08-18 FK Saransk 2-3 Chertanovo M. 14/-4 2,67 1.17/12 1.00/8 0.67/6 1.67/6   26/4 2,82 1.76/17 1.88/8 0.88/8 2.56/9
2019-08-25 Chertanovo M. 1-1 Tomsk 29/5 2,94 1.83/18 1.88/8 0.88/8 2.60/10   26/7 2,65 1.76/17 1.88/8 1.10/10 2.71/7
2019-08-31 Pari NN 0-0 Chertanovo M. 10/-3 2,09 1.36/11 1.75/8 1.40/5 1.33/6   30/5 2,89 1.79/19 1.88/8 0.89/9 2.60/10
2019-09-07 Chertanovo M. 2-2 Neftekhimik 30/5 2,75 1.75/20 1.63/8 0.89/9 2.45/11   30/2 2,90 1.50/20 1.00/8 0.56/9 2.27/11
2019-09-15 Armavir 1-1 Chertanovo M. 27/-6 2,73 1.18/22 1.13/8 0.91/11 1.45/11   32/5 2,81 1.71/21 1.38/8 0.90/10 2.45/11
2019-09-21 Chertanovo M. 0-1 Shinnik Yaroslavl 33/5 2,77 1.68/22 1.38/8 0.90/10 2.33/12   36/3 3,14 1.59/22 1.25/8 1.00/11 2.18/11
2019-09-29 Luch 0-1 Chertanovo M. 34/-2 2,92 1.38/24 1.63/8 0.64/14 2.40/10   33/4 2,70 1.61/23 1.25/8 0.82/11 2.33/12
2019-10-05 Chertanovo M. 2-2 Spartak Moscow 2 34/5 2,63 1.67/24 1.63/8 0.82/11 2.38/13   35/-5 3,13 1.17/24 0.50/8 0.64/11 1.62/13
2019-10-12 Kursk 0-1 Chertanovo M. 35/-9 3,04 1.15/26 1.13/8 0.92/13 1.38/13   36/5 2,68 1.64/25 1.38/8 0.83/12 2.38/13
2019-10-19 Torpedo Moscow 0-1 Chertanovo M. 74/35 2,90 2.36/39 2.25/8 2.30/23 2.44/16   37/6 2,62 1.69/26 1.38/8 0.83/12 2.43/14
2019-10-19 Torpedo Moscow 0-1 Chertanovo M. 74/34 2,85 2.30/40 1.50/8 2.21/24 2.44/16   38/7 2,56 1.74/27 1.88/8 0.83/12 2.47/15
2019-10-23 Chertanovo M. 1-0 Tekstilshtik 39/8 2,50 1.79/28 1.88/8 0.83/12 2.50/16   38/-22 3,50 0.93/28 0.75/8 0.58/12 1.19/16
2019-10-27 Yenisey 0-2 Chertanovo M. 34/-13 2,79 1.17/29 1.88/8 0.77/13 1.50/16   40/9 2,45 1.83/29 2.13/8 1.00/13 2.50/16
2019-11-03 Chertanovo M. 4-0 Fakel Voronezh 42/11 2,43 1.87/30 2.38/8 1.00/13 2.53/17   18/-18 2,35 0.91/23 0.63/8 0.85/13 1.00/10
2019-11-09 R. Volgograd 1-1 Chertanovo M. 51/14 2,84 1.90/31 2.75/8 1.36/14 2.35/17   46/15 2,48 1.90/31 2.75/8 1.14/14 2.53/17
2019-11-13 Chertanovo M. 3-1 Baltika 47/15 2,47 1.88/32 2.50/8 1.14/14 2.44/18   49/15 2,68 1.65/31 2.13/8 1.21/14 2.00/17
2019-11-17 Khimki 3-1 Chertanovo M. 60/29 2,76 1.85/33 1.88/8 1.88/16 1.82/17   50/17 2,52 1.91/33 2.75/8 1.27/15 2.44/18
2019-11-23 Chertanovo M. 1-0 SKA Khabarovsk 51/15 2,56 1.85/34 2.38/8 1.27/15 2.32/19   55/8 3,00 1.44/34 1.38/8 1.33/18 1.56/16
2020-03-10 Krasnodar 2 1-2 Chertanovo M. 50/2 2,80 1.23/35 1.63/8 0.80/15 1.55/20   52/16 2,51 1.89/35 2.38/8 1.38/16 2.32/19
2020-03-15 Chertanovo M. 3-0 Mordovia Saransk 54/17 2,53 1.92/36 2.38/8 1.38/16 2.35/20   21/-20 2,38 0.73/26 0.75/8 0.71/14 0.75/12
2020-03-15 Chertanovo M. 3-0 FK Saransk 57/20 2,54 1.95/37 2.38/8 1.47/17 2.35/20   29/-20 2,60 0.83/30 0.75/8 0.63/16 1.07/14
2020-03-22 Tomsk 0-0 Chertanovo M. 51/7 2,57 1.46/37 1.25/8 1.56/18 1.37/19   60/23 2,55 1.97/38 2.38/8 1.56/18 2.35/20
2020-03-29 Chertanovo M. 0-0 Pari NN 60/23 2,49 1.92/39 2.00/8 1.56/18 2.24/21   29/0 2,00 1.34/29 1.38/8 1.13/15 1.57/14
2020-04-04 Neftekhimik 0-0 Chertanovo M. 56/15 2,49 1.69/39 1.50/8 1.26/19 2.10/20   60/23 2,43 1.88/40 1.88/8 1.47/19 2.24/21
2020-04-08 Chertanovo M. 0-0 Armavir 60/23 2,37 1.83/41 1.50/8 1.47/19 2.14/22   40/-7 2,18 1.08/40 1.13/8 1.10/21 1.05/19
2020-04-12 Shinnik Yaroslavl 0-0 Chertanovo M. 61/7 2,74 1.40/42 0.88/8 1.00/20 1.77/22   60/23 2,31 1.79/42 1.50/8 1.40/20 2.14/22
2020-04-18 Chertanovo M. 0-0 Luch 60/23 2,26 1.74/43 1.13/8 1.40/20 2.04/23   48/-10 2,47 1.05/43 0.50/8 0.50/22 1.62/21
2020-04-26 Spartak Moscow 2 0-0 Chertanovo M. 58/-7 2,80 0.93/44 0.13/8 0.77/22 1.09/22   60/23 2,20 1.70/44 0.75/8 1.33/21 2.04/23
2020-05-02 Chertanovo M. 0-0 Kursk 60/23 2,16 1.67/45 0.38/8 1.33/21 1.96/24   50/-12 2,49 0.96/45 0.13/8 0.88/24 1.05/21
2020-05-06 Chertanovo M. 0-0 Torpedo Moscow 60/23 2,11 1.63/46 0.00/8 1.27/22 1.96/24   90/30 2,08 1.54/72 0.00/8 1.71/38 1.35/34
2020-05-10 Tekstilshtik 0-0 Chertanovo M. 42/-30 2,43 0.68/47 0.00/8 0.57/23 0.79/24   60/23 2,06 1.60/47 0.00/8 1.22/23 1.96/24
2020-05-16 Chertanovo M. 0-0 FK Chayka 60/23 2,02 1.56/48 0.00/8 1.22/23 1.88/25   51/3 2,06 1.13/48 0.00/8 1.04/24 1.21/24