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
2020-04-05 Aalesund - Haugesund / /0 / / /   / /0 / / /
2020-04-13 Haugesund - Rosenborg / /0 / / /   / /0 / / /
2020-04-19 Bodo/Glimt - Haugesund / /0 / / /   / /0 / / /
2020-04-26 Haugesund - Kristiansund / /0 / / /   / /0 / / /
2020-04-29 Sandefjord - Haugesund / /0 / / /   / /0 / / /
2020-05-03 Haugesund - Mjondalen / /0 / / /   / /0 / / /
2020-05-10 Haugesund - Start / /0 / / /   / /0 / / /
2020-05-16 Brann - Haugesund / /0 / / /   / /0 / / /
2020-06-17 Haugesund 1-2 Brann 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
2020-06-21 Bodo/Glimt 6-1 Haugesund 4/2 6,00 3.00/1 3.00/1 0.00/0 3.00/1   1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2020-06-24 Haugesund 2-2 Kristiansund 2/-6 5,00 0.00/2 0.00/2 0.00/1 0.00/1   7/5 4,50 2.00/2 2.00/2 3.00/1 1.00/1
2020-06-28 Sandefjord 0-1 Haugesund 4/-1 3,00 1.33/3 1.33/3 1.00/1 1.50/2   4/-6 4,67 0.33/3 0.33/3 0.50/2 0.00/1
2020-07-01 Haugesund 1-0 Start 5/-5 3,75 1.00/4 1.00/4 0.50/2 1.50/2   6/-6 4,50 0.50/4 0.50/4 0.33/3 1.00/1
2020-07-05 Odd 0-0 Haugesund 10/2 3,60 1.20/5 1.20/5 1.00/3 1.50/2   6/-4 3,20 1.40/5 1.40/5 1.33/3 1.50/2
2020-07-11 Haugesund 0-3 Molde 6/-4 2,67 1.33/6 1.33/6 1.33/3 1.33/3   16/9 3,83 2.67/6 2.67/6 3.00/3 2.33/3
2020-07-15 Valerenga 1-0 Haugesund 10/0 2,86 1.71/7 1.71/7 1.67/3 1.75/4   6/-7 2,71 1.14/7 1.14/7 1.00/4 1.33/3
2020-07-18 Haugesund 0-2 Viking 6/-8 2,50 1.00/8 1.00/8 1.00/4 1.00/4   8/-10 3,25 0.63/8 0.63/8 1.00/4 0.25/4
2020-07-26 Haugesund 1-0 Rosenborg 6/-10 2,44 0.89/9 1.00/8 0.80/5 1.00/4   13/6 2,22 1.67/9 1.75/8 1.60/5 1.75/4
2020-07-29 Sarpsborg 08 0-0 Haugesund 10/-2 2,20 1.00/10 1.25/8 1.20/5 0.80/5   7/-9 2,30 1.10/10 1.38/8 1.17/6 1.00/4
2020-08-02 Haugesund 3-1 Stabaek 7/-9 2,09 1.09/11 1.38/8 1.17/6 1.00/5   15/1 2,64 1.55/11 1.50/8 1.50/6 1.60/5
2020-08-09 Mjondalen 1-0 Haugesund 10/-8 2,33 0.67/12 0.38/8 0.60/5 0.71/7   10/-7 2,25 1.25/12 1.38/8 1.43/7 1.00/5
2020-08-16 Haugesund 2-3 Stromsgodset 10/-8 2,15 1.15/13 1.00/8 1.43/7 0.83/6   19/-8 3,54 1.15/13 0.88/8 1.57/7 0.67/6
2020-08-22 Aalesund 1-3 Haugesund 20/-23 4,50 0.50/14 0.50/8 0.71/7 0.29/7   12/-9 2,36 1.07/14 0.88/8 1.25/8 0.83/6
2020-08-29 Haugesund 2-1 Valerenga 15/-7 2,47 1.20/15 1.25/8 1.25/8 1.14/7   21/1 2,73 1.73/15 1.75/8 2.14/7 1.38/8
2020-09-12 Stabaek 2-1 Haugesund 21/-4 2,88 1.19/16 0.88/8 1.13/8 1.25/8   17/-6 2,50 1.31/16 1.63/8 1.44/9 1.14/7
2020-09-20 Rosenborg 2-1 Haugesund 32/14 2,94 1.71/17 1.75/8 2.00/9 1.38/8   18/-7 2,53 1.24/17 1.63/8 1.44/9 1.00/8
2020-09-27 Haugesund 4-4 Odd 19/-8 2,56 1.17/18 1.25/8 1.44/9 0.89/9   32/8 3,11 1.89/18 2.25/8 2.20/10 1.50/8
2020-10-04 Start 5-1 Haugesund 19/-19 3,00 0.79/19 1.13/8 1.30/10 0.22/9   23/-8 2,84 1.16/19 1.25/8 1.40/10 0.89/9
2020-10-18 Haugesund 2-0 Sarpsborg 08 24/-12 3,00 1.10/20 0.88/8 1.40/10 0.80/10   25/0 2,50 1.35/20 1.63/8 1.73/11 0.89/9
2020-10-27 Viking 0-1 Haugesund 38/0 3,80 1.45/20 2.25/8 1.50/10 1.40/10   26/-10 2,95 1.19/21 1.25/8 1.55/11 0.80/10
2020-10-31 Haugesund 0-1 Aalesund 27/-9 2,86 1.27/22 1.63/8 1.55/11 1.00/11   25/-39 4,05 0.32/22 0.00/8 0.42/12 0.20/10
2020-11-07 Brann 1-2 Haugesund 29/-10 2,96 1.09/23 0.50/8 0.91/11 1.25/12   27/-10 2,78 1.22/23 1.25/8 1.42/12 1.00/11
2020-11-22 Haugesund 3-2 Sandefjord 29/-9 2,79 1.29/24 1.25/8 1.42/12 1.17/12   25/-12 2,58 1.17/24 1.50/8 1.08/12 1.25/12
2020-11-29 Molde 3-1 Haugesund 62/32 3,68 2.00/25 2.00/8 2.33/12 1.69/13   32/-8 2,88 1.36/25 1.63/8 1.54/13 1.17/12
2020-12-02 Haugesund 1-1 Mjondalen 33/-10 2,92 1.31/26 1.63/8 1.54/13 1.08/13   21/-22 2,46 0.77/26 0.75/8 0.92/13 0.62/13
2020-12-06 Stromsgodset 2-2 Haugesund 32/-17 3,12 0.92/26 0.38/8 1.08/13 0.77/13   34/-10 2,89 1.30/27 1.63/8 1.50/14 1.08/13
2020-12-09 Haugesund 0-4 Bodo/Glimt 36/-10 2,93 1.29/28 1.75/8 1.50/14 1.07/14   96/64 4,57 2.68/28 2.38/8 3.00/14 2.36/14
2020-12-22 Kristiansund 1-3 Haugesund 56/14 3,38 1.66/29 1.63/8 1.79/14 1.53/15   36/-14 2,97 1.24/29 1.38/8 1.40/15 1.07/14