4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SD Amorebieta

SD Amorebieta

Entrenador: Jandro

Temporada 1998/1999
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 38 99 42 89
2 Deportivo Alavés B Deportivo 38 76 38 71
3 Real Unión Club Real Unión 38 60 29 66
4 Zalla Zalla 38 62 37 64
5 CD Hernani CD Hernani 38 45 37 62
6 SCD Durango SCD Durango 38 44 37 60
7 CD Basconia CD Basconia 38 50 42 57
8 Arenas de Getxo Arenas Getxo 38 44 42 53
9 SD San Pedro Pedro 38 37 39 52
10 Aurrera KE Aurrera KE 38 40 41 47
11 CD Lagun Onak Lagun Onak 38 44 49 46
12 Sodupe Sodupe 38 49 59 46
13 Eibar B Eibar B 38 47 47 46
14 SD Amorebieta Amorebieta 38 35 39 44
15 Tolosa CF Tolosa CF 38 45 49 42
16 UPV Vasconia Vasconia 38 38 58 41
17 Santurtzi Santurtzi 38 34 47 41
18 CD Touring CD Touring 38 44 79 35
19 SD Zamudio SD Zamudio 38 39 68 32
20 Alegría Alegría 38 38 91 22
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Basconia CD Basconia 38 61 31 71
2 Zalla Zalla 38 50 25 69
3 Real Sociedad B Real 38 73 37 69
4 SD Amorebieta Amorebieta 38 38 29 64
5 SD San Pedro Pedro 38 56 50 58
6 SCD Durango SCD Durango 38 57 50 56
7 Deportivo Alavés B Deportivo 38 43 40 55
8 Santurtzi Santurtzi 38 48 48 54
9 CD Hernani CD Hernani 38 44 46 49
10 CD Lagun Onak Lagun Onak 38 43 40 49
11 CD Touring CD Touring 38 66 66 47
12 Aurrera KE Aurrera KE 38 47 56 46
13 Arenas de Getxo Arenas Getxo 38 43 50 46
14 UPV Vasconia Vasconia 38 41 47 46
15 SD Zamudio SD Zamudio 38 42 53 45
16 Tolosa CF Tolosa CF 38 40 44 44
17 Arratia CD Arratia CD 38 30 51 43
18 Zorroza Zorroza 38 37 57 43
19 San Ignacio San Ignacio 38 45 57 41
20 CD Getxo CD Getxo 38 42 69 35
TEMPORADA 1996/1997
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Tolosa CF Tolosa CF 38 63 27 78
2 Aloña Mendi Aloña Mendi 38 60 27 74
3 CD Elgoibar CD Elgoibar 38 68 39 64
4 CD Lagun Onak Lagun Onak 38 58 35 61
5 CD Hernani CD Hernani 38 48 36 58
6 Santurtzi Santurtzi 38 42 43 57
7 SD Urola SD Urola 38 47 45 52
8 Amurrio Amurrio 38 58 51 52
9 CD Basconia CD Basconia 38 46 43 51
10 SCD Durango SCD Durango 38 33 36 51
11 Deportivo Alavés B Deportivo 38 51 57 50
12 Laudio Laudio 38 46 64 49
13 SD San Pedro Pedro 38 40 47 48
14 Arratia CD Arratia CD 38 45 54 47
15 SD Amorebieta Amorebieta 38 37 51 46
16 Zorroza Zorroza 38 51 52 45
17 Aurrera KE Aurrera KE 38 44 52 44
18 CD Touring CD Touring 38 52 78 42
19 Balmaseda FC Balmaseda 38 42 73 38
20 Arenas de Getxo Arenas Getxo 38 35 56 36
TEMPORADA 1995/1996
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Zalla Zalla 38 47 15 78
2 SD Zamudio SD Zamudio 38 53 22 73
3 SD Gernika SD Gernika 38 65 38 69
4 CD Elgoibar CD Elgoibar 38 58 38 66
5 CD Getxo CD Getxo 38 53 39 58
6 Deportivo Alavés B Deportivo 38 52 40 56
7 SD Urola SD Urola 38 50 43 53
8 CD Touring CD Touring 38 52 52 51
9 Aurrera KE Aurrera KE 38 38 44 51
10 SD Amorebieta Amorebieta 38 38 54 50
11 Aloña Mendi Aloña Mendi 38 49 52 49
12 CD Hernani CD Hernani 38 43 45 48
13 CD Lagun Onak Lagun Onak 38 41 51 47
14 CD Basconia CD Basconia 38 41 56 46
15 Balmaseda FC Balmaseda 38 36 56 46
16 Zorroza Zorroza 38 39 39 46
17 Santurtzi Santurtzi 38 31 35 45
18 Mondragón Mondragón 38 50 57 40
19 UPV Vasconia Vasconia 38 46 67 36
20 Aurrera Vitoria B Aurrera 38 30 69 22
TEMPORADA 1994/1995
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Aurrera Vitoria Aurrera 38 63 30 55
2 SCD Durango SCD Durango 38 56 19 54
3 CD Hernani CD Hernani 38 63 44 49
4 Zalla Zalla 38 61 35 46
5 Balmaseda FC Balmaseda 38 48 34 44
6 CD Getxo CD Getxo 38 53 46 42
7 CD Basconia CD Basconia 38 48 39 42
8 CD Elgoibar CD Elgoibar 38 58 47 41
9 SD Urola SD Urola 38 54 50 38
10 SD Zamudio SD Zamudio 38 43 48 38
11 SD Amorebieta Amorebieta 38 47 57 37
12 Mondragón Mondragón 38 38 44 37
13 Santurtzi Santurtzi 38 34 31 37
14 Aurrera KE Aurrera KE 38 38 51 34
15 Aloña Mendi Aloña Mendi 38 47 61 34
16 Deportivo Alavés B Deportivo 38 39 52 32
17 CD Touring CD Touring 38 45 61 30
18 Tolosa CF Tolosa CF 38 39 53 27
19 Arenas de Getxo Arenas Getxo 38 34 54 26
20 CD Mungia CD Mungia 38 32 84 17
TEMPORADA 1993/1994
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Amurrio Amurrio 38 70 32 53
2 CD Aurrera Vitoria Aurrera 38 57 30 50
3 SD Gernika SD Gernika 38 63 31 48
4 SCD Durango SCD Durango 38 58 25 47
5 CD Elgoibar CD Elgoibar 38 53 35 44
6 Arenas de Getxo Arenas Getxo 38 47 40 44
7 Zalla Zalla 38 46 43 42
8 Santurtzi Santurtzi 38 40 30 41
9 Aurrera KE Aurrera KE 38 51 50 40
10 Mondragón Mondragón 38 46 42 38
11 Tolosa CF Tolosa CF 38 38 49 37
12 CD Hernani CD Hernani 38 45 55 34
13 Balmaseda FC Balmaseda 38 43 60 34
14 CD Getxo CD Getxo 38 46 51 33
15 CD Mungia CD Mungia 38 38 48 31
16 SD Urola SD Urola 38 41 61 31
17 SD Amorebieta Amorebieta 38 44 63 31
18 Sodupe Sodupe 38 36 60 29
19 Anaitasuna FT Anaitasuna 38 35 59 27
20 SD Erandio SD Erandio 38 39 72 26
TEMPORADA 1992/1993
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Unión Club Real Unión 38 58 27 54
2 Club Bermeo Club Bermeo 38 50 35 50
3 Mondragón Mondragón 38 59 34 47
4 CD Touring CD Touring 38 60 44 47
5 Aurrera KE Aurrera KE 38 51 37 44
6 Amurrio Amurrio 38 60 48 44
7 CD Mungia CD Mungia 38 49 40 42
8 Arenas de Getxo Arenas Getxo 38 47 41 40
9 CD Getxo CD Getxo 38 52 49 39
10 SD Gernika SD Gernika 38 38 42 39
11 Sodupe Sodupe 38 59 55 39
12 SD Urola SD Urola 38 53 47 38
13 SCD Durango SCD Durango 38 48 43 38
14 SD Amorebieta Amorebieta 38 50 46 38
15 SD Erandio SD Erandio 38 56 64 33
16 Tolosa CF Tolosa CF 38 33 50 32
17 Zalla Zalla 38 31 48 31
18 CD Lagun Onak Lagun Onak 37 42 58 24
19 Galdakao Galdakao 37 24 69 21
20 Santutxu Santutxu 38 42 85 18
TEMPORADA 1991/1992
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Unión Club Real Unión 38 63 28 53
2 Beasain KE Beasain KE 38 53 21 52
3 CD Elgoibar CD Elgoibar 38 52 35 47
4 SD Amorebieta Amorebieta 38 55 30 46
5 Zalla Zalla 38 44 36 41
6 Tolosa CF Tolosa CF 38 41 30 40
7 Santutxu Santutxu 38 41 36 39
8 Arenas de Getxo Arenas Getxo 38 28 30 38
9 Aurrera KE Aurrera KE 38 37 40 38
10 SCD Durango SCD Durango 38 37 41 38
11 SD Gernika SD Gernika 38 27 37 37
12 Mondragón Mondragón 38 47 50 37
13 CD Mungia CD Mungia 38 31 36 37
14 CD Getxo CD Getxo 38 41 40 36
15 Club Bermeo Club Bermeo 38 50 44 35
16 Sodupe Sodupe 38 43 46 34
17 Galdakao Galdakao 38 33 41 33
18 CD Lagun Onak Lagun Onak 38 34 46 32
19 Pasajes Pasajes 38 37 69 27
20 Abetxuko Abetxuko 38 21 79 20
TEMPORADA 1990/1991
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Hernani CD Hernani 38 58 40 50
2 CD Elgoibar CD Elgoibar 38 50 32 48
3 Tolosa CF Tolosa CF 38 53 29 47
4 SD Amorebieta Amorebieta 38 51 36 47
5 CD Mungia CD Mungia 38 50 34 45
6 CD Getxo CD Getxo 38 35 28 42
7 Aurrera KE Aurrera KE 38 42 37 40
8 Galdakao Galdakao 38 43 47 38
9 Zalla Zalla 38 41 42 37
10 Arenas de Getxo Arenas Getxo 38 28 37 37
11 Mondragón Mondragón 38 36 32 37
12 Club Bermeo Club Bermeo 38 41 46 36
13 SD Gernika SD Gernika 38 37 46 36
14 Sodupe Sodupe 38 34 38 36
15 Pasajes Pasajes 38 22 37 35
16 Real Unión Club Real Unión 38 34 40 34
17 CD Aurrera Vitoria Aurrera 38 42 46 33
18 CD Touring CD Touring 38 27 37 30
19 Zarautz Zarautz 38 30 47 26
20 Larramendi CD Larramendi 38 33 56 26
TEMPORADA 1989/1990
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 38 73 26 60
2 Aurrera KE Aurrera KE 38 54 28 51
3 Tolosa CF Tolosa CF 38 58 26 49
4 CD Mungia CD Mungia 38 47 27 45
5 Real Unión Club Real Unión 38 49 35 42
6 CD Elgoibar CD Elgoibar 38 37 31 41
7 Larramendi CD Larramendi 38 44 50 40
8 Mondragón Mondragón 38 41 29 40
9 Zalla Zalla 38 35 36 40
10 CD Touring CD Touring 37 36 37 39
11 Pasajes Pasajes 38 30 32 39
12 SD Amorebieta Amorebieta 38 42 42 38
13 Galdakao Galdakao 38 51 54 36
14 CD Hernani CD Hernani 38 33 40 36
15 Sodupe Sodupe 38 31 49 34
16 SD Gernika SD Gernika 38 43 50 33
17 Arenas de Getxo Arenas Getxo 37 35 39 32
18 Abetxuko Abetxuko 38 34 78 25
19 Zumaiako Zumaiako 38 34 55 22
20 Anaitasuna FT Anaitasuna 38 21 64 16
TEMPORADA 1988/1989
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Santurtzi Santurtzi 38 71 30 55
2 Deportivo Alavés Deportivo 38 59 29 52
3 CD Touring CD Touring 38 58 39 50
4 Zalla Zalla 38 46 31 47
5 Tolosa CF Tolosa CF 38 42 28 44
6 Real Unión Club Real Unión 38 65 45 42
7 Larramendi CD Larramendi 38 38 34 40
8 CD Mungia CD Mungia 38 45 35 38
9 Mondragón Mondragón 38 47 47 36
10 Galdakao Galdakao 38 43 48 36
11 CD Hernani CD Hernani 38 51 62 35
12 Anaitasuna FT Anaitasuna 38 49 61 35
13 Aurrera KE Aurrera KE 38 29 35 35
14 Arenas de Getxo Arenas Getxo 38 37 42 34
15 SD Gernika SD Gernika 38 27 42 34
16 Pasajes Pasajes 38 24 38 33
17 SD Amorebieta Amorebieta 38 44 55 33
18 CD Aurrera Vitoria Aurrera 38 42 48 33
19 Mutriku FT Mutriku FT 38 21 54 24
20 Alegría Alegría 38 32 67 24
TEMPORADA 1987/1988
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Barakaldo Barakaldo 38 62 26 53
2 Aurrera KE Aurrera KE 38 48 28 51
3 CD Hernani CD Hernani 38 54 39 50
4 Tolosa CF Tolosa CF 38 48 25 48
5 Real Unión Club Real Unión 38 48 26 47
6 Santurtzi Santurtzi 38 45 29 47
7 CD Mungia CD Mungia 38 48 35 45
8 Deportivo Alavés Deportivo 38 49 35 43
9 SD Amorebieta Amorebieta 38 55 45 42
10 SD Gernika SD Gernika 38 45 41 40
11 Mondragón Mondragón 38 48 56 35
12 Anaitasuna FT Anaitasuna 38 38 49 34
13 Arenas de Getxo Arenas Getxo 38 42 50 33
14 Zalla Zalla 38 33 42 33
15 Pasajes Pasajes 38 37 56 33
16 Galdakao Galdakao 38 33 49 28
17 CD Touring CD Touring 38 40 54 26
18 Portugalete Portugalete 38 27 59 25
19 SD Erandio SD Erandio 38 31 55 24
20 Aretxabaleta Aretxabaleta 38 32 64 23
TEMPORADA 1986/1987
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 SCD Durango SCD Durango 38 49 20 51
2 CD Basconia CD Basconia 38 59 26 50
3 Lemona Lemona 38 69 36 48
4 Barakaldo Barakaldo 38 58 38 48
5 SD Amorebieta Amorebieta 38 74 44 48
6 Santurtzi Santurtzi 38 54 33 47
7 Deportivo Alavés Deportivo 38 58 37 47
8 Real Unión Club Real Unión 38 39 34 41
9 Aurrera KE Aurrera KE 38 33 35 37
10 Aretxabaleta Aretxabaleta 38 34 50 36
11 Zalla Zalla 38 43 56 36
12 Arenas de Getxo Arenas Getxo 38 40 43 35
13 SD Erandio SD Erandio 38 35 44 34
14 Portugalete Portugalete 38 22 31 32
15 CD Hernani CD Hernani 38 39 54 31
16 Tolosa CF Tolosa CF 38 36 53 30
17 Anaitasuna FT Anaitasuna 38 23 43 30
18 Mutriku FT Mutriku FT 38 26 52 29
19 SD Gernika SD Gernika 38 34 59 28
20 Santutxu Santutxu 38 26 63 22
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 1967/1968
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 SD Indautxu SD Indautxu 30 68 28 48
2 Barakaldo Barakaldo 30 66 25 44
3 Bilbao Ath. Bilbao Ath. 30 71 30 43
4 Laudio Laudio 30 60 33 40
5 Sestao Sport Club Sestao Sport 30 56 42 34
6 CD Basconia CD Basconia 30 47 48 33
7 Arenas de Getxo Arenas Getxo 30 37 38 29
8 CD Getxo CD Getxo 30 40 38 27
9 Rayo Cantabria Rayo 30 45 48 27
10 SD Erandio SD Erandio 30 35 41 27
11 Santurtzi Santurtzi 30 43 48 26
12 SD Amorebieta Amorebieta 30 47 62 23
13 Deusto Deusto 30 34 62 22
14 Portugalete Portugalete 30 28 54 21
15 UM Escobedo UM Escobedo 30 36 73 21
16 Galdakao Galdakao 30 23 66 15
TEMPORADA 1966/1967
TERCERA DIVISIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Bilbao Ath. Bilbao Ath. 30 85 26 46
2 Sestao Sport Club Sestao Sport 30 61 27 40
3 Barakaldo Barakaldo 30 61 33 39
4 Laudio Laudio 30 58 33 38
5 Rayo Cantabria Rayo 30 47 26 36
6 Arenas de Getxo Arenas Getxo 30 48 36 32
7 CD Basconia CD Basconia 30 42 36 32
8 Deusto Deusto 30 37 38 31
9 SD Erandio SD Erandio 30 43 49 30
10 Santurtzi Santurtzi 30 34 57 27
11 Galdakao Galdakao 30 31 38 26
12 SD Amorebieta Amorebieta 30 34 45 25
13 Santoña CF Santoña CF 30 37 58 25
14 Unión Club Unión Club 30 20 52 19
15 SD Barreda Balompié Barreda 30 28 61 18
16 CD Laredo CD Laredo 30 16 67 16

  USO DE MEMORIA  
