SELECT * FROM 1_Kampe WHERE LigaID = '2' AND (Home='Tottenham' OR Away='Tottenham') 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-08-10 Tottenham 3-1 Aston Villa 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-08-17 Manchester City 2-2 Tottenham 5/5 5,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
2019-08-25 Tottenham 0-1 Newcastle 5/2 4,00 2.00/2 2.00/2 3.00/1 1.00/1   1/-3 2,50 0.00/2 0.00/2 0.00/1 0.00/1
2019-09-01 Arsenal 2-2 Tottenham 4/0 2,67 2.00/3 2.00/3 3.00/1 1.50/2   5/1 3,00 1.33/3 1.33/3 1.50/2 1.00/1
2019-09-14 Tottenham 4-0 Crystal Palace 7/1 3,25 1.25/4 1.25/4 1.50/2 1.00/2   3/1 1,25 1.75/4 1.75/4 2.00/2 1.50/2
2019-09-21 Leicester 2-1 Tottenham 6/2 2,00 1.60/5 1.60/5 2.00/2 1.33/3   11/5 3,40 1.60/5 1.60/5 2.00/3 1.00/2
2019-09-28 Tottenham 2-1 Southampton 12/4 3,33 1.33/6 1.33/6 2.00/3 0.67/3   6/-3 2,50 1.17/6 1.17/6 0.33/3 2.00/3
2019-10-05 Brighton 3-0 Tottenham 5/-5 2,14 0.86/7 0.86/7 0.67/3 1.00/4   14/5 3,29 1.57/7 1.57/7 2.25/4 0.67/3
2019-10-19 Tottenham 1-1 Watford 14/2 3,25 1.38/8 1.38/8 2.25/4 0.50/4   4/-16 3,00 0.38/8 0.38/8 0.50/4 0.25/4
2019-10-27 Liverpool 2-1 Tottenham 21/14 3,11 2.78/9 2.75/8 3.00/4 2.60/5   15/2 3,11 1.33/9 1.13/8 2.00/5 0.50/4
2019-11-03 Everton 1-1 Tottenham 10/-6 2,60 1.00/10 0.75/8 1.80/5 0.20/5   16/1 3,10 1.20/10 1.00/8 2.00/5 0.40/5
2019-11-09 Tottenham 1-1 Sheffield Utd 17/1 3,00 1.18/11 1.13/8 2.00/5 0.50/6   12/4 1,82 1.45/11 1.50/8 1.50/6 1.40/5
2019-11-23 West Ham 2-3 Tottenham 14/-6 2,83 1.08/12 0.75/8 1.17/6 1.00/6   18/1 2,92 1.17/12 1.13/8 1.83/6 0.50/6
2019-11-30 Tottenham 3-2 Bournemouth 21/2 3,08 1.31/13 1.13/8 1.83/6 0.86/7   16/-1 2,54 1.23/13 1.13/8 1.29/7 1.17/6
2019-12-04 Manchester Utd 2-1 Tottenham 21/4 2,71 1.29/14 1.25/8 1.71/7 0.86/7   24/3 3,21 1.43/14 1.50/8 2.00/7 0.86/7
2019-12-07 Tottenham 5-0 Burnley 25/2 3,20 1.33/15 1.13/8 2.00/7 0.75/8   21/-3 3,00 1.20/15 1.13/8 1.50/8 0.86/7
2019-12-15 Wolves 1-2 Tottenham 23/4 2,63 1.50/16 1.75/8 1.63/8 1.38/8   30/7 3,31 1.44/16 1.50/8 2.13/8 0.75/8
2019-12-22 Tottenham 0-2 Chelsea 32/8 3,29 1.53/17 1.75/8 2.13/8 1.00/9   31/6 3,29 1.71/17 1.50/8 1.56/9 1.88/8
2019-12-26 Tottenham 2-1 Brighton 32/6 3,22 1.44/18 1.75/8 1.89/9 1.00/9   21/-5 2,61 1.11/18 1.00/8 1.33/9 0.89/9
2019-12-28 Norwich 2-2 Tottenham 19/-19 3,00 0.63/19 0.63/8 0.78/9 0.50/10   34/7 3,21 1.53/19 2.00/8 2.00/10 1.00/9
2020-01-01 Southampton 1-0 Tottenham 24/-14 3,10 1.10/20 1.75/8 0.80/10 1.40/10   36/7 3,25 1.50/20 2.00/8 2.00/10 1.00/10
2020-01-11 Tottenham 0-1 Liverpool 36/6 3,14 1.43/21 1.63/8 2.00/10 0.91/11   49/35 3,15 2.90/20 3.00/8 3.00/11 2.78/9
2020-01-18 Watford 0-0 Tottenham 20/-14 2,45 1.00/22 1.75/8 1.18/11 0.82/11   36/5 3,05 1.36/22 1.25/8 1.82/11 0.91/11
2020-01-22 Tottenham 2-1 Norwich 36/5 2,91 1.35/23 1.38/8 1.82/11 0.92/12   23/-22 2,96 0.74/23 0.75/8 1.00/12 0.45/11
2020-02-02 Tottenham 2-0 Manchester City 38/6 2,92 1.42/24 1.38/8 1.92/12 0.92/12   65/38 3,83 2.13/24 2.38/8 2.17/12 2.08/12
2020-02-16 Aston Villa 2-3 Tottenham 32/-15 3,16 1.00/25 1.25/8 1.42/12 0.62/13   40/8 2,88 1.48/25 1.38/8 2.00/13 0.92/12
2020-02-22 Chelsea 2-1 Tottenham 43/7 3,04 1.58/26 1.13/8 1.38/13 1.77/13   43/9 2,96 1.54/26 1.75/8 2.00/13 1.08/13
2020-03-01 Tottenham 2-3 Wolves 44/8 2,96 1.48/27 1.38/8 2.00/13 1.00/14   38/6 2,59 1.44/27 1.13/8 1.50/14 1.38/13
2020-03-07 Burnley 1-1 Tottenham 33/-6 2,57 1.36/28 1.75/8 1.57/14 1.14/14   46/7 3,04 1.43/28 1.25/8 1.86/14 1.00/14
2020-06-19 Tottenham 1-1 Manchester Utd 47/7 3,00 1.41/29 1.38/8 1.86/14 1.00/15   44/14 2,55 1.55/29 1.75/8 1.93/15 1.14/14
2020-06-23 Tottenham 2-0 West Ham 48/7 2,97 1.40/30 1.50/8 1.80/15 1.00/15   35/-17 2,90 0.90/30 0.50/8 1.00/15 0.80/15
2020-07-02 Sheffield Utd 3-1 Tottenham 30/-1 1,97 1.42/31 1.38/8 1.60/15 1.25/16   50/9 2,94 1.45/31 1.75/8 1.88/16 1.00/15
2020-07-06 Tottenham 1-0 Everton 51/7 2,97 1.41/32 1.38/8 1.88/16 0.94/16   40/-7 2,72 1.38/32 1.75/8 1.81/16 0.94/16
2020-07-09 Bournemouth 0-0 Tottenham 32/-27 2,76 0.82/33 0.13/8 1.06/16 0.59/17   52/8 2,91 1.45/33 1.38/8 1.94/17 0.94/16
2020-07-12 Tottenham 2-1 Arsenal 52/8 2,82 1.44/34 1.13/8 1.94/17 0.94/17   50/8 2,71 1.47/34 2.00/8 1.76/17 1.18/17
2020-07-15 Newcastle 1-3 Tottenham 36/-16 2,51 1.23/35 1.50/8 1.53/17 0.94/18   54/9 2,83 1.49/35 1.50/8 2.00/18 0.94/17
2020-07-19 Tottenham 3-0 Leicester 57/11 2,86 1.53/36 1.88/8 2.00/18 1.06/18   67/31 2,86 1.72/36 1.50/8 2.06/18 1.39/18
2020-07-26 Crystal Palace 1-1 Tottenham 30/-19 2,14 1.14/37 0.38/8 1.22/18 1.05/19   60/14 2,86 1.57/37 2.13/8 2.05/19 1.06/18