SELECT * FROM 1_Kampe WHERE LigaID = '254' AND (Home='Spartak Nalchik' OR Away='Spartak Nalchik') 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-09 Spartak Nalchik 1-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
2012-07-16 Vladimir - Spartak Nalchik / /0 / / /   / /0 / / /
2012-07-23 Spartak Nalchik 1-3 Neftekhimik 1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0   2/-2 3,00 0.50/2 0.50/2 1.00/1 0.00/1
2012-07-31 Shinnik Yaroslavl 0-1 Spartak Nalchik 3/-1 2,33 1.00/3 1.00/3 3.00/1 0.00/2   2/-1 2,50 1.50/2 1.50/2 1.50/2 0.00/0
2012-08-06 Spartak Nalchik 3-2 Ural 3/0 2,00 2.00/3 2.00/3 1.50/2 3.00/1   6/4 2,00 1.50/4 1.50/4 1.67/3 1.00/1
2012-08-13 Yenisey 3-1 Spartak Nalchik 5/1 1,80 1.60/5 1.60/5 2.33/3 0.50/2   6/1 2,75 2.25/4 2.25/4 2.00/3 3.00/1
2012-08-17 Spartak Nalchik 1-0 FC Novokuznetsk 7/-1 3,00 1.80/5 1.80/5 2.00/3 1.50/2   4/0 1,33 1.33/6 1.33/6 2.00/4 0.00/2
2012-08-22 SKA Khabarovsk 1-0 Spartak Nalchik 7/3 1,57 1.71/7 1.71/7 2.50/4 0.67/3   8/0 2,67 2.00/6 2.00/6 2.25/4 1.50/2
2012-08-28 Spartak Nalchik 0-2 Dynamo Petersburg 8/-1 2,43 1.71/7 1.71/7 2.25/4 1.00/3   6/-7 2,71 0.71/7 0.71/7 1.00/3 0.50/4
2012-09-06 Spartak Nalchik 2-1 T. Moscow 8/-3 2,38 1.50/8 1.50/8 1.80/5 1.00/3   5/-5 1,88 1.13/8 1.13/8 1.50/4 0.75/4
2012-09-06 Spartak Nalchik 2-1 Torpedo Moscow 10/-2 2,44 1.67/9 1.88/8 2.00/6 1.00/3   5/-5 1,88 1.13/8 1.13/8 1.50/4 0.75/4
2012-09-10 Volgar-Astrakhan 0-0 Spartak Nalchik 6/-4 1,78 0.89/9 0.88/8 1.20/5 0.50/4   12/-1 2,50 1.80/10 1.88/8 2.14/7 1.00/3
2012-09-17 Spartak Nalchik 0-0 Energomash Belgorod 12/-1 2,27 1.73/11 1.63/8 2.14/7 1.00/4   8/-5 2,10 0.90/10 0.75/8 1.00/5 0.80/5
2012-09-21 R. Volgograd 0-1 Spartak Nalchik 8/-1 1,55 1.64/11 1.38/8 2.00/6 1.20/5   12/-1 2,08 1.67/12 1.38/8 2.00/8 1.00/4
2012-10-02 Spartak Nalchik 2-0 Tomsk 13/0 2,00 1.77/13 1.75/8 2.00/8 1.40/5   27/12 3,50 2.25/12 2.25/8 2.33/6 2.17/6
2012-10-08 FK Novosibirsk 0-0 Spartak Nalchik 17/1 2,54 1.54/13 1.63/8 1.17/6 1.86/7   15/2 2,00 1.86/14 1.75/8 2.11/9 1.40/5
2012-10-15 Spartak Nalchik 1-0 Khimki 15/2 1,87 1.80/15 1.88/8 2.11/9 1.33/6   9/-10 2,15 0.46/13 0.63/8 0.17/6 0.71/7
2012-10-22 Baltika 1-0 Spartak Nalchik 17/1 2,06 1.50/16 1.75/8 1.14/7 1.78/9   16/3 1,81 1.88/16 2.25/8 2.20/10 1.33/6
2012-10-26 Spartak Nalchik - Vladimir / /0 / / /   / /0 / / /
2012-10-31 Neftekhimik 3-0 Spartak Nalchik 24/5 2,39 1.61/18 1.38/8 1.89/9 1.33/9   16/2 1,76 1.76/17 1.88/8 2.20/10 1.14/7
2012-11-05 Spartak Nalchik 3-2 Shinnik Yaroslavl 16/-1 1,83 1.67/18 1.50/8 2.20/10 1.00/8   11/-10 1,78 0.78/18 0.75/8 1.29/7 0.45/11
2012-11-12 Ural 0-0 Spartak Nalchik 46/35 2,85 2.20/20 2.75/8 2.60/10 1.80/10   19/0 2,00 1.74/19 1.75/8 2.27/11 1.00/8
2012-11-20 Spartak Nalchik 0-2 Yenisey 19/0 1,90 1.70/20 1.75/8 2.27/11 1.00/9   17/-4 1,81 1.05/21 0.88/8 1.30/10 0.82/11
2013-03-11 FC Novokuznetsk 0-0 Spartak Nalchik 12/-17 1,86 0.82/22 0.88/8 1.50/12 0.00/10   19/-2 1,90 1.62/21 1.38/8 2.08/12 1.00/9
2013-03-18 Spartak Nalchik 1-0 SKA Khabarovsk 19/-2 1,82 1.59/22 1.13/8 2.08/12 1.00/10   26/9 1,79 1.71/24 1.63/8 2.00/12 1.42/12
2013-03-25 Dynamo Petersburg 0-2 Spartak Nalchik 23/-11 2,48 1.00/23 0.75/8 1.67/9 0.57/14   20/-1 1,78 1.65/23 1.38/8 2.15/13 1.00/10
2013-04-02 Torpedo Moscow 1-1 Spartak Nalchik 23/-7 2,41 1.00/22 0.88/8 1.17/12 0.80/10   23/1 1,80 1.68/25 1.63/8 2.15/13 1.17/12
2013-04-02 T. Moscow 1-1 Spartak Nalchik 23/-7 2,41 1.00/22 0.88/8 1.17/12 0.80/10   22/1 1,79 1.71/24 1.38/8 2.15/13 1.18/11
2013-04-09 Spartak Nalchik 3-1 Volgar-Astrakhan 24/1 1,81 1.65/26 1.63/8 2.15/13 1.15/13   15/-13 1,72 0.80/25 0.38/8 1.15/13 0.42/12
2013-04-16 Energomash Belgorod 0-1 Spartak Nalchik 19/-7 1,73 1.00/26 1.38/8 1.21/14 0.75/12   27/3 1,89 1.70/27 1.63/8 2.21/14 1.15/13
2013-04-23 Spartak Nalchik 1-1 R. Volgograd 28/4 1,86 1.75/28 1.88/8 2.21/14 1.29/14   23/3 1,59 1.37/27 0.63/8 1.79/14 0.92/13
2013-04-29 Tomsk 1-1 Spartak Nalchik 53/21 3,04 2.14/28 1.50/8 2.57/14 1.71/14   29/4 1,86 1.72/29 2.00/8 2.13/15 1.29/14
2013-05-06 Spartak Nalchik 2-0 FK Novosibirsk 30/4 1,87 1.70/30 2.00/8 2.13/15 1.27/15   32/-3 2,31 1.41/29 1.38/8 1.50/14 1.33/15
2013-05-14 Khimki 2-1 Spartak Nalchik 21/-18 2,07 0.79/29 0.88/8 0.73/15 0.86/14   32/6 1,87 1.74/31 2.00/8 2.19/16 1.27/15
2013-05-19 Spartak Nalchik 2-0 Baltika 33/5 1,91 1.69/32 1.63/8 2.19/16 1.19/16   38/7 2,23 1.55/31 1.75/8 1.53/15 1.56/16
2013-05-25 Ufa 1-0 Spartak Nalchik 35/3 2,03 1.48/33 1.25/8 1.56/16 1.41/17   35/7 1,91 1.73/33 1.88/8 2.24/17 1.19/16