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 0-0 Spartak Nalchik 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-07-23 Spartak Nalchik 1-3 Neftekhimik 1/1 0,50 1.50/2 1.50/2 3.00/1 0.00/1   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 1,67 1.00/3 1.00/3 1.50/2 0.00/1
2012-08-06 Spartak Nalchik 3-2 Ural 3/0 1,50 1.50/4 1.50/4 1.50/2 1.50/2   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,20 1.80/5 1.80/5 2.00/3 1.50/2
2012-08-17 Spartak Nalchik 1-0 FC Novokuznetsk 7/-1 2,50 1.50/6 1.50/6 2.00/3 1.00/3   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,29 1.71/7 1.71/7 2.25/4 1.00/3
2012-08-28 Spartak Nalchik 0-2 Dynamo Petersburg 8/-1 2,13 1.50/8 1.50/8 2.25/4 0.75/4   6/-7 2,38 0.63/8 0.63/8 0.75/4 0.50/4
2012-09-06 Spartak Nalchik 2-1 Torpedo Moscow 8/-3 2,11 1.33/9 1.13/8 1.80/5 0.75/4   5/-5 1,67 1.00/9 1.00/8 1.20/5 0.75/4
2012-09-10 Volgar-Astrakhan 0-0 Spartak Nalchik 6/-4 1,60 0.80/10 0.88/8 1.20/5 0.40/5   10/-2 2,20 1.50/10 1.50/8 2.00/6 0.75/4
2012-09-17 Spartak Nalchik 0-0 Energomash Belgorod 10/-2 2,00 1.45/11 1.63/8 2.00/6 0.80/5   8/-5 1,91 0.82/11 0.63/8 0.83/6 0.80/5
2012-09-21 R. Volgograd 0-1 Spartak Nalchik 8/-1 1,42 1.50/12 1.00/8 2.00/6 1.00/6   10/-2 1,83 1.42/12 1.38/8 1.86/7 0.80/5
2012-10-02 Spartak Nalchik 2-0 Tomsk 11/-1 1,77 1.54/13 1.38/8 1.86/7 1.17/6   27/12 3,23 2.08/13 2.13/8 2.00/7 2.17/6
2012-10-08 Sibir Novosibirsk 0-0 Spartak Nalchik 17/1 2,54 1.54/13 1.63/8 1.17/6 1.86/7   13/1 1,79 1.64/14 1.75/8 2.00/8 1.17/6
2012-10-15 Spartak Nalchik 1-0 Khimki 13/1 1,67 1.60/15 1.50/8 2.00/8 1.14/7   9/-10 1,87 0.40/15 0.63/8 0.14/7 0.63/8
2012-10-22 Baltika 1-0 Spartak Nalchik 16/1 1,94 1.44/16 1.38/8 1.14/7 1.67/9   14/2 1,63 1.69/16 1.88/8 2.11/9 1.14/7
2012-10-26 Spartak Nalchik 0-0 Vladimir 14/1 1,59 1.59/17 1.88/8 2.11/9 1.00/8   0/0 0,00 0.06/16 0.00/8 0.00/7 0.11/9
2012-10-31 Neftekhimik 3-0 Spartak Nalchik 22/3 2,28 1.44/18 1.38/8 1.75/8 1.20/10   14/1 1,50 1.50/18 1.50/8 1.90/10 1.00/8
2012-11-05 Spartak Nalchik 3-2 Shinnik Yaroslavl 14/-2 1,58 1.42/19 1.38/8 1.90/10 0.89/9   11/-9 1,72 0.78/18 0.63/8 1.13/8 0.50/10
2012-11-12 Ural 0-0 Spartak Nalchik 43/32 2,70 2.05/20 2.38/8 2.56/9 1.64/11   17/-1 1,75 1.50/20 1.63/8 2.00/11 0.89/9
2012-11-20 Spartak Nalchik 0-2 Yenisey 17/-1 1,67 1.48/21 1.38/8 2.00/11 0.90/10   17/-4 1,81 1.00/21 0.50/8 1.18/11 0.80/10
2013-03-11 FC Novokuznetsk 0-0 Spartak Nalchik 11/-15 1,68 0.82/22 0.75/8 1.64/11 0.00/11   17/-3 1,68 1.41/22 1.00/8 1.83/12 0.90/10
2013-03-18 Spartak Nalchik 1-0 SKA Khabarovsk 17/-3 1,61 1.39/23 1.00/8 1.83/12 0.91/11   26/9 1,87 1.74/23 1.63/8 2.00/12 1.45/11
2013-03-25 Dynamo Petersburg 0-2 Spartak Nalchik 23/-10 2,33 0.96/24 0.75/8 1.36/11 0.62/13   18/-2 1,58 1.46/24 1.00/8 1.92/13 0.91/11
2013-04-02 Torpedo Moscow 1-1 Spartak Nalchik 23/-7 2,21 0.92/24 0.75/8 1.08/13 0.73/11   20/0 1,60 1.52/25 1.38/8 1.92/13 1.08/12
2013-04-09 Spartak Nalchik 3-1 Volgar-Astrakhan 21/0 1,62 1.50/26 1.50/8 1.92/13 1.08/13   15/-13 1,65 0.73/26 0.38/8 1.07/14 0.33/12
2013-04-16 Energomash Belgorod 0-1 Spartak Nalchik 18/-7 1,59 0.93/27 1.38/8 1.14/14 0.69/13   24/2 1,70 1.56/27 1.88/8 2.00/14 1.08/13
2013-04-23 Spartak Nalchik 1-1 R. Volgograd 25/3 1,68 1.61/28 1.88/8 2.00/14 1.21/14   23/3 1,54 1.29/28 0.63/8 1.67/15 0.85/13
2013-04-29 Tomsk 1-1 Spartak Nalchik 51/20 2,83 1.97/29 1.13/8 2.36/14 1.60/15   26/3 1,69 1.59/29 1.88/8 1.93/15 1.21/14
2013-05-06 Spartak Nalchik 2-0 Sibir Novosibirsk 27/3 1,70 1.57/30 2.00/8 1.93/15 1.20/15   31/-3 2,32 1.43/28 1.38/8 1.50/14 1.36/14
2013-05-14 Khimki 2-1 Spartak Nalchik 19/-16 1,74 0.74/31 0.75/8 0.73/15 0.75/16   29/5 1,71 1.61/31 2.25/8 2.00/16 1.20/15
2013-05-19 Spartak Nalchik 2-0 Baltika 30/4 1,75 1.56/32 1.88/8 2.00/16 1.13/16   37/7 2,09 1.47/32 1.38/8 1.44/16 1.50/16
2013-05-25 Ufa 1-0 Spartak Nalchik 30/0 1,82 1.36/33 1.25/8 1.38/16 1.35/17   32/6 1,76 1.61/33 1.88/8 2.06/17 1.13/16
2018-10-21 Spartak Nalchik 1-3 T. Moscow 32/5 1,74 1.56/34 1.75/8 2.06/17 1.06/17   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2018-10-21 T. Moscow 1-3 Spartak Nalchik 54/4 4,00 1.62/26 1.50/8 0.00/12 3.00/14   33/3 1,80 1.51/35 1.50/8 1.94/18 1.06/17
2018-10-21 Spartak Nalchik 1-3 FK Novosibirsk 36/5 1,86 1.56/36 1.50/8 1.94/18 1.17/18   41/-2 4,00 1.43/21 1.88/8 0.00/11 3.00/10
2018-10-21 FK Novosibirsk 1-3 Spartak Nalchik 1/-2 4,00 0.00/1 1.88/8 0.00/1 0.00/0   37/3 1,92 1.51/37 1.50/8 1.84/19 1.17/18