SELECT * FROM 1_Kampe WHERE LigaID = '239' AND (Home='Ural' OR Away='Ural') 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-28 Ural 0-1 FK Anzi Makhackala 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-04 Ural 1-2 Krasnodar 0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0   1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1
2018-08-10 Ural 1-1 Dynamo Moscow 1/-2 2,00 0.00/2 0.00/2 0.00/2 0.00/0   1/0 1,00 1.00/2 1.00/2 1.00/1 1.00/1
2018-08-19 Zenit 4-1 Ural 4/4 1,33 3.00/3 3.00/3 3.00/1 3.00/2   2/-2 2,00 0.33/3 0.33/3 0.33/3 0.00/0
2018-08-25 Ural 2-1 Akhmat Grozny 3/-5 2,75 0.25/4 0.25/4 0.33/3 0.00/1   3/-2 2,00 1.00/4 1.00/4 2.00/2 0.00/2
2018-09-01 CSKA Moscow 4-0 Ural 5/2 1,60 1.20/5 1.20/5 1.50/2 1.00/3   5/-4 2,80 0.80/5 0.80/5 1.00/4 0.00/1
2018-09-17 Ural 1-1 FK Rostov 5/-8 3,00 0.67/6 0.67/6 1.00/4 0.00/2   8/6 1,67 2.17/6 2.17/6 1.75/4 3.00/2
2018-09-22 Yenisey 1-2 Ural 2/-7 1,57 0.71/7 0.71/7 1.25/4 0.00/3   6/-8 2,86 0.71/7 0.71/7 1.00/5 0.00/2
2018-09-29 Ural 2-1 Arsenal Tula 8/-7 2,88 1.00/8 1.00/8 1.00/5 1.00/3   9/1 2,13 1.13/8 1.13/8 1.60/5 0.33/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 Ural 1-1 Krylya Sovetov 10/-7 2,70 1.10/10 1.38/8 1.33/6 0.75/4   4/-10 1,80 1.00/10 1.13/8 1.17/6 0.75/4
2018-10-21 FK Krylya Sovetov Samara 1-3 Ural 40/0 4,00 1.50/20 1.13/8 0.00/10 3.00/10   11/-7 2,64 1.09/11 1.38/8 1.29/7 0.75/4
2018-10-21 Ural 1-3 FK Krylya Sovetov Samara 14/-5 2,75 1.25/12 1.38/8 1.29/7 1.20/5   8/0 4,00 1.50/4 1.13/8 0.00/2 3.00/2
2018-10-27 Ural 1-1 Ufa 15/-7 2,85 1.15/13 1.38/8 1.13/8 1.20/5   11/-6 2,15 1.00/13 1.13/8 1.00/8 1.00/5
2018-11-04 Spartak Moscow 1-2 Ural 17/2 2,29 1.57/14 1.00/8 1.29/7 1.86/7   16/-7 2,79 1.14/14 1.50/8 1.11/9 1.20/5
2018-11-10 Ural 2-1 Orenburg 18/-6 2,80 1.27/15 1.75/8 1.11/9 1.50/6   18/3 2,20 1.47/15 1.50/8 1.14/7 1.75/8
2018-11-23 Lokomotiv Moscow 1-2 Ural 23/7 2,44 1.75/16 2.38/8 2.00/7 1.56/9   20/-5 2,81 1.38/16 1.75/8 1.30/10 1.50/6
2018-12-02 Krasnodar 2-0 Ural 32/16 2,82 1.88/17 1.63/8 1.63/8 2.11/9   22/-4 2,82 1.47/17 1.75/8 1.30/10 1.71/7
2018-12-09 Dynamo Moscow 4-0 Ural 16/-1 1,83 1.11/18 1.25/8 1.38/8 0.90/10   22/-6 2,78 1.39/18 1.75/8 1.30/10 1.50/8
2019-03-02 Ural 0-1 Zenit 22/-10 2,84 1.32/19 1.63/8 1.30/10 1.33/9   31/10 2,74 1.95/19 1.50/8 2.11/9 1.80/10
2019-03-11 Akhmat Grozny 1-1 Ural 19/-3 2,05 1.30/20 1.38/8 1.44/9 1.18/11   22/-11 2,75 1.25/20 1.25/8 1.18/11 1.33/9
2019-03-16 Ural 0-1 CSKA Moscow 23/-11 2,71 1.24/21 1.38/8 1.18/11 1.30/10   30/16 2,10 1.71/21 1.75/8 1.60/10 1.82/11
2019-03-30 FK Rostov 2-1 Ural 21/5 1,68 1.45/22 1.00/8 1.27/11 1.64/11   23/-12 2,64 1.18/22 1.25/8 1.08/12 1.30/10
2019-04-07 Ural 3-2 Yenisey 24/-13 2,65 1.13/23 0.88/8 1.08/12 1.18/11   17/-23 2,48 0.65/23 0.75/8 0.73/11 0.58/12
2019-04-13 Arsenal Tula 0-0 Ural 32/3 2,54 1.42/24 1.75/8 1.83/12 1.00/12   27/-12 2,75 1.21/24 0.88/8 1.23/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-25 Krylya Sovetov 0-1 Ural 20/-10 2,08 1.13/24 1.25/8 1.33/12 0.92/12   29/-11 2,65 1.27/26 1.00/8 1.36/14 1.17/12
2019-04-28 Ufa 4-1 Ural 23/-9 2,04 0.93/27 0.75/8 1.00/14 0.85/13   30/-10 2,59 1.33/27 1.38/8 1.36/14 1.31/13
2019-05-04 Ural 0-1 Spartak Moscow 31/-13 2,68 1.29/28 1.38/8 1.36/14 1.21/14   36/4 2,43 1.54/28 1.38/8 1.40/15 1.69/13
2019-05-10 Orenburg 2-2 Ural 37/1 2,52 1.34/29 1.25/8 1.50/14 1.20/15   31/-14 2,62 1.24/29 1.25/8 1.27/15 1.21/14
2019-05-19 Ural 2-2 Lokomotiv Moscow 33/-14 2,67 1.23/30 1.38/8 1.27/15 1.20/15   46/16 2,53 1.83/30 2.13/8 1.93/15 1.73/15
2019-05-26 FK Anzi Makhackala 0-2 Ural 17/-35 2,23 0.77/31 0.38/8 0.67/15 0.88/16   35/-14 2,71 1.23/31 1.50/8 1.25/16 1.20/15