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
2019-03-30 Mjallby 0-1 Varberg 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
2019-03-30 Mjallby 0-1 Varbergs 0/-1 1,00 0.00/1 0.00/2 0.00/1 0.00/0   0/0 0,00 0.00/0 0.00/0 0.00/0 0.00/0
2019-04-08 Norrby 2-1 Mjallby 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   0/-2 1,00 0.00/2 0.00/2 0.00/2 0.00/0
2019-04-13 Mjallby 2-1 Vasteras SK 1/-3 1,67 0.00/3 0.00/3 0.00/2 0.00/1   3/1 2,50 2.00/2 2.00/2 1.00/1 3.00/1
2019-04-21 Dalkurd 2-1 Mjallby 0/-6 1,20 0.40/5 0.40/5 0.00/1 0.50/4   3/-2 2,00 0.75/4 0.75/4 1.00/3 0.00/1
2019-04-27 Mjallby 1-0 Degerfors 4/-3 2,20 0.60/5 0.60/5 1.00/3 0.00/2   11/4 3,00 1.83/6 1.83/6 2.00/3 1.67/3
2019-05-04 Mjallby 2-1 Orgryte 5/-2 2,00 1.00/6 1.00/6 1.50/4 0.00/2   8/3 2,60 2.00/5 2.00/5 1.33/3 3.00/2
2019-05-12 Syrianska 1-2 Mjallby 9/-11 4,14 0.71/7 0.71/7 0.25/4 1.33/3   7/-1 2,14 1.29/7 1.29/7 1.80/5 0.00/2
2019-05-15 Mjallby 2-1 Trelleborg 9/0 2,25 1.50/8 1.50/8 1.80/5 1.00/3   9/-1 2,71 1.00/7 1.00/7 1.25/4 0.67/3
2019-05-15 Mjallby 2-1 Trelleborgs 11/1 2,33 1.67/9 2.25/8 2.00/6 1.00/3   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   13/2 2,40 1.80/10 2.25/8 2.14/7 1.00/3
2019-05-19 Osters 0-1 Mjallby 5/-3 1,63 0.88/8 0.88/8 0.75/4 1.00/4   14/3 2,27 1.91/11 2.63/8 2.14/7 1.50/4
2019-05-26 Mjallby 2-0 GAIS 15/4 2,17 2.00/12 2.63/8 2.14/7 1.80/5   13/0 2,17 1.50/12 1.75/8 1.29/7 1.80/5
2019-06-01 Mjallby 1-0 Jonkoping 17/6 2,15 2.08/13 3.00/8 2.25/8 1.80/5   17/10 2,40 1.70/10 2.13/8 2.00/5 1.40/5
2019-06-01 Mjallby 1-0 Jonkopings 18/7 2,07 2.14/14 3.00/8 2.33/9 1.80/5   17/10 2,40 1.70/10 2.13/8 2.00/5 1.40/5
2019-06-08 Brommapojkarna 1-1 Mjallby 15/-13 3,07 0.50/14 0.13/8 0.38/8 0.67/6   19/8 2,00 2.20/15 3.00/8 2.40/10 1.80/5
2019-06-16 Halmstad 2-0 Mjallby 12/-4 1,75 1.06/16 1.25/8 0.71/7 1.33/9   20/8 2,00 2.13/16 2.75/8 2.40/10 1.67/6
2019-06-23 Mjallby 1-2 Brage 20/6 2,00 2.00/17 2.38/8 2.40/10 1.43/7   22/6 2,24 1.47/17 1.38/8 1.78/9 1.13/8
2019-07-13 Frej 1-2 Mjallby 23/-13 3,28 1.06/18 0.75/8 1.22/9 0.89/9   21/5 2,06 1.89/18 2.00/8 2.18/11 1.43/7
2019-07-21 Mjallby 2-0 Halmstad 23/6 2,11 1.95/19 2.00/8 2.18/11 1.63/8   19/2 1,89 1.37/19 1.63/8 1.22/9 1.50/10
2019-07-27 Brage 1-2 Mjallby 29/11 2,35 1.70/20 2.13/8 1.90/10 1.50/10   25/8 2,10 2.00/20 2.00/8 2.25/12 1.63/8
2019-08-01 Mjallby 1-1 Norrby 27/9 2,14 2.05/21 2.00/8 2.25/12 1.78/9   31/-3 2,95 1.50/22 1.13/8 1.90/10 1.17/12
2019-08-11 GAIS 1-2 Mjallby 20/-13 2,30 1.04/23 0.75/8 1.09/11 1.00/12   28/9 2,14 2.00/22 1.75/8 2.15/13 1.78/9
2019-08-17 Orgryte 1-1 Mjallby 33/9 2,38 1.67/24 2.13/8 1.92/12 1.42/12   30/10 2,17 2.04/23 1.75/8 2.15/13 1.90/10
2019-08-25 Mjallby 3-2 Dalkurd 31/10 2,17 2.00/24 1.75/8 2.15/13 1.82/11   28/-9 2,50 1.31/26 1.63/8 1.75/12 0.93/14
2019-08-31 Mjallby 2-1 Frej 34/11 2,28 2.04/25 2.13/8 2.21/14 1.82/11   34/-21 3,18 0.82/28 0.38/8 0.87/15 0.77/13
2019-09-17 Degerfors 2-1 Mjallby 41/6 2,62 1.45/29 1.88/8 1.71/14 1.20/15   36/12 2,31 2.08/26 2.50/8 2.27/15 1.82/11
2019-09-22 Mjallby 0-2 Brommapojkarna 37/11 2,33 2.00/27 2.13/8 2.27/15 1.67/12   34/-15 2,86 0.79/29 1.00/8 0.73/15 0.86/14
2019-09-25 Trelleborgs 0-3 Mjallby 28/-4 2,50 1.25/24 1.50/8 1.42/12 1.08/12   37/9 2,32 1.93/28 1.75/8 2.13/16 1.67/12
2019-09-25 Trelleborg 0-3 Mjallby 28/-4 2,50 1.25/24 1.50/8 1.42/12 1.08/12   40/12 2,34 1.97/29 2.00/8 2.13/16 1.77/13
2019-10-01 Jonkoping 0-0 Mjallby 45/23 2,68 1.88/25 2.38/8 2.17/12 1.62/13   43/15 2,37 2.00/30 2.00/8 2.13/16 1.86/14
2019-10-01 Jonkopings 0-0 Mjallby 45/23 2,68 1.88/25 2.38/8 2.17/12 1.62/13   43/15 2,29 1.97/31 1.75/8 2.13/16 1.80/15
2019-10-05 Mjallby 3-2 Oster 43/15 2,22 1.94/32 1.75/8 2.13/16 1.75/16   22/-16 2,31 0.88/26 1.00/8 0.92/13 0.85/13
2019-10-05 Mjallby 3-2 Osters 46/16 2,30 1.97/33 1.75/8 2.18/17 1.75/16   22/-16 2,31 0.88/26 1.00/8 0.92/13 0.85/13
2019-10-19 Vasteras SK 2-2 Mjallby 40/-9 2,54 0.94/35 0.38/8 0.94/17 0.94/18   49/17 2,38 2.00/34 1.75/8 2.22/18 1.75/16
2019-10-28 Mjallby 2-0 Syrianska 51/17 2,43 1.97/35 1.88/8 2.22/18 1.71/17   38/-40 3,22 0.92/36 0.38/8 1.00/18 0.83/18
2019-11-03 Varberg 1-1 Mjallby 48/22 2,55 1.86/29 1.63/8 2.21/14 1.53/15   53/19 2,42 2.00/36 2.25/8 2.26/19 1.71/17
2019-11-03 Varbergs 1-1 Mjallby 48/22 2,55 1.86/29 1.63/8 2.21/14 1.53/15   54/19 2,41 1.97/37 1.75/8 2.26/19 1.67/18