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 B GRUPO 4
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 62 30 82
2 Lorca FC Lorca FC 38 62 22 79
3 FC Cartagena Cartagena 38 59 35 73
4 Cádiz Cádiz 38 75 38 71
5 CD Guadalajara Guadalajara 38 57 33 69
6 Recreativo Granada Recreativo 38 65 47 58
7 RB Linense RB Linense 38 51 42 56
8 UD Melilla UD Melilla 38 47 45 55
9 Lucena Lucena 38 42 45 55
10 CP Cacereño Cacereño 38 43 49 53
11 Córdoba CF B Córdoba 38 42 50 45
12 El Palo FC El Palo FC 38 35 47 45
13 Almería B Almería B 38 42 49 43
14 Sevilla At. Sevilla At. 38 33 44 43
15 Arroyo Arroyo 38 38 47 43
16 Algeciras CF Algeciras 38 39 45 43
17 La Roda CF La Roda CF 38 39 46 40
18 San Fernando CD Fernando 38 36 60 39
19 At. Sanluqueño Sanluqueño 38 34 68 34
20 Écija Balompié Écija 38 28 87 23
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN B GRUPO 4
Equipo PJ GF GC Puntos
1 Real Jaén Real Jaén 38 44 24 70
2 FC Cartagena Cartagena 38 52 33 68
3 Albacete Albacete 38 45 32 61
4 Lucena Lucena 38 47 38 59
5 Almería B Almería B 38 52 46 59
6 RB Linense RB Linense 38 48 45 58
7 San Fernando CD Fernando 38 45 39 56
8 Écija Balompié Écija 38 47 38 53
9 UD Melilla UD Melilla 38 38 37 53
10 La Roda CF La Roda CF 38 39 36 52
11 At. Sanluqueño Sanluqueño 38 49 46 50
12 CP Cacereño Cacereño 38 40 36 48
13 Cádiz Cádiz 38 40 38 48
14 Sevilla At. Sevilla At. 38 42 53 46
15 Arroyo Arroyo 38 32 40 45
16 Villanovense Villanovense 38 32 46 43
17 UCAM Murcia UCAM Murcia 38 35 41 41
18 San Roque de Lepe Roque Lepe 38 47 58 38
19 Loja Loja 38 30 54 38
20 Betis Deportivo Betis 38 38 62 30
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 RM Castilla RM Castilla 38 77 36 78
2 Tenerife Tenerife 38 51 32 64
3 CD Lugo CD Lugo 38 55 41 64
4 Albacete Albacete 38 56 37 63
5 Atlético B Atlético B 38 58 38 60
6 Real Oviedo Real Oviedo 38 50 43 60
7 Rayo Vallecano B Rayo 38 53 49 56
8 Getafe B Getafe B 38 60 63 53
9 La Roda CF La Roda CF 38 44 45 49
10 Sporting Atlético Sporting 38 42 45 48
11 Coruxo Coruxo 38 37 48 46
12 Leganés Leganés 38 50 50 45
13 Marino de Luanco Marino 38 40 53 45
14 UD Sanse UD Sanse 38 36 47 44
15 RSD Alcalá RSD Alcalá 38 40 47 44
16 UB Conquense Conquense 38 44 41 44
17 CD Toledo CD Toledo 38 37 42 42
18 Montañeros Montañeros 38 44 63 40
19 Vecindario Vecindario 38 37 66 39
20 Celta Fortuna Celta 38 42 67 38
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
Equipo PJ GF GC Puntos
1 Real Sociedad Real 42 53 37 74
2 Hércules Hércules 42 61 34 71
3 Levante Levante 42 63 45 71
4 Real Betis Real Betis 42 61 38 71
5 FC Cartagena Cartagena 42 58 49 65
6 Elche Elche 42 67 57 63
7 Villarreal B Villarreal 42 60 56 61
8 Numancia Numancia 42 55 53 59
9 Recreativo Recreativo 42 40 42 57
10 Córdoba CF Córdoba CF 42 40 46 55
11 Rayo Vallecano Rayo 42 67 58 53
12 Celta Celta 42 38 44 52
13 Huesca Huesca 42 36 40 52
14 Girona Girona 42 45 59 52
15 Albacete Albacete 42 60 62 52
16 UD Salamanca Salamanca 42 44 54 52
17 Las Palmas Las Palmas 42 49 49 51
18 Gimnàstic Tarragona Gimnàstic 42 42 55 51
19 Cádiz Cádiz 42 49 64 50
20 Real Murcia Real Murcia 42 49 51 50
21 Real Unión Club Real Unión 42 40 59 46
22 CD Castellón Castellón 42 37 62 33
TEMPORADA 2008/2009
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 42 73 42 82
2 Real Zaragoza Real 42 79 42 81
3 Tenerife Tenerife 42 79 47 81
4 Hércules Hércules 42 82 43 78
5 Rayo Vallecano Rayo 42 55 39 70
6 Real Sociedad Real 42 48 38 67
7 CD Castellón Castellón 42 55 42 65
8 Levante Levante 42 59 59 64
9 UD Salamanca Salamanca 42 59 50 60
10 Gimnàstic Tarragona Gimnàstic 42 60 50 57
11 Huesca Huesca 42 47 46 53
12 Elche Elche 42 52 50 53
13 Córdoba CF Córdoba CF 42 47 54 53
14 Real Murcia Real Murcia 42 48 58 52
15 Albacete Albacete 42 42 54 51
16 Girona Girona 42 43 54 49
17 Celta Celta 42 46 56 48
18 Las Palmas Las Palmas 42 46 51 47
19 Deportivo Alavés Deportivo 42 42 64 43
20 Alicante Alicante 42 38 69 35
21 Eibar Eibar 42 31 63 35
22 Sevilla At. Sevilla At. 42 29 89 19
TEMPORADA 2007/2008
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Numancia Numancia 42 59 38 77
2 Málaga Málaga 42 58 42 72
3 Real Sporting Real 42 61 40 72
4 Real Sociedad Real 42 55 39 68
5 CD Castellón Castellón 42 42 37 61
6 Hércules Hércules 42 66 55 58
7 UD Salamanca Salamanca 42 52 44 57
8 Las Palmas Las Palmas 42 51 55 57
9 Sevilla At. Sevilla At. 42 43 48 56
10 Elche Elche 42 44 50 54
11 Tenerife Tenerife 42 51 57 53
12 Albacete Albacete 42 37 40 52
13 Eibar Eibar 42 42 51 52
14 Gimnàstic Tarragona Gimnàstic 42 49 51 52
15 Xerez CD Xerez CD 42 47 56 52
16 Celta Celta 42 56 55 52
17 Deportivo Alavés Deportivo 42 41 47 51
18 Córdoba CF Córdoba CF 42 50 56 50
19 Racing Ferrol Racing 42 46 51 50
20 Cádiz Cádiz 42 40 47 49
21 Granada 74 Granada 74 42 45 59 45
22 Poli Ejido Poli Ejido 42 37 54 44
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
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 42 67 32 78
2 Gimnàstic Tarragona Gimnàstic 42 48 38 76
3 Levante Levante 42 53 39 74
4 Ciudad de Murcia Ciudad 42 53 42 72
5 Lorca Deportiva Lorca 42 56 39 69
6 Almería Almería 42 54 43 67
7 Xerez CD Xerez CD 42 60 46 67
8 Numancia Numancia 42 50 55 63
9 Real Sporting Real 42 41 34 56
10 Real Valladolid Real 42 54 54 55
11 RM Castilla RM Castilla 42 55 50 55
12 CD Castellón Castellón 42 46 50 54
13 Albacete Albacete 42 44 57 54
14 Elche Elche 42 47 54 53
15 Poli Ejido Poli Ejido 42 43 50 53
16 Real Murcia Real Murcia 42 41 40 52
17 Hércules Hércules 42 39 49 52
18 Tenerife Tenerife 42 53 60 51
19 Lleida Lleida 42 43 53 46
20 Racing Ferrol Racing 42 44 63 37
21 At. Malagueño Malagueño 42 42 68 36
22 Eibar Eibar 42 28 45 35
TEMPORADA 2004/2005
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 38 73 29 84
2 Real Madrid Real Madrid 38 71 32 80
3 Villarreal Villarreal 38 69 37 65
4 Real Betis Real Betis 38 62 50 62
5 Espanyol Espanyol 38 54 46 61
6 Sevilla Sevilla 38 44 41 60
7 Valencia Valencia 38 54 39 58
8 RC Deportivo Deportivo 38 46 50 51
9 Athletic Athletic 38 59 54 51
10 Málaga Málaga 38 40 48 51
11 Atlético Atlético 38 40 34 50
12 Real Zaragoza Real 38 52 57 50
13 Getafe Getafe 38 38 46 47
14 Real Sociedad Real 38 47 56 47
15 Osasuna Osasuna 38 46 65 46
16 Racing Racing 38 41 58 44
17 Mallorca Mallorca 38 42 63 39
18 Levante Levante 38 39 58 37
19 Numancia Numancia 38 30 61 29
20 Albacete Albacete 38 33 56 28
TEMPORADA 2003/2004
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Valencia Valencia 38 71 27 77
2 Barcelona Barcelona 38 63 39 72
3 RC Deportivo Deportivo 38 60 34 71
4 Real Madrid Real Madrid 38 72 54 70
5 Athletic Athletic 38 53 49 56
6 Sevilla Sevilla 38 56 45 55
7 Atlético Atlético 38 51 53 55
8 Villarreal Villarreal 38 47 49 54
9 Real Betis Real Betis 38 46 43 52
10 Málaga Málaga 38 50 55 51
11 Mallorca Mallorca 38 54 66 51
12 Real Zaragoza Real 38 46 55 48
13 Osasuna Osasuna 38 38 37 48
14 Albacete Albacete 38 40 48 47
15 Real Sociedad Real 38 49 53 46
16 Espanyol Espanyol 38 48 64 43
17 Racing Racing 38 48 63 42
18 Real Valladolid Real 38 46 56 41
19 Celta Celta 38 48 68 39
20 Real Murcia Real Murcia 38 29 57 26
TEMPORADA 2002/2003
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Murcia Real Murcia 42 59 22 79
2 Real Zaragoza Real 42 54 40 72
3 Albacete Albacete 42 51 30 71
4 Levante Levante 42 59 44 65
5 Las Palmas Las Palmas 42 53 43 64
6 Xerez CD Xerez CD 42 55 53 64
7 UD Salamanca Salamanca 42 44 32 60
8 Tenerife Tenerife 42 53 39 57
9 SD Compostela Compostela 42 54 56 55
10 Real Sporting Real 42 44 41 53
11 Getafe Getafe 42 52 55 53
12 Terrassa FC Terrassa FC 42 41 46 52
13 Poli Ejido Poli Ejido 42 36 45 52
14 Numancia Numancia 42 48 52 52
15 Córdoba CF Córdoba CF 42 36 38 50
16 Elche Elche 42 49 52 50
17 Eibar Eibar 42 33 38 50
18 Almería Almería 42 54 63 50
19 Leganés Leganés 42 44 51 48
20 Racing Ferrol Racing 42 40 60 46
21 Real Oviedo Real Oviedo 42 37 59 40
22 CD Badajoz CD Badajoz 42 34 71 38
TEMPORADA 2001/2002
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 42 68 44 79
2 Racing Racing 42 59 37 71
3 Recreativo Recreativo 42 47 35 69
4 Xerez CD Xerez CD 42 43 42 66
5 Elche Elche 42 52 39 65
6 Real Sporting Real 42 57 47 64
7 Real Oviedo Real Oviedo 42 41 40 58
8 Eibar Eibar 42 41 27 58
9 Racing Ferrol Racing 42 58 60 56
10 Albacete Albacete 42 43 42 56
11 UD Salamanca Salamanca 42 52 53 54
12 CD Badajoz CD Badajoz 42 43 52 53
13 Córdoba CF Córdoba CF 42 46 51 53
14 Leganés Leganés 42 40 46 53
15 Real Murcia Real Murcia 42 37 38 52
16 Burgos Burgos 42 31 37 52
17 Numancia Numancia 42 45 53 51
18 Poli Ejido Poli Ejido 42 41 48 50
19 Levante Levante 42 41 54 50
20 Gimnàstic Tarragona Gimnàstic 42 45 50 49
21 CF Extremadura Extremadura 42 37 50 43
22 Real Jaén Real Jaén 42 30 52 42
TEMPORADA 2000/2001
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Sevilla Sevilla 42 66 39 80
2 Real Betis Real Betis 42 49 32 75
3 Tenerife Tenerife 42 58 32 74
4 Atlético Atlético 42 59 39 74
5 Albacete Albacete 42 46 40 66
6 Recreativo Recreativo 42 45 29 65
7 Real Sporting Real 42 55 49 63
8 Levante Levante 42 58 50 60
9 UD Salamanca Salamanca 42 51 48 59
10 Real Jaén Real Jaén 42 37 40 59
11 CF Extremadura Extremadura 42 42 46 58
12 Córdoba CF Córdoba CF 42 40 43 56
13 Real Murcia Real Murcia 42 53 54 52
14 CD Badajoz CD Badajoz 42 34 38 51
15 Eibar Eibar 42 30 32 50
16 Racing Ferrol Racing 42 46 50 50
17 Leganés Leganés 42 45 41 47
18 Elche Elche 42 45 56 46
19 SD Compostela Compostela 42 41 65 45
20 Universidad LPGC Universidad 42 34 63 39
21 Getafe Getafe 42 42 65 35
22 Lleida Lleida 42 40 65 28
TEMPORADA 1999/2000
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Las Palmas Las Palmas 42 60 41 72
2 Osasuna Osasuna 42 50 36 67
3 Villarreal Villarreal 42 61 46 66
4 UD Salamanca Salamanca 42 54 43 66
5 Lleida Lleida 42 66 52 63
6 Mérida CP Mérida CP 42 41 34 63
7 Levante Levante 42 55 52 61
8 CF Extremadura Extremadura 42 49 47 61
9 Real Sporting Real 42 54 48 60
10 Albacete Albacete 42 51 53 59
11 Eibar Eibar 42 48 49 57
12 Córdoba CF Córdoba CF 42 46 49 57
13 Leganés Leganés 42 39 47 56
14 Tenerife Tenerife 42 50 48 55
15 Elche Elche 42 48 58 53
16 CD Badajoz CD Badajoz 42 38 39 51
17 Atlético B Atlético B 42 43 57 50
18 SD Compostela Compostela 42 50 53 49
19 Getafe Getafe 42 39 51 48
20 CD Logroñés Logroñés 42 52 56 46
21 Recreativo Recreativo 42 40 54 45
22 CD Toledo CD Toledo 42 34 55 40
TEMPORADA 1998/1999
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Málaga Málaga 42 72 47 79
2 Atlético B Atlético B 42 73 51 74
3 Numancia Numancia 42 68 40 73
4 Sevilla Sevilla 42 66 50 71
5 Rayo Vallecano Rayo 42 64 49 71
6 Las Palmas Las Palmas 42 57 38 68
7 CD Toledo CD Toledo 42 54 49 65
8 SD Compostela Compostela 42 60 53 61
9 Real Sporting Real 42 47 47 59
10 Mérida CP Mérida CP 42 48 41 59
11 Lleida Lleida 42 52 50 59
12 Recreativo Recreativo 42 40 35 58
13 Osasuna Osasuna 42 44 51 57
14 CD Badajoz CD Badajoz 42 35 39 51
15 Albacete Albacete 42 38 43 50
16 CD Logroñés Logroñés 42 48 57 48
17 Leganés Leganés 42 36 44 47
18 Eibar Eibar 42 42 56 47
19 Mallorca B Mallorca B 42 52 64 46
20 Barça Atlètic Barça 42 51 68 44
21 Hércules Hércules 42 38 66 40
22 CD Ourense CD Ourense 42 35 82 27
TEMPORADA 1997/1998
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 42 54 25 82
2 CF Extremadura Extremadura 42 60 38 79
3 Las Palmas Las Palmas 42 72 47 73
4 Villarreal Villarreal 42 51 38 73
5 Lleida Lleida 42 50 46 63
6 CD Badajoz CD Badajoz 42 48 37 63
7 Sevilla Sevilla 42 47 44 62
8 Rayo Vallecano Rayo 42 51 48 60
9 Atlético B Atlético B 42 64 49 60
10 Eibar Eibar 42 38 32 57
11 Hércules Hércules 42 46 43 56
12 CD Toledo CD Toledo 42 43 48 56
13 Leganés Leganés 42 45 54 53
14 Albacete Albacete 42 41 53 50
15 Osasuna Osasuna 42 36 42 50
16 CD Ourense CD Ourense 42 37 46 49
17 Numancia Numancia 42 33 50 47
18 CD Logroñés Logroñés 42 38 43 46
19 Elche Elche 42 45 56 45
20 Real Jaén Real Jaén 42 39 52 45
21 Xerez CD Xerez CD 42 24 49 38
22 Levante Levante 42 37 59 35
TEMPORADA 1996/1997
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Mérida CP Mérida CP 38 57 35 72
2 UD Salamanca Salamanca 38 72 33 71
3 Mallorca Mallorca 38 59 38 70
4 Albacete Albacete 38 51 32 66
5 Eibar Eibar 38 44 26 66
6 CD Badajoz CD Badajoz 38 38 26 60
7 Las Palmas Las Palmas 38 54 46 52
8 Leganés Leganés 38 43 39 52
9 Levante Levante 38 53 46 50
10 Villarreal Villarreal 38 38 52 48
11 Lleida Lleida 38 48 41 48
12 Atlético B Atlético B 38 57 61 47
13 Deportivo Alavés Deportivo 38 43 47 47
14 CD Toledo CD Toledo 38 37 53 45
15 CD Ourense CD Ourense 38 35 46 44
16 Osasuna Osasuna 38 34 42 44
17 Almería Almería 38 40 51 41
18 RM Castilla RM Castilla 38 40 69 41
19 Barça Atlètic Barça 38 40 63 34
20 Écija Balompié Écija 38 27 64 30

  USO DE MEMORIA  
9,100,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1901
Total Execution Time  0.1912
  CADENA URL  
/historico/Albacete/2016
  GET DATOS  
$_GET['/historico/Albacete/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
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 = 'Albacete' 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.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=140 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=140 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=140 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=140 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 15374
0.0024  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 16597
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=140 AND type_rel = 2
0.0049  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 140 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 (600,941,1819,1857,2011) ORDER BY n.cover_points DESC, update_date DESC
0.0041  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 = '140' AND l.year = 2016 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 = '140' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 16597 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 15374 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030  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=140 AND l.year in (2015,2016,2017) 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 (38453,33904,33379,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 15374 AND teamId = 140
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 33379 AND teamId = 140
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 33904 AND teamId = 140
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 38453 AND teamId = 140
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 30386 AND teamId = 140
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0054  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 = 140 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.0036  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 = 140 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 140 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 140 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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 = 2467 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 `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 = 1905 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 = 1347 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 `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.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 `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 = 812 AND t.round = 42 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 = 105 AND t.round = 42 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 `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.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 `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 = 534 AND t.round = 42 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 `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 = 40 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 = 39 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 `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 = 573 AND t.round = 42 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 `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 = 574 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 `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 = 575 AND t.round = 42 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 `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 = 576 AND t.round = 42 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 `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 = 577 AND t.round = 42 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 `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 = 5494 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 15374 ORDER BY nameShow LIMIT 100