SELECT * FROM 1_Kampe WHERE LigaID = '227' AND (Home='Sarpsborg 08' OR Away='Sarpsborg 08') 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 Valerenga 1-3 Sarpsborg 08 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 Sarpsborg 08 1-3 Stromsgodset 3/2 4,00 3.00/1 2.14/7 0.00/0 3.00/1   1/-2 4,00 0.00/1 1.50/8 0.00/1 0.00/0
2018-10-21 Molde 1-3 Sarpsborg 08 4/0 4,00 1.50/2 1.50/8 0.00/1 3.00/1   4/0 4,00 1.50/2 2.14/7 0.00/1 3.00/1
2018-10-21 Mjondalen 1-3 Sarpsborg 08 8/0 4,00 1.50/4 1.50/8 0.00/2 3.00/2   7/2 4,00 2.00/3 2.14/7 0.00/1 3.00/2
2018-10-21 Aalesund 1-3 Sarpsborg 08 8/0 4,00 1.50/4 1.29/7 0.00/2 3.00/2   10/4 4,00 2.25/4 2.14/7 0.00/1 3.00/3
2018-10-21 Sarpsborg 08 1-3 Bodo/Glimt 13/6 4,00 2.40/5 2.14/7 0.00/1 3.00/4   12/0 4,00 1.50/6 1.50/8 0.00/3 3.00/3
2018-10-21 Sandefjord 1-3 Sarpsborg 08 15/2 4,00 1.71/7 1.50/8 0.00/3 3.00/4   14/4 4,00 2.00/6 2.14/7 0.00/2 3.00/4
2020-06-16 Sarpsborg 08 0-1 Valerenga 17/6 4,00 2.14/7 2.14/7 0.00/2 3.00/5   10/-4 4,00 1.00/6 1.00/6 0.00/4 3.00/2
2020-06-20 Mjondalen 1-0 Sarpsborg 08 16/0 3,56 1.44/9 1.25/8 0.00/4 2.60/5   17/5 3,63 1.88/8 1.88/8 0.00/3 3.00/5
2020-06-25 Sarpsborg 08 2-3 Stromsgodset 17/4 3,33 1.67/9 1.50/8 0.00/3 2.50/6   19/1 3,70 1.60/10 2.00/8 0.60/5 2.60/5
2020-06-28 Bodo/Glimt 2-1 Sarpsborg 08 29/8 4,55 1.91/11 2.25/8 0.60/5 3.00/6   19/3 3,50 1.50/10 1.13/8 0.00/4 2.50/6
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 Sandefjord 0-3 Sarpsborg 08 20/-4 3,38 1.23/13 1.25/8 0.17/6 2.14/7   20/1 3,25 1.25/12 1.13/8 0.00/5 2.14/7
2020-07-12 Sarpsborg 08 1-0 Start 23/4 3,23 1.38/13 1.13/8 0.00/5 2.25/8   23/-7 3,79 1.07/14 0.75/8 0.25/8 2.17/6
2020-07-16 Stabaek 1-1 Sarpsborg 08 25/-1 3,40 1.53/15 1.38/8 0.88/8 2.29/7   24/5 3,07 1.50/14 1.13/8 0.50/6 2.25/8
2020-07-19 Sarpsborg 08 2-0 Odd 25/5 3,00 1.47/15 0.88/8 0.50/6 2.11/9   29/4 3,38 1.56/16 1.63/8 0.78/9 2.57/7
2020-07-26 Viking 3-0 Sarpsborg 08 26/-8 3,53 1.18/17 1.00/8 0.50/8 1.78/9   27/7 2,94 1.56/16 1.25/8 0.86/7 2.11/9
2020-07-29 Sarpsborg 08 0-0 Haugesund 27/4 2,94 1.47/17 1.25/8 0.86/7 1.90/10   23/-9 3,06 1.28/18 1.38/8 0.70/10 2.00/8
2020-08-02 Sarpsborg 08 4-0 Aalesund 27/4 2,78 1.44/18 1.38/8 0.88/8 1.90/10   29/-20 4,33 0.83/18 0.63/8 0.40/10 1.38/8
2020-08-09 Rosenborg 5-1 Sarpsborg 08 32/9 2,89 1.58/19 1.75/8 1.22/9 1.90/10   31/8 2,84 1.53/19 1.75/8 1.11/9 1.90/10
2020-08-15 Sarpsborg 08 2-1 Molde 32/4 3,00 1.45/20 1.75/8 1.11/9 1.73/11   56/25 3,95 1.95/22 1.88/8 1.64/11 2.27/11
2020-08-22 Kristiansund 4-1 Sarpsborg 08 43/7 3,59 1.50/22 1.38/8 1.10/10 1.83/12   34/5 3,00 1.52/21 1.75/8 1.30/10 1.73/11
2020-08-30 Sarpsborg 08 0-3 Bodo/Glimt 35/2 3,09 1.45/22 1.38/8 1.30/10 1.58/12   69/35 4,48 2.30/23 2.50/8 1.91/11 2.67/12
2020-09-13 Aalesund 0-1 Sarpsborg 08 34/-28 4,17 0.70/23 0.50/8 0.42/12 1.00/11   35/-1 3,09 1.39/23 1.25/8 1.18/11 1.58/12
2020-09-19 Sarpsborg 08 2-0 Mjondalen 36/0 3,00 1.46/24 1.25/8 1.18/11 1.69/13   29/-15 2,92 1.04/25 0.75/8 0.50/12 1.54/13
2020-09-26 Stromsgodset 0-0 Sarpsborg 08 42/-9 3,58 1.27/26 1.13/8 0.92/13 1.62/13   38/2 2,96 1.52/25 1.63/8 1.33/12 1.69/13
2020-10-03 Sarpsborg 08 4-0 Stabaek 38/2 2,85 1.50/26 1.63/8 1.33/12 1.64/14   41/-3 3,15 1.37/27 1.00/8 1.07/14 1.69/13
2020-10-18 Haugesund 2-0 Sarpsborg 08 40/-12 3,29 1.21/28 0.88/8 1.00/14 1.43/14   42/6 2,89 1.56/27 1.63/8 1.46/13 1.64/14
2020-10-25 Sarpsborg 08 1-2 Rosenborg 42/4 2,86 1.50/28 1.63/8 1.46/13 1.53/15   55/21 3,18 1.82/28 2.25/8 1.71/14 1.93/14
2020-10-31 Odd 1-1 Sarpsborg 08 56/8 3,59 1.72/29 1.63/8 1.57/14 1.87/15   43/3 2,86 1.45/29 1.25/8 1.36/14 1.53/15
2020-11-08 Start 3-2 Sarpsborg 08 41/-17 3,19 1.00/31 0.88/8 1.00/16 1.00/15   44/3 2,83 1.43/30 1.38/8 1.36/14 1.50/16
2020-11-22 Sarpsborg 08 1-2 Viking 46/2 2,90 1.39/31 1.38/8 1.36/14 1.41/17   58/-1 3,66 1.41/32 1.75/8 1.13/16 1.69/16
2020-11-29 Valerenga 1-1 Sarpsborg 08 52/9 3,06 1.68/31 2.13/8 1.75/16 1.60/15   47/1 2,91 1.34/32 1.00/8 1.27/15 1.41/17
2020-12-02 Sarpsborg 08 1-1 Kristiansund 48/1 2,88 1.33/33 0.75/8 1.27/15 1.39/18   65/13 3,44 1.62/34 1.63/8 1.29/17 1.94/17
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 Sarpsborg 08 0-0 Sandefjord 50/1 2,83 1.31/35 0.50/8 1.25/16 1.37/19   46/-12 2,97 1.26/35 1.13/8 0.82/17 1.67/18
2020-12-19 Molde 5-0 Sarpsborg 08 88/36 3,78 1.92/37 2.38/8 1.89/18 1.95/19   50/1 2,75 1.31/36 0.63/8 1.24/17 1.37/19