SELECT * FROM 1_Kampe WHERE LigaID = '191' AND (Home='Aalborg' OR Away='Aalborg') 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 Aalborg 1-3 Nordsjaelland 38/7 2,16 1.41/32 1.63/8 1.69/16 1.13/16   39/-4 2,56 1.38/32 1.13/8 1.82/17 0.87/15
2018-10-21 Midtjylland 1-3 Aalborg 30/16 3,14 2.43/14 2.38/8 3.00/7 1.86/7   15/5 1,79 1.50/14 1.75/8 1.88/8 1.00/6
2018-10-21 Aalborg 1-3 Slagelse 13/3 1,77 1.38/13 1.50/8 1.71/7 1.00/6   15/-10 3,08 1.08/13 0.88/8 1.83/6 0.43/7
2018-10-21 Aalborg 1-3 Silkeborg 11/1 1,75 1.25/12 1.25/8 1.50/6 1.00/6   7/-12 2,17 0.33/12 0.25/8 0.50/6 0.17/6
2018-10-21 Nordsjaelland 1-3 Aalborg 17/1 3,00 1.82/11 1.75/8 2.00/6 1.60/5   10/0 1,82 1.09/11 0.88/8 1.50/6 0.60/5
2018-10-21 Aalborg 1-3 Hobro 9/0 1,80 1.10/10 0.88/8 1.60/5 0.60/5   16/3 2,90 1.60/10 1.63/8 1.60/5 1.60/5
2018-10-21 Brondby 1-3 Aalborg 11/0 2,44 1.22/9 1.38/8 1.75/4 0.80/5   8/1 1,67 1.22/9 1.25/8 1.60/5 0.75/4
2018-10-21 Aalborg 1-3 Randers FC 8/1 1,88 1.25/8 1.25/8 1.75/4 0.75/4   9/2 2,00 2.00/8 2.00/8 2.25/4 1.75/4
2018-10-21 Slagelse 1-3 Aalborg 10/-3 3,29 1.00/7 1.00/7 2.33/3 0.00/4   8/2 2,00 1.43/7 1.43/7 1.75/4 1.00/3
2018-10-21 Aalborg 1-3 FC Copenhagen 7/1 2,17 1.17/6 1.17/6 1.33/3 1.00/3   6/-2 2,33 1.33/6 1.33/6 1.00/3 1.67/3
2018-10-21 Silkeborg 1-3 Aalborg 0/-6 1,20 0.40/5 0.40/5 0.50/2 0.33/3   5/1 1,80 1.20/5 1.20/5 1.33/3 1.00/2
2018-10-21 Aalborg 1-3 Esbjerg 4/1 1,75 1.25/4 1.25/4 1.50/2 1.00/2   3/-2 2,00 0.50/4 0.50/4 0.67/3 0.00/1
2018-10-21 Aalborg 1-3 Nordsjaelland 3/2 1,33 1.67/3 1.67/3 3.00/1 1.00/2   7/1 4,33 2.00/3 2.00/3 3.00/2 0.00/1
2018-10-21 Odense 1-3 Aalborg 2/-3 3,50 0.00/2 0.00/2 0.00/1 0.00/1   2/2 1,00 2.00/2 2.00/2 3.00/1 1.00/1
2018-10-21 Aalborg 1-3 Midtjylland 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   3/2 4,00 3.00/1 3.00/1 3.00/1 0.00/0
2018-10-21 Aalborg 1-3 FC Copenhagen 15/3 1,80 1.40/15 1.38/8 1.88/8 0.86/7   15/3 1,80 1.73/15 2.25/8 2.00/8 1.43/7
2018-10-21 Odense 1-3 Aalborg 18/-4 2,50 1.13/16 1.50/8 1.57/7 0.78/9   15/2 1,75 1.31/16 1.38/8 1.67/9 0.86/7
2018-10-21 Aalborg 1-3 Brondby 16/2 1,76 1.29/17 1.38/8 1.67/9 0.88/8   21/4 2,24 1.59/17 2.00/8 2.44/9 0.63/8
2018-10-21 Silkeborg 1-3 Aalborg 24/-30 2,52 0.45/31 0.25/8 0.33/15 0.56/16   36/6 2,13 1.35/31 1.25/8 1.69/16 1.00/15
2018-10-21 Aalborg 1-3 Esbjerg 35/5 2,17 1.30/30 1.00/8 1.60/15 1.00/15   44/1 2,90 1.13/30 1.00/8 1.19/16 1.07/14
2018-10-21 FC Copenhagen 1-3 Aalborg 35/14 1,93 1.90/29 1.75/8 2.29/14 1.53/15   35/6 2,21 1.34/29 1.00/8 1.60/15 1.07/14
2018-10-21 Aalborg 1-3 Odense 35/8 2,21 1.39/28 1.00/8 1.71/14 1.07/14   30/-7 2,39 1.25/28 1.25/8 1.36/14 1.14/14
2018-10-21 Brondby 1-3 Aalborg 33/10 2,07 1.63/27 2.00/8 2.14/14 1.08/13   34/8 2,22 1.41/27 1.25/8 1.71/14 1.08/13
2018-10-21 Aalborg 1-3 Hobro 29/3 2,12 1.35/26 1.25/8 1.62/13 1.08/13   33/1 2,50 1.46/26 2.13/8 1.69/13 1.23/13
2018-10-21 Sonderjyske 1-3 Aalborg 24/-5 2,12 1.20/25 1.25/8 1.00/12 1.38/13   26/0 2,08 1.28/25 1.25/8 1.62/13 0.92/12
2018-10-21 Slagelse 1-3 Aalborg 21/-20 2,58 0.79/24 0.63/8 1.09/11 0.54/13   25/1 2,04 1.33/24 1.38/8 1.62/13 1.00/11
2018-10-21 Aalborg 1-3 Midtjylland 24/2 2,00 1.39/23 1.38/8 1.75/12 1.00/11   49/26 3,13 2.35/23 2.13/8 3.00/12 1.64/11
2018-10-21 Randers FC 1-3 Aalborg 24/6 1,91 1.59/22 1.38/8 1.70/10 1.50/12   23/2 2,00 1.41/22 1.25/8 1.75/12 1.00/10
2018-10-21 Aalborg 1-3 Sonderjyske 22/5 1,86 1.48/21 1.63/8 1.91/11 1.00/10   19/-6 2,10 1.24/21 1.38/8 1.20/10 1.27/11
2018-10-21 Hobro 1-3 Aalborg 26/0 2,60 1.35/20 1.25/8 1.56/9 1.18/11   22/6 1,90 1.55/20 2.00/8 1.91/11 1.11/9
2018-10-21 Aalborg 1-3 Randers FC 20/5 1,84 1.47/19 2.00/8 1.80/10 1.11/9   21/8 1,79 1.79/19 2.00/8 1.89/9 1.70/10
2018-10-21 Esbjerg 1-3 Aalborg 26/6 2,56 1.28/18 1.88/8 1.56/9 1.00/9   17/3 1,72 1.39/18 1.75/8 1.80/10 0.88/8
2018-10-21 Sonderjyske 1-3 Aalborg 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