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   3/1 1,67 1.67/3 1.67/3 3.00/1 1.00/2
2012-08-11 Lokomotiv Moscow 2-2 Alania Vladikavkaz 11/4 3,60 2.40/5 2.40/5 3.00/2 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   7/0 2,33 1.50/6 1.50/6 3.00/3 0.00/3
2012-08-25 FK Rostov 3-1 Alania Vladikavkaz 4/-9 2,43 0.29/7 0.29/7 0.33/3 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   9/3 1,88 1.50/8 1.50/8 1.50/4 1.50/4
2012-09-16 CSKA Moscow 2-0 Alania Vladikavkaz 17/11 2,56 2.33/9 2.25/8 2.40/5 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   23/10 3,60 2.30/10 2.38/8 2.67/6 1.75/4
2012-10-01 FK Saransk 1-1 Alania Vladikavkaz 12/-14 3,80 0.40/10 0.50/8 0.50/6 0.25/4   13/-2 3,11 0.89/9 1.00/8 1.40/5 0.25/4
2012-10-01 M. 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 FK Krylya Sovetov Samara 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-06 Alania Vladikavkaz 2-2 Krylya Sovetov 17/-2 3,00 0.92/12 0.63/8 1.33/6 0.50/6   13/-5 3,10 1.20/10 1.38/8 1.00/6 1.50/4
2012-10-20 Krasnodar 2-0 Alania Vladikavkaz 26/5 3,62 1.23/13 1.13/8 1.86/7 0.50/6   19/-2 3,08 0.92/13 0.63/8 1.29/7 0.50/6
2012-10-27 Alania Vladikavkaz 2-3 Zenit 19/-4 3,00 0.86/14 0.63/8 1.29/7 0.43/7   28/17 2,79 2.00/14 1.88/8 1.86/7 2.14/7
2012-11-05 Alania Vladikavkaz 0-2 Volga N. Novgorod 21/-5 3,13 0.80/15 0.50/8 1.13/8 0.43/7   14/-14 2,80 0.73/15 0.88/8 0.63/8 0.86/7
2012-11-10 Dynamo Moscow 2-0 Alania Vladikavkaz 16/-8 2,50 1.31/16 2.25/8 1.29/7 1.33/9   21/-7 3,06 0.75/16 0.50/8 1.00/9 0.43/7
2012-11-17 Alania Vladikavkaz 0-2 Rubin Kazan 21/-9 3,00 0.71/17 0.50/8 1.00/9 0.38/8   29/13 2,65 1.94/17 2.25/8 2.25/8 1.67/9
2012-11-24 Akhmat Grozny 1-0 Alania Vladikavkaz 23/-3 2,72 1.78/18 1.50/8 2.25/8 1.40/10   21/-11 2,94 0.67/18 0.38/8 0.90/10 0.38/8
2012-12-01 Alania Vladikavkaz 0-1 Lokomotiv Moscow 21/-12 2,84 0.63/19 0.25/8 0.90/10 0.33/9   32/10 2,70 1.85/20 1.38/8 1.70/10 2.00/10
2012-12-08 Kuban 0-0 Alania Vladikavkaz 41/17 2,95 1.82/22 2.25/8 2.50/10 1.25/12   21/-13 2,75 0.60/20 0.13/8 0.82/11 0.33/9
2013-03-09 Alania Vladikavkaz 0-0 FK Rostov 21/-13 2,62 0.62/21 0.13/8 0.82/11 0.40/10   25/-5 2,39 1.13/23 2.00/8 1.55/11 0.75/12
2013-03-16 Amkar 5-1 Alania Vladikavkaz 23/-13 2,46 1.00/24 0.25/8 0.82/11 1.15/13   21/-13 2,50 0.64/22 0.25/8 0.83/12 0.40/10
2013-04-01 Alania Vladikavkaz 0-4 CSKA Moscow 22/-17 2,65 0.61/23 0.25/8 0.83/12 0.36/11   46/28 2,56 2.44/25 2.38/8 2.54/13 2.33/12
2013-04-07 FK Anzi Makhackala 0-0 Alania Vladikavkaz 42/11 2,81 1.88/26 1.13/8 2.38/13 1.38/13   22/-21 2,71 0.58/24 0.25/8 0.77/13 0.36/11
2013-04-15 Alania Vladikavkaz 3-1 M. Saransk 22/-21 2,60 0.60/25 0.38/8 0.77/13 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 25/-19 2,65 0.69/26 1.13/8 0.93/14 0.42/12   26/-19 2,84 0.76/25 1.38/8 0.69/13 0.83/12
2013-04-20 FK Krylya Sovetov Samara 2-1 Alania Vladikavkaz 25/-21 2,73 0.88/26 0.88/8 0.46/13 1.31/13   28/-17 2,70 0.78/27 1.13/8 1.07/15 0.42/12
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   29/-18 2,71 0.75/28 1.00/8 1.07/15 0.38/13
2013-04-29 Alania Vladikavkaz 2-3 Krasnodar 30/-19 2,72 0.72/29 1.00/8 1.07/15 0.36/14   47/8 2,97 1.38/29 1.00/8 2.07/15 0.64/14
2013-05-04 Zenit 4-0 Alania Vladikavkaz 52/27 2,57 2.13/30 2.75/8 2.20/15 2.07/15   32/-20 2,80 0.70/30 0.88/8 1.00/16 0.36/14
2013-05-11 Volga N. Novgorod 1-0 Alania Vladikavkaz 31/-16 2,52 1.03/31 1.13/8 0.63/16 1.47/15   32/-24 2,84 0.68/31 0.88/8 1.00/16 0.33/15
2013-05-19 Alania Vladikavkaz 1-0 Dynamo Moscow 32/-25 2,78 0.66/32 0.88/8 1.00/16 0.31/16   49/13 2,66 1.84/32 2.00/8 2.00/16 1.69/16
2013-05-26 Spartak Moscow 2-0 Alania Vladikavkaz 58/16 3,03 1.67/33 1.50/8 1.94/16 1.41/17   33/-24 2,73 0.73/33 1.13/8 1.12/17 0.31/16