SELECT * FROM 1_Kampe WHERE LigaID = '228' AND (Home='Tromso' OR Away='Tromso') 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-31 Ranheim 1-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
2019-04-07 Tromso 0-2 Viking 2/1 3,00 3.00/1 3.00/1 0.00/0 3.00/1   2/2 2,00 3.00/1 3.00/1 3.00/1 0.00/0
2019-04-14 Valerenga 4-1 Tromso 3/-3 3,00 1.00/3 1.00/3 3.00/1 0.00/2   2/-1 2,50 1.50/2 1.50/2 0.00/1 3.00/1
2019-04-22 Mjondalen 1-1 Tromso 7/-2 5,33 1.00/3 1.00/3 0.00/1 1.50/2   3/-4 3,33 1.00/3 1.00/3 0.00/1 1.50/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 Kristiansund 1-0 Tromso 6/-2 2,33 1.17/6 1.17/6 2.00/2 0.75/4   5/-5 3,00 0.80/5 0.80/5 0.00/2 1.33/3
2019-05-12 Tromso 1-2 Odd 5/-6 2,67 0.67/6 0.67/6 0.00/2 1.00/4   9/4 2,33 2.17/6 2.17/6 3.00/4 0.50/2
2019-05-16 Tromso 1-2 Bodo/Glimt 6/-7 2,71 0.57/7 0.57/7 0.00/3 1.00/4   16/6 3,71 2.00/7 2.00/7 2.50/4 1.33/3
2019-05-19 Stromsgodset 3-1 Tromso 9/-4 2,75 0.75/8 0.75/8 1.00/4 0.50/4   7/-8 2,75 0.50/8 0.50/8 0.00/4 1.00/4
2019-05-26 Tromso 2-1 Molde 8/-10 2,89 0.44/9 0.13/8 0.00/4 0.80/5   25/15 3,50 2.20/10 2.25/8 3.00/5 1.40/5
2019-06-17 Stabaek 0-1 Tromso 6/-7 2,38 0.88/8 0.88/8 1.75/4 0.00/4   10/-9 2,90 0.70/10 0.50/8 0.60/5 0.80/5
2019-06-23 Tromso 1-0 Rosenborg 11/-8 2,73 0.91/11 0.88/8 0.60/5 1.17/6   11/-3 2,27 1.36/11 1.75/8 1.83/6 0.80/5
2019-06-30 Lillestrom 4-0 Tromso 10/-8 2,33 1.00/12 1.00/8 1.17/6 0.83/6   12/-7 2,58 1.08/12 1.13/8 1.00/6 1.17/6
2019-07-05 Tromso 2-0 Sarpsborg 08 12/-11 2,69 1.00/13 1.13/8 1.00/6 1.00/7   12/-2 2,17 1.00/12 0.75/8 1.29/7 0.60/5
2019-07-14 Haugesund 5-1 Tromso 19/2 2,57 1.21/14 1.25/8 1.00/7 1.43/7   14/-9 2,64 1.14/14 1.50/8 1.29/7 1.00/7
2019-08-04 Tromso 2-2 Mjondalen 15/-13 2,87 1.07/15 1.50/8 1.29/7 0.88/8   20/-4 2,93 1.07/15 1.00/8 1.25/8 0.86/7
2019-08-10 Rosenborg 5-2 Tromso 21/2 2,50 1.56/16 2.38/8 2.13/8 1.00/8   17/-13 2,94 1.06/16 1.63/8 1.25/8 0.88/8
2019-08-18 Tromso 1-1 Lillestrom 19/-16 3,18 1.00/17 1.63/8 1.25/8 0.78/9   22/-6 2,94 1.24/17 1.50/8 1.78/9 0.63/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 Tromso 2-2 Haugesund 23/-15 3,21 1.11/19 1.38/8 1.22/9 1.00/10   27/4 2,63 1.26/19 1.00/8 1.00/10 1.56/9
2019-09-15 Molde 3-0 Tromso 47/26 3,40 2.15/20 2.25/8 2.56/9 1.82/11   25/-15 3,25 1.10/20 1.13/8 1.20/10 1.00/10
2019-09-22 Tromso 0-1 Stromsgodset 25/-18 3,24 1.05/21 1.13/8 1.20/10 0.91/11   23/-16 2,95 0.90/21 1.13/8 1.45/11 0.30/10
2019-09-29 Bodo/Glimt 4-0 Tromso 50/16 3,82 2.00/22 1.88/8 2.36/11 1.64/11   25/-19 3,14 1.00/22 0.75/8 1.09/11 0.91/11
2019-10-06 Tromso 5-0 Kristiansund 25/-23 3,17 0.96/23 0.75/8 1.09/11 0.83/12   30/5 2,39 1.48/23 1.50/8 1.91/11 1.08/12
2019-10-20 Viking 2-1 Tromso 41/8 3,08 1.54/24 2.25/8 2.00/12 1.08/12   30/-18 3,25 1.04/24 1.00/8 1.25/12 0.83/12
2019-10-27 Tromso 4-2 Ranheim 31/-19 3,24 1.00/25 1.00/8 1.25/12 0.77/13   29/-13 2,84 0.96/25 0.75/8 0.85/13 1.08/12
2019-11-03 Sarpsborg 08 3-2 Tromso 26/-7 2,27 0.96/26 1.25/8 1.31/13 0.62/13   35/-17 3,35 1.08/26 1.25/8 1.38/13 0.77/13
2019-11-10 Tromso 0-0 Valerenga 37/-18 3,41 1.04/27 0.88/8 1.38/13 0.71/14   37/-2 2,81 1.22/27 0.88/8 1.57/14 0.85/13
2019-11-24 Odd 2-1 Tromso 42/7 2,75 1.75/28 1.38/8 2.57/14 0.93/14   37/-18 3,29 1.04/28 0.88/8 1.36/14 0.71/14
2019-12-01 Tromso 1-1 Stabaek 38/-19 3,28 1.00/29 0.88/8 1.36/14 0.67/15   37/2 2,48 1.34/29 1.88/8 1.47/15 1.21/14