4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Bilbao Ath. Bilbao Ath. 32 60 16 76
2 Barakaldo Barakaldo 32 54 19 70
3 UD Logroñés Logroñés 32 63 16 65
4 Utebo Utebo 32 39 28 58
5 Deportivo Aragón Deportivo 32 48 32 56
6 Deportivo Alavés B Deportivo 32 54 38 49
7 Real Sociedad C Real 32 32 33 44
8 SD Gernika SD Gernika 32 36 44 43
9 CD Calahorra Calahorra 32 30 32 43
10 Tudelano Tudelano 32 40 32 42
11 Barbastro Barbastro 32 24 27 41
12 Arenas de Getxo Arenas Getxo 32 30 35 37
13 Izarra Izarra 32 28 49 33
14 Mutilvera Mutilvera 32 20 43 33
15 AD San Juan AD San Juan 32 28 45 32
16 CD Valle de Egüés Valle 32 23 52 21
17 Brea Brea 32 14 47 21
18 Náxara Náxara 32 20 55 21
TEMPORADA 2022/2023
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Sestao River Sestao River 34 55 17 72
2 Deportivo Alavés B Deportivo 34 40 23 59
3 SD Tarazona SD Tarazona 34 60 37 56
4 Utebo Utebo 34 39 32 53
5 SD Gernika SD Gernika 34 41 31 53
6 Tudelano Tudelano 34 39 32 52
7 Real Sociedad C Real 34 46 42 52
8 AD San Juan AD San Juan 34 33 27 51
9 Arenas de Getxo Arenas Getxo 34 39 42 48
10 Izarra Izarra 34 39 31 48
11 Mutilvera Mutilvera 34 44 37 46
12 Brea Brea 34 27 33 44
13 Beasain KE Beasain KE 34 40 40 41
14 Cirbonero Cirbonero 34 35 40 40
15 CD Alfaro CD Alfaro 34 35 54 34
16 UD Logroñés B Logroñés 34 27 54 32
17 Racing Rioja Racing Rioja 34 27 57 32
18 Arnedo Arnedo 34 28 65 24
TEMPORADA 2021/2022
SEGUNDA FEDERACIÓN GRUPO 2
Equipo PJ GF GC Puntos
1 Osasuna Promesas Osasuna 34 72 29 72
2 Sestao River Sestao River 34 53 22 70
3 Real Sociedad C Real 34 55 30 59
4 Rayo Cantabria Rayo 34 42 29 56
5 Arenas de Getxo Arenas Getxo 34 42 25 56
6 AD San Juan AD San Juan 34 47 39 51
7 Racing Rioja Racing Rioja 34 43 39 50
8 SD Gernika SD Gernika 34 50 42 49
9 Burgos CF B Burgos CF B 34 42 33 48
10 Izarra Izarra 34 33 34 45
11 Mutilvera Mutilvera 34 42 45 45
12 UD Logroñés B Logroñés 34 45 39 45
13 CD Laredo CD Laredo 34 41 36 45
14 Cayón Cayón 34 26 60 33
15 Tropezón Tropezón 34 40 68 27
16 Náxara Náxara 34 27 53 26
17 CF Ardoi CF Ardoi 34 29 61 25
18 Peña Sport Peña Sport 34 31 76 18
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 SD Gernika SD Gernika 20 39 16 43
2 Real Sociedad C Real 20 48 27 40
3 Sestao River Sestao River 20 40 13 39
4 Deusto Deusto 20 30 24 36
5 Santutxu Santutxu 20 20 23 29
6 Beasain KE Beasain KE 20 20 14 27
7 Tolosa CF Tolosa CF 20 21 26 24
8 Aurrera KE Aurrera KE 20 23 31 20
9 Balmaseda FC Balmaseda 20 22 27 18
10 JD Somorrostro Somorrostro 20 20 31 17
11 Urgatzi KK Urgatzi KK 20 11 62 10
12 CD Vitoria CD Vitoria 20 20 4 35
13 Urduliz FT Urduliz FT 20 28 18 35
14 Pasaia KE Pasaia KE 20 22 14 34
15 CD Basconia CD Basconia 20 24 15 30
16 Anaitasuna FT Anaitasuna 20 20 19 30
17 San Ignacio San Ignacio 20 19 19 29
18 Santurtzi Santurtzi 20 18 27 23
19 SCD Durango SCD Durango 20 17 20 22
20 Sodupe Sodupe 20 21 23 20
21 Ariznabarra Ariznabarra 20 12 28 16
22 CD Lagun Onak Lagun Onak 20 17 31 15
TEMPORADA 2019/2020
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Portugalete Portugalete 28 48 22 56
2 Sestao River Sestao River 28 52 24 56
3 CD Vitoria CD Vitoria 28 35 14 55
4 CD Basconia CD Basconia 28 38 26 47
5 JD Somorrostro Somorrostro 28 38 27 46
6 SD Gernika SD Gernika 28 42 26 45
7 San Ignacio San Ignacio 28 38 29 39
8 Pasaia KE Pasaia KE 28 27 27 39
9 Santutxu Santutxu 28 26 26 39
10 Balmaseda FC Balmaseda 28 29 28 37
11 Sodupe Sodupe 28 27 31 36
12 Santurtzi Santurtzi 28 21 27 36
13 Real Sociedad C Real 28 33 39 34
14 Beasain KE Beasain KE 28 31 31 33
15 SCD Durango SCD Durango 28 33 35 29
16 Urduliz FT Urduliz FT 28 20 26 28
17 Tolosa CF Tolosa CF 28 20 42 26
18 Deusto Deusto 28 28 49 26
19 CD Lagun Onak Lagun Onak 28 19 32 26
20 Ariznabarra Ariznabarra 28 17 61 17
TEMPORADA 2018/2019
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Racing Racing 38 66 25 78
2 UD Logroñés Logroñés 38 44 22 72
3 Mirandés Mirandés 38 53 32 69
4 Barakaldo Barakaldo 38 41 40 61
5 Real Oviedo Vetusta Real Oviedo 38 55 45 59
6 Bilbao Ath. Bilbao Ath. 38 67 45 57
7 Leioa Leioa 38 43 40 53
8 SD Amorebieta Amorebieta 38 44 45 53
9 Langreo Langreo 38 43 48 52
10 CD Calahorra Calahorra 38 45 52 50
11 Sporting Atlético Sporting 38 42 43 49
12 Real Sociedad B Real 38 47 42 45
13 Izarra Izarra 38 33 44 45
14 Tudelano Tudelano 38 33 42 45
15 Arenas de Getxo Arenas Getxo 38 33 40 45
16 Real Unión Club Real Unión 38 39 44 44
17 SD Gernika SD Gernika 38 32 42 42
18 CD Vitoria CD Vitoria 38 34 51 35
19 Gimnástica Torrelavega Gimnástica 38 25 44 32
20 SCD Durango SCD Durango 38 32 65 30
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Mirandés Mirandés 38 53 33 76
2 Sporting Atlético Sporting 38 61 36 75
3 Real Sociedad B Real 38 49 24 74
4 Bilbao Ath. Bilbao Ath. 38 67 27 73
5 Racing Racing 38 44 33 68
6 Barakaldo Barakaldo 38 50 28 63
7 UD Logroñés Logroñés 38 55 35 61
8 SD Gernika SD Gernika 38 46 41 59
9 Tudelano Tudelano 38 38 32 53
10 Leioa Leioa 38 47 42 51
11 Burgos Burgos 38 28 28 51
12 Arenas de Getxo Arenas Getxo 38 46 43 46
13 Real Unión Club Real Unión 38 32 46 46
14 SD Amorebieta Amorebieta 38 44 46 44
15 CD Vitoria CD Vitoria 38 40 44 43
16 Izarra Izarra 38 32 58 39
17 Peña Sport Peña Sport 38 33 62 35
18 Lealtad Villaviciosa Lealtad 38 26 60 28
19 Osasuna Promesas Osasuna 38 25 63 24
20 Caudal Deportivo Caudal 38 19 54 19
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Albacete Albacete 38 64 36 69
2 CD Toledo CD Toledo 38 38 34 65
3 Fuenlabrada Fuenlabrada 38 54 42 63
4 Rayo Majadahonda Rayo 38 43 35 61
5 Leioa Leioa 38 53 42 60
6 UD Logroñés Logroñés 38 50 33 56
7 Real Unión Club Real Unión 38 39 38 56
8 Bilbao Ath. Bilbao Ath. 38 45 33 56
9 Arenas de Getxo Arenas Getxo 38 50 46 55
10 Real Sociedad B Real 38 55 43 52
11 RM Castilla RM Castilla 38 43 47 51
12 SD Gernika SD Gernika 38 47 52 49
13 Barakaldo Barakaldo 38 46 42 49
14 SD Amorebieta Amorebieta 38 47 47 48
15 CDA Navalcarnero Navalcarnero 38 38 42 47
16 UD Sanse UD Sanse 38 47 51 47
17 CD Mensajero Mensajero 38 40 47 46
18 UD Yugo Socuéllamos Yugo 38 42 62 38
19 Sestao River Sestao River 38 28 46 37
20 SD Zamudio SD Zamudio 38 33 84 22
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 RM Castilla RM Castilla 38 72 40 80
2 Barakaldo Barakaldo 38 52 24 80
3 UD Yugo Socuéllamos Yugo 38 51 43 64
4 CD Toledo CD Toledo 38 49 33 63
5 Real Unión Club Real Unión 38 59 37 60
6 Sestao River Sestao River 38 38 29 60
7 Real Sociedad B Real 38 58 44 60
8 Arenas de Getxo Arenas Getxo 38 50 43 57
9 SD Amorebieta Amorebieta 38 50 43 56
10 CD Ebro CD Ebro 38 43 37 53
11 Fuenlabrada Fuenlabrada 38 40 40 49
12 SD Gernika SD Gernika 38 41 49 45
13 CD Mensajero Mensajero 38 37 47 44
14 Rayo Majadahonda Rayo 38 42 50 43
15 La Roda CF La Roda CF 38 40 52 43
16 Leioa Leioa 38 37 59 41
17 CD Guadalajara Guadalajara 38 40 56 40
18 CF Talavera CF Talavera 38 42 59 37
19 Portugalete Portugalete 38 29 48 32
20 Getafe B Getafe B 38 43 80 32
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Portugalete Portugalete 38 68 27 75
2 SD Gernika SD Gernika 38 54 21 75
3 Arenas de Getxo Arenas Getxo 38 62 31 71
4 SCD Durango SCD Durango 38 43 30 67
5 Beasain KE Beasain KE 38 52 41 67
6 Zalla Zalla 38 50 36 66
7 Deportivo Alavés B Deportivo 38 52 41 58
8 Real Sociedad C Real 38 38 32 57
9 Balmaseda FC Balmaseda 38 43 37 55
10 Santurtzi Santurtzi 38 48 49 51
11 SD Zamudio SD Zamudio 38 53 49 50
12 CD Aurrera Vitoria Aurrera 38 44 48 49
13 Santutxu Santutxu 38 31 43 46
14 Club Bermeo Club Bermeo 38 35 49 45
15 CD Lagun Onak Lagun Onak 38 38 43 43
16 CD Basconia CD Basconia 38 44 57 42
17 Pasaia KE Pasaia KE 38 35 49 38
18 SD Erandio SD Erandio 38 33 62 32
19 Oiartzun KE Oiartzun KE 38 24 55 26
20 Amurrio Amurrio 38 25 72 24
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Leioa Leioa 38 62 34 81
2 Portugalete Portugalete 38 67 38 70
3 Arenas de Getxo Arenas Getxo 38 67 39 69
4 CD Basconia CD Basconia 38 77 49 67
5 Deportivo Alavés B Deportivo 38 54 33 62
6 Zalla Zalla 38 55 45 60
7 SD Gernika SD Gernika 38 43 29 59
8 SD Zamudio SD Zamudio 38 64 48 56
9 Balmaseda FC Balmaseda 38 45 40 55
10 Beasain KE Beasain KE 38 45 59 52
11 Santutxu Santutxu 38 37 40 48
12 SCD Durango SCD Durango 38 52 57 48
13 Pasaia KE Pasaia KE 38 39 48 46
14 CD Lagun Onak Lagun Onak 38 34 46 45
15 Oiartzun KE Oiartzun KE 38 40 61 44
16 Amurrio Amurrio 38 31 45 42
17 Club Bermeo Club Bermeo 38 37 46 39
18 CD Elgoibar CD Elgoibar 38 26 48 35
19 Sodupe Sodupe 38 36 65 25
20 Retuerto Sport Retuerto 38 21 62 25
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Laudio Laudio 38 65 28 81
2 Arenas de Getxo Arenas Getxo 38 54 24 78
3 Portugalete Portugalete 38 75 38 73
4 Leioa Leioa 38 43 27 71
5 SD Gernika SD Gernika 38 57 30 69
6 Zalla Zalla 38 51 35 68
7 Club Bermeo Club Bermeo 38 50 46 52
8 SCD Durango SCD Durango 38 39 44 48
9 SD Zamudio SD Zamudio 38 41 52 47
10 Beasain KE Beasain KE 38 37 41 47
11 CD Lagun Onak Lagun Onak 38 36 41 46
12 CD Basconia CD Basconia 38 48 57 45
13 Pasaia KE Pasaia KE 38 42 63 43
14 Deportivo Alavés B Deportivo 38 40 48 43
15 CD Elgoibar CD Elgoibar 38 35 42 43
16 Balmaseda FC Balmaseda 38 48 57 40
17 CD Getxo CD Getxo 38 34 49 39
18 Santutxu Santutxu 38 38 55 39
19 CD Aurrera Vitoria Aurrera 38 27 57 29
20 Anaitasuna FT Anaitasuna 38 35 61 25
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Laudio Laudio 38 70 24 77
2 Barakaldo Barakaldo 38 57 30 76
3 Portugalete Portugalete 38 60 29 74
4 Beasain KE Beasain KE 38 58 34 72
5 Zalla Zalla 38 57 34 72
6 SD Gernika SD Gernika 38 50 37 64
7 SCD Durango SCD Durango 38 49 41 63
8 SD Zamudio SD Zamudio 38 42 42 54
9 Leioa Leioa 38 44 37 53
10 CD Basconia CD Basconia 38 67 67 47
11 CD Lagun Onak Lagun Onak 38 29 31 46
12 CD Elgoibar CD Elgoibar 38 41 49 45
13 Eibar B Eibar B 38 36 45 44
14 Arenas de Getxo Arenas Getxo 38 43 44 42
15 Santutxu Santutxu 38 35 56 40
16 Balmaseda FC Balmaseda 38 48 57 40
17 Deportivo Alavés B Deportivo 38 49 71 40
18 CD Vitoria CD Vitoria 38 42 64 32
19 CD Hernani CD Hernani 38 31 71 26
20 Zarauzko Ke Zarauzko Ke 38 29 74 20
TEMPORADA 2010/2011
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 SD Amorebieta Amorebieta 38 73 26 84
2 Sestao River Sestao River 38 55 27 74
3 Laudio Laudio 38 60 36 73
4 SCD Durango SCD Durango 38 51 33 68
5 Beasain KE Beasain KE 38 49 32 62
6 Arenas de Getxo Arenas Getxo 38 25 23 56
7 CD Basconia CD Basconia 38 54 42 56
8 Portugalete Portugalete 38 55 34 56
9 Leioa Leioa 38 41 39 55
10 CD Lagun Onak Lagun Onak 38 40 30 53
11 Zalla Zalla 38 32 51 48
12 Santutxu Santutxu 38 35 43 47
13 SD Zamudio SD Zamudio 38 33 48 45
14 Eibar B Eibar B 38 31 49 41
15 Zarautz Zarautz 38 32 54 39
16 SD Gernika SD Gernika 38 35 40 38
17 CD Elgoibar CD Elgoibar 38 32 51 38
18 Amurrio Amurrio 38 29 52 36
19 Santurtzi Santurtzi 38 26 43 35
20 CD Aurrera Vitoria Aurrera 38 29 64 33
TEMPORADA 2009/2010
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 38 68 23 75
2 Portugalete Portugalete 38 65 31 69
3 SD Amorebieta Amorebieta 38 58 34 68
4 CD Elgoibar CD Elgoibar 38 40 29 65
5 SD Gernika SD Gernika 38 54 38 63
6 Beasain KE Beasain KE 38 58 35 63
7 SCD Durango SCD Durango 38 56 44 59
8 Amurrio Amurrio 38 53 42 57
9 SD Zamudio SD Zamudio 38 47 44 56
10 CD Basconia CD Basconia 38 53 56 52
11 Laudio Laudio 38 31 31 49
12 Santurtzi Santurtzi 38 45 40 48
13 Zalla Zalla 38 38 47 47
14 Eibar B Eibar B 38 46 57 46
15 Arenas de Getxo Arenas Getxo 38 29 41 46
16 Leioa Leioa 38 45 59 45
17 CD Lagun Onak Lagun Onak 38 33 42 43
18 Aretxabaleta Aretxabaleta 38 33 58 41
19 Retuerto Sport Retuerto 38 31 74 26
20 Salvatierra Salvatierra 38 22 80 13
TEMPORADA 2008/2009
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Lagun Onak Lagun Onak 38 51 25 73
2 Amurrio Amurrio 38 63 27 73
3 CD Elgoibar CD Elgoibar 38 54 32 70
4 Portugalete Portugalete 38 54 35 70
5 Beasain KE Beasain KE 38 68 38 70
6 SD Gernika SD Gernika 38 45 35 56
7 CD Basconia CD Basconia 38 50 51 56
8 Laudio Laudio 38 39 43 50
9 SD Zamudio SD Zamudio 38 42 38 49
10 SD Amorebieta Amorebieta 38 59 59 48
11 Leioa Leioa 38 38 45 47
12 Arenas de Getxo Arenas Getxo 38 38 43 47
13 Zalla Zalla 38 35 53 46
14 Santurtzi Santurtzi 38 36 45 46
15 Eibar B Eibar B 38 32 35 44
16 SCD Durango SCD Durango 38 44 50 43
17 Zarautz Zarautz 38 45 51 42
18 Ordizia KE Ordizia KE 38 35 61 40
19 Deportivo Alavés B Deportivo 38 31 53 32
20 San Ignacio San Ignacio 38 25 65 19
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 2004/2005
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Portugalete Portugalete 38 75 29 83
2 Zalla Zalla 38 58 29 75
3 SD Gernika SD Gernika 38 51 25 74
4 SCD Durango SCD Durango 38 52 30 70
5 SD Zamudio SD Zamudio 38 40 26 65
6 Beasain KE Beasain KE 38 47 38 64
7 Arenas de Getxo Arenas Getxo 38 39 32 52
8 CD Basconia CD Basconia 38 53 46 51
9 SD Indautxu SD Indautxu 38 42 49 50
10 Aurrera KE Aurrera KE 38 29 36 50
11 CD Lagun Onak Lagun Onak 38 37 42 47
12 SD San Pedro Pedro 38 51 50 47
13 SD Amorebieta Amorebieta 38 43 47 47
14 Laudio Laudio 38 44 46 45
15 Eibar B Eibar B 38 33 47 45
16 CD Elgoibar CD Elgoibar 37 51 55 43
17 CD Aurrera Vitoria Aurrera 37 37 46 43
18 Deportivo Alavés C Deportivo 38 44 52 39
19 Real Sociedad C Real 38 31 58 31
20 Bruno Villarreal Bruno 38 23 97 16

  USO DE MEMORIA  
8,488,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3940
Total Execution Time  0.3959
  CADENA URL  
/historico/Gernika
  GET DATOS  
$_GET['/historico/Gernika']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1216 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1216 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (754,2599,2827,7500,37452) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '1216' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135  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 = 1216 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0255  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 `tables2023` 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 = 67966 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2022` 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 = 62381 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 50272 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `tables2018` 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 = 38807 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 `tables2017` 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 = 33379 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 `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15376 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 `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3914 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 `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2554 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 `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1952 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 `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1401 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 `tables2011` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1120 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 `tables2010` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 831 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 `tables2009` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 134 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 `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.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 `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