SELECT * FROM 1_Kampe WHERE LigaID = '254' AND (Home='FK Novosibirsk' OR Away='FK Novosibirsk') 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 Energomash Belgorod 1-2 FK Novosibirsk 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 FK Novosibirsk 1-1 R. Volgograd 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   1/1 1,00 3.00/1 3.00/1 3.00/1 0.00/0
2012-07-23 Tomsk 2-0 FK Novosibirsk 3/1 2,50 1.50/2 1.50/2 0.00/0 1.50/2   3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1
2012-07-31 Dynamo Petersburg 3-2 FK Novosibirsk 2/-6 3,33 0.33/3 0.33/3 0.00/1 0.50/2   3/-1 2,33 1.33/3 1.33/3 1.00/1 1.50/2
2012-08-07 FK Novosibirsk 2-1 Khimki 5/-2 3,00 1.00/4 1.00/4 1.00/1 1.00/3   2/-4 2,00 0.25/4 0.25/4 0.00/2 0.50/2
2012-08-13 Baltika 0-3 FK Novosibirsk 8/1 2,50 1.17/6 1.17/6 1.50/2 1.00/4   7/-1 3,00 1.40/5 1.40/5 2.00/2 1.00/3
2012-08-17 FK Novosibirsk 0-1 Ufa 10/2 3,00 1.67/6 1.67/6 2.00/2 1.50/4   9/5 1,86 1.86/7 1.86/7 1.75/4 2.00/3
2012-08-22 Vladimir - FK Novosibirsk / /0 / / /   / /0 / / /
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 Shinnik Yaroslavl 0-0 FK Novosibirsk 6/-5 1,70 0.80/10 0.63/8 1.75/4 0.17/6   11/0 2,75 1.25/8 1.25/8 1.00/4 1.50/4
2012-09-10 FK Novosibirsk 1-3 Ural 11/0 2,44 1.22/9 1.00/8 1.00/4 1.40/5   23/14 2,91 1.73/11 1.75/8 2.33/6 1.00/5
2012-09-17 Yenisey 1-2 FK Novosibirsk 9/0 1,50 1.25/12 0.88/8 2.00/6 0.50/6   12/-2 2,60 1.10/10 0.88/8 0.80/5 1.40/5
2012-09-21 FK Novosibirsk 1-0 FC Novokuznetsk 14/-1 2,64 1.27/11 1.25/8 0.80/5 1.67/6   9/-7 1,92 0.85/13 0.75/8 1.38/8 0.00/5
2012-10-01 SKA Khabarovsk 1-2 FK Novosibirsk 15/7 1,64 1.79/14 2.00/8 2.43/7 1.14/7   15/0 2,50 1.42/12 1.63/8 1.17/6 1.67/6
2012-10-08 FK Novosibirsk 0-0 Spartak Nalchik 17/1 2,54 1.54/13 1.63/8 1.17/6 1.86/7   15/2 2,00 1.86/14 1.75/8 2.11/9 1.40/5
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-15 T. Moscow 1-1 FK Novosibirsk 9/-6 1,71 1.07/14 1.25/8 1.57/7 0.57/7   18/1 2,33 1.47/15 1.63/8 1.14/7 1.75/8
2012-10-22 FK Novosibirsk 1-0 Volgar-Astrakhan 19/1 2,31 1.44/16 1.63/8 1.14/7 1.67/9   11/-5 1,69 1.06/16 1.13/8 1.44/9 0.57/7
2012-10-26 R. Volgograd 2-0 FK Novosibirsk 13/1 1,47 1.53/17 1.50/8 2.00/9 1.00/8   20/2 2,24 1.53/17 1.88/8 1.38/8 1.67/9
2012-10-31 FK Novosibirsk 0-2 Tomsk 20/0 2,22 1.44/18 1.88/8 1.38/8 1.50/10   36/16 3,11 2.33/18 2.38/8 2.60/10 2.00/8
2012-11-06 FK Novosibirsk 2-0 Dynamo Petersburg 20/-2 2,21 1.37/19 1.50/8 1.22/9 1.50/10   17/-8 2,47 1.00/17 0.75/8 1.50/6 0.73/11
2012-11-12 Khimki 0-0 FK Novosibirsk 16/-15 2,61 0.50/18 0.50/8 0.13/8 0.80/10   22/0 2,20 1.45/20 1.50/8 1.40/10 1.50/10
2012-11-20 FK Novosibirsk 3-1 Baltika 22/0 2,10 1.43/21 1.25/8 1.40/10 1.45/11   23/1 2,14 1.57/21 1.88/8 1.40/10 1.73/11
2013-03-11 Ufa 1-1 FK Novosibirsk 27/3 2,22 1.52/23 1.50/8 1.80/10 1.31/13   25/2 2,18 1.50/22 1.50/8 1.55/11 1.45/11
2013-03-18 FK Novosibirsk - Vladimir / /0 / / /   / /0 / / /
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 FK Novosibirsk 2-2 Shinnik Yaroslavl 27/3 2,13 1.54/24 1.75/8 1.55/11 1.54/13   25/-7 2,19 1.12/26 1.88/8 1.83/12 0.50/14
2013-04-08 Ural 5-2 FK Novosibirsk 57/41 2,70 2.26/27 2.50/8 2.43/14 2.08/13   29/3 2,20 1.52/25 1.50/8 1.50/12 1.54/13
2013-04-13 FK Novosibirsk 0-3 Yenisey 31/0 2,38 1.46/26 1.50/8 1.50/12 1.43/14   23/-1 1,68 1.18/28 1.38/8 1.21/14 1.14/14
2013-04-23 FC Novokuznetsk 1-0 FK Novosibirsk 17/-18 1,79 0.93/29 1.13/8 1.67/15 0.14/14   31/-3 2,41 1.41/27 1.50/8 1.38/13 1.43/14
2013-04-30 FK Novosibirsk 1-0 SKA Khabarovsk 31/-4 2,36 1.36/28 1.13/8 1.38/13 1.33/15   30/7 1,83 1.66/29 1.75/8 1.79/14 1.53/15
2013-05-06 Spartak Nalchik 2-0 FK Novosibirsk 30/4 1,87 1.70/30 2.00/8 2.13/15 1.27/15   32/-3 2,31 1.41/29 1.38/8 1.50/14 1.33/15
2013-05-14 FK Novosibirsk 1-1 T. Moscow 32/-5 2,30 1.37/30 1.00/8 1.50/14 1.25/16   27/-7 2,10 1.07/29 1.25/8 1.20/15 0.93/14
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 Volgar-Astrakhan 0-1 FK Novosibirsk 19/-18 1,75 0.75/32 0.50/8 1.13/16 0.38/16   34/-5 2,28 1.34/32 0.75/8 1.44/16 1.25/16
2013-05-25 FK Novosibirsk 1-1 Energomash Belgorod 35/-4 2,24 1.39/33 1.00/8 1.44/16 1.35/17   26/-5 1,73 1.15/33 1.88/8 1.12/17 1.19/16