4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 42 49 35 75
2 Leganés Leganés 42 59 34 74
3 Gimnàstic Tarragona Gimnàstic 42 57 41 71
4 Girona Girona 42 46 28 66
5 Córdoba CF Córdoba CF 42 59 52 65
6 Osasuna Osasuna 42 47 40 64
7 Alcorcón Alcorcón 42 48 44 64
8 Real Zaragoza Real 42 50 44 64
9 Real Oviedo Real Oviedo 42 52 51 59
10 Numancia Numancia 42 57 51 57
11 Elche Elche 42 40 46 57
12 Huesca Huesca 42 48 49 55
13 Tenerife Tenerife 42 45 46 55
14 CD Lugo CD Lugo 42 44 50 54
15 Mirandés Mirandés 42 55 56 52
16 Real Valladolid Real 42 47 52 51
17 Mallorca Mallorca 42 39 45 49
18 Almería Almería 42 44 51 48
19 Ponferradina Ponferradina 42 39 54 47
20 CF Badalona Futur Badalona 42 44 54 44
21 Albacete Albacete 42 39 61 39
22 Bilbao Ath. Bilbao Ath. 42 35 59 32
TEMPORADA 2014/2015
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 42 73 40 84
2 Real Sporting Real 42 57 27 82
3 Girona Girona 42 63 35 82
4 Las Palmas Las Palmas 42 73 47 78
5 Real Valladolid Real 42 65 40 72
6 Real Zaragoza Real 42 61 58 61
7 Ponferradina Ponferradina 42 55 51 60
8 Mirandés Mirandés 42 42 44 59
9 CF Badalona Futur Badalona 42 41 41 57
10 Leganés Leganés 42 48 42 56
11 Alcorcón Alcorcón 42 44 49 54
12 Numancia Numancia 42 54 55 53
13 Deportivo Alavés Deportivo 42 49 53 53
14 Albacete Albacete 42 55 65 51
15 CD Lugo CD Lugo 42 48 56 49
16 Mallorca Mallorca 42 51 64 48
17 Tenerife Tenerife 42 41 48 48
18 Osasuna Osasuna 42 41 60 45
19 Racing Racing 42 42 53 44
20 Recreativo Recreativo 42 37 59 41
21 CE Sabadell CE Sabadell 42 41 66 38
22 Barça Atlètic Barça 42 55 83 36
TEMPORADA 2013/2014
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Eibar Eibar 42 49 28 71
2 RC Deportivo Deportivo 42 48 36 69
3 Barça Atlètic Barça 42 60 47 66
4 Real Murcia Real Murcia 42 55 44 65
5 Real Sporting Real 42 63 51 64
6 Las Palmas Las Palmas 42 51 50 63
7 Córdoba CF Córdoba CF 42 46 43 61
8 Recreativo Recreativo 42 53 53 61
9 Alcorcón Alcorcón 42 46 40 59
10 CE Sabadell CE Sabadell 42 52 59 59
11 Tenerife Tenerife 42 46 49 54
12 CD Lugo CD Lugo 42 41 48 54
13 Numancia Numancia 42 42 41 54
14 Real Zaragoza Real 42 49 53 53
15 Girona Girona 42 52 50 51
16 Ponferradina Ponferradina 42 46 49 51
17 Mallorca Mallorca 42 46 57 51
18 Deportivo Alavés Deportivo 42 57 57 51
19 Mirandés Mirandés 42 39 56 50
20 RM Castilla RM Castilla 42 49 56 49
21 Real Jaén Real Jaén 42 43 49 48
22 Hércules Hércules 42 45 62 45
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Elche Elche 42 54 27 82
2 Villarreal Villarreal 42 68 38 77
3 Almería Almería 42 72 50 74
4 Girona Girona 42 74 56 71
5 Alcorcón Alcorcón 42 57 55 69
6 Las Palmas Las Palmas 42 62 55 66
7 Ponferradina Ponferradina 42 57 50 66
8 RM Castilla RM Castilla 42 80 62 59
9 Barça Atlètic Barça 42 76 71 57
10 Real Sporting Real 42 60 53 56
11 CD Lugo CD Lugo 42 46 54 56
12 Numancia Numancia 42 53 55 55
13 Recreativo Recreativo 42 46 57 54
14 Córdoba CF Córdoba CF 42 55 55 54
15 Mirandés Mirandés 42 35 51 52
16 CE Sabadell CE Sabadell 42 54 69 52
17 Hércules Hércules 42 43 53 50
18 CD Guadalajara Guadalajara 42 46 53 50
19 Real Murcia Real Murcia 42 43 56 47
20 Racing Racing 42 38 51 46
21 Huesca Huesca 42 46 58 45
22 Xerez CD Xerez CD 42 38 74 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Mirandés Mirandés 38 55 22 82
2 Ponferradina Ponferradina 38 65 34 74
3 Eibar Eibar 38 46 35 66
4 SD Amorebieta Amorebieta 38 50 35 62
5 UD Logroñés Logroñés 38 52 38 60
6 Deportivo Alavés Deportivo 38 64 39 59
7 Guijuelo Guijuelo 38 45 44 58
8 Bilbao Ath. Bilbao Ath. 38 47 39 55
9 UD Salamanca Salamanca 38 50 48 52
10 Sestao River Sestao River 38 52 52 51
11 Zamora Zamora 38 41 37 49
12 Real Sociedad B Real 38 50 52 48
13 Osasuna Promesas Osasuna 38 49 56 48
14 Real Unión Club Real Unión 38 45 43 48
15 Gimnástica Torrelavega Gimnástica 38 39 50 46
16 Palencia Palencia 38 32 46 46
17 Arandina Arandina 38 38 52 39
18 Gimnástica Segoviana Gimnástica 38 40 70 30
19 Lemona Lemona 38 26 60 29
20 Burgos Burgos 38 29 63 28
TEMPORADA 2010/2011
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 42 85 44 83
2 Rayo Vallecano Rayo 42 73 48 79
3 Barça Atlètic Barça 42 85 62 71
4 Elche Elche 42 55 42 69
5 Granada Granada 42 71 47 68
6 Celta Celta 42 62 43 67
7 Real Valladolid Real 42 65 51 66
8 Xerez CD Xerez CD 42 60 64 60
9 Alcorcón Alcorcón 42 57 52 58
10 Numancia Numancia 42 65 63 57
11 Girona Girona 42 58 56 57
12 Recreativo Recreativo 42 44 37 56
13 FC Cartagena Cartagena 42 48 63 56
14 Huesca Huesca 42 39 45 55
15 Las Palmas Las Palmas 42 56 71 54
16 Córdoba CF Córdoba CF 42 58 63 52
17 Villarreal B Villarreal 42 43 63 51
18 Gimnàstic Tarragona Gimnàstic 42 37 45 49
19 UD Salamanca Salamanca 42 46 68 46
20 Tenerife Tenerife 42 42 66 38
21 Ponferradina Ponferradina 42 36 63 34
22 Albacete Albacete 42 35 64 32
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
Equipo PJ GF GC Puntos
1 Real Valladolid Real 42 70 35 88
2 Almería Almería 42 73 49 80
3 Real Murcia Real Murcia 42 62 45 76
4 Ciudad de Murcia Ciudad 42 52 44 63
5 Cádiz Cádiz 42 53 45 61
6 Albacete Albacete 42 49 48 60
7 Tenerife Tenerife 42 48 51 60
8 Numancia Numancia 42 48 44 58
9 Xerez CD Xerez CD 42 47 42 58
10 Elche Elche 42 47 46 58
11 Poli Ejido Poli Ejido 42 52 50 58
12 UD Salamanca Salamanca 42 53 50 57
13 Real Sporting Real 42 53 53 56
14 CD Castellón Castellón 42 48 41 56
15 Málaga Málaga 42 49 50 55
16 Hércules Hércules 42 48 52 54
17 Deportivo Alavés Deportivo 42 51 60 52
18 Las Palmas Las Palmas 42 51 59 51
19 RM Castilla RM Castilla 42 55 67 49
20 Ponferradina Ponferradina 42 45 61 46
21 Lorca Deportiva Lorca 42 37 60 37
22 Vecindario Vecindario 42 42 81 34
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
TEMPORADA 2003/2004
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 38 54 28 73
2 RM Castilla RM Castilla 38 55 32 70
3 Mirandés Mirandés 38 51 35 68
4 Cultural Leonesa Cultural 38 52 30 68
5 Burgos Burgos 38 50 33 65
6 UB Conquense Conquense 38 57 41 60
7 Ponferradina Ponferradina 38 39 30 60
8 Zamora Zamora 38 50 40 55
9 Fuenlabrada Fuenlabrada 38 54 58 54
10 Alcorcón Alcorcón 38 34 34 52
11 Talavera CF Talavera CF 38 28 32 51
12 Palencia Palencia 38 33 35 51
13 UD Sanse UD Sanse 38 46 49 50
14 Deportivo Aragón Deportivo 38 39 38 49
15 Tomelloso Tomelloso 38 29 39 48
16 RSD Alcalá RSD Alcalá 38 33 35 44
17 Casetas Casetas 38 32 60 35
18 CD Toledo CD Toledo 38 33 54 35
19 SD Compostela Compostela 38 33 58 34
20 Rayo Majadahonda Rayo 38 29 70 16
TEMPORADA 2002/2003
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Universidad LPGC Universidad 38 65 39 72
2 Zamora Zamora 38 58 43 66
3 Lanzarote Lanzarote 38 64 44 64
4 Pontevedra Pontevedra 38 70 54 64
5 Cultural Leonesa Cultural 38 53 39 63
6 RM Castilla RM Castilla 38 57 39 59
7 Alcorcón Alcorcón 38 56 47 56
8 Pájara Playas Jandía Pájara 38 47 44 52
9 CD Ourense CD Ourense 38 41 40 51
10 RSD Alcalá RSD Alcalá 38 46 41 51
11 Ponferradina Ponferradina 38 48 51 49
12 Atlético B Atlético B 38 38 37 48
13 Real Avilés Industrial Real Avilés 38 39 42 48
14 Celta Fortuna Celta 38 45 42 48
15 Corralejo Corralejo 38 37 42 46
16 Langreo Langreo 38 33 39 45
17 Marino de Luanco Marino 38 44 66 42
18 CD Lugo CD Lugo 38 38 51 42
19 Real Ávila Real Ávila 38 34 66 26
20 Ribadesella Ribadesella 38 22 69 25
TEMPORADA 2001/2002
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Barakaldo Barakaldo 38 61 19 79
2 Cultural Leonesa Cultural 38 64 43 67
3 SD Compostela Compostela 38 53 30 64
4 Pontevedra Pontevedra 38 41 30 63
5 Marino de Luanco Marino 38 54 46 59
6 Bilbao Ath. Bilbao Ath. 38 47 34 56
7 Amurrio Amurrio 38 46 34 55
8 CD Aurrera Vitoria Aurrera 38 38 33 54
9 CD Lugo CD Lugo 38 38 41 54
10 Deportivo Alavés B Deportivo 38 44 39 52
11 CD Ourense CD Ourense 38 55 61 50
12 SD Gernika SD Gernika 38 34 42 49
13 Celta Fortuna Celta 38 28 38 49
14 Ponferradina Ponferradina 38 44 43 49
15 Zamora Zamora 38 60 60 48
16 Gimnástica Torrelavega Gimnástica 38 38 50 42
17 Sporting Atlético Sporting 38 41 56 41
18 Real Oviedo Vetusta Real Oviedo 38 25 49 36
19 Caudal Deportivo Caudal 38 33 58 28
20 Universidad Oviedo Universidad 38 36 74 26
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético B Atlético B 38 63 27 74
2 CD Ourense CD Ourense 38 60 31 73
3 Zamora Zamora 38 65 37 71
4 CD Toledo CD Toledo 38 59 34 66
5 Sporting Atlético Sporting 38 52 45 63
6 Pájara Playas Jandía Pájara 38 51 45 61
7 RM Castilla RM Castilla 38 74 53 61
8 Vecindario Vecindario 38 65 65 58
9 Caudal Deportivo Caudal 38 40 38 52
10 CD Mensajero Mensajero 38 40 44 49
11 Ponferradina Ponferradina 38 45 50 47
12 Alcorcón Alcorcón 38 46 53 44
13 Universidad Oviedo Universidad 38 46 60 44
14 Pontevedra Pontevedra 38 41 65 44
15 CD Lugo CD Lugo 38 36 47 43
16 Fuenlabrada Fuenlabrada 38 40 47 42
17 Club Siero Club Siero 38 42 55 42
18 UD Sanse UD Sanse 38 42 59 38
19 Real Ávila Real Ávila 38 46 66 38
20 Deportivo Fabril Deportivo 38 36 68 34
TEMPORADA 1999/2000
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Universidad LPGC Universidad 38 40 17 72
2 CD Ourense CD Ourense 38 48 29 69
3 Racing Ferrol Racing 38 67 24 68
4 CD Mensajero Mensajero 38 53 35 66
5 RM Castilla RM Castilla 38 72 51 61
6 UD Sanse UD Sanse 38 51 42 58
7 Pontevedra Pontevedra 38 46 49 54
8 CD Lugo CD Lugo 38 42 46 52
9 Cultural Leonesa Cultural 38 52 50 51
10 Pájara Playas Jandía Pájara 38 52 51 51
11 Real Ávila Real Ávila 38 47 54 51
12 Sporting Atlético Sporting 38 48 51 51
13 Fuenlabrada Fuenlabrada 38 42 47 50
14 Caudal Deportivo Caudal 38 37 56 45
15 Ponferradina Ponferradina 38 34 55 44
16 Real Avilés Industrial Real Avilés 38 38 43 43
17 Lanzarote Lanzarote 38 47 54 42
18 Real Oviedo Vetusta Real Oviedo 38 37 50 39
19 Gimnástica Segoviana Gimnástica 38 20 47 35
20 Móstoles Móstoles 38 34 56 32
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Zamora Zamora 38 72 33 80
2 Gimnástica Segoviana Gimnástica 38 61 24 74
3 Real Ávila Real Ávila 38 70 42 71
4 Ponferradina Ponferradina 38 65 42 70
5 Atl. Bembibre Atl. 38 60 31 69
6 Palencia Palencia 38 56 39 60
7 Racing Lermeño CF Racing 38 50 42 60
8 Norma San Leonardo Norma 38 47 45 54
9 CD Cuéllar Balompié Cuéllar 38 57 61 50
10 La Bañeza La Bañeza 38 51 57 47
11 Júpiter Leonés Júpiter 38 47 49 46
12 Salamanca B Salamanca B 38 40 35 45
13 Béjar Industrial Béjar 38 45 56 43
14 Benavente Benavente 38 38 72 40
15 Garray FC Garray FC 38 30 40 40
16 CD Laguna CD Laguna 38 39 49 39
17 Becerril Becerril 38 39 53 39
18 Ponferradina B Ponferradina 38 37 67 36
19 Hullera Hullera 38 37 69 34
20 Ribert Ribert 38 30 65 33
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Palencia Palencia 38 69 33 76
2 Gimnástica Segoviana Gimnástica 38 55 24 75
3 Ponferradina Ponferradina 38 69 30 72
4 Salamanca B Salamanca B 38 64 36 70
5 Club Deportivo Nava Club 38 62 48 67
6 Real Ávila Real Ávila 38 46 40 53
7 Ponferradina B Ponferradina 38 37 43 51
8 Júpiter Leonés Júpiter 38 37 35 51
9 CD Laguna CD Laguna 38 34 29 49
10 CD Cuéllar Balompié Cuéllar 38 45 51 49
11 Atl. Bembibre Atl. 38 61 65 48
12 Ribert Ribert 38 48 62 47
13 Racing Lermeño CF Racing 38 37 40 46
14 Hullera Hullera 38 39 47 46
15 La Bañeza La Bañeza 38 49 49 45
16 Béjar Industrial Béjar 38 45 58 44
17 Garray FC Garray FC 38 29 45 42
18 Arandina Arandina 38 42 66 40
19 Atl. Astorga Atl. Astorga 38 37 59 37
20 CD Tardajos CD Tardajos 38 29 74 21
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 8
Equipo PJ GF GC Puntos
1 Burgos Burgos 36 81 23 88
2 Palencia Palencia 36 80 36 75
3 Salamanca UDS Salamanca 36 43 20 70
4 Zamora Zamora 36 54 35 66
5 Atl. Bembibre Atl. 36 73 43 65
6 Ponferradina Ponferradina 35 53 36 63
7 Racing Lermeño CF Racing 36 43 37 56
8 CD Nava CD Nava 36 55 46 55
9 Ribert Ribert 35 45 43 49
10 La Bañeza La Bañeza 36 40 43 48
11 CD Laguna CD Laguna 36 40 46 47
12 Real Ávila Real Ávila 36 33 35 42
13 Atl. Astorga Atl. Astorga 36 44 58 40
14 Hullera Hullera 36 36 52 37
15 Arandina Arandina 36 48 68 37
16 Gimnástica Segoviana Gimnástica 36 40 52 36
17 Béjar Industrial Béjar 36 27 55 35
18 SD Almazán SD Almazán 36 29 75 20
19 Iscar Iscar 36 37 98 17

  USO DE MEMORIA  
