4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Wismut Gera
TEMPORADA 2023/2024
LANDESLIGA GRUPO 15
Equipo PJ GF GC Puntos
1 FC An der Fahner Höhe Fahner Höhe 23 64 20 60
2 Wismut Gera Wismut Gera 24 69 22 56
3 Wacker Nordhausen Wacker 23 55 27 45
4 Schott Jena Schott Jena 24 51 25 42
5 FSV Schleiz FSV Schleiz 24 43 43 40
6 FC Thuringen Thuringen 23 49 34 39
7 Eichsfeld Eichsfeld 24 41 34 39
8 BW Neustadt / Orla Neustadt 24 47 46 38
9 Bad Langensalza Langensalza 24 38 47 33
10 SpVgg Geratal SpVgg 24 32 46 27
11 FC Union Mühlhausen Union 24 35 55 27
12 1.SC 1911 Heiligenstadt 1.SC 1911 H. 24 37 41 26
13 FC Saalfeld FC Saalfeld 23 35 49 20
14 Schweina-Gumpelstadt Schweina-Gum 24 39 67 17
15 Ohratal Ohrdruf Ohratal 23 28 58 11
16 Eintracht Sondershausen Eintracht 23 13 62 9
TEMPORADA 2022/2023
LANDESLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 SV 09 Arnstadt Arnstadt 30 70 31 65
2 Wismut Gera Wismut Gera 30 104 42 63
3 SGG Schweina Schweina 30 89 56 59
4 FC Thuringen Thuringen 30 70 37 57
5 FC Saalfeld FC Saalfeld 30 64 55 50
6 DJK Struth DJK Struth 30 74 68 48
7 Schott Jena Schott Jena 30 48 43 45
8 1.SC 1911 Heiligenstadt 1.SC 1911 H. 30 64 63 43
9 Bad Langensalza Langensalza 30 52 42 42
10 SpVgg Geratal SpVgg 30 42 53 38
11 FSV Martinroda Martinroda 30 56 74 33
12 FSV Schleiz FSV Schleiz 30 44 54 32
13 Eintracht Sondershausen Eintracht 30 42 69 29
14 SV Eintracht Eisenberg Eintracht 30 46 83 28
15 Erfurt-Nord Erfurt-Nord 30 36 76 25
16 TSV Gera Westvororte Gera 30 37 92 20
TEMPORADA 2018/2019
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Chemie Leipzig Chemie 30 65 29 69
2 Luckenwalde Luckenwalde 30 83 29 68
3 Eilenburg Eilenburg 30 62 36 57
4 International Leipzig Internationa 30 50 22 53
5 Wacker Nordhausen II Wacker 30 58 45 46
6 Carl Zeiss Jena II Carl Zeiss. 30 51 47 46
7 VfB Krieschow Krieschow 30 35 41 40
8 Einheit Rudolstadt Einheit 30 40 46 37
9 Ludwigsfelder FC Ludwigsfelde 30 37 41 36
10 Wismut Gera Wismut Gera 30 55 63 35
11 VFC Plauen VFC Plauen 30 44 46 34
12 VfL Halle VfL Halle 30 52 60 34
13 Union Sandersdorf Union 30 33 46 31
14 Askania Bernburg Askania 30 37 64 29
15 Hohenstein-Ernstthal Hohenstein-E 30 35 71 26
16 Blau-Weiß Zorbau Blau-Weiß 30 33 84 17
TEMPORADA 2017/2018
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Bischofswerdaer Bischofswerd 30 70 16 74
2 International Leipzig Internationa 30 59 21 62
3 Carl Zeiss Jena II Carl Zeiss. 30 67 39 60
4 VFC Plauen VFC Plauen 30 55 53 55
5 Eilenburg Eilenburg 30 50 34 48
6 Askania Bernburg Askania 30 59 38 47
7 Einheit Rudolstadt Einheit 30 56 43 46
8 VfB Krieschow Krieschow 30 61 64 39
9 VfL Halle VfL Halle 30 28 39 37
10 Union Sandersdorf Union 30 54 54 36
11 Wismut Gera Wismut Gera 30 41 54 34
12 Lok Stendal Lok Stendal 30 36 54 33
13 Barleben Barleben 30 35 54 33
14 Schott Jena Schott Jena 30 29 61 33
15 Kamenz Kamenz 30 36 51 23
16 SV 1899 Merseburg 1899 30 29 90 12
TEMPORADA 2016/2017
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Chemie Leipzig Chemie 30 69 21 71
2 Germania Halberstadt Germania 30 73 20 69
3 Bischofswerdaer Bischofswerd 30 62 21 66
4 Wismut Gera Wismut Gera 30 48 37 50
5 SV 1899 Merseburg 1899 30 44 44 50
6 Einheit Rudolstadt Einheit 30 47 38 49
7 International Leipzig Internationa 30 45 38 43
8 Carl Zeiss Jena II Carl Zeiss. 30 59 50 42
9 VFC Plauen VFC Plauen 30 48 41 41
10 Askania Bernburg Askania 30 45 53 34
11 Union Sandersdorf Union 30 42 58 33
12 Barleben Barleben 30 41 71 32
13 BSC Süd 05 BSC Süd 05 30 37 54 29
14 Schott Jena Schott Jena 30 29 55 23
15 VfL Halle VfL Halle 30 32 64 21
16 Markranstädt Markranstäd 30 24 80 17
TEMPORADA 2015/2016
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Lokomotive Leipzig Lokomotive 30 78 14 74
2 International Leipzig Internationa 30 71 29 63
3 Bischofswerdaer Bischofswerd 30 60 31 57
4 Carl Zeiss Jena II Carl Zeiss. 30 72 42 49
5 Einheit Rudolstadt Einheit 30 46 34 45
6 VfL Halle VfL Halle 30 60 50 43
7 Union Sandersdorf Union 30 48 48 43
8 Markranstädt Markranstäd 30 49 48 41
9 Barleben Barleben 30 52 47 40
10 Energie Cottbus II Energie 30 56 66 40
11 Askania Bernburg Askania 30 43 45 38
12 VFC Plauen VFC Plauen 30 47 66 37
13 Rot-Weiß Erfurt II Rot-Weiß 30 49 65 34
14 Schott Jena Schott Jena 30 43 68 34
15 Wismut Gera Wismut Gera 30 30 66 21
16 Eisenach Eisenach 30 17 102 8
TEMPORADA 1999/2000
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 FC Lausitz Hoyerswerda Lausitz 30 75 18 71
2 VfB Leipzig II Leipzig 30 46 34 50
3 VfB Zittau VfB Zittau 30 49 39 47
4 FC Grimma FC Grimma 30 49 34 46
5 Bischofswerdaer Bischofswerd 30 41 33 45
6 Dresden-Nord Dresden-Nord 30 40 36 45
7 Wacker Nordhausen Wacker 30 37 37 45
8 Energie Cottbus II Energie 30 44 37 43
9 Fortuna Chemnitz Fortuna 30 35 35 42
10 FC Anhalt Dessau Anhalt 30 42 45 41
11 Fortuna Magdeburg/Wolmirste Fortuna 30 47 44 39
12 Erfurt-Nord Erfurt-Nord 30 31 49 36
13 1. SV Suhl 1906 Suhl 1906 30 31 36 30
14 Wismut Gera Wismut Gera 30 25 48 29
15 Schott Jena Schott Jena 30 35 67 24
16 Bornaer SV Bornaer SV 30 30 65 18
TEMPORADA 1995/1996
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 VFC Plauen VFC Plauen 30 50 17 66
2 Chemnitzer FC II Chemnitzer 30 69 28 56
3 Carl Zeiss Jena II Carl Zeiss. 30 49 31 55
4 Dresdner SC Dresdner SC 30 52 29 54
5 Fortuna Chemnitz Fortuna 30 45 27 50
6 Zeulenroda Zeulenroda 30 52 42 49
7 1. SV Suhl 1906 Suhl 1906 30 35 35 45
8 Meißner SV 08 Meißner 30 39 37 43
9 VfL Halle VfL Halle 30 43 40 40
10 FC Lausitz Hoyerswerda Lausitz 30 33 30 40
11 Bornaer SV Bornaer SV 30 31 31 36
12 SC 1903 Weimar 1903 Weimar 30 28 46 36
13 Einheit Wernigerode Einheit 30 30 58 31
14 SV 1899 Merseburg 1899 30 28 55 25
15 Glückauf Brieske-Senftenber Glückauf 30 32 55 24
16 Wismut Gera Wismut Gera 30 15 70 5
TEMPORADA 1994/1995
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 VFC Plauen VFC Plauen 30 54 23 63
2 Wacker Nordhausen Wacker 30 58 21 61
3 Chemnitzer FC II Chemnitzer 30 54 25 58
4 Zeulenroda Zeulenroda 30 49 26 53
5 FC Lausitz Hoyerswerda Lausitz 30 43 38 51
6 Fortuna Chemnitz Fortuna 30 42 40 43
7 Carl Zeiss Jena II Carl Zeiss. 30 39 41 40
8 Wismut Gera Wismut Gera 30 47 42 39
9 1. FC Wernigerode Wernigerode 30 54 52 38
10 Bornaer SV Bornaer SV 30 32 38 37
11 1. SV Suhl 1906 Suhl 1906 30 38 39 36
12 SV Blau-Weiß Meißen Blau-Weiß 30 37 44 34
13 SV 1899 Merseburg 1899 30 33 45 32
14 Glückauf Brieske-Senftenber Glückauf 30 26 45 32
15 FC Aschersleben Aschersleben 30 31 52 28
16 Hallescher FC Hallescher 30 17 83 3
TEMPORADA 1977/1978
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Dynamo Dresden Dynamo 26 70 25 59
2 Magdeburg Magdeburg 26 52 17 54
3 BFC Dynamo BFC Dynamo 26 54 25 49
4 Lokomotive Leipzig Lokomotive 26 57 34 45
5 FC Carl Zeiss Jena Carl Zeiss. 26 53 32 44
6 Hallescher FC Hallescher 26 44 34 41
7 Union Berlin Union Berlin 26 27 36 33
8 Zwickau Zwickau 26 22 45 31
9 Chemnitzer Chemnitzer 26 34 37 30
10 Rot-Weiss Erfurt Rot-Weiss 26 23 35 30
11 BSG Wismut Aue Wismut 26 22 47 30
12 BSG Chemie Böhlen Chemie 26 34 51 26
13 FC Vorwärts Frankfurt Vorwärts 26 19 35 18
14 Wismut Gera Wismut Gera 26 17 75 7
TEMPORADA 1966/1967
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Chemnitzer Chemnitzer 26 39 23 51
2 Lokomotive Leipzig Lokomotive 26 39 32 44
3 Dynamo Dresden Dynamo 26 35 31 38
4 FC Carl Zeiss Jena Carl Zeiss. 26 31 29 38
5 Lok Stendal Lok Stendal 26 39 44 38
6 BSG Wismut Aue Wismut 26 45 43 37
7 Hallescher FC Hallescher 26 38 41 37
8 Zwickau Zwickau 26 41 26 36
9 FC Vorwärts Berlin Vorwärts 26 43 34 36
10 Union Berlin Union Berlin 26 33 35 36
11 Hansa Rostock Hansa 26 27 27 35
12 Chemie Leipzig Chemie 26 35 38 34
13 BFC Dynamo BFC Dynamo 26 28 40 27
14 Wismut Gera Wismut Gera 26 27 57 16
TEMPORADA 1952/1953
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 32 57 48 54
2 Dynamo Dresden Dynamo 32 51 33 53
3 Zwickau Zwickau 32 54 43 53
4 SC Einheit Dresden Einheit 32 65 55 51
5 Dessau 05 Dessau 05 32 66 55 50
6 BSG Stahl Thale Stahl Thale 32 45 47 50
7 Rot-Weiss Erfurt Rot-Weiss 32 51 44 48
8 Chemie Leipzig Chemie 32 55 51 48
9 Brieske-Senftenberg Brieske-Senf 32 55 52 47
10 BSG Empor Lauter Empor Lauter 32 58 61 46
11 Lok Stendal Lok Stendal 32 56 54 45
12 SV Babelsberg 03 Babelsberg 32 58 59 45
13 Hallescher FC Hallescher 32 51 44 43
14 SV Vorwärts Leipzig Vorwärts 32 49 56 42
15 Union Berlin Union Berlin 32 47 50 39
16 FC Carl Zeiss Jena Carl Zeiss. 32 35 62 31
17 Wismut Gera Wismut Gera 32 32 71 20
TEMPORADA 1951/1952
DDR OBERLIGA
Equipo PJ GF GC Puntos
TEMPORADA 1950/1951
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Rot-Weiss Erfurt Rot-Weiss 34 80 37 72
2 Chemie Leipzig Chemie 34 66 33 72
3 Brieske-Senftenberg Brieske-Senf 34 87 79 63
4 Zwickau Zwickau 34 72 35 60
5 Dynamo Dresden Dynamo 34 75 40 60
6 SV Babelsberg 03 Babelsberg 34 95 78 57
7 Hallescher FC Hallescher 34 74 50 56
8 Dessau 05 Dessau 05 34 71 63 51
9 BSG Fortschritt Meerane Fortschritt 34 65 71 44
10 SC Einheit Dresden Einheit 34 64 61 42
11 Lok Stendal Lok Stendal 34 73 73 41
12 SV Motor Altenburg Motor 34 47 64 40
13 SC 1903 Weimar 1903 Weimar 34 45 71 36
14 BSG Stahl Thale II Stahl Thale 19 52 44 33
15 Wismut Gera Wismut Gera 27 47 54 29
16 Lichtenberg Lichtenberg 34 49 96 26
17 BSG Stahl Thale Stahl Thale 15 30 21 23
18 Union Berlin Union Berlin 17 32 27 23
19 Union Berlin II Union Berlin 17 17 45 12
20 BSG Einheit Pankow Einheit 34 29 131 9
TEMPORADA 1949/1950
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Zwickau Zwickau 26 69 27 61
2 Dresdner SC Dresdner SC 26 87 29 57
3 Dessau 05 Dessau 05 26 67 36 54
4 Rot-Weiss Erfurt Rot-Weiss 26 61 34 47
5 Hallescher FC Hallescher 26 56 38 44
6 Brieske-Senftenberg Brieske-Senf 26 49 48 44
7 SV Babelsberg 03 Babelsberg 26 42 66 34
8 BSG Fortschritt Meerane Fortschritt 26 38 56 30
9 Wismut Gera Wismut Gera 26 34 54 25
10 SV Motor Altenburg Motor 26 34 50 23
11 Anker Wismar Anker Wismar 26 35 60 23
12 Sachsen Leipzig Sachsen 13 20 18 20
13 Lok Stendal Lok Stendal 13 18 19 16
14 Mecklenburg Schwerin Mecklenburg 26 30 84 15
15 Lok Stendal II Stendal 13 17 29 13
16 Chemie Leipzig Chemie 13 18 27 10

  USO DE MEMORIA  
