4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1991/1992
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Celta Celta 38 61 26 53
2 Rayo Vallecano Rayo 38 52 27 48
3 UE Figueres UE Figueres 38 43 27 47
4 Real Betis Real Betis 38 54 43 46
5 Lleida Lleida 38 52 36 43
6 Barça Atlètic Barça 38 59 53 41
7 Mérida CP Mérida CP 38 58 48 41
8 SD Compostela Compostela 38 36 32 41
9 CE Sabadell CE Sabadell 38 34 35 38
10 Racing Racing 38 39 44 37
11 Real Murcia Real Murcia 38 32 36 36
12 Eibar Eibar 38 19 22 36
13 Bilbao Ath. Bilbao Ath. 38 36 40 35
14 Palamós Palamós 38 39 46 35
15 CD Castellón Castellón 38 42 48 35
16 RM Castilla RM Castilla 38 44 55 34
17 Sestao Sport Club Sestao Sport 38 26 44 32
18 CD Málaga CD Málaga 38 25 45 30
19 Real Avilés Industrial Real Avilés 38 31 56 27
20 Las Palmas Las Palmas 38 39 58 25
TEMPORADA 1990/1991
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 56 31 49
2 RC Deportivo Deportivo 38 60 32 48
3 Real Murcia Real Murcia 38 56 36 48
4 CD Málaga CD Málaga 38 52 35 46
5 Orihuela Deportiva CF Orihuela 38 46 39 43
6 Lleida Lleida 38 41 36 43
7 UE Figueres UE Figueres 38 44 42 39
8 Sestao Sport Club Sestao Sport 38 29 27 38
9 Real Avilés Industrial Real Avilés 38 35 37 38
10 Eibar Eibar 38 35 34 37
11 Rayo Vallecano Rayo 38 44 50 36
12 CE Sabadell CE Sabadell 38 32 45 36
13 Bilbao Ath. Bilbao Ath. 38 35 43 36
14 Celta Celta 38 31 38 36
15 Las Palmas Las Palmas 38 38 43 36
16 Palamós Palamós 38 33 46 35
17 Elche Elche 38 39 45 34
18 UD Salamanca Salamanca 38 41 40 31
19 Levante Levante 38 27 51 27
20 Xerez CD Xerez CD 38 37 61 24
TEMPORADA 1989/1990
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Burgos CF Real Burgos 38 53 24 50
2 Real Betis Real Betis 38 44 29 47
3 Bilbao Ath. Bilbao Ath. 38 50 36 45
4 RC Deportivo Deportivo 38 45 38 44
5 Espanyol Espanyol 38 50 33 42
6 Las Palmas Las Palmas 38 42 37 40
7 CE Sabadell CE Sabadell 38 41 39 40
8 Palamós Palamós 38 29 39 40
9 Real Murcia Real Murcia 38 38 39 38
10 Xerez CD Xerez CD 38 26 31 38
11 Sestao Sport Club Sestao Sport 38 33 32 36
12 UE Figueres UE Figueres 38 37 47 36
13 UD Salamanca Salamanca 38 35 33 36
14 Elche Elche 38 39 41 36
15 Levante Levante 38 34 43 36
16 Eibar Eibar 38 35 42 34
17 Racing Racing 38 32 36 33
18 RM Castilla RM Castilla 38 36 44 31
19 Recreativo Recreativo 38 39 56 29
20 Atlético B Atlético B 38 33 52 29
TEMPORADA 1988/1989
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 CD Castellón Castellón 38 49 29 51
2 Rayo Vallecano Rayo 38 61 36 49
3 Tenerife Tenerife 38 54 36 48
4 Mallorca Mallorca 38 51 26 48
5 Recreativo Recreativo 38 46 36 42
6 Racing Racing 38 56 43 42
7 UD Salamanca Salamanca 38 35 33 42
8 Sestao Sport Club Sestao Sport 38 39 32 41
9 UE Figueres UE Figueres 38 52 50 41
10 RC Deportivo Deportivo 38 43 35 40
11 Las Palmas Las Palmas 38 52 53 40
12 Xerez CD Xerez CD 38 40 38 40
13 CE Sabadell CE Sabadell 38 49 43 39
14 Real Burgos CF Real Burgos 38 27 34 36
15 RM Castilla RM Castilla 38 50 59 36
16 Eibar Eibar 38 36 42 34
17 Barça Atlètic Barça 38 42 58 28
18 UD Alzira UD Alzira 38 29 58 26
19 Lleida Lleida 38 29 43 26
20 CFJ Mollerussa Mollerussa 38 19 75 11
TEMPORADA 1987/1988
SEGUNDA DIVISIÓN B GRUPO 1
Equipo PJ GF GC Puntos
1 Eibar Eibar 38 68 21 59
2 Real Avilés Industrial Real Avilés 38 60 28 53
3 CD Ourense CD Ourense 38 42 25 48
4 Ponferradina Ponferradina 38 64 44 45
5 Pontevedra Pontevedra 38 52 34 43
6 CD Basconia CD Basconia 38 44 34 42
7 Lemona Lemona 38 33 31 41
8 SCD Durango SCD Durango 38 33 37 40
9 CD Lugo CD Lugo 38 36 38 40
10 As Pontes As Pontes 38 40 42 39
11 Bergantiños FC Bergantiños 38 39 41 37
12 Lalín Lalín 38 39 43 37
13 Langreo Langreo 38 47 43 36
14 Cultural Leonesa Cultural 38 42 53 35
15 Arosa Arosa 38 38 48 34
16 Arenteiro Arenteiro 38 40 48 32
17 CD Laredo CD Laredo 38 41 58 29
18 Caudal Deportivo Caudal 38 35 51 28
19 Rayo Cantabria Rayo 38 32 60 23
20 Gimnástica Torrelavega Gimnástica 38 16 62 19
TEMPORADA 1986/1987
SEGUNDA DIVISIÓN B
Equipo PJ GF GC Puntos
1 Tenerife Tenerife 42 70 33 59
2 Lleida Lleida 42 71 32 57
3 Granada Granada 42 55 39 56
4 Burgos Burgos 42 45 20 54
5 UD Salamanca Salamanca 42 60 34 53
6 Pontevedra Pontevedra 42 44 38 47
7 Eibar Eibar 42 55 33 47
8 RB Linense RB Linense 42 43 36 44
9 Córdoba CF Córdoba CF 42 53 59 42
10 UD Alzira UD Alzira 42 41 56 41
11 CD Lugo CD Lugo 42 44 51 40
12 Alcoyano Alcoyano 42 56 65 40
13 CD Ourense CD Ourense 42 44 42 40
14 Atlético B Atlético B 42 50 47 39
15 Real Sociedad B Real 42 60 63 38
16 CF Gandia CF Gandia 42 49 51 38
17 Albacete Albacete 42 41 45 37
18 Deportivo Aragón Deportivo 42 35 50 36
19 AgD Ceuta AgD Ceuta 42 42 60 34
20 Poli Almería Poli 42 38 60 31
21 Mallorca B Mallorca B 42 35 70 26
22 Poblense Poblense 42 37 84 25
TEMPORADA 1985/1986
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Eibar Eibar 38 85 23 58
2 Barakaldo Barakaldo 38 63 22 58
3 Santurtzi Santurtzi 38 51 28 51
4 CD Basconia CD Basconia 38 77 47 50
5 SD Amorebieta Amorebieta 38 80 40 49
6 SCD Durango SCD Durango 38 60 41 44
7 SD Erandio SD Erandio 38 58 49 41
8 Portugalete Portugalete 38 38 51 39
9 Zalla Zalla 38 42 44 39
10 SD Gernika SD Gernika 38 64 53 39
11 Tolosa CF Tolosa CF 38 41 44 36
12 Real Unión Club Real Unión 38 52 50 36
13 Arenas de Getxo Arenas Getxo 38 37 51 35
14 Anaitasuna FT Anaitasuna 38 36 49 33
15 Santutxu Santutxu 38 46 62 33
16 Mutriku FT Mutriku FT 38 43 72 31
17 CD Hernani CD Hernani 38 35 59 27
18 CD Elgoibar CD Elgoibar 38 33 74 22
19 Bergara KE Bergara KE 38 27 68 20
20 Ortuella Ortuella 38 25 66 19
TEMPORADA 1984/1985
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 CD Basconia CD Basconia 38 53 19 56
2 Eibar Eibar 38 56 28 53
3 SD Amorebieta Amorebieta 38 50 26 50
4 Barakaldo Barakaldo 38 58 50 46
5 SCD Durango SCD Durango 38 58 36 45
6 Zalla Zalla 38 52 57 39
7 SD Gernika SD Gernika 38 41 39 38
8 Real Unión Club Real Unión 38 54 47 37
9 Bergara KE Bergara KE 38 36 45 36
10 CD Hernani CD Hernani 38 46 57 35
11 Arenas de Getxo Arenas Getxo 38 28 34 35
12 Tolosa CF Tolosa CF 38 47 45 35
13 Santurtzi Santurtzi 38 38 33 35
14 Mutriku FT Mutriku FT 38 36 49 34
15 Anaitasuna FT Anaitasuna 38 45 53 34
16 Santutxu Santutxu 38 40 46 33
17 Aurrera KE Aurrera KE 38 38 48 32
18 Lemona Lemona 38 40 68 31
19 CD Getxo CD Getxo 38 46 58 29
20 Deusto Deusto 38 36 60 27
TEMPORADA 1983/1984
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Santurtzi Santurtzi 37 61 23 57
2 Eibar Eibar 38 55 25 54
3 SCD Durango SCD Durango 38 81 31 54
4 Real Unión Club Real Unión 38 74 45 49
5 CD Getxo CD Getxo 37 48 33 46
6 Arenas de Getxo Arenas Getxo 38 47 35 45
7 Aurrera KE Aurrera KE 38 56 37 45
8 CD Basconia CD Basconia 38 58 44 43
9 SD Amorebieta Amorebieta 38 47 45 42
10 Lemona Lemona 38 50 45 41
11 Santutxu Santutxu 38 42 46 41
12 Deusto Deusto 38 36 51 32
13 Bergara KE Bergara KE 38 36 48 31
14 SD Gernika SD Gernika 38 25 47 28
15 Anaitasuna FT Anaitasuna 38 38 62 27
16 Tolosa CF Tolosa CF 38 33 55 27
17 Aretxabaleta Aretxabaleta 38 35 61 27
18 SD Ilintxa SD Ilintxa 38 41 62 27
19 Mondragón Mondragón 38 47 79 22
20 CD Touring CD Touring 38 36 72 20
TEMPORADA 1982/1983
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 SCD Durango SCD Durango 38 72 29 55
2 Eibar Eibar 38 58 31 53
3 SD Amorebieta Amorebieta 38 52 33 51
4 CD Basconia CD Basconia 38 49 35 47
5 Aurrera KE Aurrera KE 38 47 32 43
6 Anaitasuna FT Anaitasuna 38 47 46 40
7 CD Getxo CD Getxo 38 41 40 39
8 Real Unión Club Real Unión 38 51 47 39
9 CD Touring CD Touring 38 38 45 38
10 Santutxu Santutxu 38 42 51 37
11 Santurtzi Santurtzi 38 70 66 36
12 Deusto Deusto 38 44 57 36
13 Lemona Lemona 38 49 56 35
14 Tolosa CF Tolosa CF 38 40 48 33
15 SD Ilintxa SD Ilintxa 38 39 49 33
16 Bergara KE Bergara KE 38 30 49 32
17 SD Gernika SD Gernika 38 38 48 31
18 CD Lagun Onak Lagun Onak 38 35 50 31
19 Zorroza Zorroza 38 52 62 31
20 Deportivo Alavés B Deportivo 38 34 54 20
TEMPORADA 1981/1982
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Eibar Eibar 38 56 25 51
2 Aurrera KE Aurrera KE 38 56 30 51
3 CD Basconia CD Basconia 38 62 36 48
4 Deusto Deusto 37 58 41 47
5 SD Amorebieta Amorebieta 38 56 41 46
6 Real Unión Club Real Unión 38 60 42 43
7 Lemona Lemona 38 49 47 38
8 Deportivo Alavés B Deportivo 38 50 55 37
9 SD Gernika SD Gernika 38 44 44 37
10 CD Lagun Onak Lagun Onak 38 54 69 37
11 Santutxu Santutxu 38 33 35 35
12 Anaitasuna FT Anaitasuna 38 43 54 35
13 Zorroza Zorroza 38 35 44 35
14 Bergara KE Bergara KE 38 33 39 34
15 CD Touring CD Touring 38 39 53 33
16 Tolosa CF Tolosa CF 38 41 49 33
17 CD Getxo CD Getxo 38 50 61 32
18 Arenas de Getxo Arenas Getxo 37 45 59 29
19 Balmaseda FC Balmaseda 38 39 61 29
20 CD Mungia CD Mungia 38 42 60 28
TEMPORADA 1980/1981
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 SD Erandio SD Erandio 38 54 26 55
2 Arenas de Getxo Arenas Getxo 38 52 34 49
3 Eibar Eibar 38 66 32 49
4 Aurrera KE Aurrera KE 38 49 35 47
5 CD Lagun Onak Lagun Onak 38 55 37 46
6 Anaitasuna FT Anaitasuna 38 55 42 44
7 Balmaseda FC Balmaseda 38 45 38 40
8 Bergara KE Bergara KE 38 46 42 40
9 Real Unión Club Real Unión 38 55 63 39
10 Deportivo Alavés B Deportivo 38 52 45 37
11 Zorroza Zorroza 38 46 47 36
12 CD Mungia CD Mungia 38 45 50 35
13 Deusto Deusto 38 37 54 33
14 CD Getxo CD Getxo 38 40 50 32
15 Santutxu Santutxu 38 48 67 32
16 SD Gernika SD Gernika 38 29 39 31
17 Tolosa CF Tolosa CF 38 33 43 31
18 Lemona Lemona 38 38 56 31
19 Mutriku FT Mutriku FT 38 43 59 28
20 CD Elorrio CD Elorrio 38 31 60 25
TEMPORADA 1979/1980
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 38 76 26 55
2 Deportivo Alavés B Deportivo 38 57 32 51
3 Deportivo Aragón Deportivo 38 58 41 51
4 Eibar Eibar 38 84 38 49
5 Sabiñánigo Sabiñánigo 38 59 48 43
6 SD Erandio SD Erandio 38 47 39 42
7 Balmaseda FC Balmaseda 38 54 51 41
8 Talavera CF Talavera CF 38 61 49 39
9 CD Toledo CD Toledo 38 48 46 39
10 SD Gernika SD Gernika 38 44 49 37
11 Aurrera KE Aurrera KE 38 47 40 37
12 Real Unión Club Real Unión 38 46 57 34
13 CD Mungia CD Mungia 38 39 43 34
14 Mutriku FT Mutriku FT 38 40 56 34
15 CD Lagun Onak Lagun Onak 38 40 53 33
16 Deusto Deusto 38 41 57 32
17 Tolosa CF Tolosa CF 38 41 62 28
18 CD Elorrio CD Elorrio 38 51 76 28
19 Ejea Ejea 38 44 79 27
20 Lemona Lemona 38 33 68 26
TEMPORADA 1975/1976
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Getafe Deportivo Getafe 38 58 25 53
2 CD Logroñés Logroñés 38 51 34 51
3 RM Castilla RM Castilla 38 72 36 50
4 Real Unión Club Real Unión 38 68 43 46
5 Atlético B Atlético B 38 50 33 46
6 Tudelano Tudelano 38 54 57 44
7 Real Sociedad B Real 38 58 54 43
8 Mirandés Mirandés 38 42 36 43
9 Palencia Palencia 38 46 38 42
10 Talavera CF Talavera CF 38 45 47 40
11 Galáctico Pegaso Galáctico 38 54 39 40
12 RCD Carabanchel Carabanchel 38 50 39 37
13 CD Colonia Moscardó Colonia 38 30 32 37
14 AD Torrejón CF Torrejón 38 44 53 37
15 CD Lagun Onak Lagun Onak 38 41 48 37
16 Zamora Zamora 38 32 52 32
17 Salamanca UDS Salamanca 38 41 58 24
18 CD Alfaro CD Alfaro 38 23 65 22
19 Eibar Eibar 38 29 65 20
20 Michelín Michelín 38 31 65 16
TEMPORADA 1974/1975
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Osasuna Osasuna 38 77 30 61
2 Getafe Deportivo Getafe 38 73 37 53
3 CD Logroñés Logroñés 38 53 33 47
4 RM Castilla RM Castilla 38 59 38 44
5 Mirandés Mirandés 38 49 38 43
6 Real Sociedad B Real 38 62 49 41
7 RCD Carabanchel Carabanchel 38 46 49 39
8 CD Colonia Moscardó Colonia 38 42 40 39
9 Galáctico Pegaso Galáctico 38 37 43 39
10 Tudelano Tudelano 38 51 47 37
11 AD Torrejón CF Torrejón 38 38 41 37
12 Salamanca UDS Salamanca 38 46 62 36
13 Real Unión Club Real Unión 38 39 46 35
14 Atlético B Atlético B 38 48 45 35
15 Eibar Eibar 38 43 53 32
16 Béjar Industrial Béjar 38 38 58 32
17 Michelín Michelín 38 40 57 32
18 CD Calahorra Calahorra 38 43 65 28
19 CD Guadalajara Guadalajara 38 35 52 26
20 Arganda Arganda 38 51 87 24
TEMPORADA 1973/1974
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 38 67 21 54
2 Eibar Eibar 38 60 25 52
3 RM Castilla RM Castilla 38 58 40 48
4 CD Logroñés Logroñés 38 43 26 48
5 CD Colonia Moscardó Colonia 38 48 36 46
6 Palencia Palencia 38 46 34 42
7 Getafe Deportivo Getafe 38 39 30 42
8 CD Guadalajara Guadalajara 38 35 35 41
9 Tudelano Tudelano 38 50 36 41
10 Real Sociedad B Real 38 46 42 39
11 Atlético B Atlético B 38 47 38 38
12 Galáctico Pegaso Galáctico 38 54 55 38
13 RCD Carabanchel Carabanchel 38 38 49 37
14 Salamanca UDS Salamanca 38 49 57 37
15 Mirandés Mirandés 38 45 55 33
16 Barbastro Barbastro 38 39 52 33
17 Peña Sport Peña Sport 38 29 46 32
18 Andorra Andorra 38 34 58 23
19 Tolosa CF Tolosa CF 38 22 69 20
20 Osasuna Promesas Osasuna 38 24 69 16
TEMPORADA 1972/1973
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 82 23 59
2 Atlético B Atlético B 38 57 27 51
3 RM Castilla RM Castilla 38 57 28 49
4 Deportivo Alavés Deportivo 38 53 26 49
5 Galáctico Pegaso Galáctico 38 60 35 47
6 CD Colonia Moscardó Colonia 38 55 42 46
7 Tudelano Tudelano 38 42 35 42
8 Andorra Andorra 38 40 39 40
9 Real Sociedad B Real 38 64 52 39
10 Osasuna Promesas Osasuna 38 43 46 38
11 Puertollano Puertollano 38 39 40 37
12 Eibar Eibar 38 42 50 37
13 Huesca Huesca 38 57 47 36
14 Getafe Deportivo Getafe 38 39 42 35
15 Aretxabaleta Aretxabaleta 38 36 54 35
16 Mirandés Mirandés 38 30 63 29
17 AD Torrejón CF Torrejón 38 25 46 26
18 Txantrea Txantrea 38 27 55 26
19 Béjar Industrial Béjar 38 27 67 22
20 Ejea Ejea 38 34 92 17
TEMPORADA 1971/1972
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 UD Salamanca Salamanca 38 52 31 51
2 Osasuna Osasuna 38 46 24 50
3 Atlético B Atlético B 38 51 34 45
4 Eibar Eibar 38 58 43 42
5 CD Colonia Moscardó Colonia 38 52 43 42
6 Real Sociedad B Real 38 66 34 41
7 Deportivo Alavés Deportivo 38 45 44 41
8 Puertollano Puertollano 38 50 50 39
9 Zamora Zamora 38 43 52 39
10 AD Plus Ultra Plus Ultra 38 46 40 38
11 Palencia Palencia 38 49 45 38
12 Huesca Huesca 38 49 51 38
13 Talavera CF Talavera CF 38 40 53 37
14 Getafe Deportivo Getafe 38 46 46 36
15 Tudelano Tudelano 38 45 46 36
16 Andorra Andorra 38 45 58 35
17 SAD Villaverde Villaverde 38 48 56 35
18 Deportivo Aragón Deportivo 38 31 51 28
19 Real Unión Club Real Unión 38 28 53 27
20 Oberena Oberena 38 25 61 22
TEMPORADA 1970/1971
TERCERA DIVISIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Tenerife Tenerife 38 62 21 53
2 Real Valladolid Real 38 76 35 52
3 Palencia Palencia 38 57 37 50
4 Osasuna Osasuna 38 67 44 50
5 Atlético B Atlético B 38 70 45 48
6 Talavera CF Talavera CF 38 55 49 43
7 Eibar Eibar 38 48 41 42
8 Real Sociedad B Real 38 57 49 40
9 Mirandés Mirandés 38 39 34 40
10 UD Salamanca Salamanca 38 53 40 38
11 AD Plus Ultra Plus Ultra 38 50 58 38
12 Getafe Deportivo Getafe 38 57 51 36
13 Huesca Huesca 38 46 51 35
14 Real Unión Club Real Unión 38 38 49 35
15 Andorra Andorra 38 40 56 35
16 Tudelano Tudelano 38 33 44 34
17 Txantrea Txantrea 38 47 70 33
18 Michelín Michelín 38 46 67 25
19 RCD Carabanchel Carabanchel 38 33 70 20
20 Ejea Ejea 38 24 87 13
TEMPORADA 1969/1970
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 CD Logroñés Logroñés 38 122 27 62
2 Eibar Eibar 38 109 34 58
3 Real Sociedad B Real 38 96 28 54
4 Txantrea Txantrea 38 66 34 51
5 Huesca Huesca 38 74 39 49
6 Real Unión Club Real Unión 38 64 38 48
7 Tudelano Tudelano 38 86 39 47
8 Andorra Andorra 37 54 48 43
9 Deportivo Aragón Deportivo 38 61 68 40
10 CD Iruña CD Iruña 38 71 66 37
11 Tolosa CF Tolosa CF 38 58 55 36
12 Numancia Numancia 38 60 74 33
13 Barbastro Barbastro 38 37 64 33
14 Oberena Oberena 38 62 71 32
15 CD Calahorra Calahorra 38 57 70 32
16 Mutriku FT Mutriku FT 38 48 74 27
17 Atlético Monzón Atlético 38 43 90 27
18 CD Binéfar CD Binéfar 38 42 108 21
19 CD Teruel CD Teruel 38 42 96 20
20 Utebo Utebo 37 17 146 8

  USO DE MEMORIA  
