4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CD Elgoibar
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 5
Equipo PJ GF GC Puntos
1 Eibar B Eibar B 7 21 5 18
2 Bergara KE Bergara KE 7 12 8 14
3 CD Elgoibar CD Elgoibar 7 10 10 11
4 Aretxabaleta Aretxabaleta 7 16 11 9
5 Mutriku FT Mutriku FT 7 10 15 9
6 Amaikak Bat Amaikak Bat 7 8 11 6
7 SD Urola SD Urola 7 4 11 5
8 Mondragón Mondragón 7 2 12 4
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 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
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
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
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Cultural Leonesa Cultural 38 51 37 72
2 Club Bermeo Club Bermeo 38 49 35 70
3 Barakaldo Barakaldo 38 50 27 69
4 Burgos Burgos 38 44 24 66
5 UB Conquense Conquense 38 46 39 60
6 Bilbao Ath. Bilbao Ath. 38 54 36 59
7 Amurrio Amurrio 38 47 38 56
8 Gimnástica Torrelavega Gimnástica 38 39 44 53
9 Real Valladolid Promesas Real 38 36 43 53
10 Osasuna Promesas Osasuna 38 34 30 50
11 Deportivo Aragón Deportivo 38 43 47 49
12 CD Calahorra Calahorra 38 35 36 48
13 Beasain KE Beasain KE 38 27 30 45
14 SD Gernika SD Gernika 38 43 48 45
15 CD Binéfar CD Binéfar 38 35 38 44
16 CD Aurrera Vitoria Aurrera 38 32 36 44
17 Noja Noja 38 33 49 44
18 Lemona Lemona 38 32 43 38
19 Tropezón Tropezón 38 27 47 36
20 CD Elgoibar CD Elgoibar 38 30 60 29

  USO DE MEMORIA  
7,811,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6724
Total Execution Time  0.6738
  CADENA URL  
/historico/Elgoibar
  GET DATOS  
$_GET['/historico/Elgoibar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=979 AND type_rel = 2
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 979 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0159  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 (258953,259487,382293) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '979' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73550 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=979 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73550 AND teamId = 979
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 `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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '979' and rp.type = 4
0.0146  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 = '979' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73550 WHERE rp.league_id = 73550 AND rp.teamId = 979 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73550 WHERE rp.league_id = 73550 AND rp.teamId = 979 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 73550 WHERE rp.league_id = 73550 AND rp.teamId = 979 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 979 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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 = 60098 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.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 `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.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 `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.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 `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.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 `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.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 `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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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.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 `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.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 `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.0160  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.0170  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.0169  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.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 `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.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 `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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 22097 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 `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.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 5504 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC