4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1946/1947
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Valencia Valencia 26 54 34 34
2 Athletic Athletic 26 72 38 34
3 Atlético Atlético 26 58 44 32
4 Barcelona Barcelona 26 59 42 31
5 CE Sabadell CE Sabadell 26 42 36 30
6 Sevilla Sevilla 26 54 48 29
7 Real Madrid Real Madrid 26 62 56 27
8 Real Oviedo Real Oviedo 26 52 42 27
9 Celta Celta 26 53 48 26
10 Real Sporting Real 26 51 59 25
11 Espanyol Espanyol 26 46 59 19
12 Real Murcia Real Murcia 26 30 58 19
13 RC Deportivo Deportivo 26 32 60 18
14 CD Castellón Castellón 26 39 80 13
TEMPORADA 1945/1946
PRIMERA DIVISIÓN
Equipo PJ GF GC Puntos
1 Sevilla Sevilla 26 53 37 36
2 Barcelona Barcelona 26 48 31 35
3 Athletic Athletic 26 63 38 33
4 Real Madrid Real Madrid 26 46 30 31
5 Real Oviedo Real Oviedo 26 44 37 30
6 Valencia Valencia 26 44 36 28
7 Atlético Atlético 26 50 48 26
8 CD Castellón Castellón 26 38 54 26
9 Real Sporting Real 26 37 39 25
10 Celta Celta 26 57 56 21
11 Real Murcia Real Murcia 26 21 39 20
12 Espanyol Espanyol 26 41 53 19
13 Alcoyano Alcoyano 26 39 54 19
14 Hércules Hércules 26 30 59 15
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,902,920 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1773
Total Execution Time  0.1790
  CADENA URL  
/historico/Atletico-Madrid/1947
  GET DATOS  
$_GET['/historico/Atletico-Madrid/1947']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0068  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 = 1947 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.0020  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.0019  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.0019  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.0027  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 = 22155
0.0027  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.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 (1312856,1312887,1312797,1001167,1312778) ORDER BY n.cover_points DESC, update_date DESC
0.0098  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' ORDER BY l.year DESC,cat.coefficient DESC
0.0062  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 = 1947 ORDER BY l.year DESC,cat.coefficient DESC
0.0076  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.0038  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 = 22155 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0036  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 = 5372 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0071  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 (1946,1947,1948) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (22156,5373) 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.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 5373 AND teamId = 369
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 22156 AND teamId = 369
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1947` 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 = 5372 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032  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 events1947 e ON e.player_id = p.id AND e.league_id = 5372 WHERE rp.league_id = 5372 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.0033  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 events1947 e ON e.player_id = p.id AND e.league_id = 5372 WHERE rp.league_id = 5372 AND rp.teamId = 369 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events1947 e ON e.player_id = p.id AND e.league_id = 5372 WHERE rp.league_id = 5372 AND rp.teamId = 369 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0056  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 <= 1947 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1946` 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 = 5371 AND t.round = 26 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 `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.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 `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.0029  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.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 `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.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 `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.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 `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.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 `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.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 `tables1935` 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 = 5360 AND t.round = 22 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 `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.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 `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.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 `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.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 `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.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 `tables1930` 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 = 5355 AND t.round = 18 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 `tables1929` 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 = 5354 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 5372 ORDER BY nameShow LIMIT 100