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

Deutschlandsberger

Entrenador: Christoph Meier

Temporada 2023/2024
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Voitsberg Voitsberg 24 66 21 55
2 SV Wallern SV Wallern 24 54 37 44
3 Hertha Wels Hertha Wels 24 49 24 43
4 Gurten Gurten 24 34 19 41
5 FC Juniors OÖ Juniors 24 50 31 37
6 Weindorf St. Anna Weindorf 23 29 44 33
7 Gleisdorf Gleisdorf 24 36 33 32
8 Vorwarts Steyr Vorwarts 24 24 28 32
9 Deutschlandsberger Deutschlands 24 38 34 30
10 ASK Kla­gen­furt Kla­gen­fu 24 40 48 30
11 Weiz Weiz 23 36 44 30
12 Vöcklamarkt Vöcklamarkt 24 28 46 28
13 Allerheiligen Allerheilige 24 36 52 27
14 TUS Bad Gleichenberg Gleichenberg 24 37 55 26
15 Wolfsberger AC II Wolfsberger 24 35 54 24
16 SV Ried II SV Ried II 24 39 61 24
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Leoben Leoben 30 76 22 72
2 FC Juniors OÖ Juniors 30 84 30 69
3 Hertha Wels Hertha Wels 30 63 35 63
4 Gurten Gurten 30 44 29 55
5 TUS Bad Gleichenberg Gleichenberg 30 65 56 49
6 Deutschlandsberger Deutschlands 30 53 46 47
7 SV Ried II SV Ried II 30 47 47 47
8 Weindorf St. Anna Weindorf 30 48 53 39
9 Wolfsberger AC II Wolfsberger 30 49 48 36
10 Gleisdorf Gleisdorf 30 49 50 36
11 Vöcklamarkt Vöcklamarkt 30 29 44 33
12 Weiz Weiz 30 45 64 31
13 Allerheiligen Allerheilige 30 35 56 28
14 Treibach Treibach 30 37 65 25
15 Kalsdorf Kalsdorf 30 30 70 23
16 SAK Klagenfurt Klagenfurt 30 29 68 14
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Sturm Graz II Sturm Graz 32 105 29 72
2 Deutschlandsberger Deutschlands 32 62 26 63
3 Gurten Gurten 32 63 31 62
4 Hertha Wels Hertha Wels 32 64 34 56
5 WAC Sankt Andrä II Sankt Andrä 32 71 50 56
6 Vöcklamarkt Vöcklamarkt 32 46 41 52
7 TUS Bad Gleichenberg Gleichenberg 32 56 47 51
8 Allerheiligen Allerheilige 32 52 48 47
9 Weindorf St. Anna Weindorf 32 61 54 44
10 Gleisdorf Gleisdorf 32 50 53 44
11 Weiz Weiz 32 47 56 43
12 SV Ried II SV Ried II 32 50 63 36
13 Kalsdorf Kalsdorf 32 46 54 35
14 Treibach Treibach 32 56 73 35
15 Wels Wels 32 47 71 33
16 Spittal Spittal 32 25 60 18
17 Stadl-Paura Stadl-Paura 32 18 129 6
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Gleisdorf Gleisdorf 13 26 17 27
2 Weindorf St. Anna Weindorf 12 33 15 26
3 TUS Bad Gleichenberg Gleichenberg 13 31 18 26
4 Gurten Gurten 13 22 13 26
5 Hertha Wels Hertha Wels 14 34 23 25
6 Sturm Graz II Sturm Graz 13 23 17 23
7 Kalsdorf Kalsdorf 13 20 19 22
8 Wolfsberger AC II Wolfsberger 13 21 18 18
9 Weiz Weiz 13 24 20 16
10 Deutschlandsberger Deutschlands 13 29 27 16
11 Allerheiligen Allerheilige 11 26 24 13
12 SV Ried II SV Ried II 12 20 28 12
13 Stadl-Paura Stadl-Paura 13 20 32 11
14 Spittal Spittal 12 10 25 9
15 Vöcklamarkt Vöcklamarkt 13 11 28 8
16 Wels Wels 13 14 40 7
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sturm Graz II Sturm Graz 17 39 20 34
2 Allerheiligen Allerheilige 17 35 23 33
3 Hertha Wels Hertha Wels 17 42 26 32
4 Gurten Gurten 17 35 19 31
5 TUS Bad Gleichenberg Gleichenberg 17 44 33 29
6 Wolfsberger AC II Wolfsberger 17 39 30 29
7 Vöcklamarkt Vöcklamarkt 17 41 34 29
8 Weindorf St. Anna Weindorf 17 29 20 28
9 Weiz Weiz 17 37 29 27
10 Gleisdorf Gleisdorf 17 34 26 27
11 Deutschlandsberger Deutschlands 17 31 24 22
12 Kalsdorf Kalsdorf 17 18 28 20
13 SV Ried II SV Ried II 17 25 32 15
14 ATSV Wolfsberg ATSV 17 26 36 14
15 Stadl-Paura Stadl-Paura 17 15 72 7
16 Wels Wels 17 13 51 6
TEMPORADA 2018/2019
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Grazer AK Grazer AK 30 70 28 68
2 Gleisdorf Gleisdorf 30 62 37 54
3 TUS Bad Gleichenberg Gleichenberg 30 70 51 51
4 Vöcklamarkt Vöcklamarkt 30 61 48 51
5 Stadl-Paura Stadl-Paura 30 56 51 51
6 Allerheiligen Allerheilige 30 53 37 48
7 Sturm Graz II Sturm Graz 30 60 46 47
8 Wolfsberger AC II Wolfsberger 30 61 48 46
9 Weiz Weiz 30 65 54 45
10 Deutschlandsberger Deutschlands 30 57 52 44
11 Gurten Gurten 30 41 41 39
12 Hertha Wels Hertha Wels 30 56 64 38
13 Kalsdorf Kalsdorf 30 43 56 35
14 Völkermarkt Völkermarkt 30 31 73 20
15 Lendorf Lendorf 30 32 77 20
16 Wels Wels 30 30 85 16
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 70 16 67
2 Gleisdorf Gleisdorf 30 60 33 57
3 Vorwarts Steyr Vorwarts 30 70 38 55
4 FC Juniors OÖ Juniors 30 54 46 52
5 Austria Klagenfurt Austria 30 57 48 48
6 Allerheiligen Allerheilige 30 59 41 47
7 Vöcklamarkt Vöcklamarkt 30 52 43 47
8 Deutschlandsberger Deutschlands 30 50 43 47
9 Sturm Graz II Sturm Graz 30 45 48 42
10 TUS Bad Gleichenberg Gleichenberg 30 44 54 39
11 Gurten Gurten 30 45 46 37
12 Wolfsberger AC II Wolfsberger 30 41 63 33
13 Weiz Weiz 30 43 58 32
14 Kalsdorf Kalsdorf 30 36 52 29
15 Stadl-Paura Stadl-Paura 30 32 67 27
16 Union St. Florian Union 30 14 76 13
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 TSV Hartberg Hartberg 30 74 38 62
2 SV Lafnitz SV Lafnitz 30 54 27 60
3 Gleisdorf Gleisdorf 30 53 35 59
4 Stadl-Paura Stadl-Paura 30 75 53 51
5 Deutschlandsberger Deutschlands 30 65 45 46
6 Vorwarts Steyr Vorwarts 30 56 49 44
7 Kalsdorf Kalsdorf 30 38 35 44
8 Gurten Gurten 30 39 43 42
9 Union St. Florian Union 30 36 46 39
10 Sturm Graz II Sturm Graz 30 42 51 38
11 Weiz Weiz 30 40 52 38
12 Austria Klagenfurt Austria 30 43 61 35
13 Allerheiligen Allerheilige 30 46 60 33
14 SV Pasching SV Pasching 30 43 49 31
15 Grieskirchen Grieskirchen 30 44 64 23
16 ATSV Wolfsberg ATSV 30 25 65 19
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Blau-Weiß Linz Blau-Weiß 30 89 25 70
2 TSV Hartberg Hartberg 30 64 38 60
3 Union St. Florian Union 30 53 35 52
4 Kalsdorf Kalsdorf 30 56 43 51
5 SV Pasching SV Pasching 30 59 46 50
6 SV Lafnitz SV Lafnitz 30 62 52 49
7 Stadl-Paura Stadl-Paura 30 58 49 48
8 Allerheiligen Allerheilige 30 50 43 48
9 Deutschlandsberger Deutschlands 30 49 43 43
10 Gurten Gurten 30 51 44 40
11 Sturm Graz II Sturm Graz 30 48 48 38
12 Vorwarts Steyr Vorwarts 30 36 49 34
13 Weiz Weiz 30 33 66 26
14 Wolfsberger AC II Wolfsberger 30 34 64 23
15 SV Wallern SV Wallern 30 35 70 22
16 Annabichler Austria Annabichler 30 24 86 19
TEMPORADA 2014/2015
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Deutschlandsberger Deutschlands 30 84 35 68
2 TUS Heiligenkreuz Heiligenkreu 30 71 38 66
3 Gleisdorf Gleisdorf 30 60 46 48
4 Frohnleiten Frohnleiten 30 48 48 47
5 SV Union Gnas Union Gnas 30 55 43 45
6 Zeltweg Zeltweg 30 61 50 44
7 SV ADA Anger Anger 30 50 44 44
8 Kapfenberger SV KM II Kapfenberger 30 52 48 44
9 Voitsberg Voitsberg 30 51 53 44
10 Weindorf St. Anna Weindorf 30 58 61 38
11 Liezen Liezen 30 37 49 37
12 Lebring Lebring 30 34 43 36
13 Leoben Leoben 30 45 55 34
14 SC Fürstenfeld Fürstenfeld 30 46 56 32
15 SV Gleinstätten Gleinstätte 30 63 78 31
16 Gratkorn Gratkorn 30 27 95 9
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Weiz Weiz 30 71 19 72
2 Gleisdorf Gleisdorf 30 70 39 61
3 Deutschlandsberger Deutschlands 30 72 42 59
4 SV Gleinstätten Gleinstätte 30 56 43 53
5 SV Union Gnas Union Gnas 30 43 34 46
6 TUS Heiligenkreuz Heiligenkreu 30 65 59 45
7 Frohnleiten Frohnleiten 30 53 49 42
8 Voitsberg Voitsberg 30 47 45 41
9 Leoben Leoben 30 40 44 39
10 SC Fürstenfeld Fürstenfeld 30 45 45 37
11 Gratkorn Gratkorn 30 41 55 32
12 SV ADA Anger Anger 30 35 47 31
13 Liezen Liezen 30 38 55 31
14 Wildon Wildon 30 38 59 30
15 Grossklein Grossklein 30 27 65 20
16 Irdning Irdning 30 32 73 18
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 SV Lafnitz SV Lafnitz 30 80 36 63
2 Weiz Weiz 30 60 33 60
3 SV Gleinstätten Gleinstätte 30 61 41 53
4 Deutschlandsberger Deutschlands 30 58 49 51
5 Gleisdorf Gleisdorf 30 63 44 47
6 Frohnleiten Frohnleiten 30 47 48 47
7 SC Fürstenfeld Fürstenfeld 30 52 44 45
8 Voitsberg Voitsberg 30 50 39 42
9 Liezen Liezen 30 44 42 40
10 Wildon Wildon 30 43 62 38
11 TUS Heiligenkreuz Heiligenkreu 30 45 59 35
12 SV ADA Anger Anger 30 38 52 34
13 SV Pachern SV Pachern 30 50 60 32
14 Gratkorn II Gratkorn II 30 37 65 30
15 SVA Kindberg Kindberg 30 29 55 29
16 Zeltweg Zeltweg 30 33 61 25
TEMPORADA 2008/2009
CUARTA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 SVL Flavia Solva Flavia Solva 30 54 34 52
2 Kalsdorf Kalsdorf 29 56 38 52
3 SC Fürstenfeld Fürstenfeld 30 55 50 51
4 Gleisdorf Gleisdorf 30 47 40 50
5 Fehring Fehring 30 57 47 47
6 SV Gleinstätten Gleinstätte 30 64 48 46
7 SC Bruck SC Bruck 30 40 34 46
8 Köflach Köflach 30 52 49 41
9 Gratkorn II Gratkorn II 30 55 50 40
10 Wildon Wildon 30 40 47 39
11 Grazer AK II Grazer 30 53 46 37
12 Irdning Irdning 30 32 41 36
13 Kapfenberger SV KM II Kapfenberger 29 44 53 34
14 Grossklein Grossklein 30 40 52 34
15 Deutschlandsberger Deutschlands 30 40 64 32
16 Hartberg II Hartberg II 30 33 69 25

  USO DE MEMORIA  
6,759,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5991
Total Execution Time  0.6005
  CADENA URL  
/historico/Deutschlandsberger-Sc
  GET DATOS  
$_GET['/historico/Deutschlandsberger-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0136  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 = 'Deutschlandsberger-Sc' 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.0126  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=18091 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=18091 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=18091 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=18091 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 72354
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18091 AND type_rel = 2
0.0129  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 = '18091' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '18091' 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 = 72354 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=18091 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 (72354,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72354 AND teamId = 18091
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 18091
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18091
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 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 = 72354 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '18091' 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 = '18091' and rp.type = 4
0.0126  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 = '18091' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  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 = 72354 WHERE rp.league_id = 72354 AND rp.teamId = 18091 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.0135  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 = 72354 WHERE rp.league_id = 72354 AND rp.teamId = 18091 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 72354 WHERE rp.league_id = 72354 AND rp.teamId = 18091 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 18091 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72354 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 68176 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.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 = 63402 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 57019 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.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 `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 = 50223 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 44211 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 `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 = 38883 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 `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 = 33372 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 `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 = 15759 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 = 3939 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 `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 = 27166 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 = 27164 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 `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 = 27261 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 = 72354 ORDER BY nameShow LIMIT 100