4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 RC Deportivo Deportivo 34 58 25 68
2 Barça Atlètic Barça 34 54 37 64
3 Gimnàstic Tarragona Gimnàstic 34 35 22 60
4 Celta Fortuna Celta 34 62 35 60
5 Ponferradina Ponferradina 34 34 23 57
6 Cultural Leonesa Cultural 34 33 24 55
7 Arenteiro Arenteiro 34 41 32 50
8 Unionistas CF Unionistas 34 33 28 48
9 Real Sociedad B Real 34 40 38 46
10 CD Lugo CD Lugo 34 29 39 43
11 Osasuna Promesas Osasuna 34 41 46 41
12 SD Tarazona SD Tarazona 34 24 28 40
13 Real Unión Club Real Unión 34 42 47 39
14 Fuenlabrada Fuenlabrada 34 29 37 39
15 Sestao River Sestao River 34 35 45 38
16 CE Sabadell CE Sabadell 34 33 51 37
17 CD Teruel CD Teruel 34 28 35 36
18 UE Cornellà Cornellà 34 28 36 35
19 SD Logroñés Logroñés 34 22 52 28
20 Rayo Majadahonda Rayo 34 26 47 25
TEMPORADA 2022/2023
PRIMERA FEDERACIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Ferrol Racing 38 55 25 75
2 Alcorcón Alcorcón 38 53 23 74
3 RM Castilla RM Castilla 38 58 38 69
4 RC Deportivo Deportivo 38 53 29 67
5 Celta Fortuna Celta 38 48 38 59
6 Linares Deportivo Linares 38 53 53 59
7 Unionistas CF Unionistas 38 38 40 56
8 AD Mérida AD Mérida 38 40 37 54
9 Córdoba CF Córdoba CF 38 48 37 54
10 Cultural Leonesa Cultural 38 41 43 48
11 Fuenlabrada Fuenlabrada 38 32 51 46
12 AD Ceuta FC AD Ceuta FC 38 53 52 45
13 San Fernando CD Fernando 38 46 50 45
14 Rayo Majadahonda Rayo 38 42 51 45
15 Algeciras CF Algeciras 38 36 47 44
16 CD Badajoz CD Badajoz 38 35 52 43
17 UD Sanse UD Sanse 38 30 46 43
18 RB Linense RB Linense 38 31 34 42
19 Pontevedra Pontevedra 38 34 53 36
20 CF Talavera CF Talavera 38 36 63 33
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 1
Equipo PJ GF GC Puntos
1 Celta Fortuna Celta 18 22 20 30
2 Unionistas CF Unionistas 18 17 10 30
3 Zamora Zamora 18 18 17 30
4 RC Deportivo Deportivo 18 14 10 29
5 Racing Ferrol Racing 18 22 17 27
6 SD Compostela Compostela 18 20 16 25
7 Pontevedra Pontevedra 18 19 19 21
8 Coruxo Coruxo 18 16 23 20
9 Salamanca UDS Salamanca 18 17 23 19
10 Guijuelo Guijuelo 18 12 22 12
11 Burgos Burgos 18 24 12 39
12 Cultural Leonesa Cultural 18 27 15 31
13 Real Valladolid Promesas Real 18 24 17 30
14 Numancia Numancia 18 23 14 25
15 Langreo Langreo 18 21 20 25
16 Marino de Luanco Marino 18 18 22 22
17 Real Oviedo Vetusta Real Oviedo 18 17 27 21
18 Lealtad Villaviciosa Lealtad 18 11 14 20
19 Sporting Atlético Sporting 18 16 24 16
20 CD Covadonga Covadonga 18 21 37 14
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 1
Equipo PJ GF GC Puntos
1 Fuenlabrada Fuenlabrada 38 49 21 71
2 Ponferradina Ponferradina 38 55 27 69
3 Atlético B Atlético B 38 57 32 68
4 RM Castilla RM Castilla 38 62 45 65
5 Cultural Leonesa Cultural 38 56 34 65
6 Pontevedra Pontevedra 38 45 38 62
7 Guijuelo Guijuelo 38 35 33 59
8 UD Sanse UD Sanse 38 54 45 56
9 Unionistas CF Unionistas 38 39 37 52
10 Coruxo Coruxo 38 38 41 50
11 Real Valladolid Promesas Real 38 33 40 49
12 Salamanca UDS Salamanca 38 40 42 49
13 Burgos Burgos 38 28 32 48
14 Internacional de Madrid Internaciona 38 47 54 48
15 Las Palmas At. Palmas 38 26 33 48
16 Celta Fortuna Celta 38 45 48 46
17 Rápido de Bouzas Rápido 38 28 55 38
18 Unión Adarve Unión 38 42 62 36
19 CDA Navalcarnero Navalcarnero 38 37 70 25
20 Deportivo Fabril Deportivo 38 28 55 24
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Rayo Vallecano Rayo 42 67 48 76
2 Huesca Huesca 42 61 40 75
3 Real Zaragoza Real 42 57 44 71
4 Real Sporting Real 42 60 40 71
5 Real Valladolid Real 42 69 55 67
6 Numancia Numancia 42 52 41 65
7 Real Oviedo Real Oviedo 42 54 48 65
8 Osasuna Osasuna 42 44 34 64
9 Cádiz Cádiz 42 42 29 64
10 Granada Granada 42 55 50 61
11 Tenerife Tenerife 42 58 50 59
12 CD Lugo CD Lugo 42 39 48 55
13 Alcorcón Alcorcón 42 37 42 52
14 Reus Deportiu Reus 42 31 42 52
15 Gimnàstic Tarragona Gimnàstic 42 44 50 52
16 Córdoba CF Córdoba CF 42 57 65 51
17 Albacete Albacete 42 35 46 49
18 Almería Almería 42 38 45 48
19 Cultural Leonesa Cultural 42 54 67 48
20 Barça Atlètic Barça 42 46 54 44
21 Lorca FC Lorca FC 42 37 68 33
22 Sevilla At. Sevilla At. 42 29 60 32
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 1
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 38 77 31 80
2 Real Murcia Real Murcia 38 47 26 72
3 Racing Ferrol Racing 38 65 41 69
4 UD Logroñés Logroñés 38 49 37 66
5 Guijuelo Guijuelo 38 58 48 61
6 SD Compostela Compostela 38 45 39 61
7 Cultural Leonesa Cultural 38 52 43 59
8 Coruxo Coruxo 38 44 47 53
9 Real Valladolid Promesas Real 38 54 54 52
10 Somozas Somozas 38 44 43 52
11 Sporting Atlético Sporting 38 49 50 50
12 Burgos Burgos 38 37 40 49
13 Celta Fortuna Celta 38 49 58 48
14 Atl. Astorga Atl. Astorga 38 50 56 45
15 Lealtad Villaviciosa Lealtad 38 38 49 44
16 Real Avilés Industrial Real Avilés 38 36 53 43
17 Langreo Langreo 38 37 49 43
18 Zamora Zamora 38 38 51 39
19 Tropezón Tropezón 38 38 62 36
20 Marino de Luanco Marino 38 26 56 21
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Racing Racing 36 55 27 66
2 Racing Ferrol Racing 36 58 35 63
3 Real Avilés Industrial Real Avilés 36 53 31 63
4 Guijuelo Guijuelo 36 49 31 60
5 Real Oviedo Real Oviedo 36 52 42 57
6 Marino de Luanco Marino 36 50 34 54
7 Zamora Zamora 36 43 40 54
8 Sporting Atlético Sporting 36 52 50 50
9 CD Ourense CD Ourense 36 36 34 50
10 Burgos Burgos 36 38 44 46
11 UD Logroñés Logroñés 36 33 45 46
12 Tropezón Tropezón 36 38 55 44
13 SD Compostela Compostela 36 53 46 44
14 Cultural Leonesa Cultural 36 39 43 44
15 Coruxo Coruxo 36 38 47 44
16 Caudal Deportivo Caudal 36 41 50 39
17 SD Logroñés Logroñés 36 36 52 38
18 Celta Fortuna Celta 36 37 61 34
19 Noja Noja 36 36 70 24
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Burgos Burgos 38 80 19 90
2 Cultural Leonesa Cultural 38 70 25 82
3 Arandina Arandina 38 65 22 82
4 Gimnástica Segoviana Gimnástica 38 80 38 75
5 Real Valladolid Promesas Real 38 68 25 73
6 CD La Granja Granja 38 50 36 69
7 Atl. Astorga Atl. Astorga 38 60 41 68
8 Atl. Bembibre Atl. 38 55 43 59
9 La Virgen del Camino Virgen 38 51 51 57
10 Real Ávila Real Ávila 38 47 46 55
11 Numancia B Numancia B 38 51 56 53
12 Palencia Cristo Atlético Palencia 38 35 46 43
13 SD Almazán SD Almazán 38 36 55 43
14 Unami CP Unami CP 38 39 67 38
15 Salamanca B Salamanca B 38 27 48 36
16 Racing Lermeño CF Racing 38 35 63 34
17 UD Santa Marta Santa Marta 38 25 50 32
18 Palencia Palencia 38 32 67 32
19 CD Villaralbo Villaralbo 38 24 65 32
20 CD Cuéllar Balompié Cuéllar 38 20 87 9
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Real Valladolid Promesas Real 38 76 42 79
2 Real Ávila Real Ávila 38 79 43 78
3 Cultural Leonesa Cultural 38 75 37 76
4 CD Villaralbo Villaralbo 38 72 38 73
5 Atl. Bembibre Atl. 38 72 33 72
6 Atl. Astorga Atl. Astorga 38 76 36 70
7 Iscar Iscar 38 51 61 59
8 La Virgen del Camino Virgen 38 60 51 58
9 Numancia B Numancia B 38 59 60 51
10 SD Almazán SD Almazán 38 40 54 49
11 Palencia Cristo Atlético Palencia 38 54 54 48
12 Racing Lermeño CF Racing 38 41 62 48
13 CD La Granja Granja 38 41 42 46
14 Atlético Tordesillas Atlético 38 43 61 45
15 Salamanca B Salamanca B 38 45 56 42
16 Burgos CF B Burgos CF B 38 44 53 40
17 Cd Aguilar Cd Aguilar 38 45 62 38
18 CD Huracán Z Huracán 38 45 74 36
19 Béjar Industrial Béjar 38 46 77 35
20 Ponferradina B Ponferradina 38 31 99 12
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Eibar Eibar 38 58 32 73
2 Mirandés Mirandés 38 52 24 72
3 Deportivo Alavés Deportivo 38 63 43 66
4 Real Unión Club Real Unión 38 51 35 65
5 Palencia Palencia 38 44 28 63
6 UD Logroñés Logroñés 38 44 32 63
7 Osasuna Promesas Osasuna 38 49 39 58
8 Real Oviedo Real Oviedo 38 45 34 58
9 Lemona Lemona 38 42 38 53
10 Gimnástica Torrelavega Gimnástica 38 34 41 52
11 Real Sociedad B Real 38 34 37 51
12 Bilbao Ath. Bilbao Ath. 38 29 37 46
13 Zamora Zamora 38 46 56 43
14 Cultural Leonesa Cultural 38 42 48 43
15 Guijuelo Guijuelo 38 39 44 39
16 Caudal Deportivo Caudal 38 29 38 38
17 La Muela La Muela 38 36 56 38
18 Peña Sport Peña Sport 38 30 56 36
19 Sporting Atlético Sporting 38 26 54 34
20 Barakaldo Barakaldo 38 27 48 24
TEMPORADA 2009/2010
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Ponferradina Ponferradina 38 44 21 75
2 Eibar Eibar 38 45 34 66
3 Palencia Palencia 38 46 27 65
4 Pontevedra Pontevedra 38 48 37 63
5 Deportivo Alavés Deportivo 38 45 31 62
6 Lemona Lemona 38 51 42 53
7 CD Lugo CD Lugo 38 49 41 53
8 Osasuna Promesas Osasuna 38 38 43 52
9 Celta Fortuna Celta 38 53 61 51
10 Cultural Leonesa Cultural 38 46 49 49
11 Barakaldo Barakaldo 38 40 43 49
12 Mirandés Mirandés 38 44 42 48
13 Montañeros Montañeros 38 46 51 47
14 Zamora Zamora 38 39 51 46
15 Bilbao Ath. Bilbao Ath. 38 35 42 46
16 Guijuelo Guijuelo 38 38 36 45
17 Sestao River Sestao River 38 32 40 44
18 Izarra Izarra 38 41 50 39
19 Racing Ferrol Racing 38 31 43 37
20 SD Compostela Compostela 38 38 65 30
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Real Unión Club Real Unión 38 57 25 75
2 Cultural Leonesa Cultural 38 45 23 70
3 Ponferradina Ponferradina 38 54 41 63
4 Zamora Zamora 38 47 34 61
5 Celta Fortuna Celta 38 42 26 58
6 Lemona Lemona 38 31 31 58
7 Racing Ferrol Racing 38 43 44 56
8 CD Lugo CD Lugo 38 57 48 55
9 Guijuelo Guijuelo 38 45 37 53
10 Barakaldo Barakaldo 38 35 39 53
11 Bilbao Ath. Bilbao Ath. 38 48 43 52
12 Pontevedra Pontevedra 38 50 49 51
13 Ciudad de Santiago Ciudad 38 42 42 50
14 Rayo Cantabria Rayo 38 38 47 47
15 Sestao River Sestao River 38 37 41 46
16 Sporting Atlético Sporting 38 46 55 45
17 Deportivo Fabril Deportivo 38 40 53 39
18 Real Sociedad B Real 38 29 43 39
19 Real Valladolid Promesas Real 38 32 61 36
20 Marino de Luanco Marino 38 22 58 33
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Ponferradina Ponferradina 38 52 28 67
2 Huesca Huesca 38 45 27 67
3 Barakaldo Barakaldo 38 45 34 63
4 Zamora Zamora 38 43 38 63
5 Real Unión Club Real Unión 38 48 34 62
6 UB Conquense Conquense 38 54 44 61
7 Lemona Lemona 38 42 34 60
8 CD Guadalajara Guadalajara 38 45 49 58
9 Guijuelo Guijuelo 38 42 41 57
10 Sestao River Sestao River 38 34 26 55
11 Cultural Leonesa Cultural 38 49 44 52
12 Real Sociedad B Real 38 40 38 50
13 CD Logroñés Logroñés 38 40 46 47
14 Real Valladolid Promesas Real 38 37 48 44
15 Bilbao Ath. Bilbao Ath. 38 40 50 42
16 Logroñes CF Logroñes 38 37 40 40
17 Burgos Burgos 38 30 39 40
18 Osasuna Promesas Osasuna 38 25 37 40
19 Palencia Palencia 38 30 46 39
20 Peña Sport Peña Sport 38 31 66 23
TEMPORADA 2006/2007
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Eibar Eibar 38 51 26 71
2 Burgos Burgos 38 51 24 69
3 Palencia Palencia 38 38 29 65
4 Real Unión Club Real Unión 38 43 26 65
5 Sestao River Sestao River 38 42 29 65
6 Barakaldo Barakaldo 38 45 26 63
7 Real Sociedad B Real 38 54 39 61
8 Lemona Lemona 38 40 28 60
9 Zamora Zamora 38 44 36 52
10 Logroñes CF Logroñes 38 36 38 51
11 Cultural Leonesa Cultural 38 37 40 51
12 Guijuelo Guijuelo 38 41 33 50
13 Marino de Luanco Marino 38 31 31 49
14 CD Logroñés Logroñés 38 36 49 46
15 Bilbao Ath. Bilbao Ath. 38 39 49 45
16 Real Valladolid Promesas Real 38 31 47 43
17 CD Alfaro CD Alfaro 38 41 55 41
18 Universidad Oviedo Universidad 38 34 68 36
19 Real Oviedo Real Oviedo 38 27 47 32
20 Amurrio Amurrio 38 19 60 19
TEMPORADA 2005/2006
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 61 33 75
2 Real Sociedad B Real 38 60 34 65
3 Burgos Burgos 38 48 38 64
4 Ponferradina Ponferradina 38 47 32 62
5 Real Unión Club Real Unión 38 43 30 56
6 Bilbao Ath. Bilbao Ath. 38 40 34 55
7 Real Oviedo Real Oviedo 38 37 35 55
8 Rayo Cantabria Rayo 38 47 42 54
9 Lemona Lemona 38 27 25 53
10 Real Valladolid Promesas Real 38 52 42 50
11 Marino de Luanco Marino 38 38 37 50
12 Palencia Palencia 38 36 34 49
13 Zamora Zamora 38 45 43 48
14 Cultural Leonesa Cultural 38 37 45 47
15 Barakaldo Barakaldo 38 32 38 46
16 Amurrio Amurrio 38 36 45 44
17 SCD Durango SCD Durango 38 36 59 41
18 Deportivo Alavés B Deportivo 38 32 55 38
19 Portugalete Portugalete 38 32 55 37
20 Zalla Zalla 38 36 66 35
TEMPORADA 2004/2005
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Ponferradina Ponferradina 38 43 28 69
2 Real Unión Club Real Unión 38 47 27 68
3 Burgos Burgos 38 44 24 63
4 Zamora Zamora 38 39 30 62
5 Real Sociedad B Real 38 38 30 61
6 Logroñes CF Logroñes 38 35 37 61
7 Barakaldo Barakaldo 38 41 32 59
8 Cultural Leonesa Cultural 38 53 37 58
9 Lemona Lemona 38 34 26 58
10 Bilbao Ath. Bilbao Ath. 38 53 43 57
11 Amurrio Amurrio 38 33 25 51
12 Deportivo Alavés B Deportivo 38 39 34 49
13 Palencia Palencia 38 40 41 45
14 CD Alfaro CD Alfaro 38 42 53 43
15 Marino de Luanco Marino 38 39 48 42
16 Mirandés Mirandés 38 26 35 42
17 Guijuelo Guijuelo 38 37 48 39
18 Sestao River Sestao River 38 34 54 32
19 Gimnástica Torrelavega Gimnástica 38 29 58 32
20 Haro Deportivo Haro 38 18 54 22

  USO DE MEMORIA  
8,570,400 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6153
Total Execution Time  0.6165
  CADENA URL  
/historico/Cultural-Deportiva-Leonesa
  GET DATOS  
$_GET['/historico/Cultural-Deportiva-Leonesa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=877 AND type_rel = 2
0.0219  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 877 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0142  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 (945,2225,2598,2642,2826) ORDER BY n.cover_points DESC, update_date DESC
0.0167  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 = '877' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0184  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=877 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72358,71432,68343,68172) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72358 AND teamId = 877
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 68343 AND teamId = 877
0.0220  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 877
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 68172 AND teamId = 877
0.0129  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 = '877' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '877' and rp.type = 4
0.0135  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 = '877' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '877' and rp.type = 4
0.0141  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 877 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.0145  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 877 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 = 72358 WHERE rp.league_id = 72358 AND rp.teamId = 877 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 877 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0256  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 = 72358 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.0254  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.0130  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.0254  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 = 44080 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0254  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 = 38790 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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.0146  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 = 1948 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1404 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1102 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 127 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 83 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 169 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 173 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC