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

Rentistas

Entrenador: Julio Fuentes

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Juventud Juventud 6 10 6 13
2 Albion FC Albion FC 6 7 3 11
3 Tacuarembó FC Tacuarembó 6 8 5 11
4 Oriental Oriental 6 11 10 10
5 Uruguay Montevideo Uruguay 6 7 8 6
6 La Luz FC La Luz FC 6 2 5 6
7 Sud América América 6 2 10 3
8 Montevideo City Torque Montevideo 6 9 2 14
9 Rentistas Rentistas 6 4 3 10
10 Plaza Colonia Plaza 6 7 8 8
11 Colón FC Colón FC 6 5 7 8
12 Cerrito Cerrito 6 4 4 7
13 CSyD Cooper CSyD Cooper 6 6 8 5
14 Atenas Atenas 6 3 6 3
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
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
SEGUNDA DIVISIÓN URUGUAY
Equipo PJ GF GC Puntos
1 Montevideo City Torque Montevideo 22 28 14 43
2 Deportivo Maldonado Deportivo 22 30 20 40
3 Rentistas Rentistas 22 28 19 39
4 CSyD Villa Española CSyD Villa. 22 30 25 36
5 Cerrito Cerrito 22 26 23 30
6 Sud América América 22 16 17 30
7 Atenas Atenas 22 30 27 29
8 Villa Teresa Villa Teresa 22 24 27 28
9 Albion FC Albion FC 22 21 28 27
10 Central Español FC Central 22 18 25 24
11 Bella Vista Bella Vista 22 23 40 20
12 Tacuarembó FC Tacuarembó 22 19 28 19
TEMPORADA 2017/2018
SEGUNDA DIVISIÓN URUGUAY
Equipo PJ GF GC Puntos
1 Cerro Largo Cerro Largo 26 33 16 51
2 Juventud Juventud 26 46 24 50
3 Plaza Colonia Plaza 26 35 28 44
4 Cerrito Cerrito 26 30 37 37
5 Villa Teresa Villa Teresa 26 39 31 36
6 Tacuarembó FC Tacuarembó 26 33 32 35
7 Deportivo Maldonado Deportivo 26 32 27 35
8 Sud América América 26 32 30 35
9 Central Español FC Central 26 30 31 32
10 CSyD Villa Española CSyD Villa. 26 32 40 29
11 Rentistas Rentistas 26 31 43 28
12 Albion FC Albion FC 26 27 36 27
13 Miramar Misiones Miramar 26 26 41 26
14 Oriental Oriental 26 29 39 24
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
CLAUSURA URUGUAY
Equipo PJ GF GC Puntos
1 Plaza Colonia Plaza 15 20 9 32
2 Peñarol Peñarol 15 25 18 27
3 Sud América América 15 17 16 25
4 Montevideo Wanderers Montevideo 15 31 21 24
5 Nacional Nacional 15 21 17 24
6 Cerro CA Cerro CA 15 17 15 24
7 Fénix Fénix 15 18 13 23
8 Liverpool Montevideo Liverpool 15 16 18 22
9 Rentistas Rentistas 15 18 17 21
10 Defensor Sporting Defensor 15 23 29 21
11 Villa Teresa Villa Teresa 15 15 19 19
12 Juventud Juventud 15 19 19 18
13 River Plate Montevideo River Plate 15 15 16 18
14 Racing Montevideo Racing 15 19 24 14
15 Danubio Danubio 15 18 25 13
16 El Tanque Sisley Tanque 15 14 30 7
TEMPORADA 2014/2015
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 15 34 7 42
2 Racing Montevideo Racing 15 32 26 32
3 Peñarol Peñarol 15 28 16 25
4 River Plate Montevideo River Plate 15 26 18 25
5 El Tanque Sisley Tanque 15 18 18 23
6 Defensor Sporting Defensor 15 28 22 21
7 Sud América América 15 17 17 20
8 Juventud Juventud 15 21 22 20
9 Atenas Atenas 15 20 22 20
10 Danubio Danubio 15 17 20 20
11 Rentistas Rentistas 15 18 24 20
12 Montevideo Wanderers Montevideo 15 21 21 19
13 Fénix Fénix 15 20 26 17
14 Rampla Juniors Rampla 15 18 27 17
15 Cerro CA Cerro CA 15 11 32 11
16 Tacuarembó FC Tacuarembó 15 17 28 7
TEMPORADA 2013/2014
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 River Plate Montevideo River Plate 16 33 18 34
2 Danubio Danubio 15 24 13 32
3 Nacional Nacional 15 29 18 30
4 Montevideo Wanderers Montevideo 16 26 18 30
5 Rentistas Rentistas 18 26 28 29
6 El Tanque Sisley Tanque 16 22 17 24
7 Liverpool Montevideo Liverpool 16 18 16 22
8 Peñarol Peñarol 16 25 23 19
9 Cerro Largo Cerro Largo 16 20 25 19
10 Cerro CA Cerro CA 15 21 25 17
11 Sud América América 15 16 21 17
12 Defensor Sporting Defensor 16 23 28 16
13 Fénix Fénix 15 18 20 15
14 Racing Montevideo Racing 15 18 23 15
15 Juventud Juventud 16 21 30 14
16 Miramar Misiones Miramar 16 12 29 13

  USO DE MEMORIA  
6,223,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6673
Total Execution Time  0.6693
  CADENA URL  
/historico/Rentistas
  GET DATOS  
$_GET['/historico/Rentistas']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0138  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 = 'Rentistas' 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.0126  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=5949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=5949 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5949 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5949 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (11861,17794,74514,77311,85881) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '5949' ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '5949' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '5949' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 75545 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=5949 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125  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 (75923,73584) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 75923 AND teamId = 5949
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 5949
0.0127  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 = '5949' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5949' and rp.type = 4
0.0127  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 = '5949' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 75923 WHERE rp.league_id = 75923 AND rp.teamId = 5949 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.0130  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 = 75923 WHERE rp.league_id = 75923 AND rp.teamId = 5949 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 75923 WHERE rp.league_id = 75923 AND rp.teamId = 5949 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 5949 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0137  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 = 75545 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 `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.0146  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.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.0137  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.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 `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.0135  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.0133  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.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 `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.0133  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.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 `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.0128  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 = 49071 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 42967 AND t.round = 26 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 = 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.0128  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.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 `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 = 15472 AND t.round = 15 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 `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 = 20175 AND t.round = 15 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 `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 = 9063 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 `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 = 4058 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 `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 = 3281 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC