SELECT * FROM 1_Kampe WHERE LigaID = '241' 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
2016-07-31 Ural 2-0 Ufa 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
2016-08-07 FK Rostov 0-0 Ural 1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2016-08-13 Ural 0-1 CSKA Moscow 2/2 1,00 2.00/2 2.00/2 3.00/1 1.00/1   1/1 0,50 2.00/2 2.00/2 0.00/0 2.00/2
2016-08-21 Amkar 1-0 Ural 2/2 0,67 1.67/3 1.67/3 3.00/1 1.00/2   2/1 1,00 1.33/3 1.33/3 1.50/2 1.00/1
2016-08-28 Ural 1-1 Arsenal Tula 2/0 1,00 1.00/4 1.00/4 1.50/2 0.50/2   1/-4 1,50 1.00/4 1.00/4 2.00/2 0.00/2
2016-09-12 Rubin Kazan 3-1 Ural 3/-2 1,60 0.60/5 0.60/5 0.67/3 0.50/2   3/0 1,20 1.00/5 1.00/5 1.33/3 0.50/2
2016-09-17 Ural 0-1 FK Anzi Makhackala 4/-2 1,67 0.83/6 0.83/6 1.33/3 0.33/3   3/-2 1,33 1.33/6 1.33/6 1.33/3 1.33/3
2016-09-25 Orenburg 0-1 Ural 2/-4 1,14 0.57/7 0.57/7 0.60/5 0.50/2   4/-3 1,57 0.71/7 0.71/7 1.00/4 0.33/3
2016-10-01 Tomsk 1-1 Ural 5/-7 2,13 0.88/8 0.88/8 2.00/3 0.20/5   5/-2 1,50 1.00/8 1.00/8 1.00/4 1.00/4
2016-10-16 Ural 0-2 Zenit 6/-2 1,56 1.00/9 0.75/8 1.00/4 1.00/5   22/14 3,33 2.11/9 2.25/8 2.33/6 1.67/3
2016-10-22 Ural 0-1 Spartak Moscow 6/-4 1,60 0.90/10 0.63/8 0.80/5 1.00/5   17/10 2,40 2.20/10 2.00/8 2.50/6 1.75/4
2016-10-30 Ural 1-4 Akhmat Grozny 6/-5 1,55 0.82/11 0.63/8 0.67/6 1.00/5   13/-2 2,55 1.64/11 1.75/8 2.17/6 1.00/5
2016-11-05 Krylya Sovetov 2-2 Ural 6/-8 1,67 0.58/12 0.63/8 1.00/5 0.29/7   7/-8 1,83 0.75/12 0.63/8 0.57/7 1.00/5
2016-11-20 Krasnodar 3-0 Ural 17/7 2,08 1.62/13 1.75/8 2.29/7 0.83/6   9/-8 2,00 0.77/13 0.63/8 0.57/7 1.00/6
2016-11-26 Lokomotiv Moscow 1-1 Ural 12/1 1,64 1.14/14 1.13/8 1.50/6 0.88/8   9/-11 2,07 0.71/14 0.63/8 0.57/7 0.86/7
2016-11-30 Ural 1-0 FK Rostov 10/-11 2,07 0.73/15 0.75/8 0.57/7 0.88/8   19/8 2,00 1.60/15 1.75/8 2.75/8 0.29/7
2016-12-03 CSKA Moscow 4-0 Ural 17/6 1,75 1.81/16 1.38/8 2.00/6 1.70/10   11/-10 2,00 0.88/16 0.75/8 0.88/8 0.88/8
2017-03-05 Ural 1-0 Amkar 11/-14 2,12 0.82/17 0.63/8 0.88/8 0.78/9   16/4 1,65 1.59/17 1.38/8 2.50/8 0.78/9
2017-03-10 Arsenal Tula 2-0 Ural 6/-20 1,78 0.67/18 0.50/8 1.13/8 0.30/10   12/-13 2,06 0.94/18 1.00/8 1.11/9 0.78/9
2017-03-18 Ural 1-0 Rubin Kazan 12/-15 2,05 0.89/19 1.00/8 1.11/9 0.70/10   21/2 2,11 1.42/19 1.88/8 1.90/10 0.89/9
2017-03-31 FK Anzi Makhackala 2-3 Ural 14/-6 1,70 1.15/20 0.75/8 1.30/10 1.00/10   13/-14 2,00 1.00/20 1.38/8 1.30/10 0.70/10
2017-04-10 Ural 2-0 Orenburg 16/-13 2,14 1.10/21 1.63/8 1.30/10 0.91/11   16/-9 1,95 0.76/21 0.63/8 1.30/10 0.27/11
2017-04-16 Ural 1-0 Tomsk 18/-11 2,14 1.18/22 2.00/8 1.45/11 0.91/11   11/-35 2,59 0.59/22 0.50/8 1.10/10 0.17/12
2017-04-22 Zenit 2-0 Ural 39/22 2,43 1.87/23 1.50/8 2.50/12 1.18/11   19/-10 2,09 1.26/23 2.25/8 1.58/12 0.91/11
2017-04-25 Spartak Moscow 1-0 Ural 38/15 2,54 2.25/24 2.13/8 2.75/12 1.75/12   19/-12 2,08 1.21/24 1.88/8 1.58/12 0.83/12
2017-04-29 Akhmat Grozny 5-2 Ural 27/-1 2,20 1.44/25 1.00/8 1.64/14 1.18/11   19/-13 2,04 1.16/25 1.88/8 1.58/12 0.77/13
2017-05-08 Ural 1-3 Krylya Sovetov 21/-16 2,23 1.12/26 1.50/8 1.58/12 0.71/14   24/-8 2,15 0.85/26 0.88/8 1.23/13 0.46/13
2017-05-13 Ural 1-1 Krasnodar 22/-18 2,30 1.07/27 1.50/8 1.46/13 0.71/14   34/15 1,96 1.67/27 1.63/8 2.00/15 1.25/12
2017-05-17 Ural 1-2 Lokomotiv Moscow 23/-18 2,29 1.07/28 1.25/8 1.43/14 0.71/14   37/13 2,18 1.39/28 1.50/8 1.36/14 1.43/14
2017-05-21 Ufa 1-0 Ural 21/-4 1,59 1.38/29 1.00/8 1.36/14 1.40/15   24/-19 2,31 1.03/29 0.88/8 1.33/15 0.71/14
2018-10-21 FK Krylya Sovetov Samara 1-3 Ural 4/0 4,00 1.50/2 1.88/8 0.00/1 3.00/1   24/-20 2,27 1.00/30 0.50/8 1.33/15 0.67/15
2018-10-21 Ural 1-3 FK Krylya Sovetov Samara 27/-18 2,32 1.06/31 0.50/8 1.33/15 0.81/16   34/-4 4,00 1.33/18 1.88/8 0.00/10 3.00/8