8,269,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7094
Total Execution Time  0.7107
  CADENA URL  
/historico/Amorebieta/1999
  GET DATOS  
$_GET['/historico/Amorebieta/1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0159  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 = 'Amorebieta' AND l.year = 1999 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.0145  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=213 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=213 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 22001
0.0153  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 = '213' AND l.year = 1999 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '213' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0158  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 = 22001 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0179  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=213 AND l.year in (1998,1999,2000) ORDER BY l.id DESC, l.year DESC ;
0.0152  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 (22017) 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.0144  SELECT count(id) as num_players from rel_players WHERE league_id = 22017 AND teamId = 213
0.0148  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 = '213' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '213' and rp.type = 4
0.0150  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 = '213' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '213' and rp.type = 4
0.0146  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 events1999 e ON e.player_id = p.id AND e.league_id = 22001 WHERE rp.league_id = 22001 AND rp.teamId = 213 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.0146  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 events1999 e ON e.player_id = p.id AND e.league_id = 22001 WHERE rp.league_id = 22001 AND rp.teamId = 213 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events1999 e ON e.player_id = p.id AND e.league_id = 22001 WHERE rp.league_id = 22001 AND rp.teamId = 213 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155  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 = 213 AND l.year <= 1999 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 22001 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 `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 = 21985 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 `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 = 21967 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 `tables1996` 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 = 21946 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1995` 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 = 21926 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 `tables1994` 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 = 21904 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables1993` 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 = 21883 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 `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 = 21860 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 21838 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 21817 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 `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 = 21798 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 21779 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 `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 = 21760 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 `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.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 `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.0153  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.0152  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.0152  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 `tables1968` 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 = 21601 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1967` 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 = 22198 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC