4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
BUNDESLIGA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Salzburg Salzburg 22 45 12 50
2 Sturm Graz Sturm Graz 22 37 15 46
3 LASK LASK 22 26 18 35
4 TSV Hartberg Hartberg 22 33 28 34
5 Austria Klagenfurt Austria 22 29 27 34
6 Rapid Wien Rapid Wien 22 38 21 33
7 Austria Wien Austria Wien 22 25 22 33
8 Wolfsberger AC Wolfsberger 22 29 32 30
9 SCR Altach SCR Altach 22 17 30 19
10 Blau-Weiß Linz Blau-Weiß 22 22 38 19
11 WSG Tirol WSG Tirol 22 20 42 14
12 Austria Lustenau Austria 22 13 49 10
TEMPORADA 2022/2023
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Wolfsberger AC Wolfsberger 32 51 51 31
2 Austria Lustenau Austria 32 50 54 29
3 WSG Tirol WSG Tirol 32 44 53 24
4 TSV Hartberg Hartberg 32 39 56 24
5 SCR Altach SCR Altach 32 29 53 19
6 SV Ried SV Ried 32 27 50 14
TEMPORADA 2021/2022
BUNDESLIGA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 10 16 16 28
2 LASK LASK 10 16 13 26
3 SCR Altach SCR Altach 10 14 11 22
4 TSV Hartberg Hartberg 10 14 12 22
5 SV Ried SV Ried 10 9 13 22
6 Admira Admira 10 11 15 21
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 3
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 10 16 11 34
2 SCR Altach SCR Altach 10 11 9 26
3 SKN St. Polten Polten 10 18 11 25
4 Mattersburg Mattersburg 10 13 12 21
5 Admira Admira 10 7 14 18
6 WSG Tirol WSG Tirol 10 8 16 16
TEMPORADA 2018/2019
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 59 26 65
2 SV Ried SV Ried 30 61 21 63
3 Austria Lustenau Austria 30 55 34 50
4 Kapfenberger SV Kapfenberger 30 44 40 46
5 Blau-Weiß Linz Blau-Weiß 30 46 48 44
6 Wiener Neustadt Wiener 30 39 41 44
7 FC Juniors OÖ Juniors 30 52 55 42
8 Austria Klagenfurt Austria 30 43 35 41
9 FC Wacker Innsbruck II Wacker 30 40 44 41
10 FAC Wien FAC Wien 30 35 41 41
11 SKU Amstetten Amstetten 30 45 43 36
12 Liefering Liefering 30 50 54 35
13 Austria Wien II Austria Wien 30 46 62 34
14 SV Lafnitz SV Lafnitz 30 36 42 33
15 Horn Horn 30 33 62 25
16 Vorwarts Steyr Vorwarts 30 32 68 21
TEMPORADA 2017/2018
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 60 31 71
2 TSV Hartberg Hartberg 36 63 34 68
3 Wiener Neustadt Wiener 36 53 37 62
4 SV Ried SV Ried 36 68 41 61
5 Liefering Liefering 36 58 44 55
6 Austria Lustenau Austria 36 48 52 45
7 WSG Tirol WSG Tirol 36 45 56 40
8 Kapfenberger SV Kapfenberger 36 40 68 35
9 FAC Wien FAC Wien 36 37 75 30
10 Blau-Weiß Linz Blau-Weiß 36 35 69 26
TEMPORADA 2016/2017
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 LASK LASK 36 77 42 77
2 Liefering Liefering 36 58 49 60
3 Austria Lustenau Austria 36 58 49 57
4 Wacker Innsbruck Wacker 36 58 53 54
5 WSG Tirol WSG Tirol 36 56 54 51
6 Kapfenberger SV Kapfenberger 36 47 57 41
7 Blau-Weiß Linz Blau-Weiß 36 41 45 39
8 Wiener Neustadt Wiener 36 40 62 39
9 FAC Wien FAC Wien 36 39 48 38
10 Horn Horn 36 42 57 33
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 81 18 75
2 USK Anif USK Anif 30 76 46 57
3 St. Johann St. Johann 30 59 32 55
4 Dornbirn Dornbirn 30 58 39 50
5 Schwaz Schwaz 30 44 40 46
6 USC Eugendorf Eugendorf 30 56 63 43
7 FC Wacker Innsbruck II Wacker 30 54 45 42
8 Pinzgau Saalfelden Pinzgau 30 51 59 39
9 Seekirchen Seekirchen 30 50 58 39
10 SC Rheindorf Altach II Rheindorf 30 33 48 38
11 Kufstein Kufstein 30 43 45 37
12 Hard Hard 30 35 42 36
13 TSV Neumarkt Neumarkt 30 43 61 36
14 SW Bregenz SW Bregenz 30 42 63 33
15 Kitzbühel Kitzbühel 30 53 59 32
16 Reichenau Reichenau 30 28 88 13
TEMPORADA 2014/2015
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 30 71 23 73
2 WSG Tirol WSG Tirol 30 81 22 69
3 St. Johann St. Johann 30 51 35 47
4 USC Eugendorf Eugendorf 30 53 48 47
5 Kitzbühel Kitzbühel 30 46 40 43
6 TSV Neumarkt Neumarkt 30 51 58 43
7 Dornbirn Dornbirn 30 46 43 41
8 Kufstein Kufstein 30 56 59 41
9 Seekirchen Seekirchen 30 40 46 40
10 Schwaz Schwaz 30 42 37 39
11 FC Wacker Innsbruck II Wacker 30 58 61 38
12 Pinzgau Saalfelden Pinzgau 30 47 49 37
13 Hard Hard 30 41 50 32
14 SC Rheindorf Altach II Rheindorf 30 33 70 31
15 Bizau Bizau 30 27 68 29
16 FC Höchst FC Höchst 30 20 54 19
TEMPORADA 2013/2014
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 30 96 15 79
2 WSG Tirol WSG Tirol 30 88 36 70
3 TSV Neumarkt Neumarkt 30 67 41 53
4 St. Johann St. Johann 30 59 57 47
5 SC Rheindorf Altach II Rheindorf 30 51 51 46
6 Schwaz Schwaz 30 45 42 45
7 FC Wacker Innsbruck II Wacker 30 51 61 40
8 Kufstein Kufstein 30 49 58 36
9 Dornbirn Dornbirn 30 50 51 34
10 Seekirchen Seekirchen 30 44 48 34
11 Hard Hard 30 38 65 34
12 FC Höchst FC Höchst 30 35 51 33
13 USC Eugendorf Eugendorf 30 44 69 33
14 USK Anif USK Anif 30 43 56 31
15 SW Bregenz SW Bregenz 30 50 75 29
16 Wals-Grünau Wals-Grünau 30 36 70 27
TEMPORADA 2012/2013
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Liefering Liefering 30 94 23 74
2 Austria Salzburg Austria 30 77 21 68
3 WSG Tirol WSG Tirol 30 73 49 59
4 Kufstein Kufstein 30 70 41 54
5 SW Bregenz SW Bregenz 30 57 43 48
6 USK Anif USK Anif 30 50 43 47
7 Seekirchen Seekirchen 30 43 44 43
8 Dornbirn Dornbirn 30 48 51 41
9 FC Wacker Innsbruck II Wacker 30 60 60 40
10 St. Johann St. Johann 30 39 44 37
11 SC Rheindorf Altach II Rheindorf 30 41 49 36
12 TSV Neumarkt Neumarkt 30 47 69 34
13 Hard Hard 30 36 64 32
14 Wals-Grünau Wals-Grünau 30 37 69 23
15 Andelsbuch Andelsbuch 30 32 75 23
16 Pinzgau Saalfelden Pinzgau 30 27 86 13
TEMPORADA 2011/2012
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 WSG Tirol WSG Tirol 30 67 14 76
2 USK Anif USK Anif 30 82 38 70
3 Dornbirn Dornbirn 30 72 30 64
4 RB Juniors Salzburg Juniors 30 72 48 52
5 Kufstein Kufstein 30 58 44 46
6 FC Wacker Innsbruck II Wacker 30 58 53 45
7 SC Rheindorf Altach II Rheindorf 30 50 44 40
8 Austria Salzburg Austria 30 54 54 40
9 St. Johann St. Johann 30 43 48 39
10 SW Bregenz SW Bregenz 30 47 45 38
11 Pinzgau Saalfelden Pinzgau 30 50 55 38
12 Hard Hard 30 39 66 32
13 TSV Neumarkt Neumarkt 30 44 71 31
14 Union Innsbruck Union 30 35 87 24
15 Seekirchen Seekirchen 30 33 65 20
16 SV Hall SV Hall 30 27 69 18
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 RB Juniors Salzburg Juniors 30 78 23 68
2 WSG Tirol WSG Tirol 30 64 40 59
3 USK Anif USK Anif 30 66 37 55
4 Kufstein Kufstein 30 67 45 55
5 Austria Salzburg Austria 30 61 37 54
6 Dornbirn Dornbirn 30 62 35 53
7 SW Bregenz SW Bregenz 30 58 51 43
8 FC Wacker Innsbruck II Wacker 30 56 60 40
9 St. Johann St. Johann 30 39 41 39
10 Hard Hard 30 49 57 38
11 SC Rheindorf Altach II Rheindorf 30 49 62 37
12 TSV Neumarkt Neumarkt 30 34 61 33
13 Union Innsbruck Union 30 39 74 29
14 Seekirchen Seekirchen 30 48 75 28
15 Reichenau Reichenau 30 52 82 23
16 FC Höchst FC Höchst 30 35 77 15
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Grödig Grödig 30 100 23 76
2 WSG Tirol WSG Tirol 30 78 39 61
3 USK Anif USK Anif 30 82 47 59
4 FC Wacker Innsbruck II Wacker 30 64 46 53
5 Kufstein Kufstein 30 69 51 51
6 Seekirchen Seekirchen 30 70 54 51
7 SW Bregenz SW Bregenz 30 76 44 50
8 Hard Hard 30 82 53 49
9 St. Johann St. Johann 30 66 64 42
10 TSV Neumarkt Neumarkt 30 48 57 40
11 Reichenau / Union Reichenau 30 73 75 36
12 SC Rheindorf Altach II Rheindorf 30 43 62 36
13 Schwaz Schwaz 30 37 64 33
14 Blau-Weiß Feldkirch Blau-Weiß 30 50 78 28
15 Axams / Götzens Axams 30 54 98 14
16 Hohenems Hohenems 30 19 156 1

  USO DE MEMORIA  
6,502,728 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2557
Total Execution Time  0.2579
  CADENA URL  
/historico/Wattens
  GET DATOS  
$_GET['/historico/Wattens']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0042  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 = 'Wattens' 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.0080  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=12423 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=12423 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=12423 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=12423 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=12423 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 75597
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12423 AND type_rel = 2
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12423 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (83095,668138,1042054) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '12423' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 75597 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 72330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0035  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=12423 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (75597,72330,71432) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 75597 AND teamId = 12423
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 12423
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12423
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 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 = 75597 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0047  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 = 75597 WHERE rp.league_id = 75597 AND rp.teamId = 12423 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.0083  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 = 75597 WHERE rp.league_id = 75597 AND rp.teamId = 12423 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 75597 WHERE rp.league_id = 75597 AND rp.teamId = 12423 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0051  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 = 12423 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0043  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 = 67768 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.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 `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 = 71333 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.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 `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 = 63138 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.0061  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 = 66906 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.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 `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.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 = 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.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 `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.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 `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 = 55612 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.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 `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 = 44020 AND t.round = 30 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 `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 = 38776 AND t.round = 36 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 `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 = 33336 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15760 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0057  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 = 4156 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 2768 AND t.round = 30 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 `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 = 24525 AND t.round = 30 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 `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 = 24528 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 `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 = 24534 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC