SELECT * FROM 1_Kampe WHERE LigaID = '227' AND (Home='Start' OR Away='Start') 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-05 Kristiansund - Start / /0 / / /   / /0 / / /
2020-04-13 Start - Aalesund / /0 / / /   / /0 / / /
2020-04-19 Stromsgodset - Start / /0 / / /   / /0 / / /
2020-04-26 Start - Stabaek / /0 / / /   / /0 / / /
2020-04-29 Bodo/Glimt - Start / /0 / / /   / /0 / / /
2020-05-03 Start - Sandefjord / /0 / / /   / /0 / / /
2020-05-10 Haugesund - Start / /0 / / /   / /0 / / /
2020-05-16 Start - Mjondalen / /0 / / /   / /0 / / /
2020-06-17 Start 2-2 Stromsgodset 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 Sandefjord 2-2 Start 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2020-06-24 Start 2-3 Molde 4/0 4,00 1.00/2 1.00/2 1.00/1 1.00/1   5/4 3,00 3.00/2 3.00/2 3.00/1 3.00/1
2020-06-27 Start 0-5 Odd 6/-1 4,33 0.67/3 0.67/3 0.50/2 1.00/1   5/1 3,00 1.00/3 1.00/3 1.50/2 0.00/1
2020-07-01 Haugesund 1-0 Start 5/-5 3,75 1.00/4 1.00/4 0.50/2 1.50/2   6/-6 4,50 0.50/4 0.50/4 0.33/3 1.00/1
2020-07-04 Start 1-1 Viking 6/-7 3,80 0.40/5 0.40/5 0.33/3 0.50/2   6/-4 3,20 0.80/5 0.80/5 1.33/3 0.00/2
2020-07-12 Sarpsborg 08 1-0 Start 6/-2 2,33 0.50/6 0.50/6 0.00/3 1.00/3   7/-7 3,50 0.50/6 0.50/6 0.50/4 0.50/2
2020-07-16 Start 0-0 Rosenborg 7/-8 3,14 0.43/7 0.43/7 0.50/4 0.33/3   11/5 2,43 1.57/7 1.57/7 1.25/4 2.00/3
2020-07-19 Brann 1-1 Start 12/0 3,00 1.63/8 1.63/8 2.00/3 1.40/5   7/-8 2,75 0.50/8 0.50/8 0.60/5 0.33/3
2020-07-26 Start 0-0 Stabaek 8/-8 2,67 0.56/9 0.50/8 0.60/5 0.50/4   13/1 2,78 1.67/9 1.75/8 1.60/5 1.75/4
2020-07-29 Aalesund 3-2 Start 13/-19 4,50 0.30/10 0.38/8 0.20/5 0.40/5   8/-8 2,40 0.60/10 0.50/8 0.67/6 0.50/4
2020-08-02 Start 3-0 Mjondalen 10/-9 2,64 0.55/11 0.50/8 0.67/6 0.40/5   10/-5 2,27 0.73/11 0.38/8 0.60/5 0.83/6
2020-08-05 Molde 5-0 Start 34/21 3,92 2.33/12 2.00/8 3.00/5 1.86/7   13/-6 2,67 0.75/12 0.88/8 1.00/7 0.40/5
2020-08-09 Kristiansund 3-2 Start 23/7 3,25 1.50/12 1.25/8 1.60/5 1.43/7   13/-11 2,85 0.69/13 0.88/8 1.00/7 0.33/6
2020-08-17 Start 2-1 Valerenga 15/-12 3,00 0.64/14 0.75/8 1.00/7 0.29/7   18/1 2,69 1.77/13 1.88/8 2.00/6 1.57/7
2020-08-22 Bodo/Glimt 6-0 Start 47/29 4,64 2.71/14 2.50/8 3.00/6 2.50/8   17/-11 3,00 0.80/15 1.13/8 1.25/8 0.29/7
2020-08-30 Start 1-0 Aalesund 17/-17 3,19 0.75/16 1.00/8 1.25/8 0.25/8   21/-25 4,47 0.47/15 0.50/8 0.63/8 0.29/7
2020-09-20 Start 1-2 Kristiansund 18/-16 3,06 0.88/17 1.25/8 1.44/9 0.25/8   36/10 3,65 1.59/17 2.00/8 1.75/8 1.44/9
2020-09-27 Stabaek 2-0 Start 23/-5 2,83 1.22/18 0.75/8 1.33/9 1.11/9   19/-17 3,06 0.83/18 1.13/8 1.30/10 0.25/8
2020-10-04 Start 5-1 Haugesund 19/-19 3,00 0.79/19 1.13/8 1.30/10 0.22/9   23/-8 2,84 1.16/19 1.25/8 1.40/10 0.89/9
2020-10-18 Stromsgodset 1-1 Start 28/-9 3,25 1.15/20 1.00/8 1.30/10 1.00/10   24/-15 3,15 0.90/20 1.13/8 1.45/11 0.22/9
2020-10-24 Start 0-1 Sandefjord 25/-15 3,10 0.90/21 1.25/8 1.45/11 0.30/10   21/-13 2,62 1.10/21 0.88/8 1.10/10 1.09/11
2020-11-01 Rosenborg 1-0 Start 42/20 2,91 1.91/22 2.25/8 2.18/11 1.64/11   25/-16 3,00 0.86/22 1.25/8 1.33/12 0.30/10
2020-11-08 Start 3-2 Sarpsborg 08 25/-17 2,91 0.83/23 0.88/8 1.33/12 0.27/11   27/-3 2,48 1.22/23 1.38/8 1.58/12 0.82/11
2020-11-22 Odd 1-2 Start 44/9 3,29 1.75/24 1.38/8 2.17/12 1.33/12   28/-16 3,00 0.92/24 1.25/8 1.46/13 0.27/11
2020-11-28 Viking 4-1 Start 44/0 3,52 1.44/25 1.75/8 1.50/12 1.38/13   30/-15 3,00 1.00/25 1.25/8 1.46/13 0.50/12
2020-12-02 Start 1-1 Bodo/Glimt 31/-18 3,08 0.96/26 1.25/8 1.46/13 0.46/13   90/61 4,58 2.73/26 2.63/8 3.00/13 2.46/13
2020-12-06 Mjondalen 1-0 Start 22/-22 2,44 0.78/27 0.88/8 0.92/13 0.64/14   32/-18 3,04 0.96/27 1.38/8 1.43/14 0.46/13
2020-12-09 Start 1-1 Brann 32/-19 2,96 0.93/28 1.00/8 1.43/14 0.43/14   37/-10 3,00 1.14/28 1.13/8 1.00/14 1.29/14
2020-12-22 Valerenga 4-0 Start 47/14 2,76 1.79/29 1.75/8 2.29/14 1.33/15   33/-19 2,93 0.93/29 1.00/8 1.40/15 0.43/14