SELECT * FROM 1_Kampe WHERE LigaID = '227' 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
2018-10-21 Brann 1-3 Haugesund 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 Mjondalen 1-3 Brann 3/2 4,00 3.00/1 1.50/8 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.29/7 0.00/1 0.00/0
2018-10-21 Brann 1-3 Kristiansund 4/0 4,00 1.50/2 1.29/7 0.00/1 3.00/1   4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1
2018-10-21 Brann 1-3 Bodo/Glimt 5/-2 4,00 1.00/3 1.29/7 0.00/2 3.00/1   8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2
2018-10-21 Sandefjord 1-3 Brann 11/2 4,00 1.80/5 1.50/8 0.00/2 3.00/3   6/-4 4,00 0.75/4 1.29/7 0.00/3 3.00/1
2018-10-21 Brann 1-3 Stabaek 9/-2 4,00 1.20/5 1.29/7 0.00/3 3.00/2   12/0 4,00 1.50/6 1.50/8 0.00/3 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-17 Haugesund 1-2 Brann 16/0 4,00 1.50/8 1.50/8 0.00/4 3.00/4   13/-2 4,00 1.29/7 1.29/7 0.00/4 3.00/3
2020-06-21 Brann 3-0 Viking 15/-1 3,88 1.50/8 1.50/8 0.00/4 3.00/4   18/-2 4,22 1.33/9 1.13/8 0.00/5 3.00/4
2020-06-24 Aalesund 2-2 Brann 16/-10 4,67 1.00/9 1.13/8 0.00/5 2.25/4   18/2 3,78 1.67/9 1.50/8 0.60/5 3.00/4
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-02 Sarpsborg 08 0-1 Brann 20/2 3,45 1.36/11 1.13/8 0.00/4 2.14/7   21/1 3,73 1.45/11 1.25/8 0.50/6 2.60/5
2020-07-05 Bodo/Glimt 5-0 Brann 35/13 4,38 2.08/13 2.63/8 1.00/6 3.00/7   22/2 3,50 1.58/12 1.63/8 0.50/6 2.67/6
2020-07-12 Brann 3-1 Sandefjord 22/-3 3,62 1.46/13 1.63/8 0.50/6 2.29/7   20/-7 3,36 1.14/14 0.88/8 0.14/7 2.14/7
2020-07-15 Odd 1-0 Brann 28/3 3,53 1.47/15 1.63/8 0.50/8 2.57/7   25/-1 3,64 1.57/14 2.00/8 0.86/7 2.29/7
2020-07-19 Brann 1-1 Start 25/-2 3,47 1.47/15 1.63/8 0.86/7 2.00/8   23/-8 3,38 1.00/16 0.50/8 0.33/9 1.86/7
2020-07-25 Brann 1-1 Kristiansund 26/-2 3,38 1.44/16 1.38/8 0.88/8 2.00/8   33/4 3,65 1.35/17 1.25/8 0.63/8 2.00/9
2020-07-29 Stromsgodset 3-1 Brann 27/-8 3,44 1.33/18 1.00/8 0.89/9 1.78/9   27/-2 3,29 1.41/17 1.13/8 0.89/9 2.00/8
2020-08-01 Brann 1-2 Valerenga 28/-4 3,33 1.33/18 1.00/8 0.89/9 1.78/9   24/-4 3,06 1.47/17 1.88/8 1.22/9 1.75/8
2020-08-10 Molde 1-2 Brann 55/26 4,00 2.05/21 2.25/8 1.80/10 2.27/11   29/-5 3,32 1.26/19 1.00/8 0.80/10 1.78/9
2020-08-16 Brann 0-1 Mjondalen 31/-4 3,30 1.35/20 1.00/8 0.80/10 1.90/10   27/-7 2,90 1.10/21 0.38/8 0.60/10 1.55/11
2020-08-24 Stabaek 0-2 Brann 35/-2 3,27 1.36/22 1.25/8 0.82/11 1.91/11   31/-5 3,19 1.29/21 1.00/8 0.73/11 1.90/10
2020-08-29 Brann 1-1 Stromsgodset 33/-3 3,14 1.36/22 1.00/8 0.73/11 2.00/11   38/-9 3,70 1.30/23 1.13/8 0.92/12 1.73/11
2020-09-13 Valerenga 5-1 Brann 32/-4 3,09 1.45/22 1.38/8 1.36/11 1.55/11   34/-3 3,09 1.35/23 1.13/8 0.75/12 2.00/11
2020-09-20 Brann 1-3 Bodo/Glimt 35/-7 3,21 1.29/24 1.00/8 0.75/12 1.83/12   78/43 4,52 2.36/25 2.50/8 2.00/12 2.69/13
2020-09-27 Kristiansund 1-1 Brann 54/11 3,73 1.62/26 2.25/8 1.17/12 2.00/14   36/-9 3,24 1.24/25 0.88/8 0.69/13 1.83/12
2020-10-04 Brann 1-2 Molde 37/-9 3,19 1.23/26 1.00/8 0.69/13 1.77/13   62/23 3,74 1.70/27 0.75/8 1.62/13 1.79/14
2020-10-17 Mjondalen 2-0 Brann 31/-21 2,96 0.93/28 0.75/8 0.46/13 1.33/15   38/-10 3,19 1.19/27 1.00/8 0.64/14 1.77/13
2020-10-24 Brann 1-1 Stabaek 38/-12 3,14 1.14/28 0.63/8 0.64/14 1.64/14   45/-3 3,21 1.38/29 1.38/8 1.20/15 1.57/14
2020-11-01 Sandefjord 3-3 Brann 38/-12 2,93 1.27/30 1.25/8 0.79/14 1.69/16   39/-12 3,10 1.14/29 0.75/8 0.67/15 1.64/14
2020-11-07 Brann 1-2 Haugesund 42/-12 3,20 1.13/30 0.50/8 0.67/15 1.60/15   43/-10 3,10 1.29/31 1.25/8 1.06/16 1.53/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-28 Brann 3-1 Aalesund 46/-12 3,25 1.16/32 0.75/8 0.63/16 1.69/16   40/-47 3,97 0.63/32 0.50/8 0.35/17 0.93/15
2020-12-02 Viking 2-0 Brann 64/3 3,68 1.50/34 1.75/8 1.24/17 1.76/17   49/-10 3,27 1.21/33 1.13/8 0.76/17 1.69/16
2020-12-06 Brann 1-1 Sarpsborg 08 49/-12 3,24 1.18/34 1.00/8 0.76/17 1.59/17   49/1 2,85 1.32/34 0.75/8 1.25/16 1.39/18
2020-12-09 Start 1-1 Brann 48/-19 3,19 1.06/36 1.00/8 1.11/18 1.00/18   50/-12 3,20 1.17/35 1.13/8 0.78/18 1.59/17
2020-12-22 Brann 2-1 Odd 51/-12 3,17 1.17/36 1.25/8 0.78/18 1.56/18   67/2 3,57 1.49/37 0.63/8 1.37/19 1.61/18