SELECT * FROM 1_Kampe WHERE LigaID = '228' AND (Home='Ranheim' OR Away='Ranheim') 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 Ranheim 1-2 Tromso 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 Lillestrom 2-1 Ranheim 1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1   1/-1 3,00 0.00/1 0.00/1 0.00/1 0.00/0
2019-04-14 Ranheim 0-2 Haugesund 2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1   3/-1 3,50 0.50/2 0.50/2 1.00/1 0.00/1
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 Ranheim 5-2 Viking 2/-4 2,00 0.25/4 0.25/4 0.00/2 0.50/2   6/4 2,00 2.25/4 2.25/4 3.00/2 1.50/2
2019-05-05 Brann 0-1 Ranheim 9/0 3,00 1.33/6 1.33/6 1.67/3 1.00/3   7/-1 3,00 0.80/5 0.80/5 1.00/3 0.50/2
2019-05-12 Ranheim 1-5 Valerenga 8/0 2,67 1.17/6 1.17/6 1.00/3 1.33/3   10/1 2,71 1.57/7 1.57/7 3.00/3 0.50/4
2019-05-16 Odd 1-0 Ranheim 11/5 2,43 2.29/7 2.29/7 3.00/4 1.33/3   9/-4 3,14 1.00/7 1.00/7 0.75/4 1.33/3
2019-05-19 Sarpsborg 08 1-3 Ranheim 6/-2 1,75 0.88/8 0.88/8 1.25/4 0.50/4   9/-5 2,88 0.88/8 0.88/8 0.75/4 1.00/4
2019-05-26 Ranheim 1-0 Stromsgodset 12/-3 3,00 1.11/9 1.25/8 0.75/4 1.40/5   12/-2 2,89 1.00/9 0.75/8 1.40/5 0.50/4
2019-06-16 Molde 2-0 Ranheim 26/14 3,45 2.00/11 1.88/8 3.00/5 1.17/6   13/-2 2,80 1.30/10 1.63/8 1.20/5 1.40/5
2019-06-23 Ranheim 1-1 Mjondalen 13/-4 2,73 1.18/11 1.63/8 1.20/5 1.17/6   16/-6 3,45 0.91/11 0.88/8 1.00/6 0.80/5
2019-06-30 Stabaek 0-0 Ranheim 7/-7 2,10 1.00/10 1.13/8 1.40/5 0.60/5   14/-4 2,67 1.17/12 1.63/8 1.17/6 1.17/6
2019-07-04 Ranheim 2-3 Rosenborg 14/-4 2,46 1.15/13 1.38/8 1.17/6 1.14/7   12/-3 2,08 1.38/13 2.00/8 2.00/7 0.67/6
2019-07-13 Bodo/Glimt 5-1 Ranheim 28/6 3,85 2.00/13 2.00/8 2.29/7 1.67/6   16/-5 2,64 1.07/14 1.00/8 1.00/7 1.14/7
2019-08-04 Ranheim 0-3 Brann 17/-9 2,87 1.00/15 1.00/8 1.00/7 1.00/8   19/3 2,19 1.63/16 1.88/8 1.67/9 1.57/7
2019-08-11 Haugesund 0-1 Ranheim 25/6 2,75 1.31/16 1.25/8 1.25/8 1.38/8   17/-12 2,88 0.94/16 1.00/8 0.88/8 1.00/8
2019-08-18 Ranheim 2-3 Molde 18/-11 2,76 1.06/17 1.00/8 0.88/8 1.22/9   39/23 3,24 2.12/17 2.13/8 2.75/8 1.56/9
2019-08-25 Viking 2-2 Ranheim 27/-1 3,06 1.39/18 1.00/8 1.89/9 0.89/9   20/-12 2,89 1.00/18 0.63/8 0.78/9 1.22/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 Stromsgodset 1-0 Ranheim 22/-17 3,05 0.80/20 0.88/8 1.30/10 0.30/10   23/-13 2,95 0.95/20 0.63/8 0.70/10 1.20/10
2019-09-22 Ranheim 1-1 Bodo/Glimt 23/-14 2,86 0.90/21 0.50/8 0.70/10 1.09/11   49/16 3,90 2.05/21 2.13/8 2.36/11 1.70/10
2019-09-29 Valerenga 1-1 Ranheim 34/-1 3,14 1.23/22 0.38/8 1.64/11 0.82/11   24/-14 2,82 0.91/22 0.63/8 0.73/11 1.09/11
2019-10-06 Ranheim 0-2 Sarpsborg 08 25/-14 2,78 0.91/23 0.75/8 0.73/11 1.08/12   23/-9 2,39 0.87/23 0.88/8 1.33/12 0.36/11
2019-10-20 Ranheim 4-1 Odd 25/-16 2,75 0.88/24 0.75/8 0.67/12 1.08/12   38/10 2,75 1.88/24 1.63/8 2.54/13 1.09/11
2019-10-27 Tromso 4-2 Ranheim 31/-19 3,24 1.00/25 1.00/8 1.25/12 0.77/13   29/-13 2,84 0.96/25 0.75/8 0.85/13 1.08/12
2019-11-03 Ranheim 0-2 Stabaek 31/-15 2,96 0.92/26 0.75/8 0.85/13 1.00/13   28/-4 2,31 1.15/26 1.25/8 1.36/14 0.92/12
2019-11-10 Mjondalen 3-1 Ranheim 32/-15 2,93 0.89/27 0.50/8 1.15/13 0.64/14   31/-17 2,93 0.89/27 0.63/8 0.79/14 1.00/13
2019-11-24 Ranheim 2-1 Lillestrom 32/-19 2,96 0.86/28 0.63/8 0.79/14 0.93/14   31/-14 2,71 1.04/28 0.50/8 1.36/14 0.71/14
2019-12-01 Rosenborg 3-2 Ranheim 50/11 3,07 1.69/29 1.63/8 2.36/14 1.07/15   34/-18 2,97 0.93/29 1.00/8 0.93/15 0.93/14