SELECT * FROM 1_Kampe WHERE LigaID = '195' AND (Home='Odense' OR Away='Odense') 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
2010-07-17 Odense 3-0 Esbjerg 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
2010-07-26 Odense 1-1 Randers FC 3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0   3/1 5,00 3.00/1 3.00/1 3.00/1 0.00/0
2010-08-02 Horsens 1-0 Odense 0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1   4/3 2,50 2.00/2 2.00/2 2.00/2 0.00/0
2010-08-08 Odense 2-3 FC Copenhagen 4/2 2,00 1.33/3 1.33/3 2.00/2 0.00/1   6/3 3,00 2.33/3 2.33/3 1.00/1 3.00/2
2010-08-14 Sonderjyske 1-3 Odense 6/1 2,75 1.50/4 1.50/4 1.50/2 1.50/2   6/1 2,75 1.00/4 1.00/4 1.33/3 0.00/1
2010-08-22 Brondby 2-2 Odense 9/4 2,80 2.00/5 2.00/5 2.00/2 2.00/3   9/3 3,00 1.40/5 1.40/5 1.33/3 1.50/2
2010-08-30 Odense 2-1 Midtjylland 11/3 3,17 1.33/6 1.33/6 1.33/3 1.33/3   13/11 2,50 2.50/6 2.50/6 3.00/3 2.00/3
2010-09-11 Odense 0-1 Nordsjaelland 13/4 3,14 1.57/7 1.57/7 1.75/4 1.33/3   8/-4 2,86 1.00/7 1.00/7 1.00/4 1.00/3
2010-09-19 Silkeborg 3-1 Odense 8/-7 2,88 0.50/8 0.50/8 0.67/3 0.40/5   13/3 2,88 1.38/8 1.38/8 1.40/5 1.33/3
2010-09-27 Odense 3-1 Lyngby 14/1 3,00 1.22/9 1.00/8 1.40/5 1.00/4   15/-1 3,44 1.56/9 1.75/8 2.00/5 1.00/4
2010-10-04 Aalborg 1-2 Odense 11/-5 2,70 0.90/10 0.75/8 0.20/5 1.60/5   17/3 3,10 1.40/10 1.25/8 1.67/6 1.00/4
2010-10-17 FC Copenhagen 5-0 Odense 24/16 2,91 2.64/11 2.75/8 2.33/6 3.00/5   19/4 3,09 1.55/11 1.63/8 1.67/6 1.40/5
2010-10-25 Odense 1-2 Sonderjyske 19/-1 3,25 1.42/12 1.63/8 1.67/6 1.17/6   14/-2 2,50 1.33/12 1.25/8 1.50/6 1.17/6
2010-11-01 Nordsjaelland 1-4 Odense 14/-4 2,46 1.15/13 1.13/8 1.33/6 1.00/7   20/-2 3,23 1.31/13 1.25/8 1.43/7 1.17/6
2010-11-08 Odense 1-0 Randers FC 24/1 3,36 1.43/14 1.50/8 1.43/7 1.43/7   14/-3 2,21 1.00/14 0.63/8 1.29/7 0.71/7
2010-11-13 Esbjerg 1-2 Odense 19/-6 2,93 1.00/15 1.00/8 0.71/7 1.25/8   25/2 3,20 1.53/15 1.50/8 1.63/8 1.43/7
2010-11-22 Odense 3-2 Midtjylland 27/3 3,19 1.63/16 1.88/8 1.63/8 1.63/8   27/10 2,75 1.63/16 1.25/8 1.50/8 1.75/8
2010-11-28 Brondby 2-0 Odense 27/3 3,00 1.53/17 1.38/8 1.50/8 1.56/9   30/4 3,29 1.71/17 2.25/8 1.78/9 1.63/8
2010-12-04 Odense 6-0 Aalborg 30/2 3,22 1.61/18 1.88/8 1.78/9 1.44/9   18/-6 2,33 0.89/18 0.88/8 0.56/9 1.22/9
2011-03-07 Horsens 2-1 Odense 17/-9 2,26 1.26/19 1.38/8 1.00/9 1.50/10   36/8 3,37 1.68/19 1.88/8 1.90/10 1.44/9
2011-03-14 Odense 2-0 Lyngby 37/7 3,35 1.60/20 1.88/8 1.90/10 1.30/10   27/-5 3,11 1.26/19 0.88/8 1.67/9 0.90/10
2011-03-19 Silkeborg 1-1 Odense 27/-6 2,86 1.24/21 1.50/8 1.60/10 0.91/11   39/9 3,29 1.67/21 2.25/8 2.00/11 1.30/10
2011-04-02 Aalborg 0-1 Odense 21/-12 2,45 0.91/22 0.88/8 0.55/11 1.27/11   40/9 3,23 1.64/22 2.00/8 2.00/11 1.27/11
2011-04-10 Odense 1-1 Brondby 41/10 3,13 1.70/23 2.00/8 2.00/11 1.42/12   37/5 3,00 1.52/23 1.50/8 1.67/12 1.36/11
2011-04-18 Midtjylland 1-1 Odense 40/9 2,96 1.42/24 1.00/8 1.67/12 1.17/12   42/10 3,08 1.67/24 1.75/8 1.92/12 1.42/12
2011-04-21 Odense 1-2 Nordsjaelland 43/10 3,04 1.64/25 1.50/8 1.92/12 1.38/13   27/-12 2,64 1.08/25 1.13/8 1.25/12 0.92/13
2011-04-25 Sonderjyske 0-2 Odense 26/-9 2,35 1.15/26 1.13/8 1.17/12 1.14/14   44/9 3,04 1.58/26 1.50/8 1.77/13 1.38/13
2011-05-02 Odense 1-0 Esbjerg 46/11 3,00 1.63/27 1.50/8 1.77/13 1.50/14   29/-14 2,67 0.93/27 1.00/8 0.57/14 1.31/13
2011-05-08 Odense 0-0 Silkeborg 47/12 2,93 1.68/28 1.88/8 1.86/14 1.50/14   35/-6 2,71 1.29/28 1.63/8 1.71/14 0.86/14
2011-05-14 Randers FC 1-2 Odense 35/-5 2,59 1.10/29 0.88/8 1.43/14 0.80/15   47/12 2,83 1.66/29 1.63/8 1.80/15 1.50/14
2011-05-19 Odense 3-3 Horsens 49/13 2,83 1.70/30 1.88/8 1.80/15 1.60/15   24/-9 1,90 1.20/30 1.00/8 1.27/15 1.13/15
2011-05-25 Odense 3-0 FC Copenhagen 52/13 2,94 1.68/31 1.63/8 1.75/16 1.60/15   75/49 3,26 2.52/31 2.50/8 2.75/16 2.27/15
2011-05-29 Lyngby 2-0 Odense 40/-12 2,88 1.09/32 0.88/8 1.40/15 0.82/17   55/16 2,94 1.72/32 1.88/8 1.82/17 1.60/15