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-10-21 FK Anzi Makhackala 1-3 Ural 13/-38 2,06 0.68/31 0.38/8 0.67/15 0.69/16   33/-13 2,55 1.26/31 1.50/8 1.31/16 1.20/15
2018-10-21 Spartak Moscow 1-3 Ural 13/2 2,00 1.58/12 1.13/8 1.50/6 1.67/6   13/-7 2,54 1.08/13 1.25/8 1.22/9 0.75/4
2018-10-21 Ural 1-3 Ufa 12/-7 2,58 1.08/12 1.50/8 1.25/8 0.75/4   7/-6 1,82 0.91/11 0.75/8 1.14/7 0.50/4
2018-10-21 Ural 1-3 FK Krylya Sovetov Samara 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 Rubin Kazan 1-3 Ural 13/3 2,30 1.70/10 1.63/8 2.17/6 1.00/4   10/-6 2,89 1.22/9 1.38/8 1.33/6 1.00/3
2018-10-21 Ural 1-3 Arsenal Tula 8/-7 2,88 1.00/8 1.00/8 1.00/5 1.00/3   13/5 2,33 1.33/9 1.38/8 1.83/6 0.33/3
2018-10-21 Yenisey 1-3 Ural 3/-6 1,50 1.00/8 1.00/8 1.60/5 0.00/3   6/-8 2,86 0.71/7 0.71/7 1.00/5 0.00/2
2018-10-21 Ural 1-3 FK Rostov 5/-8 3,00 0.67/6 0.67/6 1.00/4 0.00/2   8/5 1,57 1.86/7 1.86/7 1.40/5 3.00/2
2018-10-21 CSKA Moscow 1-3 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-10-21 Ural 1-3 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-10-21 Zenit 1-3 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-10-21 Ural 1-3 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-10-21 Ural 1-3 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-10-21 Ural 1-3 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-10-21 Krylya Sovetov 1-3 Ural 20/-10 2,08 1.13/24 1.25/8 1.33/12 0.92/12   27/-10 2,46 1.31/26 1.75/8 1.43/14 1.17/12
2018-10-21 Ural 1-3 Orenburg 15/-6 2,57 1.21/14 1.63/8 1.22/9 1.20/5   17/6 2,00 1.57/14 1.13/8 1.33/6 1.75/8
2018-10-21 Lokomotiv Moscow 1-3 Ural 20/8 2,13 1.87/15 2.13/8 2.33/6 1.56/9   17/-5 2,60 1.33/15 1.88/8 1.40/10 1.20/5
2018-10-21 Ural 1-3 Lokomotiv Moscow 31/-13 2,50 1.27/30 1.75/8 1.33/15 1.20/15   45/17 2,43 1.87/30 2.13/8 2.00/15 1.73/15
2018-10-21 Orenburg 1-3 Ural 39/6 2,48 1.45/29 1.63/8 1.71/14 1.20/15   29/-13 2,45 1.28/29 1.63/8 1.33/15 1.21/14
2018-10-21 Ural 1-3 Spartak Moscow 29/-12 2,50 1.32/28 1.63/8 1.43/14 1.21/14   35/6 2,37 1.59/27 1.38/8 1.60/15 1.58/12
2018-10-21 Ufa 1-3 Ural 20/-10 1,92 0.85/26 0.75/8 1.00/14 0.67/12   28/-9 2,41 1.37/27 1.75/8 1.43/14 1.31/13
2018-10-21 FK Krylya Sovetov Samara 1-3 Ural 20/-10 2,08 1.13/24 1.25/8 1.33/12 0.92/12   26/-11 2,52 1.24/25 1.00/8 1.43/14 1.00/11
2018-10-21 Ural 1-3 Rubin Kazan 24/-12 2,50 1.17/24 0.63/8 1.31/13 1.00/11   21/-2 1,76 1.32/25 1.00/8 1.77/13 0.83/12
2018-10-21 Arsenal Tula 1-3 Ural 33/8 2,42 1.54/24 2.13/8 2.08/12 1.00/12   24/-12 2,61 1.17/23 0.88/8 1.31/13 1.00/10
2018-10-21 Ural 1-3 Yenisey 21/-13 2,50 1.09/22 0.88/8 1.17/12 1.00/10   14/-26 2,35 0.65/23 0.75/8 1.00/11 0.33/12
2018-10-21 FK Rostov 1-3 Ural 17/3 1,41 1.32/22 0.88/8 1.27/11 1.36/11   20/-12 2,48 1.14/21 1.25/8 1.17/12 1.11/9
2018-10-21 Ural 1-3 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
2018-10-21 Akhmat Grozny 1-3 Ural 17/-2 1,89 1.37/19 1.38/8 1.63/8 1.18/11   19/-11 2,58 1.21/19 1.38/8 1.27/11 1.13/8
2018-10-21 Ural 1-3 Zenit 19/-10 2,67 1.28/18 1.50/8 1.40/10 1.13/8   28/11 2,50 2.06/18 1.50/8 2.38/8 1.80/10
2018-10-21 Dynamo Moscow 1-3 Ural 12/-2 1,53 1.00/17 0.88/8 1.57/7 0.60/10   19/-6 2,59 1.35/17 1.50/8 1.40/10 1.29/7
2018-10-21 Krasnodar 1-3 Ural 31/19 2,69 2.00/16 2.00/8 1.86/7 2.11/9   19/-4 2,63 1.44/16 1.88/8 1.40/10 1.50/6
2018-10-21 Ural 1-3 Krylya Sovetov 11/-7 2,64 1.09/11 1.50/8 1.29/7 0.75/4   4/-10 1,80 1.00/10 1.13/8 1.17/6 0.75/4