4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
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
TORNEO INTERMEDIO URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Defensor Sporting Defensor 7 11 5 14
2 Montevideo Wanderers Montevideo 7 10 6 12
3 Danubio Danubio 7 6 4 11
4 Peñarol Peñarol 7 9 9 10
5 Boston River Boston River 7 8 7 9
6 River Plate Montevideo River Plate 7 5 7 9
7 Montevideo City Torque Montevideo 7 8 8 8
8 La Luz FC La Luz FC 7 6 17 4
TEMPORADA 2021/2022
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 15 26 9 34
2 River Plate Montevideo River Plate 15 29 12 30
3 Deportivo Maldonado Deportivo 15 19 11 30
4 Liverpool Montevideo Liverpool 15 23 12 28
5 Danubio Danubio 15 19 10 25
6 Defensor Sporting Defensor 15 18 12 25
7 Boston River Boston River 15 21 15 22
8 Peñarol Peñarol 15 20 16 22
9 Cerro Largo Cerro Largo 15 11 18 19
10 Fénix Fénix 15 13 15 17
11 Montevideo Wanderers Montevideo 15 12 19 16
12 Albion FC Albion FC 15 11 19 16
13 Plaza Colonia Plaza 15 11 20 14
14 Montevideo City Torque Montevideo 15 12 24 13
15 Rentistas Rentistas 15 16 31 10
16 Cerrito Cerrito 15 10 28 9
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
TORNEO INTERMEDIO URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 7 19 5 17
2 Cerro CA Cerro CA 7 9 5 13
3 Danubio Danubio 7 12 12 10
4 Racing Montevideo Racing 7 5 9 10
5 Montevideo Wanderers Montevideo 7 8 10 9
6 Liverpool Montevideo Liverpool 7 10 11 8
7 Rampla Juniors Rampla 7 9 14 6
8 Fénix Fénix 7 7 13 5
9 Montevideo City Torque Montevideo 6 10 6 13
10 Peñarol Peñarol 6 20 10 12
11 River Plate Montevideo River Plate 6 5 9 9
12 Atenas Atenas 6 6 5 8
13 Progreso Progreso 6 5 7 6
14 Defensor Sporting Defensor 6 4 8 6
15 Boston River Boston River 6 2 7 4
TEMPORADA 2016/2017
TORNEO INTERMEDIO URUGUAY
Equipo PJ GF GC Puntos
1 Defensor Sporting Defensor 7 15 7 17
2 Peñarol Peñarol 7 17 7 16
3 Rampla Juniors Rampla 7 7 8 11
4 Boston River Boston River 7 9 9 10
5 Fénix Fénix 7 8 10 9
6 Plaza Colonia Plaza 7 4 9 6
7 Liverpool Montevideo Liverpool 7 7 10 5
8 El Tanque Sisley Tanque 7 6 13 2
9 Nacional Nacional 7 16 5 19
10 Montevideo Wanderers Montevideo 7 9 3 17
11 Racing Montevideo Racing 7 8 6 13
12 Cerro CA Cerro CA 7 7 8 8
13 Danubio Danubio 7 5 9 7
14 Juventud Juventud 7 5 8 6
15 Sud América América 7 6 11 4
16 River Plate Montevideo River Plate 7 5 11 3

  USO DE MEMORIA  
6,380,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8138
Total Execution Time  0.8150
  CADENA URL  
/historico/Penarol-Montevideo
  GET DATOS  
$_GET['/historico/Penarol-Montevideo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0276  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 = 75645
0.0144  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 = 75068
0.0145  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 = 75100
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1945 AND type_rel = 2
0.0188  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1945 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138  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 (72918,129700,205736,359,483) ORDER BY n.cover_points DESC, update_date DESC
0.0212  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 = '1945' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0193  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=1945 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0141  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 (75645,75100,75068,74799,73584,71732,71432,71371,70793,70727) 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.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 75068 AND teamId = 1945
0.0177  SELECT count(id) as num_players from rel_players WHERE league_id = 70793 AND teamId = 1945
0.0179  SELECT count(id) as num_players from rel_players WHERE league_id = 71732 AND teamId = 1945
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 75645 AND teamId = 1945
0.0134  SELECT count(id) as num_players from rel_players WHERE league_id = 71371 AND teamId = 1945
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 70727 AND teamId = 1945
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 1945
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 74799 AND teamId = 1945
0.0243  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1945
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 75100 AND teamId = 1945
0.0134  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 = '1945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1945' and rp.type = 4
0.0131  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 = '1945' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1945' and rp.type = 4
0.0168  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 = 75645 WHERE rp.league_id = 75645 AND rp.teamId = 1945 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.0185  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 = 75645 WHERE rp.league_id = 75645 AND rp.teamId = 1945 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 75645 WHERE rp.league_id = 75645 AND rp.teamId = 1945 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 1945 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0131  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.0132  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 = 70792 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.0141  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 = 70793 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.0138  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 = 71732 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.0144  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 = 66322 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.0138  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 = 67806 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.0143  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 = 68424 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.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 `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.0143  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.0141  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.0142  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.0143  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.0145  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.0142  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.0144  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.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 `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.0136  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.0130  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.0129  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 = 37744 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 38472 AND t.round = 7 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC