4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1944/1945
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 26 50 30 39
2 Real Madrid Real Madrid 26 68 35 38
3 Atlético Atlético 26 46 41 31
4 Real Oviedo Real Oviedo 26 50 48 31
5 Valencia Valencia 26 61 35 30
6 Athletic Athletic 26 54 41 30
7 Real Sporting Real 26 42 46 24
8 CD Castellón Castellón 26 43 50 24
9 Espanyol Espanyol 26 44 39 23
10 Sevilla Sevilla 26 52 49 22
11 Real Murcia Real Murcia 26 40 58 19
12 Granada Granada 26 40 55 19
13 CE Sabadell CE Sabadell 26 30 67 17
14 RC Deportivo Deportivo 26 36 62 17
TEMPORADA 1943/1944
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Valencia Valencia 26 73 32 40
2 Atlético Atlético 26 66 49 34
3 Sevilla Sevilla 26 60 46 32
4 Real Oviedo Real Oviedo 26 71 47 29
5 CD Castellón Castellón 26 42 36 29
6 Barcelona Barcelona 26 59 46 28
7 Real Madrid Real Madrid 26 48 38 28
8 Granada Granada 26 41 46 26
9 CE Sabadell CE Sabadell 26 53 60 25
10 Athletic Athletic 26 47 51 25
11 Espanyol Espanyol 26 42 50 23
12 RC Deportivo Deportivo 26 35 64 19
13 Real Sociedad Real 26 34 54 17
14 Celta Celta 26 23 75 9
TEMPORADA 1942/1943
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Athletic Athletic 26 73 38 36
2 Sevilla Sevilla 26 63 47 33
3 Barcelona Barcelona 26 77 50 32
4 CD Castellón Castellón 26 41 43 31
5 Celta Celta 26 52 50 30
6 Real Oviedo Real Oviedo 26 53 63 28
7 Valencia Valencia 26 58 45 27
8 Atlético Atlético 26 54 44 27
9 RC Deportivo Deportivo 26 35 32 26
10 Real Madrid Real Madrid 26 52 50 25
11 Espanyol Espanyol 26 45 51 24
12 Granada Granada 26 56 68 22
13 Real Zaragoza Real 26 25 57 13
14 Real Betis Real Betis 26 28 74 10
TEMPORADA 1941/1942
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Valencia Valencia 26 85 39 40
2 Real Madrid Real Madrid 26 65 43 33
3 Atlético Atlético 26 50 44 33
4 RC Deportivo Deportivo 26 36 37 28
5 Celta Celta 26 53 58 28
6 Sevilla Sevilla 26 58 45 27
7 Athletic Athletic 26 55 41 27
8 CD Castellón Castellón 26 54 63 26
9 Espanyol Espanyol 26 49 42 26
10 Granada Granada 26 64 52 25
11 Real Oviedo Real Oviedo 26 42 63 23
12 Barcelona Barcelona 26 57 66 19
13 Hércules Hércules 26 42 71 17
14 Real Sociedad Real 26 31 77 12
TEMPORADA 1940/1941
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 22 70 36 33
2 Athletic Athletic 22 49 24 31
3 Valencia Valencia 22 60 52 27
4 Barcelona Barcelona 22 55 45 27
5 Sevilla Sevilla 22 70 43 26
6 Real Madrid Real Madrid 22 51 38 24
7 Espanyol Espanyol 22 50 54 22
8 Real Oviedo Real Oviedo 22 36 63 16
9 Hércules Hércules 22 28 67 16
10 Celta Celta 22 45 51 15
11 Real Zaragoza Real 22 26 41 14
12 Real Murcia Real Murcia 22 29 55 13
TEMPORADA 1939/1940
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Atlético Atlético 22 43 29 29
2 Sevilla Sevilla 22 60 44 28
3 Athletic Athletic 22 57 44 26
4 Real Madrid Real Madrid 22 47 35 25
5 Espanyol Espanyol 22 43 43 24
6 Hércules Hércules 22 41 34 23
7 Real Zaragoza Real 22 30 40 21
8 Valencia Valencia 22 40 36 21
9 Barcelona Barcelona 22 32 38 19
10 Celta Celta 22 45 50 19
11 Real Betis Real Betis 22 26 51 16
12 Racing Racing 22 37 57 13
TEMPORADA 1935/1936
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Athletic Athletic 22 59 33 31
2 Real Madrid Real Madrid 22 62 35 29
3 Real Oviedo Real Oviedo 22 63 47 28
4 Racing Racing 22 58 46 27
5 Barcelona Barcelona 22 39 32 24
6 Hércules Hércules 22 37 41 24
7 Real Betis Real Betis 22 31 46 20
8 Valencia Valencia 22 36 42 19
9 Espanyol Espanyol 22 36 53 17
10 Sevilla Sevilla 22 27 48 16
11 Atlético Atlético 22 34 50 15
12 Osasuna Osasuna 22 46 55 14
TEMPORADA 1934/1935
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 22 43 19 34
2 Real Madrid Real Madrid 22 61 34 33
3 Real Oviedo Real Oviedo 22 60 47 26
4 Athletic Athletic 22 60 37 25
5 Sevilla Sevilla 22 53 38 24
6 Barcelona Barcelona 22 55 44 24
7 Atlético Atlético 22 40 45 21
8 Espanyol Espanyol 22 47 59 20
9 Valencia Valencia 22 40 49 20
10 Racing Racing 22 37 46 17
11 Real Sociedad Real 22 28 67 11
12 Arenas de Getxo Arenas Getxo 22 17 56 9
TEMPORADA 1933/1934
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Sevilla Sevilla 18 57 27 27
2 Atlético Atlético 18 45 28 24
3 Real Murcia Real Murcia 18 41 31 21
4 Celta Celta 18 44 28 20
5 Osasuna Osasuna 18 47 39 18
6 Real Sporting Real 18 30 38 18
7 RC Deportivo Deportivo 18 35 38 17
8 Real Unión Club Real Unión 18 31 43 16
9 CE Sabadell CE Sabadell 18 31 45 14
10 Deportivo Alavés Deportivo 18 18 62 5
TEMPORADA 1932/1933
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Oviedo Real Oviedo 18 58 26 27
2 Atlético Atlético 18 40 35 24
3 Real Murcia Real Murcia 18 33 41 20
4 Real Unión Club Real Unión 18 51 36 20
5 RC Deportivo Deportivo 18 39 38 20
6 Real Sporting Real 18 50 40 18
7 Celta Celta 18 37 38 17
8 Osasuna Osasuna 18 46 47 17
9 Sevilla Sevilla 18 29 38 13
10 Castellón Castellón 18 14 58 4
TEMPORADA 1931/1932
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Real Betis Real Betis 18 40 30 25
2 Real Oviedo Real Oviedo 18 48 26 23
3 Real Sporting Real 18 33 26 22
4 Real Murcia Real Murcia 18 39 32 21
5 RC Deportivo Deportivo 18 33 37 19
6 Atlético Atlético 18 39 37 18
7 Castellón Castellón 17 26 32 17
8 Sevilla Sevilla 17 27 31 13
9 Celta Celta 17 30 47 11
10 CE Europa CE Europa 15 13 30 5
TEMPORADA 1930/1931
SEGUNDA DIVISIÓN
Equipo PJ GF GC Puntos
1 Valencia Valencia 18 37 25 26
2 Sevilla Sevilla 18 42 26 23
3 Atlético Atlético 18 47 31 23
4 Real Sporting Real 18 48 32 18
5 Castellón Castellón 18 27 31 18
6 Real Betis Real Betis 18 25 36 17
7 Real Murcia Real Murcia 18 29 46 14
8 Real Oviedo Real Oviedo 18 39 41 14
9 RC Deportivo Deportivo 18 32 43 14
10 Iberia SC Iberia SC 18 23 38 13
TEMPORADA 1929/1930
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Athletic Athletic 18 63 28 30
2 Barcelona Barcelona 18 46 36 23
3 Arenas de Getxo Arenas Getxo 18 51 40 20
4 Espanyol Espanyol 18 40 33 20
5 Real Madrid Real Madrid 18 45 42 17
6 Real Unión Club Real Unión 18 48 52 17
7 Real Sociedad Real 18 34 37 14
8 Racing Racing 18 32 58 14
9 CE Europa CE Europa 18 29 44 13
10 Atlético Atlético 18 32 50 12
TEMPORADA 1928/1929
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Barcelona Barcelona 18 37 23 25
2 Real Madrid Real Madrid 18 40 27 23
3 Athletic Athletic 18 43 33 20
4 Real Sociedad Real 18 46 41 20
5 Arenas de Getxo Arenas Getxo 18 32 39 19
6 Atlético Atlético 18 43 41 18
7 Espanyol Espanyol 18 32 38 18
8 CE Europa CE Europa 18 45 49 16
9 Real Unión Club Real Unión 18 40 42 12
10 Racing Racing 18 25 50 9

  USO DE MEMORIA  
6,676,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7236
Total Execution Time  0.7247
  CADENA URL  
/historico/Atletico-Madrid/1945
  GET DATOS  
$_GET['/historico/Atletico-Madrid/1945']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0210  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 = 'Atletico-Madrid' AND l.year = 1945 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.0147  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=369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=369 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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 = 5370
0.0150  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 = 22157
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=369 AND type_rel = 2
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 369 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148  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 (1312856,1312900,1312887,1312797,1001167) ORDER BY n.cover_points DESC, update_date DESC
0.0152  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 = '369' AND l.year = 1945 ORDER BY l.year DESC,cat.coefficient DESC
0.0298  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 = '369' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0159  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 = 22157 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 5370 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0175  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=369 AND l.year in (1944,1945,1946) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (22158,5371) 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.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 5371 AND teamId = 369
0.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 22158 AND teamId = 369
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 FROM `tables1945` 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 = 5370 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0167  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 = '369' 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 = '369' and rp.type = 4
0.0157  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 = '369' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '369' and rp.type = 4
0.0156  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 events1945 e ON e.player_id = p.id AND e.league_id = 5370 WHERE rp.league_id = 5370 AND rp.teamId = 369 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.0155  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 events1945 e ON e.player_id = p.id AND e.league_id = 5370 WHERE rp.league_id = 5370 AND rp.teamId = 369 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160  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 events1945 e ON e.player_id = p.id AND e.league_id = 5370 WHERE rp.league_id = 5370 AND rp.teamId = 369 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0269  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 = 369 AND l.year <= 1945 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,team.teamId FROM `tables1945` 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 = 5370 AND t.round = 26 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 `tables1944` 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 = 5369 AND t.round = 26 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 `tables1943` 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 = 5368 AND t.round = 26 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 `tables1942` 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 = 5367 AND t.round = 26 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 `tables1941` 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 = 5366 AND t.round = 22 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 `tables1940` 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 = 5365 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1936` 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 = 5361 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1934` 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 = 10382 AND t.round = 18 ORDER BY team.conference 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 `tables1933` 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 = 10383 AND t.round = 18 ORDER BY team.conference 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 `tables1932` 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 = 10384 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables1931` 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 = 10387 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 5370 ORDER BY nameShow LIMIT 100