SELECT * FROM 1_Kampe WHERE LigaID = '239' 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-07-29 Rubin Kazan 2-1 Krasnodar 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-08-03 Dynamo Moscow 1-1 Rubin Kazan 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   2/1 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-08-13 Rubin Kazan 0-1 Zenit 3/1 2,50 2.00/2 2.00/2 3.00/1 1.00/1   3/3 1,50 3.00/2 3.00/2 3.00/1 3.00/1
2018-08-18 Akhmat Grozny 1-1 Rubin Kazan 2/-2 2,00 1.00/3 1.00/3 3.00/1 0.00/2   3/0 2,00 1.33/3 1.33/3 1.50/2 1.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,50 1.25/4 1.25/4 1.50/2 1.00/2
2018-08-31 FK Rostov 1-1 Rubin Kazan 7/6 1,60 2.40/5 2.40/5 2.00/3 3.00/2   5/0 2,00 1.20/5 1.20/5 1.33/3 1.00/2
2018-09-15 Rubin Kazan 1-0 Yenisey 6/0 2,00 1.17/6 1.17/6 1.33/3 1.00/3   2/-6 1,67 0.83/6 0.83/6 1.25/4 0.00/2
2018-09-22 Arsenal Tula 2-2 Rubin Kazan 7/1 1,86 1.14/7 1.14/7 1.75/4 0.33/3   7/1 1,86 1.43/7 1.43/7 1.75/4 1.00/3
2018-10-01 Rubin Kazan 2-1 Krylya Sovetov 9/1 2,13 1.38/8 1.38/8 1.75/4 1.00/4   2/-10 1,75 0.88/8 0.88/8 0.80/5 1.00/3
2018-10-06 Rubin Kazan 1-0 Ural 11/2 2,22 1.56/9 1.38/8 2.00/5 1.00/4   10/-6 2,89 1.22/9 1.38/8 1.33/6 1.00/3
2018-10-20 Ufa 0-0 Rubin Kazan 7/-6 2,00 0.90/10 0.63/8 1.17/6 0.50/4   12/3 2,10 1.70/10 1.63/8 2.17/6 1.00/4
2018-10-21 FK Krylya Sovetov Samara 1-3 Rubin Kazan 44/0 4,00 1.50/22 1.13/8 0.00/11 3.00/11   12/3 1,91 1.64/11 1.75/8 2.17/6 1.00/5
2018-10-21 Rubin Kazan 1-3 FK Krylya Sovetov Samara 15/5 2,08 1.75/12 1.88/8 2.17/6 1.33/6   12/0 4,00 1.50/6 1.13/8 0.00/3 3.00/3
2018-10-29 Rubin Kazan 1-1 Spartak Moscow 16/3 2,23 1.62/13 1.88/8 1.86/7 1.33/6   16/2 2,31 1.62/13 1.00/8 1.29/7 2.00/6
2018-11-05 Orenburg 1-0 Rubin Kazan 17/2 2,29 1.36/14 1.13/8 0.83/6 1.75/8   17/3 2,21 1.57/14 1.88/8 1.75/8 1.33/6
2018-11-11 Rubin Kazan 0-0 Lokomotiv Moscow 17/2 2,13 1.47/15 1.50/8 1.75/8 1.14/7   23/7 2,60 1.80/15 2.25/8 2.00/7 1.63/8
2018-11-24 FK Anzi Makhackala 1-1 Rubin Kazan 12/-13 2,31 1.00/16 1.25/8 1.00/6 1.00/10   17/2 2,00 1.44/16 1.50/8 1.67/9 1.14/7
2018-11-30 Rubin Kazan 1-1 Dynamo Moscow 18/2 2,00 1.41/17 1.25/8 1.67/9 1.13/8   15/-1 1,82 1.12/17 1.13/8 1.38/8 0.89/9
2018-12-09 Zenit 1-2 Rubin Kazan 30/11 2,72 2.06/18 1.50/8 2.38/8 1.80/10   19/2 2,00 1.39/18 1.00/8 1.60/10 1.13/8
2019-03-02 Rubin Kazan 1-0 Akhmat Grozny 21/3 2,05 1.47/19 1.25/8 1.60/10 1.33/9   19/-2 2,11 1.37/19 1.38/8 1.44/9 1.30/10
2019-03-09 CSKA Moscow 3-0 Rubin Kazan 27/13 2,05 1.65/20 1.38/8 1.44/9 1.82/11   22/4 2,00 1.55/20 1.63/8 1.73/11 1.33/9
2019-03-16 Rubin Kazan 0-2 FK Rostov 22/1 2,05 1.48/21 1.25/8 1.73/11 1.20/10   19/3 1,67 1.38/21 1.00/8 1.27/11 1.50/10
2019-03-30 Yenisey 1-1 Rubin Kazan 16/-23 2,50 0.64/22 0.63/8 0.70/10 0.58/12   22/-1 2,05 1.41/22 1.13/8 1.58/12 1.20/10
2019-04-07 Rubin Kazan 0-0 Arsenal Tula 23/-1 2,04 1.39/23 1.25/8 1.58/12 1.18/11   32/3 2,65 1.43/23 2.00/8 1.83/12 1.00/11
2019-04-12 Krylya Sovetov 1-0 Rubin Kazan 19/-10 2,18 1.09/22 1.25/8 1.18/11 1.00/11   23/-1 1,96 1.38/24 1.25/8 1.54/13 1.18/11
2019-04-21 Ural 2-1 Rubin Kazan 27/-12 2,64 1.20/25 0.63/8 1.23/13 1.17/12   23/-2 1,92 1.32/25 1.13/8 1.54/13 1.08/12
2019-04-24 Rubin Kazan 1-1 Ufa 24/-3 1,96 1.27/26 1.00/8 1.54/13 1.00/13   22/-9 2,04 0.92/26 0.75/8 1.00/14 0.83/12
2019-04-29 Spartak Moscow 1-1 Rubin Kazan 35/4 2,44 1.56/27 1.38/8 1.43/14 1.69/13   25/-3 1,96 1.26/27 0.75/8 1.50/14 1.00/13
2019-05-03 Rubin Kazan 2-0 Orenburg 26/-3 1,96 1.25/28 0.50/8 1.50/14 1.00/14   37/3 2,54 1.39/28 1.63/8 1.50/14 1.29/14
2019-05-10 Lokomotiv Moscow 4-0 Rubin Kazan 42/12 2,48 1.79/29 2.13/8 1.86/14 1.73/15   28/-1 1,97 1.31/29 0.88/8 1.60/15 1.00/14
2019-05-20 Rubin Kazan 0-0 FK Anzi Makhackala 28/-5 2,03 1.27/30 0.88/8 1.60/15 0.93/15   17/-35 2,30 0.77/30 0.25/8 0.67/15 0.87/15
2019-05-26 Krasnodar 1-0 Rubin Kazan 58/31 2,74 1.81/31 1.88/8 1.80/15 1.81/16   28/-5 1,97 1.26/31 0.88/8 1.56/16 0.93/15