4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Telde
TEMPORADA 2023/2024
PREFERENTE CANARIAS GRUPO 3
Equipo PJ GF GC Puntos
1 UD Las Palmas C Palmas 39 116 21 103
2 Unión Viera Unión Viera 39 76 39 78
3 Estrella Estrella 39 79 45 77
4 Playas de Sotavento Playas 38 60 38 67
5 Telde Telde 39 59 53 66
6 El Cotillo El Cotillo 39 67 43 66
7 CD Becerril CD Becerril 39 62 49 60
8 At. Gran Canaria Gran Canaria 39 63 51 59
9 Universitario FC Universitari 39 62 57 58
10 CD Valleseco Valleseco 39 49 49 56
11 UD Balos UD Balos 39 50 47 54
12 Lomo Blanco Lomo Blanco 39 48 46 53
13 Tahiche Tahiche 39 46 49 53
14 Doramas Doramas 39 45 58 53
15 Guía Guía 38 53 66 47
16 Tinajo Tinajo 39 52 68 45
17 Arguineguín Arguineguín 39 49 69 45
18 Breñamen Las Playitas Breñamen 38 45 67 43
19 Costa Ayala Costa Ayala 39 45 59 41
20 Marítima Marítima 39 45 65 40
21 Sporting Tías Sporting 39 47 64 39
22 CD Ingenio CD Ingenio 38 36 59 35
23 Maspalomas Maspalomas 39 34 69 28
24 San Nicolás Nicolás 39 45 102 28
TEMPORADA 2022/2023
1ª REGIONAL CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 At. Gran Canaria Gran Canaria 38 127 30 91
2 Telde Telde 38 128 33 89
3 Tablero Tablero 38 101 54 79
4 Las Longueras Longueras 38 127 54 78
5 San Pedro Mártir Pedro 38 102 48 74
6 Castillo CF Castillo CF 38 101 59 72
7 Club Atlético Fomento Club 38 130 77 62
8 Unión Carrizal Unión 38 76 62 61
9 Agüimes CF Agüimes CF 38 89 64 59
10 CF Las Majoreras Majoreras 38 87 85 58
11 Unión Viera B Unión Viera 38 84 72 55
12 Union Marina Union Marina 38 83 80 47
13 Cerruda Cerruda 38 69 77 46
14 Las Huesas Las Huesas 38 76 95 45
15 Cercado de Espino Cercado 38 68 91 41
16 Valsequillo Valsequillo 38 55 65 39
17 Futboltec Futboltec 38 67 119 36
18 Casa Pastores Casa 38 72 115 25
19 Las Rosas Las Rosas 38 54 101 21
20 Calero Calero 38 9 255 0
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Maspalomas Maspalomas 26 50 22 54
2 RC Victoria RC Victoria 26 54 26 49
3 Tahiche Tahiche 26 46 32 48
4 CD Goleta CD Goleta 26 30 25 47
5 Sporting Tías Sporting 26 46 27 46
6 San Bartolomé CF Bartolomé 26 55 20 45
7 CD Becerril CD Becerril 26 37 44 35
8 CD Ingenio CD Ingenio 26 36 43 34
9 Arguineguín Arguineguín 26 30 33 32
10 UD Balos UD Balos 26 30 33 32
11 Telde Telde 26 33 40 31
12 San Pedro Mártir Pedro 26 30 43 27
13 UD Artenara UD Artenara 26 26 71 12
14 CD Cardones CD Cardones 26 22 66 7
TEMPORADA 2017/2018
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Tamaraceite Tamaraceite 36 105 29 90
2 Unión Viera Unión Viera 36 90 28 81
3 Arucas Arucas 36 70 34 76
4 UD San Gregorio Gregorio 36 75 47 64
5 Maspalomas Maspalomas 36 62 47 60
6 CD Becerril CD Becerril 36 67 55 60
7 UD San Antonio Antonio 36 69 53 59
8 UD Balos UD Balos 36 66 59 56
9 UD Teror UD Teror 36 72 61 55
10 RC Victoria RC Victoria 36 56 48 51
11 UD Guía UD Guía 36 55 58 42
12 Doramas Doramas 36 45 50 41
13 Union Marina Union Marina 36 45 72 41
14 CF Pedro Hidalgo Pedro 36 55 79 40
15 Tahiche Tahiche 36 44 77 35
16 CD Vecinklubf Vecinklubf 36 41 74 35
17 Cerruda Cerruda 36 51 66 31
18 Telde Telde 36 29 86 17
19 Costa Ayala Costa Ayala 36 39 113 14
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 92 20 94
2 UD San Fernando Fernando 38 54 38 66
3 Villa Santa Brígida Villa Santa 38 64 44 65
4 Ibarra Ibarra 38 61 41 65
5 Tenerife B Tenerife B 38 57 42 56
6 Marino Marino 38 51 45 56
7 Union Sur Yaiza Union Yaiza 38 55 44 55
8 Panadería Pulido Panadería 38 52 49 55
9 Unión Puerto Unión 38 45 50 51
10 CD Buzanada CD Buzanada 38 45 48 51
11 Tenisca Tenisca 38 66 70 51
12 Lanzarote Lanzarote 38 53 60 49
13 Las Zocas Las Zocas 38 43 56 48
14 El Cotillo El Cotillo 38 62 64 47
15 Estrella Estrella 38 40 42 46
16 CD Santa Úrsula Santa 38 54 61 44
17 Vera Vera 38 44 60 44
18 Unión Viera Unión Viera 38 57 80 42
19 Arucas Arucas 38 41 58 37
20 Telde Telde 38 22 86 20
TEMPORADA 2015/2016
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Villa Santa Brígida Villa Santa 38 59 26 81
2 Lanzarote Lanzarote 38 67 28 75
3 Las Palmas At. Palmas 38 70 37 73
4 Tenisca Tenisca 38 60 38 71
5 UD San Fernando Fernando 38 41 26 64
6 Las Zocas Las Zocas 38 47 34 63
7 El Cotillo El Cotillo 38 58 52 62
8 Telde Telde 38 59 38 60
9 Tenerife B Tenerife B 38 56 36 59
10 Ibarra Ibarra 38 63 46 57
11 Union Sur Yaiza Union Yaiza 38 47 43 52
12 Vera Vera 38 59 52 52
13 CD Santa Úrsula Santa 38 41 47 47
14 Arucas Arucas 38 36 41 46
15 Unión Viera Unión Viera 38 44 54 43
16 Unión Puerto Unión 38 36 61 37
17 Marino Marino 38 35 67 33
18 Real Sporting San José Real 38 28 63 28
19 UD Cruz Santa Cruz Santa 38 23 61 24
20 At. Granadilla Granadilla 38 27 106 17
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 CD Mensajero Mensajero 38 61 35 71
2 Lanzarote Lanzarote 38 60 44 68
3 Marino Marino 38 58 42 65
4 Real Sporting San José Real 38 57 38 60
5 Union Sur Yaiza Union Yaiza 38 40 35 56
6 Villa Santa Brígida Villa Santa 38 55 50 53
7 Tenerife B Tenerife B 38 53 42 52
8 Unión Viera Unión Viera 38 61 54 51
9 Arucas Arucas 38 46 52 50
10 Ibarra Ibarra 38 51 58 49
11 Tenisca Tenisca 38 54 48 47
12 At. Granadilla Granadilla 38 45 53 47
13 CD Santa Úrsula Santa 38 41 49 47
14 El Cotillo El Cotillo 38 40 62 47
15 Telde Telde 38 44 51 46
16 Las Zocas Las Zocas 38 53 67 46
17 Vera Vera 38 56 69 45
18 Estrella Estrella 38 49 45 44
19 CD Laguna CD Laguna 38 45 58 44
20 Atletico Victoria Atletico 38 42 59 41
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 At. Granadilla Granadilla 38 68 34 82
2 Marino Marino 38 59 29 81
3 CD Mensajero Mensajero 38 57 18 77
4 Tenerife B Tenerife B 38 76 44 74
5 Estrella Estrella 38 59 39 66
6 Villa Santa Brígida Villa Santa 38 69 49 65
7 Atletico Victoria Atletico 38 49 55 54
8 Tenisca Tenisca 38 66 57 53
9 Union Sur Yaiza Union Yaiza 38 51 47 52
10 Vecindario Vecindario 38 60 45 50
11 El Cotillo El Cotillo 38 48 52 50
12 Lanzarote Lanzarote 38 33 44 48
13 Las Zocas Las Zocas 38 38 47 46
14 CD Laguna CD Laguna 38 38 48 45
15 Unión Viera Unión Viera 38 50 53 45
16 Ibarra Ibarra 38 47 67 41
17 Telde Telde 38 50 62 39
18 Vera Vera 38 48 93 33
19 Raqui San Isidro Raqui Isidro 38 34 73 31
20 Realejos Realejos 38 41 85 27
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 90 27 85
2 At. Granadilla Granadilla 38 63 31 81
3 Estrella Estrella 38 65 30 77
4 Unión Viera Unión Viera 38 82 49 75
5 CD Mensajero Mensajero 38 80 37 74
6 Tenerife B Tenerife B 38 63 40 63
7 Vecindario Vecindario 37 49 35 60
8 Corralejo Corralejo 38 43 41 56
9 Las Zocas Las Zocas 38 42 55 56
10 Villa Santa Brígida Villa Santa 38 55 59 54
11 San Andrés y Sauces Andrés 38 50 45 52
12 Telde Telde 38 44 55 52
13 Tenisca Tenisca 38 46 65 51
14 Lanzarote Lanzarote 38 59 58 49
15 Atletico Victoria Atletico 38 41 48 45
16 Vera Vera 38 43 75 42
17 Raqui San Isidro Raqui Isidro 38 41 57 33
18 San Pedro Mártir Pedro 38 21 41 24
19 Tijarafe Tijarafe 37 28 92 15
20 UD Gomera UD Gomera 38 30 95 14
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Marino Marino 38 74 35 76
2 Tenisca Tenisca 38 59 40 72
3 Las Palmas At. Palmas 38 68 29 71
4 Vera Vera 38 67 40 70
5 Lanzarote Lanzarote 38 47 34 66
6 At. Granadilla Granadilla 38 52 35 65
7 Estrella Estrella 38 47 34 63
8 Tenerife B Tenerife B 38 70 53 59
9 Corralejo Corralejo 38 48 45 58
10 Telde Telde 38 55 49 54
11 San Pedro Mártir Pedro 38 50 59 47
12 San Andrés y Sauces Andrés 38 46 64 46
13 CD Mensajero Mensajero 38 54 63 45
14 Villa Santa Brígida Villa Santa 38 56 66 45
15 Atletico Victoria Atletico 38 45 61 45
16 Las Zocas Las Zocas 38 46 60 41
17 Tijarafe Tijarafe 38 39 67 38
18 CD Laguna CD Laguna 38 35 55 37
19 Real Sporting San José Real 38 35 64 35
20 Charco del Pino Charco Pino 38 35 75 22
TEMPORADA 2010/2011
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Real Sporting San José Real 36 68 26 75
2 Estrella Estrella 36 69 35 73
3 San Pedro Mártir Pedro 36 61 33 73
4 Telde Telde 36 64 39 60
5 Gáldar Gáldar 36 65 58 56
6 CD Vallinámar Vallinámar 36 55 47 53
7 Arguineguín Arguineguín 36 49 50 50
8 Union Sur Yaiza Union Yaiza 36 36 41 49
9 Acodetti CF Acodetti CF 36 58 49 47
10 Universidad LPGC B Universidad 36 52 70 46
11 Unión Viera Unión Viera 36 51 48 45
12 UD Vecindario B Vecindario 36 47 49 45
13 Teguise Teguise 36 35 43 44
14 UD Balos UD Balos 36 39 54 44
15 Valsequillo Valsequillo 36 53 53 43
16 Doramas Doramas 36 37 46 42
17 Sporting Tías Sporting 36 34 52 39
18 Altavista Altavista 36 37 57 32
19 Castillo CF Castillo CF 36 28 88 18
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Tenisca Tenisca 38 77 33 76
2 Raqui San Isidro Raqui Isidro 38 58 29 74
3 CP Mijas Las Lagunas Mijas 38 48 21 64
4 Orientación Marítima Orientación 38 50 42 64
5 Gáldar Gáldar 38 58 49 58
6 Las Zocas Las Zocas 38 56 34 57
7 Villa Santa Brígida Villa Santa 38 46 37 57
8 Las Palmas At. Palmas 38 54 43 53
9 Union Antigua Union 38 49 57 52
10 CD Mensajero Mensajero 38 37 48 50
11 Universidad LPGC B Universidad 38 43 46 50
12 AD Huracán AD Huracán 38 45 41 49
13 Tegueste Tegueste 38 35 40 48
14 Maspalomas Maspalomas 38 46 54 48
15 Ibarra Ibarra 38 51 51 48
16 Realejos Realejos 38 43 60 47
17 Teguise Teguise 38 40 50 43
18 Telde Telde 38 37 58 35
19 CD La Oliva CD La Oliva 38 36 85 29
20 Atlético Arona Atlético 38 36 67 25
TEMPORADA 2003/2004
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Castillo CF Castillo CF 38 59 27 72
2 Villa Santa Brígida Villa Santa 38 55 33 71
3 CP Mijas Las Lagunas Mijas 38 62 30 70
4 Tenisca Tenisca 38 52 39 65
5 Gáldar Gáldar 38 58 45 59
6 Raqui San Isidro Raqui Isidro 38 53 42 59
7 Las Zocas Las Zocas 38 52 49 57
8 Orientación Marítima Orientación 38 58 47 54
9 Las Palmas At. Palmas 38 55 43 54
10 CD La Oliva CD La Oliva 38 34 30 52
11 Teguise Teguise 38 50 53 51
12 Ibarra Ibarra 38 48 62 49
13 Realejos Realejos 38 50 62 47
14 Universidad LPGC B Universidad 38 54 59 46
15 Telde Telde 38 36 42 46
16 CD Mensajero Mensajero 38 40 50 45
17 Union Antigua Union 38 45 59 45
18 Tenerife B Tenerife B 38 45 49 43
19 CD Victoria Tazacorte Victoria 38 39 65 32
20 CD San Miguel Miguel 38 34 93 23
TEMPORADA 2002/2003
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Vecindario Vecindario 40 76 25 82
2 Castillo CF Castillo CF 40 53 31 73
3 Tenerife B Tenerife B 40 58 35 71
4 Las Palmas At. Palmas 40 63 39 67
5 Villa Santa Brígida Villa Santa 40 58 41 65
6 Gáldar Gáldar 40 60 44 62
7 Raqui San Isidro Raqui Isidro 40 60 52 58
8 Orientación Marítima Orientación 40 52 57 56
9 UD Oliva UD Oliva 40 46 42 56
10 CD Victoria Tazacorte Victoria 40 44 44 54
11 CD Mensajero Mensajero 40 58 62 53
12 Ibarra Ibarra 40 40 40 53
13 Las Zocas Las Zocas 40 46 54 52
14 CD Laguna CD Laguna 40 45 49 52
15 Teguise Teguise 40 47 50 51
16 Tenisca Tenisca 40 50 54 50
17 Telde Telde 40 39 41 48
18 Agaete Agaete 40 51 68 42
19 Esperanza Esperanza 40 42 71 33
20 CD Huracán Z Huracán 40 48 81 32
21 Ud Valle Frontera Valle 40 29 85 29
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Corralejo Corralejo 38 70 33 76
2 Castillo CF Castillo CF 38 63 31 72
3 Villa Santa Brígida Villa Santa 38 50 33 70
4 Telde Telde 38 57 30 69
5 Tenerife B Tenerife B 38 57 39 63
6 Raqui San Isidro Raqui Isidro 38 46 34 61
7 Agaete Agaete 38 59 56 61
8 Las Zocas Las Zocas 38 57 42 55
9 Gáldar Gáldar 38 56 62 48
10 Orientación Marítima Orientación 38 42 43 48
11 CD Laguna CD Laguna 38 35 39 47
12 Ibarra Ibarra 38 52 49 45
13 Las Palmas At. Palmas 38 44 43 45
14 CD La Oliva CD La Oliva 38 48 55 44
15 Tenisca Tenisca 38 43 46 44
16 CD Victoria Tazacorte Victoria 38 47 66 43
17 Esperanza Esperanza 38 47 67 43
18 Unión Carrizal Unión 38 49 62 42
19 Maspalomas Maspalomas 38 37 74 33
20 CD Águilas CD Águilas 38 31 86 20
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Lanzarote Lanzarote 38 78 26 83
2 Tenisca Tenisca 38 66 47 71
3 Las Palmas At. Palmas 38 70 45 70
4 Raqui San Isidro Raqui Isidro 38 62 32 70
5 Castillo CF Castillo CF 38 60 48 70
6 Corralejo Corralejo 38 52 34 64
7 CD La Oliva CD La Oliva 38 67 48 63
8 Gáldar Gáldar 38 52 43 58
9 Tenerife B Tenerife B 38 48 43 54
10 Orientación Marítima Orientación 38 47 54 47
11 Telde Telde 38 34 37 47
12 Ibarra Ibarra 38 46 57 44
13 CD Victoria Tazacorte Victoria 38 42 70 43
14 Las Zocas Las Zocas 38 50 75 43
15 CD Laguna CD Laguna 38 27 36 42
16 Unión Carrizal Unión 38 37 56 41
17 CD La Angostura Angostura 38 46 55 40
18 Orotava Orotava 38 41 59 40
19 Doramas Doramas 38 41 57 37
20 Realejos Realejos 38 37 81 29
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 85 39 76
2 Orotava Orotava 38 64 36 71
3 Vecindario Vecindario 38 49 26 70
4 Castillo CF Castillo CF 38 47 30 70
5 Raqui San Isidro Raqui Isidro 38 56 34 68
6 Corralejo Corralejo 38 50 32 62
7 CD Victoria Tazacorte Victoria 38 41 44 57
8 Telde Telde 38 54 39 56
9 Tenerife B Tenerife B 38 55 47 52
10 Orientación Marítima Orientación 38 50 51 51
11 Doramas Doramas 38 41 44 50
12 Villa Santa Brígida Villa Santa 38 38 48 48
13 Gáldar Gáldar 38 46 51 48
14 Tenisca Tenisca 38 57 56 48
15 Realejos Realejos 38 56 66 43
16 UD Oliva UD Oliva 38 41 66 42
17 Ibarra Ibarra 38 41 70 40
18 Puerto Cruz Puerto Cruz 38 41 59 38
19 UD Icodense UD Icodense 38 33 70 32
20 Maspalomas Maspalomas 38 29 66 25
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 85 20 82
2 Orotava Orotava 38 54 26 79
3 Lanzarote Lanzarote 38 61 31 73
4 Telde Telde 38 53 25 73
5 Raqui San Isidro Raqui Isidro 38 62 32 72
6 Corralejo Corralejo 38 66 30 71
7 CD La Angostura Angostura 38 52 38 66
8 Gáldar Gáldar 38 66 38 64
9 Vecindario Vecindario 38 53 49 51
10 Tenisca Tenisca 38 53 59 50
11 CD La Oliva CD La Oliva 38 35 47 44
12 Doramas Doramas 38 36 47 43
13 Tenerife B Tenerife B 38 46 55 41
14 Realejos Realejos 38 41 61 40
15 Ibarra Ibarra 38 33 52 39
16 Maspalomas Maspalomas 38 35 48 37
17 CD Victoria Tazacorte Victoria 38 38 65 35
18 Unión Carrizal Unión 38 43 81 34
19 Atlético Arona Atlético 38 25 88 28
20 C.D. Z Esperanza C.D. 38 29 74 27
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Universidad LPGC Universidad 38 84 35 80
2 Corralejo Corralejo 38 76 21 79
3 Las Palmas At. Palmas 38 72 29 79
4 Lanzarote Lanzarote 38 60 26 75
5 Telde Telde 38 54 34 66
6 CD Victoria Tazacorte Victoria 38 51 42 58
7 Raqui San Isidro Raqui Isidro 38 51 43 55
8 Orotava Orotava 38 55 54 51
9 Realejos Realejos 38 50 52 51
10 Vecindario Vecindario 38 39 44 50
11 Ibarra Ibarra 38 52 76 47
12 Doramas Doramas 38 42 45 46
13 Tenerife B Tenerife B 38 44 45 46
14 Tenisca Tenisca 38 45 51 44
15 Maspalomas Maspalomas 38 53 67 42
16 Atlético Arona Atlético 38 40 73 41
17 Unión Carrizal Unión 38 46 73 39
18 UC La Estrella Estrella 38 31 61 36
19 Puerto Cruz Puerto Cruz 38 36 55 35
20 At. Paso At. Paso 38 22 77 22
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Tenisca Tenisca 38 66 30 81
2 Tenerife B Tenerife B 38 73 30 77
3 Maspalomas Maspalomas 38 58 29 76
4 Pájara Playas Jandía Pájara 38 77 34 76
5 Corralejo Corralejo 38 74 35 72
6 Vecindario Vecindario 38 50 28 67
7 Telde Telde 38 49 34 61
8 Lanzarote Lanzarote 38 53 51 58
9 Las Palmas At. Palmas 38 66 42 58
10 CD Victoria Tazacorte Victoria 38 40 57 49
11 Puerto Cruz Puerto Cruz 38 43 45 48
12 Atlético Arona Atlético 38 40 35 45
13 Orotava Orotava 38 48 55 45
14 Doramas Doramas 38 35 52 44
15 Ibarra Ibarra 38 28 40 40
16 Estrella Estrella 38 32 61 39
17 At. Paso At. Paso 38 46 67 38
18 Arguineguín Arguineguín 38 28 67 30
19 UD San Antonio Antonio 38 30 92 19
20 Real Artesano FC Real 38 37 89 11

  USO DE MEMORIA  
8,211,152 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1670
Total Execution Time  0.1682
  CADENA URL  
/historico/Ud-Telde
  GET DATOS  
$_GET['/historico/Ud-Telde']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0034  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Ud-Telde' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5167 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=5167 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5167 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5167 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (13702,41542,48582,88292,119027) ORDER BY n.cover_points DESC, update_date DESC
0.0029  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '5167' ORDER BY l.year DESC,cat.coefficient DESC
0.0027  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '5167' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0030  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '5167' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=5167 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (73545,69367) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73545 AND teamId = 5167
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 69367 AND teamId = 5167
0.0027  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '5167' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5167' and rp.type = 4
0.0031  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '5167' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '5167' and rp.type = 4
0.0026  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73545 WHERE rp.league_id = 73545 AND rp.teamId = 5167 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73545 WHERE rp.league_id = 73545 AND rp.teamId = 5167 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73545 WHERE rp.league_id = 73545 AND rp.teamId = 5167 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0049  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 5167 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0051  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 73545 AND t.round = 39 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 69367 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 64494 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39649 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 33362 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15453 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3921 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2561 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1954 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1408 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1214 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22105 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22089 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22073 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22057 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22041 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2000` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22025 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22009 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21993 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1997` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 21975 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC