4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
CUARTA AUSTRIA GRUPO 10
Equipo PJ GF GC Puntos
1 Kitzbühel Kitzbühel 3 8 2 30
2 Swarovski Tirol II Swarovski 3 13 2 26
3 SK St. Johann Johann 3 2 9 25
4 Volders Volders 3 4 8 24
5 Ebbs Ebbs 3 2 2 21
6 Fügen Fügen 3 1 7 18
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 1
Equipo PJ GF GC Puntos
1 Schwaz Schwaz 22 40 23 47
2 Telfs Telfs 22 55 30 42
3 Wörgl Wörgl 22 55 25 40
4 Reichenau Reichenau 22 38 25 38
5 Kitzbühel Kitzbühel 22 43 29 38
6 Kufstein Kufstein 22 48 44 33
7 Imst Imst 22 40 35 30
8 FC Wacker Innsbruck II Wacker 22 46 48 29
9 SV Hall SV Hall 22 32 53 24
10 Fügen Fügen 22 36 64 21
11 Swarovski Tirol II Swarovski 22 36 57 19
12 SV Innsbruck Innsbruck 22 26 62 12
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
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Kitzbühel Kitzbühel 30 78 28 67
2 Telfs Telfs 30 68 29 64
3 Reichenau Reichenau 30 68 34 64
4 Imst Imst 30 56 37 48
5 Swarovski Tirol II Swarovski 30 60 52 45
6 Zirl Zirl 30 51 51 45
7 Kirchbichl Kirchbichl 30 56 64 45
8 SV Innsbruck Innsbruck 30 40 45 43
9 SV Hall SV Hall 30 42 37 40
10 Kematen Kematen 30 52 56 37
11 Kundl Kundl 30 33 44 37
12 Mötz / Silz Mötz Silz 30 54 75 36
13 Union Innsbruck Union 30 54 58 34
14 Völs Völs 30 45 71 33
15 Fügen Fügen 30 27 52 26
16 Ebbs Ebbs 30 38 89 11
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
CUARTA AUSTRIA GRUPO 6
Equipo PJ GF GC Puntos
1 Kitzbühel Kitzbühel 30 90 32 72
2 Reichenau Reichenau 30 89 34 68
3 Matrei Matrei 30 76 53 54
4 Imst Imst 30 60 44 51
5 Kirchbichl Kirchbichl 30 67 51 49
6 Union Innsbruck Union 30 68 54 49
7 Reutte Reutte 30 52 46 45
8 SV Hall SV Hall 30 37 40 42
9 SV Innsbruck Innsbruck 30 50 64 40
10 Fügen Fügen 30 52 47 39
11 Völs Völs 30 57 65 38
12 Kundl Kundl 30 41 67 36
13 Mötz / Silz Mötz Silz 30 45 71 27
14 Zirl Zirl 30 35 67 26
15 Hippach Hippach 30 33 76 25
16 Neustift Neustift 30 35 76 17
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
CUARTA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Reichenau / Union II Reichenau 30 75 35 67
2 Matrei Matrei 30 81 47 63
3 Imst Imst 30 63 44 57
4 SV Hall SV Hall 30 61 35 50
5 Jenbach Jenbach 30 54 44 48
6 Kirchbichl Kirchbichl 30 60 52 46
7 SV Innsbruck Innsbruck 30 46 46 45
8 Innsbrucker AC Innsbrucker 30 50 39 43
9 Kitzbühel Kitzbühel 30 54 52 42
10 SV Absam SV Absam 30 51 49 40
11 Kundl Kundl 30 68 68 36
12 Telfs Telfs 30 48 60 35
13 Fügen Fügen 30 43 58 32
14 Längenfeld Längenfeld 30 33 62 23
15 FC Söll FC Söll 30 36 90 21
16 Kirchberg Kirchberg 30 31 73 20

  USO DE MEMORIA  
6,311,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6640
Total Execution Time  0.6652
  CADENA URL  
/historico/Kitzbuhel
  GET DATOS  
$_GET['/historico/Kitzbuhel']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0175  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 = 'Kitzbuhel' 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.0131  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=19090 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=19090 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=19090 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0254  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 = 75883
0.0131  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 = 73014
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19090 AND type_rel = 2
0.0130  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 = '19090' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '19090' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 75883 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=19090 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75883,71435,67320) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71435 AND teamId = 19090
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 75883 AND teamId = 19090
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 19090
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 `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 = 75883 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '19090' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19090' and rp.type = 4
0.0127  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 = '19090' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128  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 = 75883 WHERE rp.league_id = 75883 AND rp.teamId = 19090 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.0126  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 = 75883 WHERE rp.league_id = 75883 AND rp.teamId = 19090 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 75883 WHERE rp.league_id = 75883 AND rp.teamId = 19090 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 19090 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73014 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.0127  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 = 75883 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.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 `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.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 `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.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 `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 = 67265 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.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 `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.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 = 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.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 `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.0142  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.0138  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.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 `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 = 33431 AND t.round = 30 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 `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.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 `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.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 `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 = 27172 AND t.round = 30 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 `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.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 `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.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 `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
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 `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 = 27223 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 75883 ORDER BY nameShow LIMIT 100