SELECT * FROM 1_Kampe WHERE LigaID = '245' AND (Home='Spartak Moscow' OR Away='Spartak Moscow') 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 Spartak Moscow 2-1 Volga N. Novgorod 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-08-05 Dynamo Moscow 0-4 Spartak Moscow 0/-3 1,50 0.00/2 0.00/2 0.00/0 0.00/2   4/2 3,00 3.00/2 3.00/2 3.00/1 3.00/1
2012-08-11 Zenit 5-0 Spartak Moscow 7/6 2,67 3.00/3 3.00/3 3.00/2 3.00/1   8/6 3,33 3.00/3 3.00/3 3.00/1 3.00/2
2012-08-18 Spartak Moscow 2-1 Rubin Kazan 8/1 3,75 2.25/4 2.25/4 3.00/1 2.00/3   8/4 3,00 2.25/4 2.25/4 3.00/2 1.50/2
2012-08-25 Akhmat Grozny 2-1 Spartak Moscow 7/-1 2,50 1.83/6 1.83/6 3.00/2 1.25/4   10/2 3,60 2.40/5 2.40/5 3.00/2 2.00/3
2012-09-02 Lokomotiv Moscow 2-1 Spartak Moscow 17/5 3,63 2.00/8 2.00/8 1.75/4 2.25/4   11/1 3,50 2.00/6 2.00/6 3.00/2 1.50/4
2012-09-15 Kuban 2-2 Spartak Moscow 16/4 3,11 1.67/9 1.88/8 3.00/4 0.60/5   12/0 3,43 1.71/7 1.71/7 3.00/2 1.20/5
2012-09-23 Spartak Moscow 3-1 FK Rostov 14/0 3,50 1.63/8 1.63/8 3.00/2 1.17/6   9/-6 2,40 0.90/10 1.00/8 1.40/5 0.40/5
2012-09-29 Amkar 1-3 Spartak Moscow 15/3 2,45 1.45/11 1.63/8 1.80/5 1.17/6   17/2 3,56 1.78/9 1.63/8 3.00/3 1.17/6
2012-10-07 Spartak Moscow 0-2 CSKA Moscow 20/4 3,60 1.90/10 1.63/8 3.00/3 1.43/7   22/12 2,67 2.25/12 2.63/8 2.14/7 2.40/5
2012-10-20 FK Anzi Makhackala 2-1 Spartak Moscow 28/14 3,23 2.46/13 3.00/8 2.71/7 2.17/6   20/2 3,45 1.73/11 1.25/8 2.25/4 1.43/7
2012-10-27 Spartak Moscow 2-0 M. Saransk 21/1 3,42 1.58/12 1.25/8 2.25/4 1.25/8   14/-12 3,33 0.67/12 0.50/8 0.57/7 0.80/5
2012-10-27 Spartak Moscow 2-0 FK Saransk 23/3 3,31 1.69/13 1.63/8 2.40/5 1.25/8   16/-13 3,46 0.62/13 0.50/8 0.50/8 0.80/5
2012-11-03 Krylya Sovetov 0-5 Spartak Moscow 15/-7 2,85 1.00/13 0.75/8 0.86/7 1.17/6   25/5 3,21 1.79/14 1.63/8 2.50/6 1.25/8
2012-11-03 FK Krylya Sovetov Samara 0-5 Spartak Moscow 18/-6 3,00 1.14/14 1.13/8 0.86/7 1.43/7   30/10 3,33 1.87/15 2.25/8 2.50/6 1.44/9
2012-11-11 Spartak Moscow 2-0 Krasnodar 35/15 3,44 1.94/16 2.25/8 2.50/6 1.60/10   31/9 3,31 1.44/16 1.88/8 2.11/9 0.57/7
2012-11-17 Volga N. Novgorod 1-1 Spartak Moscow 17/-13 2,76 0.82/17 1.25/8 0.56/9 1.13/8   37/17 3,35 2.00/17 2.25/8 2.57/7 1.60/10
2012-11-25 Spartak Moscow 1-5 Dynamo Moscow 38/17 3,28 1.94/18 2.00/8 2.57/7 1.55/11   21/-3 2,50 1.50/18 2.25/8 1.67/9 1.33/9
2012-11-30 Spartak Moscow 2-4 Zenit 39/13 3,42 1.84/19 2.00/8 2.25/8 1.55/11   36/17 2,89 2.00/19 2.13/8 1.89/9 2.10/10
2012-12-10 Rubin Kazan 0-1 Spartak Moscow 31/12 2,50 1.85/20 2.38/8 2.11/9 1.64/11   41/11 3,55 1.75/20 2.00/8 2.00/9 1.55/11
2013-03-10 Spartak Moscow 3-1 Akhmat Grozny 42/12 3,43 1.81/21 2.00/8 2.00/9 1.67/12   26/-3 2,62 1.71/21 1.25/8 2.10/10 1.36/11
2013-03-16 Spartak Moscow 0-0 Lokomotiv Moscow 45/14 3,45 1.86/22 2.00/8 2.10/10 1.67/12   33/9 2,48 1.74/23 1.63/8 1.55/11 1.92/12
2013-03-31 Spartak Moscow 2-2 Kuban 45/14 3,30 1.83/23 1.75/8 2.00/11 1.67/12   44/19 2,76 1.80/25 2.13/8 2.25/12 1.38/13
2013-04-06 FK Rostov 1-0 Spartak Moscow 26/-7 2,27 1.04/26 1.63/8 1.42/12 0.71/14   47/14 3,33 1.79/24 1.50/8 1.92/12 1.67/12
2013-04-14 Spartak Moscow 2-0 Amkar 47/13 3,24 1.72/25 1.13/8 1.92/12 1.54/13   30/-9 2,56 1.07/27 0.88/8 1.00/13 1.14/14
2013-04-21 CSKA Moscow 2-2 Spartak Moscow 52/34 2,50 2.43/28 2.75/8 2.57/14 2.29/14   49/15 3,19 1.77/26 1.38/8 2.00/13 1.54/13
2013-04-28 Spartak Moscow 2-0 FK Anzi Makhackala 51/15 3,22 1.74/27 1.50/8 2.00/13 1.50/14   48/14 2,83 1.86/29 0.88/8 2.20/15 1.50/14
2013-05-03 M. Saransk 2-1 Spartak Moscow 25/-26 2,92 0.62/26 0.88/8 0.69/13 0.54/13   53/17 3,18 1.79/28 1.88/8 2.07/14 1.50/14
2013-05-03 FK Saransk 2-1 Spartak Moscow 29/-25 2,96 0.68/28 1.25/8 0.64/14 0.71/14   54/16 3,17 1.72/29 1.13/8 2.07/14 1.40/15
2013-05-10 Spartak Moscow 1-1 FK Krylya Sovetov Samara 55/15 3,17 1.67/30 1.13/8 2.07/14 1.31/16   29/-21 2,72 0.93/29 1.00/8 0.60/15 1.29/14
2013-05-10 Spartak Moscow 1-1 Krylya Sovetov 56/15 3,13 1.65/31 1.13/8 2.00/15 1.31/16   26/-20 2,67 0.89/27 1.00/8 0.64/14 1.15/13
2013-05-18 Krasnodar 0-1 Spartak Moscow 53/11 2,97 1.47/32 1.13/8 2.13/16 0.81/16   57/15 3,09 1.63/32 1.13/8 1.94/16 1.31/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