8,692,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2576
Total Execution Time  0.2588
  CADENA URL  
/historico/Eibar/1992
  GET DATOS  
$_GET['/historico/Eibar/1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0129  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 = 'Eibar' AND l.year = 1992 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=957 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=957 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=957 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0119  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 = '957' AND l.year = 1992 ORDER BY l.year DESC,cat.coefficient DESC
0.0168  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 = '957' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128  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=957 AND l.year in (1991,1992,1993) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (21853,5489) 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.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 5489 AND teamId = 957
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 21853 AND teamId = 957
0.0082  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 events1992 e ON e.player_id = p.id AND e.league_id = 5488 WHERE rp.league_id = 5488 AND rp.teamId = 957 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.0071  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 events1992 e ON e.player_id = p.id AND e.league_id = 5488 WHERE rp.league_id = 5488 AND rp.teamId = 957 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0069  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 events1992 e ON e.player_id = p.id AND e.league_id = 5488 WHERE rp.league_id = 5488 AND rp.teamId = 957 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0103  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 = 957 AND l.year <= 1992 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0053  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 `tables1992` 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 = 5488 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1991` 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 = 5487 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables1990` 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 = 5486 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables1989` 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 = 5485 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 `tables1988` 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 = 21069 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 `tables1987` 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 = 21065 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables1986` 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 = 21745 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 `tables1985` 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 = 21731 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables1984` 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 = 21716 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables1983` 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 = 21703 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables1982` 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 = 21686 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046  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 `tables1981` 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 = 21671 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 `tables1980` 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 = 21663 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 `tables1976` 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 = 21642 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables1975` 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 = 21639 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1974` 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 = 21636 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 `tables1973` 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 = 21633 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables1972` 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 = 21630 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1971` 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 = 21627 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1970` 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 = 21621 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC