SELECT * FROM 1_Kampe WHERE LigaID = '228' AND (Home='Haugesund' OR Away='Haugesund') 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
2019-03-31 Stromsgodset 3-2 Haugesund 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
2019-04-07 Haugesund 1-1 Sarpsborg 08 2/-1 5,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
2019-04-14 Ranheim 0-2 Haugesund 2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1   3/-1 3,50 0.50/2 0.50/2 1.00/1 0.00/1
2019-04-22 Haugesund 3-0 Stabaek 5/1 3,00 1.33/3 1.33/3 1.00/1 1.50/2   4/-1 3,00 1.33/3 1.33/3 2.00/2 0.00/1
2019-04-28 Lillestrom 1-0 Haugesund 3/-2 2,00 1.00/4 1.00/4 1.50/2 0.50/2   8/4 3,00 1.75/4 1.75/4 2.00/2 1.50/2
2019-05-05 Haugesund 1-2 Molde 8/3 2,60 1.40/5 1.40/5 2.00/2 1.00/3   15/10 3,33 2.17/6 2.17/6 3.00/3 1.33/3
2019-05-12 Haugesund 1-1 Bodo/Glimt 9/2 2,67 1.17/6 1.17/6 1.33/3 1.00/3   15/6 4,00 2.17/6 2.17/6 2.50/4 1.50/2
2019-05-16 Rosenborg 0-2 Haugesund 4/-6 2,00 0.86/7 0.86/7 1.67/3 0.25/4   10/2 2,57 1.14/7 1.14/7 1.25/4 1.00/3
2019-05-19 Haugesund 0-0 Kristiansund 12/4 2,50 1.38/8 1.38/8 1.25/4 1.50/4   11/1 2,33 1.78/9 2.00/8 2.50/4 1.20/5
2019-05-26 Mjondalen 1-4 Haugesund 14/-3 3,44 1.00/9 1.13/8 1.25/4 0.80/5   12/4 2,22 1.33/9 1.50/8 1.20/5 1.50/4
2019-06-15 Haugesund 1-1 Brann 16/7 2,50 1.50/10 1.75/8 1.20/5 1.80/5   14/1 2,45 1.55/11 1.63/8 1.33/6 1.80/5
2019-06-23 Odd 3-1 Haugesund 15/7 2,30 2.20/10 2.25/8 3.00/5 1.40/5   17/7 2,45 1.45/11 1.50/8 1.17/6 1.80/5
2019-06-30 Haugesund 1-4 Valerenga 18/5 2,58 1.33/12 1.13/8 1.17/6 1.50/6   18/1 2,92 1.50/12 1.50/8 2.17/6 0.83/6
2019-07-05 Viking 0-0 Haugesund 19/1 3,08 1.50/12 1.13/8 2.00/5 1.14/7   19/2 2,77 1.23/13 1.13/8 1.00/7 1.50/6
2019-07-14 Haugesund 5-1 Tromso 19/2 2,57 1.21/14 1.25/8 1.00/7 1.43/7   14/-9 2,64 1.14/14 1.50/8 1.29/7 1.00/7
2019-08-04 Stabaek 1-1 Haugesund 14/-7 2,33 1.00/15 1.00/8 1.29/7 0.75/8   24/6 2,80 1.33/15 1.50/8 1.25/8 1.43/7
2019-08-11 Haugesund 0-1 Ranheim 25/6 2,75 1.31/16 1.25/8 1.25/8 1.38/8   17/-12 2,88 0.94/16 1.00/8 0.88/8 1.00/8
2019-08-18 Valerenga 1-2 Haugesund 32/9 3,24 1.53/17 1.13/8 2.13/8 1.00/9   25/5 2,65 1.24/17 1.13/8 1.11/9 1.38/8
2019-08-25 Haugesund 0-2 Lillestrom 27/6 2,67 1.33/18 1.13/8 1.11/9 1.56/9   23/-6 2,89 1.22/18 1.25/8 1.78/9 0.67/9
2019-09-01 Tromso 2-2 Haugesund 23/-15 3,21 1.11/19 1.38/8 1.22/9 1.00/10   27/4 2,63 1.26/19 1.00/8 1.00/10 1.56/9
2019-09-15 Haugesund 0-0 Mjondalen 29/4 2,70 1.25/20 1.13/8 1.00/10 1.50/10   27/-10 3,20 1.00/20 1.13/8 1.30/10 0.70/10
2019-09-21 Brann 0-0 Haugesund 28/5 2,43 1.52/21 1.38/8 1.50/10 1.55/11   29/4 2,57 1.24/21 1.25/8 1.00/11 1.50/10
2019-09-29 Kristiansund 2-2 Haugesund 28/5 2,32 1.50/22 1.50/8 2.00/10 1.08/12   29/4 2,45 1.23/22 1.25/8 1.00/11 1.45/11
2019-10-06 Haugesund 2-1 Rosenborg 31/4 2,52 1.22/23 1.00/8 1.00/11 1.42/12   36/9 2,74 1.74/23 2.00/8 2.25/12 1.18/11
2019-10-20 Molde 3-1 Haugesund 54/31 3,21 2.21/24 2.50/8 2.64/11 1.85/13   33/5 2,54 1.29/24 1.25/8 1.17/12 1.42/12
2019-10-27 Haugesund 2-2 Stromsgodset 34/3 2,60 1.24/25 1.25/8 1.17/12 1.31/13   28/-16 2,88 0.96/25 1.38/8 1.31/13 0.58/12
2019-11-03 Bodo/Glimt 2-2 Haugesund 55/20 3,46 1.92/26 1.38/8 2.31/13 1.54/13   36/3 2,65 1.23/26 1.00/8 1.15/13 1.31/13
2019-11-09 Haugesund 1-0 Viking 38/3 2,70 1.22/27 1.13/8 1.15/13 1.29/14   48/10 3,19 1.59/27 2.13/8 2.14/14 1.00/13
2019-11-24 Sarpsborg 08 1-1 Haugesund 29/-10 2,43 1.00/28 1.50/8 1.43/14 0.57/14   39/4 2,64 1.29/28 1.38/8 1.29/14 1.29/14
2019-12-01 Haugesund 4-1 Odd 40/4 2,62 1.28/29 1.38/8 1.29/14 1.27/15   44/8 2,76 1.79/29 1.75/8 2.60/15 0.93/14