4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Bilbao Ath. Bilbao Ath. 32 60 16 76
2 Barakaldo Barakaldo 32 54 19 70
3 UD Logroñés Logroñés 32 63 16 65
4 Utebo Utebo 32 39 28 58
5 Deportivo Aragón Deportivo 32 48 32 56
6 Deportivo Alavés B Deportivo 32 54 38 49
7 Real Sociedad C Real 32 32 33 44
8 SD Gernika SD Gernika 32 36 44 43
9 CD Calahorra Calahorra 32 30 32 43
10 Tudelano Tudelano 32 40 32 42
11 Barbastro Barbastro 32 24 27 41
12 Arenas de Getxo Arenas Getxo 32 30 35 37
13 Izarra Izarra 32 28 49 33
14 Mutilvera Mutilvera 32 20 43 33
15 AD San Juan AD San Juan 32 28 45 32
16 CD Valle de Egüés Valle 32 23 52 21
17 Brea Brea 32 14 47 21
18 Náxara Náxara 32 20 55 21
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Sestao River Sestao River 34 55 17 72
2 Deportivo Alavés B Deportivo 34 40 23 59
3 SD Tarazona SD Tarazona 34 60 37 56
4 Utebo Utebo 34 39 32 53
5 SD Gernika SD Gernika 34 41 31 53
6 Tudelano Tudelano 34 39 32 52
7 Real Sociedad C Real 34 46 42 52
8 AD San Juan AD San Juan 34 33 27 51
9 Arenas de Getxo Arenas Getxo 34 39 42 48
10 Izarra Izarra 34 39 31 48
11 Mutilvera Mutilvera 34 44 37 46
12 Brea Brea 34 27 33 44
13 Beasain KE Beasain KE 34 40 40 41
14 Cirbonero Cirbonero 34 35 40 40
15 CD Alfaro CD Alfaro 34 35 54 34
16 UD Logroñés B Logroñés 34 27 54 32
17 Racing Rioja Racing Rioja 34 27 57 32
18 Arnedo Arnedo 34 28 65 24
TEMPORADA 2021/2022
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Racing 38 61 31 82
2 RC Deportivo Deportivo 38 59 29 74
3 Racing Ferrol Racing 38 50 26 72
4 Rayo Majadahonda Rayo 38 50 47 62
5 UD Logroñés Logroñés 38 41 37 62
6 Celta Fortuna Celta 38 60 46 61
7 Unionistas CF Unionistas 38 55 37 61
8 Real Unión Club Real Unión 38 51 45 60
9 CD Badajoz CD Badajoz 38 40 30 56
10 UD Sanse UD Sanse 38 40 41 53
11 CD Calahorra Calahorra 38 48 43 52
12 Cultural Leonesa Cultural 38 61 55 49
13 SD Logroñés Logroñés 38 43 43 48
14 Internacional de Madrid Internaciona 38 46 51 46
15 Bilbao Ath. Bilbao Ath. 38 36 46 45
16 CF Talavera CF Talavera 38 39 54 42
17 Zamora Zamora 38 30 48 37
18 Real Valladolid Promesas Real 38 42 64 36
19 Tudelano Tudelano 38 33 54 28
20 Extremadura Extremadura 38 22 80 0
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 20 35 16 40
2 Bilbao Ath. Bilbao Ath. 20 34 19 39
3 SD Amorebieta Amorebieta 20 26 19 37
4 Racing Racing 20 30 17 35
5 Real Unión Club Real Unión 20 26 18 33
6 Arenas de Getxo Arenas Getxo 20 15 15 26
7 CD Laredo CD Laredo 20 17 27 24
8 Portugalete Portugalete 20 16 19 22
9 Deportivo Alavés B Deportivo 20 22 31 20
10 Barakaldo Barakaldo 20 19 39 17
11 Leioa Leioa 20 12 32 10
12 Tudelano Tudelano 18 29 14 34
13 CD Calahorra Calahorra 18 17 6 34
14 SD Logroñés Logroñés 18 20 14 29
15 CD Ebro CD Ebro 18 15 17 28
16 Osasuna Promesas Osasuna 18 21 22 24
17 SD Tarazona SD Tarazona 18 16 22 24
18 Mutilvera Mutilvera 18 23 18 23
19 Ejea Ejea 18 12 19 18
20 Izarra Izarra 18 14 25 15
21 Haro Deportivo Haro 18 14 24 12
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 UD Logroñés Logroñés 28 49 19 62
2 Cultural Leonesa Cultural 28 45 28 49
3 Bilbao Ath. Bilbao Ath. 28 55 35 49
4 Real Valladolid Promesas Real 28 43 28 47
5 Real Sociedad B Real 28 47 35 44
6 SD Amorebieta Amorebieta 28 38 38 42
7 Osasuna Promesas Osasuna 28 35 35 40
8 Burgos Burgos 28 31 37 39
9 Guijuelo Guijuelo 28 30 26 37
10 Haro Deportivo Haro 28 29 33 36
11 Deportivo Alavés B Deportivo 28 28 31 34
12 CD Calahorra Calahorra 28 28 32 34
13 Salamanca UDS Salamanca 28 30 39 34
14 Barakaldo Barakaldo 28 33 42 32
15 Leioa Leioa 28 35 38 31
16 Unionistas CF Unionistas 28 39 43 31
17 Real Unión Club Real Unión 28 29 33 29
18 Arenas de Getxo Arenas Getxo 28 27 43 28
19 Izarra Izarra 28 29 47 28
20 Tudelano Tudelano 28 26 44 24
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Racing Racing 38 66 25 78
2 UD Logroñés Logroñés 38 44 22 72
3 Mirandés Mirandés 38 53 32 69
4 Barakaldo Barakaldo 38 41 40 61
5 Real Oviedo Vetusta Real Oviedo 38 55 45 59
6 Bilbao Ath. Bilbao Ath. 38 67 45 57
7 Leioa Leioa 38 43 40 53
8 SD Amorebieta Amorebieta 38 44 45 53
9 Langreo Langreo 38 43 48 52
10 CD Calahorra Calahorra 38 45 52 50
11 Sporting Atlético Sporting 38 42 43 49
12 Real Sociedad B Real 38 47 42 45
13 Izarra Izarra 38 33 44 45
14 Tudelano Tudelano 38 33 42 45
15 Arenas de Getxo Arenas Getxo 38 33 40 45
16 Real Unión Club Real Unión 38 39 44 44
17 SD Gernika SD Gernika 38 32 42 42
18 CD Vitoria CD Vitoria 38 34 51 35
19 Gimnástica Torrelavega Gimnástica 38 25 44 32
20 SCD Durango SCD Durango 38 32 65 30
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Mirandés Mirandés 38 53 33 76
2 Sporting Atlético Sporting 38 61 36 75
3 Real Sociedad B Real 38 49 24 74
4 Bilbao Ath. Bilbao Ath. 38 67 27 73
5 Racing Racing 38 44 33 68
6 Barakaldo Barakaldo 38 50 28 63
7 UD Logroñés Logroñés 38 55 35 61
8 SD Gernika SD Gernika 38 46 41 59
9 Tudelano Tudelano 38 38 32 53
10 Leioa Leioa 38 47 42 51
11 Burgos Burgos 38 28 28 51
12 Arenas de Getxo Arenas Getxo 38 46 43 46
13 Real Unión Club Real Unión 38 32 46 46
14 SD Amorebieta Amorebieta 38 44 46 44
15 CD Vitoria CD Vitoria 38 40 44 43
16 Izarra Izarra 38 32 58 39
17 Peña Sport Peña Sport 38 33 62 35
18 Lealtad Villaviciosa Lealtad 38 26 60 28
19 Osasuna Promesas Osasuna 38 25 63 24
20 Caudal Deportivo Caudal 38 19 54 19
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Cultural Leonesa Cultural 38 86 28 86
2 Racing Racing 38 64 20 86
3 Celta Fortuna Celta 38 76 31 84
4 Pontevedra Pontevedra 38 48 36 60
5 Ponferradina Ponferradina 38 35 40 55
6 Real Valladolid Promesas Real 38 40 42 54
7 Racing Ferrol Racing 38 50 38 54
8 Coruxo Coruxo 38 43 58 49
9 Tudelano Tudelano 38 32 34 49
10 Lealtad Villaviciosa Lealtad 38 38 39 48
11 Osasuna Promesas Osasuna 38 48 53 47
12 Guijuelo Guijuelo 38 57 49 47
13 Izarra Izarra 38 37 45 46
14 Boiro Boiro 38 39 45 45
15 Caudal Deportivo Caudal 38 47 56 45
16 Burgos Burgos 38 43 54 45
17 Mutilvera Mutilvera 38 32 46 43
18 CD Palencia Balompié Palencia 38 26 60 38
19 Arandina Arandina 38 39 64 32
20 Somozas Somozas 38 23 65 24
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Racing 38 56 28 74
2 Racing Ferrol Racing 38 60 28 73
3 Tudelano Tudelano 38 48 23 72
4 UD Logroñés Logroñés 38 50 28 66
5 Burgos Burgos 38 47 39 58
6 Guijuelo Guijuelo 38 35 35 57
7 Cultural Leonesa Cultural 38 39 32 56
8 Somozas Somozas 38 41 38 55
9 Pontevedra Pontevedra 38 38 37 54
10 Lealtad Villaviciosa Lealtad 38 50 44 50
11 Celta Fortuna Celta 38 47 55 50
12 Izarra Izarra 38 35 37 50
13 Real Valladolid Promesas Real 38 42 49 48
14 Coruxo Coruxo 38 49 51 46
15 Arandina Arandina 38 43 61 45
16 CP Cacereño Cacereño 38 33 45 43
17 Sporting Atlético Sporting 38 34 52 42
18 Atl. Astorga Atl. Astorga 38 44 55 40
19 SD Compostela Compostela 38 29 42 38
20 Peña Sport Peña Sport 38 29 70 26
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Huesca Huesca 38 61 30 69
2 Bilbao Ath. Bilbao Ath. 38 65 30 66
3 CD Guadalajara Guadalajara 38 49 43 61
4 Real Unión Club Real Unión 38 48 38 60
5 Tudelano Tudelano 38 42 31 58
6 RM Castilla RM Castilla 38 59 40 58
7 Barakaldo Barakaldo 38 50 43 58
8 UD Yugo Socuéllamos Yugo 38 45 45 58
9 CD Toledo CD Toledo 38 47 54 57
10 SD Amorebieta Amorebieta 38 59 54 52
11 Fuenlabrada Fuenlabrada 38 43 54 51
12 Getafe B Getafe B 38 50 51 51
13 Sestao River Sestao River 38 46 51 50
14 Real Sociedad B Real 38 51 56 48
15 Leioa Leioa 38 42 60 48
16 Las Palmas At. Palmas 38 58 60 47
17 Rayo Vallecano B Rayo 38 43 60 43
18 Atlético B Atlético B 38 52 62 41
19 Trival Valderas Trival 38 42 71 37
20 UB Conquense Conquense 38 48 67 30
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Sestao River Sestao River 38 61 41 71
2 Leganés Leganés 38 53 24 70
3 CD Toledo CD Toledo 38 51 33 67
4 Las Palmas At. Palmas 38 50 27 66
5 Bilbao Ath. Bilbao Ath. 38 59 38 65
6 Fuenlabrada Fuenlabrada 38 51 38 64
7 Huesca Huesca 38 52 43 63
8 Barakaldo Barakaldo 38 48 37 60
9 Real Madrid C Real Madrid 38 66 54 56
10 SD Amorebieta Amorebieta 38 55 54 55
11 UB Conquense Conquense 38 47 53 53
12 Real Sociedad B Real 38 41 38 51
13 Tudelano Tudelano 38 45 50 46
14 Getafe B Getafe B 38 37 48 46
15 Real Unión Club Real Unión 38 34 42 44
16 Atlético B Atlético B 38 43 48 41
17 Laudio Laudio 38 42 66 37
18 Puerta Bonita Puerta 38 35 52 36
19 Peña Sport Peña Sport 38 17 60 23
20 Sariñena Sariñena 38 17 58 22
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 38 57 22 82
2 Eibar Eibar 38 59 28 73
3 Bilbao Ath. Bilbao Ath. 38 64 35 71
4 Lleida Esportiu Lleida 38 56 34 66
5 Barakaldo Barakaldo 38 42 23 65
6 SD Amorebieta Amorebieta 38 48 39 60
7 Tudelano Tudelano 38 48 46 56
8 Real Unión Club Real Unión 38 53 39 55
9 Noja Noja 38 43 48 47
10 SD Logroñés Logroñés 38 37 60 46
11 Real Sociedad B Real 38 37 45 46
12 Sestao River Sestao River 38 34 40 43
13 Gimnástica Torrelavega Gimnástica 38 36 46 42
14 UD Logroñés Logroñés 38 27 37 42
15 Peña Sport Peña Sport 38 35 41 41
16 Deportivo Aragón Deportivo 38 44 52 41
17 Rayo Cantabria Rayo 38 37 52 41
18 CD Teruel CD Teruel 38 33 52 38
19 Osasuna Promesas Osasuna 38 40 65 36
20 Izarra Izarra 38 31 57 35
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Peña Sport Peña Sport 38 88 35 92
2 Izarra Izarra 38 104 33 90
3 Tudelano Tudelano 38 97 26 88
4 Mutilvera Mutilvera 38 71 32 80
5 AD San Juan AD San Juan 38 50 36 66
6 Txantrea Txantrea 38 54 38 60
7 Murchante Murchante 38 61 64 54
8 Cirbonero Cirbonero 38 57 53 53
9 CD Iruña CD Iruña 38 53 53 52
10 CD Pamplona CD Pamplona 38 47 65 43
11 Oberena Oberena 38 48 61 42
12 CD Itaroa Huarte Itaroa 38 54 60 41
13 CD Valle de Egüés Valle 38 43 60 41
14 Idoya Idoya 38 36 61 39
15 Burladés Burladés 38 40 48 38
16 Aoiz Aoiz 38 49 74 38
17 CD Cortes CD Cortes 38 33 63 37
18 Lourdes Lourdes 38 39 77 33
19 Azkoyen Azkoyen 38 34 65 32
20 Aluvión Aluvión 38 33 87 21
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Tudelano Tudelano 38 87 24 90
2 Nivel Andalucia Pizarra Nivel 38 78 24 83
3 CD Valle de Egüés Valle 38 57 45 67
4 Mutilvera Mutilvera 38 60 34 66
5 Txantrea Txantrea 38 57 35 65
6 CD Iruña CD Iruña 38 52 36 59
7 AD San Juan AD San Juan 38 38 30 56
8 Cirbonero Cirbonero 38 51 46 53
9 Lourdes Lourdes 38 52 57 53
10 Oberena Oberena 38 40 39 52
11 CD Pamplona CD Pamplona 38 51 49 49
12 Murchante Murchante 38 50 57 45
13 CD Itaroa Huarte Itaroa 38 45 48 44
14 Aoiz Aoiz 38 37 49 42
15 Aluvión Aluvión 38 34 44 41
16 Idoya Idoya 38 51 77 41
17 CF Ardoi CF Ardoi 38 29 57 38
18 Lagun Artea Lagun Artea 38 38 80 37
19 River Ega River Ega 38 26 73 27
20 Peña Azagresa Peña 38 34 63 25
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Tudelano Tudelano 38 87 29 89
2 Peña Sport Peña Sport 38 87 27 82
3 Cirbonero Cirbonero 38 57 38 71
4 CD Iruña CD Iruña 38 58 35 69
5 Mutilvera Mutilvera 38 69 46 65
6 AD San Juan AD San Juan 38 50 36 58
7 CD Valle de Egüés Valle 38 51 43 57
8 Txantrea Txantrea 38 40 38 52
9 Lourdes Lourdes 38 67 64 52
10 Oberena Oberena 38 62 49 49
11 CD Pamplona CD Pamplona 38 33 45 48
12 Aoiz Aoiz 38 36 39 48
13 Aluvión Aluvión 38 44 61 44
14 River Ega River Ega 38 33 38 41
15 Peña Azagresa Peña 38 44 61 41
16 Murchante Murchante 38 29 50 40
17 CD Itaroa Huarte Itaroa 38 38 59 39
18 Valtierrano Valtierrano 38 34 91 36
19 Zarramonza Zarramonza 38 28 58 34
20 CD Cortes CD Cortes 38 25 65 23
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Izarra Izarra 36 75 27 82
2 Peña Sport Peña Sport 36 72 31 79
3 Tudelano Tudelano 36 65 32 69
4 Mutilvera Mutilvera 37 61 36 67
5 AD San Juan AD San Juan 36 61 39 63
6 CD Iruña CD Iruña 36 55 39 60
7 Cirbonero Cirbonero 37 44 40 54
8 CD Valle de Egüés Valle 36 50 46 51
9 CD Itaroa Huarte Itaroa 36 44 37 48
10 River Ega River Ega 36 41 54 46
11 Lourdes Lourdes 36 42 52 46
12 Aoiz Aoiz 37 42 47 45
13 Oberena Oberena 36 48 58 44
14 Txantrea Txantrea 36 42 46 43
15 Aluvión Aluvión 36 48 67 41
16 Murchante Murchante 36 34 52 39
17 Idoya Idoya 36 38 53 39
18 Peña Azagresa Peña 37 46 72 38
19 CF Ardoi CF Ardoi 36 44 54 36
20 Lagunak Lagunak 36 32 63 31
21 Mendi Mendi 36 29 68 23
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Izarra Izarra 38 63 32 81
2 Mutilvera Mutilvera 38 57 42 74
3 CD Iruña CD Iruña 38 70 34 74
4 Tudelano Tudelano 38 64 35 70
5 AD San Juan AD San Juan 38 58 33 69
6 CD Valle de Egüés Valle 38 53 33 67
7 Aluvión Aluvión 38 55 35 65
8 Murchante Murchante 38 44 37 55
9 Txantrea Txantrea 38 43 45 55
10 Lourdes Lourdes 38 58 51 54
11 Aoiz Aoiz 38 40 34 52
12 Oberena Oberena 38 42 57 46
13 River Ega River Ega 38 48 56 46
14 Cirbonero Cirbonero 38 43 50 46
15 CF Ardoi CF Ardoi 38 46 66 40
16 CD Itaroa Huarte Itaroa 38 40 60 34
17 Idoya Idoya 38 42 62 31
18 Artajonés Artajonés 38 44 66 30
19 Zarramonza Zarramonza 38 34 78 29
20 Burladés Burladés 38 26 64 29
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 CD Valle de Egüés Valle 38 77 43 84
2 Peña Sport Peña Sport 38 72 25 82
3 Mutilvera Mutilvera 38 63 37 78
4 Tudelano Tudelano 38 64 40 74
5 Izarra Izarra 38 57 46 62
6 Cirbonero Cirbonero 38 70 50 61
7 CD Itaroa Huarte Itaroa 38 51 41 55
8 Aluvión Aluvión 38 50 51 54
9 Txantrea Txantrea 38 48 52 51
10 Burladés Burladés 38 42 51 46
11 River Ega River Ega 38 49 53 46
12 Murchante Murchante 38 36 54 45
13 CD Iruña CD Iruña 38 56 60 44
14 Oberena Oberena 38 43 48 44
15 Aoiz Aoiz 38 49 48 42
16 CF Ardoi CF Ardoi 38 44 64 42
17 Lourdes Lourdes 38 45 56 40
18 Azkoyen Azkoyen 38 42 57 39
19 Lagunak Lagunak 38 30 50 36
20 Avance Ezcabarte Avance 38 30 92 18
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 Peña Sport Peña Sport 36 72 35 78
2 CD Valle de Egüés Valle 36 70 31 71
3 CD Itaroa Huarte Itaroa 36 59 35 69
4 CD Iruña CD Iruña 36 75 49 69
5 Oberena Oberena 36 57 29 66
6 Mutilvera Mutilvera 36 43 33 56
7 Aluvión Aluvión 36 44 48 49
8 Tudelano Tudelano 36 39 39 49
9 Burladés Burladés 36 47 51 46
10 Txantrea Txantrea 36 38 41 45
11 Aoiz Aoiz 36 44 49 44
12 Murchante Murchante 36 34 42 43
13 Cirbonero Cirbonero 36 52 64 41
14 Lourdes Lourdes 36 39 59 39
15 River Ega River Ega 36 44 57 38
16 Lagun Artea Lagun Artea 36 43 61 38
17 Artajonés Artajonés 36 36 60 36
18 Beti Onak Beti Onak 36 51 73 33
19 AD San Juan AD San Juan 36 25 56 26
TEMPORADA 2004/2005
TERCERA DIVISIÓN GRUPO 15
Equipo PJ GF GC Puntos
1 CD Valle de Egüés Valle 34 58 20 68
2 Mutilvera Mutilvera 34 51 24 67
3 Beti Onak Beti Onak 34 53 43 56
4 CD Iruña CD Iruña 34 45 36 53
5 Murchante Murchante 34 37 44 49
6 Lagun Artea Lagun Artea 34 44 45 48
7 Aluvión Aluvión 34 39 44 47
8 Burladés Burladés 34 40 35 46
9 Cirbonero Cirbonero 34 43 48 46
10 River Ega River Ega 34 41 39 45
11 Aoiz Aoiz 34 38 48 44
12 Txantrea Txantrea 34 39 43 43
13 Tudelano Tudelano 34 31 33 43
14 Oberena Oberena 34 41 35 43
15 CD Itaroa Huarte Itaroa 34 40 49 42
16 CD Urroztarra Urroztarra 34 37 46 40
17 Izarra Izarra 34 34 39 39
18 Subiza Subiza 34 29 69 22

  USO DE MEMORIA  
