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

Leioa

Entrenador: Jon Castrillo

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 CD Vitoria CD Vitoria 31 60 15 75
2 Portugalete Portugalete 31 50 27 59
3 Beasain KE Beasain KE 31 50 31 58
4 CD Basconia CD Basconia 31 47 29 55
5 CD Lagun Onak Lagun Onak 31 36 27 52
6 Deusto Deusto 31 42 29 52
7 SCD Durango SCD Durango 31 39 40 46
8 San Ignacio San Ignacio 31 43 35 45
9 Urduliz FT Urduliz FT 31 36 39 42
10 Leioa Leioa 31 40 44 41
11 CD Derio CD Derio 31 31 31 38
12 CD Padura CD Padura 31 31 42 38
13 Deportivo Alavés C Deportivo 31 29 39 35
14 CD Touring CD Touring 31 34 44 33
15 Anaitasuna FT Anaitasuna 31 30 44 29
16 Pasaia KE Pasaia KE 31 16 38 27
17 Aurrera KE Aurrera KE 31 20 48 21
18 Añorga Añorga 31 25 57 15
TEMPORADA 2022/2023
TERCERA FEDERACIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Barakaldo Barakaldo 30 67 11 76
2 CD Vitoria CD Vitoria 30 49 18 58
3 Leioa Leioa 30 49 36 56
4 CD Basconia CD Basconia 30 59 37 54
5 Deusto Deusto 30 38 26 47
6 Portugalete Portugalete 30 32 32 41
7 Pasaia KE Pasaia KE 30 36 53 38
8 SCD Durango SCD Durango 30 40 41 37
9 Aurrera KE Aurrera KE 30 29 37 37
10 Anaitasuna FT Anaitasuna 30 36 36 37
11 Urduliz FT Urduliz FT 30 31 38 33
12 CD Lagun Onak Lagun Onak 30 25 29 33
13 CD Padura CD Padura 30 28 39 32
14 CD Touring CD Touring 30 34 52 32
15 San Ignacio San Ignacio 30 30 53 26
16 CD Aurrera Vitoria Aurrera 30 17 62 12
TEMPORADA 2021/2022
TERCERA FEDERACIÓN GRUPO 4
Equipo PJ GF GC Puntos
1 Deportivo Alavés B Deportivo 38 72 31 76
2 Beasain KE Beasain KE 38 65 36 70
3 Portugalete Portugalete 38 60 33 70
4 Barakaldo Barakaldo 38 64 46 69
5 CD Basconia CD Basconia 38 45 32 65
6 CD Vitoria CD Vitoria 38 55 49 59
7 San Ignacio San Ignacio 38 57 48 58
8 SCD Durango SCD Durango 38 42 29 57
9 Leioa Leioa 38 55 38 56
10 Anaitasuna FT Anaitasuna 38 48 49 52
11 CD Lagun Onak Lagun Onak 38 42 44 51
12 Pasaia KE Pasaia KE 38 36 43 50
13 Deusto Deusto 38 42 40 49
14 Urduliz FT Urduliz FT 38 39 57 45
15 Aurrera KE Aurrera KE 38 36 55 38
16 Santutxu Santutxu 38 42 60 38
17 Uritarra CD Uritarra CD 38 38 52 38
18 Amurrio Amurrio 38 39 45 37
19 Beti Gazte KKE Beti Gazte 38 34 80 26
20 Tolosa CF Tolosa CF 38 43 87 26
TEMPORADA 2020/2021
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Real Sociedad B Real 20 35 16 40
2 Bilbao Ath. Bilbao Ath. 20 34 19 39
3 SD Amorebieta Amorebieta 20 26 19 37
4 Racing Racing 20 30 17 35
5 Real Unión Club Real Unión 20 26 18 33
6 Arenas de Getxo Arenas Getxo 20 15 15 26
7 CD Laredo CD Laredo 20 17 27 24
8 Portugalete Portugalete 20 16 19 22
9 Deportivo Alavés B Deportivo 20 22 31 20
10 Barakaldo Barakaldo 20 19 39 17
11 Leioa Leioa 20 12 32 10
12 Tudelano Tudelano 18 29 14 34
13 CD Calahorra Calahorra 18 17 6 34
14 SD Logroñés Logroñés 18 20 14 29
15 CD Ebro CD Ebro 18 15 17 28
16 Osasuna Promesas Osasuna 18 21 22 24
17 SD Tarazona SD Tarazona 18 16 22 24
18 Mutilvera Mutilvera 18 23 18 23
19 Ejea Ejea 18 12 19 18
20 Izarra Izarra 18 14 25 15
21 Haro Deportivo Haro 18 14 24 12
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 UD Logroñés Logroñés 28 49 19 62
2 Cultural Leonesa Cultural 28 45 28 49
3 Bilbao Ath. Bilbao Ath. 28 55 35 49
4 Real Valladolid Promesas Real 28 43 28 47
5 Real Sociedad B Real 28 47 35 44
6 SD Amorebieta Amorebieta 28 38 38 42
7 Osasuna Promesas Osasuna 28 35 35 40
8 Burgos Burgos 28 31 37 39
9 Guijuelo Guijuelo 28 30 26 37
10 Haro Deportivo Haro 28 29 33 36
11 Deportivo Alavés B Deportivo 28 28 31 34
12 CD Calahorra Calahorra 28 28 32 34
13 Salamanca UDS Salamanca 28 30 39 34
14 Barakaldo Barakaldo 28 33 42 32
15 Leioa Leioa 28 35 38 31
16 Unionistas CF Unionistas 28 39 43 31
17 Real Unión Club Real Unión 28 29 33 29
18 Arenas de Getxo Arenas Getxo 28 27 43 28
19 Izarra Izarra 28 29 47 28
20 Tudelano Tudelano 28 26 44 24
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
SEGUNDA DIVISIÓN B GRUPO 2
Equipo PJ GF GC Puntos
1 Huesca Huesca 38 61 30 69
2 Bilbao Ath. Bilbao Ath. 38 65 30 66
3 CD Guadalajara Guadalajara 38 49 43 61
4 Real Unión Club Real Unión 38 48 38 60
5 Tudelano Tudelano 38 42 31 58
6 RM Castilla RM Castilla 38 59 40 58
7 Barakaldo Barakaldo 38 50 43 58
8 UD Yugo Socuéllamos Yugo 38 45 45 58
9 CD Toledo CD Toledo 38 47 54 57
10 SD Amorebieta Amorebieta 38 59 54 52
11 Fuenlabrada Fuenlabrada 38 43 54 51
12 Getafe B Getafe B 38 50 51 51
13 Sestao River Sestao River 38 46 51 50
14 Real Sociedad B Real 38 51 56 48
15 Leioa Leioa 38 42 60 48
16 Las Palmas At. Palmas 38 58 60 47
17 Rayo Vallecano B Rayo 38 43 60 43
18 Atlético B Atlético B 38 52 62 41
19 Trival Valderas Trival 38 42 71 37
20 UB Conquense Conquense 38 48 67 30
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

  USO DE MEMORIA  
7,673,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1466
Total Execution Time  0.1486
  CADENA URL  
/historico/Leioa
  GET DATOS  
$_GET['/historico/Leioa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0039  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 = 73357
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1539 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1539 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0029  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 (997,2599,2827,28120,30916) 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 = '1539' 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 = '1539' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 73357 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=1539 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (73357,72263,71489,71432) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72263 AND teamId = 1539
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71489 AND teamId = 1539
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 73357 AND teamId = 1539
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1539
0.0037  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 = 72263 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '1539' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1539' and rp.type = 4
0.0020  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 = '1539' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 = 72263 WHERE rp.league_id = 72263 AND rp.teamId = 1539 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.0039  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 = 72263 WHERE rp.league_id = 72263 AND rp.teamId = 1539 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 72263 WHERE rp.league_id = 72263 AND rp.teamId = 1539 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 1539 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 67978 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 62388 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.0027  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 = 50266 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.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 `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 = 44096 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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.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 `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.0028  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.0027  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.0031  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.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 `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.0028  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.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 = 134 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC