SELECT * FROM 1_Kampe WHERE LigaID = '245' AND (Home='Alania Vladikavkaz' OR Away='Alania Vladikavkaz') 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
2012-07-21 Alania Vladikavkaz 1-2 Spartak 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
2012-07-29 Rubin Kazan 3-1 Alania Vladikavkaz 1/-1 3,00 0.00/1 0.00/1 0.00/0 0.00/1   1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2012-08-04 Alania Vladikavkaz 5-0 Akhmat Grozny 2/-3 3,50 0.00/2 0.00/2 0.00/1 0.00/1   2/1 1,50 2.00/2 2.00/2 3.00/1 1.00/1
2012-08-11 Lokomotiv Moscow 2-2 Alania Vladikavkaz 9/2 4,00 2.25/4 2.25/4 3.00/1 2.00/3   7/2 4,00 1.00/3 1.00/3 1.50/2 0.00/1
2012-08-20 Alania Vladikavkaz 2-1 Kuban 9/2 4,00 1.00/4 1.00/4 1.50/2 0.50/2   6/1 2,20 1.80/5 1.80/5 3.00/3 0.00/2
2012-08-25 FK Rostov 3-1 Alania Vladikavkaz 3/-8 2,33 0.33/6 0.33/6 0.50/2 0.25/4   11/3 3,80 1.40/5 1.40/5 2.00/3 0.50/2
2012-09-01 Alania Vladikavkaz 1-1 Amkar 12/1 3,83 1.17/6 1.17/6 2.00/3 0.33/3   7/1 1,86 1.29/7 1.29/7 1.50/4 1.00/3
2012-09-16 CSKA Moscow 2-0 Alania Vladikavkaz 14/8 2,50 2.25/8 2.25/8 2.25/4 2.25/4   13/1 3,57 1.14/7 1.14/7 1.75/4 0.33/3
2012-09-24 Alania Vladikavkaz 0-1 FK Anzi Makhackala 13/-1 3,38 1.00/8 1.00/8 1.75/4 0.25/4   21/9 3,67 2.22/9 2.13/8 2.67/6 1.33/3
2012-10-01 Mordovia Saransk 1-1 Alania Vladikavkaz 10/-13 3,67 0.44/9 0.50/8 0.60/5 0.25/4   13/-2 3,11 0.89/9 1.00/8 1.40/5 0.25/4
2012-10-01 FK Saransk 1-1 Alania Vladikavkaz 10/-13 3,67 0.44/9 0.50/8 0.60/5 0.25/4   14/-2 3,00 0.90/10 0.88/8 1.40/5 0.40/5
2012-10-06 Alania Vladikavkaz 2-2 Krylya Sovetov 15/-2 2,91 0.91/11 0.88/8 1.40/5 0.50/6   16/-4 3,27 1.36/11 1.38/8 1.00/6 1.80/5
2012-10-20 Krasnodar 2-0 Alania Vladikavkaz 24/5 3,58 1.25/12 1.13/8 1.86/7 0.40/5   17/-2 3,00 0.92/12 0.88/8 1.33/6 0.50/6
2012-10-27 Alania Vladikavkaz 2-3 Zenit 17/-4 2,92 0.85/13 0.50/8 1.33/6 0.43/7   26/17 2,69 2.08/13 1.75/8 1.86/7 2.33/6
2012-11-05 Alania Vladikavkaz 0-2 Volga N. Novgorod 19/-5 3,07 0.79/14 0.50/8 1.14/7 0.43/7   13/-15 2,93 0.57/14 0.63/8 0.63/8 0.50/6
2012-11-10 Dynamo Moscow 2-0 Alania Vladikavkaz 15/-9 2,60 1.20/15 1.88/8 1.00/6 1.33/9   19/-7 3,00 0.73/15 0.38/8 1.00/8 0.43/7
2012-11-17 Alania Vladikavkaz 0-2 Rubin Kazan 19/-9 2,94 0.69/16 0.38/8 1.00/8 0.38/8   27/11 2,69 1.88/16 2.25/8 2.14/7 1.67/9
2012-11-24 Akhmat Grozny 1-0 Alania Vladikavkaz 22/-3 2,76 1.82/17 1.50/8 2.25/8 1.44/9   19/-11 2,88 0.65/17 0.38/8 0.89/9 0.38/8
2012-12-01 Alania Vladikavkaz 0-1 Lokomotiv Moscow 19/-12 2,78 0.61/18 0.25/8 0.89/9 0.33/9   29/7 2,83 1.72/18 1.13/8 1.56/9 1.89/9
2012-12-08 Kuban 0-0 Alania Vladikavkaz 36/15 2,85 1.85/20 1.88/8 2.44/9 1.36/11   19/-13 2,68 0.58/19 0.13/8 0.80/10 0.33/9
2013-03-09 Alania Vladikavkaz 0-0 FK Rostov 19/-13 2,55 0.60/20 0.13/8 0.80/10 0.40/10   22/-6 2,38 1.10/21 1.63/8 1.70/10 0.55/11
2013-03-16 Amkar 5-1 Alania Vladikavkaz 21/-13 2,50 0.95/22 0.25/8 0.90/10 1.00/12   19/-13 2,43 0.62/21 0.25/8 0.82/11 0.40/10
2013-04-01 Alania Vladikavkaz 0-4 CSKA Moscow 20/-17 2,59 0.59/22 0.25/8 0.82/11 0.36/11   41/23 2,57 2.39/23 2.38/8 2.50/12 2.27/11
2013-04-07 FK Anzi Makhackala 0-0 Alania Vladikavkaz 39/10 2,83 1.88/24 1.13/8 2.50/12 1.25/12   20/-21 2,65 0.57/23 0.25/8 0.75/12 0.36/11
2013-04-15 Alania Vladikavkaz 3-1 Mordovia Saransk 20/-21 2,54 0.58/24 0.38/8 0.75/12 0.42/12   22/-20 2,78 0.70/23 1.00/8 0.75/12 0.64/11
2013-04-15 Alania Vladikavkaz 3-1 FK Saransk 23/-19 2,60 0.68/25 1.13/8 0.92/13 0.42/12   22/-20 2,78 0.70/23 1.00/8 0.75/12 0.64/11
2013-04-20 Krylya Sovetov 2-1 Alania Vladikavkaz 25/-21 2,73 0.88/26 0.88/8 0.46/13 1.31/13   26/-17 2,65 0.77/26 1.13/8 1.07/14 0.42/12
2013-04-29 Alania Vladikavkaz 2-3 Krasnodar 27/-18 2,67 0.74/27 1.13/8 1.07/14 0.38/13   45/11 2,93 1.44/27 1.38/8 2.21/14 0.62/13
2013-05-04 Zenit 4-0 Alania Vladikavkaz 49/26 2,57 2.14/28 2.38/8 2.14/14 2.14/14   29/-19 2,75 0.71/28 1.00/8 1.00/15 0.38/13
2013-05-11 Volga N. Novgorod 1-0 Alania Vladikavkaz 29/-17 2,59 0.97/29 1.38/8 0.60/15 1.36/14   29/-23 2,79 0.69/29 0.88/8 1.00/15 0.36/14
2013-05-19 Alania Vladikavkaz 1-0 Dynamo Moscow 29/-24 2,73 0.67/30 0.88/8 1.00/15 0.33/15   46/11 2,70 1.77/30 2.00/8 1.93/15 1.60/15
2013-05-26 Spartak Moscow 2-0 Alania Vladikavkaz 52/11 3,00 1.65/31 1.38/8 2.00/15 1.31/16   30/-23 2,68 0.74/31 1.25/8 1.13/16 0.33/15
2018-10-21 FK Krylya Sovetov Samara 1-3 Alania Vladikavkaz 41/-2 4,00 1.43/21 1.88/8 0.00/11 3.00/10   30/-25 2,66 0.72/32 1.13/8 1.13/16 0.31/16
2018-10-21 Alania Vladikavkaz 1-3 M. Saransk 33/-23 2,70 0.79/33 1.13/8 1.13/16 0.47/17   41/-2 4,00 1.43/21 1.13/8 0.00/11 3.00/10
2018-10-21 Alania Vladikavkaz 1-3 FK Krylya Sovetov Samara 34/-25 2,74 0.76/34 1.13/8 1.06/17 0.47/17   7/2 4,00 2.00/3 1.88/8 0.00/1 3.00/2
2018-10-21 M. Saransk 1-3 Alania Vladikavkaz 11/2 4,00 1.80/5 1.13/8 0.00/2 3.00/3   35/-27 2,77 0.74/35 1.13/8 1.00/18 0.47/17