SELECT * FROM 1_Kampe WHERE LigaID = '234' 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
2013-03-16 Brann 3-1 Valerenga 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
2013-04-01 Rosenborg 4-0 Brann 1/1 1,00 3.00/1 3.00/1 0.00/0 3.00/1   3/2 4,00 3.00/1 3.00/1 3.00/1 0.00/0
2013-04-06 Brann 1-0 Molde 3/-2 4,00 1.50/2 1.50/2 3.00/1 0.00/1   2/-2 3,00 0.00/2 0.00/2 0.00/1 0.00/1
2013-04-14 Lillestrom 2-0 Brann 4/0 2,67 1.33/3 1.33/3 0.50/2 3.00/1   4/-1 3,00 2.00/3 2.00/3 3.00/2 0.00/1
2013-04-20 Brann 2-0 Viking 4/-3 2,75 1.50/4 1.50/4 3.00/2 0.00/2   5/2 2,00 2.25/4 2.25/4 3.00/2 1.50/2
2013-04-26 Brann 2-0 Odd 6/-1 2,60 1.80/5 1.80/5 3.00/3 0.00/2   4/-1 1,80 0.80/5 0.80/5 1.33/3 0.00/2
2013-05-05 Sogndal 3-1 Brann 5/-7 2,83 0.83/6 0.83/6 0.67/3 1.00/3   8/1 2,50 2.00/6 2.00/6 3.00/4 0.00/2
2013-05-09 Brann 2-0 Start 9/-1 2,71 1.71/7 1.71/7 3.00/4 0.00/3   12/0 3,43 1.29/7 1.29/7 2.00/4 0.33/3
2013-05-12 Stromsgodset 2-0 Brann 13/7 2,38 2.13/8 2.13/8 2.50/4 1.75/4   11/1 2,63 1.88/8 1.88/8 3.00/5 0.00/3
2013-05-16 Brann 2-0 Aalesund 11/-1 2,56 1.67/9 1.50/8 3.00/5 0.00/4   21/9 3,67 1.89/9 1.75/8 2.20/5 1.50/4
2013-05-20 Tromso 2-0 Brann 15/3 2,70 1.30/10 1.13/8 2.25/4 0.67/6   13/1 2,50 1.80/10 1.88/8 3.00/6 0.00/4
2013-05-26 Brann 3-1 Sarpsborg 08 13/-1 2,45 1.64/11 1.50/8 3.00/6 0.00/5   15/-6 3,27 1.27/11 1.13/8 1.60/5 1.00/6
2013-06-23 Haugesund 2-1 Brann 15/0 2,50 1.42/12 1.25/8 1.80/5 1.14/7   16/1 2,58 1.75/12 1.88/8 3.00/7 0.00/5
2013-06-29 Brann 6-1 Sandnes 17/0 2,62 1.62/13 1.50/8 3.00/7 0.00/6   10/-9 2,23 0.77/13 0.63/8 0.43/7 1.17/6
2013-07-08 Honefoss 1-1 Brann 16/-4 2,57 1.07/14 1.25/8 1.33/6 0.88/8   23/5 2,93 1.71/14 1.50/8 3.00/8 0.00/6
2013-07-13 Start 3-3 Brann 19/-11 3,27 0.93/15 0.63/8 1.29/7 0.63/8   24/5 2,87 1.67/15 1.63/8 3.00/8 0.14/7
2013-07-28 Brann 1-4 Rosenborg 27/5 3,06 1.63/16 1.38/8 3.00/8 0.25/8   28/14 2,63 2.13/16 2.50/8 2.22/9 2.00/7
2013-08-03 Molde 2-0 Brann 25/-1 3,00 1.06/17 1.50/8 1.25/8 0.89/9   28/2 3,18 1.53/17 1.38/8 2.67/9 0.25/8
2013-08-09 Brann 1-1 Lillestrom 28/0 3,11 1.44/18 1.00/8 2.67/9 0.22/9   23/-4 2,78 1.22/18 1.25/8 1.67/9 0.78/9
2013-08-18 Viking 3-2 Brann 25/6 2,32 1.63/19 1.38/8 2.11/9 1.20/10   29/0 3,05 1.42/19 1.13/8 2.50/10 0.22/9
2013-08-24 Odd 1-3 Brann 24/3 2,25 1.30/20 1.88/8 1.80/10 0.80/10   31/-1 3,15 1.35/20 0.75/8 2.50/10 0.20/10
2013-08-30 Brann 1-0 Sogndal 34/1 3,19 1.43/21 1.13/8 2.50/10 0.45/11   27/-3 2,71 1.38/21 1.25/8 1.40/10 1.36/11
2013-09-15 Valerenga 4-3 Brann 30/-8 3,09 1.23/22 1.25/8 1.36/11 1.09/11   35/2 3,09 1.50/22 1.13/8 2.55/11 0.45/11
2013-09-21 Brann 1-1 Stromsgodset 38/1 3,26 1.43/23 1.00/8 2.55/11 0.42/12   52/28 3,30 2.00/23 1.75/8 2.67/12 1.27/11
2013-09-28 Aalesund 0-0 Brann 48/8 3,67 1.58/24 1.25/8 1.83/12 1.33/12   39/1 3,21 1.42/24 1.00/8 2.42/12 0.42/12
2013-10-04 Brann 0-1 Haugesund 39/1 3,08 1.40/25 1.13/8 2.42/12 0.46/13   32/1 2,52 1.56/25 1.88/8 2.00/13 1.08/12
2013-10-18 Sarpsborg 08 3-2 Brann 33/-19 3,27 0.92/26 0.88/8 1.31/13 0.54/13   39/0 3,00 1.35/26 1.13/8 2.23/13 0.46/13
2013-10-27 Brann 0-0 Honefoss 41/-1 3,07 1.30/27 1.00/8 2.23/13 0.43/14   29/-14 2,67 0.93/27 1.13/8 0.93/14 0.92/13
2013-11-03 Sandnes 3-1 Brann 33/-22 3,14 1.07/28 0.63/8 1.14/14 1.00/14   41/-1 2,96 1.29/28 1.13/8 2.14/14 0.43/14
2013-11-10 Brann 4-1 Tromso 42/-3 3,00 1.24/29 0.75/8 2.14/14 0.40/15   40/-6 2,97 1.00/29 1.00/8 1.67/15 0.29/14