SELECT * FROM 1_Kampe WHERE LigaID = '195' 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 FC Copenhagen 1-3 Aalborg 75/46 3,25 2.44/32 2.13/8 2.75/16 2.13/16   38/-8 2,63 1.09/32 1.75/8 0.94/17 1.27/15
2018-10-21 Aalborg 1-3 Esbjerg 14/-5 2,36 0.93/14 1.00/8 0.57/7 1.29/7   18/-6 3,00 1.00/14 1.25/8 0.71/7 1.29/7
2018-10-21 Randers FC 1-3 Aalborg 14/-3 2,38 1.00/13 0.63/8 1.33/6 0.71/7   14/-5 2,54 0.92/13 0.88/8 0.57/7 1.33/6
2018-10-21 Aalborg 1-3 Nordsjaelland 12/-7 2,58 0.75/12 0.50/8 0.17/6 1.33/6   14/-2 2,50 1.25/12 1.13/8 1.33/6 1.17/6
2018-10-21 Sonderjyske 1-3 Aalborg 13/-3 2,64 1.18/11 0.88/8 1.20/5 1.17/6   12/-6 2,73 0.82/11 0.63/8 0.17/6 1.60/5
2018-10-21 Aalborg 1-3 Odense 11/-5 2,70 0.90/10 0.75/8 0.20/5 1.60/5   17/3 3,10 1.40/10 1.25/8 1.67/6 1.00/4
2018-10-21 Aalborg 1-3 Sonderjyske 11/-3 2,78 1.00/9 0.75/8 0.25/4 1.60/5   10/-3 2,56 1.11/9 1.25/8 1.20/5 1.00/4
2018-10-21 Randers FC 1-3 Aalborg 8/0 2,00 1.38/8 1.38/8 1.75/4 1.00/4   8/-4 2,50 0.75/8 0.75/8 0.25/4 1.25/4
2018-10-21 Aalborg 1-3 Horsens 6/-3 2,14 0.86/7 0.86/7 0.33/3 1.25/4   4/-4 1,71 1.00/7 1.00/7 1.00/4 1.00/3
2018-10-21 Nordsjaelland 1-3 Aalborg 8/-4 3,33 1.00/6 1.00/6 1.00/3 1.00/3   6/-3 2,50 0.83/6 0.83/6 0.33/3 1.33/3
2018-10-21 Aalborg 1-3 Esbjerg 6/-1 2,60 1.00/5 1.00/5 0.50/2 1.33/3   2/-10 2,80 0.20/5 0.20/5 0.00/2 0.33/3
2018-10-21 Midtjylland 1-3 Aalborg 7/6 2,00 2.25/4 2.25/4 3.00/1 2.00/3   5/0 2,50 1.25/4 1.25/4 0.50/2 2.00/2
2018-10-21 Aalborg 1-3 Silkeborg 5/0 3,33 1.33/3 1.33/3 0.00/1 2.00/2   3/-5 3,67 0.33/3 0.33/3 1.00/1 0.00/2
2018-10-21 FC Copenhagen 1-3 Aalborg 5/3 3,50 3.00/2 3.00/2 0.00/0 3.00/2   4/0 4,00 1.50/2 1.50/2 0.00/1 3.00/1
2018-10-21 Aalborg 1-3 Brondby 4/2 6,00 3.00/1 3.00/1 0.00/0 3.00/1   2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1
2018-10-21 Midtjylland 1-3 Aalborg 25/10 2,67 1.67/15 1.25/8 1.57/7 1.75/8   15/-5 2,33 0.93/15 1.00/8 0.63/8 1.29/7
2018-10-21 Aalborg 1-3 Brondby 17/-5 2,44 0.94/16 1.13/8 0.63/8 1.25/8   25/2 3,00 1.44/16 1.00/8 1.50/8 1.38/8
2018-10-21 Horsens 1-3 Aalborg 16/-8 2,35 1.35/17 1.63/8 1.00/8 1.67/9   18/-6 2,47 0.88/17 0.75/8 0.56/9 1.25/8
2018-10-21 Aalborg 1-3 Sonderjyske 37/-7 2,61 1.13/31 1.88/8 1.00/16 1.27/15   30/-13 2,35 1.16/31 0.88/8 1.33/15 1.00/16
2018-10-21 Silkeborg 1-3 Aalborg 37/-7 2,70 1.23/30 1.25/8 1.71/14 0.81/16   34/-6 2,47 1.17/30 1.88/8 1.00/16 1.36/14
2018-10-21 Esbjerg 1-3 Aalborg 31/-13 2,59 0.97/29 1.38/8 0.73/15 1.21/14   34/-6 2,55 1.17/29 2.13/8 1.00/16 1.38/13
2018-10-21 Aalborg 1-3 Lyngby 32/-7 2,54 1.11/28 1.75/8 0.87/15 1.38/13   37/-10 3,00 1.14/28 1.00/8 1.50/14 0.79/14
2018-10-21 Aalborg 1-3 Midtjylland 30/-9 2,56 1.04/27 1.50/8 0.71/14 1.38/13   43/11 2,78 1.52/27 1.13/8 1.71/14 1.31/13
2018-10-21 Nordsjaelland 1-3 Aalborg 29/-11 2,65 1.15/26 1.38/8 1.25/12 1.07/14   27/-9 2,42 1.04/26 1.38/8 0.71/14 1.42/12
2018-10-21 Aalborg 1-3 Randers FC 23/-12 2,32 0.96/25 1.13/8 0.54/13 1.42/12   31/1 2,44 1.12/25 1.25/8 1.42/12 0.85/13
2018-10-21 Brondby 1-3 Aalborg 38/5 2,96 1.50/24 1.63/8 1.67/12 1.33/12   21/-13 2,29 0.88/24 0.75/8 0.54/13 1.27/11
2018-10-21 Aalborg 1-3 Horsens 21/-13 2,39 0.87/23 0.75/8 0.50/12 1.27/11   20/-9 2,13 1.26/23 1.50/8 1.17/12 1.36/11
2018-10-21 Aalborg 1-3 Odense 21/-12 2,45 0.91/22 0.88/8 0.55/11 1.27/11   40/9 3,23 1.64/22 2.00/8 2.00/11 1.27/11
2018-10-21 Lyngby 1-3 Aalborg 27/-7 3,05 1.20/20 0.75/8 1.67/9 0.82/11   19/-13 2,43 0.81/21 0.63/8 0.55/11 1.10/10
2018-10-21 Aalborg 1-3 FC Copenhagen 19/-12 2,50 0.85/20 1.00/8 0.60/10 1.10/10   50/33 3,35 2.55/20 2.38/8 2.64/11 2.44/9
2018-10-21 Aalborg 1-3 Silkeborg 18/-12 2,53 0.84/19 0.88/8 0.56/9 1.10/10   24/-7 2,89 1.16/19 1.13/8 1.44/9 0.90/10
2018-10-21 Odense 1-3 Aalborg 30/2 3,22 1.61/18 1.88/8 1.78/9 1.44/9   18/-6 2,33 0.89/18 0.88/8 0.56/9 1.22/9
2018-10-21 Lyngby 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