8,569,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1641
Total Execution Time  0.1655
  CADENA URL  
/historico/Tudelano
  GET DATOS  
$_GET['/historico/Tudelano']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0041  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 = 'Tudelano' 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.0018  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=2545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=2545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2545 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2545 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=2545 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2545 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (2598,2826,3254,5358,10357) ORDER BY n.cover_points DESC, update_date 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 = '2545' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '2545' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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=2545 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72363,71759,71432,68196) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72363 AND teamId = 2545
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 71759 AND teamId = 2545
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68196 AND teamId = 2545
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2545
0.0020  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 = '2545' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2545' and rp.type = 4
0.0021  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 = '2545' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0017  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '2545' and rp.type = 4
0.0034  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 = 72363 WHERE rp.league_id = 72363 AND rp.teamId = 2545 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.0030  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 = 72363 WHERE rp.league_id = 72363 AND rp.teamId = 2545 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72363 WHERE rp.league_id = 72363 AND rp.teamId = 2545 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 2545 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0039  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 = 67966 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 62378 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.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 `tables2020` 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 = 50266 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2019` 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 = 44096 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 33378 AND t.round = 38 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 `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 = 15375 AND t.round = 38 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 `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 = 3863 AND t.round = 38 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 `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 = 2469 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1903 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0045  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 = 1449 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1135 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 `tables2010` 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 = 842 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 `tables2009` 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 = 145 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2008` 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 = 22 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2007` 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 = 100 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables2006` 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 = 22127 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 `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 = 22108 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC