4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2020/2021
BUNDESLIGA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 32 94 33 51
2 Rapid Wien Rapid Wien 32 64 40 36
3 Sturm Graz Sturm Graz 32 52 34 36
4 LASK LASK 32 55 41 30
5 Wolfsberger AC Wolfsberger 32 52 62 27
6 WSG Tirol WSG Tirol 32 53 60 23
TEMPORADA 2019/2020
BUNDESLIGA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 10 36 8 50
2 Rapid Wien Rapid Wien 10 17 17 38
3 Wolfsberger AC Wolfsberger 10 19 16 35
4 LASK LASK 10 17 17 33
5 TSV Hartberg Hartberg 10 16 24 27
6 Sturm Graz Sturm Graz 10 9 32 19
TEMPORADA 2018/2019
BUNDESLIGA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 22 51 18 55
2 LASK LASK 22 40 19 46
3 Sturm Graz Sturm Graz 22 26 23 31
4 Wolfsberger AC Wolfsberger 22 32 31 30
5 Austria Wien Austria Wien 22 29 28 30
6 SKN St. Polten Polten 22 26 29 30
7 Mattersburg Mattersburg 22 28 36 29
8 Rapid Wien Rapid Wien 22 26 29 27
9 TSV Hartberg Hartberg 22 35 45 26
10 Admira Admira 22 26 42 21
11 SCR Altach SCR Altach 22 30 32 18
12 Wacker Innsbruck Wacker 22 17 34 17
TEMPORADA 2017/2018
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 81 29 83
2 Sturm Graz Sturm Graz 36 68 45 70
3 Rapid Wien Rapid Wien 36 68 43 62
4 LASK LASK 36 49 41 57
5 Admira Admira 36 59 66 51
6 Mattersburg Mattersburg 36 50 56 46
7 Austria Wien Austria Wien 36 51 55 43
8 SCR Altach SCR Altach 36 35 51 38
9 Wolfsberger AC Wolfsberger 36 31 57 33
10 SKN St. Polten Polten 36 28 77 20
TEMPORADA 2016/2017
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 74 24 81
2 Austria Wien Austria Wien 36 72 50 63
3 Sturm Graz Sturm Graz 36 55 39 60
4 SCR Altach SCR Altach 36 46 49 53
5 Rapid Wien Rapid Wien 36 52 42 46
6 Admira Admira 36 36 55 46
7 Mattersburg Mattersburg 36 39 54 43
8 Wolfsberger AC Wolfsberger 36 40 59 42
9 SKN St. Polten Polten 36 41 60 37
10 SV Ried SV Ried 36 33 56 35
TEMPORADA 2015/2016
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 71 33 74
2 Rapid Wien Rapid Wien 36 66 42 65
3 Austria Wien Austria Wien 36 65 48 59
4 Admira Admira 36 45 51 50
5 Sturm Graz Sturm Graz 36 40 40 48
6 Wolfsberger AC Wolfsberger 36 33 36 43
7 SV Ried SV Ried 36 36 52 42
8 SCR Altach SCR Altach 36 39 49 40
9 Mattersburg Mattersburg 36 40 70 39
10 Grödig Grödig 36 42 56 35
TEMPORADA 2014/2015
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 99 42 73
2 Rapid Wien Rapid Wien 36 68 38 67
3 SCR Altach SCR Altach 36 50 49 59
4 Sturm Graz Sturm Graz 36 57 41 58
5 Wolfsberger AC Wolfsberger 36 44 50 52
6 SV Ried SV Ried 36 49 51 44
7 Austria Wien Austria Wien 36 45 51 43
8 Grödig Grödig 36 46 65 37
9 Admira Admira 36 32 61 34
10 Wiener Neustadt Wiener 36 37 79 29
TEMPORADA 2013/2014
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 110 35 80
2 Rapid Wien Rapid Wien 36 63 40 62
3 Grödig Grödig 36 68 71 54
4 Austria Wien Austria Wien 36 58 44 53
5 Sturm Graz Sturm Graz 36 55 55 48
6 SV Ried SV Ried 36 55 66 43
7 Admira Admira 36 51 67 42
8 Wolfsberger AC Wolfsberger 36 50 63 41
9 Wiener Neustadt Wiener 36 43 84 39
10 Wacker Innsbruck Wacker 36 42 70 29
TEMPORADA 2012/2013
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 36 84 31 82
2 Salzburg Salzburg 36 91 39 77
3 Rapid Wien Rapid Wien 36 57 39 57
4 Sturm Graz Sturm Graz 36 47 56 48
5 Wolfsberger AC Wolfsberger 36 53 56 47
6 SV Ried SV Ried 36 60 59 46
7 Wiener Neustadt Wiener 36 32 60 36
8 Wacker Innsbruck Wacker 36 41 73 36
9 Admira Admira 36 47 68 35
10 Mattersburg Mattersburg 36 36 67 35
TEMPORADA 2011/2012
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 60 30 68
2 Rapid Wien Rapid Wien 36 52 30 62
3 Admira Admira 36 59 52 55
4 Austria Wien Austria Wien 36 52 44 54
5 Sturm Graz Sturm Graz 36 47 41 51
6 SV Ried SV Ried 36 44 38 48
7 Wacker Innsbruck Wacker 36 36 45 45
8 Mattersburg Mattersburg 36 41 43 38
9 Wiener Neustadt Wiener 36 26 51 33
10 Kapfenberger SV Kapfenberger 36 21 64 23
TEMPORADA 2010/2011
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Sturm Graz Sturm Graz 36 66 33 66
2 Salzburg Salzburg 36 53 31 63
3 Austria Wien Austria Wien 36 64 37 61
4 SV Ried SV Ried 36 51 38 58
5 Rapid Wien Rapid Wien 36 52 41 53
6 Wacker Innsbruck Wacker 36 43 42 50
7 Wiener Neustadt Wiener 36 44 52 50
8 Kapfenberger SV Kapfenberger 36 42 61 38
9 Mattersburg Mattersburg 36 29 56 31
10 LASK LASK 36 22 75 19
TEMPORADA 2009/2010
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 68 27 76
2 Austria Wien Austria Wien 36 60 34 75
3 Rapid Wien Rapid Wien 36 80 38 73
4 Sturm Graz Sturm Graz 36 50 36 58
5 Wiener Neustadt Wiener 36 54 58 47
6 Mattersburg Mattersburg 36 45 71 41
7 LASK LASK 36 59 70 40
8 SV Ried SV Ried 36 39 47 38
9 Kapfenberger SV Kapfenberger 36 44 67 33
10 Austria Karnten Austria 36 29 80 15
TEMPORADA 2008/2009
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 86 50 74
2 Rapid Wien Rapid Wien 36 89 43 70
3 Austria Wien Austria Wien 36 59 46 62
4 Sturm Graz Sturm Graz 36 68 45 60
5 SV Ried SV Ried 36 58 38 60
6 Austria Karnten Austria 36 47 57 41
7 LASK LASK 36 35 67 37
8 Kapfenberger SV Kapfenberger 36 48 81 36
9 Mattersburg Mattersburg 36 42 71 33
10 SCR Altach SCR Altach 36 56 90 30
TEMPORADA 2007/2008
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 36 69 36 69
2 Salzburg Salzburg 36 63 42 63
3 Austria Wien Austria Wien 36 46 33 58
4 Sturm Graz Sturm Graz 36 60 41 56
5 Mattersburg Mattersburg 36 55 43 53
6 LASK LASK 36 54 47 53
7 SV Ried SV Ried 36 38 53 38
8 SCR Altach SCR Altach 36 37 64 36
9 Austria Karnten Austria 36 26 58 33
10 Wacker Innsbruck Wacker 36 32 63 29
TEMPORADA 2006/2007
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 36 72 25 75
2 SV Ried SV Ried 36 47 42 56
3 Mattersburg Mattersburg 36 61 58 55
4 Rapid Wien Rapid Wien 36 55 49 52
5 SV Pasching SV Pasching 36 47 41 52
6 Austria Wien Austria Wien 36 43 43 45
7 Sturm Graz Sturm Graz 36 40 40 41
8 SCR Altach SCR Altach 36 45 64 38
9 Wacker Innsbruck Wacker 36 40 64 34
10 Grazer AK Grazer AK 36 43 67 6
TEMPORADA 2005/2006
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 36 51 33 67
2 Salzburg Salzburg 36 62 42 63
3 SV Pasching SV Pasching 36 43 32 58
4 SV Ried SV Ried 36 48 47 52
5 Rapid Wien Rapid Wien 36 51 41 49
6 Grazer AK Grazer AK 36 47 48 45
7 Mattersburg Mattersburg 36 40 54 44
8 Sturm Graz Sturm Graz 36 44 51 42
9 Wacker Innsbruck Wacker 36 44 55 42
10 Admira Admira 36 42 69 33
TEMPORADA 2004/2005
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Rapid Wien Rapid Wien 36 67 31 71
2 Grazer AK Grazer AK 36 58 28 70
3 Austria Wien Austria Wien 36 64 24 69
4 SV Pasching SV Pasching 36 53 48 60
5 Mattersburg Mattersburg 36 48 58 45
6 Wacker Innsbruck Wacker 36 48 48 44
7 Sturm Graz Sturm Graz 36 37 47 40
8 Admira Admira 36 36 63 38
9 Salzburg Salzburg 36 37 51 36
10 SW Bregenz SW Bregenz 36 30 80 21

  USO DE MEMORIA  
6,895,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1976
Total Execution Time  0.1988
  CADENA URL  
/historico/Salzburgo/2021
  GET DATOS  
$_GET['/historico/Salzburgo/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (56)  
0.0038  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 = 'Salzburgo' 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.0020  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=3698 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=3698 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=3698 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=3698 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=3698 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=3698 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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=3698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0059  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 = 59175
0.0024  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 = 58504
0.0023  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 = 61918
0.0026  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 = 58620
0.0024  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 = 57797
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3698 AND type_rel = 2
0.0029  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3698 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (2898,5070,9022,18982,19087) ORDER BY n.cover_points DESC, update_date DESC
0.0042  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 = '3698' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0058  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 = '3698' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 58504 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 = 58620 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018  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 = 59175 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 57797 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043  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=3698 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (66905,66133,63190,62807,62629,60338) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 66905 AND teamId = 3698
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 66133 AND teamId = 3698
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 60338 AND teamId = 3698
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 62629 AND teamId = 3698
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 63190 AND teamId = 3698
0.0101  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 3698
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 `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 = 59175 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0038  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 = 59175 WHERE rp.league_id = 59175 AND rp.teamId = 3698 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.0053  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 = 59175 WHERE rp.league_id = 59175 AND rp.teamId = 3698 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 59175 WHERE rp.league_id = 59175 AND rp.teamId = 3698 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0050  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 = 3698 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 58504 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.0020  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 = 61918 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.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 `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 = 50148 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.0021  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 = 55611 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.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 `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 = 49411 AND t.round = 10 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 `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 = 43673 AND t.round = 22 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 `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 = 38775 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 29662 AND t.round = 36 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 = 15404 AND t.round = 36 ORDER BY team.conference 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 `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 = 3813 AND t.round = 36 ORDER BY team.conference 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 `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 = 2482 AND t.round = 36 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 `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 = 2014 AND t.round = 36 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 `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 = 1364 AND t.round = 36 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 `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 = 1093 AND t.round = 36 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 `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 = 870 AND t.round = 36 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 `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 = 321 AND t.round = 36 ORDER BY team.conference 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 `tables2008` 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 = 67 AND t.round = 36 ORDER BY team.conference 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 `tables2007` 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 = 341 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2005` 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 = 343 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 59175 ORDER BY nameShow LIMIT 100