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

CA Morelia

Entrenador: Mario García

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA DE EXPANSIÓN MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Venados FC Venados FC 14 25 10 32
2 Leones Negros Leones 14 23 10 29
3 Atlante FC Atlante FC 14 19 8 25
4 CD Tapatío CD Tapatío 14 22 13 22
5 Celaya Celaya 14 21 15 22
6 Cancún Cancún 14 21 16 22
7 CA La Paz CA La Paz 14 21 19 22
8 Mineros de Zacatecas Mineros 14 20 19 19
9 Alebrijes de Oaxaca Alebrijes 14 18 22 19
10 Cimarrones de Sonora Cimarrones 14 19 18 17
11 Correcaminos UAT Correcaminos 14 15 23 16
12 Tlaxcala FC Tlaxcala FC 14 11 23 13
13 Dorados Dorados 14 16 27 11
14 CA Morelia CA Morelia 14 16 23 10
15 Tepatitlán FC Tepatitlán 14 9 30 8
TEMPORADA 2022/2023
LIGA DE EXPANSIÓN MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Celaya Celaya 17 29 17 37
2 CD Tapatío CD Tapatío 17 30 19 31
3 Atlante FC Atlante FC 17 22 13 30
4 CA Morelia CA Morelia 17 20 14 30
5 Tepatitlán FC Tepatitlán 17 21 12 25
6 Cimarrones de Sonora Cimarrones 17 17 11 25
7 Raya2 Expansión Raya2 17 19 21 24
8 Tlaxcala FC Tlaxcala FC 17 15 18 23
9 Venados FC Venados FC 17 20 16 22
10 Alebrijes de Oaxaca Alebrijes 17 25 25 22
11 Pumas Tabasco Pumas 17 21 22 22
12 Correcaminos UAT Correcaminos 17 18 20 22
13 Leones Negros Leones 17 26 23 21
14 CA La Paz CA La Paz 17 25 29 21
15 Cancún Cancún 17 19 21 19
16 Durango Durango 17 19 29 18
17 Mineros de Zacatecas Mineros 17 22 34 17
18 Dorados Dorados 17 11 35 9
TEMPORADA 2021/2022
LIGA DE EXPANSIÓN MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Alebrijes de Oaxaca Alebrijes 16 21 13 34
2 Leones Negros Leones 16 21 16 33
3 Celaya Celaya 16 23 15 30
4 CA Morelia CA Morelia 16 24 19 27
5 Mineros de Zacatecas Mineros 16 23 18 27
6 Cancún Cancún 16 15 17 26
7 Atlante FC Atlante FC 16 15 15 25
8 Cimarrones de Sonora Cimarrones 16 20 14 24
9 CD Tapatío CD Tapatío 16 14 16 24
10 Venados FC Venados FC 16 17 16 23
11 Tepatitlán FC Tepatitlán 16 17 17 23
12 Tlaxcala FC Tlaxcala FC 16 18 19 23
13 Dorados Dorados 16 16 24 22
14 Correcaminos UAT Correcaminos 16 18 21 19
15 Raya2 Expansión Raya2 16 14 17 18
16 Pumas Tabasco Pumas 16 13 25 12
17 Tampico Madero Tampico 16 14 21 11
TEMPORADA 2020/2021
LIGA DE EXPANSIÓN MX - CLAUSURA
Equipo PJ GF GC Puntos
1 CA Morelia CA Morelia 15 26 19 33
2 Celaya Celaya 15 19 11 28
3 Cimarrones de Sonora Cimarrones 15 20 11 27
4 Mineros de Zacatecas Mineros 15 21 21 27
5 CD Tapatío CD Tapatío 15 14 14 24
6 Tepatitlán FC Tepatitlán 15 13 19 24
7 Atlante FC Atlante FC 15 18 12 23
8 Cancún Cancún 15 15 17 21
9 Dorados Dorados 15 15 16 20
10 Tlaxcala FC Tlaxcala FC 15 15 17 20
11 Alebrijes de Oaxaca Alebrijes 15 24 24 19
12 Venados FC Venados FC 15 15 16 18
13 Pumas Tabasco Pumas 15 14 19 18
14 Tampico Madero Tampico 15 11 12 16
15 Correcaminos UAT Correcaminos 15 16 20 14
16 Leones Negros Leones 15 11 19 12
TEMPORADA 2019/2020
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 10 24 14 22
2 León León 10 23 14 21
3 Santos Laguna Santos 10 14 14 17
4 América América 10 11 11 17
5 Chivas Guadalajara Chivas 10 13 11 16
6 Pumas UNAM Pumas UNAM 10 20 19 15
7 Tigres UANL Tigres UANL 10 13 10 14
8 FC Juárez FC Juárez 10 20 18 14
9 CA Morelia CA Morelia 10 17 16 14
10 Puebla Puebla 10 7 7 14
11 Pachuca Pachuca 10 11 12 14
12 Querétaro Querétaro 10 13 15 14
13 Atl. San Luis Atl. Luis 10 11 15 13
14 Necaxa Necaxa 10 17 16 11
15 Toluca Toluca 10 16 18 10
16 Tijuana Tijuana 10 10 16 9
17 Atlas Guadalajara Atlas 10 10 17 9
18 Monterrey Monterrey 10 10 17 5
TEMPORADA 2018/2019
LIGA MX - APERTURA
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 17 26 13 36
2 América América 17 33 17 33
3 Pumas UNAM Pumas UNAM 17 29 19 30
4 Santos Laguna Santos 17 27 18 30
5 Monterrey Monterrey 17 25 19 30
6 Tigres UANL Tigres UANL 17 32 18 29
7 Toluca Toluca 17 27 22 26
8 Querétaro Querétaro 17 19 20 26
9 CA Morelia CA Morelia 17 23 26 25
10 Pachuca Pachuca 17 26 18 24
11 Chivas Guadalajara Chivas 17 21 22 20
12 Puebla Puebla 17 23 30 20
13 Lobos BUAP Lobos BUAP 17 21 25 19
14 León León 17 18 23 18
15 Tijuana Tijuana 17 13 24 17
16 Necaxa Necaxa 17 19 29 14
17 Atlas Guadalajara Atlas 17 11 27 11
18 Veracruz Veracruz 17 17 40 8
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,494,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1599
Total Execution Time  0.1613
  CADENA URL  
/historico/Morelia
  GET DATOS  
$_GET['/historico/Morelia']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0041  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 = 'Morelia' 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.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=10273 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=10273 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=10273 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=10273 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=10273 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 74956
0.0025  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 = 74491
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10273 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10273 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (3244,3770,6333,6817,19577) ORDER BY n.cover_points DESC, update_date DESC
0.0029  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 = '10273' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031  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 = '10273' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 74956 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 74491 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=10273 AND l.year in (2023,2024,2025) 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 (74956,74491,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 74956 AND teamId = 10273
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74491 AND teamId = 10273
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 10273
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 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 = 74956 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0052  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 = 74956 WHERE rp.league_id = 74956 AND rp.teamId = 10273 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.0036  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 = 74956 WHERE rp.league_id = 74956 AND rp.teamId = 10273 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 74956 WHERE rp.league_id = 74956 AND rp.teamId = 10273 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030  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 = 10273 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74956 AND t.round = 15 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 `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 = 67937 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.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 `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 = 70613 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.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 `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 = 63294 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.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 = 66236 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.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 = 58361 AND t.round = 15 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 `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 = 60392 AND t.round = 15 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 `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.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 `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.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 = 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.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 `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.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 `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.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 = 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.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 = 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.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 `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.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 `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.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 `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.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 `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.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 `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
0.0020  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 = 74956 ORDER BY nameShow LIMIT 100