SELECT * FROM 1_Kampe WHERE LigaID = '241' AND (Home='Rubin Kazan' OR Away='Rubin Kazan') 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 Amkar 1-3 Rubin Kazan 26/-3 1,77 1.19/31 0.50/8 1.73/15 0.69/16   31/-2 2,06 1.26/31 1.00/8 1.56/16 0.93/15
2018-10-21 Ufa 1-3 Rubin Kazan 8/0 1,23 1.46/13 1.88/8 0.80/5 1.88/8   18/3 2,54 1.38/13 1.88/8 2.13/8 0.20/5
2018-10-21 Rubin Kazan 1-3 Lokomotiv Moscow 16/1 2,58 1.25/12 1.63/8 2.00/7 0.20/5   7/-1 1,25 1.08/12 1.13/8 1.17/6 1.00/6
2018-10-21 Akhmat Grozny 1-3 Rubin Kazan 11/-3 2,27 1.64/11 1.50/8 2.17/6 1.00/5   15/3 2,45 1.36/11 1.63/8 2.00/7 0.25/4
2018-10-21 Rubin Kazan 1-3 FK Krylya Sovetov Samara 9/-3 2,33 1.00/9 1.00/8 1.60/5 0.25/4   5/-4 1,56 0.67/9 0.75/8 1.00/4 0.40/5
2018-10-21 Krasnodar 1-3 Rubin Kazan 13/5 2,33 1.44/9 1.25/8 2.25/4 0.80/5   9/-2 2,50 1.13/8 1.13/8 1.60/5 0.33/3
2018-10-21 Rubin Kazan 1-3 Tomsk 7/-3 2,43 0.86/7 0.86/7 1.25/4 0.33/3   4/-6 2,00 1.00/7 1.00/7 2.00/3 0.25/4
2018-10-21 Zenit 1-3 Rubin Kazan 12/9 2,50 2.00/6 2.00/6 2.00/4 2.00/2   6/0 2,00 1.00/6 1.00/6 1.25/4 0.50/2
2018-10-21 Rubin Kazan 1-3 Ural 3/-2 1,60 0.60/5 0.60/5 0.67/3 0.50/2   3/0 1,20 1.00/5 1.00/5 1.33/3 0.50/2
2018-10-21 Orenburg 1-3 Rubin Kazan 0/-2 0,50 0.50/4 0.50/4 0.50/2 0.50/2   2/-2 1,50 0.50/4 0.50/4 0.67/3 0.00/1
2018-10-21 Rubin Kazan 1-3 FK Anzi Makhackala 1/-1 1,00 0.67/3 0.67/3 1.00/2 0.00/1   1/-1 1,00 1.33/3 1.33/3 2.00/2 0.00/1
2018-10-21 Rubin Kazan 1-3 Spartak Moscow 0/-1 0,50 0.50/2 0.50/2 1.00/1 0.00/1   6/6 2,00 3.00/3 3.00/3 3.00/3 0.00/0
2018-10-21 Arsenal Tula 1-3 Rubin Kazan 0/-4 4,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2018-10-21 Rubin Kazan 1-3 Amkar 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-10-21 Krylya Sovetov 1-3 Rubin Kazan 23/-6 2,26 0.87/23 1.13/8 1.27/11 0.50/12   26/1 2,04 1.28/25 0.88/8 1.69/13 0.83/12
2018-10-21 Rubin Kazan 1-3 FK Rostov 21/4 2,71 1.50/14 1.88/8 2.13/8 0.67/6   19/7 2,21 1.64/14 1.63/8 2.75/8 0.17/6
2018-10-21 CSKA Moscow 1-3 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
2018-10-21 Rubin Kazan 1-3 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
2018-10-21 FK Rostov 1-3 Rubin Kazan 32/18 1,59 1.59/29 1.63/8 2.47/15 0.64/14   29/2 1,93 1.34/29 1.13/8 1.67/15 1.00/14
2018-10-21 Rubin Kazan 1-3 Ufa 27/1 1,89 1.29/28 0.75/8 1.57/14 1.00/14   19/-2 1,43 1.50/28 1.00/8 1.36/14 1.64/14
2018-10-21 Lokomotiv Moscow 1-3 Rubin Kazan 36/13 2,19 1.44/27 1.50/8 1.31/13 1.57/14   26/0 1,93 1.22/27 0.50/8 1.57/14 0.85/13
2018-10-21 Rubin Kazan 1-3 Akhmat Grozny 26/1 1,96 1.27/26 0.88/8 1.69/13 0.85/13   27/-1 2,20 1.44/25 0.63/8 1.73/15 1.00/10
2018-10-21 FK Krylya Sovetov Samara 1-3 Rubin Kazan 23/-6 2,26 0.87/23 1.13/8 1.27/11 0.50/12   26/1 2,13 1.29/24 1.00/8 1.69/13 0.82/11
2018-10-21 Rubin Kazan 1-3 Krasnodar 26/2 2,17 1.35/23 1.13/8 1.83/12 0.82/11   31/11 2,13 1.54/24 1.13/8 1.93/14 1.00/10
2018-10-21 Tomsk 1-3 Rubin Kazan 9/-38 2,55 0.55/22 0.38/8 1.11/9 0.15/13   24/2 2,09 1.36/22 1.13/8 1.83/12 0.80/10
2018-10-21 Rubin Kazan 1-3 Zenit 24/4 2,10 1.43/21 1.50/8 2.00/11 0.80/10   38/23 2,52 2.00/21 1.75/8 2.67/12 1.11/9
2018-10-21 Ural 1-3 Rubin Kazan 14/-15 2,15 0.90/20 1.13/8 1.11/9 0.73/11   24/5 2,15 1.50/20 1.88/8 2.00/11 0.89/9
2018-10-21 Rubin Kazan 1-3 Orenburg 24/5 2,26 1.53/19 1.75/8 2.10/10 0.89/9   15/-6 1,89 0.95/19 1.38/8 1.45/11 0.25/8
2018-10-21 FK Anzi Makhackala 1-3 Rubin Kazan 14/-6 1,89 1.11/18 1.00/8 1.25/8 1.00/10   23/4 2,33 1.44/18 1.75/8 2.10/10 0.63/8
2018-10-21 Spartak Moscow 1-3 Rubin Kazan 25/9 2,28 2.22/18 2.25/8 2.67/9 1.78/9   22/5 2,29 1.53/17 2.13/8 2.10/10 0.71/7
2018-10-21 Rubin Kazan 1-3 Arsenal Tula 21/4 2,38 1.44/16 1.75/8 2.00/9 0.71/7   6/-17 1,81 0.63/16 0.50/8 0.86/7 0.44/9
2018-10-21 Rubin Kazan 1-3 Krylya Sovetov 12/0 2,40 1.20/10 1.63/8 1.83/6 0.25/4   5/-4 1,56 0.67/9 0.75/8 1.00/4 0.40/5