8,892,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7546
Total Execution Time  0.7558
  CADENA URL  
/historico/Ponferradina-Sd/2016
  GET DATOS  
$_GET['/historico/Ponferradina-Sd/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0146  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 = 'Ponferradina-Sd' AND l.year = 2016 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.0126  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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=3287 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3287 AND type_rel = 2
0.0141  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3287 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1194,1427,2575,3226,3254) ORDER BY n.cover_points DESC, update_date DESC
0.0140  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 = '3287' ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '3287' AND l.year = 2016 ORDER BY l.year DESC,cat.coefficient DESC
0.0137  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 = '3287' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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=3287 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (37067,33904,33378,30386,15374) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 15374 AND teamId = 3287
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 33378 AND teamId = 3287
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 33904 AND teamId = 3287
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 37067 AND teamId = 3287
0.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 3287
0.0130  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 = '3287' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '3287' and rp.type = 4
0.0138  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 = '3287' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '3287' and rp.type = 4
0.0154  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 events2016 e ON e.player_id = p.id AND e.league_id = 15374 WHERE rp.league_id = 15374 AND rp.teamId = 3287 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.0152  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 events2016 e ON e.player_id = p.id AND e.league_id = 15374 WHERE rp.league_id = 15374 AND rp.teamId = 3287 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 events2016 e ON e.player_id = p.id AND e.league_id = 15374 WHERE rp.league_id = 15374 AND rp.teamId = 3287 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0167  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 = 3287 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138  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 = 15374 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3803 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 2434 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 1901 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 1346 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 1100 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 826 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 5 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 81 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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.0150  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
0.0147  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 = 177 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 5501 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 5500 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 5499 AND t.round = 38 ORDER BY team.conference 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 `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 = 5498 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 22005 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 21989 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 = 21971 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC