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

Santurtzi

Entrenador: Miguel Romillo

Temporada 2007/2008
TEMPORADA 2007/2008
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Portugalete Portugalete 38 56 31 69
2 SD Gernika SD Gernika 38 52 37 68
3 Amurrio Amurrio 38 55 30 67
4 SD Zamudio SD Zamudio 38 56 40 66
5 CD Basconia CD Basconia 38 51 35 65
6 CD Lagun Onak Lagun Onak 38 50 32 63
7 Zalla Zalla 38 53 47 63
8 Eibar B Eibar B 38 60 47 58
9 Santurtzi Santurtzi 38 34 44 51
10 SD Amorebieta Amorebieta 38 46 47 49
11 CD Elgoibar CD Elgoibar 38 37 40 47
12 Arenas de Getxo Arenas Getxo 38 39 44 46
13 Deportivo Alavés B Deportivo 38 39 37 45
14 Beasain KE Beasain KE 38 43 52 43
15 Laudio Laudio 38 36 38 42
16 Zarautz Zarautz 38 28 43 41
17 SCD Durango SCD Durango 38 42 51 41
18 UD San Pedro Pedro 38 37 52 41
19 Tolosa CF Tolosa CF 38 37 53 39
20 CD Vitoria CD Vitoria 38 34 85 23
TEMPORADA 2006/2007
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Zalla Zalla 38 64 35 76
2 SD Amorebieta Amorebieta 38 56 27 70
3 Portugalete Portugalete 38 60 36 70
4 Beasain KE Beasain KE 38 66 38 69
5 CD Basconia CD Basconia 38 62 38 68
6 SD Gernika SD Gernika 38 62 28 68
7 Santurtzi Santurtzi 38 37 25 56
8 SCD Durango SCD Durango 38 46 41 55
9 Eibar B Eibar B 38 43 33 51
10 Deportivo Alavés B Deportivo 38 37 34 50
11 Arenas de Getxo Arenas Getxo 38 38 39 49
12 CD Elgoibar CD Elgoibar 38 33 41 47
13 Laudio Laudio 38 35 47 46
14 CD Lagun Onak Lagun Onak 38 36 42 42
15 UD San Pedro Pedro 38 29 47 40
16 Tolosa CF Tolosa CF 38 35 58 37
17 Real Unión B Real Unión 38 38 68 37
18 Santutxu Santutxu 38 35 64 34
19 Upv / Ehu Upv / Ehu 38 35 66 31
20 San Ignacio San Ignacio 38 27 67 30
TEMPORADA 2005/2006
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Sestao River Sestao River 38 71 14 90
2 SD Gernika SD Gernika 38 47 23 69
3 SD Amorebieta Amorebieta 38 44 26 67
4 CD Basconia CD Basconia 38 53 33 64
5 Arenas de Getxo Arenas Getxo 38 39 39 56
6 Laudio Laudio 38 50 53 54
7 SD San Pedro Pedro 38 50 40 53
8 CD Lagun Onak Lagun Onak 38 40 42 53
9 Eibar B Eibar B 38 38 30 52
10 UPV Vasconia Vasconia 38 33 33 51
11 CD Elgoibar CD Elgoibar 38 32 37 51
12 Santurtzi Santurtzi 38 38 38 49
13 Tolosa CF Tolosa CF 38 39 31 49
14 Beasain KE Beasain KE 38 38 37 47
15 CD Aurrera Vitoria Aurrera 38 39 43 47
16 SD Zamudio SD Zamudio 38 35 46 41
17 SD Indautxu SD Indautxu 38 32 42 38
18 CD Getxo CD Getxo 38 27 53 33
19 Aurrera KE Aurrera KE 38 30 50 30
20 Salvatierra Salvatierra 38 27 92 23
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
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Deportivo Alavés Deportivo 38 62 30 52
2 Barakaldo Barakaldo 38 54 29 45
3 Gimnástica Torrelavega Gimnástica 38 35 30 45
4 Palencia Palencia 38 51 44 45
5 Osasuna Promesas Osasuna 38 37 31 44
6 Izarra Izarra 38 40 36 44
7 CD Basconia CD Basconia 38 52 35 43
8 Numancia Numancia 38 51 41 42
9 Real Sociedad B Real 38 49 39 38
10 FC Andorra FC Andorra 38 47 41 37
11 Real Valladolid Promesas Real 38 42 53 36
12 CD Logroñés B Logroñés 38 34 40 36
13 Beasain KE Beasain KE 38 38 48 34
14 Lemona Lemona 38 32 34 34
15 Andorra Andorra 38 39 53 33
16 Tudelano Tudelano 38 31 44 33
17 CD Hernani CD Hernani 38 39 50 32
18 Deportivo Aragón Deportivo 38 35 51 32
19 CD Elgoibar CD Elgoibar 38 30 52 28
20 Santurtzi Santurtzi 38 25 42 27
TEMPORADA 1991/1992
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 UE Sant Andreu Sant Andreu 38 70 35 54
2 Manlleu Manlleu 38 61 32 49
3 Girona Girona 38 66 44 48
4 Deportivo Alavés Deportivo 38 51 31 48
5 L´Hospitalet L´Hospitale 38 65 44 46
6 FC Andorra FC Andorra 38 64 46 44
7 Barakaldo Barakaldo 38 49 33 44
8 Real Sociedad B Real 38 49 38 42
9 Gimnàstic Tarragona Gimnàstic 38 45 41 40
10 Osasuna Promesas Osasuna 38 54 45 37
11 Deportivo Aragón Deportivo 38 47 47 35
12 Sp. Mahonès Mahonès 38 35 45 35
13 CD Basconia CD Basconia 38 36 52 35
14 CD Hernani CD Hernani 38 49 53 35
15 Lemona Lemona 38 33 50 35
16 Santurtzi Santurtzi 38 29 45 33
17 Fraga Fraga 38 29 68 27
18 Huesca Huesca 38 41 68 25
19 CFJ Mollerussa Mollerussa 38 46 78 24
20 CD Binéfar CD Binéfar 38 30 54 24
TEMPORADA 1990/1991
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Racing Racing 38 67 32 54
2 Deportivo Alavés Deportivo 38 61 28 52
3 Osasuna Promesas Osasuna 38 61 32 48
4 Real Sociedad B Real 38 52 31 47
5 Deportivo Aragón Deportivo 38 59 36 44
6 Lemona Lemona 38 38 31 41
7 Barakaldo Barakaldo 38 37 34 40
8 FC Andorra FC Andorra 38 42 34 40
9 CD Basconia CD Basconia 38 35 37 40
10 CFJ Mollerussa Mollerussa 38 51 36 39
11 Numancia Numancia 38 45 41 38
12 Gimnástica Torrelavega Gimnástica 38 33 40 36
13 Huesca Huesca 38 39 51 34
14 CD Binéfar CD Binéfar 38 31 39 34
15 Santurtzi Santurtzi 38 29 43 32
16 Izarra Izarra 38 34 56 31
17 Mirandés Mirandés 38 21 43 30
18 SCD Durango SCD Durango 38 23 43 30
19 Andorra Andorra 38 24 42 30
20 CD Teruel CD Teruel 38 29 82 20
TEMPORADA 1989/1990
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Lleida Lleida 38 86 31 55
2 Osasuna Promesas Osasuna 38 46 29 50
3 CFJ Mollerussa Mollerussa 38 61 29 49
4 FC Andorra FC Andorra 38 57 43 46
5 Real Sociedad B Real 38 51 37 44
6 SCD Durango SCD Durango 38 40 39 43
7 Lemona Lemona 38 36 28 43
8 Deportivo Aragón Deportivo 38 54 41 43
9 CD Binéfar CD Binéfar 38 41 44 36
10 Barakaldo Barakaldo 38 47 41 35
11 Andorra Andorra 38 45 46 35
12 Santurtzi Santurtzi 38 49 56 35
13 Numancia Numancia 38 37 45 35
14 Mirandés Mirandés 38 45 52 35
15 CD Basconia CD Basconia 38 31 48 33
16 CD Teruel CD Teruel 38 46 54 33
17 CD Laredo CD Laredo 38 42 67 33
18 Fraga Fraga 38 41 61 30
19 CD Calahorra Calahorra 38 37 69 25
20 Barbastro Barbastro 38 32 64 22
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

  USO DE MEMORIA  
8,085,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6940
Total Execution Time  0.6954
  CADENA URL  
/historico/Santurtzi/2008
  GET DATOS  
$_GET['/historico/Santurtzi/2008']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0141  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 = 'Santurtzi' AND l.year = 2008 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.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2272 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=2272 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 11
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2272 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2272 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0134  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 (93102,96315,822157,886617,1281481) ORDER BY n.cover_points DESC, update_date DESC
0.0152  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 = '2272' AND l.year = 2008 ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '2272' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 11 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=2272 AND l.year in (2007,2008,2009) 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 (134) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 134 AND teamId = 2272
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 FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 11 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '2272' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2272' and rp.type = 4
0.0132  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 = '2272' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2008 e ON e.player_id = p.id AND e.league_id = 11 WHERE rp.league_id = 11 AND rp.teamId = 2272 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.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 events2008 e ON e.player_id = p.id AND e.league_id = 11 WHERE rp.league_id = 11 AND rp.teamId = 2272 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2008 e ON e.player_id = p.id AND e.league_id = 11 WHERE rp.league_id = 11 AND rp.teamId = 2272 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 2272 AND l.year <= 2008 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 11 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 89 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 22116 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 `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.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 `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.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 `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.0146  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.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 `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.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 `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.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 `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 = 22253 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 `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 = 22250 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 `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 = 22247 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 `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 = 22244 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 `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.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 `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.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 `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.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 `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.0140  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.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.0126  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 = 11 ORDER BY nameShow LIMIT 100