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   18/11 2,27 2.27/11 2.00/8 2.57/7 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   14/-1 2,42 1.75/12 1.75/8 2.29/7 1.00/5
2016-11-05 FK Krylya Sovetov Samara 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-05 Krylya Sovetov 2-2 Ural 6/-8 1,67 0.58/12 0.63/8 1.00/5 0.29/7   9/-8 2,00 0.77/13 0.75/8 0.57/7 1.00/6
2016-11-20 Krasnodar 3-0 Ural 18/7 2,07 1.57/14 1.75/8 2.29/7 0.86/7   11/-8 2,14 0.79/14 0.75/8 0.57/7 1.00/7
2016-11-26 Lokomotiv Moscow 1-1 Ural 12/1 1,53 1.13/15 1.13/8 1.43/7 0.88/8   11/-11 2,20 0.73/15 0.75/8 0.57/7 0.88/8
2016-11-30 Ural 1-0 FK Rostov 12/-11 2,19 0.75/16 0.50/8 0.57/7 0.89/9   21/9 2,06 1.69/16 1.75/8 2.78/9 0.29/7
2016-12-03 CSKA Moscow 4-0 Ural 19/7 1,82 1.88/17 1.38/8 2.00/6 1.82/11   13/-10 2,12 0.88/17 0.75/8 0.88/8 0.89/9
2017-03-05 Ural 1-0 Amkar 13/-14 2,22 0.83/18 0.75/8 0.88/8 0.80/10   16/4 1,56 1.56/18 1.38/8 2.33/9 0.78/9
2017-03-10 Arsenal Tula 2-0 Ural 7/-20 1,79 0.68/19 0.50/8 1.13/8 0.36/11   14/-13 2,16 0.95/19 1.13/8 1.11/9 0.80/10
2017-03-18 Ural 1-0 Rubin Kazan 14/-15 2,15 0.90/20 1.13/8 1.11/9 0.73/11   24/5 2,15 1.50/20 1.88/8 2.00/11 0.89/9
2017-03-31 FK Anzi Makhackala 2-3 Ural 15/-7 1,76 1.10/21 0.75/8 1.30/10 0.91/11   15/-14 2,10 1.00/21 1.38/8 1.30/10 0.73/11
2017-04-10 Ural 2-0 Orenburg 18/-13 2,23 1.09/22 1.63/8 1.30/10 0.92/12   17/-8 1,91 0.86/22 0.63/8 1.45/11 0.27/11
2017-04-16 Ural 1-0 Tomsk 20/-11 2,22 1.17/23 2.00/8 1.45/11 0.92/12   11/-38 2,61 0.57/23 0.50/8 1.10/10 0.15/13
2017-04-22 Zenit 2-0 Ural 42/24 2,50 1.92/24 1.50/8 2.54/13 1.18/11   21/-10 2,17 1.25/24 2.25/8 1.58/12 0.92/12
2017-04-25 Spartak Moscow 1-0 Ural 39/12 2,54 2.19/26 2.13/8 2.77/13 1.62/13   21/-12 2,16 1.20/25 1.88/8 1.58/12 0.85/13
2017-04-29 Akhmat Grozny 5-2 Ural 28/0 2,15 1.50/26 1.00/8 1.73/15 1.18/11   21/-13 2,12 1.15/26 1.88/8 1.58/12 0.79/14
2017-05-08 Ural 1-3 FK Krylya Sovetov Samara 23/-16 2,30 1.11/27 1.50/8 1.58/12 0.73/15   24/-8 2,15 0.85/26 0.88/8 1.23/13 0.46/13
2017-05-08 Ural 1-3 Krylya Sovetov 24/-18 2,36 1.07/28 1.13/8 1.46/13 0.73/15   24/-8 2,15 0.85/26 0.88/8 1.23/13 0.46/13
2017-05-13 Ural 1-1 Krasnodar 25/-20 2,41 1.03/29 1.13/8 1.36/14 0.73/15   36/15 1,97 1.62/29 1.63/8 1.94/16 1.23/13
2017-05-17 Ural 1-2 Lokomotiv Moscow 26/-20 2,40 1.03/30 0.88/8 1.33/15 0.73/15   40/16 2,13 1.43/30 1.50/8 1.33/15 1.53/15
2017-05-21 Ufa 1-0 Ural 23/-2 1,55 1.48/31 1.00/8 1.47/15 1.50/16   27/-21 2,42 1.00/31 0.50/8 1.25/16 0.73/15