4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Schwaz
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Austria Salzburg Austria 22 60 23 49
2 Hohenems Hohenems 22 53 26 43
3 Pinzgau Saalfelden Pinzgau 22 40 21 43
4 Reichenau Reichenau 23 44 24 40
5 Imst Imst 23 48 42 38
6 Mötz / Silz Mötz Silz 22 60 44 37
7 SC Rheindorf Altach II Rheindorf 22 37 27 36
8 Wals-Grünau Wals-Grünau 23 36 37 36
9 Bischofshofen Bischofshofe 23 47 38 33
10 Schwaz Schwaz 22 31 31 27
11 Kufstein Kufstein 23 22 39 25
12 Röthis Röthis 22 25 36 24
13 St. Johann St. Johann 22 28 41 22
14 Wolfurt Wolfurt 23 29 59 18
15 Dornbirner SV Dornbirner 22 25 51 14
16 Rot-Weiß Rankweil Rot-Weiß 22 22 68 13
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 7
Equipo PJ GF GC Puntos
1 Mötz / Silz Mötz Silz 8 11 21 35
2 Imst Imst 8 19 14 31
3 Schwaz Schwaz 8 14 12 30
4 Fügen Fügen 8 22 14 28
5 Telfs Telfs 8 11 16 23
6 Swarovski Tirol II Swarovski 8 17 8 28
7 Kitzbühel Kitzbühel 8 13 12 26
8 Wörgl Wörgl 8 9 7 23
9 Kundl Kundl 8 6 13 17
10 SV Hall SV Hall 8 8 13 12
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 4
Equipo PJ GF GC Puntos
1 Kitzbühel Kitzbühel 16 34 13 33
2 Wörgl Wörgl 15 36 27 31
3 Imst Imst 14 34 20 26
4 Kufstein Kufstein 15 30 19 26
5 Reichenau Reichenau 15 25 17 24
6 FC Wacker Innsbruck II Wacker 14 30 21 22
7 Schwaz Schwaz 14 25 28 18
8 Swarovski Tirol II Swarovski 15 28 45 16
9 Telfs Telfs 17 27 35 15
10 SV Hall SV Hall 15 12 56 0
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Wörgl Wörgl 18 45 16 36
2 Schwaz Schwaz 18 43 34 33
3 Reichenau Reichenau 18 46 32 29
4 SV Hall SV Hall 18 35 26 28
5 Kitzbühel Kitzbühel 18 36 25 27
6 Imst Imst 18 32 34 27
7 Telfs Telfs 18 38 38 26
8 Kufstein Kufstein 18 22 38 21
9 Zirl Zirl 18 30 53 12
10 FC Wacker Innsbruck II Wacker 18 23 54 9
TEMPORADA 2018/2019
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dornbirn Dornbirn 30 70 23 72
2 Kitzbühel Kitzbühel 30 59 28 65
3 USK Anif USK Anif 30 98 37 61
4 Kufstein Kufstein 30 55 31 55
5 Seekirchen Seekirchen 30 57 45 51
6 St. Johann St. Johann 30 66 43 50
7 Schwaz Schwaz 30 47 42 47
8 Wörgl Wörgl 30 60 59 43
9 Reichenau Reichenau 30 50 45 42
10 Grödig Grödig 30 38 46 38
11 Hohenems Hohenems 30 52 70 30
12 Wals-Grünau Wals-Grünau 30 34 55 30
13 SC Rheindorf Altach II Rheindorf 30 31 49 28
14 Pinzgau Saalfelden Pinzgau 30 38 73 25
15 Langenegg Langenegg 30 35 89 22
16 Bischofshofen Bischofshofe 30 31 86 19
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 USK Anif USK Anif 30 92 24 67
2 Grödig Grödig 30 73 27 61
3 Schwaz Schwaz 30 49 33 53
4 SC Rheindorf Altach II Rheindorf 30 63 45 49
5 Kitzbühel Kitzbühel 30 58 39 47
6 Dornbirn Dornbirn 30 40 42 43
7 Wals-Grünau Wals-Grünau 30 58 53 42
8 FC Wacker Innsbruck II Wacker 30 48 50 41
9 Hohenems Hohenems 30 51 61 41
10 Kufstein Kufstein 30 56 53 38
11 St. Johann St. Johann 30 48 55 36
12 Seekirchen Seekirchen 30 46 54 36
13 Wörgl Wörgl 30 45 59 34
14 Hard Hard 30 37 62 29
15 Pinzgau Saalfelden Pinzgau 30 35 74 24
16 Alberschwende Alberschwend 30 28 96 13
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
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
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Schwaz Schwaz 30 81 38 67
2 Kitzbühel Kitzbühel 30 69 41 58
3 Reichenau Reichenau 30 52 36 56
4 SV Hall SV Hall 30 53 37 55
5 Matrei Matrei 30 74 46 53
6 Imst Imst 30 43 37 44
7 Union Innsbruck Union 30 51 48 44
8 SV Innsbruck Innsbruck 30 59 54 43
9 Kirchbichl Kirchbichl 30 61 64 43
10 Reutte Reutte 30 42 50 40
11 Fügen Fügen 30 45 52 37
12 Kundl Kundl 30 54 61 34
13 Völs Völs 30 43 62 27
14 Mötz / Silz Mötz Silz 30 26 54 26
15 Kematen Kematen 30 50 80 25
16 SV Kolsass Weer Kolsass Weer 30 44 87 20
TEMPORADA 2011/2012
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Reichenau Reichenau 30 79 29 64
2 Imst Imst 30 58 29 57
3 Schwaz Schwaz 30 66 42 53
4 SV Innsbruck Innsbruck 30 96 65 49
5 Völs Völs 30 56 42 49
6 Matrei Matrei 30 83 59 48
7 Reutte Reutte 30 70 50 43
8 Kirchbichl Kirchbichl 30 73 63 41
9 Kematen Kematen 30 70 59 40
10 Kundl Kundl 30 58 53 39
11 Kitzbühel Kitzbühel 30 54 52 39
12 SV Kolsass Weer Kolsass Weer 30 63 71 39
13 SV Absam SV Absam 30 55 56 37
14 Telfs Telfs 30 45 56 36
15 SK St. Johann Johann 30 52 79 34
16 Axams / Götzens Axams 30 7 180 1
TEMPORADA 2010/2011
CUARTA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 SV Hall SV Hall 30 93 23 77
2 Kundl Kundl 30 76 48 57
3 Matrei Matrei 30 81 60 56
4 Schwaz Schwaz 30 64 38 55
5 Reutte Reutte 30 63 52 51
6 Axams / Götzens Axams 30 58 48 46
7 Kitzbühel Kitzbühel 30 44 43 43
8 Imst Imst 30 43 47 43
9 SV Innsbruck Innsbruck 30 78 60 41
10 Kirchbichl Kirchbichl 30 63 54 40
11 SK St. Johann Johann 30 49 78 33
12 Telfs Telfs 30 35 52 30
13 SV Absam SV Absam 30 47 66 27
14 Innsbrucker AC Innsbrucker 30 46 89 27
15 Jenbach Jenbach 30 37 61 23
16 Hippach Hippach 30 32 90 22
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
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dornbirn Dornbirn 30 62 25 63
2 WSG Tirol WSG Tirol 30 85 39 58
3 USK Anif USK Anif 30 52 29 58
4 Hard Hard 30 77 35 56
5 SW Bregenz SW Bregenz 30 77 46 53
6 Kufstein Kufstein 30 66 46 49
7 Reichenau / Union Reichenau 30 63 55 44
8 Axams / Götzens Axams 30 62 61 43
9 St. Johann St. Johann 30 43 41 41
10 Hohenems Hohenems 30 48 48 41
11 Seekirchen Seekirchen 30 49 53 37
12 Schwaz Schwaz 30 42 50 37
13 Blau-Weiß Feldkirch Blau-Weiß 30 36 56 33
14 SV Hall SV Hall 30 36 60 32
15 FC Höchst FC Höchst 30 34 59 31
16 Rot-Weiß Rankweil Rot-Weiß 30 13 142 0

  USO DE MEMORIA  
6,723,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1383
Total Execution Time  0.1402
  CADENA URL  
/historico/Schwaz
  GET DATOS  
$_GET['/historico/Schwaz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0029  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 = 'Schwaz' 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=12427 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=12427 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=12427 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 72355
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12427 AND type_rel = 2
0.0025  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 = '12427' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '12427' 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 = '12427' 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.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=12427 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,71432,68059) 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 = 72355 AND teamId = 12427
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 68059 AND teamId = 12427
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12427
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 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 = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024  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 = '12427' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12427' and rp.type = 4
0.0023  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 = '12427' 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 = 12427 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 = 12427 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 12427 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 12427 AND l.year <= 2024 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 `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 = 23 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 = 68178 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 `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 = 71435 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.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 `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 = 63400 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 `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 = 57021 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 = 51816 AND t.round = 3 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 = 50649 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 `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 = 44210 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 `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 = 38884 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.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 `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.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 `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.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 = 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.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 `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 = 27167 AND t.round = 30 ORDER BY team.conference 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 `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 = 27194 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037  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 = 27214 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC