SELECT * FROM 1_Kampe WHERE LigaID = '138' 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
2018-08-20 Gimnastic 1-1 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
2018-08-26 Almeria 1-1 Tenerife 0/-1 1,00 0.00/1 0.00/1 0.00/0 0.00/1   1/0 2,00 1.00/1 1.00/1 0.00/0 1.00/1
2018-09-01 Tenerife 2-2 Dep. La Coruna 2/0 2,00 1.00/2 1.00/2 0.00/0 1.00/2   2/1 1,50 2.00/2 2.00/2 0.00/0 2.00/2
2018-09-08 Malaga 1-0 Tenerife 4/3 1,67 3.00/3 3.00/3 3.00/1 3.00/2   4/0 2,67 1.00/3 1.00/3 1.00/1 1.00/2
2018-09-15 Tenerife 0-1 Reus FCR 4/-1 2,25 0.75/4 0.75/4 1.00/1 0.67/3   3/-1 1,75 1.00/4 1.00/4 0.50/2 1.50/2
2018-09-22 Cordoba 1-1 Tenerife 5/-8 3,60 0.40/5 0.40/5 0.67/3 0.00/2   4/-2 2,00 0.60/5 0.60/5 0.50/2 0.67/3
2018-09-29 Tenerife 1-0 Cadiz CF 5/-2 2,00 0.67/6 0.67/6 0.50/2 0.75/4   4/-2 1,67 1.00/6 1.00/6 1.33/3 0.67/3
2018-10-06 Mallorca 4-1 Tenerife 6/0 1,71 1.57/7 1.57/7 2.00/3 1.25/4   6/-1 1,86 1.00/7 1.00/7 1.33/3 0.75/4
2018-10-14 Tenerife 0-0 Lugo 7/-4 2,25 0.88/8 0.88/8 1.33/3 0.60/5   9/-2 2,50 1.00/8 1.00/8 1.00/4 1.00/4
2018-10-21 Tenerife 0-1 Reus Deportiu 7/-4 2,00 0.89/9 0.88/8 1.25/4 0.60/5   7/-1 1,00 1.40/15 1.88/8 0.00/8 3.00/7
2018-10-21 Zaragoza 1-1 Tenerife 11/1 2,33 1.11/9 0.88/8 1.25/4 1.00/5   7/-5 1,90 0.80/10 1.13/8 1.00/5 0.60/5
2018-10-21 Reus Deportiu 0-1 Tenerife 19/0 1,00 1.50/38 1.88/8 0.00/19 3.00/19   8/-5 1,91 0.82/11 1.13/8 1.00/5 0.67/6
2018-10-27 Tenerife 3-2 Alcorcon 9/-4 1,83 1.00/12 1.13/8 1.00/5 1.00/7   9/6 1,00 1.75/12 2.00/8 2.17/6 1.33/6
2018-11-03 Numancia 2-0 Tenerife 11/-5 2,08 1.23/13 1.25/8 1.67/6 0.86/7   12/-3 2,08 1.15/13 1.50/8 1.33/6 1.00/7
2018-11-11 Tenerife 0-0 Albacete 12/-5 2,07 1.07/14 1.38/8 1.33/6 0.88/8   20/7 2,36 1.64/14 1.38/8 1.43/7 1.86/7
2018-11-17 Osasuna 2-0 Tenerife 17/2 2,13 1.47/15 1.75/8 2.00/7 1.00/8   12/-5 1,93 1.07/15 1.13/8 1.29/7 0.88/8
2018-11-25 Tenerife 2-1 Rayo Majadahonda 12/-7 1,94 1.00/16 1.13/8 1.29/7 0.78/9   14/-5 2,06 1.38/16 1.63/8 1.63/8 1.13/8
2018-12-01 Gijon 2-1 Tenerife 16/1 1,82 1.24/17 1.13/8 1.63/8 0.89/9   14/-6 2,00 1.12/17 1.38/8 1.50/8 0.78/9
2018-12-07 Tenerife 0-0 Extremadura UD 15/-7 2,06 1.06/18 1.38/8 1.50/8 0.70/10   24/-3 2,83 1.06/18 1.25/8 0.78/9 1.33/9
2018-12-16 Las Palmas 1-1 Tenerife 23/2 2,32 1.37/19 1.00/8 1.70/10 1.00/9   15/-7 1,95 1.05/19 1.13/8 1.44/9 0.70/10
2018-12-21 Tenerife 1-1 Granada CF 16/-7 1,95 1.05/20 1.13/8 1.44/9 0.73/11   27/14 2,00 2.00/20 2.13/8 2.00/10 2.00/10
2019-01-04 Tenerife 2-1 Elche 17/-7 1,95 1.05/21 0.88/8 1.40/10 0.73/11   19/-6 2,10 1.14/21 0.88/8 1.27/11 1.00/10
2019-01-12 R. Oviedo 1-0 Tenerife 24/-3 2,32 1.36/22 1.38/8 1.45/11 1.27/11   19/-6 2,00 1.14/22 1.25/8 1.55/11 0.73/11
2019-01-20 Tenerife 2-0 Gimnastic 19/-7 1,96 1.09/23 1.13/8 1.55/11 0.67/12   13/-19 1,96 0.83/23 0.88/8 1.00/11 0.67/12
2019-01-26 Tenerife 0-0 Malaga 21/-5 1,96 1.17/24 1.50/8 1.67/12 0.67/12   27/9 1,88 1.88/24 1.63/8 2.25/12 1.50/12
2019-02-02 Dep. La Coruna 0-0 Tenerife 36/17 2,20 1.80/25 1.50/8 2.25/12 1.38/13   21/-5 1,88 1.16/25 1.25/8 1.62/13 0.67/12
2019-02-09 Tenerife 0-2 Cordoba 21/-5 1,81 1.15/26 1.38/8 1.62/13 0.69/13   29/-17 2,88 0.81/26 0.75/8 1.15/13 0.46/13
2019-02-16 Cadiz CF 2-0 Tenerife 33/11 2,04 1.52/27 1.13/8 1.77/13 1.29/14   21/-7 1,81 1.11/27 1.25/8 1.50/14 0.69/13
2019-02-22 Tenerife 2-2 Mallorca 21/-9 1,82 1.07/28 1.13/8 1.50/14 0.64/14   33/8 2,07 1.54/28 1.63/8 2.07/14 1.00/14
2019-03-03 Reus FCR 0-0 Tenerife 16/-13 1,67 0.78/27 0.50/8 0.57/14 1.00/13   23/-9 1,90 1.07/29 1.13/8 1.47/15 0.64/14
2019-03-10 Tenerife 1-1 Numancia 23/-9 1,83 1.03/30 0.75/8 1.47/15 0.60/15   34/-1 2,30 1.23/30 1.50/8 1.53/15 0.93/15
2019-03-16 Alcorcon 1-1 Tenerife 27/0 1,74 1.35/31 0.88/8 2.00/15 0.75/16   24/-9 1,84 1.03/31 0.88/8 1.44/16 0.60/15
2019-03-22 Tenerife 3-2 Osasuna 25/-9 1,84 1.03/32 0.63/8 1.44/16 0.63/16   42/15 2,16 1.97/32 2.75/8 2.56/16 1.38/16
2019-03-30 Albacete 2-2 Tenerife 41/17 1,97 1.79/33 1.75/8 1.94/16 1.65/17   28/-8 1,94 1.09/33 0.88/8 1.53/17 0.63/16
2019-04-05 Tenerife 0-1 Gijon 30/-8 2,00 1.09/34 0.88/8 1.53/17 0.65/17   36/6 1,94 1.44/34 1.63/8 1.65/17 1.24/17
2019-04-13 Rayo Majadahonda 1-3 Tenerife 36/-8 2,29 1.23/35 1.63/8 1.47/17 1.00/18   30/-9 1,97 1.06/35 0.88/8 1.44/18 0.65/17
2019-04-21 Tenerife 1-3 Almeria 33/-7 2,03 1.11/36 1.25/8 1.44/18 0.78/18   38/8 1,89 1.36/36 1.50/8 1.72/18 1.00/18
2019-04-27 Extremadura UD 1-0 Tenerife 39/-6 2,27 1.05/37 1.63/8 0.94/18 1.16/19   34/-9 2,08 1.08/37 1.13/8 1.37/19 0.78/18
2019-05-04 Tenerife 2-1 Las Palmas 34/-10 2,05 1.05/38 1.13/8 1.37/19 0.74/19   43/-1 2,29 1.29/38 1.00/8 1.53/19 1.05/19
2019-05-10 Granada CF 2-1 Tenerife 45/20 1,79 1.74/39 1.50/8 1.84/19 1.65/20   36/-9 2,08 1.10/39 1.38/8 1.45/20 0.74/19
2019-05-18 Elche 3-0 Tenerife 43/-4 2,25 1.25/40 1.75/8 1.65/20 0.85/20   37/-10 2,10 1.08/40 1.25/8 1.45/20 0.70/20
2019-05-26 Tenerife 2-1 R. Oviedo 37/-13 2,12 1.05/41 0.88/8 1.45/20 0.67/21   43/0 2,10 1.46/41 1.25/8 1.71/21 1.20/20
2019-06-04 Lugo 0-0 Tenerife 42/-9 2,21 1.07/42 1.50/8 1.24/21 0.90/21   39/-12 2,14 1.10/42 1.13/8 1.52/21 0.67/21
2019-06-09 Tenerife 1-0 Zaragoza 39/-12 2,09 1.09/43 1.25/8 1.52/21 0.68/22   49/-2 2,33 1.19/43 1.25/8 1.14/22 1.24/21