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
2013-07-17 Ural 2-2 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
2013-07-21 Ural 0-2 Spartak Moscow 2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0   2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1
2013-07-27 Ural 1-2 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
2013-08-03 Tomsk 1-2 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
2013-08-17 Ural 0-0 Amkar 5/-2 3,00 1.00/4 1.00/4 0.33/3 3.00/1   4/1 1,75 1.25/4 1.25/4 2.00/2 0.50/2
2013-08-25 Kuban 3-2 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
2013-09-01 Ural 0-3 Rubin Kazan 7/-3 2,83 0.83/6 0.83/6 0.50/4 1.50/2   4/1 1,17 1.33/6 1.33/6 1.67/3 1.00/3
2013-09-16 Ural 1-4 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
2013-09-21 Krylya Sovetov 1-1 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
2013-09-26 Ural 0-3 Lokomotiv Moscow 9/-9 3,00 0.67/9 0.63/8 0.33/6 1.33/3   19/10 3,11 2.11/9 2.25/8 2.25/4 2.00/5
2013-09-30 FK Rostov 1-1 Ural 13/-2 2,80 1.40/10 1.25/8 2.00/5 0.80/5   9/-12 3,00 0.60/10 0.63/8 0.29/7 1.33/3
2013-10-05 Ural 0-2 Krasnodar 10/-12 2,91 0.64/11 0.75/8 0.29/7 1.25/4   17/3 2,82 1.64/11 1.75/8 1.83/6 1.40/5
2013-10-19 Akhmat Grozny 1-1 Ural 6/-7 1,58 0.58/12 0.63/8 1.00/6 0.17/6   10/-14 2,83 0.58/12 0.38/8 0.25/8 1.25/4
2013-10-26 Ural 1-2 Zenit 11/-14 2,77 0.62/13 0.38/8 0.25/8 1.20/5   32/22 3,23 2.46/13 2.75/8 2.67/6 2.29/7
2013-11-03 FK Anzi Makhackala 0-1 Ural 12/-14 2,71 0.43/14 0.50/8 0.40/5 0.44/9   12/-15 2,79 0.57/14 0.38/8 0.22/9 1.20/5
2013-11-08 Ural 1-4 FK Rostov 13/-14 2,67 0.73/15 0.75/8 0.22/9 1.50/6   17/-5 2,60 1.13/15 0.38/8 1.50/8 0.71/7
2013-11-24 Ural 1-1 Krylya Sovetov 14/-17 2,81 0.69/16 0.75/8 0.20/10 1.50/6   16/-5 2,31 1.06/16 1.13/8 0.89/9 1.29/7
2013-11-30 Dynamo Moscow 3-0 Ural 27/6 2,82 1.71/17 2.00/8 1.80/10 1.57/7   15/-17 2,76 0.71/17 0.75/8 0.27/11 1.50/6
2013-12-06 Zenit 2-1 Ural 38/19 3,17 2.06/18 1.75/8 2.13/8 2.00/10   15/-20 2,78 0.67/18 0.75/8 0.27/11 1.29/7
2014-03-08 Krasnodar 0-1 Ural 30/6 2,84 1.74/19 1.88/8 2.00/10 1.44/9   16/-21 2,79 0.63/19 0.63/8 0.27/11 1.13/8
2014-03-14 Ural 2-1 Akhmat Grozny 17/-20 2,70 0.75/20 1.00/8 0.27/11 1.33/9   14/-9 1,85 0.80/20 1.13/8 1.27/11 0.22/9
2014-03-22 Lokomotiv Moscow 3-0 Ural 39/22 2,67 2.10/21 2.13/8 2.22/9 2.00/12   19/-19 2,71 0.86/21 1.25/8 0.50/12 1.33/9
2014-03-29 Ural 2-1 FK Anzi Makhackala 19/-22 2,73 0.82/22 1.25/8 0.50/12 1.20/10   15/-20 2,27 0.55/22 0.75/8 0.64/11 0.45/11
2014-04-04 Spartak Moscow 0-1 Ural 39/12 2,87 1.78/23 1.38/8 2.10/10 1.54/13   21/-21 2,74 0.91/23 1.25/8 0.69/13 1.20/10
2014-04-12 CSKA Moscow 1-0 Ural 36/12 2,50 1.92/24 2.00/8 2.55/11 1.38/13   22/-20 2,67 1.00/24 1.63/8 0.69/13 1.36/11
2014-04-18 Amkar 0-2 Ural 31/4 2,32 1.44/25 0.75/8 2.00/12 0.92/13   22/-21 2,60 0.96/25 1.50/8 0.69/13 1.25/12
2014-04-26 Ural 0-0 Tomsk 24/-19 2,58 1.04/26 1.88/8 0.69/13 1.38/13   18/-16 2,00 0.92/26 1.13/8 1.00/13 0.85/13
2014-05-04 Rubin Kazan 1-0 Ural 30/1 2,19 1.15/27 0.88/8 1.38/13 0.93/14   24/-19 2,48 1.04/27 2.00/8 0.71/14 1.38/13
2014-05-10 Ural 2-1 Kuban 24/-20 2,43 1.00/28 1.63/8 0.71/14 1.29/14   38/2 2,64 1.36/28 1.63/8 1.57/14 1.14/14
2014-05-15 Volga N. Novgorod 1-2 Ural 21/-42 2,90 0.72/29 0.38/8 1.07/14 0.40/15   26/-19 2,45 1.07/29 1.63/8 0.87/15 1.29/14
2018-10-21 FK Krylya Sovetov Samara 1-3 Ural 12/0 4,00 1.50/6 1.13/8 0.00/3 3.00/3   28/-18 2,47 1.13/30 2.00/8 0.87/15 1.40/15
2018-10-21 Ural 1-3 FK Krylya Sovetov Samara 31/-16 2,52 1.19/31 1.63/8 0.87/15 1.50/16   56/0 4,00 1.50/28 1.13/8 0.00/14 3.00/14