SELECT * FROM 1_Kampe WHERE LigaID = '234' AND (Home='Odd' OR Away='Odd') 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
2013-03-17 Odd 0-1 Rosenborg 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
2013-04-01 Tromso 2-1 Odd 2/0 4,00 1.00/1 1.00/1 0.00/0 1.00/1   0/-1 1,00 0.00/1 0.00/1 0.00/1 0.00/0
2013-04-05 Odd 2-0 Valerenga 1/-2 2,00 0.00/2 0.00/2 0.00/1 0.00/1   2/-1 2,50 1.50/2 1.50/2 3.00/1 0.00/1
2013-04-14 Viking 1-0 Odd 4/1 2,33 2.00/3 2.00/3 3.00/1 1.50/2   3/0 2,00 1.00/3 1.00/3 1.50/2 0.00/1
2013-04-20 Odd 1-1 Molde 3/-1 1,75 0.75/4 0.75/4 1.50/2 0.00/2   3/-4 2,50 0.00/4 0.00/4 0.00/2 0.00/2
2013-04-26 Brann 2-0 Odd 6/-1 2,60 1.80/5 1.80/5 3.00/3 0.00/2   4/-1 1,80 0.80/5 0.80/5 1.33/3 0.00/2
2013-05-05 Odd 2-1 Lillestrom 4/-3 1,83 0.67/6 0.67/6 1.33/3 0.00/3   9/2 2,67 1.67/6 1.67/6 1.75/4 1.50/2
2013-05-09 Odd 1-1 Stromsgodset 6/-2 2,00 1.00/7 1.00/7 1.75/4 0.00/3   12/7 2,43 2.29/7 2.29/7 2.50/4 2.00/3
2013-05-12 Sogndal 2-0 Odd 10/-5 3,13 1.13/8 1.13/8 1.25/4 1.00/4   7/-2 2,00 1.00/8 1.00/8 1.60/5 0.00/3
2013-05-16 Odd 0-1 Start 7/-4 2,00 0.89/9 1.00/8 1.60/5 0.00/4   13/-3 3,22 1.00/9 0.75/8 1.60/5 0.25/4
2013-05-20 Aalesund 2-0 Odd 21/7 3,50 1.70/10 1.38/8 2.20/5 1.20/5   7/-5 1,90 0.80/10 1.00/8 1.33/6 0.00/4
2013-05-26 Odd 3-0 Sandnes 7/-7 1,91 0.73/11 0.63/8 1.33/6 0.00/5   9/-4 2,00 0.91/11 1.13/8 0.50/6 1.40/5
2013-06-23 Honefoss 1-1 Odd 14/-4 2,67 1.08/12 1.25/8 1.40/5 0.86/7   10/-4 2,00 0.92/12 1.00/8 1.57/7 0.00/5
2013-06-30 Odd 4-0 Haugesund 11/-4 2,00 0.92/13 1.00/8 1.57/7 0.17/6   17/1 2,54 1.54/13 1.25/8 2.00/6 1.14/7
2013-07-07 Sarpsborg 08 0-1 Odd 19/-9 3,36 1.21/14 1.25/8 1.83/6 0.75/8   15/0 2,14 1.07/14 1.38/8 1.75/8 0.17/6
2013-07-14 Rosenborg 3-2 Odd 25/13 2,47 2.07/15 2.50/8 2.13/8 2.00/7   16/1 2,07 1.20/15 1.38/8 1.75/8 0.57/7
2013-07-28 Odd 3-1 Tromso 18/0 2,25 1.13/16 1.25/8 1.75/8 0.50/8   25/3 2,94 1.25/16 1.25/8 2.00/8 0.50/8
2013-08-03 Start 0-1 Odd 22/-14 3,41 0.88/17 0.75/8 1.25/8 0.56/9   21/2 2,35 1.24/17 1.63/8 1.89/9 0.50/8
2013-08-10 Odd 1-1 Viking 22/3 2,28 1.33/18 2.00/8 1.89/9 0.78/9   24/6 2,33 1.67/18 1.63/8 2.11/9 1.22/9
2013-08-17 Molde 1-1 Odd 29/2 2,95 1.26/19 2.13/8 1.44/9 1.10/10   23/3 2,26 1.32/19 2.13/8 1.80/10 0.78/9
2013-08-24 Odd 1-3 Brann 24/3 2,25 1.30/20 1.88/8 1.80/10 0.80/10   31/-1 3,15 1.35/20 0.75/8 2.50/10 0.20/10
2013-08-31 Lillestrom 1-0 Odd 26/-4 2,67 1.19/21 1.25/8 1.60/10 0.82/11   25/1 2,33 1.24/21 1.75/8 1.64/11 0.80/10
2013-09-15 Stromsgodset 3-1 Odd 49/26 3,27 1.95/22 1.38/8 2.64/11 1.27/11   25/0 2,27 1.18/22 1.38/8 1.64/11 0.73/11
2013-09-22 Odd 5-1 Aalesund 26/-2 2,35 1.13/23 1.00/8 1.64/11 0.67/12   47/12 3,57 1.65/23 1.63/8 1.83/12 1.45/11
2013-09-29 Valerenga 1-2 Odd 34/-8 3,17 1.25/24 1.13/8 1.50/12 1.00/12   31/2 2,50 1.21/24 1.38/8 1.75/12 0.67/12
2013-10-06 Odd 0-0 Sogndal 33/3 2,52 1.28/25 1.38/8 1.75/12 0.85/13   28/-12 2,72 1.16/25 0.75/8 1.17/12 1.15/13
2013-10-20 Sandnes 2-4 Odd 30/-19 3,04 1.15/26 1.38/8 1.23/13 1.08/13   33/3 2,42 1.27/26 1.13/8 1.69/13 0.85/13
2013-10-27 Odd 2-2 Sarpsborg 08 37/5 2,56 1.33/27 1.38/8 1.69/13 1.00/14   36/-18 3,33 1.00/27 1.25/8 1.43/14 0.54/13
2013-11-03 Haugesund 3-1 Odd 38/4 2,57 1.71/28 1.88/8 2.07/14 1.36/14   39/5 2,61 1.32/28 1.38/8 1.64/14 1.00/14
2013-11-10 Odd 3-2 Honefoss 40/3 2,66 1.28/29 1.38/8 1.64/14 0.93/15   32/-12 2,62 1.00/29 1.25/8 1.07/15 0.93/14