SELECT * FROM 1_Kampe WHERE LigaID = '228' AND (Home='Brann' OR Away='Brann') 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 Odd 3-2 Brann 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 Brann 1-1 Stromsgodset 2/-1 5,00 0.00/1 0.00/1 0.00/0 0.00/1   3/1 5,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-13 Viking 2-1 Brann 4/4 2,00 3.00/2 3.00/2 3.00/1 3.00/1   5/0 3,33 1.33/3 1.33/3 2.00/2 0.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-28 Tromso 1-2 Brann 4/-4 3,00 1.00/4 1.00/4 0.00/1 1.33/3   7/-1 3,00 1.00/5 1.00/5 1.67/3 0.00/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 Stabaek 0-1 Brann 6/-3 2,50 1.17/6 1.17/6 2.33/3 0.00/3   9/-1 2,71 1.14/7 1.14/7 1.25/4 1.00/3
2019-05-16 Brann 2-1 Sarpsborg 08 10/0 2,50 1.38/8 1.38/8 1.25/4 1.50/4   5/-1 1,57 1.00/7 1.00/7 1.25/4 0.67/3
2019-05-19 Bodo/Glimt 1-2 Brann 18/7 3,63 2.13/8 2.13/8 2.50/4 1.75/4   12/1 2,56 1.56/9 1.75/8 1.60/5 1.50/4
2019-05-26 Brann 0-1 Rosenborg 14/2 2,60 1.70/10 2.00/8 1.60/5 1.80/5   7/-7 2,33 1.00/9 1.13/8 1.60/5 0.25/4
2019-06-15 Haugesund 1-1 Brann 16/7 2,50 1.50/10 1.75/8 1.20/5 1.80/5   14/1 2,45 1.55/11 1.63/8 1.33/6 1.80/5
2019-06-23 Brann 1-0 Lillestrom 15/1 2,42 1.50/12 1.75/8 1.33/6 1.67/6   10/-7 2,45 1.09/11 1.00/8 1.17/6 1.00/5
2019-06-30 Molde 1-1 Brann 32/20 3,38 2.15/13 2.25/8 3.00/6 1.43/7   16/2 2,31 1.62/13 2.00/8 1.57/7 1.67/6
2019-07-05 Brann 0-0 Mjondalen 17/2 2,29 1.57/14 1.75/8 1.57/7 1.57/7   18/-6 3,23 0.92/13 0.88/8 1.00/7 0.83/6
2019-07-21 Brann 2-1 Stabaek 17/2 2,13 1.53/15 1.88/8 1.50/8 1.57/7   13/-6 2,29 1.07/14 1.00/8 1.29/7 0.86/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-18 Mjondalen 2-1 Brann 24/-5 3,12 1.00/17 1.00/8 1.25/8 0.78/9   22/6 2,24 1.71/17 1.88/8 1.67/9 1.75/8
2019-08-25 Brann 2-3 Tromso 23/5 2,28 1.61/18 1.50/8 1.67/9 1.56/9   20/-16 3,11 1.00/18 1.38/8 1.22/9 0.78/9
2019-09-01 Lillestrom 1-3 Brann 25/-4 2,84 1.32/19 1.63/8 1.78/9 0.90/10   25/4 2,42 1.53/19 1.50/8 1.50/10 1.56/9
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-21 Brann 0-0 Haugesund 28/5 2,43 1.52/21 1.38/8 1.50/10 1.55/11   29/4 2,57 1.24/21 1.25/8 1.00/11 1.50/10
2019-09-28 Rosenborg 0-0 Brann 36/9 2,86 1.77/22 2.25/8 2.36/11 1.18/11   28/5 2,32 1.50/22 1.38/8 1.45/11 1.55/11
2019-10-06 Brann 0-0 Molde 28/5 2,22 1.48/23 1.38/8 1.45/11 1.50/12   54/31 3,35 2.26/23 2.75/8 2.64/11 1.92/12
2019-10-20 Sarpsborg 08 1-1 Brann 25/-7 2,38 0.96/24 1.13/8 1.33/12 0.58/12   28/5 2,13 1.46/24 1.13/8 1.42/12 1.50/12
2019-10-28 Brann 1-1 Bodo/Glimt 29/5 2,12 1.44/25 0.88/8 1.42/12 1.46/13   54/20 3,52 1.96/25 1.38/8 2.31/13 1.58/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-08 Brann 1-0 Odd 30/4 2,07 1.37/27 1.00/8 1.38/13 1.36/14   42/8 2,81 1.81/27 1.75/8 2.57/14 1.00/13
2019-11-24 Stromsgodset 6-0 Brann 33/-20 3,07 0.93/28 1.25/8 1.29/14 0.57/14   31/5 2,04 1.43/28 1.00/8 1.50/14 1.36/14
2019-12-01 Brann 1-5 Viking 31/-1 2,17 1.38/29 1.00/8 1.50/14 1.27/15   50/9 3,14 1.52/29 1.75/8 2.07/15 0.93/14