SELECT * FROM 1_Kampe WHERE LigaID = '228' AND (Home='Valerenga' OR Away='Valerenga') 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-30 Valerenga 2-0 Mjondalen 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 Molde 4-1 Valerenga 4/3 2,50 2.00/2 2.00/2 3.00/1 1.00/1   2/0 2,00 1.50/2 1.50/2 3.00/1 0.00/1
2019-04-14 Valerenga 4-1 Tromso 3/-3 3,00 1.00/3 1.00/3 3.00/1 0.00/2   2/-1 2,50 1.50/2 1.50/2 0.00/1 3.00/1
2019-04-22 Brann 1-1 Valerenga 6/-1 3,25 1.00/4 1.00/4 2.00/2 0.00/2   7/0 3,50 1.50/4 1.50/4 3.00/2 0.00/2
2019-04-29 Valerenga 1-0 Odd 8/0 3,20 1.40/5 1.40/5 3.00/2 0.33/3   7/4 2,50 2.50/4 2.50/4 3.00/3 1.00/1
2019-05-06 Viking 1-1 Valerenga 8/1 3,00 1.80/5 1.80/5 3.00/2 1.00/3   9/1 2,83 1.67/6 1.67/6 3.00/3 0.33/3
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 Valerenga 2-0 Stromsgodset 15/5 3,13 1.75/8 1.75/8 3.00/3 1.00/5   9/-2 2,86 0.86/7 0.86/7 1.00/4 0.67/3
2019-05-25 Valerenga 0-3 Lillestrom 17/7 3,00 1.89/9 1.75/8 3.00/4 1.00/5   7/-8 2,44 1.00/9 1.00/8 1.40/5 0.50/4
2019-06-16 Rosenborg 3-0 Valerenga 8/-6 2,20 1.20/10 1.38/8 1.60/5 0.80/5   17/4 3,00 1.70/10 1.75/8 2.40/5 1.00/5
2019-06-23 Valerenga 1-1 Sarpsborg 08 17/1 3,00 1.55/11 1.75/8 2.40/5 0.83/6   9/-2 2,00 1.00/10 1.00/8 1.33/6 0.50/4
2019-06-30 Haugesund 1-4 Valerenga 18/5 2,58 1.33/12 1.13/8 1.17/6 1.50/6   18/1 2,92 1.50/12 1.50/8 2.17/6 0.83/6
2019-07-05 Valerenga 6-0 Bodo/Glimt 22/4 3,08 1.62/13 1.75/8 2.17/6 1.14/7   28/12 3,67 2.17/12 2.00/8 2.29/7 2.00/5
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 Stromsgodset 3-2 Valerenga 16/-14 2,88 0.63/16 0.50/8 0.88/8 0.38/8   29/10 3,20 1.67/15 1.75/8 2.13/8 1.14/7
2019-08-14 Stabaek 1-1 Valerenga 15/-7 2,31 1.00/16 1.13/8 1.25/8 0.75/8   31/9 3,31 1.56/16 1.38/8 2.13/8 1.00/8
2019-08-18 Valerenga 1-2 Haugesund 32/9 3,24 1.53/17 1.13/8 2.13/8 1.00/9   25/5 2,65 1.24/17 1.13/8 1.11/9 1.38/8
2019-08-26 Bodo/Glimt 4-0 Valerenga 41/14 3,78 2.17/18 2.38/8 2.44/9 1.89/9   33/8 3,22 1.44/18 1.13/8 1.89/9 1.00/9
2019-09-01 Valerenga 1-1 Rosenborg 33/4 3,26 1.37/19 1.13/8 1.89/9 0.90/10   30/6 2,84 1.68/19 2.13/8 2.30/10 1.00/9
2019-09-16 Sarpsborg 08 1-0 Valerenga 22/-7 2,55 0.80/20 0.50/8 1.20/10 0.40/10   34/4 3,20 1.35/20 1.13/8 1.80/10 0.90/10
2019-09-22 Valerenga 0-4 Viking 34/3 3,10 1.29/21 0.75/8 1.80/10 0.82/11   33/1 3,10 1.43/21 1.38/8 1.91/11 0.90/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-05 Odd 1-1 Valerenga 37/10 2,78 1.91/23 1.88/8 2.67/12 1.09/11   35/-1 3,09 1.22/23 0.38/8 1.58/12 0.82/11
2019-10-19 Valerenga 0-2 Stabaek 36/-1 3,04 1.21/24 0.50/8 1.58/12 0.83/12   26/-6 2,42 1.08/24 1.25/8 1.38/13 0.73/11
2019-10-26 Lillestrom 0-0 Valerenga 30/-9 2,76 1.12/25 0.88/8 1.50/12 0.77/13   36/-3 3,00 1.16/25 0.38/8 1.46/13 0.83/12
2019-11-03 Valerenga 1-0 Brann 36/-3 2,88 1.15/26 0.50/8 1.46/13 0.85/13   30/5 2,12 1.42/26 1.00/8 1.38/13 1.46/13
2019-11-10 Tromso 0-0 Valerenga 37/-18 3,41 1.04/27 0.88/8 1.38/13 0.71/14   37/-2 2,81 1.22/27 0.88/8 1.57/14 0.85/13
2019-11-24 Valerenga 2-4 Molde 37/-2 2,71 1.21/28 0.88/8 1.57/14 0.86/14   64/37 3,25 2.21/28 2.38/8 2.71/14 1.71/14
2019-12-01 Mjondalen 1-0 Valerenga 37/-15 3,07 0.93/29 0.75/8 1.29/14 0.60/15   39/-4 2,83 1.17/29 0.88/8 1.47/15 0.86/14