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

Atlas Guadalajara

Entrenador: Beñat San José

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 América América 17 30 12 35
2 Cruz Azul Cruz Azul 17 23 14 33
3 Toluca Toluca 17 38 23 32
4 Monterrey Monterrey 17 32 19 32
5 Tigres UANL Tigres UANL 17 34 23 31
6 Chivas Guadalajara Chivas 17 24 17 31
7 Pachuca Pachuca 17 34 27 29
8 Pumas UNAM Pumas UNAM 17 27 22 27
9 Necaxa Necaxa 17 30 29 27
10 Querétaro Querétaro 17 22 21 24
11 León León 17 23 25 24
12 FC Juárez FC Juárez 17 19 26 16
13 Atl. San Luis Atl. Luis 17 25 35 16
14 Mazatlán Mazatlán 17 21 32 16
15 Santos Laguna Santos 17 15 28 15
16 Tijuana Tijuana 17 21 30 14
17 Atlas Guadalajara Atlas 17 21 31 14
18 Puebla Puebla 17 18 43 5
TEMPORADA 2022/2023
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Monterrey Monterrey 17 35 14 40
2 América América 17 36 21 34
3 Chivas Guadalajara Chivas 17 28 18 34
4 Toluca Toluca 17 34 19 32
5 Pachuca Pachuca 17 32 24 31
6 León León 17 23 13 30
7 Tigres UANL Tigres UANL 17 20 17 25
8 Cruz Azul Cruz Azul 17 21 22 24
9 Atlas Guadalajara Atlas 17 27 22 21
10 Querétaro Querétaro 17 16 21 20
11 Puebla Puebla 17 26 32 20
12 Atl. San Luis Atl. Luis 17 16 21 19
13 Santos Laguna Santos 17 23 37 19
14 Pumas UNAM Pumas UNAM 17 24 32 18
15 Tijuana Tijuana 17 19 29 16
16 FC Juárez FC Juárez 17 17 25 15
17 Necaxa Necaxa 17 16 24 14
18 Mazatlán Mazatlán 17 19 41 7
TEMPORADA 2021/2022
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Pachuca Pachuca 17 30 15 38
2 Tigres UANL Tigres UANL 17 30 20 33
3 Atlas Guadalajara Atlas 17 21 15 27
4 América América 17 24 17 26
5 Puebla Puebla 17 25 19 26
6 Chivas Guadalajara Chivas 17 25 21 26
7 Monterrey Monterrey 17 21 17 26
8 Cruz Azul Cruz Azul 17 20 17 25
9 Necaxa Necaxa 17 21 21 23
10 Atl. San Luis Atl. Luis 17 21 22 23
11 Pumas UNAM Pumas UNAM 17 24 21 22
12 Mazatlán Mazatlán 17 20 24 21
13 León León 17 17 22 21
14 Santos Laguna Santos 17 25 25 20
15 Toluca Toluca 17 21 36 19
16 Querétaro Querétaro 17 18 21 17
17 Tijuana Tijuana 17 14 26 17
18 FC Juárez FC Juárez 17 10 28 11
TEMPORADA 2020/2021
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 17 26 11 41
2 América América 17 26 14 38
3 Puebla Puebla 17 25 14 28
4 Monterrey Monterrey 17 22 13 28
5 Santos Laguna Santos 17 18 13 26
6 León León 17 25 23 26
7 Atlas Guadalajara Atlas 17 20 15 25
8 Pachuca Pachuca 17 20 19 23
9 Chivas Guadalajara Chivas 17 21 21 23
10 Tigres UANL Tigres UANL 17 19 20 23
11 Toluca Toluca 17 26 24 22
12 Querétaro Querétaro 17 19 25 21
13 Mazatlán Mazatlán 17 19 26 21
14 Tijuana Tijuana 17 19 21 20
15 Pumas UNAM Pumas UNAM 17 10 12 18
16 FC Juárez FC Juárez 17 13 29 15
17 Atl. San Luis Atl. Luis 17 20 33 12
18 Necaxa Necaxa 17 14 29 11
TEMPORADA 2019/2020
LIGA MX - APERTURA
Equipo PJ GF GC Puntos
1 Santos Laguna Santos 18 40 25 37
2 León León 18 38 23 33
3 Tigres UANL Tigres UANL 18 26 14 32
4 Querétaro Querétaro 18 31 19 31
5 Necaxa Necaxa 18 33 23 31
6 América América 18 32 22 31
7 CA Morelia CA Morelia 18 31 26 27
8 Monterrey Monterrey 18 27 23 27
9 Pachuca Pachuca 18 32 26 25
10 Chivas Guadalajara Chivas 18 28 28 25
11 Tijuana Tijuana 18 26 36 24
12 Cruz Azul Cruz Azul 18 25 24 23
13 Pumas UNAM Pumas UNAM 18 21 20 23
14 Atlas Guadalajara Atlas 18 19 26 21
15 Atl. San Luis Atl. Luis 18 22 31 20
16 FC Juárez FC Juárez 18 17 27 18
17 Toluca Toluca 18 16 26 17
18 Puebla Puebla 18 20 31 17
19 Veracruz Veracruz 18 11 45 8
TEMPORADA 2018/2019
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 León León 17 41 14 41
2 Tigres UANL Tigres UANL 17 33 16 37
3 Monterrey Monterrey 17 33 21 30
4 Cruz Azul Cruz Azul 17 26 15 30
5 América América 17 28 19 29
6 Necaxa Necaxa 17 32 24 29
7 Pachuca Pachuca 17 32 26 28
8 Tijuana Tijuana 17 25 20 28
9 Toluca Toluca 17 28 23 25
10 Puebla Puebla 17 18 21 24
11 Santos Laguna Santos 17 21 23 22
12 Lobos BUAP Lobos BUAP 17 17 34 20
13 Atlas Guadalajara Atlas 17 19 28 19
14 Chivas Guadalajara Chivas 17 16 21 18
15 Pumas UNAM Pumas UNAM 17 19 26 17
16 CA Morelia CA Morelia 17 20 31 13
17 Querétaro Querétaro 17 11 30 11
18 Veracruz Veracruz 17 7 34 0
TEMPORADA 2017/2018
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Toluca Toluca 17 24 13 36
2 América América 17 24 14 29
3 Monterrey Monterrey 17 30 21 29
4 Santos Laguna Santos 17 29 20 29
5 Tigres UANL Tigres UANL 17 23 16 28
6 Tijuana Tijuana 17 18 12 25
7 Pumas UNAM Pumas UNAM 17 24 24 24
8 CA Morelia CA Morelia 17 22 24 24
9 Pachuca Pachuca 17 29 27 23
10 Puebla Puebla 17 23 24 23
11 Necaxa Necaxa 17 21 15 22
12 Cruz Azul Cruz Azul 17 22 18 22
13 León León 17 24 33 22
14 Querétaro Querétaro 17 13 18 18
15 Atlas Guadalajara Atlas 17 17 26 18
16 Veracruz Veracruz 17 12 25 18
17 Chivas Guadalajara Chivas 17 14 24 15
18 Lobos BUAP Lobos BUAP 17 18 33 9
TEMPORADA 2016/2017
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Tijuana Tijuana 17 30 22 31
2 Monterrey Monterrey 17 26 18 27
3 Chivas Guadalajara Chivas 17 21 18 27
4 Toluca Toluca 17 21 20 27
5 Santos Laguna Santos 17 25 20 26
6 Atlas Guadalajara Atlas 17 24 20 26
7 Tigres UANL Tigres UANL 17 26 12 25
8 CA Morelia CA Morelia 17 19 16 24
9 América América 17 19 19 24
10 Pachuca Pachuca 17 16 16 24
11 Cruz Azul Cruz Azul 17 19 20 21
12 Necaxa Necaxa 17 16 21 21
13 Veracruz Veracruz 17 14 20 21
14 León León 17 21 23 20
15 Querétaro Querétaro 17 21 27 19
16 Chiapas Chiapas 17 18 28 19
17 Pumas UNAM Pumas UNAM 17 21 30 18
18 Puebla Puebla 17 18 25 16
TEMPORADA 2015/2016
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Monterrey Monterrey 17 38 23 37
2 Pachuca Pachuca 17 31 16 30
3 León León 17 29 19 30
4 América América 17 34 22 29
5 Chivas Guadalajara Chivas 17 26 16 28
6 CA Morelia CA Morelia 17 25 24 28
7 Santos Laguna Santos 17 22 20 27
8 Tigres UANL Tigres UANL 17 29 19 24
9 Cruz Azul Cruz Azul 17 25 24 22
10 Pumas UNAM Pumas UNAM 17 23 24 22
11 Toluca Toluca 17 20 21 22
12 Puebla Puebla 17 21 26 22
13 Querétaro Querétaro 17 21 26 19
14 Tijuana Tijuana 17 17 26 18
15 Atlas Guadalajara Atlas 17 18 26 14
16 Dorados Dorados 17 18 32 14
17 Veracruz Veracruz 17 18 34 14
18 Chiapas Chiapas 17 16 33 12
TEMPORADA 2014/2015
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Tigres UANL Tigres UANL 17 23 15 29
2 América América 17 21 18 29
3 Veracruz Veracruz 17 28 18 28
4 Atlas Guadalajara Atlas 17 20 21 28
5 Chivas Guadalajara Chivas 17 20 16 26
6 Querétaro Querétaro 17 25 23 26
7 Pachuca Pachuca 17 25 21 25
8 Santos Laguna Santos 17 24 21 25
9 Cruz Azul Cruz Azul 17 14 14 25
10 Toluca Toluca 17 20 18 24
11 Tijuana Tijuana 17 30 30 24
12 Monterrey Monterrey 17 24 27 24
13 Pumas UNAM Pumas UNAM 17 22 27 22
14 Puebla Puebla 17 21 20 20
15 Chiapas Chiapas 17 21 30 20
16 Leones Negros Leones 17 13 19 18
17 León León 17 27 32 16
18 CA Morelia CA Morelia 17 17 25 13

  USO DE MEMORIA  
6,778,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5876
Total Execution Time  0.5888
  CADENA URL  
/historico/Fc-Atlas-Guadalajara
  GET DATOS  
$_GET['/historico/Fc-Atlas-Guadalajara']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0124  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 = 'Fc-Atlas-Guadalajara' 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.0106  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=731 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=731 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=731 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=731 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=731 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  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 = 75359
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=731 AND type_rel = 2
0.0113  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 731 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (5580,20221,22024,25960,27061) ORDER BY n.cover_points DESC, update_date DESC
0.0115  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 = '731' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0117  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 = '731' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 75359 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0117  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=731 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (75359,74881,71994,71572,71432,70474) 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.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 71994 AND teamId = 731
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 74881 AND teamId = 731
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 71572 AND teamId = 731
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 70474 AND teamId = 731
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 75359 AND teamId = 731
0.0194  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 731
0.0119  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 = 71994 WHERE rp.league_id = 71994 AND rp.teamId = 731 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.0117  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 = 71994 WHERE rp.league_id = 71994 AND rp.teamId = 731 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 71994 WHERE rp.league_id = 71994 AND rp.teamId = 731 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0119  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 = 731 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109  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 = 71994 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 74881 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 70544 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 63173 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 66176 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 56984 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 60360 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 51325 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 49953 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 43804 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 48493 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 38666 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 41853 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 33338 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 37583 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 15261 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 20080 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 3802 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 9007 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC