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
2018-10-21 Rosenborg 1-3 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
2018-10-21 Kristiansund 1-3 Odd 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0
2018-10-21 Brann 1-3 Kristiansund 4/0 4,00 1.50/2 1.29/7 0.00/1 3.00/1   4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1
2018-10-21 Kristiansund 1-3 Stromsgodset 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-10-21 Haugesund 1-3 Kristiansund 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2
2018-10-21 Kristiansund 1-3 Viking 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-10-21 Molde 1-3 Kristiansund 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-10-21 Kristiansund 1-3 Start 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
2020-06-16 Rosenborg 0-0 Kristiansund 15/2 4,00 1.71/7 1.71/7 0.00/3 3.00/4   16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4
2020-06-21 Kristiansund 7-2 Aalesund 16/0 3,56 1.44/9 1.63/8 0.00/4 2.60/5   14/-5 4,13 1.13/8 1.13/8 0.00/5 3.00/3
2020-06-24 Haugesund 2-2 Kristiansund 18/-6 4,20 1.20/10 0.75/8 0.00/5 2.40/5   23/5 4,10 1.60/10 1.63/8 0.60/5 2.60/5
2020-06-28 Mjondalen 1-2 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
2020-07-02 Kristiansund 2-2 Molde 27/6 4,00 1.67/12 2.13/8 0.60/5 2.43/7   28/8 4,00 2.00/12 1.88/8 1.00/6 3.00/6
2020-07-05 Stromsgodset 2-2 Kristiansund 23/0 3,54 1.54/13 1.38/8 0.67/6 2.29/7   29/6 4,00 1.62/13 1.88/8 0.67/6 2.43/7
2020-07-12 Kristiansund 1-2 Stabaek 31/6 4,00 1.57/14 1.63/8 0.67/6 2.25/8   23/-2 3,43 1.43/14 1.38/8 0.88/8 2.17/6
2020-07-15 Bodo/Glimt 2-1 Kristiansund 46/23 4,60 2.20/15 2.63/8 1.29/7 3.00/8   32/5 3,93 1.47/15 1.25/8 0.57/7 2.25/8
2020-07-19 Kristiansund 0-0 Valerenga 33/4 3,88 1.38/16 1.25/8 0.57/7 2.00/9   21/-3 3,21 1.50/14 1.88/8 1.00/8 2.17/6
2020-07-25 Brann 1-1 Kristiansund 26/-2 3,38 1.44/16 1.38/8 0.88/8 2.00/8   33/4 3,65 1.35/17 1.25/8 0.63/8 2.00/9
2020-07-29 Kristiansund 3-1 Sandefjord 34/4 3,56 1.33/18 1.00/8 0.63/8 1.90/10   24/-8 3,11 1.22/18 0.75/8 0.78/9 1.67/9
2020-08-02 Viking 1-2 Kristiansund 29/-8 3,47 1.21/19 1.25/8 0.78/9 1.60/10   37/6 3,58 1.42/19 1.25/8 0.89/9 1.90/10
2020-08-09 Kristiansund 3-2 Start 39/7 3,55 1.50/20 1.25/8 0.89/9 2.00/11   29/-11 3,29 1.00/21 0.88/8 0.64/11 1.40/10
2020-08-16 Odd 2-1 Kristiansund 37/7 3,19 1.76/21 2.38/8 1.18/11 2.40/10   42/8 3,62 1.57/21 1.50/8 1.10/10 2.00/11
2020-08-22 Kristiansund 4-1 Sarpsborg 08 43/7 3,59 1.50/22 1.38/8 1.10/10 1.83/12   34/5 3,00 1.52/21 1.75/8 1.30/10 1.73/11
2020-08-30 Sandefjord 0-2 Kristiansund 33/-10 3,30 1.22/23 1.50/8 0.91/11 1.50/12   47/10 3,65 1.57/23 1.75/8 1.27/11 1.83/12
2020-09-12 Kristiansund 3-5 Viking 49/12 3,58 1.63/24 2.13/8 1.27/11 1.92/13   40/-6 3,58 1.29/24 1.75/8 0.92/12 1.67/12
2020-09-20 Start 1-2 Kristiansund 34/-16 3,36 1.08/25 1.25/8 1.00/13 1.17/12   52/10 3,76 1.56/25 2.00/8 1.17/12 1.92/13
2020-09-27 Kristiansund 1-1 Brann 54/11 3,73 1.62/26 2.25/8 1.17/12 2.00/14   36/-9 3,24 1.24/25 0.88/8 0.69/13 1.83/12
2020-10-04 Aalesund 1-2 Kristiansund 37/-33 4,12 0.62/26 0.13/8 0.36/14 0.92/12   55/11 3,67 1.59/27 2.00/8 1.15/13 2.00/14
2020-10-18 Kristiansund 0-0 Rosenborg 57/12 3,64 1.64/28 2.00/8 1.15/13 2.07/15   55/21 3,30 1.85/27 2.50/8 1.71/14 2.00/13
2020-10-25 Valerenga 1-1 Kristiansund 46/5 3,22 1.63/27 1.88/8 1.71/14 1.54/13   57/12 3,52 1.62/29 1.75/8 1.14/14 2.07/15
2020-11-01 Kristiansund 2-3 Bodo/Glimt 58/12 3,47 1.60/30 1.88/8 1.14/14 2.00/16   89/48 4,33 2.37/30 2.63/8 2.20/15 2.53/15
2020-11-08 Molde 2-2 Kristiansund 73/29 3,77 1.87/31 1.88/8 1.80/15 1.94/16   60/11 3,52 1.55/31 1.50/8 1.07/15 2.00/16
2020-11-22 Kristiansund 1-0 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
2020-11-29 Kristiansund 2-1 Stromsgodset 63/12 3,45 1.58/33 1.63/8 1.19/16 1.94/17   47/-16 3,33 1.09/33 0.50/8 0.82/17 1.38/16
2020-12-02 Sarpsborg 08 1-1 Kristiansund 48/1 2,88 1.33/33 0.75/8 1.27/15 1.39/18   65/13 3,44 1.62/34 1.63/8 1.29/17 1.94/17
2020-12-09 Kristiansund 4-3 Odd 66/13 3,40 1.60/35 1.63/8 1.29/17 1.89/18   61/8 3,45 1.64/33 1.38/8 1.53/17 1.75/16
2020-12-13 Stabaek 2-2 Kristiansund 51/-8 3,06 1.31/36 1.25/8 1.11/18 1.50/18   70/14 3,50 1.64/36 1.63/8 1.39/18 1.89/18
2020-12-22 Kristiansund 1-3 Haugesund 72/14 3,51 1.62/37 1.63/8 1.39/18 1.84/19   52/-14 3,19 1.30/37 1.38/8 1.11/19 1.50/18