SELECT * FROM 1_Kampe WHERE LigaID = '234' AND (Home='Sogndal' OR Away='Sogndal') 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-17 Sogndal 2-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
2013-04-01 Valerenga 1-0 Sogndal 1/-2 4,00 0.00/1 0.00/1 0.00/0 0.00/1   2/0 4,00 1.00/1 1.00/1 1.00/1 0.00/0
2013-04-07 Sogndal 0-4 Rosenborg 2/-1 2,50 0.50/2 0.50/2 1.00/1 0.00/1   5/5 2,50 3.00/2 3.00/2 3.00/1 3.00/1
2013-04-13 Molde 1-2 Sogndal 2/-3 2,33 0.00/3 0.00/3 0.00/1 0.00/2   2/-5 3,00 0.33/3 0.33/3 0.50/2 0.00/1
2013-04-21 Sogndal 0-0 Sarpsborg 08 4/-4 3,00 1.00/4 1.00/4 0.50/2 1.50/2   5/-1 2,75 1.25/4 1.25/4 1.50/2 1.00/2
2013-04-28 Viking 4-1 Sogndal 5/0 2,00 1.80/5 1.80/5 3.00/2 1.00/3   4/-4 2,40 1.00/5 1.00/5 0.67/3 1.50/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 Lillestrom 2-2 Sogndal 10/1 2,71 1.43/7 1.43/7 1.75/4 1.00/3   8/-5 3,00 1.14/7 1.14/7 1.25/4 1.00/3
2013-05-12 Sogndal 2-0 Odd 10/-5 3,13 1.13/8 1.13/8 1.25/4 1.00/4   7/-2 2,00 1.00/8 1.00/8 1.60/5 0.00/3
2013-05-16 Stromsgodset 3-1 Sogndal 15/9 2,33 2.22/9 2.13/8 2.60/5 1.75/4   12/-3 3,00 1.33/9 1.38/8 1.60/5 1.00/4
2013-05-20 Haugesund 0-1 Sogndal 15/4 2,60 1.70/10 2.00/8 2.25/4 1.33/6   13/-5 3,10 1.20/10 1.38/8 1.60/5 0.80/5
2013-05-26 Sogndal 1-1 Start 14/-4 2,91 1.36/11 1.75/8 1.60/5 1.17/6   14/-8 3,27 1.09/11 0.88/8 1.33/6 0.80/5
2013-06-23 Sandnes 1-3 Sogndal 9/-7 2,08 0.83/12 0.75/8 0.50/6 1.17/6   15/-4 2,83 1.33/12 1.50/8 1.50/6 1.17/6
2013-06-29 Sogndal 1-1 Honefoss 18/-2 2,92 1.46/13 1.75/8 1.50/6 1.43/7   15/-4 2,62 1.08/13 1.25/8 1.33/6 0.86/7
2013-07-06 Aalesund 2-2 Sogndal 28/9 3,36 1.71/14 1.38/8 2.43/7 1.00/7   19/-2 2,86 1.43/14 1.88/8 1.43/7 1.43/7
2013-07-14 Tromso 2-2 Sogndal 23/3 2,87 1.27/15 1.13/8 2.14/7 0.50/8   21/-2 2,93 1.40/15 1.63/8 1.43/7 1.38/8
2013-07-28 Sogndal 1-1 Haugesund 23/-2 3,00 1.38/16 1.63/8 1.43/7 1.33/9   20/-3 2,69 1.44/16 1.50/8 1.88/8 1.00/8
2013-08-04 Rosenborg 2-0 Sogndal 32/17 2,76 2.18/17 2.50/8 2.22/9 2.13/8   24/-2 2,94 1.35/17 1.38/8 1.38/8 1.33/9
2013-08-10 Sogndal 1-2 Molde 24/-4 2,89 1.28/18 1.38/8 1.38/8 1.20/10   27/1 2,94 1.17/18 1.88/8 1.44/9 0.89/9
2013-08-18 Sarpsborg 08 0-1 Sogndal 25/-17 3,53 0.89/19 0.38/8 1.22/9 0.60/10   25/-5 2,89 1.21/19 1.00/8 1.22/9 1.20/10
2013-08-24 Sogndal 1-0 Viking 26/-4 2,80 1.30/20 1.25/8 1.22/9 1.36/11   28/7 2,45 1.70/20 1.38/8 2.20/10 1.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-14 Sogndal 1-2 Lillestrom 27/-4 2,64 1.32/22 1.13/8 1.40/10 1.25/12   27/-3 2,59 1.27/22 1.63/8 1.73/11 0.82/11
2013-09-22 Start 2-0 Sogndal 35/-6 3,30 1.09/23 1.38/8 1.18/11 1.00/12   28/-5 2,65 1.26/23 1.00/8 1.27/11 1.25/12
2013-09-27 Sogndal 0-5 Stromsgodset 28/-7 2,63 1.21/24 0.88/8 1.27/11 1.15/13   53/28 3,25 1.96/24 1.88/8 2.67/12 1.25/12
2013-10-06 Odd 0-0 Sogndal 33/3 2,52 1.28/25 1.38/8 1.75/12 0.85/13   28/-12 2,72 1.16/25 0.75/8 1.17/12 1.15/13
2013-10-20 Sogndal 1-2 Valerenga 28/-12 2,62 1.15/26 0.88/8 1.17/12 1.14/14   36/-10 3,15 1.15/26 0.63/8 1.38/13 0.92/13
2013-10-27 Sogndal 2-1 Sandnes 29/-13 2,63 1.11/27 0.88/8 1.08/13 1.14/14   32/-21 3,15 1.11/27 1.00/8 1.14/14 1.08/13
2013-11-03 Honefoss 3-1 Sogndal 29/-14 2,57 0.93/28 1.25/8 0.93/14 0.93/14   31/-12 2,64 1.18/28 0.88/8 1.21/14 1.14/14
2013-11-10 Sogndal 1-2 Aalesund 32/-14 2,69 1.14/29 0.50/8 1.21/14 1.07/15   53/10 3,31 1.59/29 1.00/8 1.73/15 1.43/14