4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2020/2021
APERTURA PARAGUAY
Equipo PJ GF GC Puntos
1 Libertad Libertad 18 36 15 38
2 Olimpia Olimpia 18 34 23 33
3 Nacional Nacional 18 26 19 30
4 Cerro Porteño Cerro 18 24 22 28
5 Guaireña Guaireña 18 20 14 26
6 Guaraní Guaraní 18 24 27 25
7 12 de Octubre Octubre 18 20 25 22
8 Sportivo Luqueño Sportivo 18 19 29 18
9 Sol de América América 18 18 28 14
10 Club River Plate Club River. 18 13 32 12
TEMPORADA 2019/2020
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 12 de Octubre Octubre 11 15 12 20
2 Nacional Nacional 11 18 12 19
3 Cerro Porteño Cerro 11 16 11 19
4 Libertad Libertad 11 20 15 18
5 Guaraní Guaraní 11 11 7 18
6 Olimpia Olimpia 11 20 16 17
7 Sol de América América 11 19 14 16
8 Guaireña Guaireña 11 10 14 14
9 Sportivo San Lorenzo Sportivo 11 13 15 12
10 Sportivo Luqueño Sportivo 11 13 19 11
11 Club River Plate Club River. 11 10 17 9
12 General Díaz General 11 12 25 3
TEMPORADA 2018/2019
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Olimpia Olimpia 22 53 15 54
2 Libertad Libertad 22 35 12 48
3 Cerro Porteño Cerro 22 42 28 37
4 Guaraní Guaraní 22 31 28 32
5 Sol de América América 22 23 22 31
6 Nacional Nacional 22 29 27 29
7 General Díaz General 22 27 33 25
8 Club River Plate Club River. 22 18 24 24
9 Sportivo San Lorenzo Sportivo 22 23 36 22
10 Sportivo Luqueño Sportivo 22 20 37 21
11 Dep. Capiatá Dep. 22 18 38 21
12 Deportivo Santaní Deportivo 22 20 39 19
TEMPORADA 2017/2018
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Olimpia Olimpia 22 48 20 49
2 Cerro Porteño Cerro 22 36 21 40
3 Libertad Libertad 22 33 20 37
4 Sol de América América 22 29 30 33
5 Deportivo Santaní Deportivo 22 22 29 28
6 Nacional Nacional 22 28 31 27
7 Guaraní Guaraní 22 27 30 25
8 3 de Febrero Febrero 22 32 37 25
9 Sportivo Luqueño Sportivo 22 23 30 25
10 Dep. Capiatá Dep. 22 25 36 24
11 General Díaz General 22 30 39 22
12 Independiente FBC Independient 22 22 32 20
TEMPORADA 2016/2017
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Cerro Porteño Cerro 22 41 23 45
2 Olimpia Olimpia 22 37 20 42
3 Guaraní Guaraní 22 36 29 37
4 General Díaz General 22 30 21 35
5 Sportivo Luqueño Sportivo 22 36 31 33
6 Sol de América América 22 26 32 28
7 Nacional Nacional 22 26 30 27
8 Libertad Libertad 22 26 27 26
9 Dep. Capiatá Dep. 22 19 22 26
10 Rubio Ñu Rubio Ñu 22 16 25 25
11 Sportivo Trinidense Sportivo 22 20 28 19
12 Independiente FBC Independient 22 16 41 18
TEMPORADA 2015/2016
APERTURA PARAGUAY
Equipo PJ GF GC Puntos
1 Libertad Libertad 22 38 23 44
2 Olimpia Olimpia 22 57 30 43
3 Sol de América América 22 41 36 35
4 Guaraní Guaraní 22 35 31 35
5 Rubio Ñu Rubio Ñu 22 31 32 33
6 Cerro Porteño Cerro 22 40 32 31
7 Dep. Capiatá Dep. 22 42 42 30
8 Sportivo Luqueño Sportivo 22 28 31 27
9 General Caballero SC General 22 36 47 26
10 General Díaz General 22 32 44 24
11 Nacional Nacional 22 36 42 23
12 Club River Plate Club River. 22 17 43 16
TEMPORADA 2014/2015
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Olimpia Olimpia 22 40 22 44
2 Cerro Porteño Cerro 22 32 23 44
3 Guaraní Guaraní 22 52 29 39
4 Libertad Libertad 22 35 23 38
5 Dep. Capiatá Dep. 22 31 34 33
6 Sol de América América 22 35 35 26
7 Deportivo Santaní Deportivo 22 29 37 26
8 General Díaz General 22 18 35 24
9 Sportivo Luqueño Sportivo 22 39 43 23
10 Rubio Ñu Rubio Ñu 22 22 29 22
11 Sportivo San Lorenzo Sportivo 22 29 38 22
12 Nacional Nacional 22 21 35 21
TEMPORADA 2013/2014
APERTURA PARAGUAY
Equipo PJ GF GC Puntos
1 Libertad Libertad 22 41 17 50
2 Guaraní Guaraní 22 56 31 46
3 Olimpia Olimpia 22 32 26 33
4 Cerro Porteño Cerro 22 49 38 31
5 Sol de América América 22 36 31 31
6 Rubio Ñu Rubio Ñu 22 38 37 30
7 Nacional Nacional 22 26 27 30
8 Sportivo Luqueño Sportivo 22 23 25 28
9 Dep. Capiatá Dep. 22 22 37 26
10 General Díaz General 22 19 34 19
11 12 de Octubre Octubre 22 21 38 15
12 3 de Febrero Febrero 22 22 44 14
TEMPORADA 2012/2013
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Cerro Porteño Cerro 22 37 16 50
2 Libertad Libertad 22 25 19 39
3 Dep. Capiatá Dep. 22 36 32 38
4 Guaraní Guaraní 22 47 24 37
5 General Díaz General 22 30 24 33
6 Nacional Nacional 22 30 26 33
7 Sportivo Luqueño Sportivo 22 30 29 29
8 Rubio Ñu Rubio Ñu 22 25 32 25
9 Olimpia Olimpia 22 31 32 24
10 Sportivo Carapeguá Sportivo 22 24 38 22
11 Sol de América América 22 24 43 17
12 PF Cerro Por. Cerro Por. 22 23 47 16
TEMPORADA 2011/2012
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Libertad Libertad 22 44 16 47
2 Nacional Nacional 22 36 16 44
3 Guaraní Guaraní 22 28 19 43
4 Cerro Porteño Cerro 22 39 21 37
5 Sportivo Luqueño Sportivo 22 23 24 33
6 Olimpia Olimpia 22 33 31 32
7 PF Cerro Por. Cerro Por. 22 19 31 26
8 Sol de América América 22 24 26 25
9 Sportivo Carapeguá Sportivo 22 30 34 25
10 Tacuary Tacuary 22 31 39 22
11 Rubio Ñu Rubio Ñu 22 18 38 18
12 Independiente FBC Independient 22 14 44 9

  USO DE MEMORIA  
