SELECT * FROM 1_Kampe WHERE LigaID = '228' 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
2019-03-31 Viking 2-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
2019-04-07 Kristiansund 2-0 Valerenga 0/-2 2,00 0.00/1 0.00/1 0.00/0 0.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2019-04-10 Brann 2-1 Kristiansund 3/-1 3,50 0.50/2 0.50/2 1.00/1 0.00/1   2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1
2019-04-14 Odd 2-0 Kristiansund 4/1 3,50 2.00/2 2.00/2 3.00/1 1.00/1   3/-1 2,33 1.00/3 1.00/3 3.00/1 0.00/2
2019-04-22 Kristiansund 0-0 Ranheim 3/-3 2,25 0.75/4 0.75/4 3.00/1 0.00/3   2/-4 2,67 0.00/3 0.00/3 0.00/2 0.00/1
2019-04-28 Stromsgodset 2-3 Kristiansund 6/0 3,00 1.25/4 1.25/4 1.50/2 1.00/2   3/-3 1,80 0.80/5 0.80/5 2.00/2 0.00/3
2019-05-05 Kristiansund 1-0 Tromso 6/-2 2,33 1.17/6 1.17/6 2.00/2 0.75/4   5/-5 3,00 0.80/5 0.80/5 0.00/2 1.33/3
2019-05-12 Sarpsborg 08 0-1 Kristiansund 5/0 1,67 1.17/6 1.17/6 1.67/3 0.67/3   7/-1 2,14 1.43/7 1.43/7 2.33/3 0.75/4
2019-05-16 Kristiansund 3-2 Molde 8/0 2,00 1.63/8 1.63/8 2.33/3 1.20/5   18/12 3,00 2.38/8 2.38/8 3.00/4 1.75/4
2019-05-19 Haugesund 0-0 Kristiansund 12/4 2,50 1.38/8 1.38/8 1.25/4 1.50/4   11/1 2,33 1.78/9 2.00/8 2.50/4 1.20/5
2019-06-16 Mjondalen 1-1 Kristiansund 15/-6 3,60 0.90/10 1.13/8 1.00/5 0.80/5   11/1 2,10 1.70/10 1.75/8 2.50/4 1.17/6
2019-06-23 Kristiansund 0-1 Stabaek 12/1 2,09 1.64/11 1.88/8 2.50/4 1.14/7   6/-8 2,22 0.78/9 0.75/8 1.40/5 0.00/4
2019-06-29 Rosenborg 1-0 Kristiansund 11/-4 2,17 1.25/12 1.63/8 1.83/6 0.67/6   12/0 2,00 1.50/12 1.88/8 2.00/5 1.14/7
2019-07-05 Kristiansund 5-2 Lillestrom 12/-1 1,92 1.38/13 1.75/8 2.00/5 1.00/8   14/-4 2,46 1.15/13 1.00/8 1.43/7 0.83/6
2019-08-04 Valerenga 1-1 Kristiansund 28/10 3,29 1.71/14 1.75/8 2.29/7 1.14/7   17/2 2,29 1.50/14 1.75/8 2.17/6 1.00/8
2019-08-11 Kristiansund 1-1 Odd 18/2 2,27 1.47/15 1.50/8 2.17/6 1.00/9   24/6 2,63 2.00/16 1.63/8 2.78/9 1.00/7
2019-08-14 Kristiansund 1-2 Bodo/Glimt 19/2 2,25 1.44/16 1.25/8 2.00/7 1.00/9   38/13 3,94 2.19/16 2.25/8 2.44/9 1.86/7
2019-08-18 Stabaek 2-0 Kristiansund 16/-7 2,29 1.00/17 1.25/8 1.22/9 0.75/8   20/1 2,29 1.35/17 0.88/8 1.75/8 1.00/9
2019-08-25 Kristiansund 4-0 Mjondalen 20/-1 2,28 1.28/18 0.75/8 1.75/8 0.90/10   26/-4 3,11 1.11/18 1.38/8 1.44/9 0.78/9
2019-09-01 Ranheim 1-2 Kristiansund 22/-12 2,95 1.00/19 0.75/8 0.78/9 1.20/10   24/3 2,37 1.37/19 1.00/8 1.89/9 0.90/10
2019-09-15 Kristiansund 1-0 Brann 26/4 2,40 1.45/20 1.38/8 1.89/9 1.09/11   28/6 2,50 1.60/20 1.75/8 1.50/10 1.70/10
2019-09-22 Lillestrom 1-1 Kristiansund 27/-8 2,95 1.19/21 1.25/8 1.60/10 0.82/11   27/5 2,33 1.52/21 1.75/8 2.00/10 1.09/11
2019-09-29 Kristiansund 2-2 Haugesund 28/5 2,32 1.50/22 1.50/8 2.00/10 1.08/12   29/4 2,45 1.23/22 1.25/8 1.00/11 1.45/11
2019-10-06 Tromso 5-0 Kristiansund 25/-23 3,17 0.96/23 0.75/8 1.09/11 0.83/12   30/5 2,39 1.48/23 1.50/8 1.91/11 1.08/12
2019-10-19 Kristiansund 2-2 Rosenborg 30/0 2,50 1.42/24 1.38/8 1.91/11 1.00/13   37/8 2,75 1.67/24 1.88/8 2.25/12 1.08/12
2019-10-27 Kristiansund 4-2 Viking 32/0 2,56 1.40/25 1.50/8 1.83/12 1.00/13   43/9 3,08 1.60/25 2.25/8 2.08/13 1.08/12
2019-11-02 Molde 2-0 Kristiansund 58/31 3,27 2.15/26 2.13/8 2.67/12 1.71/14   36/2 2,69 1.46/26 1.88/8 1.92/13 1.00/13
2019-11-10 Kristiansund 4-0 Sarpsborg 08 36/0 2,67 1.41/27 1.50/8 1.92/13 0.93/14   29/-6 2,37 1.04/27 1.63/8 1.43/14 0.62/13
2019-11-24 Bodo/Glimt 3-0 Kristiansund 59/19 3,54 1.82/28 1.13/8 2.21/14 1.43/14   40/4 2,71 1.46/28 1.50/8 2.00/14 0.93/14
2019-12-01 Kristiansund 1-2 Stromsgodset 40/1 2,72 1.41/29 1.13/8 2.00/14 0.87/15   39/-14 3,17 1.00/29 1.25/8 1.40/15 0.57/14