SELECT * FROM 1_Kampe WHERE LigaID = '248' 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-07-17 Chertanovo M. 1-1 R. Volgograd 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
2018-07-22 Zenit 2 1-2 Chertanovo M. 1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-07-29 Chertanovo M. 3-1 Baltika 3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1   2/-4 4,00 0.00/2 0.00/2 0.00/1 0.00/1
2018-08-04 Nizhny Novgorod 2-1 Chertanovo M. 6/1 2,75 1.50/4 1.50/4 3.00/1 1.00/3   6/3 3,00 2.33/3 2.33/3 2.00/2 3.00/1
2018-08-04 Pari NN 2-1 Chertanovo M. 4/1 2,33 1.67/3 1.67/3 3.00/1 1.00/2   7/2 3,00 1.75/4 1.40/5 2.00/2 1.50/2
2018-08-08 Chertanovo M. 1-1 Armavir 8/1 3,00 1.40/5 1.40/5 2.00/2 1.00/3   1/-8 2,00 0.00/5 0.00/5 0.00/3 0.00/2
2018-08-12 Krasnodar 2 3-1 Chertanovo M. 9/4 2,33 2.33/6 2.33/6 1.00/2 3.00/4   9/1 2,83 1.33/6 1.33/6 1.67/3 1.00/3
2018-08-18 Chertanovo M. 2-2 SKA Khabarovsk 10/-1 3,00 1.14/7 1.14/7 1.67/3 0.75/4   11/4 2,57 1.71/7 1.71/7 2.00/5 1.00/2
2018-08-26 FK Saransk 1-2 Chertanovo M. 13/2 3,00 1.25/8 1.25/8 1.25/4 1.25/4   12/-1 3,13 1.13/8 1.13/8 1.50/4 0.75/4
2018-08-26 M. Saransk 1-2 Chertanovo M. 11/2 2,86 1.29/7 1.29/7 1.33/3 1.25/4   14/0 3,11 1.33/9 1.38/8 1.50/4 1.20/5
2018-09-01 Chertanovo M. 4-0 Tyumen 16/1 3,10 1.50/10 1.38/8 1.50/4 1.50/6   11/-1 2,30 1.00/10 0.88/8 1.25/8 0.00/2
2018-09-08 Tambov 2-2 Chertanovo M. 20/8 2,91 2.00/11 1.88/8 1.17/6 3.00/5   20/5 3,18 1.64/11 1.38/8 1.80/5 1.50/6
2018-09-15 Chertanovo M. 2-1 FK Novosibirsk 22/5 3,25 1.58/12 1.50/8 1.80/5 1.43/7   8/-8 2,00 1.08/12 1.00/8 1.00/4 1.13/8
2018-09-19 Chertanovo M. 1-1 Luch 24/6 3,23 1.69/13 1.88/8 2.00/6 1.43/7   4/-2 0,77 0.85/13 0.75/8 0.88/8 0.80/5
2018-09-23 Tomsk 3-1 Chertanovo M. 20/12 1,87 2.13/15 2.00/8 2.20/10 2.00/5   25/6 3,14 1.64/14 1.88/8 1.86/7 1.43/7
2018-09-30 Chertanovo M. 2-6 Sochi 26/4 3,20 1.53/15 1.88/8 1.86/7 1.25/8   21/1 2,56 1.25/16 0.75/8 0.63/8 1.88/8
2018-10-06 Kursk 2-1 Chertanovo M. 24/10 2,24 2.06/17 2.38/8 2.00/8 2.11/9   28/0 3,50 1.44/16 1.75/8 1.63/8 1.25/8
2018-10-13 Chertanovo M. 0-1 Shinnik Yaroslavl 29/-1 3,47 1.35/17 1.38/8 1.63/8 1.11/9   18/-2 2,11 1.28/18 1.13/8 1.45/11 1.00/7
2018-10-20 Spartak Moscow 2 0-2 Chertanovo M. 26/9 2,26 1.89/19 1.63/8 2.13/8 1.73/11   29/-2 3,33 1.28/18 1.00/8 1.44/9 1.11/9
2018-10-24 Chertanovo M. 2-1 F. Voronezh 31/0 3,26 1.37/19 1.00/8 1.44/9 1.30/10   19/-3 2,28 1.06/18 0.75/8 1.20/10 0.88/8
2018-10-24 Chertanovo M. 2-1 Fakel Voronezh 33/1 3,25 1.45/20 1.25/8 1.60/10 1.30/10   19/-1 2,17 1.22/18 1.13/8 1.50/10 0.88/8
2018-10-28 Khimki 3-2 Chertanovo M. 26/-8 2,86 1.10/21 0.88/8 1.13/8 1.08/13   35/2 3,24 1.52/21 1.25/8 1.73/11 1.30/10
2018-11-04 Chertanovo M. 4-0 Zenit 2 37/1 3,32 1.45/22 1.13/8 1.73/11 1.18/11   14/-18 2,09 0.41/22 0.25/8 0.30/10 0.50/12
2018-11-10 Armavir 1-3 Chertanovo M. 26/-13 2,71 0.88/24 0.75/8 1.00/10 0.79/14   41/5 3,35 1.52/23 1.50/8 1.83/12 1.18/11
2018-11-14 Chertanovo M. 3-1 Nizhny Novgorod 44/7 3,38 1.58/24 1.88/8 1.83/12 1.33/12   22/3 1,78 1.43/23 1.63/8 1.89/9 1.14/14
2018-11-14 Chertanovo M. 3-1 Pari NN 47/9 3,40 1.64/25 2.63/8 1.92/13 1.33/12   20/4 1,71 1.52/21 1.63/8 1.89/9 1.25/12
2018-11-18 Baltika 2-0 Chertanovo M. 25/-14 2,56 1.00/25 1.38/8 1.08/13 0.92/12   50/11 3,42 1.69/26 2.63/8 2.00/14 1.33/12
2018-11-24 Chertanovo M. 3-0 Krasnodar 2 50/9 3,37 1.63/27 2.25/8 2.00/14 1.23/13   36/3 2,56 1.48/27 0.75/8 1.14/14 1.85/13
2019-03-03 SKA Khabarovsk 1-3 Chertanovo M. 36/6 2,36 1.61/28 2.13/8 1.77/13 1.47/15   53/12 3,36 1.68/28 2.25/8 2.07/15 1.23/13
2019-03-10 Chertanovo M. 0-2 FK Saransk 56/14 3,38 1.72/29 2.25/8 2.07/15 1.36/14   33/1 2,41 1.41/27 1.38/8 0.93/14 1.92/13
2019-03-10 Chertanovo M. 0-2 M. Saransk 56/12 3,33 1.67/30 1.88/8 1.94/16 1.36/14   29/0 2,32 1.36/25 1.38/8 0.92/13 1.83/12
2019-03-16 Tyumen 1-1 Chertanovo M. 27/-10 2,06 1.00/31 0.88/8 1.56/16 0.40/15   56/10 3,29 1.61/31 1.88/8 1.82/17 1.36/14
2019-03-24 Chertanovo M. 0-1 Tambov 57/10 3,25 1.59/32 1.63/8 1.82/17 1.33/15   50/21 2,47 1.88/32 1.63/8 1.80/15 1.94/17
2019-03-30 FK Novosibirsk 1-2 Chertanovo M. 24/-17 1,97 0.97/33 1.38/8 1.31/16 0.65/17   57/9 3,18 1.55/33 1.25/8 1.72/18 1.33/15
2019-04-07 Luch 0-0 Chertanovo M. 25/2 1,41 1.26/34 0.88/8 1.50/16 1.06/18   59/10 3,18 1.59/34 1.25/8 1.72/18 1.44/16
2019-04-13 Chertanovo M. 1-1 Tomsk 59/10 3,09 1.57/35 1.38/8 1.72/18 1.41/17   40/19 1,74 1.83/35 1.50/8 2.26/19 1.31/16
2019-04-20 Sochi 2-1 Chertanovo M. 58/23 2,51 1.68/37 2.50/8 1.47/19 1.89/18   60/10 3,06 1.56/36 1.13/8 1.68/19 1.41/17
2019-04-24 Chertanovo M. 3-2 Kursk 61/9 3,05 1.51/37 0.75/8 1.68/19 1.33/18   50/16 2,27 1.73/37 1.63/8 2.16/19 1.28/18
2019-04-28 Shinnik Yaroslavl 3-3 Chertanovo M. 36/5 1,72 1.51/39 1.25/8 1.79/19 1.25/20   64/10 3,11 1.55/38 1.13/8 1.75/20 1.33/18
2019-05-04 Chertanovo M. 1-0 Spartak Moscow 2 67/10 3,18 1.54/39 1.25/8 1.75/20 1.32/19   52/2 2,55 1.35/40 1.38/8 1.43/21 1.26/19
2019-05-11 F. Voronezh 1-1 Chertanovo M. 37/-4 2,11 1.08/37 1.00/8 1.28/18 0.89/19   68/11 3,13 1.58/40 1.50/8 1.81/21 1.32/19
2019-05-11 Fakel Voronezh 1-1 Chertanovo M. 36/-3 2,03 1.14/37 0.88/8 1.44/18 0.84/19   69/11 3,10 1.56/41 1.38/8 1.81/21 1.30/20
2019-05-19 Chertanovo M. 2-1 Khimki 70/11 3,07 1.55/42 1.38/8 1.81/21 1.29/21   48/-6 2,43 1.29/42 1.88/8 1.43/21 1.14/21
2019-05-25 R. Volgograd 1-2 Chertanovo M. 40/0 1,86 1.35/43 1.00/8 1.62/21 1.09/22   72/12 3,07 1.58/43 1.63/8 1.86/22 1.29/21