SELECT * FROM 1_Kampe WHERE LigaID = '227' 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
2018-10-21 Brann 1-3 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
2018-10-21 Haugesund 1-3 Start 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0
2018-10-21 Haugesund 1-3 Mjondalen 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1
2018-10-21 Sandefjord 1-3 Haugesund 7/2 4,00 2.00/3 1.50/8 0.00/1 3.00/2   5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1
2018-10-21 Haugesund 1-3 Kristiansund 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2
2018-10-21 Bodo/Glimt 1-3 Haugesund 11/2 4,00 1.80/5 1.50/8 0.00/2 3.00/3   9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2
2018-10-21 Haugesund 1-3 Rosenborg 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   11/2 4,00 1.80/5 1.71/7 0.00/2 3.00/3
2018-10-21 Aalesund 1-3 Haugesund 12/0 4,00 1.50/6 1.29/7 0.00/3 3.00/3   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2020-06-17 Haugesund 1-2 Brann 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   13/-2 4,00 1.29/7 1.29/7 0.00/4 3.00/3
2020-06-21 Bodo/Glimt 6-1 Haugesund 20/2 4,22 1.67/9 1.88/8 0.00/4 3.00/5   17/-1 3,89 1.33/9 1.13/8 0.00/5 3.00/4
2020-06-24 Haugesund 2-2 Kristiansund 18/-6 4,20 1.20/10 0.75/8 0.00/5 2.40/5   23/5 4,10 1.60/10 1.63/8 0.60/5 2.60/5
2020-06-28 Sandefjord 0-1 Haugesund 20/-1 3,73 1.45/11 1.63/8 0.20/5 2.50/6   20/-6 4,18 1.18/11 0.88/8 0.17/6 2.40/5
2020-07-01 Haugesund 1-0 Start 21/-5 3,92 1.33/12 0.88/8 0.17/6 2.50/6   22/-6 4,17 1.17/12 0.63/8 0.14/7 2.60/5
2020-07-05 Odd 0-0 Haugesund 26/2 3,85 1.38/13 1.13/8 0.43/7 2.50/6   22/-4 3,69 1.46/13 1.25/8 0.57/7 2.50/6
2020-07-11 Haugesund 0-3 Molde 22/-4 3,43 1.43/14 1.38/8 0.57/7 2.29/7   32/9 3,93 2.00/14 2.38/8 1.29/7 2.71/7
2020-07-15 Valerenga 1-0 Haugesund 20/-4 3,38 1.38/13 1.50/8 0.71/7 2.17/6   22/-7 3,40 1.33/15 1.38/8 0.50/8 2.29/7
2020-07-18 Haugesund 0-2 Viking 22/-8 3,25 1.25/16 1.00/8 0.50/8 2.00/8   24/-10 3,63 1.06/16 0.63/8 0.50/8 1.63/8
2020-07-26 Haugesund 1-0 Rosenborg 22/-10 3,18 1.18/17 1.00/8 0.44/9 2.00/8   28/8 3,00 1.69/16 1.75/8 1.00/8 2.38/8
2020-07-29 Sarpsborg 08 0-0 Haugesund 27/4 2,94 1.47/17 1.25/8 0.86/7 1.90/10   23/-9 3,06 1.28/18 1.38/8 0.70/10 2.00/8
2020-08-02 Haugesund 3-1 Stabaek 23/-9 2,89 1.26/19 1.38/8 0.70/10 1.89/9   31/1 3,21 1.53/19 1.50/8 0.90/10 2.22/9
2020-08-09 Mjondalen 1-0 Haugesund 26/-8 3,00 1.00/20 0.38/8 0.33/9 1.55/11   26/-7 2,95 1.35/20 1.38/8 0.91/11 1.89/9
2020-08-16 Haugesund 2-3 Stromsgodset 26/-8 2,86 1.29/21 1.00/8 0.91/11 1.70/10   35/-8 3,71 1.29/21 0.88/8 1.00/11 1.60/10
2020-08-22 Aalesund 1-3 Haugesund 33/-25 4,33 0.76/21 0.50/8 0.45/11 1.10/10   28/-9 2,95 1.23/22 0.88/8 0.83/12 1.70/10
2020-08-29 Haugesund 2-1 Valerenga 31/-7 3,00 1.30/23 1.25/8 0.83/12 1.82/11   31/-3 3,10 1.52/21 1.75/8 1.36/11 1.70/10
2020-09-12 Stabaek 2-1 Haugesund 37/-4 3,25 1.29/24 0.88/8 0.75/12 1.83/12   33/-6 3,00 1.38/24 1.63/8 1.00/13 1.82/11
2020-09-20 Rosenborg 2-1 Haugesund 47/16 3,25 1.71/24 1.75/8 1.50/12 1.92/12   34/-7 3,00 1.32/25 1.63/8 1.00/13 1.67/12
2020-09-27 Haugesund 4-4 Odd 35/-8 3,00 1.27/26 1.25/8 1.00/13 1.54/13   48/8 3,38 1.77/26 2.25/8 1.57/14 2.00/12
2020-10-04 Start 5-1 Haugesund 35/-19 3,30 1.00/27 1.13/8 0.93/14 1.08/13   39/-8 3,19 1.26/27 1.25/8 1.00/14 1.54/13
2020-10-18 Haugesund 2-0 Sarpsborg 08 40/-12 3,29 1.21/28 0.88/8 1.00/14 1.43/14   42/6 2,89 1.56/27 1.63/8 1.46/13 1.64/14
2020-10-27 Viking 0-1 Haugesund 54/0 3,86 1.46/28 2.25/8 1.07/14 1.86/14   42/-10 3,24 1.28/29 1.25/8 1.13/15 1.43/14
2020-10-31 Haugesund 0-1 Aalesund 43/-9 3,17 1.33/30 1.63/8 1.13/15 1.53/15   38/-41 4,03 0.55/29 0.00/8 0.31/16 0.85/13
2020-11-07 Brann 1-2 Haugesund 42/-12 3,20 1.13/30 0.50/8 0.67/15 1.60/15   43/-10 3,10 1.29/31 1.25/8 1.06/16 1.53/15
2020-11-22 Haugesund 3-2 Sandefjord 45/-9 3,09 1.34/32 1.25/8 1.06/16 1.63/16   41/-12 2,94 1.25/32 1.50/8 0.81/16 1.69/16
2020-11-29 Molde 3-1 Haugesund 78/32 3,76 1.88/33 2.00/8 1.75/16 2.00/17   48/-8 3,15 1.39/33 1.63/8 1.18/17 1.63/16
2020-12-02 Haugesund 1-1 Mjondalen 49/-10 3,18 1.35/34 1.63/8 1.18/17 1.53/17   37/-22 2,82 0.94/34 0.75/8 0.71/17 1.18/17
2020-12-06 Stromsgodset 2-2 Haugesund 48/-17 3,32 1.06/34 0.38/8 0.82/17 1.29/17   50/-10 3,14 1.34/35 1.63/8 1.17/18 1.53/17
2020-12-09 Haugesund 0-4 Bodo/Glimt 52/-10 3,17 1.33/36 1.75/8 1.17/18 1.50/18   112/64 4,44 2.42/36 2.38/8 2.33/18 2.50/18
2020-12-22 Kristiansund 1-3 Haugesund 72/14 3,51 1.62/37 1.63/8 1.39/18 1.84/19   52/-14 3,19 1.30/37 1.38/8 1.11/19 1.50/18