4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sodupe
TEMPORADA 2023/2024
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 Santurtzi Santurtzi 31 55 29 65
2 SD Zamudio SD Zamudio 31 45 32 54
3 Sodupe Sodupe 31 37 36 51
4 Zalla Zalla 31 36 24 51
5 Club Bermeo Club Bermeo 31 31 25 49
6 Santutxu Santutxu 31 49 31 48
7 Galdakao Galdakao 31 33 32 45
8 CD Getxo CD Getxo 31 28 26 42
9 SD Erandio SD Erandio 31 38 38 39
10 Uritarra CD Uritarra CD 31 31 28 38
11 SD San Pedro Pedro 31 45 50 37
12 JD Somorrostro Somorrostro 31 41 47 37
13 Dínamo San Juan Dínamo Juan 31 47 48 36
14 Balmaseda FC Balmaseda 31 34 36 36
15 Iurretako KT Iurretako 31 33 48 34
16 Arratia CD Arratia CD 31 25 37 32
17 SD Indautxu SD Indautxu 31 28 43 30
18 SD Iturrigorri Iturrigorri 31 27 53 28
TEMPORADA 2022/2023
DIVISIÓN HONOR PAÍS VASCO GRUPO 2
Equipo PJ GF GC Puntos
1 CD Derio CD Derio 38 63 29 79
2 Santurtzi Santurtzi 38 79 40 74
3 SD Erandio SD Erandio 38 54 37 63
4 JD Somorrostro Somorrostro 38 60 50 63
5 Uritarra CD Uritarra CD 38 55 47 61
6 Club Bermeo Club Bermeo 38 39 25 60
7 SD San Pedro Pedro 38 59 55 58
8 Santutxu Santutxu 38 49 32 56
9 Zalla Zalla 38 59 47 55
10 SD Zamudio SD Zamudio 38 49 48 54
11 Balmaseda FC Balmaseda 38 45 44 52
12 Sodupe Sodupe 38 63 60 51
13 SD Indautxu SD Indautxu 38 43 47 50
14 Dínamo San Juan Dínamo Juan 38 50 55 47
15 Galdakao Galdakao 38 48 65 44
16 CD Getxo CD Getxo 38 47 41 43
17 Iurretako KT Iurretako 38 39 47 42
18 Abanto Club Abanto Club 38 43 70 41
19 Abadiño KE Abadiño KE 38 36 67 30
20 CD Elorrio CD Elorrio 38 31 105 10
TEMPORADA 2021/2022
DIVISIÓN HONOR PAÍS VASCO GRUPO 9
Equipo PJ GF GC Puntos
1 CD Getxo CD Getxo 32 61 35 56
2 Iurretako KT Iurretako 32 35 39 47
3 CD Elorrio CD Elorrio 32 37 49 45
4 Sodupe Sodupe 32 37 29 45
5 Galdakao Galdakao 32 47 48 45
6 Abanto Club Abanto Club 32 37 34 43
7 JD Somorrostro Somorrostro 32 43 38 43
8 Gatika KT Gatika KT 32 46 44 42
9 Otxarkoaga Otxarkoaga 32 40 37 40
10 SD Basurto SD Basurto 32 30 73 24
11 Gernika B Gernika B 32 34 60 20
12 Cd Sondika Cd Sondika 32 25 63 19
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
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Portugalete Portugalete 38 65 21 86
2 Sestao River Sestao River 38 74 36 78
3 Deportivo Alavés B Deportivo 38 69 44 66
4 San Ignacio San Ignacio 38 66 36 63
5 Balmaseda FC Balmaseda 38 50 36 63
6 CD Basconia CD Basconia 38 64 52 60
7 Real Sociedad C Real 38 71 48 59
8 JD Somorrostro Somorrostro 38 59 43 57
9 Sodupe Sodupe 38 49 45 50
10 Pasaia KE Pasaia KE 38 33 46 49
11 Santutxu Santutxu 38 38 48 48
12 CD Lagun Onak Lagun Onak 38 46 46 48
13 Beasain KE Beasain KE 38 46 40 46
14 Santurtzi Santurtzi 38 33 42 45
15 Deusto Deusto 38 41 55 43
16 SD Zamudio SD Zamudio 38 42 66 39
17 Amurrio Amurrio 38 30 64 34
18 Ordizia KE Ordizia KE 38 40 72 31
19 SD San Pedro Pedro 38 40 69 29
20 Club Bermeo Club Bermeo 38 24 71 19
TEMPORADA 2017/2018
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 SCD Durango SCD Durango 38 62 36 77
2 Portugalete Portugalete 38 63 29 71
3 Deportivo Alavés B Deportivo 38 55 27 65
4 Sestao River Sestao River 38 55 30 64
5 Beasain KE Beasain KE 38 50 33 61
6 Real Sociedad C Real 38 48 48 61
7 JD Somorrostro Somorrostro 38 59 43 58
8 Deusto Deusto 38 40 37 57
9 Balmaseda FC Balmaseda 38 42 43 54
10 Sodupe Sodupe 38 32 40 51
11 CD Lagun Onak Lagun Onak 38 44 49 50
12 SD Zamudio SD Zamudio 38 44 49 49
13 Santutxu Santutxu 38 33 45 47
14 Santurtzi Santurtzi 38 41 46 46
15 CD Basconia CD Basconia 38 49 46 43
16 Amurrio Amurrio 38 38 46 43
17 Club Bermeo Club Bermeo 38 31 52 39
18 Anaitasuna FT Anaitasuna 38 32 47 38
19 CD Getxo CD Getxo 38 23 49 31
20 CD Aurrera Vitoria Aurrera 38 30 76 19
TEMPORADA 2016/2017
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Deportivo Alavés B Deportivo 38 57 20 74
2 CD Vitoria CD Vitoria 38 60 39 72
3 SCD Durango SCD Durango 38 56 27 71
4 Beasain KE Beasain KE 38 51 29 70
5 Portugalete Portugalete 38 56 39 69
6 Club Bermeo Club Bermeo 38 53 41 56
7 Deusto Deusto 38 46 45 55
8 Santurtzi Santurtzi 38 44 38 53
9 Balmaseda FC Balmaseda 38 41 40 51
10 CD Basconia CD Basconia 38 50 55 48
11 Sodupe Sodupe 38 55 67 47
12 Amurrio Amurrio 38 39 39 46
13 CD Getxo CD Getxo 38 39 45 45
14 CD Lagun Onak Lagun Onak 38 30 47 45
15 Real Sociedad C Real 38 36 35 44
16 Santutxu Santutxu 38 38 45 41
17 Tolosa CF Tolosa CF 38 32 49 39
18 Aurrera KE Aurrera KE 38 27 54 38
19 Zalla Zalla 38 39 63 33
20 Pasaia KE Pasaia KE 38 35 67 29
TEMPORADA 2015/2016
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Sodupe Sodupe 34 76 33 72
2 CD Padura CD Padura 34 40 20 60
3 CD Loiu CD Loiu 34 41 29 60
4 Sondika Sondika 34 41 32 56
5 Apurtuarte Apurtuarte 34 43 30 52
6 Gallarta Gallarta 34 35 37 48
7 JD Somorrostro Somorrostro 34 43 43 48
8 Gatika KT Gatika KT 34 31 32 46
9 Iurretako KT Iurretako 34 36 34 44
10 Lekeitio FT Lekeitio FT 34 39 38 44
11 Urduliz FT Urduliz FT 34 38 50 42
12 Retuerto Sport Retuerto 34 38 38 40
13 SD Erandio SD Erandio 34 38 47 40
14 Derio Derio 34 23 33 38
15 CD Elorrio CD Elorrio 34 28 38 37
16 Abanto Club Abanto Club 34 38 50 35
17 Arratia CD Arratia CD 34 27 36 33
18 Trapagaran CF Trapagaran 34 21 56 24
TEMPORADA 2014/2015
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Deusto Deusto 34 48 24 70
2 CD Getxo CD Getxo 34 56 29 64
3 JD Somorrostro Somorrostro 34 52 27 63
4 Retuerto Sport Retuerto 34 37 21 57
5 Sodupe Sodupe 34 39 30 56
6 Iurretako KT Iurretako 34 46 28 53
7 Apurtuarte Apurtuarte 34 42 41 52
8 Sondika Sondika 34 32 26 51
9 Gallarta Gallarta 34 37 38 47
10 Gatika KT Gatika KT 34 38 40 44
11 Derio Derio 34 26 31 42
12 CD Elorrio CD Elorrio 34 35 36 40
13 Urduliz FT Urduliz FT 34 39 50 40
14 CD Loiu CD Loiu 34 40 48 39
15 Abanto Club Abanto Club 34 39 48 36
16 CD Padura CD Padura 34 28 44 34
17 Gurutzeta Gurutzeta 34 28 57 24
18 SD Indautxu SD Indautxu 34 31 75 20
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 2011/2012
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 CD Getxo CD Getxo 34 58 38 66
2 Club Bermeo Club Bermeo 34 63 38 65
3 JD Somorrostro Somorrostro 34 44 34 58
4 Deusto Deusto 34 52 35 56
5 Sondika Sondika 34 53 45 50
6 Apurtuarte Club Apurtuarte 34 47 55 49
7 Gallarta Gallarta 34 46 59 49
8 Gatika KT Gatika KT 34 49 40 48
9 Sodupe Sodupe 34 47 42 48
10 Derio Derio 34 37 32 47
11 SD Erandio SD Erandio 34 41 40 47
12 Santurtzi Santurtzi 34 39 52 39
13 Gurutzeta Gurutzeta 34 36 39 37
14 SD San Pedro Pedro 34 45 53 37
15 CD Elorrio CD Elorrio 34 26 32 35
16 Ugeraga Ugeraga 34 34 48 34
17 Galdakao Galdakao 34 36 54 32
18 SD Indautxu SD Indautxu 34 30 47 27
TEMPORADA 2010/2011
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Balmaseda FC Balmaseda 34 56 26 71
2 JD Somorrostro Somorrostro 34 51 26 66
3 Sondika Sondika 34 60 40 61
4 Club Bermeo Club Bermeo 34 61 49 56
5 Gallarta Gallarta 34 42 39 50
6 Deusto Deusto 34 37 34 50
7 CD Getxo CD Getxo 34 48 40 48
8 SD Indautxu SD Indautxu 34 44 38 47
9 Derio Derio 34 38 49 44
10 Sodupe Sodupe 34 33 37 40
11 Apurtuarte Club Apurtuarte 34 40 51 40
12 SD San Pedro Pedro 34 41 47 39
13 Galdakao Galdakao 34 28 38 39
14 Gurutzeta Gurutzeta 34 37 46 35
15 Berriz Berriz 34 40 67 35
16 Retuerto Sport Retuerto 34 38 43 34
17 Ugeraga Ugeraga 34 36 46 34
18 SD Basurto SD Basurto 34 35 49 31
TEMPORADA 2008/2009
DIVISIÓN HONOR PAÍS VASCO GRUPO 1
Equipo PJ GF GC Puntos
1 Retuerto Sport Retuerto 34 53 33 69
2 Balmaseda FC Balmaseda 34 49 34 63
3 Santutxu Santutxu 34 50 35 62
4 Gatika KT Gatika KT 34 38 25 59
5 Apurtuarte Apurtuarte 34 53 39 56
6 JD Somorrostro Somorrostro 34 46 35 52
7 Ortuella Ortuella 34 37 44 47
8 SD San Pedro Pedro 34 44 36 45
9 Deusto Deusto 34 39 39 45
10 Club Bermeo Club Bermeo 34 45 46 43
11 CD Getxo CD Getxo 34 44 47 43
12 Ugeraga Ugeraga 34 28 35 43
13 Derio Derio 34 34 37 42
14 Sondika Sondika 34 45 39 41
15 Berriz Berriz 34 35 50 38
16 Galdakao Galdakao 34 32 52 35
17 Sodupe Sodupe 34 34 46 34
18 SD Moraza SD Moraza 34 33 67 21
TEMPORADA 2001/2002
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Lemona Lemona 38 73 31 78
2 Sestao River Sestao River 38 58 28 72
3 Zalla Zalla 38 43 39 69
4 SD Amorebieta Amorebieta 38 51 34 67
5 Aurrera KE Aurrera KE 38 42 40 65
6 UPV Vasconia Vasconia 38 40 39 60
7 CD Basconia CD Basconia 38 51 41 58
8 Deportivo Alavés C Deportivo 38 52 42 54
9 Arenas de Getxo Arenas Getxo 38 49 34 54
10 Portugalete Portugalete 38 46 41 54
11 SD San Pedro Pedro 38 41 36 53
12 Aurrera Vitoria B Aurrera 38 36 32 53
13 Club Bermeo Club Bermeo 38 41 39 51
14 SCD Durango SCD Durango 38 41 48 46
15 SD Zamudio SD Zamudio 38 35 39 44
16 Real Unión B Real Unión 38 41 46 42
17 Sodupe Sodupe 38 36 55 41
18 Salleko Lagunak Salleko 38 40 67 41
19 Zestoa KB Zestoa KB 38 33 59 36
20 Anaitasuna FT Anaitasuna 38 18 77 12
TEMPORADA 2000/2001
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Lemona Lemona 38 83 24 92
2 Real Sociedad B Real 38 65 28 75
3 Sestao River Sestao River 38 62 24 73
4 Aurrera KE Aurrera KE 38 65 55 65
5 SD Zamudio SD Zamudio 38 59 48 64
6 CD Basconia CD Basconia 38 64 58 56
7 Arenas de Getxo Arenas Getxo 38 52 41 52
8 SCD Durango SCD Durango 38 52 57 52
9 Deportivo Alavés C Deportivo 38 38 37 50
10 Zalla Zalla 38 34 37 49
11 Club Bermeo Club Bermeo 38 46 49 47
12 SD San Pedro Pedro 38 40 41 45
13 SD Amorebieta Amorebieta 38 40 57 45
14 Real Unión B Real Unión 38 42 51 45
15 UPV Vasconia Vasconia 38 40 49 45
16 Aurrera Vitoria B Aurrera 38 35 42 44
17 Sodupe Sodupe 38 29 65 43
18 CD Hernani CD Hernani 38 31 51 39
19 Bergara KE Bergara KE 38 33 61 38
20 CD Lagun Onak Lagun Onak 38 35 70 31
TEMPORADA 1999/2000
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 38 68 22 82
2 Lemona Lemona 38 53 31 68
3 Arenas de Getxo Arenas Getxo 38 46 34 67
4 Eibar B Eibar B 38 58 33 64
5 CD Basconia CD Basconia 38 61 41 63
6 Sestao River Sestao River 38 43 32 60
7 Zalla Zalla 38 32 33 53
8 CD Hernani CD Hernani 38 35 41 53
9 Aurrera Vitoria B Aurrera 38 40 43 50
10 Aurrera KE Aurrera KE 38 45 37 48
11 SD Amorebieta Amorebieta 38 39 47 48
12 CD Lagun Onak Lagun Onak 38 42 45 47
13 UPV Vasconia Vasconia 38 33 43 46
14 Sodupe Sodupe 38 43 52 44
15 Bergara KE Bergara KE 38 43 47 43
16 SD San Pedro Pedro 38 31 38 43
17 CD Elgoibar CD Elgoibar 38 32 46 37
18 Santurtzi Santurtzi 38 28 78 37
19 Tolosa CF Tolosa CF 38 33 58 30
TEMPORADA 1998/1999
TERCERA DIVISIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 38 99 42 89
2 Deportivo Alavés B Deportivo 38 76 38 71
3 Real Unión Club Real Unión 38 60 29 66
4 Zalla Zalla 38 62 37 64
5 CD Hernani CD Hernani 38 45 37 62
6 SCD Durango SCD Durango 38 44 37 60
7 CD Basconia CD Basconia 38 50 42 57
8 Arenas de Getxo Arenas Getxo 38 44 42 53
9 SD San Pedro Pedro 38 37 39 52
10 Aurrera KE Aurrera KE 38 40 41 47
11 CD Lagun Onak Lagun Onak 38 44 49 46
12 Sodupe Sodupe 38 49 59 46
13 Eibar B Eibar B 38 47 47 46
14 SD Amorebieta Amorebieta 38 35 39 44
15 Tolosa CF Tolosa CF 38 45 49 42
16 UPV Vasconia Vasconia 38 38 58 41
17 Santurtzi Santurtzi 38 34 47 41
18 CD Touring CD Touring 38 44 79 35
19 SD Zamudio SD Zamudio 38 39 68 32
20 Alegría Alegría 38 38 91 22
TEMPORADA 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

  USO DE MEMORIA  
7,632,264 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1602
Total Execution Time  0.1614
  CADENA URL  
/historico/Sodupe
  GET DATOS  
$_GET['/historico/Sodupe']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0031  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 = 'Sodupe' 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.0018  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=2358 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2358 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 73549
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2358 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2358 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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,102810,822157,886617) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '2358' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '2358' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '2358' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 73549 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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=2358 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (73549) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73549 AND teamId = 2358
0.0021  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 = '2358' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2358' and rp.type = 4
0.0021  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 = '2358' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 2358 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.0020  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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 2358 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 73549 WHERE rp.league_id = 73549 AND rp.teamId = 2358 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 2358 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 73549 AND t.round = 31 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 68809 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 63865 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.0022  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 = 66949 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 58582 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.0024  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.0024  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 `tables2019` 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 = 44392 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 39028 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 33354 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 16700 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 4069 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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.0023  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 = 1455 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 1134 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 289 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2002` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 22049 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0199  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.0025  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.0025  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.0025  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