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 2017/2018
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 - APERTURA
Equipo PJ GF GC Puntos
1 Deportivo Tepic Deportivo 13 19 11 27
2 Mineros de Zacatecas Mineros 13 17 11 25
3 Correcaminos UAT Correcaminos 13 15 11 24
4 Necaxa Necaxa 13 17 13 21
5 Atlante FC Atlante FC 13 20 17 21
6 Altamira Altamira 13 15 13 21
7 Lobos BUAP Lobos BUAP 13 19 13 20
8 Zacatepec Zacatepec 13 16 15 18
9 Atl. San Luis Atl. Luis 13 17 13 17
10 Alebrijes de Oaxaca Alebrijes 13 19 21 15
11 Dorados Dorados 13 15 22 14
12 Irapuato Irapuato 13 9 18 12
13 Venados FC Venados FC 13 17 24 9
14 Celaya Celaya 13 12 25 6
TEMPORADA 2013/2014
ASCENSO MX - APERTURA
Equipo PJ GF GC Puntos
1 Alebrijes de Oaxaca Alebrijes 14 28 17 25
2 Necaxa Necaxa 14 21 15 25
3 Delfines Delfines 14 24 12 24
4 Venados FC Venados FC 14 22 13 23
5 Leones Negros Leones 14 21 21 23
6 Correcaminos UAT Correcaminos 14 25 20 22
7 Atl. San Luis Atl. Luis 14 19 17 22
8 Dorados Dorados 14 15 11 18
9 Cafetaleros Cafetaleros 14 26 26 18
10 Cruz Azul Cruz Azul 14 16 18 17
11 Lobos BUAP Lobos BUAP 14 9 17 17
12 Tecos Tecos 14 21 20 16
13 Celaya Celaya 14 18 25 14
14 Ballenas Galeana Ballenas 14 14 28 13
15 Zacatepec Zacatepec 14 9 28 5
TEMPORADA 2012/2013
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Leones Negros Leones 14 15 7 30
2 Correcaminos UAT Correcaminos 14 17 10 26
3 Lobos BUAP Lobos BUAP 14 16 10 25
4 Veracruz Veracruz 14 23 18 25
5 Necaxa Necaxa 14 23 15 21
6 Toros Neza Toros Neza 14 19 14 20
7 Celaya Celaya 14 17 16 20
8 Tecos Tecos 14 11 10 19
9 Dorados Dorados 14 11 14 19
10 Altamira Altamira 14 18 18 18
11 Pumas Morelos Pumas 14 13 15 17
12 Venados FC Venados FC 14 13 18 13
13 La Piedad La Piedad 14 13 17 12
14 Cruz Azul Cruz Azul 14 13 26 12
15 Irapuato Irapuato 14 7 21 7
TEMPORADA 2011/2012
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 León León 14 41 13 34
2 Mérida B Mérida B 14 16 8 28
3 Necaxa Necaxa 14 20 13 27
4 Toros Neza Toros Neza 14 25 16 24
5 Lobos BUAP Lobos BUAP 14 20 20 20
6 Leones Negros Leones 14 11 11 20
7 Correcaminos UAT Correcaminos 14 22 16 19
8 La Piedad La Piedad 14 22 17 19
9 Celaya Celaya 14 20 23 19
10 Irapuato Irapuato 14 13 17 16
11 Dorados Dorados 14 15 23 14
12 Pumas Morelos Pumas 14 7 16 13
13 Altamira Altamira 14 15 29 13
14 Veracruz Veracruz 14 13 24 12
15 Cruz Azul Cruz Azul 14 14 28 10
TEMPORADA 2010/2011
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 León León 16 30 16 34
2 Irapuato Irapuato 16 28 16 33
3 Atlante II Atlante II 16 19 12 29
4 Tijuana Tijuana 16 23 18 26
5 Veracruz Veracruz 16 18 14 26
6 Cruz Azul Cruz Azul 16 24 18 24
7 Correcaminos UAT Correcaminos 16 25 21 24
8 Dorados Dorados 16 22 21 24
9 Altamira Altamira 16 17 22 21
10 Indios Indios 16 14 20 20
11 Pumas Morelos Pumas 16 18 24 19
12 Orizaba Orizaba 16 15 17 18
13 Venados FC Venados FC 16 17 21 16
14 Reboceros de la Piedad Reboceros 16 14 21 15
15 Lobos BUAP Lobos BUAP 16 26 34 15
16 Leones Negros Leones 16 20 24 14
17 Durango Durango 16 16 27 12
TEMPORADA 2009/2010
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 León León 16 25 13 34
2 Necaxa Necaxa 16 25 13 32
3 Tijuana Tijuana 16 24 15 27
4 Pumas Morelos Pumas 16 21 16 26
5 Reboceros de la Piedad Reboceros 16 16 19 25
6 Correcaminos UAT Correcaminos 16 22 17 24
7 Lobos BUAP Lobos BUAP 16 17 22 24
8 Irapuato Irapuato 16 21 18 23
9 Cruz Azul Cruz Azul 16 17 14 23
10 Venados FC Venados FC 16 21 14 22
11 Orizaba Orizaba 16 19 17 22
12 Dorados Dorados 16 18 20 19
13 Atlante II Atlante II 16 24 26 17
14 Durango Durango 16 20 28 15
15 Veracruz Veracruz 16 18 26 15
16 Leones Negros Leones 16 15 28 13
17 Guerreros Guerreros 16 11 28 10
TEMPORADA 2008/2009
ASCENSO MX - APERTURA
Equipo PJ GF GC Puntos
1 León León 16 21 12 35
2 Tijuana Tijuana 16 20 8 32
3 Irapuato Irapuato 16 20 6 30
4 CD Tapatío CD Tapatío 16 12 16 19
5 Tecos UAG II Tecos 16 17 16 17
6 Académicos Académicos 16 12 14 16
7 Guerreros Guerreros 16 10 18 15
8 Dorados Dorados 16 11 21 15
9 Reboceros de la Piedad Reboceros 16 10 22 13
10 Querétaro Querétaro 16 36 20 33
11 Correcaminos UAT Correcaminos 16 21 12 31
12 Tigres UANL Premier Tigres UANL 16 19 12 29
13 Indios Chihuahua Indios 16 25 28 21
14 Durango Durango 16 15 16 20
15 Socio Águila Socio 16 13 16 19
16 Tampico Madero Tampico 16 25 30 17
17 Santos Laguna Premier Santos 16 18 27 15
18 Rayados de Monterrey Premie Rayados 16 19 30 12
19 Pumas Morelos Pumas 16 27 12 35
20 Venados FC Venados FC 16 22 13 32
21 Veracruz Veracruz 16 25 16 28
22 Cruz Azul Cruz Azul 16 25 15 24
23 Lobos BUAP Lobos BUAP 16 22 30 21
24 Atlético Mexiquense Atlético 16 19 19 19
25 Orizaba Orizaba 16 14 16 19
26 Atlante II Atlante II 16 15 28 11
27 Tuxtla FC Tuxtla FC 16 12 32 8

  USO DE MEMORIA  
6,595,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9074
Total Execution Time  0.9086
  CADENA URL  
/historico/Correcaminos-Uat/2018
  GET DATOS  
$_GET['/historico/Correcaminos-Uat/2018']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (51)  
0.0162  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 = 2018 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.0145  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.0145  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.0145  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.0145  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.0151  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.0150  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.0152  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 = 38667
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 = 41854
0.0151  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 = 42126
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6616 AND type_rel = 2
0.0146  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.0147  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.0151  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 = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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.0146  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 = 38667 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 41854 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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 = 42126 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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 (2017,2018,2019) 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 (48518,48497,44040,43475) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 44040 AND teamId = 6616
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 48497 AND teamId = 6616
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 48518 AND teamId = 6616
0.0246  SELECT count(id) as num_players from rel_players WHERE league_id = 43475 AND teamId = 6616
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6616' and rp.type = 4
0.0179  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.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 events2018 e ON e.player_id = p.id AND e.league_id = 38667 WHERE rp.league_id = 38667 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.0153  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 events2018 e ON e.player_id = p.id AND e.league_id = 38667 WHERE rp.league_id = 38667 AND rp.teamId = 6616 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0189  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 events2018 e ON e.player_id = p.id AND e.league_id = 38667 WHERE rp.league_id = 38667 AND rp.teamId = 6616 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 `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.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 `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.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 `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
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 `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.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 `tables2014` 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 = 12850 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0187  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 `tables2014` 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 = 45192 AND t.round = 15 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 `tables2013` 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 = 45193 AND t.round = 15 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 `tables2013` 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 = 2371 AND t.round = 15 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 `tables2012` 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 = 1660 AND t.round = 15 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 `tables2012` 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 = 1661 AND t.round = 15 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 `tables2011` 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 = 14201 AND t.round = 17 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 `tables2011` 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 = 14202 AND t.round = 17 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 `tables2010` 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 = 14200 AND t.round = 16 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 `tables2010` 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 = 14204 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2009` 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 = 14205 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 `tables2009` 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 = 14199 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC