SELECT * FROM 1_Kampe WHERE LigaID = '227' AND (Home='Kristiansund' OR Away='Kristiansund') 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 Molde - Kristiansund / /0 / / /   / /0 / / /
2020-04-19 Kristiansund - Viking / /0 / / /   / /0 / / /
2020-04-26 Haugesund - Kristiansund / /0 / / /   / /0 / / /
2020-04-29 Kristiansund - Stromsgodset / /0 / / /   / /0 / / /
2020-05-03 Brann - Kristiansund / /0 / / /   / /0 / / /
2020-05-10 Kristiansund - Odd / /0 / / /   / /0 / / /
2020-05-16 Rosenborg - Kristiansund / /0 / / /   / /0 / / /
2020-06-16 Rosenborg 0-0 Kristiansund 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 Kristiansund 7-2 Aalesund 0/0 0,00 1.00/1 1.00/1 0.00/0 1.00/1   1/-3 5,00 0.00/1 0.00/1 0.00/1 0.00/0
2020-06-24 Haugesund 2-2 Kristiansund 2/-6 5,00 0.00/2 0.00/2 0.00/1 0.00/1   7/5 4,50 2.00/2 2.00/2 3.00/1 1.00/1
2020-06-28 Mjondalen 1-2 Kristiansund 2/1 1,00 1.67/3 1.67/3 3.00/1 1.00/2   9/5 4,33 1.67/3 1.67/3 3.00/1 1.00/2
2020-07-02 Kristiansund 2-2 Molde 11/6 4,00 2.00/4 2.00/4 3.00/1 1.67/3   12/8 4,00 3.00/4 3.00/4 3.00/2 3.00/2
2020-07-05 Stromsgodset 2-2 Kristiansund 7/0 2,80 1.60/5 1.60/5 2.00/2 1.33/3   13/6 4,00 1.80/5 1.80/5 2.00/2 1.67/3
2020-07-12 Kristiansund 1-2 Stabaek 15/6 4,00 1.67/6 1.67/6 2.00/2 1.50/4   7/-2 2,67 1.33/6 1.33/6 1.75/4 0.50/2
2020-07-15 Bodo/Glimt 2-1 Kristiansund 30/23 5,29 3.00/7 3.00/7 3.00/3 3.00/4   16/5 3,86 1.43/7 1.43/7 1.33/3 1.50/4
2020-07-19 Kristiansund 0-0 Valerenga 17/4 3,75 1.25/8 1.25/8 1.33/3 1.20/5   11/1 2,63 1.88/8 1.88/8 2.00/4 1.75/4
2020-07-25 Brann 1-1 Kristiansund 13/0 2,89 1.56/9 1.38/8 1.75/4 1.40/5   17/4 3,33 1.22/9 1.25/8 1.25/4 1.20/5
2020-07-29 Kristiansund 3-1 Sandefjord 18/4 3,20 1.20/10 1.00/8 1.25/4 1.17/6   8/-8 2,40 1.00/10 0.75/8 1.40/5 0.60/5
2020-08-02 Viking 1-2 Kristiansund 13/-8 3,09 1.00/11 1.25/8 1.40/5 0.67/6   21/6 3,27 1.36/11 1.25/8 1.60/5 1.17/6
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-16 Odd 2-1 Kristiansund 21/7 2,69 1.92/13 2.38/8 1.86/7 2.00/6   26/8 3,38 1.62/13 1.50/8 1.83/6 1.43/7
2020-08-22 Kristiansund 4-1 Sarpsborg 08 27/7 3,36 1.50/14 1.38/8 1.83/6 1.25/8   17/-1 2,50 1.21/14 1.75/8 1.63/8 0.67/6
2020-08-30 Sandefjord 0-2 Kristiansund 17/-10 2,93 1.07/15 1.50/8 1.43/7 0.75/8   31/10 3,47 1.60/15 1.75/8 2.00/7 1.25/8
2020-09-12 Kristiansund 3-5 Viking 33/12 3,38 1.69/16 2.13/8 2.00/7 1.44/9   24/-6 3,38 1.19/16 1.75/8 1.38/8 1.00/8
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 Kristiansund 1-1 Brann 38/11 3,61 1.67/18 2.25/8 1.75/8 1.60/10   23/-7 2,94 1.22/18 0.88/8 1.00/9 1.44/9
2020-10-04 Aalesund 1-2 Kristiansund 24/-31 4,16 0.37/19 0.13/8 0.50/10 0.22/9   39/11 3,53 1.63/19 2.00/8 1.67/9 1.60/10
2020-10-18 Kristiansund 0-0 Rosenborg 41/12 3,50 1.70/20 2.00/8 1.67/9 1.73/11   40/19 3,05 1.90/20 2.50/8 2.18/11 1.56/9
2020-10-25 Valerenga 1-1 Kristiansund 36/9 3,00 1.81/21 1.88/8 2.40/10 1.27/11   41/12 3,33 1.67/21 1.75/8 1.60/10 1.73/11
2020-11-01 Kristiansund 2-3 Bodo/Glimt 42/12 3,27 1.64/22 1.88/8 1.60/10 1.67/12   73/48 4,45 2.68/22 2.63/8 3.00/11 2.36/11
2020-11-08 Molde 2-2 Kristiansund 57/29 3,70 2.00/23 1.88/8 2.45/11 1.58/12   44/11 3,35 1.57/23 1.50/8 1.45/11 1.67/12
2020-11-22 Kristiansund 1-0 Mjondalen 46/11 3,38 1.54/24 1.25/8 1.45/11 1.62/13   21/-20 2,58 0.83/24 0.75/8 1.00/12 0.67/12
2020-11-29 Kristiansund 2-1 Stromsgodset 47/12 3,28 1.60/25 1.63/8 1.58/12 1.62/13   31/-16 3,12 0.96/25 0.50/8 1.08/13 0.83/12
2020-12-02 Sarpsborg 08 1-1 Kristiansund 31/-5 2,58 1.12/26 0.75/8 1.46/13 0.77/13   49/13 3,27 1.65/26 1.63/8 1.69/13 1.62/13
2020-12-09 Kristiansund 4-3 Odd 50/13 3,22 1.63/27 1.63/8 1.69/13 1.57/14   45/8 3,28 1.68/25 1.38/8 2.00/13 1.33/12
2020-12-13 Stabaek 2-2 Kristiansund 35/-8 2,79 1.25/28 1.25/8 1.43/14 1.07/14   54/14 3,36 1.68/28 1.63/8 1.79/14 1.57/14
2020-12-22 Kristiansund 1-3 Haugesund 56/14 3,38 1.66/29 1.63/8 1.79/14 1.53/15   36/-14 2,97 1.24/29 1.38/8 1.40/15 1.07/14