6,595,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1521
Total Execution Time  0.1536
  CADENA URL  
/historico/Wismut-Gera
  GET DATOS  
$_GET['/historico/Wismut-Gera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0030  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 = 'Wismut-Gera' 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.0020  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=66080 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=66080 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0030  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=66080 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0054  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 = 73081
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=66080 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 = '66080' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '66080' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 73081 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=66080 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73081,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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73081 AND teamId = 66080
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 66080
0.0027  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 = 73081 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '66080' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '66080' and rp.type = 4
0.0020  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 = '66080' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028  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 = 73081 WHERE rp.league_id = 73081 AND rp.teamId = 66080 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.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 = 73081 WHERE rp.league_id = 73081 AND rp.teamId = 66080 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 = 73081 WHERE rp.league_id = 73081 AND rp.teamId = 66080 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 66080 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73081 AND t.round = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 72018 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.0027  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 = 44324 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 39083 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 33811 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15542 AND t.round = 30 ORDER BY team.conference 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 `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 = 28335 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 `tables1996` 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 = 28369 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables1995` 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 = 28379 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035  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 `tables1978` 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 = 45346 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 `tables1967` 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 = 45357 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables1953` 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 = 45384 AND t.round = 34 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 `tables1952` 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 = 45385 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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 `tables1951` 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 = 45386 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 `tables1950` 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 = 45387 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC