SELECT * FROM 1_Kampe WHERE LigaID = '178' AND (Home='GAIS' OR Away='GAIS') 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-04 GAIS - Halmstad / /0 / / /   / /0 / / /
2020-04-19 GAIS - Dalkurd / /0 / / /   / /0 / / /
2020-04-25 Brage - GAIS / /0 / / /   / /0 / / /
2020-05-03 Ljungskile - GAIS / /0 / / /   / /0 / / /
2020-05-09 GAIS - Umea FC / /0 / / /   / /0 / / /
2020-05-18 GAIS - Orgryte / /0 / / /   / /0 / / /
2020-05-23 Jonkopings - GAIS / /0 / / /   / /0 / / /
2020-05-27 GAIS - Trelleborgs / /0 / / /   / /0 / / /
2020-05-31 Vasteras SK - GAIS / /0 / / /   / /0 / / /
2020-06-16 GAIS 1-0 Jonkopings 1/1 1,00 3.00/1 3.00/2 3.00/1 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2020-06-16 GAIS 1-0 Jonkoping 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 Norrby 3-0 GAIS 2/-2 3,00 0.00/2 0.00/2 0.00/0 0.00/2   2/2 1,00 3.00/2 3.00/2 3.00/2 0.00/0
2020-06-28 GAIS 0-1 Brage 2/-1 1,67 2.00/3 2.00/3 3.00/2 0.00/1   2/-4 4,00 0.00/2 0.00/2 0.00/1 0.00/1
2020-07-05 Vasteras SK 2-2 GAIS 3/1 1,25 1.50/4 1.50/4 1.00/1 1.67/3   2/-2 1,50 1.50/4 1.50/4 2.00/3 0.00/1
2020-07-08 GAIS 2-1 Dalkurd 4/-2 2,00 1.40/5 1.40/5 2.00/3 0.50/2   2/-1 1,25 0.50/4 0.50/4 0.00/2 1.00/2
2020-07-13 Trelleborg 2-0 GAIS 4/-2 2,00 1.00/5 1.00/5 0.50/2 1.33/3   6/-1 2,17 1.67/6 1.67/6 2.25/4 0.50/2
2020-07-13 Trelleborgs 2-0 GAIS 4/-2 2,00 1.00/5 1.00/5 0.50/2 1.33/3   6/-3 2,14 1.43/7 1.25/8 2.25/4 0.33/3
2020-07-18 GAIS 1-1 Umea FC 6/-5 2,13 1.25/8 1.25/8 2.25/4 0.25/4   5/-2 1,71 0.86/7 0.86/7 0.75/4 1.00/3
2020-07-24 AFC Eskilstuna 2-0 GAIS 10/-4 3,00 0.75/8 0.75/8 1.20/5 0.00/3   7/-5 2,11 1.22/9 1.00/8 2.00/5 0.25/4
2020-07-29 GAIS 1-1 Ljungskile 7/-7 2,10 1.10/10 0.63/8 2.00/5 0.20/5   15/-4 3,40 0.80/10 1.00/8 1.40/5 0.20/5
2020-08-02 Akropolis 2-2 GAIS 16/1 2,82 1.36/11 1.25/8 1.80/5 1.00/6   8/-7 2,09 1.09/11 0.75/8 1.83/6 0.20/5
2020-08-08 Halmstad 0-0 GAIS 20/12 2,33 1.92/12 2.13/8 1.71/7 2.20/5   10/-7 2,25 1.08/12 0.88/8 1.83/6 0.33/6
2020-08-12 GAIS 0-0 Degerfors 10/-7 2,08 1.08/13 0.88/8 1.83/6 0.43/7   29/20 2,71 2.50/14 2.75/8 2.63/8 2.33/6
2020-08-15 Sundsvall 3-0 GAIS 28/7 3,27 1.60/15 1.13/8 1.83/6 1.44/9   10/-7 1,93 1.07/14 0.63/8 1.71/7 0.43/7
2020-08-22 GAIS 0-0 Orgryte 10/-10 2,00 1.00/15 0.63/8 1.71/7 0.38/8   20/-3 2,69 1.50/16 2.25/8 2.11/9 0.71/7
2020-08-29 Oster 4-1 GAIS 16/1 2,21 1.43/14 1.00/8 1.57/7 1.29/7   10/-10 1,88 1.00/16 0.75/8 1.63/8 0.38/8
2020-08-29 Osters 4-1 GAIS 16/1 2,21 1.43/14 1.00/8 1.57/7 1.29/7   11/-13 2,06 0.94/17 0.63/8 1.63/8 0.33/9
2020-09-04 GAIS 2-1 Trelleborgs 14/-15 2,26 1.00/19 1.13/8 1.78/9 0.30/10   17/-1 2,33 1.27/15 1.38/8 1.50/8 1.00/7
2020-09-04 GAIS 2-1 Trelleborg 12/-16 2,22 0.89/18 0.63/8 1.63/8 0.30/10   17/-1 2,33 1.27/15 1.38/8 1.50/8 1.00/7
2020-09-12 GAIS 3-1 Sundsvall 16/-14 2,30 1.10/20 1.13/8 1.90/10 0.30/10   35/6 3,20 1.35/20 0.88/8 1.56/9 1.18/11
2020-09-16 Brage 2-1 GAIS 29/0 2,76 1.48/21 1.38/8 1.67/9 1.33/12   19/-12 2,38 1.19/21 1.38/8 2.00/11 0.30/10
2020-09-21 GAIS 1-0 Vasteras SK 20/-13 2,41 1.14/22 1.25/8 2.00/11 0.27/11   22/-7 2,43 1.00/21 1.00/8 1.56/9 0.58/12
2020-09-28 Orgryte 0-2 GAIS 28/-3 2,46 1.38/24 1.13/8 2.27/11 0.62/13   21/-12 2,35 1.22/23 1.63/8 2.08/12 0.27/11
2020-10-04 Ljungskile 1-2 GAIS 24/-19 2,91 0.78/23 0.63/8 1.36/11 0.25/12   23/-10 2,33 1.29/24 1.88/8 2.08/12 0.50/12
2020-10-10 GAIS 1-3 Halmstad 25/-9 2,36 1.36/25 2.25/8 2.08/12 0.69/13   39/23 2,20 1.88/25 1.63/8 2.00/14 1.73/11
2020-10-16 GAIS 3-3 Norrby 26/-11 2,42 1.31/26 2.25/8 1.92/13 0.69/13   29/-11 2,56 0.93/27 0.75/8 0.86/14 1.00/13
2020-10-22 Jonkopings 1-0 GAIS 41/11 3,09 1.83/23 2.00/8 2.42/12 1.18/11   29/-11 2,56 1.30/27 2.00/8 1.86/14 0.69/13
2020-10-22 Jonkopings 1-0 GAIS 42/12 3,00 1.88/24 2.38/8 2.46/13 1.18/11   29/-13 2,45 1.21/29 1.25/8 1.86/14 0.60/15
2020-10-22 Jonkoping 1-0 GAIS 41/11 3,09 1.83/23 2.00/8 2.42/12 1.18/11   29/-12 2,50 1.25/28 1.25/8 1.86/14 0.64/14
2020-10-26 Umea FC 3-0 GAIS 22/-24 2,27 0.67/30 0.13/8 0.64/14 0.69/16   29/-14 2,40 1.17/30 1.25/8 1.86/14 0.56/16
2020-10-26 Umea FC 3-0 GAIS 25/-21 2,29 0.74/31 0.75/8 0.80/15 0.69/16   29/-17 2,42 1.13/31 0.50/8 1.86/14 0.53/17
2020-11-02 GAIS 2-0 AFC Eskilstuna 29/-20 2,44 1.09/32 0.50/8 1.86/14 0.50/18   37/-16 2,81 1.13/32 1.13/8 1.50/18 0.64/14
2020-11-02 GAIS 2-0 AFC Eskilstuna 31/-18 2,42 1.15/33 0.88/8 1.93/15 0.50/18   37/-14 2,84 1.16/31 1.88/8 1.50/18 0.69/13
2020-11-07 Degerfors 2-1 GAIS 75/43 2,97 2.22/36 2.25/8 2.68/19 1.71/17   34/-17 2,43 1.17/35 0.75/8 2.00/16 0.47/19
2020-11-07 Degerfors 2-1 GAIS 73/42 2,97 2.20/35 1.88/8 2.67/18 1.71/17   33/-16 2,41 1.21/34 0.88/8 2.00/16 0.50/18
2020-11-21 GAIS 0-1 Osters 35/-19 2,41 1.11/37 0.75/8 1.88/17 0.45/20   44/3 2,74 1.74/31 1.50/8 2.06/17 1.36/14
2020-11-21 GAIS 0-1 Oster 35/-20 2,37 1.08/38 0.75/8 1.78/18 0.45/20   39/6 2,67 1.78/27 2.25/8 2.07/14 1.46/13
2020-11-21 GAIS 0-1 Osters 35/-18 2,44 1.14/36 0.75/8 2.00/16 0.45/20   45/4 2,69 1.78/32 1.50/8 2.06/17 1.47/15
2020-11-28 GAIS 1-1 Akropolis 35/-21 2,33 1.05/39 0.75/8 1.68/19 0.45/20   56/2 2,89 1.45/38 1.50/8 1.56/18 1.35/20
2020-11-28 GAIS 1-1 Akropolis 36/-21 2,33 1.05/40 0.63/8 1.65/20 0.45/20   57/2 2,87 1.44/39 1.75/8 1.56/18 1.33/21
2020-12-05 Dalkurd 0-1 GAIS 36/-27 2,41 0.78/41 0.13/8 0.85/20 0.71/21   37/-21 2,32 1.05/41 0.63/8 1.62/21 0.45/20