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 - Vladimir / /0 / / /   / /0 / / /
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 2,50 0.50/2 0.50/2 1.00/1 0.00/1
2012-08-06 Torpedo Moscow 1-0 Shinnik Yaroslavl 1/-5 2,33 0.33/3 0.33/3 1.00/1 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 2,00 1.00/4 1.00/4 2.00/2 0.00/2
2012-08-17 Torpedo Moscow 0-0 Yenisey 2/-7 2,20 0.80/5 0.80/5 2.00/2 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,83 0.83/6 0.83/6 1.67/3 0.00/3
2012-08-28 Torpedo Moscow 0-0 SKA Khabarovsk 5/-5 2,14 1.14/7 1.14/7 1.67/3 0.75/4   8/4 1,33 1.78/9 1.88/8 2.60/5 0.75/4
2012-09-06 Spartak Nalchik 2-1 Torpedo Moscow 10/-2 2,44 1.67/9 1.88/8 2.00/6 1.00/3   5/-5 1,88 1.13/8 1.13/8 1.50/4 0.75/4
2012-09-10 Torpedo Moscow 1-0 Dynamo Petersburg 6/-6 2,00 1.00/9 1.00/8 1.50/4 0.60/5   10/-5 2,50 1.10/10 1.25/8 1.50/4 0.83/6
2012-09-17 Torpedo Moscow 0-0 Volgar-Astrakhan 7/-5 1,90 1.20/10 1.38/8 1.80/5 0.60/5   6/-4 1,45 0.91/11 1.13/8 1.17/6 0.60/5
2012-09-21 Energomash Belgorod 1-1 Torpedo Moscow 9/-5 1,92 0.92/12 0.88/8 1.00/6 0.83/6   7/-5 1,73 1.18/11 1.50/8 1.67/6 0.60/5
2012-10-01 Torpedo Moscow 0-0 R. Volgograd 8/-5 1,75 1.17/12 1.25/8 1.67/6 0.67/6   8/-2 1,38 1.46/13 0.88/8 1.71/7 1.17/6
2012-10-09 Tomsk 2-1 Torpedo Moscow 29/11 3,36 2.14/14 2.38/8 2.43/7 1.86/7   8/-5 1,62 1.15/13 1.38/8 1.57/7 0.67/6
2012-10-15 Torpedo Moscow 1-1 FK Novosibirsk 9/-6 1,71 1.07/14 1.25/8 1.57/7 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 2,07 0.43/14 0.63/8 0.17/6 0.63/8   10/-6 1,73 1.07/15 1.00/8 1.50/8 0.57/7
2012-10-26 Torpedo Moscow 2-2 Ufa 14/-4 2,00 1.19/16 1.25/8 1.50/8 0.88/8   20/2 2,24 1.59/17 1.00/8 1.75/8 1.44/9
2012-10-30 Vladimir - Torpedo Moscow / /0 / / /   / /0 / / /
2012-11-05 Torpedo Moscow 2-3 Neftekhimik 16/-4 2,12 1.18/17 1.38/8 1.44/9 0.88/8   27/8 2,42 1.68/19 1.75/8 2.00/10 1.33/9
2012-11-12 Shinnik Yaroslavl 3-2 Torpedo Moscow 13/-11 1,95 0.74/19 0.63/8 1.29/7 0.42/12   18/-5 2,28 1.11/18 1.00/8 1.30/10 0.88/8
2012-11-19 Torpedo Moscow 2-3 Ural 20/-6 2,42 1.05/19 0.88/8 1.30/10 0.78/9   49/36 2,82 2.18/22 2.50/8 2.45/11 1.91/11
2013-03-12 Yenisey 0-0 Torpedo Moscow 19/-2 1,74 1.13/23 0.75/8 1.27/11 1.00/12   22/-7 2,55 1.00/20 0.75/8 1.18/11 0.78/9
2013-03-19 Torpedo Moscow 1-1 FC Novokuznetsk 22/-7 2,43 1.00/21 0.75/8 1.18/11 0.80/10   13/-17 1,79 0.83/24 1.13/8 1.46/13 0.09/11
2013-04-02 Torpedo Moscow 1-1 Spartak Nalchik 23/-7 2,41 1.00/22 0.88/8 1.17/12 0.80/10   23/1 1,80 1.68/25 1.63/8 2.15/13 1.17/12
2013-04-08 Dynamo Petersburg 1-0 Torpedo Moscow 26/-11 2,42 1.12/26 1.50/8 1.64/11 0.73/15   24/-7 2,39 1.00/23 0.88/8 1.15/13 0.80/10
2013-04-16 Volgar-Astrakhan 0-1 Torpedo Moscow 16/-16 1,78 0.74/27 0.25/8 1.07/14 0.38/13   24/-8 2,33 0.96/24 0.50/8 1.15/13 0.73/11
2013-04-22 Torpedo Moscow 0-1 Energomash Belgorod 25/-7 2,28 1.04/25 0.75/8 1.15/13 0.92/12   20/-7 1,68 1.04/28 1.63/8 1.13/15 0.92/13
2013-04-29 R. Volgograd 0-0 Torpedo Moscow 24/3 1,55 1.34/29 0.63/8 1.73/15 0.93/14   25/-8 2,23 1.00/26 0.75/8 1.07/14 0.92/12
2013-05-06 Torpedo Moscow 1-0 Tomsk 25/-8 2,15 1.00/27 0.88/8 1.07/14 0.92/13   54/20 2,93 2.03/30 0.75/8 2.47/15 1.60/15
2013-05-10 SKA Khabarovsk 1-1 Torpedo Moscow 35/10 1,88 1.63/32 1.50/8 1.81/16 1.44/16   26/-7 2,11 1.07/28 1.25/8 1.20/15 0.92/13
2013-05-14 FK Novosibirsk 1-1 Torpedo Moscow 33/-5 2,29 1.35/31 0.75/8 1.47/15 1.25/16   27/-7 2,10 1.07/29 1.25/8 1.20/15 0.93/14
2013-05-20 Torpedo Moscow 0-0 Khimki 28/-7 2,10 1.07/30 1.25/8 1.20/15 0.93/15   23/-17 2,03 0.87/31 1.25/8 0.88/16 0.87/15
2013-05-25 Baltika 3-1 Torpedo Moscow 38/5 2,22 1.50/32 1.38/8 1.53/15 1.47/17   28/-7 2,03 1.06/31 1.25/8 1.19/16 0.93/15