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

Tacuarembó FC

Entrenador: L. González

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 1
Equipo PJ GF GC Puntos
1 Progreso Progreso 6 11 2 14
2 Rampla Juniors Rampla 6 10 6 13
3 Oriental Oriental 6 8 4 10
4 Albion FC Albion FC 6 8 12 7
5 Sud América América 6 7 10 6
6 Uruguay Montevideo Uruguay 6 5 9 6
7 Atenas Atenas 6 3 9 4
8 Juventud Juventud 6 9 2 13
9 Miramar Misiones Miramar 6 12 8 12
10 Rentistas Rentistas 6 7 3 11
11 Bella Vista Bella Vista 6 7 8 7
12 Potencia Potencia 6 8 12 5
13 Cerrito Cerrito 6 5 10 5
14 Tacuarembó FC Tacuarembó 6 8 13 4
TEMPORADA 2019/2020
SEGUNDA DIVISIÓN URUGUAY GRUPO 1
Equipo PJ GF GC Puntos
1 Cerrito Cerrito 22 38 23 41
2 CSyD Villa Española CSyD Villa. 22 35 24 37
3 Juventud Juventud 22 24 17 32
4 Rampla Juniors Rampla 22 27 23 32
5 Racing Montevideo Racing 22 25 26 30
6 Sud América América 22 30 33 28
7 Central Español FC Central 22 25 25 27
8 Rocha FC Rocha FC 22 20 23 27
9 Villa Teresa Villa Teresa 22 19 29 26
10 Atenas Atenas 22 23 29 24
11 Tacuarembó FC Tacuarembó 22 19 27 23
12 Albion FC Albion FC 22 22 28 22
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
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
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
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 Tacuarembó FC Tacuarembó 26 41 25 48
2 Atenas Atenas 26 43 34 46
3 Deportivo Maldonado Deportivo 26 30 28 41
4 Huracán FC Huracán FC 26 33 26 40
5 Boston River Boston River 26 39 31 39
6 Rocha FC Rocha FC 26 34 26 39
7 Rampla Juniors Rampla 26 36 33 36
8 Villa Teresa Villa Teresa 26 34 31 36
9 Plaza Colonia Plaza 26 27 24 36
10 Central Español FC Central 26 33 40 36
11 Canadian Canadian 26 26 30 34
12 Progreso Progreso 26 27 38 27
13 Cerrito Cerrito 26 24 41 23
14 Montevideo City Torque Montevideo 26 27 47 15
TEMPORADA 2012/2013
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 Sud América América 26 39 18 48
2 Miramar Misiones Miramar 26 39 28 46
3 Rentistas Rentistas 26 34 24 46
4 Tacuarembó FC Tacuarembó 26 38 24 45
5 Montevideo City Torque Montevideo 26 43 33 44
6 Cerrito Cerrito 26 26 30 37
7 Boston River Boston River 26 37 31 36
8 Atenas Atenas 26 28 32 34
9 Rampla Juniors Rampla 26 26 26 32
10 Plaza Colonia Plaza 26 23 34 28
11 Deportivo Maldonado Deportivo 26 25 33 26
12 Rocha FC Rocha FC 26 32 51 25
13 Villa Teresa Villa Teresa 26 29 41 22
14 Huracán FC Huracán FC 26 28 42 22
TEMPORADA 2011/2012
SEGUNDA DIVISIÓN URUGUAY FORMATO ANTIGUO
Equipo PJ GF GC Puntos
1 Central Español FC Central 24 47 18 54
2 Juventud Juventud 24 37 22 43
3 Progreso Progreso 24 36 31 42
4 Tacuarembó FC Tacuarembó 24 29 22 37
5 Huracán FC Huracán FC 24 29 31 35
6 Miramar Misiones Miramar 24 38 31 34
7 Boston River Boston River 24 30 25 33
8 Atenas Atenas 24 29 31 32
9 Sud América América 24 23 24 27
10 Plaza Colonia Plaza 24 28 42 27
11 Deportivo Maldonado Deportivo 24 27 30 26
12 Rocha FC Rocha FC 24 28 51 19
13 Villa Teresa Villa Teresa 24 20 43 12
TEMPORADA 2010/2011
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Defensor Sporting Defensor 15 31 13 30
2 Nacional Nacional 15 28 18 29
3 Bella Vista Bella Vista 15 24 18 29
4 El Tanque Sisley Tanque 15 21 18 28
5 Danubio Danubio 15 24 14 26
6 Peñarol Peñarol 15 24 17 25
7 Montevideo Wanderers Montevideo 15 20 16 21
8 Liverpool Montevideo Liverpool 15 18 19 21
9 Cerro CA Cerro CA 15 15 17 19
10 Fénix Fénix 15 21 20 18
11 River Plate Montevideo River Plate 15 16 23 18
12 Central Español FC Central 15 21 25 17
13 Racing Montevideo Racing 15 14 20 14
14 Rampla Juniors Rampla 15 19 27 12
15 Miramar Misiones Miramar 15 14 23 11
16 Tacuarembó FC Tacuarembó 15 10 32 5
TEMPORADA 2009/2010
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 15 36 11 39
2 Liverpool Montevideo Liverpool 15 31 14 29
3 Defensor Sporting Defensor 15 28 16 29
4 Montevideo Wanderers Montevideo 15 24 13 26
5 Peñarol Peñarol 15 28 19 26
6 Rampla Juniors Rampla 15 18 19 24
7 Danubio Danubio 15 26 25 23
8 River Plate Montevideo River Plate 15 24 23 23
9 Racing Montevideo Racing 15 25 22 20
10 Cerrito Cerrito 15 20 21 18
11 Cerro Largo Cerro Largo 15 15 18 16
12 Tacuarembó FC Tacuarembó 15 17 24 16
13 Central Español FC Central 15 13 28 12
14 Cerro CA Cerro CA 15 18 31 11
15 Atenas Atenas 15 9 32 11
16 Fénix Fénix 15 10 26 6
TEMPORADA 2008/2009
APERTURA URUGUAY
Equipo PJ GF GC Puntos
1 Danubio Danubio 15 27 15 32
2 Nacional Nacional 15 23 13 32
3 Defensor Sporting Defensor 15 23 12 30
4 Racing Montevideo Racing 15 24 14 27
5 Liverpool Montevideo Liverpool 15 21 15 27
6 Peñarol Peñarol 15 29 15 25
7 Cerro CA Cerro CA 16 20 12 23
8 River Plate Montevideo River Plate 15 17 17 20
9 Central Español FC Central 15 16 21 20
10 Tacuarembó FC Tacuarembó 15 16 20 17
11 Bella Vista Bella Vista 15 13 22 17
12 Montevideo Wanderers Montevideo 15 17 18 14
13 Rampla Juniors Rampla 15 16 24 14
14 CSyD Villa Española CSyD Villa. 15 11 26 12
15 Cerro Largo Cerro Largo 14 13 25 9
16 Juventud Juventud 15 9 26 8

  USO DE MEMORIA  
6,440,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1583
Total Execution Time  0.1595
  CADENA URL  
/historico/Tacuarembo-Fc
  GET DATOS  
$_GET['/historico/Tacuarembo-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
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 = 'Tacuarembo-Fc' 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=2459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=2459 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 75923
0.0027  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 = 73584
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2459 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2459 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 (185429,336749,1201980) 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 = '2459' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '2459' 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 = 73584 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 75923 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  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=2459 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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,67320) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75923 AND teamId = 2459
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73584 AND teamId = 2459
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 2459
0.0021  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 = 75923 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '2459' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '2459' and rp.type = 4
0.0020  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 = '2459' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 2459 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.0020  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 = 2459 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 2459 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 2459 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.0023  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 = 55517 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.0023  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.0024  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.0022  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.0022  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.0024  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.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 `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.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 `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.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 `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.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 `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 = 3761 AND t.round = 26 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 `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 = 2217 AND t.round = 26 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 `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 = 1640 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 1299 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 `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 = 1395 AND t.round = 15 ORDER BY team.conference 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 `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 = 1033 AND t.round = 15 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 `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 = 1394 AND t.round = 15 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 `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 = 1032 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 75923 ORDER BY nameShow LIMIT 100