SELECT * FROM 1_Kampe WHERE LigaID = '234' AND (Home='Aalesund' OR Away='Aalesund') 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-01 Sandnes 0-1 Aalesund 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   3/3 3,00 3.00/1 3.00/1 3.00/1 0.00/0
2013-04-07 Aalesund 4-3 Honefoss 4/4 2,00 3.00/2 3.00/2 3.00/1 3.00/1   4/1 3,50 1.50/2 1.50/2 3.00/1 0.00/1
2013-04-14 Sarpsborg 08 0-2 Aalesund 5/1 3,00 1.67/3 1.67/3 3.00/1 1.00/2   8/5 3,67 3.00/3 3.00/3 3.00/2 3.00/1
2013-04-21 Aalesund 0-0 Tromso 10/7 3,25 3.00/4 3.00/4 3.00/2 3.00/2   6/0 3,00 1.25/4 1.25/4 1.50/2 1.00/2
2013-04-27 Valerenga 2-1 Aalesund 2/-7 2,20 0.60/5 0.60/5 1.50/2 0.00/3   10/7 2,60 2.60/5 2.60/5 2.33/3 3.00/2
2013-05-04 Aalesund 2-2 Rosenborg 11/6 2,67 2.17/6 2.17/6 2.33/3 2.00/3   11/6 2,67 1.67/6 1.67/6 1.33/3 2.00/3
2013-05-09 Molde 4-1 Aalesund 6/-5 2,43 0.29/7 0.29/7 0.00/3 0.50/4   13/6 2,86 2.00/7 2.00/7 2.00/4 2.00/3
2013-05-13 Aalesund 7-1 Lillestrom 14/3 3,13 1.75/8 1.75/8 2.00/4 1.50/4   12/1 2,88 1.38/8 1.38/8 1.60/5 1.00/3
2013-05-16 Brann 2-0 Aalesund 11/-1 2,56 1.67/9 1.50/8 3.00/5 0.00/4   21/9 3,67 1.89/9 1.75/8 2.20/5 1.50/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-24 Stromsgodset 2-1 Aalesund 24/17 2,82 2.36/11 2.75/8 2.67/6 2.00/5   23/9 3,36 1.82/11 1.38/8 2.33/6 1.20/5
2013-06-23 Aalesund 2-1 Viking 24/8 3,33 1.67/12 1.00/8 2.33/6 1.00/6   15/4 2,17 1.92/12 1.75/8 2.33/6 1.50/6
2013-06-30 Start 2-2 Aalesund 16/-9 3,15 1.00/13 0.63/8 1.33/6 0.71/7   26/9 3,31 1.77/13 1.25/8 2.43/7 1.00/6
2013-07-06 Aalesund 2-2 Sogndal 28/9 3,36 1.71/14 1.38/8 2.43/7 1.00/7   19/-2 2,86 1.43/14 1.88/8 1.43/7 1.43/7
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-27 Aalesund 2-3 Sandnes 32/10 3,38 1.75/16 1.75/8 2.25/8 1.25/8   16/-11 2,69 1.00/16 1.00/8 1.00/9 1.00/7
2013-08-04 Honefoss 2-5 Aalesund 19/-10 2,82 0.94/17 0.88/8 1.13/8 0.78/9   34/9 3,47 1.65/17 1.38/8 2.00/9 1.25/8
2013-08-11 Aalesund 3-1 Sarpsborg 08 39/12 3,67 1.72/18 1.75/8 2.00/9 1.44/9   24/-15 3,50 0.94/18 0.50/8 1.22/9 0.67/9
2013-08-18 Tromso 1-2 Aalesund 29/0 3,05 1.11/19 0.63/8 1.89/9 0.40/10   42/14 3,68 1.79/19 1.75/8 2.10/10 1.44/9
2013-08-25 Aalesund 1-1 Start 44/15 3,65 1.85/20 2.13/8 2.10/10 1.60/10   26/-14 3,30 0.90/20 0.63/8 1.00/10 0.80/10
2013-08-31 Rosenborg 2-1 Aalesund 39/20 2,76 2.14/21 2.25/8 2.18/11 2.10/10   45/15 3,57 1.81/21 1.88/8 2.00/11 1.60/10
2013-09-13 Aalesund 1-3 Molde 46/14 3,55 1.73/22 1.75/8 2.00/11 1.45/11   36/3 3,14 1.27/22 1.75/8 1.55/11 1.00/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-28 Aalesund 0-0 Brann 48/8 3,67 1.58/24 1.25/8 1.83/12 1.33/12   39/1 3,21 1.42/24 1.00/8 2.42/12 0.42/12
2013-10-06 Lillestrom 1-1 Aalesund 31/-3 2,60 1.28/25 1.38/8 1.58/12 1.00/13   48/8 3,52 1.56/25 1.38/8 1.77/13 1.33/12
2013-10-20 Aalesund 0-1 Stromsgodset 49/8 3,46 1.54/26 1.13/8 1.77/13 1.31/13   60/34 3,31 2.04/26 1.88/8 2.69/13 1.38/13
2013-10-25 Viking 1-3 Aalesund 37/7 2,48 1.59/27 1.50/8 2.23/13 1.00/14   49/7 3,37 1.48/27 0.75/8 1.64/14 1.31/13
2013-11-03 Aalesund 1-0 Valerenga 52/9 3,39 1.54/28 0.75/8 1.64/14 1.43/14   39/-10 3,14 1.18/28 0.88/8 1.29/14 1.07/14
2013-11-10 Sogndal 1-2 Aalesund 32/-14 2,69 1.14/29 0.50/8 1.21/14 1.07/15   53/10 3,31 1.59/29 1.00/8 1.73/15 1.43/14