6,415,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9243
Total Execution Time  0.9255
  CADENA URL  
/historico/Cerro-Porteno/2021
  GET DATOS  
$_GET['/historico/Cerro-Porteno/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (60)  
0.0146  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 = 'Cerro-Porteno' AND l.year = 2021 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.0127  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=725 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0155  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 = 62029
0.0155  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 = 62809
0.0154  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 = 61075
0.0154  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 = 61077
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 = 63469
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 = 66123
0.0130  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=725 AND type_rel = 2
0.0132  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 725 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (1460,1625,2162,4401,5200) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '725' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0135  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 = '725' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 63469 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 62809 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 61075 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 = 61077 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 66123 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  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=725 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (67706,67572,66976,66215,66123,56547,55450) 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.0136  SELECT count(id) as num_players from rel_players WHERE league_id = 66215 AND teamId = 725
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 66976 AND teamId = 725
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 67706 AND teamId = 725
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 55450 AND teamId = 725
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 67572 AND teamId = 725
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 66123 AND teamId = 725
0.0215  SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 725
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 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 = 62029 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137  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 events2021 e ON e.player_id = p.id AND e.league_id = 62029 WHERE rp.league_id = 62029 AND rp.teamId = 725 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.0180  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 events2021 e ON e.player_id = p.id AND e.league_id = 62029 WHERE rp.league_id = 62029 AND rp.teamId = 725 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 events2021 e ON e.player_id = p.id AND e.league_id = 62029 WHERE rp.league_id = 62029 AND rp.teamId = 725 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0180  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 = 725 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140  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 = 61077 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 61075 AND t.round = 18 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 = 53523 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.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 `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 = 59044 AND t.round = 11 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 `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 = 48541 AND t.round = 22 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 `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 = 48635 AND t.round = 22 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 `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 = 42060 AND t.round = 22 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 `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 = 44321 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 `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 = 37684 AND t.round = 22 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 = 38848 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 `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 = 26801 AND t.round = 22 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 `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 = 20174 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 `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 = 8951 AND t.round = 22 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 = 15482 AND t.round = 22 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 `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 = 3351 AND t.round = 22 ORDER BY team.conference 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 `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 = 3570 AND t.round = 22 ORDER BY team.conference 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 `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 = 2334 AND t.round = 22 ORDER BY team.conference 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 `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 = 2706 AND t.round = 22 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 `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 = 1673 AND t.round = 22 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 `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 = 1573 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 62029 ORDER BY nameShow LIMIT 100