SELECT * FROM 1_Kampe WHERE LigaID = '227' AND (Home='Mjondalen' OR Away='Mjondalen') 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-07-13 Start 3-1 Mjondalen 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-07-13 Stromsgodset 3-1 Mjondalen 25/-3 3,53 1.40/15 1.13/8 0.71/7 2.00/8   23/0 3,07 1.33/15 1.38/8 0.43/7 2.13/8
2018-07-13 Mjondalen 3-1 Valerenga 23/1 3,21 1.43/14 1.75/8 0.50/6 2.13/8   19/-5 3,58 1.25/12 1.13/8 0.71/7 2.00/5
2018-07-13 Molde 3-1 Mjondalen 30/8 4,00 1.92/13 2.00/8 1.00/6 2.71/7   22/2 3,23 1.54/13 1.75/8 0.50/6 2.43/7
2018-07-13 Aalesund 3-1 Mjondalen 19/-10 4,36 1.00/11 1.00/8 0.17/6 2.00/5   19/0 3,17 1.42/12 1.38/8 0.50/6 2.33/6
2018-07-13 Mjondalen 3-1 Kristiansund 18/1 3,18 1.55/11 1.38/8 0.60/5 2.33/6   25/5 4,09 1.55/11 1.75/8 0.60/5 2.33/6
2018-07-13 Viking 3-1 Mjondalen 18/-5 4,10 1.20/10 1.13/8 0.00/5 2.40/5   17/1 3,30 1.60/10 1.25/8 0.60/5 2.60/5
2018-07-13 Mjondalen 3-1 Sarpsborg 08 16/0 3,56 1.44/9 1.25/8 0.00/4 2.60/5   17/5 3,63 1.88/8 1.88/8 0.00/3 3.00/5
2018-07-13 Stabaek 3-1 Mjondalen 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2018-07-13 Mjondalen 3-1 Brann 31/-21 2,96 0.93/28 0.75/8 0.46/13 1.33/15   38/-10 3,19 1.19/27 1.00/8 0.64/14 1.77/13
2018-07-13 Mjondalen 3-1 Aalesund 39/-22 2,70 0.97/37 0.88/8 0.83/18 1.11/19   43/-54 3,89 0.56/36 0.50/8 0.32/19 0.82/17
2018-07-13 Rosenborg 3-1 Mjondalen 61/14 3,18 1.68/34 1.25/8 1.69/16 1.67/18   39/-21 2,75 1.00/36 1.25/8 0.83/18 1.17/18
2018-07-13 Mjondalen 3-1 Start 38/-22 2,80 0.94/35 0.88/8 0.71/17 1.17/18   48/-18 3,26 1.09/35 1.38/8 1.11/18 1.06/17
2018-07-13 Haugesund 3-1 Mjondalen 49/-10 3,18 1.35/34 1.63/8 1.18/17 1.53/17   37/-22 2,82 0.94/34 0.75/8 0.71/17 1.18/17
2018-07-13 Mjondalen 3-1 Stabaek 37/-21 2,88 0.97/33 0.75/8 0.75/16 1.18/17   47/-6 3,03 1.30/33 1.13/8 1.12/17 1.50/16
2018-07-13 Kristiansund 3-1 Mjondalen 62/11 3,53 1.53/32 1.25/8 1.07/15 1.94/17   37/-20 2,94 1.00/32 0.75/8 0.75/16 1.25/16
2018-07-13 Mjondalen 3-1 Stromsgodset 34/-23 2,94 0.94/31 0.38/8 0.60/15 1.25/16   46/-12 3,35 1.16/31 0.75/8 0.88/16 1.47/15
2018-07-13 Mjondalen 3-1 Molde 33/-21 2,90 0.97/30 0.38/8 0.64/14 1.25/16   70/27 3,77 1.83/30 1.50/8 1.80/15 1.87/15
2018-07-13 Mjondalen 3-1 Bodo/Glimt 24/-1 3,06 1.25/16 1.00/8 0.43/7 1.89/9   48/24 4,50 2.25/16 3.00/8 1.50/8 3.00/8
2018-07-13 Sandefjord 3-1 Mjondalen 23/-9 3,24 1.12/17 0.50/8 0.50/8 1.67/9   26/-2 3,18 1.18/17 0.88/8 0.38/8 1.89/9
2018-07-13 Mjondalen 3-1 Brann 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.29/7 0.00/1 0.00/0
2018-07-13 Haugesund 3-1 Mjondalen 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1
2018-07-13 Mjondalen 3-1 Viking 7/2 4,00 2.00/3 1.50/8 0.00/1 3.00/2   5/-2 4,00 1.00/3 1.50/8 0.00/2 3.00/1
2018-07-13 Mjondalen 3-1 Sarpsborg 08 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   7/2 4,00 2.00/3 2.14/7 0.00/1 3.00/2
2018-07-13 Stabaek 3-1 Mjondalen 11/2 4,00 1.80/5 1.50/8 0.00/2 3.00/3   9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2
2018-07-13 Mjondalen 3-1 Sandefjord 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3
2018-07-13 Bodo/Glimt 3-1 Mjondalen 15/2 4,00 1.71/7 1.50/8 0.00/3 3.00/4   13/-2 4,00 1.29/7 1.50/8 0.00/4 3.00/3
2018-07-13 Valerenga 3-1 Mjondalen 39/-1 3,16 1.52/25 1.63/8 1.62/13 1.42/12   30/-18 2,89 0.96/27 0.75/8 0.46/13 1.43/14
2018-07-13 Mjondalen 3-1 Viking 29/-17 2,88 1.00/26 0.75/8 0.50/12 1.43/14   50/-1 3,88 1.42/26 1.75/8 1.08/13 1.77/13
2018-07-13 Sarpsborg 08 3-1 Mjondalen 36/0 3,00 1.46/24 1.25/8 1.18/11 1.69/13   29/-15 2,92 1.04/25 0.75/8 0.50/12 1.54/13
2018-07-13 Mjondalen 3-1 Sandefjord 29/-13 2,96 1.08/24 0.75/8 0.55/11 1.54/13   33/-12 3,25 1.17/24 1.13/8 0.83/12 1.50/12
2018-07-13 Odd 3-1 Mjondalen 39/6 3,13 1.74/23 2.25/8 1.33/12 2.18/11   28/-8 2,78 1.13/23 0.75/8 0.55/11 1.67/12
2018-07-13 Mjondalen 3-1 Rosenborg 28/-6 2,82 1.18/22 0.75/8 0.60/10 1.67/12   40/14 3,14 1.71/21 2.00/8 1.55/11 1.90/10
2018-07-13 Brann 3-1 Mjondalen 31/-4 3,30 1.35/20 1.00/8 0.80/10 1.90/10   27/-7 2,90 1.10/21 0.38/8 0.60/10 1.55/11
2018-07-13 Mjondalen 3-1 Haugesund 26/-8 3,00 1.00/20 0.38/8 0.33/9 1.55/11   26/-7 2,95 1.35/20 1.38/8 0.91/11 1.89/9
2018-07-13 Start 3-1 Mjondalen 26/-9 3,21 0.95/19 0.50/8 0.40/10 1.56/9   26/-5 3,00 1.05/19 0.38/8 0.33/9 1.70/10
2018-07-13 Mjondalen 3-1 Odd 26/-3 3,06 1.11/18 0.50/8 0.38/8 1.70/10   32/3 3,39 1.56/18 2.00/8 1.00/10 2.25/8
2018-07-13 Bodo/Glimt 3-1 Mjondalen 87/46 4,41 2.34/29 2.63/8 2.14/14 2.53/15   33/-19 2,93 1.00/29 0.75/8 0.64/14 1.33/15