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 2001/2002
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Lemona Lemona 38 73 31 78
2 Sestao River Sestao River 38 58 28 72
3 Zalla Zalla 38 43 39 69
4 SD Amorebieta Amorebieta 38 51 34 67
5 Aurrera KE Aurrera KE 38 42 40 65
6 UPV Vasconia Vasconia 38 40 39 60
7 CD Basconia CD Basconia 38 51 41 58
8 Deportivo Alavés C Deportivo 38 52 42 54
9 Arenas de Getxo Arenas Getxo 38 49 34 54
10 Portugalete Portugalete 38 46 41 54
11 SD San Pedro Pedro 38 41 36 53
12 Aurrera Vitoria B Aurrera 38 36 32 53
13 Club Bermeo Club Bermeo 38 41 39 51
14 SCD Durango SCD Durango 38 41 48 46
15 SD Zamudio SD Zamudio 38 35 39 44
16 Real Unión B Real Unión 38 41 46 42
17 Sodupe Sodupe 38 36 55 41
18 Salleko Lagunak Salleko 38 40 67 41
19 Zestoa KB Zestoa KB 38 33 59 36
20 Anaitasuna FT Anaitasuna 38 18 77 12
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Lemona Lemona 38 83 24 92
2 Real Sociedad B Real 38 65 28 75
3 Sestao River Sestao River 38 62 24 73
4 Aurrera KE Aurrera KE 38 65 55 65
5 SD Zamudio SD Zamudio 38 59 48 64
6 CD Basconia CD Basconia 38 64 58 56
7 Arenas de Getxo Arenas Getxo 38 52 41 52
8 SCD Durango SCD Durango 38 52 57 52
9 Deportivo Alavés C Deportivo 38 38 37 50
10 Zalla Zalla 38 34 37 49
11 Club Bermeo Club Bermeo 38 46 49 47
12 SD San Pedro Pedro 38 40 41 45
13 SD Amorebieta Amorebieta 38 40 57 45
14 Real Unión B Real Unión 38 42 51 45
15 UPV Vasconia Vasconia 38 40 49 45
16 Aurrera Vitoria B Aurrera 38 35 42 44
17 Sodupe Sodupe 38 29 65 43
18 CD Hernani CD Hernani 38 31 51 39
19 Bergara KE Bergara KE 38 33 61 38
20 CD Lagun Onak Lagun Onak 38 35 70 31
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 38 68 22 82
2 Lemona Lemona 38 53 31 68
3 Arenas de Getxo Arenas Getxo 38 46 34 67
4 Eibar B Eibar B 38 58 33 64
5 CD Basconia CD Basconia 38 61 41 63
6 Sestao River Sestao River 38 43 32 60
7 Zalla Zalla 38 32 33 53
8 CD Hernani CD Hernani 38 35 41 53
9 Aurrera Vitoria B Aurrera 38 40 43 50
10 Aurrera KE Aurrera KE 38 45 37 48
11 SD Amorebieta Amorebieta 38 39 47 48
12 CD Lagun Onak Lagun Onak 38 42 45 47
13 UPV Vasconia Vasconia 38 33 43 46
14 Sodupe Sodupe 38 43 52 44
15 Bergara KE Bergara KE 38 43 47 43
16 SD San Pedro Pedro 38 31 38 43
17 CD Elgoibar CD Elgoibar 38 32 46 37
18 Santurtzi Santurtzi 38 28 78 37
19 Tolosa CF Tolosa CF 38 33 58 30
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

  USO DE MEMORIA  
8,335,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5735
Total Execution Time  0.5749
  CADENA URL  
/historico/Amorebieta/2002
  GET DATOS  
$_GET['/historico/Amorebieta/2002']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0255  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 = 22049
0.0136  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.0126  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 = 22049 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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 (2001,2002,2003) ORDER BY l.id DESC, l.year DESC ;
0.0126  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (22065) 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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 22065 AND teamId = 213
0.0156  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 22049 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 events2002 e ON e.player_id = p.id AND e.league_id = 22049 WHERE rp.league_id = 22049 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.0135  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 events2002 e ON e.player_id = p.id AND e.league_id = 22049 WHERE rp.league_id = 22049 AND rp.teamId = 213 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 events2002 e ON e.player_id = p.id AND e.league_id = 22049 WHERE rp.league_id = 22049 AND rp.teamId = 213 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0179  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 <= 2002 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0144  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 = 22049 AND t.round = 38 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 `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 = 22033 AND t.round = 38 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 `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 = 22017 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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.0156  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.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 `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.0143  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.0137  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0135  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.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 `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.0158  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.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 `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.0156  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.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 `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.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 `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.0134  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.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 `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.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 `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.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 `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