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 6/1 3,67 2.00/3 2.00/3 3.00/1 1.50/2   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   5/0 2,50 1.50/4 1.50/4 3.00/2 0.00/2
2012-08-25 FK Rostov 3-1 Alania Vladikavkaz 3/-5 2,20 0.40/5 0.40/5 0.50/2 0.33/3   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 2,17 1.33/6 1.33/6 1.67/3 1.00/3
2012-09-16 CSKA Moscow 2-0 Alania Vladikavkaz 11/5 2,43 2.14/7 2.14/7 2.25/4 2.00/3   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   17/7 3,38 2.13/8 2.13/8 2.60/5 1.33/3
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   13/-2 3,11 0.89/9 1.00/8 1.40/5 0.25/4
2012-10-06 Alania Vladikavkaz 2-2 Krylya Sovetov 14/-2 3,00 0.90/10 1.13/8 1.40/5 0.40/5   13/-5 3,10 1.20/10 1.38/8 1.00/6 1.50/4
2012-10-20 Krasnodar 2-0 Alania Vladikavkaz 18/0 3,27 1.09/11 0.75/8 1.67/6 0.40/5   16/-2 3,09 0.91/11 0.88/8 1.33/6 0.40/5
2012-10-27 Alania Vladikavkaz 2-3 Zenit 16/-4 3,00 0.83/12 0.75/8 1.33/6 0.33/6   23/14 2,67 2.00/12 1.50/8 1.86/7 2.20/5
2012-11-05 Alania Vladikavkaz 0-2 Volga N. Novgorod 18/-5 3,15 0.77/13 0.38/8 1.14/7 0.33/6   13/-13 3,00 0.62/13 0.63/8 0.71/7 0.50/6
2012-11-10 Dynamo Moscow 2-0 Alania Vladikavkaz 13/-10 2,57 1.07/14 1.50/8 1.00/6 1.13/8   18/-7 3,07 0.71/14 0.38/8 1.00/8 0.33/6
2012-11-17 Alania Vladikavkaz 0-2 Rubin Kazan 18/-9 3,00 0.67/15 0.25/8 1.00/8 0.29/7   24/9 2,60 1.80/15 1.88/8 2.14/7 1.50/8
2012-11-24 Akhmat Grozny 1-0 Alania Vladikavkaz 20/-4 2,75 1.75/16 1.13/8 2.14/7 1.44/9   18/-11 2,94 0.63/16 0.25/8 0.89/9 0.29/7
2012-12-01 Alania Vladikavkaz 0-1 Lokomotiv Moscow 18/-12 2,82 0.59/17 0.25/8 0.89/9 0.25/8   26/6 2,71 1.65/17 1.13/8 1.56/9 1.75/8
2012-12-08 Kuban 0-0 Alania Vladikavkaz 32/11 2,94 1.72/18 1.88/8 2.38/8 1.20/10   18/-13 2,72 0.56/18 0.13/8 0.80/10 0.25/8
2013-03-09 Alania Vladikavkaz 0-0 FK Rostov 18/-13 2,58 0.58/19 0.13/8 0.80/10 0.33/9   20/-5 2,37 1.05/19 1.38/8 1.56/9 0.60/10
2013-03-16 Amkar 5-1 Alania Vladikavkaz 20/-13 2,65 0.95/20 0.50/8 0.89/9 1.00/11   18/-13 2,45 0.60/20 0.25/8 0.82/11 0.33/9
2013-04-01 Alania Vladikavkaz 0-4 CSKA Moscow 19/-17 2,62 0.57/21 0.25/8 0.82/11 0.30/10   36/19 2,52 2.33/21 2.38/8 2.45/11 2.20/10
2013-04-07 FK Anzi Makhackala 0-0 Alania Vladikavkaz 35/10 2,73 1.91/22 1.25/8 2.45/11 1.36/11   19/-21 2,68 0.55/22 0.25/8 0.75/12 0.30/10
2013-04-15 Alania Vladikavkaz 3-1 FK Saransk 19/-21 2,57 0.57/23 0.38/8 0.75/12 0.36/11   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 22/-20 2,67 0.83/24 0.88/8 0.50/12 1.17/12   22/-19 2,63 0.67/24 0.75/8 0.92/13 0.36/11
2013-04-29 Alania Vladikavkaz 2-3 Krasnodar 23/-20 2,64 0.64/25 0.75/8 0.92/13 0.33/12   39/6 2,88 1.40/25 1.63/8 2.15/13 0.58/12
2013-05-04 Zenit 4-0 Alania Vladikavkaz 45/22 2,62 2.08/26 2.13/8 2.08/13 2.08/13   25/-21 2,73 0.62/26 0.75/8 0.86/14 0.33/12
2013-05-11 Volga N. Novgorod 1-0 Alania Vladikavkaz 26/-17 2,56 0.93/27 1.00/8 0.64/14 1.23/13   25/-25 2,78 0.59/27 0.63/8 0.86/14 0.31/13
2013-05-19 Alania Vladikavkaz 1-0 Dynamo Moscow 25/-26 2,71 0.57/28 0.50/8 0.86/14 0.29/14   41/8 2,64 1.68/28 1.75/8 1.86/14 1.50/14
2013-05-26 Spartak Moscow 2-0 Alania Vladikavkaz 49/10 3,03 1.66/29 1.50/8 1.93/14 1.40/15   26/-25 2,66 0.66/29 0.88/8 1.00/15 0.29/14
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   26/-27 2,63 0.63/30 0.88/8 1.00/15 0.27/15
2018-10-21 Alania Vladikavkaz 1-3 M. Saransk 29/-25 2,68 0.71/31 1.13/8 1.00/15 0.44/16   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 30/-27 2,72 0.69/32 1.13/8 0.94/16 0.44/16   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   31/-29 2,76 0.67/33 1.13/8 0.88/17 0.44/16