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

Austria Salzburg

Entrenador: Christian Schaider

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 24 66 26 52
2 Hohenems Hohenems 24 55 28 46
3 Pinzgau Saalfelden Pinzgau 24 42 27 43
4 Mötz / Silz Mötz Silz 23 63 44 40
5 Reichenau Reichenau 24 44 25 40
6 SC Rheindorf Altach II Rheindorf 23 38 27 39
7 Imst Imst 24 50 44 39
8 Wals-Grünau Wals-Grünau 24 39 37 39
9 Bischofshofen Bischofshofe 24 52 38 36
10 Schwaz Schwaz 24 37 33 33
11 St. Johann St. Johann 24 33 44 26
12 Röthis Röthis 24 28 39 26
13 Kufstein Kufstein 23 22 39 25
14 Wolfurt Wolfurt 23 29 61 18
15 Dornbirner SV Dornbirner 24 25 59 14
16 Rot-Weiß Rankweil Rot-Weiß 24 25 77 13
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 10
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 8 17 13 40
2 St. Johann St. Johann 8 20 14 30
3 Seekirchen Seekirchen 8 9 9 26
4 Wals-Grünau Wals-Grünau 8 11 17 26
5 Kuchl Kuchl 8 10 14 20
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Schwaz Schwaz 10 23 7 25
2 St. Johann St. Johann 10 21 10 16
3 Austria Salzburg Austria 10 17 12 14
4 Telfs Telfs 10 12 19 12
5 Hohenems Hohenems 10 20 22 8
6 Admira Dornbirn Admira 10 11 34 8
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 14 21 15 28
2 Kuchl Kuchl 11 25 12 25
3 Seekirchen Seekirchen 14 24 23 23
4 Bischofshofen Bischofshofe 13 17 11 22
5 Grödig Grödig 13 23 24 18
6 USK Anif USK Anif 13 19 12 17
7 Pinzgau Saalfelden Pinzgau 13 18 19 16
8 St. Johann St. Johann 14 17 22 14
9 Salzburger AK Salzburger 12 15 26 12
10 Wals-Grünau Wals-Grünau 13 15 30 8
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Salzburger AK Salzburger 18 73 21 52
2 Pinzgau Saalfelden Pinzgau 18 46 13 42
3 Seekirchen Seekirchen 18 35 30 29
4 USK Anif USK Anif 18 40 37 27
5 Wals-Grünau Wals-Grünau 18 33 35 24
6 St. Johann St. Johann 18 28 39 24
7 Grödig Grödig 18 35 31 23
8 Austria Salzburg Austria 18 27 31 18
9 Kuchl Kuchl 18 25 41 13
10 Bischofshofen Bischofshofe 18 12 76 1
TEMPORADA 2018/2019
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Salzburger AK Salzburger 30 93 25 75
2 Austria Salzburg Austria 30 92 31 70
3 Kuchl Kuchl 30 66 37 61
4 TSV Neumarkt Neumarkt 30 77 48 57
5 Bürmoos Bürmoos 30 55 45 47
6 USC Eugendorf Eugendorf 30 61 47 46
7 Zell am See Zell am See 30 63 53 43
8 Golling Golling 30 59 69 38
9 Straßwalchen Straßwalche 30 48 46 37
10 Altenmarkt Altenmarkt 30 52 61 37
11 Thalgau Thalgau 30 64 75 34
12 Puch Puch 30 54 89 30
13 Bramberg Bramberg 30 59 82 29
14 Adnet Adnet 30 32 82 26
15 UFC Hallein UFC Hallein 30 41 85 25
16 SK Strobl SK Strobl 30 38 79 18
TEMPORADA 2017/2018
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Bischofshofen Bischofshofe 30 63 28 69
2 TSV Neumarkt Neumarkt 30 64 34 61
3 USC Eugendorf Eugendorf 30 69 50 55
4 Bürmoos Bürmoos 30 46 36 49
5 Zell am See Zell am See 30 63 46 47
6 Salzburger AK Salzburger 30 59 48 45
7 Austria Salzburg Austria 30 57 50 41
8 Bramberg Bramberg 30 39 44 41
9 Straßwalchen Straßwalche 30 58 55 39
10 SK Strobl SK Strobl 30 56 57 37
11 Kuchl Kuchl 30 49 57 36
12 Golling Golling 30 53 64 32
13 UFC Hallein UFC Hallein 30 37 60 30
14 Altenmarkt Altenmarkt 30 40 64 30
15 Hallwang Hallwang 30 39 68 30
16 Bergheim Bergheim 30 39 70 27
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 USK Anif USK Anif 30 99 28 80
2 Grödig Grödig 30 70 20 70
3 SC Rheindorf Altach II Rheindorf 30 48 48 48
4 St. Johann St. Johann 30 48 42 45
5 Schwaz Schwaz 30 46 39 44
6 FC Wacker Innsbruck II Wacker 30 48 46 43
7 Kufstein Kufstein 30 53 51 41
8 Dornbirn Dornbirn 30 33 43 39
9 Hohenems Hohenems 30 49 50 38
10 Seekirchen Seekirchen 30 51 57 38
11 Hard Hard 30 46 54 37
12 Pinzgau Saalfelden Pinzgau 30 33 47 34
13 Wörgl Wörgl 30 40 61 33
14 USC Eugendorf Eugendorf 30 40 66 30
15 Austria Salzburg Austria 30 43 62 23
16 Salzburger AK Salzburger 30 34 67 22
TEMPORADA 2015/2016
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SKN St. Polten Polten 36 68 34 80
2 LASK LASK 36 65 35 72
3 Wacker Innsbruck Wacker 36 61 47 59
4 Liefering Liefering 36 65 49 57
5 Austria Lustenau Austria 36 56 40 57
6 Kapfenberger SV Kapfenberger 36 63 62 50
7 Wiener Neustadt Wiener 36 39 49 45
8 Austria Klagenfurt Austria 36 43 62 34
9 Austria Salzburg Austria 36 45 73 32
10 FAC Wien FAC Wien 36 23 77 17
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
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 26 68 24 60
2 Hallwang Hallwang 26 50 26 55
3 USC Eugendorf Eugendorf 26 60 30 51
4 Pinzgau Saalfelden Pinzgau 26 56 29 50
5 Hallein Hallein 26 61 52 45
6 Salzburger AK Salzburger 26 54 36 40
7 Zell am See Zell am See 26 59 50 39
8 Straßwalchen Straßwalche 26 46 59 32
9 Piesendorf Piesendorf 26 39 58 26
10 Anthering Anthering 26 30 52 26
11 Puch Puch 26 32 51 25
12 Maria Saal Maria Saal 26 43 71 25
13 ASK PSV Salzburg Salzburg 26 29 61 23
14 Union Henndorf Union 26 44 72 19

  USO DE MEMORIA  
6,687,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1333
Total Execution Time  0.1345
  CADENA URL  
/historico/Sv-Austria-Salzburg
  GET DATOS  
$_GET['/historico/Sv-Austria-Salzburg']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0033  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 = 'Sv-Austria-Salzburg' 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.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=12421 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=12421 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=12421 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=12421 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12421 AND type_rel = 2
0.0028  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 = '12421' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '12421' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '12421' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 72355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=12421 AND l.year in (2023,2024,2025) 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 (72355,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 72355 AND teamId = 12421
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 12421
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12421
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 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 = 72355 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '12421' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12421' 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 = '12421' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 72355 WHERE rp.league_id = 72355 AND rp.teamId = 12421 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.0030  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 = 72355 WHERE rp.league_id = 72355 AND rp.teamId = 12421 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72355 WHERE rp.league_id = 72355 AND rp.teamId = 12421 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 = 12421 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68177 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 `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 = 71438 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.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 `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 = 63403 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.0036  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 = 67264 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.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 `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 = 57020 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.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 `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 = 50648 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.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 `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 = 44306 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 `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 = 38911 AND t.round = 30 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 = 33373 AND t.round = 30 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 `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 = 15704 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 `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.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 `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.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 `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.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 = 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.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 `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 = 24531 AND t.round = 30 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 `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 = 27237 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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 = 72355 ORDER BY nameShow LIMIT 100