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 11
Equipo PJ GF GC Puntos
1 Innsbrucker AC Innsbrucker 2 7 2 16
2 Völs Völs 2 3 3 16
3 Kematen Kematen 1 1 1 14
4 Telfs Telfs 1 1 1 14
5 Kundl Kundl 2 2 2 9
6 Wörgl Wörgl 2 1 6 6
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 8
Equipo PJ GF GC Puntos
1 Imst Imst 8 32 9 36
2 Wörgl Wörgl 8 16 15 33
3 Kitzbühel Kitzbühel 8 12 15 29
4 Reichenau Reichenau 8 10 20 27
5 Kufstein Kufstein 8 12 23 22
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 6
Equipo PJ GF GC Puntos
1 Dornbirner SV Dornbirner 0 0 0 0
2 Hohenems Hohenems 0 0 0 0
3 Pinzgau Saalfelden Pinzgau 0 0 0 0
4 Salzburger AK Salzburger 0 0 0 0
5 Schwaz Schwaz 0 0 0 0
6 Wörgl Wörgl 0 0 0 0
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
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 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
TEMPORADA 2004/2005
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 SV Ried SV Ried 36 79 38 77
2 Kapfenberger SV Kapfenberger 36 64 37 71
3 FC Kärnten FC Kärnten 36 68 41 58
4 Austria Lustenau Austria 36 55 43 56
5 Leoben Leoben 36 43 49 47
6 SCR Altach SCR Altach 36 37 45 41
7 LASK LASK 36 38 64 39
8 Untersiebenbrunn Untersiebenb 36 45 66 34
9 Gratkorn Gratkorn 36 43 58 32
10 Wörgl Wörgl 36 32 63 32
TEMPORADA 2003/2004
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Wacker Innsbruck Wacker 36 65 44 72
2 Austria Lustenau Austria 36 55 36 65
3 Kapfenberger SV Kapfenberger 36 68 55 60
4 Untersiebenbrunn Untersiebenb 36 61 48 60
5 SV Ried SV Ried 36 60 43 56
6 Leoben Leoben 36 44 44 46
7 LASK LASK 36 46 55 44
8 Wörgl Wörgl 36 48 66 37
9 FC Lustenau FC Lustenau 36 40 58 31
10 BSV Juniors BSV Juniors 36 31 69 24
TEMPORADA 2002/2003
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Mattersburg Mattersburg 36 58 33 70
2 Leoben Leoben 36 69 57 57
3 Austria Lustenau Austria 36 41 40 53
4 Untersiebenbrunn Untersiebenb 36 59 58 52
5 LASK LASK 36 47 47 49
6 Kapfenberger SV Kapfenberger 36 50 49 48
7 FC Lustenau FC Lustenau 36 53 53 46
8 Wörgl Wörgl 36 44 58 45
9 Bad Bleiberg Bleiberg 36 49 60 44
10 Wiener SC Wiener SC 36 56 71 42
TEMPORADA 2001/2002
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 FC Superfund Superfund 36 66 37 72
2 Austria Lustenau Austria 36 68 36 70
3 Bad Bleiberg Bleiberg 36 68 38 67
4 Untersiebenbrunn Untersiebenb 36 57 39 62
5 LASK LASK 36 45 38 52
6 Mattersburg Mattersburg 36 60 57 47
7 Leoben Leoben 36 51 51 46
8 Wörgl Wörgl 36 61 72 34
9 Braunau Braunau 36 25 85 24
10 FC Lustenau FC Lustenau 36 33 81 22
TEMPORADA 2000/2001
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 FC Kärnten FC Kärnten 36 71 34 70
2 Bad Bleiberg Bleiberg 36 71 42 68
3 Untersiebenbrunn Untersiebenb 36 61 56 57
4 Leoben Leoben 36 59 45 54
5 Austria Lustenau Austria 36 58 55 49
6 Wörgl Wörgl 36 58 69 45
7 Mattersburg Mattersburg 36 52 67 42
8 Braunau Braunau 36 46 67 41
9 First Vienna First Vienna 36 41 59 38
10 WSG Tirol WSG Tirol 36 39 62 34
TEMPORADA 1999/2000
SEGUNDA AUSTRIA
Equipo PJ GF GC Puntos
1 Admira Admira 36 70 29 77
2 Leoben Leoben 36 50 32 66
3 Wörgl Wörgl 36 58 41 62
4 Untersiebenbrunn Untersiebenb 36 50 31 57
5 FC Kärnten FC Kärnten 36 54 40 57
6 Braunau Braunau 36 42 37 51
7 First Vienna First Vienna 36 55 43 50
8 WSG Tirol WSG Tirol 36 52 66 38
9 VSE St. Polten Polten 34 25 58 30
10 Vorwarts Steyr Vorwarts 34 13 92 4

  USO DE MEMORIA  
6,189,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1109
Total Execution Time  0.1121
  CADENA URL  
/historico/Worgl
  GET DATOS  
$_GET['/historico/Worgl']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0055  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 = 75884
0.0035  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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59606 AND type_rel = 2
0.0034  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 = '59606' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73014 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = '59606' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0023  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59606' and rp.type = 4
0.0022  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 = '59606' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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 = 59606 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 = 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.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 `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 = 75884 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.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 = 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.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 = 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.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 `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.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 = 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.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 `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.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 `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 `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.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 `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.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 = 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.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 `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.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 `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.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 `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
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 `tables2005` 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 = 8914 AND t.round = 36 ORDER BY team.conference 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 `tables2004` 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 = 8912 AND t.round = 36 ORDER BY team.conference 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 `tables2003` 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 = 8911 AND t.round = 36 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 `tables2002` 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 = 8908 AND t.round = 36 ORDER BY team.conference 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 `tables2001` 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 = 8906 AND t.round = 36 ORDER BY team.conference 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 `tables2000` 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 = 10039 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC