SELECT * FROM 1_Kampe WHERE LigaID = '137' AND (Home='Tenerife' OR Away='Tenerife') 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-17

Zaragoza

2-0

Tenerife

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-25

Tenerife

3-2

Numancia

0/-2

2,00

0.00/1

0.00/1

0.00/0

0.00/1

0/-1

1,00

0.00/1

0.00/1

0.00/1

0.00/0

2019-09-01

Ponferradina

4-0

Tenerife

2/-2

3,00

0.50/2

0.50/2

1.00/1

0.00/1

3/-1

3,50

1.50/2

1.50/2

3.00/1

0.00/1

2019-09-07

Tenerife

0-0

Las Palmas

3/-5

3,67

1.00/3

1.00/3

3.00/1

0.00/2

3/-1

2,33

0.67/3

0.67/3

0.50/2

1.00/1

2019-09-15

Albacete

0-4

Tenerife

2/-3

1,75

1.50/4

1.50/4

3.00/1

1.00/3

3/-5

2,75

1.00/4

1.00/4

2.00/2

0.00/2

2019-09-19

Elche

1-1

Tenerife

5/0

2,00

1.40/5

1.40/5

0.50/2

2.00/3

7/-1

3,00

1.40/5

1.40/5

2.00/2

1.00/3

2019-09-22

Tenerife

0-1

Fuenlabrada

8/-1

2,83

1.33/6

1.33/6

2.00/2

1.00/4

7/2

2,40

2.00/5

2.00/5

2.00/2

2.00/3

2019-09-29

Lugo

1-4

Tenerife

8/0

2,29

1.14/7

1.14/7

1.25/4

1.00/3

8/-2

2,57

1.14/7

1.14/7

1.33/3

1.00/4

2019-10-02

Tenerife

0-1

R. Oviedo

12/1

2,88

1.38/8

1.38/8

1.33/3

1.40/5

9/-6

3,00

0.38/8

0.38/8

0.75/4

0.00/4

2019-10-05

Tenerife

1-2

Extremadura UD

12/0

2,67

1.22/9

1.38/8

1.00/4

1.40/5

8/-1

1,89

1.00/9

1.00/8

1.00/4

1.00/5

2019-10-11

Rayo Vallecano

2-1

Tenerife

15/2

2,80

1.30/10

1.38/8

1.80/5

0.80/5

13/-1

2,70

1.10/10

1.00/8

0.80/5

1.40/5

2019-10-20

Tenerife

3-3

Racing Santander

14/-2

2,73

1.00/11

1.00/8

0.80/5

1.17/6

10/-3

2,09

0.82/11

0.88/8

0.83/6

0.80/5

2019-10-26

Mirandes

0-0

Tenerife

14/-6

2,83

1.17/12

1.25/8

1.50/6

0.83/6

17/-2

3,00

1.00/12

1.00/8

0.83/6

1.17/6

2019-11-02

Tenerife

0-0

Huesca

17/-2

2,77

1.00/13

0.75/8

0.83/6

1.14/7

14/5

1,77

1.69/13

1.63/8

2.29/7

1.00/6

2019-11-08

Girona

1-0

Tenerife

18/1

2,50

1.43/14

1.63/8

2.00/7

0.86/7

17/-2

2,57

1.00/14

0.75/8

0.86/7

1.14/7

2019-11-17

Tenerife

1-1

Cadiz CF

17/-3

2,47

0.93/15

0.75/8

0.86/7

1.00/8

24/12

2,40

2.33/15

2.38/8

2.71/7

2.00/8

2019-11-22

Gijon

0-2

Tenerife

17/0

2,13

1.13/16

1.25/8

1.50/8

0.75/8

18/-3

2,44

0.94/16

0.50/8

0.88/8

1.00/8

2019-11-30

Tenerife

1-3

Almeria

20/-1

2,41

1.06/17

0.88/8

0.88/8

1.22/9

25/10

2,35

1.71/17

1.50/8

2.13/8

1.33/9

2019-12-06

Malaga

2-0

Tenerife

14/-4

1,78

0.94/18

1.13/8

1.00/8

0.90/10

21/-3

2,50

1.00/18

0.88/8

0.78/9

1.22/9

2019-12-14

Tenerife

0-0

Alcorcon

21/-5

2,47

0.95/19

0.88/8

0.78/9

1.10/10

22/-1

2,37

1.32/19

1.25/8

1.00/10

1.67/9

2019-12-20

Dep. La Coruna

2-1

Tenerife

15/-19

2,45

0.60/20

0.50/8

0.78/9

0.45/11

21/-5

2,35

0.95/20

0.88/8

0.80/10

1.10/10

2020-01-04

Tenerife

4-2

Albacete

22/-6

2,38

0.90/21

0.75/8

0.80/10

1.00/11

14/-7

1,75

1.35/20

1.00/8

1.10/10

1.60/10

2020-01-15

Huesca

2-1

Tenerife

26/7

2,05

1.64/22

1.63/8

2.27/11

1.00/11

26/-4

2,55

1.00/22

1.00/8

1.00/11

1.00/11

2020-01-19

Tenerife

1-0

Girona

27/-5

2,57

0.96/23

1.00/8

1.00/11

0.92/12

31/2

2,61

1.48/23

1.38/8

2.17/12

0.73/11

2020-01-25

Las Palmas

0-0

Tenerife

29/1

2,38

1.42/24

1.88/8

1.50/12

1.33/12

28/-4

2,50

1.04/24

1.25/8

1.17/12

0.92/12

2020-01-31

Tenerife

2-1

Gijon

28/-4

2,40

1.04/25

1.00/8

1.17/12

0.92/13

22/-3

1,88

1.24/25

1.63/8

1.62/13

0.83/12

2020-02-08

Extremadura UD

2-4

Tenerife

22/-11

2,12

1.00/26

1.25/8

1.00/13

1.00/13

30/-3

2,42

1.12/26

1.38/8

1.31/13

0.92/13

2020-02-16

Tenerife

0-0

Rayo Vallecano

34/-1

2,56

1.19/27

1.75/8

1.31/13

1.07/14

33/5

2,35

1.35/26

1.75/8

1.62/13

1.08/13

2020-02-22

Tenerife

1-0

Elche

34/-1

2,46

1.18/28

1.75/8

1.29/14

1.07/14

36/6

2,36

1.43/28

1.50/8

1.29/14

1.57/14

2020-03-01

R. Oviedo

1-0

Tenerife

34/-8

2,62

1.00/29

0.88/8

1.21/14

0.80/15

35/0

2,41

1.24/29

2.13/8

1.40/15

1.07/14

2020-03-08

Tenerife

1-0

Ponferradina

35/-1

2,37

1.20/30

1.75/8

1.40/15

1.00/15

36/3

2,30

1.33/30

1.13/8

1.81/16

0.79/14

2020-06-12

Fuenlabrada

1-0

Tenerife

32/-1

2,10

1.26/31

0.38/8

1.40/15

1.13/16

36/0

2,32

1.26/31

2.13/8

1.50/16

1.00/15

2020-06-15

Tenerife

0-0

Malaga

36/-1

2,28

1.22/32

1.75/8

1.50/16

0.94/16

28/-2

1,81

1.19/32

1.38/8

1.38/16

1.00/16

2020-06-21

Racing Santander

1-2

Tenerife

32/-10

2,24

0.88/33

1.13/8

0.94/16

0.82/17

36/-1

2,21

1.21/33

1.75/8

1.47/17

0.94/16

2020-06-24

Tenerife

4-1

Mirandes

38/0

2,24

1.26/34

1.75/8

1.47/17

1.06/17

47/0

2,76

1.41/34

1.50/8

1.56/18

1.25/16

2020-06-27

Cadiz CF

0-2

Tenerife

46/13

2,26

1.77/35

1.25/8

1.94/17

1.61/18

42/3

2,31

1.31/35

1.75/8

1.56/18

1.06/17

2020-06-30

Tenerife

1-1

Dep. La Coruna

44/5

2,31

1.36/36

2.00/8

1.56/18

1.17/18

36/-16

2,44

1.22/36

1.25/8

1.44/18

1.00/18

2020-07-04

Almeria

1-2

Tenerife

57/21

2,51

1.62/37

1.63/8

1.67/18

1.58/19

45/5

2,30

1.35/37

1.75/8

1.53/19

1.17/18

2020-07-09

Tenerife

1-1

Zaragoza

47/6

2,32

1.39/38

2.13/8

1.53/19

1.26/19

53/10

2,53

1.61/38

1.13/8

1.47/19

1.74/19

2020-07-13

Alcorcon

0-0

Tenerife

50/2

2,51

1.36/39

1.50/8

1.05/19

1.65/20

48/6

2,31

1.38/39

1.88/8

1.50/20

1.26/19

2020-07-17

Tenerife

1-2

Lugo

48/6

2,25

1.38/40

2.00/8

1.50/20

1.25/20

39/-13

2,28

1.15/40

1.13/8

1.30/20

1.00/20

2020-07-20

Numancia

2-1

Tenerife

43/-9

2,32

1.15/41

1.13/8

1.75/20

0.57/21

49/5

2,27

1.34/41

1.88/8

1.43/21

1.25/20