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

Correcaminos UAT

Entrenador: Potro Gutiérrez

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
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 8 18 4 22
2 Correcaminos UAT Correcaminos 8 16 10 18
3 Celaya Celaya 8 7 7 15
4 Zacatepec Zacatepec 8 13 12 14
5 Leones Negros Leones 8 14 14 14
6 Tampico Madero Tampico 8 9 8 13
7 Venados FC Venados FC 8 8 11 13
8 Atlante FC Atlante FC 8 6 7 12
9 Cimarrones de Sonora Cimarrones 8 6 11 9
10 Alebrijes de Oaxaca Alebrijes 8 6 9 6
11 Dorados Dorados 8 13 18 5
12 Cafetaleros Cafetaleros 8 9 14 3
TEMPORADA 2018/2019
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Atl. San Luis Atl. Luis 14 22 11 28
2 Mineros de Zacatecas Mineros 14 17 9 25
3 Zacatepec Zacatepec 14 22 18 22
4 Cimarrones de Sonora Cimarrones 14 12 17 22
5 Dorados Dorados 14 21 19 20
6 Venados FC Venados FC 14 12 13 20
7 Alebrijes de Oaxaca Alebrijes 14 12 14 19
8 Celaya Celaya 14 14 16 18
9 Atlante FC Atlante FC 14 26 21 17
10 Leones Negros Leones 14 19 18 17
11 Correcaminos UAT Correcaminos 14 15 16 17
12 UAEM Potros UAEM Potros 14 13 17 17
13 Cafetaleros Cafetaleros 14 23 25 15
14 FC Juárez FC Juárez 14 12 16 15
15 Tampico Madero Tampico 14 16 26 11
TEMPORADA 2017/2018
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 15 24 17 28
2 Dorados Dorados 15 20 13 26
3 Leones Negros Leones 15 21 18 25
4 Zacatepec Zacatepec 15 17 19 24
5 Alebrijes de Oaxaca Alebrijes 15 25 17 23
6 Atlante FC Atlante FC 15 16 12 23
7 Celaya Celaya 15 17 14 23
8 Cafetaleros Cafetaleros 15 24 21 22
9 Tampico Madero Tampico 15 14 11 22
10 Atl. San Luis Atl. Luis 15 18 22 20
11 Venados FC Venados FC 15 15 17 19
12 Correcaminos UAT Correcaminos 15 15 20 18
13 FC Juárez FC Juárez 15 12 16 15
14 Murciélagos Murciélagos 15 12 21 15
15 Cimarrones de Sonora Cimarrones 15 16 22 14
16 UAEM Potros UAEM Potros 15 11 17 11
TEMPORADA 2016/2017
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 17 21 11 32
2 Dorados Dorados 17 29 22 31
3 Alebrijes de Oaxaca Alebrijes 17 27 19 30
4 FC Juárez FC Juárez 17 23 17 28
5 UAEM Potros UAEM Potros 17 21 15 28
6 Lobos BUAP Lobos BUAP 17 30 26 27
7 Zacatepec Zacatepec 17 23 22 27
8 Cimarrones de Sonora Cimarrones 17 20 19 27
9 Deportivo Tepic Deportivo 17 24 20 26
10 Tampico Madero Tampico 17 15 14 23
11 Leones Negros Leones 17 16 18 22
12 Cafetaleros Cafetaleros 17 20 21 21
13 Atlante FC Atlante FC 17 17 18 21
14 Celaya Celaya 17 26 27 19
15 Correcaminos UAT Correcaminos 17 24 31 16
16 Venados FC Venados FC 17 17 34 15
17 Loros Universidad Loros 17 18 27 14
18 Murciélagos Murciélagos 17 13 23 14
TEMPORADA 2015/2016
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Leones Negros Leones 15 22 15 29
2 Necaxa Necaxa 15 21 12 28
3 Cafetaleros Cafetaleros 15 14 8 27
4 Celaya Celaya 15 20 13 26
5 Atlante FC Atlante FC 15 22 12 25
6 Mineros de Zacatecas Mineros 15 17 13 22
7 Correcaminos UAT Correcaminos 15 13 17 22
8 Alebrijes de Oaxaca Alebrijes 15 19 19 21
9 Venados FC Venados FC 15 17 14 20
10 FC Juárez FC Juárez 15 13 12 20
11 Deportivo Tepic Deportivo 15 20 19 19
12 Lobos BUAP Lobos BUAP 15 17 22 18
13 Murciélagos Murciélagos 15 18 30 16
14 Zacatepec Zacatepec 15 15 23 13
15 Atl. San Luis Atl. Luis 15 11 20 11
16 Cimarrones de Sonora Cimarrones 15 12 22 10
TEMPORADA 2014/2015
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Atl. San Luis Atl. Luis 13 20 10 24
2 Dorados Dorados 13 23 15 23
3 Lobos BUAP Lobos BUAP 13 20 11 22
4 Venados FC Venados FC 13 21 16 22
5 Necaxa Necaxa 13 15 14 21
6 Correcaminos UAT Correcaminos 13 18 15 20
7 Alebrijes de Oaxaca Alebrijes 13 18 16 20
8 Deportivo Tepic Deportivo 13 16 19 18
9 Mineros de Zacatecas Mineros 13 16 19 18
10 Irapuato Irapuato 13 12 16 16
11 Altamira Altamira 13 11 18 14
12 Atlante FC Atlante FC 13 12 19 13
13 Zacatepec Zacatepec 13 10 13 12
14 Celaya Celaya 13 14 25 10

  USO DE MEMORIA  
6,244,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1649
Total Execution Time  0.1662
  CADENA URL  
/historico/Correcaminos-Uat
  GET DATOS  
$_GET['/historico/Correcaminos-Uat']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0034  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 = 'Correcaminos-Uat' 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=6616 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=6616 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=6616 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=6616 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6616 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6616 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (88339,171432,181925,189088,204552) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '6616' ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '6616' 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 = '6616' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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.0031  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=6616 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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) 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.0031  SELECT count(id) as num_players from rel_players WHERE league_id = 74956 AND teamId = 6616
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 74491 AND teamId = 6616
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 = 74956 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0034  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 = '6616' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6616' and rp.type = 4
0.0025  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 = '6616' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0057  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 = 6616 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.0066  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 = 6616 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0050  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 = 6616 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053  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 = 6616 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72549 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.0030  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.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 `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.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 `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.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 `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.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 `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.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 `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.0030  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 = 49960 AND t.round = 13 ORDER BY team.conference ASC,t.position 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 `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 = 53478 AND t.round = 8 ORDER BY team.conference ASC,t.position 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 `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 = 44040 AND t.round = 15 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 `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 = 48497 AND t.round = 15 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 `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 = 38667 AND t.round = 15 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 `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 = 41854 AND t.round = 15 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 `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 = 33339 AND t.round = 17 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 `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 = 37587 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 15285 AND t.round = 15 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 `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 = 20081 AND t.round = 15 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 `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 = 3944 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 9009 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC