SELECT * FROM 1_Kampe WHERE LigaID = '241' 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
2016-07-30 FK Anzi Makhackala 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
2016-08-07 Orenburg 0-1 CSKA Moscow 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1
2016-08-13 Ural 0-1 CSKA Moscow 2/2 1,00 2.00/2 2.00/2 3.00/1 1.00/1   1/1 0,50 2.00/2 2.00/2 0.00/0 2.00/2
2016-08-20 Zenit 1-1 CSKA Moscow 3/1 1,67 1.67/3 1.67/3 2.00/2 1.00/1   2/2 0,67 2.33/3 2.33/3 0.00/0 2.33/3
2016-08-27 Tomsk 0-1 CSKA Moscow 3/-5 2,75 1.00/4 1.00/4 3.00/1 0.33/3   3/2 1,00 2.00/4 2.00/4 0.00/0 2.00/4
2016-09-10 CSKA Moscow 3-0 Akhmat Grozny 4/3 1,00 2.20/5 2.20/5 0.00/0 2.20/5   8/1 2,50 2.17/6 2.17/6 2.50/4 1.50/2
2016-09-18 Krylya Sovetov 1-2 CSKA Moscow 2/-4 1,33 0.33/6 0.33/6 0.50/2 0.25/4   7/6 1,33 2.33/6 2.33/6 3.00/1 2.20/5
2016-09-18 FK Krylya Sovetov Samara 1-2 CSKA Moscow 2/-4 1,33 0.33/6 0.33/6 0.50/2 0.25/4   9/7 1,57 2.43/7 2.50/8 3.00/1 2.33/6
2016-09-24 CSKA Moscow 1-1 Krasnodar 11/8 1,75 2.50/8 2.50/8 3.00/1 2.43/7   12/5 2,38 1.50/8 1.50/8 2.25/4 0.75/4
2016-10-02 FK Rostov 2-0 CSKA Moscow 13/4 2,44 1.78/9 1.63/8 2.67/6 0.00/3   12/8 1,78 2.33/9 2.50/8 2.00/2 2.43/7
2016-10-14 CSKA Moscow 1-0 Ufa 12/6 1,80 2.10/10 2.13/8 2.00/2 2.13/8   6/-1 1,30 1.50/10 1.75/8 0.75/4 2.00/6
2016-10-23 Lokomotiv Moscow 1-0 CSKA Moscow 6/-2 1,27 0.91/11 0.88/8 0.80/5 1.00/6   13/7 1,73 2.18/11 2.13/8 2.33/3 2.13/8
2016-10-29 Spartak Moscow 3-1 CSKA Moscow 19/12 2,17 2.33/12 2.25/8 2.57/7 2.00/5   13/6 1,67 2.00/12 2.00/8 2.33/3 1.89/9
2016-11-06 CSKA Moscow 2-2 Amkar 14/4 1,85 1.85/13 1.63/8 2.33/3 1.70/10   9/3 1,15 1.62/13 1.63/8 2.14/7 1.00/6
2016-11-18 Arsenal Tula 0-1 CSKA Moscow 6/-15 1,93 0.71/14 0.63/8 1.00/6 0.50/8   16/4 2,00 1.79/14 1.38/8 2.00/4 1.70/10
2016-11-26 CSKA Moscow 0-0 Rubin Kazan 17/5 1,93 1.87/15 1.38/8 2.00/4 1.82/11   21/4 2,53 1.47/15 2.00/8 2.00/9 0.67/6
2016-11-30 CSKA Moscow 2-0 Orenburg 17/5 1,81 1.81/16 1.13/8 1.80/5 1.82/11   12/-4 1,75 0.94/16 1.38/8 1.30/10 0.33/6
2016-12-03 CSKA Moscow 4-0 Ural 19/7 1,82 1.88/17 1.38/8 2.00/6 1.82/11   13/-10 2,12 0.88/17 0.75/8 0.88/8 0.89/9
2017-03-04 CSKA Moscow 0-0 Zenit 23/11 1,94 1.94/18 1.75/8 2.14/7 1.82/11   36/22 2,78 2.11/18 2.00/8 2.64/11 1.29/7
2017-03-11 CSKA Moscow 4-0 Tomsk 23/11 1,84 1.89/19 1.50/8 2.00/8 1.82/11   8/-32 2,53 0.47/19 0.13/8 0.88/8 0.18/11
2017-03-19 Akhmat Grozny 0-1 CSKA Moscow 22/0 2,20 1.60/20 1.38/8 1.92/12 1.13/8   27/15 1,95 1.95/20 1.88/8 2.11/9 1.82/11
2017-04-02 CSKA Moscow 2-1 FK Krylya Sovetov Samara 28/16 1,90 2.00/21 2.25/8 2.11/9 1.92/12   17/-7 2,05 0.80/20 1.13/8 1.30/10 0.30/10
2017-04-02 CSKA Moscow 2-1 Krylya Sovetov 30/17 1,95 2.05/22 2.50/8 2.20/10 1.92/12   17/-7 2,05 0.80/20 1.13/8 1.30/10 0.30/10
2017-04-09 Krasnodar 1-1 CSKA Moscow 30/11 2,13 1.57/23 1.38/8 2.00/13 1.00/10   32/18 2,00 2.09/23 2.50/8 2.27/11 1.92/12
2017-04-15 CSKA Moscow 0-0 FK Rostov 33/18 2,00 2.04/24 2.50/8 2.27/11 1.85/13   27/14 1,67 1.50/24 1.13/8 2.33/12 0.67/12
2017-04-21 Ufa 0-2 CSKA Moscow 18/0 1,44 1.56/25 1.75/8 1.33/12 1.77/13   33/18 1,92 2.00/25 2.25/8 2.17/12 1.85/13
2017-04-26 CSKA Moscow 4-0 Lokomotiv Moscow 35/20 1,92 2.04/26 2.25/8 2.17/12 1.93/14   36/17 2,12 1.50/26 1.88/8 1.31/13 1.69/13
2017-04-30 CSKA Moscow 1-2 Spartak Moscow 39/24 2,00 2.07/27 2.50/8 2.23/13 1.93/14   40/13 2,48 2.22/27 2.13/8 2.79/14 1.62/13
2017-05-06 Amkar 0-2 CSKA Moscow 26/0 1,86 1.29/28 0.63/8 2.00/13 0.67/15   40/23 2,04 2.00/28 2.13/8 2.07/14 1.93/14
2017-05-12 CSKA Moscow 3-0 Arsenal Tula 42/25 2,03 2.03/29 2.13/8 2.07/14 2.00/15   18/-20 1,93 0.97/29 1.50/8 1.71/14 0.27/15
2017-05-17 Rubin Kazan 0-2 CSKA Moscow 31/0 2,07 1.30/30 1.13/8 1.67/15 0.93/15   45/28 2,07 2.07/30 2.13/8 2.13/15 2.00/15
2017-05-21 CSKA Moscow 4-0 FK Anzi Makhackala 47/30 2,06 2.10/31 2.13/8 2.13/15 2.06/16   26/-13 2,10 0.97/31 0.75/8 0.94/16 1.00/15