SELECT * FROM 1_Kampe WHERE LigaID = '244' 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 Volga N. Novgorod 1-3 Ural 24/-43 2,94 0.71/31 0.38/8 1.00/15 0.44/16   28/-19 2,42 1.06/31 1.63/8 0.88/16 1.27/15
2018-10-21 Akhmat Grozny 1-3 Ural 6/-7 1,58 0.58/12 0.63/8 1.00/6 0.17/6   11/-14 2,77 0.62/13 0.38/8 0.25/8 1.20/5
2018-10-21 Ural 1-3 Krasnodar 11/-12 2,83 0.67/12 0.50/8 0.29/7 1.20/5   18/3 2,75 1.58/12 1.88/8 1.71/7 1.40/5
2018-10-21 FK Rostov 1-3 Ural 13/-2 2,80 1.40/10 1.25/8 2.00/5 0.80/5   10/-12 2,91 0.64/11 0.75/8 0.29/7 1.25/4
2018-10-21 Ural 1-3 Lokomotiv Moscow 10/-9 2,90 0.70/10 0.75/8 0.33/6 1.25/4   19/10 3,11 2.11/9 2.25/8 2.25/4 2.00/5
2018-10-21 FK Krylya Sovetov Samara 1-3 Ural 6/-1 1,63 1.00/8 1.00/8 1.25/4 0.75/4   8/-9 3,13 0.63/8 0.63/8 0.33/6 1.50/2
2018-10-21 Ural 1-3 Dynamo Moscow 7/-6 2,86 0.71/7 0.71/7 0.40/5 1.50/2   9/-1 2,71 1.43/7 1.43/7 1.50/6 1.00/1
2018-10-21 Ural 1-3 Rubin Kazan 7/-3 2,83 0.83/6 0.83/6 0.50/4 1.50/2   5/1 1,29 1.29/7 1.29/7 1.50/4 1.00/3
2018-10-21 Kuban 1-3 Ural 6/0 2,40 1.20/5 1.20/5 1.00/2 1.33/3   5/-2 2,40 1.00/5 1.00/5 0.50/4 3.00/1
2018-10-21 Ural 1-3 Amkar 5/-2 3,00 1.00/4 1.00/4 0.33/3 3.00/1   4/1 1,40 1.20/5 1.20/5 1.67/3 0.50/2
2018-10-21 Tomsk 1-3 Ural 1/-6 2,67 0.00/3 0.00/3 0.00/1 0.00/2   3/-3 3,00 0.33/3 0.33/3 0.33/3 0.00/0
2018-10-21 Ural 1-3 Volga N. Novgorod 2/-2 3,00 0.50/2 0.50/2 0.50/2 0.00/0   3/-1 3,50 0.50/2 0.50/2 0.00/1 1.00/1
2018-10-21 Ural 1-3 Spartak Moscow 2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0   4/2 3,00 3.00/2 3.00/2 0.00/0 3.00/2
2018-10-21 Ural 1-3 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
2018-10-21 Ural 1-3 Krylya Sovetov 16/-17 2,72 0.72/18 0.88/8 0.27/11 1.43/7   16/-5 2,31 1.06/16 1.13/8 0.89/9 1.29/7
2018-10-21 Ural 1-3 Zenit 12/-14 2,71 0.64/14 0.50/8 0.25/8 1.17/6   36/25 3,36 2.50/14 3.00/8 2.67/6 2.38/8
2018-10-21 FK Anzi Makhackala 1-3 Ural 13/-14 2,67 0.47/15 0.50/8 0.40/5 0.50/10   13/-15 2,73 0.60/15 0.50/8 0.22/9 1.17/6
2018-10-21 Ural 1-3 Kuban 26/-20 2,40 1.00/30 1.63/8 0.73/15 1.27/15   42/6 2,60 1.40/30 1.88/8 1.67/15 1.13/15
2018-10-21 Rubin Kazan 1-3 Ural 31/1 2,18 1.14/28 0.88/8 1.36/14 0.93/14   26/-19 2,45 1.03/29 2.00/8 0.73/15 1.36/14
2018-10-21 Ural 1-3 Tomsk 26/-19 2,54 1.04/28 1.88/8 0.71/14 1.36/14   20/-15 1,96 0.96/28 1.50/8 1.14/14 0.79/14
2018-10-21 Amkar 1-3 Ural 31/4 2,23 1.42/26 0.75/8 1.92/13 0.92/13   24/-21 2,56 0.96/27 1.50/8 0.71/14 1.23/13
2018-10-21 CSKA Moscow 1-3 Ural 41/15 2,58 2.00/26 2.00/8 2.58/12 1.50/14   24/-20 2,62 1.00/26 1.63/8 0.71/14 1.33/12
2018-10-21 Spartak Moscow 1-3 Ural 41/13 2,88 1.83/24 1.38/8 2.10/10 1.64/14   23/-21 2,68 0.92/25 1.38/8 0.71/14 1.18/11
2018-10-21 Ural 1-3 FK Anzi Makhackala 21/-22 2,67 0.83/24 1.00/8 0.54/13 1.18/11   16/-20 2,26 0.57/23 0.75/8 0.64/11 0.50/12
2018-10-21 Lokomotiv Moscow 1-3 Ural 43/23 2,74 2.09/23 2.13/8 2.30/10 1.92/13   21/-19 2,65 0.87/23 1.38/8 0.54/13 1.30/10
2018-10-21 Ural 1-3 Akhmat Grozny 19/-20 2,64 0.77/22 1.00/8 0.33/12 1.30/10   14/-10 1,81 0.76/21 1.00/8 1.17/12 0.22/9
2018-10-21 Krasnodar 1-3 Ural 31/5 2,71 1.62/21 1.50/8 1.91/11 1.30/10   18/-21 2,71 0.67/21 0.75/8 0.33/12 1.11/9
2018-10-21 Zenit 1-3 Ural 42/22 3,26 2.11/19 1.75/8 2.13/8 2.09/11   17/-20 2,70 0.70/20 0.75/8 0.33/12 1.25/8
2018-10-21 Dynamo Moscow 1-3 Ural 31/9 2,79 1.84/19 2.25/8 1.91/11 1.75/8   17/-17 2,68 0.74/19 0.88/8 0.33/12 1.43/7
2018-10-21 Ural 1-3 FK Krylya Sovetov Samara 15/-17 2,76 0.71/17 0.75/8 0.20/10 1.43/7   16/-5 2,31 1.06/16 1.13/8 0.89/9 1.29/7
2018-10-21 Ural 1-3 FK Rostov 14/-14 2,63 0.75/16 0.88/8 0.22/9 1.43/7   18/-6 2,63 1.06/16 0.38/8 1.33/9 0.71/7
2018-10-21 Krylya Sovetov 1-3 Ural 6/-1 1,63 1.00/8 1.00/8 1.25/4 0.75/4   9/-9 3,00 0.67/9 0.75/8 0.33/6 1.33/3