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

  USO DE MEMORIA  
5,928,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5218
Total Execution Time  0.5231
  CADENA URL  
/historico/Fugen
  GET DATOS  
$_GET['/historico/Fugen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0114  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 = 'Fugen' 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.0105  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=19370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=19370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=19370 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0214  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.0111  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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19370 AND type_rel = 2
0.0109  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 = '19370' ORDER BY l.year DESC,cat.coefficient DESC
0.0108  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 = '19370' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109  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 = '19370' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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.0109  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=19370 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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,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.0108  SELECT count(id) as num_players from rel_players WHERE league_id = 71435 AND teamId = 19370
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 75883 AND teamId = 19370
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 68059 AND teamId = 19370
0.0107  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 = 2 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0107  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 = '19370' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19370' and rp.type = 4
0.0107  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 = '19370' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0109  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 = 19370 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.0107  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 = 19370 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107  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 = 19370 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109  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 = 19370 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108  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.0107  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 = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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.0108  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.0108  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.0108  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 = 67294 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.0109  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 = 57778 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 50453 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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.0109  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 = 15769 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 3940 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115  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.0112  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.0111  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.0112  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 = 27257 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC