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

Progreso

Entrenador: Carlos Canobbio

Temporada 2023/2024
TEMPORADA 2023/2024
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Peñarol Peñarol 10 22 4 28
2 Progreso Progreso 10 23 14 24
3 Nacional Nacional 10 20 9 22
4 Defensor Sporting Defensor 10 19 13 16
5 Racing Montevideo Racing 10 15 12 15
6 Cerro Largo Cerro Largo 10 10 8 15
7 Boston River Boston River 10 12 12 15
8 River Plate Montevideo River Plate 10 13 14 12
9 Danubio Danubio 10 11 13 12
10 Liverpool Montevideo Liverpool 10 15 15 11
11 Montevideo Wanderers Montevideo 10 10 16 9
12 Deportivo Maldonado Deportivo 10 9 15 8
13 Cerro CA Cerro CA 10 11 18 8
14 Rampla Juniors Rampla 10 9 22 8
15 Miramar Misiones Miramar 10 14 20 7
16 Fénix Fénix 10 5 13 4
TEMPORADA 2022/2023
SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo PJ GF GC Puntos
1 Miramar Misiones Miramar 32 52 24 66
2 Progreso Progreso 32 60 36 65
3 Uruguay Montevideo Uruguay 32 47 33 56
4 Juventud Juventud 32 38 30 51
5 Rentistas Rentistas 32 39 27 47
6 Rampla Juniors Rampla 32 41 32 47
7 Oriental Oriental 32 40 39 47
8 Cerrito Cerrito 32 38 56 41
9 Albion FC Albion FC 32 44 41 41
10 Atenas Atenas 32 26 32 40
11 Tacuarembó FC Tacuarembó 32 43 49 39
12 Bella Vista Bella Vista 32 24 48 29
13 Sud América América 32 26 45 26
14 Potencia Potencia 32 24 50 21
TEMPORADA 2021/2022
SEGUNDA DIVISIÓN URUGUAY GRUPO 3
Equipo PJ GF GC Puntos
1 Racing Montevideo Racing 27 40 18 57
2 La Luz FC La Luz FC 27 35 23 51
3 Uruguay Montevideo Uruguay 27 35 29 44
4 Cerro CA Cerro CA 27 31 30 41
5 Miramar Misiones Miramar 27 38 32 40
6 Rampla Juniors Rampla 27 32 31 35
7 Sud América América 27 27 38 33
8 Atenas Atenas 27 24 25 32
9 Progreso Progreso 27 23 27 31
10 Juventud Juventud 27 19 28 27
11 CSyD Villa Española CSyD Villa. 27 27 37 27
12 Central Español FC Central 27 22 35 22
TEMPORADA 2020/2021
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Peñarol Peñarol 15 27 11 32
2 Nacional Nacional 15 23 15 30
3 Montevideo Wanderers Montevideo 15 23 18 27
4 Cerro Largo Cerro Largo 15 24 11 26
5 Montevideo City Torque Montevideo 15 26 19 25
6 Progreso Progreso 15 12 7 25
7 Boston River Boston River 15 24 25 22
8 Cerrito Cerrito 15 20 22 21
9 Plaza Colonia Plaza 15 20 18 20
10 Fénix Fénix 15 18 18 19
11 Deportivo Maldonado Deportivo 15 13 18 17
12 River Plate Montevideo River Plate 15 18 22 16
13 Liverpool Montevideo Liverpool 15 15 19 15
14 Rentistas Rentistas 15 18 24 14
15 Sud América América 15 14 26 13
16 CSyD Villa Española CSyD Villa. 15 12 34 6
TEMPORADA 2019/2020
TORNEO INTERMEDIO URUGUAY
Equipo PJ GF GC Puntos
1 Montevideo Wanderers Montevideo 7 13 8 14
2 Liverpool Montevideo Liverpool 7 14 12 12
3 Montevideo City Torque Montevideo 7 13 10 10
4 Cerro Largo Cerro Largo 7 8 5 10
5 Rentistas Rentistas 7 7 6 9
6 Progreso Progreso 7 7 10 7
7 Plaza Colonia Plaza 7 8 11 6
8 Cerro CA Cerro CA 7 5 13 5
9 Nacional Nacional 7 11 6 15
10 River Plate Montevideo River Plate 7 14 8 13
11 Peñarol Peñarol 7 15 9 12
12 Fénix Fénix 7 7 6 10
13 Danubio Danubio 7 5 9 9
14 Deportivo Maldonado Deportivo 7 10 15 8
15 Defensor Sporting Defensor 7 5 10 6
16 Boston River Boston River 7 6 10 5
TEMPORADA 2018/2019
TORNEO INTERMEDIO URUGUAY
Equipo PJ GF GC Puntos
1 River Plate Montevideo River Plate 6 6 3 12
2 Nacional Nacional 6 10 6 11
3 Peñarol Peñarol 6 9 4 9
4 Progreso Progreso 6 9 7 9
5 Defensor Sporting Defensor 6 10 10 8
6 Juventud Juventud 6 5 7 6
7 Boston River Boston River 6 3 7 6
8 Danubio Danubio 6 5 13 1
9 Liverpool Montevideo Liverpool 6 15 5 15
10 Cerro Largo Cerro Largo 6 10 5 13
11 Plaza Colonia Plaza 6 9 4 13
12 Fénix Fénix 6 7 9 9
13 Racing Montevideo Racing 6 8 12 7
14 Rampla Juniors Rampla 6 7 10 4
15 Cerro CA Cerro CA 6 2 7 4
16 Montevideo Wanderers Montevideo 6 9 15 4
TEMPORADA 2017/2018
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 14 26 8 38
2 Peñarol Peñarol 14 28 10 36
3 Danubio Danubio 14 23 13 30
4 Defensor Sporting Defensor 14 26 20 30
5 Liverpool Montevideo Liverpool 14 17 16 27
6 River Plate Montevideo River Plate 14 28 22 25
7 Cerro CA Cerro CA 14 16 18 25
8 Progreso Progreso 14 25 17 21
9 Fénix Fénix 14 18 18 20
10 Boston River Boston River 14 17 21 19
11 Montevideo Wanderers Montevideo 14 14 20 18
12 Atenas Atenas 14 11 27 16
13 Racing Montevideo Racing 14 14 24 12
14 Montevideo City Torque Montevideo 14 13 27 10
15 Rampla Juniors Rampla 14 12 27 10
16 El Tanque Sisley Tanque 0 0 0 0
TEMPORADA 2016/2017
SEGUNDA DIVISIÓN URUGUAY
Equipo PJ GF GC Puntos
1 Montevideo City Torque Montevideo 28 48 23 56
2 Atenas Atenas 28 40 26 47
3 Progreso Progreso 28 39 27 42
4 Cerro Largo Cerro Largo 28 30 27 42
5 Cerrito Cerrito 28 26 35 42
6 Deportivo Maldonado Deportivo 28 29 31 39
7 Central Español FC Central 28 32 38 39
8 Rentistas Rentistas 28 43 38 36
9 Villa Teresa Villa Teresa 28 40 36 36
10 CSyD Villa Española CSyD Villa. 28 26 27 35
11 Tacuarembó FC Tacuarembó 28 33 34 34
12 Miramar Misiones Miramar 28 25 31 31
13 Huracán FC Huracán FC 28 33 43 30
14 Canadian Canadian 28 29 36 28
15 Oriental Oriental 28 31 52 28
TEMPORADA 2015/2016
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO GRUPO 2
Equipo PJ GF GC Puntos
1 Rampla Juniors Rampla 14 22 14 31
2 CSyD Villa Española CSyD Villa. 14 23 14 29
3 Boston River Boston River 14 21 13 26
4 Montevideo City Torque Montevideo 14 26 20 23
5 Progreso Progreso 14 21 16 23
6 Atenas Atenas 14 25 19 22
7 Miramar Misiones Miramar 14 18 17 19
8 Tacuarembó FC Tacuarembó 14 22 23 17
9 Cerro Largo Cerro Largo 14 16 18 17
10 Central Español FC Central 14 17 20 17
11 Rocha FC Rocha FC 14 12 15 17
12 Deportivo Maldonado Deportivo 14 12 18 14
13 Oriental Oriental 14 12 20 14
14 Huracán FC Huracán FC 14 10 23 13
15 Canadian Canadian 14 16 23 12

  USO DE MEMORIA  
6,084,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7964
Total Execution Time  0.7976
  CADENA URL  
/historico/Progreso-Montevideo
  GET DATOS  
$_GET['/historico/Progreso-Montevideo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0156  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 = 'Progreso-Montevideo' 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.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=2020 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=2020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=2020 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2020 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2020 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 (95192,96985,97024,120228,488477) ORDER BY n.cover_points DESC, update_date DESC
0.0154  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 = '2020' ORDER BY l.year DESC,cat.coefficient DESC
0.0154  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 = '2020' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '2020' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0152  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=2020 AND l.year in (2023,2024,2025) 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 (75068,73584,71542) 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.0157  SELECT count(id) as num_players from rel_players WHERE league_id = 75068 AND teamId = 2020
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 71542 AND teamId = 2020
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 2020
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 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 = 75068 AND t.round = 10 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0155  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 = '2020' 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 = '2020' and rp.type = 4
0.0147  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 = '2020' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0216  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 = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 2020 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 events2024 e ON e.player_id = p.id AND e.league_id = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 2020 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 75068 WHERE rp.league_id = 75068 AND rp.teamId = 2020 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 = 2020 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75068 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.0152  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 = 71087 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 71381 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 66698 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 67421 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 62425 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.0154  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 = 64096 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.0164  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 = 53552 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.0165  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 = 53553 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.0161  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 = 59648 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 48930 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 50060 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 50145 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 42567 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 43412 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 42566 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 35302 AND t.round = 13 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 `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 = 38209 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 15508 AND t.round = 7 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 `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 = 20258 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 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 = 75068 ORDER BY nameShow LIMIT 100