SELECT * FROM 1_Kampe WHERE LigaID = '227' AND (Home='Rosenborg' OR Away='Rosenborg') 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 Aalesund 1-3 Rosenborg 3/2 4,00 3.00/1 1.29/7 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.71/7 0.00/1 0.00/0
2018-10-21 Stromsgodset 1-3 Rosenborg 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   4/0 4,00 1.50/2 1.71/7 0.00/1 3.00/1
2018-10-21 Odd 1-3 Rosenborg 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   7/2 4,00 2.00/3 1.71/7 0.00/1 3.00/2
2018-10-21 Rosenborg 1-3 Molde 10/4 4,00 2.25/4 1.71/7 0.00/1 3.00/3   9/-2 4,00 1.20/5 1.50/8 0.00/3 3.00/2
2018-10-21 Haugesund 1-3 Rosenborg 12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3   11/2 4,00 1.80/5 1.71/7 0.00/2 3.00/3
2018-10-21 Rosenborg 1-3 Brann 14/4 4,00 2.00/6 1.71/7 0.00/2 3.00/4   10/-4 4,00 1.00/6 1.29/7 0.00/4 3.00/2
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-20 Molde 1-0 Rosenborg 20/3 4,11 1.67/9 1.50/8 0.00/4 3.00/5   15/2 3,50 1.63/8 1.63/8 0.25/4 3.00/4
2020-06-25 Rosenborg 2-3 Bodo/Glimt 15/1 3,22 1.44/9 1.63/8 0.25/4 2.40/5   26/7 4,50 1.80/10 1.88/8 0.60/5 3.00/5
2020-06-28 Brann 1-2 Rosenborg 20/2 3,80 1.60/10 1.63/8 0.60/5 2.60/5   17/0 3,40 1.30/10 1.63/8 0.20/5 2.40/5
2020-07-01 Rosenborg 1-1 Valerenga 19/1 3,36 1.45/11 1.63/8 0.20/5 2.50/6   16/-5 3,70 1.30/10 1.63/8 0.67/6 2.25/4
2020-07-05 Stabaek 0-3 Rosenborg 23/1 3,46 1.54/13 1.75/8 1.00/7 2.17/6   20/1 3,25 1.42/12 1.38/8 0.33/6 2.50/6
2020-07-11 Rosenborg 3-0 Stromsgodset 23/4 3,23 1.54/13 1.38/8 0.33/6 2.57/7   25/0 3,57 1.50/14 1.13/8 0.71/7 2.29/7
2020-07-16 Start 0-0 Rosenborg 23/-8 3,60 1.00/15 0.75/8 0.25/8 1.86/7   26/7 3,21 1.64/14 1.38/8 0.71/7 2.57/7
2020-07-19 Rosenborg 2-1 Sandefjord 26/7 3,00 1.60/15 1.50/8 0.71/7 2.38/8   22/-8 3,25 1.19/16 0.88/8 0.50/8 1.88/8
2020-07-26 Haugesund 1-0 Rosenborg 22/-10 3,18 1.18/17 1.00/8 0.44/9 2.00/8   28/8 3,00 1.69/16 1.75/8 1.00/8 2.38/8
2020-07-30 Rosenborg 3-0 Viking 28/7 2,88 1.59/17 1.75/8 1.00/8 2.11/9   29/-5 3,50 1.28/18 1.38/8 0.78/9 1.78/9
2020-08-02 Odd 2-1 Rosenborg 34/5 3,32 1.63/19 2.00/8 1.00/10 2.33/9   31/10 2,89 1.67/18 2.13/8 1.22/9 2.11/9
2020-08-09 Rosenborg 5-1 Sarpsborg 08 32/9 2,89 1.58/19 1.75/8 1.22/9 1.90/10   31/8 2,84 1.53/19 1.75/8 1.11/9 1.90/10
2020-08-16 Rosenborg 3-2 Aalesund 37/13 3,05 1.65/20 2.00/8 1.40/10 1.90/10   31/-24 4,30 0.80/20 0.63/8 0.45/11 1.22/9
2020-08-22 Mjondalen 0-2 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
2020-08-30 Rosenborg 2-2 Stabaek 42/16 3,09 1.77/22 2.00/8 1.55/11 2.00/11   35/-4 3,22 1.30/23 0.88/8 0.75/12 1.91/11
2020-09-13 Stromsgodset 3-3 Rosenborg 39/-9 3,63 1.29/24 0.88/8 0.92/12 1.67/12   44/16 3,13 1.74/23 2.00/8 1.50/12 2.00/11
2020-09-20 Rosenborg 2-1 Haugesund 47/16 3,25 1.71/24 1.75/8 1.50/12 1.92/12   34/-7 3,00 1.32/25 1.63/8 1.00/13 1.67/12
2020-09-27 Aalesund 1-2 Rosenborg 36/-32 4,16 0.64/25 0.50/8 0.38/13 0.92/12   49/17 3,24 1.76/25 2.13/8 1.62/13 1.92/12
2020-10-04 Rosenborg 4-1 Odd 51/18 3,23 1.81/26 2.13/8 1.62/13 2.00/13   52/8 3,56 1.74/27 2.00/8 1.57/14 1.92/13
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 Sarpsborg 08 1-2 Rosenborg 42/4 2,86 1.50/28 1.63/8 1.46/13 1.53/15   55/21 3,18 1.82/28 2.25/8 1.71/14 1.93/14
2020-11-01 Rosenborg 1-0 Start 57/22 3,17 1.86/29 2.25/8 1.71/14 2.00/15   41/-16 3,27 1.03/30 1.25/8 1.00/16 1.07/14
2020-11-08 Viking 3-0 Rosenborg 55/-4 3,68 1.35/31 1.75/8 1.00/15 1.69/16   58/23 3,10 1.90/30 2.25/8 1.80/15 2.00/15
2020-11-24 Rosenborg 2-3 Brann 58/20 3,10 1.84/31 2.13/8 1.80/15 1.88/16   43/-13 3,19 1.10/31 0.38/8 0.63/16 1.60/15
2020-11-29 Bodo/Glimt 5-1 Rosenborg 101/57 4,39 2.42/33 2.63/8 2.25/16 2.59/17   60/19 3,16 1.78/32 2.00/8 1.69/16 1.88/16
2020-12-07 Valerenga 1-0 Rosenborg 54/9 3,00 1.64/33 2.00/8 1.71/17 1.56/16   61/15 3,24 1.73/33 1.63/8 1.69/16 1.76/17
2020-12-10 Rosenborg 1-0 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
2020-12-13 Rosenborg 3-1 Molde 62/15 3,11 1.71/35 1.25/8 1.76/17 1.67/18   83/35 3,74 1.94/35 2.75/8 1.89/18 2.00/17
2020-12-22 Sandefjord 0-0 Rosenborg 47/-12 2,86 1.24/37 1.38/8 0.83/18 1.63/19   65/17 3,14 1.75/36 1.50/8 1.83/18 1.67/18