SELECT * FROM 1_Kampe WHERE LigaID = '234' 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
2013-03-16 Aalesund 3-0 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
2013-04-07 Sandnes 1-1 Haugesund 0/-3 1,50 0.00/2 0.00/2 0.00/1 0.00/1   0/-3 3,00 0.00/1 0.00/1 0.00/0 0.00/1
2013-04-14 Honefoss 0-1 Haugesund 7/0 4,67 1.00/3 1.00/3 3.00/1 0.00/2   1/-3 2,50 0.50/2 0.50/2 0.00/0 0.50/2
2013-04-21 Haugesund 3-1 Rosenborg 2/-2 2,00 1.33/3 1.33/3 0.00/0 1.33/3   10/9 2,75 2.50/4 2.50/4 2.00/2 3.00/2
2013-04-24 Haugesund 3-2 Start 5/0 2,50 1.75/4 1.75/4 3.00/1 1.33/3   7/2 3,00 2.00/4 2.00/4 2.33/3 1.00/1
2013-04-28 Tromso 2-1 Haugesund 6/0 2,40 1.20/5 1.20/5 1.50/2 1.00/3   8/1 3,00 2.00/5 2.00/5 3.00/2 1.33/3
2013-05-05 Haugesund 0-1 Sarpsborg 08 9/0 3,00 1.67/6 1.67/6 3.00/2 1.00/4   6/-1 2,17 1.17/6 1.17/6 1.33/3 1.00/3
2013-05-09 Viking 0-0 Haugesund 10/1 2,71 1.71/7 1.71/7 3.00/3 0.75/4   9/-1 2,71 1.43/7 1.43/7 2.00/3 1.00/4
2013-05-12 Haugesund 1-0 Valerenga 9/-1 2,38 1.38/8 1.38/8 2.00/3 1.00/5   7/-6 2,50 1.13/8 1.13/8 1.50/4 0.75/4
2013-05-16 Molde 1-5 Haugesund 10/-2 2,44 0.67/9 0.75/8 0.75/4 0.60/5   10/0 2,22 1.56/9 1.75/8 2.25/4 1.00/5
2013-05-20 Haugesund 0-1 Sogndal 15/4 2,60 1.70/10 2.00/8 2.25/4 1.33/6   13/-5 3,10 1.20/10 1.38/8 1.60/5 0.80/5
2013-05-26 Lillestrom 3-0 Haugesund 15/-6 3,27 1.09/11 1.00/8 1.50/6 0.60/5   15/3 2,45 1.55/11 1.63/8 1.80/5 1.33/6
2013-06-23 Haugesund 2-1 Brann 15/0 2,50 1.42/12 1.25/8 1.80/5 1.14/7   16/1 2,58 1.75/12 1.88/8 3.00/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-06 Haugesund 2-1 Stromsgodset 17/-3 2,64 1.43/14 1.25/8 2.00/6 1.00/8   29/19 2,79 2.29/14 2.38/8 2.75/8 1.67/6
2013-07-14 Haugesund 1-2 Aalesund 19/-2 2,67 1.53/15 1.63/8 2.14/7 1.00/8   30/9 3,40 1.67/15 1.38/8 2.25/8 1.00/7
2013-07-28 Sogndal 1-1 Haugesund 23/-2 3,00 1.38/16 1.63/8 1.43/7 1.33/9   20/-3 2,69 1.44/16 1.50/8 1.88/8 1.00/8
2013-08-04 Haugesund 3-1 Sandnes 21/-3 2,65 1.41/17 1.25/8 1.88/8 1.00/9   19/-10 2,82 1.12/17 1.25/8 1.00/9 1.25/8
2013-08-11 Haugesund 1-0 Honefoss 24/-1 2,72 1.50/18 1.25/8 2.00/9 1.00/9   21/-13 3,06 0.89/18 0.75/8 1.00/9 0.78/9
2013-08-18 Start 1-2 Haugesund 25/-13 3,32 0.95/19 0.75/8 1.11/9 0.80/10   25/0 2,63 1.58/19 1.63/8 2.10/10 1.00/9
2013-08-25 Haugesund 1-0 Tromso 27/1 2,65 1.65/20 2.00/8 2.10/10 1.20/10   30/-1 3,05 1.05/20 0.63/8 1.70/10 0.40/10
2013-09-01 Sarpsborg 08 2-1 Haugesund 26/-20 3,43 0.81/21 0.00/8 1.10/10 0.55/11   28/2 2,57 1.71/21 2.00/8 2.18/11 1.20/10
2013-09-14 Haugesund 1-1 Viking 29/1 2,59 1.64/22 2.00/8 2.18/11 1.09/11   29/7 2,32 1.68/22 1.63/8 2.27/11 1.09/11
2013-09-20 Rosenborg 1-1 Haugesund 41/20 2,70 2.09/23 2.13/8 2.25/12 1.91/11   30/1 2,57 1.61/23 1.75/8 2.08/12 1.09/11
2013-09-29 Haugesund 1-1 Molde 31/1 2,54 1.58/24 1.88/8 2.08/12 1.08/12   43/8 3,25 1.42/24 2.00/8 1.67/12 1.17/12
2013-10-04 Brann 0-1 Haugesund 39/1 3,08 1.40/25 1.13/8 2.42/12 0.46/13   32/1 2,52 1.56/25 1.88/8 2.00/13 1.08/12
2013-10-20 Haugesund 3-2 Lillestrom 33/2 2,46 1.62/26 1.88/8 2.00/13 1.23/13   32/-3 2,58 1.27/26 1.38/8 1.54/13 1.00/13
2013-10-26 Valerenga 1-2 Haugesund 38/-9 3,15 1.22/27 1.00/8 1.38/13 1.07/14   36/3 2,56 1.67/27 1.88/8 2.07/14 1.23/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 Stromsgodset 4-0 Haugesund 62/36 3,03 2.07/29 2.13/8 2.71/14 1.47/15   41/6 2,62 1.76/29 1.88/8 2.13/15 1.36/14