SELECT * FROM 1_Kampe WHERE LigaID = '239' AND (Home='CSKA Moscow' OR Away='CSKA Moscow') 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-31 Krylya Sovetov 0-0 CSKA Moscow 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-31 FK Krylya Sovetov Samara 0-0 CSKA Moscow 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   0/0 0,00 1.00/1 1.00/2 0.00/0 1.00/1
2018-08-05 CSKA Moscow 0-1 FK Rostov 0/0 0,00 1.00/2 1.00/2 0.00/0 1.00/2   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-11 Yenisey 1-1 CSKA Moscow 0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1   0/-1 0,33 0.67/3 0.67/3 0.00/1 1.00/2
2018-08-18 CSKA Moscow 3-0 Arsenal Tula 1/-1 0,75 0.75/4 0.75/4 0.00/1 1.00/3   3/1 1,67 1.33/3 1.33/3 2.00/2 0.00/1
2018-08-25 Rubin Kazan 1-1 CSKA Moscow 4/0 2,00 1.25/4 1.25/4 1.50/2 1.00/2   4/2 1,20 1.20/5 1.20/5 1.50/2 1.00/3
2018-09-01 CSKA Moscow 4-0 Ural 5/2 1,33 1.17/6 1.17/6 1.50/2 1.00/4   5/-4 2,80 0.80/5 0.80/5 1.00/4 0.00/1
2018-09-15 Ufa 0-3 CSKA Moscow 4/-4 2,00 0.67/6 0.67/6 1.00/4 0.00/2   9/6 1,71 1.43/7 1.43/7 2.00/3 1.00/4
2018-09-23 CSKA Moscow 1-1 Spartak Moscow 12/9 1,88 1.63/8 1.63/8 2.00/3 1.40/5   6/3 1,29 2.00/7 2.00/7 2.25/4 1.67/3
2018-09-28 Orenburg 0-1 CSKA Moscow 13/5 2,33 1.56/9 1.75/8 1.33/3 1.67/6   13/9 1,89 1.56/9 1.63/8 1.75/4 1.40/5
2018-10-07 CSKA Moscow 0-1 Lokomotiv Moscow 14/10 1,80 1.70/10 1.88/8 1.75/4 1.67/6   11/1 2,10 1.50/10 1.63/8 2.00/4 1.17/6
2018-10-19 FK Anzi Makhackala 0-2 CSKA Moscow 6/-10 2,00 0.91/11 0.88/8 1.00/3 0.88/8   14/9 1,73 1.55/11 1.88/8 1.40/5 1.67/6
2018-10-28 CSKA Moscow 1-2 Krasnodar 16/11 1,75 1.67/12 2.13/8 1.40/5 1.86/7   21/12 2,50 1.83/12 2.00/8 1.50/4 2.00/8
2018-11-03 Dynamo Moscow 0-0 CSKA Moscow 10/-1 1,62 1.08/13 1.00/8 2.00/5 0.50/8   17/10 1,85 1.54/13 1.75/8 1.17/6 1.86/7
2018-11-11 CSKA Moscow 2-0 Zenit 17/10 1,71 1.50/14 1.75/8 1.17/6 1.75/8   23/14 2,29 2.43/14 2.25/8 2.67/6 2.25/8
2018-11-23 Akhmat Grozny 0-2 CSKA Moscow 14/-1 1,93 1.47/15 1.50/8 1.67/6 1.33/9   19/12 1,73 1.60/15 1.75/8 1.43/7 1.75/8
2018-12-02 FK Rostov 0-0 CSKA Moscow 14/3 1,56 1.44/16 1.13/8 1.33/9 1.57/7   21/14 1,75 1.69/16 1.75/8 1.43/7 1.89/9
2018-12-08 CSKA Moscow 2-1 Yenisey 21/14 1,65 1.65/17 1.75/8 1.43/7 1.80/10   11/-15 2,18 0.76/17 0.63/8 1.00/9 0.50/8
2019-03-02 Arsenal Tula 2-0 CSKA Moscow 27/2 2,89 1.28/18 1.38/8 1.90/10 0.50/8   23/15 1,72 1.72/18 1.75/8 1.63/8 1.80/10
2019-03-09 CSKA Moscow 3-0 Rubin Kazan 23/13 1,74 1.63/19 1.75/8 1.63/8 1.64/11   20/5 1,84 1.63/19 1.38/8 2.00/11 1.13/8
2019-03-16 Ural 0-1 CSKA Moscow 20/-11 2,55 1.20/20 1.38/8 1.27/11 1.11/9   26/16 1,80 1.70/20 1.75/8 1.78/9 1.64/11
2019-03-31 CSKA Moscow 2-2 Ufa 27/17 1,76 1.76/21 2.13/8 1.78/9 1.75/12   15/-10 1,90 0.76/21 0.63/8 0.92/12 0.56/9
2019-04-06 Spartak Moscow 0-2 CSKA Moscow 31/10 2,36 1.77/22 2.50/8 1.67/12 1.90/10   29/17 1,86 1.73/22 2.13/8 1.70/10 1.75/12
2019-04-13 CSKA Moscow 2-3 Orenburg 31/19 1,87 1.78/23 2.13/8 1.70/10 1.85/13   31/5 2,38 1.46/24 1.25/8 1.67/12 1.25/12
2019-04-20 Lokomotiv Moscow 1-1 CSKA Moscow 36/13 2,36 1.84/25 2.25/8 1.92/12 1.77/13   33/18 2,00 1.71/24 1.75/8 1.55/11 1.85/13
2019-04-24 CSKA Moscow 2-0 FK Anzi Makhackala 34/18 2,00 1.68/25 1.75/8 1.55/11 1.79/14   11/-33 2,12 0.73/26 0.50/8 0.69/13 0.77/13
2019-04-28 Krasnodar 2-0 CSKA Moscow 48/26 2,59 1.81/27 1.50/8 1.93/14 1.69/13   36/20 2,00 1.73/26 1.75/8 1.67/12 1.79/14
2019-05-05 CSKA Moscow 2-2 Dynamo Moscow 36/18 2,00 1.67/27 1.75/8 1.67/12 1.67/15   22/0 1,57 1.14/28 1.13/8 1.57/14 0.71/14
2019-05-12 Zenit 3-1 CSKA Moscow 55/27 2,86 2.21/29 2.50/8 2.64/14 1.80/15   38/18 2,07 1.64/28 1.50/8 1.62/13 1.67/15
2019-05-18 CSKA Moscow 1-0 Akhmat Grozny 39/16 2,14 1.59/29 1.13/8 1.62/13 1.56/16   31/0 2,07 1.50/30 1.88/8 1.47/15 1.53/15
2019-05-26 CSKA Moscow 6-0 Krylya Sovetov 40/17 2,10 1.63/30 1.38/8 1.71/14 1.56/16   25/-15 2,24 0.97/29 0.50/8 1.13/15 0.79/14
2019-05-26 CSKA Moscow 6-0 FK Krylya Sovetov Samara 46/23 2,23 1.68/31 1.75/8 1.80/15 1.56/16   25/-15 2,24 0.97/29 0.50/8 1.13/15 0.79/14