SELECT * FROM 1_Kampe WHERE LigaID = '254' AND (Home='Neftekhimik' OR Away='Neftekhimik') 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 FC Novokuznetsk 3-1 Neftekhimik 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 Neftekhimik 1-1 SKA Khabarovsk 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   0/0 0,00 1.00/1 1.00/1 1.00/1 0.00/0
2012-07-23 Spartak Nalchik 1-3 Neftekhimik 1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0   2/-2 3,00 0.50/2 0.50/2 1.00/1 0.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 2,50 0.50/2 0.50/2 1.00/1 0.00/1
2012-07-30 Neftekhimik 2-0 T. Moscow 7/2 3,00 1.75/4 2.00/5 2.00/2 1.50/2   1/-3 2,50 0.50/2 0.50/2 1.00/1 0.00/1
2012-08-07 Volgar-Astrakhan 1-1 Neftekhimik 1/-3 1,67 0.33/3 0.33/3 0.50/2 0.00/1   9/4 2,80 2.00/5 2.00/5 2.33/3 1.50/2
2012-08-13 Neftekhimik 3-0 Energomash Belgorod 10/4 2,67 1.83/6 1.83/6 2.33/3 1.33/3   6/1 2,75 1.25/4 1.25/4 0.50/2 2.00/2
2012-08-17 R. Volgograd 2-1 Neftekhimik 4/2 1,20 2.00/5 2.00/5 2.00/3 2.00/2   13/7 2,71 2.00/7 2.00/7 2.50/4 1.33/3
2012-08-22 Neftekhimik 3-3 Tomsk 14/6 2,75 1.75/8 1.75/8 2.50/4 1.00/4   11/6 2,67 2.17/6 2.17/6 2.00/2 2.25/4
2012-08-27 FK Novosibirsk 1-2 Neftekhimik 10/1 2,71 1.43/7 1.43/7 1.33/3 1.50/4   17/6 3,11 1.67/9 1.88/8 2.20/5 1.00/4
2012-09-06 Neftekhimik 1-2 Khimki 19/7 3,10 1.80/10 2.13/8 2.20/5 1.40/5   6/-7 2,71 0.14/7 0.14/7 0.00/3 0.25/4
2012-09-10 Baltika 0-0 Neftekhimik 12/0 2,40 1.40/10 1.50/8 1.00/4 1.67/6   20/6 3,09 1.64/11 1.75/8 1.83/6 1.40/5
2012-09-17 Neftekhimik 1-0 Ufa 20/6 2,83 1.58/12 1.50/8 1.83/6 1.33/6   15/6 2,18 1.82/11 1.75/8 2.00/5 1.67/6
2012-09-21 Vladimir - Neftekhimik / /0 / / /   / /0 / / /
2012-10-01 Dynamo Petersburg 0-1 Neftekhimik 12/-7 2,58 0.92/12 0.88/8 1.50/4 0.63/8   21/7 2,69 1.69/13 1.50/8 2.00/7 1.33/6
2012-10-08 Neftekhimik 1-2 Shinnik Yaroslavl 22/8 2,57 1.79/14 1.75/8 2.00/7 1.57/7   7/-8 1,57 0.71/14 0.88/8 1.33/6 0.25/8
2012-10-14 Ural 3-0 Neftekhimik 33/23 2,87 2.07/15 2.38/8 2.50/8 1.57/7   23/7 2,60 1.67/15 1.38/8 1.75/8 1.57/7
2012-10-22 Neftekhimik 1-0 Yenisey 23/4 2,63 1.56/16 1.38/8 1.75/8 1.38/8   15/0 1,88 1.31/16 1.00/8 1.50/8 1.13/8
2012-10-26 SKA Khabarovsk 0-0 Neftekhimik 20/9 1,72 1.78/18 1.88/8 2.22/9 1.33/9   24/5 2,53 1.65/17 1.63/8 1.89/9 1.38/8
2012-10-31 Neftekhimik 3-0 Spartak Nalchik 24/5 2,39 1.61/18 1.38/8 1.89/9 1.33/9   16/2 1,76 1.76/17 1.88/8 2.20/10 1.14/7
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-05 T. Moscow 2-3 Neftekhimik 16/-4 2,12 1.18/17 1.38/8 1.44/9 0.88/8   30/9 2,55 1.75/20 2.00/8 2.00/10 1.50/10
2012-11-12 Neftekhimik 3-1 Volgar-Astrakhan 33/10 2,67 1.81/21 2.00/8 2.00/10 1.64/11   12/-8 1,68 0.95/19 1.00/8 1.30/10 0.56/9
2012-11-19 Energomash Belgorod 2-0 Neftekhimik 12/-11 1,75 0.80/20 0.63/8 1.00/11 0.56/9   36/12 2,73 1.86/22 2.00/8 2.09/11 1.64/11
2013-03-11 Neftekhimik 0-2 R. Volgograd 36/10 2,70 1.78/23 2.00/8 2.09/11 1.50/12   18/4 1,52 1.52/21 1.63/8 2.18/11 0.80/10
2013-03-18 Tomsk 4-3 Neftekhimik 44/21 3,05 2.36/22 2.75/8 2.50/12 2.20/10   36/8 2,67 1.71/24 2.00/8 1.92/12 1.50/12
2013-03-25 Neftekhimik 0-1 FK Novosibirsk 39/7 2,84 1.64/25 1.63/8 1.92/12 1.38/13   26/2 2,17 1.48/23 1.50/8 1.55/11 1.42/12
2013-04-01 Khimki 0-0 Neftekhimik 19/-14 2,26 0.74/23 1.38/8 0.67/12 0.82/11   39/6 2,77 1.58/26 1.50/8 1.77/13 1.38/13
2013-04-08 Neftekhimik 1-0 Baltika 39/6 2,67 1.56/27 1.25/8 1.77/13 1.36/14   29/3 2,20 1.60/25 1.63/8 1.50/12 1.69/13
2013-04-15 Ufa 2-0 Neftekhimik 30/1 2,19 1.44/27 1.25/8 1.46/13 1.43/14   40/7 2,61 1.61/28 1.25/8 1.86/14 1.36/14
2013-04-22 Neftekhimik - Vladimir / /0 / / /   / /0 / / /
2013-04-29 Neftekhimik 2-0 Dynamo Petersburg 40/5 2,59 1.55/29 0.88/8 1.86/14 1.27/15   28/-9 2,32 1.25/28 1.50/8 1.85/13 0.73/15
2013-05-07 Shinnik Yaroslavl 2-1 Neftekhimik 28/-7 2,10 1.13/30 1.63/8 1.79/14 0.56/16   42/7 2,57 1.60/30 0.88/8 1.93/15 1.27/15
2013-05-13 Neftekhimik 2-2 Ural 43/6 2,58 1.55/31 0.88/8 1.93/15 1.19/16   65/47 2,68 2.29/31 2.50/8 2.50/16 2.07/15
2013-05-19 Yenisey 2-2 Neftekhimik 28/-1 1,78 1.22/32 1.50/8 1.25/16 1.19/16   45/6 2,63 1.53/32 1.00/8 1.88/16 1.19/16
2013-05-25 Neftekhimik 2-1 FC Novokuznetsk 47/6 2,67 1.52/33 1.13/8 1.88/16 1.18/17   20/-22 1,88 0.94/33 1.25/8 1.65/17 0.19/16