SELECT * FROM 1_Kampe WHERE LigaID = '254' 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
2012-07-10 Torpedo Moscow 1-1 Baltika 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 Ufa 3-0 Torpedo Moscow 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   1/0 2,00 1.00/1 1.00/1 1.00/1 0.00/0
2012-07-23 Torpedo Moscow 0-0 Vladimir 1/-3 2,50 0.50/2 0.50/2 1.00/1 0.00/1   0/0 0,00 0.50/2 0.50/2 0.00/1 1.00/1
2012-07-30 Neftekhimik 2-0 Torpedo Moscow 5/0 3,33 1.33/3 1.33/3 1.00/1 1.50/2   1/-3 1,67 0.33/3 0.33/3 0.50/2 0.00/1
2012-08-06 Torpedo Moscow 1-0 Shinnik Yaroslavl 1/-5 1,75 0.25/4 0.25/4 0.50/2 0.00/2   3/-2 2,00 0.75/4 0.75/4 1.50/2 0.00/2
2012-08-13 Ural 3-0 Torpedo Moscow 8/3 2,60 1.20/5 1.20/5 1.67/3 0.50/2   2/-4 1,60 0.80/5 0.80/5 1.33/3 0.00/2
2012-08-17 Torpedo Moscow 0-0 Yenisey 2/-7 1,83 0.67/6 0.67/6 1.33/3 0.00/3   8/3 2,17 1.83/6 1.83/6 2.50/4 0.50/2
2012-08-22 FC Novokuznetsk 1-3 Torpedo Moscow 4/-1 1,29 1.14/7 1.14/7 2.00/4 0.00/3   2/-7 1,57 0.71/7 0.71/7 1.25/4 0.00/3
2012-08-28 Torpedo Moscow 0-0 SKA Khabarovsk 5/-5 1,88 1.00/8 1.00/8 1.25/4 0.75/4   8/4 1,50 1.88/8 1.88/8 2.60/5 0.67/3
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 Torpedo Moscow 1-0 Dynamo Petersburg 6/-6 1,80 0.90/10 1.00/8 1.20/5 0.60/5   10/-4 2,40 1.10/10 1.38/8 1.20/5 1.00/5
2012-09-17 Torpedo Moscow 0-0 Volgar-Astrakhan 7/-5 1,73 1.09/11 1.38/8 1.50/6 0.60/5   6/-4 1,45 0.82/11 1.00/8 1.17/6 0.40/5
2012-09-21 Energomash Belgorod 1-1 Torpedo Moscow 8/-5 1,75 0.83/12 0.63/8 0.83/6 0.83/6   7/-5 1,58 1.08/12 1.50/8 1.43/7 0.60/5
2012-10-01 Torpedo Moscow 0-0 R. Volgograd 8/-5 1,62 1.08/13 1.25/8 1.43/7 0.67/6   8/-2 1,38 1.38/13 1.00/8 1.71/7 1.00/6
2012-10-09 Tomsk 2-1 Torpedo Moscow 27/10 3,14 1.93/14 1.75/8 2.00/7 1.86/7   8/-5 1,50 1.07/14 1.38/8 1.38/8 0.67/6
2012-10-15 Torpedo Moscow 1-1 Sibir Novosibirsk 9/-6 1,60 1.00/15 1.25/8 1.38/8 0.57/7   17/1 2,36 1.50/14 1.38/8 1.14/7 1.86/7
2012-10-22 Khimki 2-4 Torpedo Moscow 9/-11 1,81 0.38/16 0.63/8 0.14/7 0.56/9   10/-6 1,63 1.00/16 1.00/8 1.33/9 0.57/7
2012-10-26 Torpedo Moscow 2-2 Ufa 14/-4 1,88 1.12/17 1.25/8 1.33/9 0.88/8   17/-1 2,06 1.41/17 0.88/8 1.38/8 1.44/9
2012-10-30 Vladimir 0-0 Torpedo Moscow 0/0 0,00 0.06/17 0.00/8 0.00/7 0.10/10   16/-4 2,00 1.11/18 1.38/8 1.30/10 0.88/8
2012-11-05 Torpedo Moscow 2-3 Neftekhimik 16/-4 1,89 1.05/19 1.00/8 1.30/10 0.78/9   25/6 2,32 1.53/19 1.63/8 1.89/9 1.20/10
2012-11-12 Shinnik Yaroslavl 3-2 Torpedo Moscow 13/-10 1,89 0.74/19 0.50/8 1.13/8 0.45/11   18/-5 2,05 1.00/20 0.88/8 1.18/11 0.78/9
2012-11-19 Torpedo Moscow 2-3 Ural 20/-6 2,19 0.95/21 0.75/8 1.18/11 0.70/10   43/32 2,57 2.00/21 2.13/8 2.40/10 1.64/11
2013-03-12 Yenisey 0-0 Torpedo Moscow 19/-2 1,82 1.09/22 0.88/8 1.18/11 1.00/11   22/-7 2,32 0.91/22 0.63/8 1.08/12 0.70/10
2013-03-19 Torpedo Moscow 1-1 FC Novokuznetsk 22/-7 2,22 0.91/23 0.75/8 1.08/12 0.73/11   11/-15 1,61 0.83/23 0.88/8 1.58/12 0.00/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-08 Dynamo Petersburg 1-0 Torpedo Moscow 25/-11 2,35 1.00/26 1.13/8 1.25/12 0.79/14   24/-7 2,20 0.92/25 0.50/8 1.07/14 0.73/11
2013-04-16 Volgar-Astrakhan 0-1 Torpedo Moscow 16/-15 1,74 0.70/27 0.25/8 1.07/14 0.31/13   24/-8 2,15 0.88/26 0.38/8 1.07/14 0.67/12
2013-04-22 Torpedo Moscow 0-1 Energomash Belgorod 25/-7 2,11 0.96/27 0.75/8 1.07/14 0.85/13   18/-8 1,57 0.89/28 1.25/8 1.07/15 0.69/13
2013-04-29 R. Volgograd 0-0 Torpedo Moscow 24/3 1,55 1.28/29 0.75/8 1.67/15 0.86/14   25/-8 2,07 0.93/28 0.75/8 1.00/15 0.85/13
2013-05-06 Torpedo Moscow 1-0 Tomsk 25/-8 2,00 0.93/29 0.88/8 1.00/15 0.86/14   52/20 2,80 1.93/30 1.13/8 2.27/15 1.60/15
2013-05-10 SKA Khabarovsk 1-1 Torpedo Moscow 34/10 1,93 1.67/30 1.63/8 1.87/15 1.47/15   26/-7 1,97 1.00/30 1.25/8 1.13/16 0.86/14
2013-05-14 Sibir Novosibirsk 1-1 Torpedo Moscow 31/-5 2,31 1.38/29 1.00/8 1.50/14 1.27/15   27/-7 1,97 1.00/31 1.25/8 1.13/16 0.87/15
2013-05-20 Torpedo Moscow 0-0 Khimki 28/-7 1,97 1.00/32 1.25/8 1.13/16 0.88/16   21/-15 1,78 0.81/32 1.13/8 0.88/16 0.75/16
2013-05-25 Baltika 3-1 Torpedo Moscow 37/5 2,09 1.42/33 1.00/8 1.44/16 1.41/17   28/-7 1,91 1.00/33 1.25/8 1.12/17 0.88/16
2018-10-21 FK Novosibirsk 1-3 Torpedo Moscow 32/0 4,00 1.50/16 1.88/8 0.00/8 3.00/8   29/-9 1,97 0.97/34 1.25/8 1.12/17 0.82/17
2018-10-21 Torpedo Moscow 1-3 FK Novosibirsk 32/-7 2,03 1.03/35 1.25/8 1.12/17 0.94/18   69/-2 4,00 1.46/35 1.88/8 0.00/18 3.00/17