SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Armavir' OR Away='Armavir') 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
2018-10-21 Armavir 1-3 F. Voronezh 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   78/-4 4,00 1.43/40 1.13/8 0.00/21 3.00/19
2018-10-21 Armavir 1-3 Nizhny Novgorod 1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0   49/-2 4,00 1.44/25 1.13/8 0.00/13 3.00/12
2018-10-21 Armavir 1-3 T. Moscow 2/-4 4,00 0.00/2 1.50/8 0.00/2 0.00/0   65/-2 4,00 1.45/33 2.25/8 0.00/17 3.00/16
2018-10-21 T. Moscow 1-3 Armavir 21/-10 4,00 0.92/13 2.25/8 0.00/9 3.00/4   3/-6 4,00 0.00/3 1.50/8 0.00/3 0.00/0
2018-10-21 F. Voronezh 1-3 Armavir 17/-2 4,00 1.33/9 1.13/8 0.00/5 3.00/4   6/-4 4,00 0.75/4 1.50/8 0.00/3 3.00/1
2018-10-21 Armavir 1-3 M. Saransk 9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2   5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1
2018-10-21 Nizhny Novgorod 1-3 Armavir 13/-2 4,00 1.29/7 1.13/8 0.00/4 3.00/3   10/-4 4,00 1.00/6 1.50/8 0.00/4 3.00/2
2018-10-21 M. Saransk 1-3 Armavir 58/-4 4,00 1.40/30 1.50/8 0.00/16 3.00/14   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2019-07-09 Armavir 2-1 Krasnodar 2 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2019-07-13 Tomsk 2-0 Armavir 18/2 3,78 1.67/9 1.50/8 0.00/4 3.00/5   18/1 3,89 1.67/9 1.50/8 0.60/5 3.00/4
2019-07-20 Armavir 0-2 Neftekhimik 18/-1 3,70 1.50/10 1.50/8 0.60/5 2.40/5   19/2 3,27 1.73/11 1.63/8 0.20/5 3.00/6
2019-07-24 Shinnik Yaroslavl 1-1 Armavir 23/5 3,42 2.00/12 2.63/8 1.00/6 3.00/6   18/-3 3,55 1.36/11 1.13/8 0.50/6 2.40/5
2019-07-29 Armavir 1-1 Spartak Moscow 2 19/-3 3,42 1.33/12 1.25/8 0.50/6 2.17/6   21/1 3,15 1.46/13 1.25/8 0.67/6 2.14/7
2019-08-04 Torpedo Moscow 2-1 Armavir 30/6 3,38 1.81/16 2.13/8 1.00/8 2.63/8   20/-3 3,31 1.31/13 1.00/8 0.57/7 2.17/6
2019-08-04 Torpedo Moscow 2-1 Armavir 28/5 3,40 1.73/15 1.75/8 0.71/7 2.63/8   21/-4 3,29 1.21/14 0.63/8 0.57/7 1.86/7
2019-08-10 Armavir 2-1 FK Chayka 22/-5 3,27 1.13/15 0.63/8 0.57/7 1.63/8   17/-2 2,40 1.27/15 0.88/8 0.14/7 2.25/8
2019-08-14 Fakel Voronezh 0-2 Armavir 10/-2 2,20 1.10/10 1.00/8 1.14/7 1.00/3   24/-4 3,25 1.25/16 1.00/8 0.88/8 1.63/8
2019-08-18 Armavir 1-1 Baltika 26/-2 3,18 1.35/17 1.00/8 0.88/8 1.78/9   27/1 3,12 1.41/17 1.50/8 0.38/8 2.33/9
2019-08-25 SKA Khabarovsk 3-0 Armavir 27/1 2,94 1.33/18 1.38/8 0.64/11 2.43/7   27/-2 3,11 1.33/18 1.13/8 0.89/9 1.78/9
2019-08-31 Armavir 0-0 Mordovia Saransk 27/-5 3,11 1.26/19 1.13/8 0.89/9 1.60/10   8/-6 2,20 0.80/10 1.00/8 0.67/6 1.00/4
2019-08-31 Armavir 0-0 FK Saransk 27/-5 2,95 1.25/20 1.13/8 0.90/10 1.60/10   16/-6 2,71 1.00/14 1.00/8 0.50/8 1.67/6
2019-09-07 Pari NN 1-0 Armavir 10/-3 1,92 1.33/12 1.88/8 1.33/6 1.33/6   27/-5 2,81 1.24/21 1.13/8 0.91/11 1.60/10
2019-09-15 Armavir 1-1 Chertanovo M. 27/-6 2,73 1.18/22 1.13/8 0.91/11 1.45/11   32/5 2,81 1.71/21 1.38/8 0.90/10 2.45/11
2019-09-21 Armavir 0-0 Luch 28/-6 2,70 1.17/23 1.25/8 0.92/12 1.45/11   34/-2 3,04 1.39/23 1.50/8 0.64/14 2.56/9
2019-09-29 Kursk 2-1 Armavir 31/-10 3,00 1.08/24 0.75/8 0.75/12 1.42/12   28/-6 2,58 1.17/24 1.00/8 0.92/13 1.45/11
2019-10-05 Armavir 2-0 Tekstilshtik 29/-7 2,60 1.12/25 0.63/8 0.92/13 1.33/12   33/-20 3,44 0.92/25 0.38/8 0.36/11 1.36/14
2019-10-12 Yenisey 1-1 Armavir 31/-14 2,92 1.12/26 1.38/8 0.73/11 1.40/15   31/-5 2,58 1.19/26 0.88/8 1.07/14 1.33/12
2019-10-19 Armavir 0-0 R. Volgograd 32/-5 2,56 1.19/27 1.00/8 1.07/14 1.31/13   46/10 3,04 1.81/27 1.88/8 1.08/12 2.40/15
2019-10-23 Khimki 1-0 Armavir 54/27 2,89 1.86/28 1.63/8 1.85/13 1.87/15   32/-5 2,46 1.18/28 1.00/8 1.07/15 1.31/13
2019-10-27 Armavir 1-1 Tomsk 32/-6 2,41 1.14/29 0.88/8 1.07/15 1.21/14   40/9 2,45 1.52/29 1.50/8 1.38/16 1.69/13
2019-11-03 Neftekhimik 2-1 Armavir 45/10 2,67 1.70/30 2.38/8 1.14/14 2.19/16   33/-6 2,40 1.13/30 1.00/8 1.06/16 1.21/14
2019-11-09 Armavir 0-1 Shinnik Yaroslavl 34/-7 2,42 1.10/31 0.88/8 1.06/16 1.13/15   49/0 3,06 1.44/32 0.63/8 0.93/15 1.88/17
2019-11-13 Spartak Moscow 2 1-3 Armavir 55/-2 3,39 1.18/33 1.25/8 1.00/16 1.35/17   34/-8 2,38 1.06/32 0.75/8 1.00/17 1.13/15
2019-11-17 Armavir 2-1 Torpedo Moscow 37/-6 2,42 1.12/33 1.13/8 1.00/17 1.25/16   85/35 2,76 2.18/49 1.88/8 2.17/30 2.21/19
2019-11-23 FK Chayka 1-0 Armavir 48/2 2,69 1.40/35 1.50/8 1.25/16 1.53/19   39/-5 2,44 1.18/34 1.13/8 1.11/18 1.25/16
2020-03-09 Armavir 1-0 Fakel Voronezh 39/-6 2,40 1.14/35 1.00/8 1.11/18 1.18/17   20/-29 2,38 0.79/29 0.63/8 0.73/15 0.86/14
2020-03-15 Baltika 2-0 Armavir 51/10 2,56 1.53/36 1.00/8 1.18/17 1.84/19   40/-5 2,36 1.19/36 1.25/8 1.21/19 1.18/17
2020-03-22 Armavir 0-0 SKA Khabarovsk 40/-7 2,35 1.16/37 1.25/8 1.21/19 1.11/18   63/11 3,03 1.53/38 1.88/8 1.42/19 1.63/19
2020-03-29 Mordovia Saransk - Armavir / /0 / / /   / /0 / / /
2020-03-29 FK Saransk 0-0 Armavir 29/-23 2,53 0.78/32 0.63/8 0.63/16 0.94/16   40/-7 2,29 1.13/38 1.13/8 1.15/20 1.11/18
2020-04-04 Armavir 0-0 Pari NN 40/-7 2,23 1.10/39 1.13/8 1.15/20 1.05/19   29/0 1,93 1.30/30 1.00/8 1.13/15 1.47/15
2020-04-08 Chertanovo M. 0-0 Armavir 60/23 2,37 1.83/41 1.50/8 1.47/19 2.14/22   40/-7 2,18 1.08/40 1.13/8 1.10/21 1.05/19
2020-04-12 Luch 0-0 Armavir 48/-10 2,52 1.07/42 0.88/8 0.52/21 1.62/21   40/-7 2,12 1.05/41 0.75/8 1.10/21 1.00/20
2020-04-18 Armavir 0-0 Kursk 40/-7 2,07 1.02/42 0.38/8 1.10/21 0.95/21   50/-12 2,60 1.00/43 0.38/8 0.91/23 1.10/20
2020-04-26 Tekstilshtik 0-0 Armavir 42/-30 2,59 0.73/44 0.25/8 0.62/21 0.83/23   40/-7 2,02 1.00/43 0.38/8 1.05/22 0.95/21
2020-05-02 Armavir 0-0 Yenisey 40/-7 1,98 0.98/44 0.00/8 1.05/22 0.91/22   41/-18 2,22 0.96/45 0.00/8 0.83/23 1.09/22
2020-05-06 R. Volgograd 0-0 Armavir 58/19 2,11 1.54/46 0.00/8 1.14/22 1.92/24   40/-7 1,93 0.96/45 0.00/8 1.00/23 0.91/22
2020-05-10 Armavir 0-0 Khimki 40/-7 1,89 0.93/46 0.00/8 1.00/23 0.87/23   70/34 2,26 1.47/47 0.00/8 1.50/24 1.43/23
2020-05-16 Krasnodar 2 0-0 Armavir 52/0 2,17 0.90/48 0.00/8 0.52/23 1.24/25   40/-7 1,85 0.91/47 0.00/8 0.96/24 0.87/23