4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Hernani
TEMPORADA 2023/2024
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Aretxabaleta Aretxabaleta 22 53 21 51
2 Eibar B Eibar B 22 54 24 46
3 Zarautz Zarautz 22 46 19 46
4 Bergara KE Bergara KE 22 27 18 41
5 Mutriku FT Mutriku FT 22 31 24 41
6 Tolosa CF Tolosa CF 22 33 30 33
7 Real Unión B Real Unión 22 26 23 33
8 CD Hernani CD Hernani 22 31 27 31
9 CD Elgoibar CD Elgoibar 22 22 27 29
10 Zumaiako Zumaiako 22 32 35 28
11 Oiartzun KE Oiartzun KE 22 27 31 28
12 Deusto FC Deusto FC 22 19 36 22
13 SD Urola SD Urola 22 27 38 21
14 Lagun Onak B Lagun Onak 22 25 38 20
15 Ordizia KE Ordizia KE 22 20 42 20
16 Beti Gazte KKE Beti Gazte 22 24 31 19
17 Amaikak Bat Amaikak Bat 22 26 41 19
18 Beasain B Beasain B 22 18 36 17
TEMPORADA 2022/2023
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Eibar B Eibar B 34 87 33 71
2 Añorga Añorga 34 54 37 62
3 Oiartzun KE Oiartzun KE 34 43 39 54
4 CD Hernani CD Hernani 34 58 47 54
5 CD Elgoibar CD Elgoibar 34 35 32 52
6 Zumaiako Zumaiako 34 60 46 51
7 Amaikak Bat Amaikak Bat 34 42 53 49
8 Zarautz Zarautz 34 41 37 46
9 SD Urola SD Urola 34 44 48 46
10 Beti Gazte KKE Beti Gazte 34 38 45 46
11 Aretxabaleta Aretxabaleta 34 55 47 45
12 Mutriku FT Mutriku FT 34 31 39 44
13 Bergara KE Bergara KE 34 45 54 43
14 Tolosa CF Tolosa CF 34 39 41 43
15 Lagun Onak B Lagun Onak 34 27 41 39
16 UPV Vasconia Vasconia 34 44 57 37
17 Aloña Mendi Aloña Mendi 34 35 52 31
18 Mondragón Mondragón 34 29 59 23
TEMPORADA 2021/2022
DIVISIÓN HONOR PAÍS VASCO GRUPO 5
Equipo PJ GF GC Puntos
1 CD Touring CD Touring 34 74 28 73
2 Eibar B Eibar B 34 60 29 64
3 CD Elgoibar CD Elgoibar 34 58 33 64
4 Aretxabaleta Aretxabaleta 34 49 36 60
5 CD Hernani CD Hernani 34 56 35 57
6 Mondragón Mondragón 34 40 30 54
7 Bergara KE Bergara KE 34 43 29 53
8 Zarautz Zarautz 34 47 51 50
9 Oiartzun KE Oiartzun KE 34 37 50 45
10 Añorga Añorga 34 42 44 44
11 Mutriku FT Mutriku FT 34 37 40 43
12 SD Urola SD Urola 34 41 47 41
13 Aloña Mendi Aloña Mendi 34 50 49 40
14 Amaikak Bat Amaikak Bat 34 32 46 39
15 Real Unión B Real Unión 34 36 44 34
16 Ordizia KE Ordizia KE 34 28 52 34
17 Euskalduna Euskalduna 34 23 67 20
18 Allerru KE Allerru KE 34 32 75 19
TEMPORADA 2020/2021
DIVISIÓN HONOR PAÍS VASCO GRUPO 4
Equipo PJ GF GC Puntos
1 Beti Gazte KKE Beti Gazte 9 31 11 20
2 CD Hernani CD Hernani 9 19 8 20
3 Añorga Añorga 9 17 7 17
4 Zarautz Zarautz 9 14 11 15
5 CD Touring CD Touring 9 8 10 14
6 Oiartzun KE Oiartzun KE 9 12 18 13
7 Real Unión B Real Unión 9 10 13 11
8 Allerru KE Allerru KE 9 14 23 7
9 Ordizia KE Ordizia KE 9 12 22 6
10 Euskalduna Euskalduna 9 6 20 2
TEMPORADA 2019/2020
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Anaitasuna FT Anaitasuna 24 59 23 52
2 Eibar B Eibar B 24 56 26 52
3 CD Hernani CD Hernani 25 49 27 51
4 Beti Gazte KKE Beti Gazte 25 55 30 47
5 Añorga Añorga 25 39 37 40
6 Aretxabaleta Aretxabaleta 25 30 31 38
7 Mutriku FT Mutriku FT 25 39 42 37
8 CD Elgoibar CD Elgoibar 25 43 41 35
9 Amaikak Bat Amaikak Bat 25 33 34 35
10 Zarautz Zarautz 25 31 36 34
11 SD Urola SD Urola 25 32 42 34
12 CD Touring CD Touring 25 27 37 32
13 Mondragón Mondragón 25 36 37 29
14 Ordizia KE Ordizia KE 25 31 37 28
15 Bergara KE Bergara KE 25 21 36 23
16 Oiartzun KE Oiartzun KE 25 32 47 21
17 Real Unión B Real Unión 25 23 37 20
18 Euskalduna Euskalduna 25 17 53 17
TEMPORADA 2017/2018
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Pasaia KE Pasaia KE 34 61 33 72
2 Ordizia KE Ordizia KE 34 77 22 70
3 Tolosa CF Tolosa CF 34 68 31 69
4 CD Hernani CD Hernani 34 63 27 65
5 Bergara KE Bergara KE 34 50 31 60
6 Mondragón Mondragón 34 52 32 59
7 Zarautz Zarautz 34 55 38 59
8 Amaikak Bat Amaikak Bat 34 49 47 47
9 Mutriku FT Mutriku FT 34 57 50 46
10 Aretxabaleta Aretxabaleta 34 34 34 44
11 Añorga Añorga 34 47 48 40
12 Oiartzun KE Oiartzun KE 34 40 43 40
13 Beti Gazte KKE Beti Gazte 34 42 53 40
14 Real Unión B Real Unión 34 36 41 38
15 Hondarribia Hondarribia 34 39 59 36
16 SD Urola SD Urola 34 43 59 34
17 UPV Vasconia Vasconia 34 44 74 25
18 CD Touring CD Touring 34 15 150 3
TEMPORADA 2016/2017
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Anaitasuna FT Anaitasuna 34 72 30 73
2 CD Hernani CD Hernani 34 60 25 72
3 Aretxabaleta Aretxabaleta 34 57 23 66
4 Ordizia KE Ordizia KE 34 64 45 56
5 Mutriku FT Mutriku FT 34 59 43 56
6 Real Unión B Real Unión 34 32 33 52
7 Mondragón Mondragón 34 59 45 48
8 Oiartzun KE Oiartzun KE 34 37 38 46
9 UPV Vasconia Vasconia 34 39 52 45
10 Hondarribia Hondarribia 34 43 36 43
11 Zarautz Zarautz 34 51 45 43
12 Beti Gazte KKE Beti Gazte 34 48 62 42
13 Amaikak Bat Amaikak Bat 34 39 56 41
14 CD Touring CD Touring 34 46 45 40
15 CD Elgoibar CD Elgoibar 34 38 50 37
16 Aloña Mendi Aloña Mendi 34 29 45 35
17 Ostadar SKT Ostadar SKT 34 39 85 26
18 Martutene Martutene 34 30 84 16
TEMPORADA 2015/2016
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Tolosa CF Tolosa CF 34 70 34 70
2 Anaitasuna FT Anaitasuna 34 67 27 69
3 Real Unión B Real Unión 34 64 33 68
4 Mutriku FT Mutriku FT 34 53 39 60
5 Aloña Mendi Aloña Mendi 34 48 42 53
6 CD Hernani CD Hernani 34 47 38 52
7 Oiartzun KE Oiartzun KE 34 45 36 51
8 CD Touring CD Touring 34 46 41 49
9 Zarautz Zarautz 34 45 46 48
10 Ostadar SKT Ostadar SKT 34 48 60 48
11 CD Elgoibar CD Elgoibar 34 36 47 43
12 Hondarribia Hondarribia 34 43 46 40
13 Martutene Martutene 34 38 47 39
14 Ordizia KE Ordizia KE 34 44 50 38
15 Beti Gazte KKE Beti Gazte 34 40 49 38
16 Euskalduna Euskalduna 34 33 65 36
17 Getariako Keta FT Getariako 34 37 65 31
18 Orio'ko FT Orio'ko FT 34 32 71 26
TEMPORADA 2014/2015
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Aurrera KE Aurrera KE 34 70 27 75
2 Aretxabaleta Aretxabaleta 34 60 25 68
3 CD Hernani CD Hernani 34 55 30 61
4 Tolosa CF Tolosa CF 34 44 33 59
5 Anaitasuna FT Anaitasuna 34 49 39 53
6 CD Touring CD Touring 34 55 50 51
7 Martutene Martutene 34 46 37 48
8 CD Elgoibar CD Elgoibar 34 42 39 46
9 Beti Gazte KKE Beti Gazte 34 37 45 45
10 Real Unión B Real Unión 34 36 41 44
11 Aloña Mendi Aloña Mendi 34 46 47 41
12 Ordizia KE Ordizia KE 34 36 47 41
13 Ostadar SKT Ostadar SKT 34 49 65 41
14 Bergara KE Bergara KE 34 32 43 36
15 Zarautz Zarautz 34 28 43 36
16 Hondarribia Hondarribia 34 27 44 36
17 Usuarbil FT Usuarbil FT 34 26 57 32
18 Antzuola KE Antzuola KE 34 43 69 29
TEMPORADA 2013/2014
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Real Sociedad C Real 34 64 32 69
2 Tolosa CF Tolosa CF 34 64 42 69
3 Aretxabaleta Aretxabaleta 34 54 35 64
4 Anaitasuna FT Anaitasuna 34 58 26 64
5 Aloña Mendi Aloña Mendi 34 48 35 55
6 Aurrera KE Aurrera KE 34 42 33 52
7 CD Hernani CD Hernani 34 48 45 48
8 Antzuola KE Antzuola KE 34 51 51 45
9 Beti Gazte KKE Beti Gazte 34 36 48 45
10 Real Unión B Real Unión 34 49 49 44
11 CD Touring CD Touring 34 46 53 40
12 Hondarribia Hondarribia 34 40 58 39
13 Ostadar SKT Ostadar SKT 34 39 46 38
14 Zarautz Zarautz 34 34 49 38
15 Bergara KE Bergara KE 34 40 42 38
16 UPV Vasconia Vasconia 34 38 45 38
17 Lagun Onak B Lagun Onak 34 31 62 23
18 Getariako Keta FT Getariako 34 33 64 22
TEMPORADA 2012/2013
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Oiartzun KE Oiartzun KE 34 59 27 78
2 CD Hernani CD Hernani 34 56 27 74
3 Real Unión B Real Unión 34 56 32 72
4 Aretxabaleta Aretxabaleta 34 56 32 67
5 Real Sociedad C Real 34 60 54 53
6 Hondarribia Hondarribia 33 46 35 52
7 Tolosa CF Tolosa CF 34 53 40 49
8 Bergara KE Bergara KE 34 33 33 49
9 Aloña Mendi Aloña Mendi 32 27 36 40
10 Zarautz Zarautz 34 42 48 38
11 Lagun Onak B Lagun Onak 33 30 45 37
12 Beti Gazte KKE Beti Gazte 33 37 42 36
13 Ostadar SKT Ostadar SKT 34 48 58 36
14 CD Touring CD Touring 34 37 53 36
15 Mondragón Mondragón 34 40 63 34
16 Aurrera KE Aurrera KE 33 45 51 33
17 SD Urola SD Urola 34 39 53 32
18 Trintxerpe Trintxerpe 34 32 67 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
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 CD Hernani CD Hernani 34 67 21 78
2 Real Unión B Real Unión 34 67 24 77
3 Pasajes Pasajes 34 70 42 66
4 Aretxabaleta Aretxabaleta 34 43 30 62
5 Anaitasuna FT Anaitasuna 34 46 31 56
6 Oiartzun KE Oiartzun KE 34 48 33 53
7 Tolosa CF Tolosa CF 34 39 35 53
8 Aurrera KE Aurrera KE 34 36 37 48
9 Bergara KE Bergara KE 34 44 44 47
10 Real Sociedad C Real 34 42 41 43
11 Mondragón Mondragón 34 45 51 42
12 Trintxerpe Trintxerpe 34 39 40 39
13 Aloña Mendi Aloña Mendi 34 36 51 38
14 Hondarribia Hondarribia 34 41 74 34
15 CD Roteta CD Roteta 34 41 59 32
16 Zumaiako Zumaiako 34 35 51 30
17 Idiazabal Idiazabal 34 37 59 30
18 Ordizia KE Ordizia KE 34 25 78 22
TEMPORADA 2008/2009
DIVISIÓN HONOR PAÍS VASCO GRUPO 3
Equipo PJ GF GC Puntos
1 Aretxabaleta Aretxabaleta 34 57 27 74
2 CD Hernani CD Hernani 34 57 39 64
3 Pasajes Pasajes 34 54 38 61
4 Aloña Mendi Aloña Mendi 34 61 42 60
5 Real Unión B Real Unión 34 60 38 59
6 Tolosa CF Tolosa CF 34 57 39 59
7 Trintxerpe Trintxerpe 34 61 45 55
8 Hondarribia Hondarribia 34 47 43 52
9 Real Sociedad C Real 34 52 43 51
10 Idiazabal Idiazabal 34 31 41 44
11 Mondragón Mondragón 34 43 54 38
12 Aurrera KE Aurrera KE 34 33 45 38
13 UPV Vasconia Vasconia 34 35 50 36
14 Euskalduna Euskalduna 34 43 54 35
15 Astigarrako Mundarro Astigarrako 29 20 26 34
16 Anaitasuna FT Anaitasuna 34 28 42 32
17 Zumaiako Zumaiako 34 29 53 24
18 Amaikak Bat Amaikak Bat 34 28 75 17
19 Astigarragako Mundarro Astigarragak 5 6 8 4
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

  USO DE MEMORIA  
7,734,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5361
Total Execution Time  0.5373
  CADENA URL  
/historico/Hernani
  GET DATOS  
$_GET['/historico/Hernani']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0117  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 = 'Hernani' AND l.year = 2024 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.0106  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=1317 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=1317 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1317 AND type_rel = 2
0.0107  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1317 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (400866,827094,1065416,1069146) ORDER BY n.cover_points DESC, update_date DESC
0.0110  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 = '1317' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0113  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=1317 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0105  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 (73550) 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.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 73550 AND teamId = 1317
0.0107  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 events2024 e ON e.player_id = p.id AND e.league_id = 73550 WHERE rp.league_id = 73550 AND rp.teamId = 1317 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.0106  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 events2024 e ON e.player_id = p.id AND e.league_id = 73550 WHERE rp.league_id = 73550 AND rp.teamId = 1317 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 events2024 e ON e.player_id = p.id AND e.league_id = 73550 WHERE rp.league_id = 73550 AND rp.teamId = 1317 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 1317 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111  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 `tables2024` 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 = 73550 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 68810 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.0113  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 = 63867 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.0108  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 `tables2021` 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 = 60097 AND t.round = 9 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 51265 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 39692 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 36614 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113  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 = 16751 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 4071 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 2671 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 1982 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124  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.0109  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 = 1143 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 309 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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.0113  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.0113  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.0114  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.0112  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.0211  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