SELECT * FROM 1_Kampe WHERE LigaID = '247' AND (Home='Torpedo Moscow' OR Away='Torpedo 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
2018-10-21 Torpedo Moscow 1-3 F. Voronezh 0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0   26/-4 4,00 1.29/14 1.13/8 0.00/8 3.00/6
2018-10-21 Nizhny Novgorod 1-3 Torpedo Moscow 30/-4 4,00 1.31/16 1.13/8 0.00/9 3.00/7   1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0
2018-10-21 Torpedo Moscow 1-3 M. Saransk 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2018-10-21 Torpedo Moscow 1-3 Nizhny Novgorod 5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1   35/-6 4,00 1.26/19 1.13/8 0.00/11 3.00/8
2018-10-21 F. Voronezh 1-3 Torpedo Moscow 25/-2 4,00 1.38/13 1.13/8 0.00/7 3.00/6   6/-4 4,00 0.75/4 1.50/8 0.00/3 3.00/1
2018-10-21 Torpedo Moscow 1-3 Nizhny Novgorod 9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2   32/-8 4,00 1.17/18 1.13/8 0.00/11 3.00/7
2018-10-21 M. Saransk 1-3 Torpedo Moscow 22/-4 4,00 1.25/12 1.50/8 0.00/7 3.00/5   10/-4 4,00 1.00/6 1.50/8 0.00/4 3.00/2
2018-10-21 M. Saransk 1-3 Torpedo Moscow 21/-2 4,00 1.36/11 1.50/8 0.00/6 3.00/5   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2018-10-21 Nizhny Novgorod 1-3 Torpedo Moscow 31/-6 4,00 1.24/17 1.13/8 0.00/10 3.00/7   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2019-07-07 Fakel Voronezh 0-1 Torpedo Moscow 4/0 4,00 1.50/2 1.50/2 0.00/1 3.00/1   19/2 4,00 1.67/9 1.50/8 0.00/4 3.00/5
2019-07-13 Torpedo Moscow 2-0 Baltika 20/3 3,70 1.80/10 1.88/8 0.00/4 3.00/6   16/-1 3,67 1.33/9 1.13/8 0.00/5 3.00/4
2019-07-20 SKA Khabarovsk 0-1 Torpedo Moscow 19/-1 3,90 1.30/10 1.63/8 0.00/5 2.60/5   22/5 3,55 1.91/11 2.25/8 0.60/5 3.00/6
2019-07-24 Torpedo Moscow 2-2 FK Saransk 23/6 3,33 2.00/12 2.63/8 0.60/5 3.00/7   9/-1 2,71 1.29/7 1.29/7 0.75/4 2.00/3
2019-07-24 Torpedo Moscow 2-2 Mordovia Saransk 25/6 3,38 1.92/13 2.13/8 0.67/6 3.00/7   1/-1 1,00 1.00/3 1.00/3 1.50/2 0.00/1
2019-07-28 Pari NN 2-1 Torpedo Moscow 2/-6 2,50 0.25/4 0.25/4 0.00/2 0.50/2   27/6 3,43 1.86/14 2.13/8 0.71/7 3.00/7
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-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-10 Luch 0-1 Torpedo Moscow 26/-4 3,73 1.33/15 1.00/8 0.44/9 2.67/6   32/7 3,35 1.88/17 2.13/8 1.22/9 2.63/8
2019-08-10 Luch 0-1 Torpedo Moscow 26/-3 3,93 1.43/14 1.75/8 0.50/8 2.67/6   33/8 3,22 1.94/18 2.13/8 1.22/9 2.67/9
2019-08-14 Torpedo Moscow 3-1 Kursk 34/9 3,11 2.00/19 2.13/8 1.22/9 2.70/10   24/-7 3,44 1.25/16 1.00/8 0.63/8 1.88/8
2019-08-14 Torpedo Moscow 3-1 Kursk 37/11 3,15 2.05/20 2.38/8 1.40/10 2.70/10   23/-5 3,40 1.33/15 1.00/8 0.63/8 2.14/7
2019-08-18 Torpedo Moscow 3-1 Tekstilshtik 40/13 3,19 2.10/21 2.38/8 1.55/11 2.70/10   27/-6 3,53 1.18/17 1.00/8 0.14/7 1.90/10
2019-08-18 Torpedo Moscow 3-1 Tekstilshtik 43/15 3,23 2.14/22 3.00/8 1.67/12 2.70/10   26/-4 3,50 1.25/16 1.00/8 0.14/7 2.11/9
2019-08-25 Torpedo Moscow 2-0 Yenisey 46/17 3,26 2.17/23 3.00/8 1.77/13 2.70/10   20/-12 2,89 1.00/18 0.38/8 0.14/7 1.55/11
2019-08-25 Torpedo Moscow 2-0 Yenisey 48/19 3,21 2.21/24 3.00/8 1.86/14 2.70/10   20/-10 2,94 1.06/17 0.38/8 0.14/7 1.70/10
2019-08-31 R. Volgograd 0-2 Torpedo Moscow 33/7 3,11 1.79/19 1.63/8 0.50/8 2.73/11   50/21 3,16 2.24/25 3.00/8 1.93/15 2.70/10
2019-08-31 R. Volgograd 0-2 Torpedo Moscow 33/9 3,17 1.89/18 2.00/8 0.57/7 2.73/11   52/23 3,12 2.27/26 3.00/8 1.93/15 2.73/11
2019-09-08 Torpedo Moscow 1-0 Khimki 54/25 3,07 2.30/27 3.00/8 1.93/15 2.75/12   41/18 3,20 1.95/20 1.75/8 1.67/9 2.18/11
2019-09-08 Torpedo Moscow 1-0 Khimki 55/26 3,00 2.32/28 3.00/8 2.00/16 2.75/12   41/19 3,32 2.05/19 2.25/8 1.67/9 2.40/10
2019-09-14 Torpedo Moscow 2-1 Krasnodar 2 56/27 2,93 2.34/29 3.00/8 2.06/17 2.75/12   28/-3 2,95 1.20/20 1.25/8 0.22/9 2.00/11
2019-09-14 Torpedo Moscow 2-1 Krasnodar 2 58/28 2,93 2.37/30 3.00/8 2.11/18 2.75/12   29/-4 2,95 1.14/21 0.88/8 0.22/9 1.83/12
2019-09-21 Torpedo Moscow 2-1 Tomsk 60/29 2,94 2.39/31 3.00/8 2.16/19 2.75/12   30/5 2,62 1.52/21 0.88/8 1.00/12 2.22/9
2019-09-21 Torpedo Moscow 2-1 Tomsk 62/30 2,94 2.41/32 3.00/8 2.20/20 2.75/12   31/4 2,64 1.45/22 0.75/8 1.00/12 2.00/10
2019-09-29 Neftekhimik 1-0 Torpedo Moscow 38/6 2,92 1.58/24 2.13/8 0.82/11 2.23/13   64/31 2,94 2.42/33 3.00/8 2.24/21 2.75/12
2019-09-29 Neftekhimik 1-0 Torpedo Moscow 37/5 3,00 1.52/23 1.50/8 0.60/10 2.23/13   64/30 2,88 2.35/34 2.25/8 2.24/21 2.54/13
2019-10-05 Torpedo Moscow 2-0 Shinnik Yaroslavl 64/29 2,83 2.29/35 2.25/8 2.24/21 2.36/14   40/3 3,08 1.64/25 1.38/8 1.17/12 2.08/13
2019-10-05 Torpedo Moscow 2-0 Shinnik Yaroslavl 66/31 2,81 2.31/36 2.25/8 2.27/22 2.36/14   40/5 3,13 1.71/24 1.88/8 1.17/12 2.25/12
2019-10-12 Spartak Moscow 2 2-3 Torpedo Moscow 37/-5 3,16 1.16/25 0.63/8 0.64/11 1.57/14   68/33 2,78 2.32/37 2.25/8 2.30/23 2.36/14
2019-10-12 Spartak Moscow 2 2-3 Torpedo Moscow 39/-6 3,23 1.12/26 0.25/8 0.58/12 1.57/14   71/34 2,84 2.34/38 2.25/8 2.30/23 2.40/15
2019-10-19 Torpedo Moscow 0-1 Chertanovo M. 74/35 2,90 2.36/39 2.25/8 2.30/23 2.44/16   37/6 2,62 1.69/26 1.38/8 0.83/12 2.43/14
2019-10-19 Torpedo Moscow 0-1 Chertanovo M. 74/34 2,85 2.30/40 1.50/8 2.21/24 2.44/16   38/7 2,56 1.74/27 1.88/8 0.83/12 2.47/15
2019-10-23 Torpedo Moscow 2-1 FK Chayka 74/33 2,80 2.24/41 1.50/8 2.12/25 2.44/16   36/-1 2,61 1.32/28 0.88/8 0.92/12 1.63/16
2019-10-23 Torpedo Moscow 2-1 FK Chayka 76/34 2,81 2.26/42 2.25/8 2.15/26 2.44/16   35/0 2,59 1.37/27 1.63/8 0.92/12 1.73/15
2019-10-27 Baltika 1-1 Torpedo Moscow 45/13 2,75 1.68/28 2.50/8 1.08/12 2.13/16   78/35 2,81 2.28/43 2.25/8 2.19/27 2.44/16
2019-11-03 Torpedo Moscow 2-1 SKA Khabarovsk 79/35 2,80 2.25/44 2.00/8 2.19/27 2.35/17   48/8 3,03 1.48/29 1.25/8 1.24/17 1.83/12
2019-11-03 Torpedo Moscow 2-1 SKA Khabarovsk 81/36 2,80 2.27/45 2.00/8 2.21/28 2.35/17   49/7 3,03 1.43/30 0.88/8 1.24/17 1.69/13
2019-11-09 FK Saransk 1-1 Torpedo Moscow 22/-19 2,52 0.80/25 0.50/8 0.62/13 1.00/12   83/37 2,80 2.28/46 2.00/8 2.24/29 2.35/17
2019-11-09 Mordovia Saransk 1-1 Torpedo Moscow 14/-19 2,24 0.67/21 0.50/8 0.73/11 0.60/10   84/37 2,79 2.26/47 1.88/8 2.24/29 2.28/18
2019-11-13 Torpedo Moscow 0-2 Pari NN 85/37 2,77 2.23/48 1.88/8 2.24/29 2.21/19   24/-1 2,13 1.39/23 1.38/8 1.33/12 1.45/11
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 Torpedo Moscow 0-2 Luch 86/34 2,76 2.14/50 1.50/8 2.17/30 2.10/20   45/-11 2,89 1.17/35 1.25/8 0.58/19 1.88/16
2019-11-23 Torpedo Moscow 0-2 Luch 86/32 2,75 2.10/51 1.00/8 2.10/31 2.10/20   43/-13 2,91 1.12/34 0.50/8 0.58/19 1.80/15
2020-03-09 Kursk 2-2 Torpedo Moscow 45/-12 2,91 1.14/35 1.25/8 1.06/18 1.24/17   86/30 2,73 2.06/52 1.00/8 2.03/32 2.10/20
2020-03-09 Kursk 2-2 Torpedo Moscow 47/-12 2,94 1.14/36 1.00/8 1.05/19 1.24/17   88/30 2,75 2.04/53 0.50/8 2.03/32 2.05/21
2020-03-15 Tekstilshtik 0-0 Torpedo Moscow 42/-30 3,08 0.84/37 0.75/8 0.67/18 1.00/19   90/30 2,78 2.02/54 0.50/8 2.03/32 2.00/22
2020-03-15 Tekstilshtik 0-0 Torpedo Moscow 42/-30 3,17 0.83/36 0.50/8 0.65/17 1.00/19   90/30 2,73 2.00/55 0.50/8 2.03/32 1.96/23
2020-03-22 Yenisey 0-0 Torpedo Moscow 41/-18 2,70 1.16/37 1.13/8 1.06/18 1.26/19   90/30 2,68 1.98/56 0.50/8 2.03/32 1.92/24
2020-03-22 Yenisey 0-0 Torpedo Moscow 41/-18 2,63 1.13/38 1.13/8 1.00/19 1.26/19   90/30 2,63 1.95/57 0.50/8 2.03/32 1.84/25
2020-03-29 Torpedo Moscow 0-0 R. Volgograd 90/30 2,59 1.91/58 0.50/8 2.03/32 1.77/26   58/19 2,55 1.87/38 1.88/8 1.32/19 2.42/19
2020-03-29 Torpedo Moscow 0-0 R. Volgograd 90/30 2,54 1.88/59 0.50/8 1.97/33 1.77/26   58/19 2,49 1.82/39 1.38/8 1.32/19 2.30/20
2020-04-04 Khimki 0-0 Torpedo Moscow 70/34 2,72 1.77/39 1.00/8 1.89/19 1.65/20   90/30 2,50 1.85/60 0.50/8 1.91/34 1.77/26
2020-04-04 Khimki 0-0 Torpedo Moscow 70/34 2,65 1.73/40 1.00/8 1.80/20 1.65/20   90/30 2,46 1.82/61 0.25/8 1.91/34 1.70/27
2020-04-08 Krasnodar 2 0-0 Torpedo Moscow 52/0 2,54 1.05/41 0.13/8 0.63/19 1.41/22   90/30 2,42 1.79/62 0.25/8 1.91/34 1.64/28
2020-04-08 Krasnodar 2 0-0 Torpedo Moscow 52/0 2,60 1.08/40 0.63/8 0.67/18 1.41/22   90/30 2,38 1.76/63 0.00/8 1.91/34 1.59/29
2020-04-12 Tomsk 0-0 Torpedo Moscow 51/7 2,32 1.32/41 0.38/8 1.40/20 1.24/21   90/30 2,34 1.73/64 0.00/8 1.91/34 1.53/30
2020-04-12 Tomsk 0-0 Torpedo Moscow 51/7 2,26 1.29/42 0.38/8 1.33/21 1.24/21   90/30 2,31 1.71/65 0.00/8 1.91/34 1.48/31
2020-04-18 Torpedo Moscow 0-0 Neftekhimik 90/30 2,27 1.68/66 0.00/8 1.91/34 1.44/32   56/15 2,31 1.57/42 0.63/8 1.14/21 2.00/21
2020-04-18 Torpedo Moscow 0-0 Neftekhimik 90/30 2,24 1.66/67 0.00/8 1.86/35 1.44/32   56/15 2,26 1.53/43 0.13/8 1.14/21 1.91/22
2020-04-26 Shinnik Yaroslavl 0-0 Torpedo Moscow 61/7 2,61 1.34/44 0.38/8 0.95/21 1.70/23   90/30 2,21 1.63/68 0.00/8 1.81/36 1.44/32
2020-04-26 Shinnik Yaroslavl 0-0 Torpedo Moscow 61/7 2,56 1.31/45 0.00/8 0.91/22 1.70/23   90/30 2,17 1.61/69 0.00/8 1.81/36 1.39/33
2020-05-02 Torpedo Moscow 0-0 Spartak Moscow 2 90/30 2,14 1.59/70 0.00/8 1.81/36 1.35/34   58/-7 2,67 0.89/46 0.00/8 0.74/23 1.04/23
2020-05-02 Torpedo Moscow 0-0 Spartak Moscow 2 90/30 2,11 1.56/71 0.00/8 1.76/37 1.35/34   58/-7 2,73 0.91/45 0.00/8 0.74/23 1.09/22
2020-05-06 Chertanovo M. 0-0 Torpedo Moscow 60/23 2,11 1.63/46 0.00/8 1.27/22 1.96/24   90/30 2,08 1.54/72 0.00/8 1.71/38 1.35/34
2020-05-10 FK Chayka 0-0 Torpedo Moscow 51/3 2,11 1.15/47 0.00/8 1.09/23 1.21/24   90/30 2,05 1.52/73 0.00/8 1.71/38 1.31/35
2020-05-16 Torpedo Moscow 0-0 Fakel Voronezh 90/30 2,03 1.50/74 0.00/8 1.71/38 1.28/36   21/-29 1,73 0.63/41 0.00/8 0.67/21 0.60/20