SELECT * FROM 1_Kampe WHERE LigaID = '179' AND (Home='Mjallby' OR Away='Mjallby') 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 Varbergs 1-3 Mjallby 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
2018-10-21 Mjallby 1-3 Varbergs 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   57/-2 4,00 1.45/29 1.88/8 0.00/15 3.00/14
2018-10-21 Mjallby 1-3 Trelleborgs 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   15/2 4,00 1.71/7 1.50/8 0.00/3 3.00/4
2018-10-21 Osters 1-3 Mjallby 10/-4 4,00 1.00/6 1.50/8 0.00/4 3.00/2   5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1
2018-10-21 Mjallby 1-3 Jonkopings 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   6/-4 4,00 0.75/4 1.50/8 0.00/3 3.00/1
2018-10-21 Trelleborgs 1-3 Mjallby 42/4 4,00 1.65/20 1.50/8 0.00/9 3.00/11   9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2
2018-10-21 Jonkopings 1-3 Mjallby 39/2 4,00 1.58/19 1.50/8 0.00/9 3.00/10   12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3
2018-10-21 Mjallby 1-3 Osters 15/2 4,00 1.71/7 1.50/8 0.00/3 3.00/4   34/-4 4,00 1.33/18 1.50/8 0.00/10 3.00/8
2019-03-30 Mjallby 0-1 Varberg 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2019-04-08 Norrby 2-1 Mjallby 17/0 3,78 1.44/9 1.25/8 0.00/4 2.60/5   16/-1 3,67 1.33/9 1.50/8 0.00/5 3.00/4
2019-04-13 Mjallby 2-1 Vasteras SK 17/-2 3,60 1.20/10 1.13/8 0.00/5 2.40/5   19/1 3,70 1.60/10 1.63/8 0.20/5 3.00/5
2019-04-21 Dalkurd 2-1 Mjallby 16/-5 3,36 1.18/11 1.25/8 0.00/5 2.17/6   19/-1 3,55 1.36/11 1.50/8 0.50/6 2.40/5
2019-04-27 Mjallby 1-0 Degerfors 20/-2 3,50 1.25/12 1.50/8 0.50/6 2.00/6   24/3 3,75 1.58/12 2.00/8 0.50/6 2.67/6
2019-05-04 Mjallby 2-1 Orgryte 21/-1 3,31 1.38/13 1.50/8 0.86/7 2.00/6   24/3 3,46 1.69/13 2.00/8 0.57/7 3.00/6
2019-05-12 Syrianska 1-2 Mjallby 24/-7 3,93 1.21/14 1.38/8 0.14/7 2.29/7   23/0 3,29 1.50/14 1.88/8 1.13/8 2.00/6
2019-05-15 Mjallby 2-1 Trelleborg 25/1 3,27 1.60/15 1.88/8 1.13/8 2.14/7   9/-1 2,71 1.00/7 1.00/7 1.25/4 0.67/3
2019-05-19 Oster 0-1 Mjallby 5/-3 1,63 0.88/8 0.88/8 0.75/4 1.00/4   27/2 3,25 1.69/16 1.88/8 1.33/9 2.14/7
2019-05-26 Mjallby 2-0 GAIS 28/3 3,12 1.76/17 2.25/8 1.33/9 2.25/8   25/-1 3,00 1.47/17 1.50/8 0.56/9 2.50/8
2019-06-01 Mjallby 1-0 Jonkoping 30/5 3,06 1.83/18 2.63/8 1.50/10 2.25/8   17/10 2,40 1.70/10 2.13/8 2.00/5 1.40/5
2019-06-08 Brommapojkarna 1-1 Mjallby 29/-7 3,42 1.00/19 0.50/8 0.30/10 1.78/9   31/6 2,95 1.89/19 2.63/8 1.64/11 2.25/8
2019-06-16 Halmstad 2-0 Mjallby 26/-4 2,80 1.15/20 0.88/8 0.50/10 1.80/10   32/6 2,90 1.85/20 2.75/8 1.64/11 2.11/9
2019-06-23 Mjallby 1-2 Brage 32/4 2,86 1.76/21 2.38/8 1.64/11 1.90/10   33/7 2,81 1.57/21 1.38/8 1.18/11 2.00/10
2019-07-13 Frej 1-2 Mjallby 31/-14 3,45 1.14/22 1.00/8 0.60/10 1.58/12   33/3 2,86 1.68/22 2.00/8 1.50/12 1.90/10
2019-07-21 Mjallby 2-0 Halmstad 35/4 2,87 1.74/23 2.00/8 1.50/12 2.00/11   33/2 2,78 1.39/23 1.63/8 0.92/12 1.91/11
2019-07-27 Brage 1-2 Mjallby 40/12 2,83 1.75/24 2.00/8 1.33/12 2.17/12   37/6 2,83 1.79/24 2.00/8 1.62/13 2.00/11
2019-08-01 Mjallby 1-1 Norrby 39/7 2,84 1.84/25 2.00/8 1.62/13 2.08/12   39/1 3,08 1.52/25 1.25/8 1.33/12 1.69/13
2019-08-11 GAIS 1-2 Mjallby 30/-12 2,77 1.19/26 0.75/8 0.62/13 1.77/13   40/7 2,81 1.81/26 1.75/8 1.57/14 2.08/12
2019-08-17 Orgryte 1-1 Mjallby 42/7 2,85 1.63/27 2.13/8 1.38/13 1.86/14   42/8 2,81 1.85/27 1.75/8 1.57/14 2.15/13
2019-08-25 Mjallby 3-2 Dalkurd 43/8 2,79 1.82/28 1.75/8 1.57/14 2.07/14   43/-3 3,18 1.50/28 1.63/8 1.29/14 1.71/14
2019-08-31 Mjallby 2-1 Frej 46/9 2,86 1.86/29 2.13/8 1.67/15 2.07/14   39/-19 3,34 0.97/29 0.38/8 0.53/15 1.43/14
2019-09-17 Degerfors 2-1 Mjallby 48/4 3,07 1.47/30 1.38/8 1.13/15 1.80/15   48/10 2,87 1.90/30 2.50/8 1.75/16 2.07/14
2019-09-22 Mjallby 0-2 Brommapojkarna 49/9 2,87 1.84/31 2.13/8 1.75/16 1.93/15   44/-9 3,13 1.03/31 1.25/8 0.63/16 1.47/15
2019-09-25 Trelleborg 0-3 Mjallby 28/-4 2,50 1.25/24 1.50/8 1.42/12 1.08/12   49/7 2,84 1.78/32 1.75/8 1.65/17 1.93/15
2019-10-01 Jonkoping 0-0 Mjallby 45/23 2,68 1.88/25 2.38/8 2.17/12 1.62/13   52/10 2,85 1.82/33 1.75/8 1.65/17 2.00/16
2019-10-05 Mjallby 3-2 Oster 52/10 2,76 1.79/34 1.75/8 1.65/17 1.94/17   22/-16 2,31 0.88/26 1.00/8 0.92/13 0.85/13
2019-10-19 Vasteras SK 2-2 Mjallby 50/-1 2,89 1.20/35 0.75/8 0.82/17 1.56/18   55/11 2,83 1.83/35 1.75/8 1.72/18 1.94/17
2019-10-28 Mjallby 2-0 Syrianska 57/11 2,86 1.81/36 1.75/8 1.72/18 1.89/18   45/-27 3,25 1.03/36 0.50/8 0.72/18 1.33/18
2019-11-03 Varberg 1-1 Mjallby 48/22 2,55 1.86/29 1.63/8 2.21/14 1.53/15   59/13 2,84 1.84/37 1.75/8 1.79/19 1.89/18