4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Germania Teveren
TEMPORADA 2023/2024
OBERLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 Eintracht Hohkeppel Eintracht 26 74 20 59
2 Bonner SC Bonner SC 26 48 17 52
3 SpVgg Frechen SpVgg 25 55 28 51
4 VfL Vichttal Vichttal 25 61 28 47
5 Bergisch Gladbach Bergisch 25 42 30 46
6 SC Fortuna Köln II Fortuna 25 45 36 37
7 Konigsdorf Konigsdorf 26 40 39 35
8 Siegburger SV 04 Siegburger 25 37 35 34
9 Borussia Freialdenhoven Borussia 26 40 37 32
10 Hennef 05 Hennef 05 26 40 55 32
11 SpVg Porz 1919 SpVg Porz 1. 25 31 52 31
12 Hürth Hürth 25 29 44 29
13 Union Schafhausen Union 25 23 52 25
14 Germania Teveren Germania 26 36 73 21
15 FV Endenich FV Endenich 25 26 50 19
16 BCV Glesch-Paffendorf Glesch-Paffe 17 14 45 6
TEMPORADA 2020/2021
LANDESLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Germania Teveren Germania 7 25 8 19
2 DJK Arminia Eilendorf Arminia 8 19 8 15
3 Union Schafhausen Union 7 16 8 14
4 Konigsdorf Konigsdorf 5 18 6 13
5 SV Eintracht Verlautenheide Eintracht 7 20 11 13
6 SF Düren SF Düren 6 12 8 11
7 Kohlscheider BC Kohlscheider 6 12 10 11
8 Alemannia Mariadorf Alemannia 8 15 22 9
9 SV Rott SV Rott 6 15 16 7
10 GKSC Hürth GKSC Hürth 7 10 12 6
11 1. FC Düren II Düren 8 9 16 6
12 GW Brauweiler Brauweiler 7 7 14 6
13 Germania Erftstadt Germania 5 10 15 3
14 Euskirchen Euskirchen 6 4 21 3
15 SC Bruhl SC Bruhl 7 5 22 1
TEMPORADA 2019/2020
LANDESLIGA GRUPO 16
Equipo PJ GF GC Puntos
TEMPORADA 2018/2019
LANDESLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 SV Rott SV Rott 4 15 7 10
2 BCV Glesch-Paffendorf Glesch-Paffe 4 12 5 9
3 Wesseling-Urfeld Wesseling-Ur 4 12 5 9
4 SV Eilendorf Eilendorf 4 9 2 8
5 Union Schafhausen Union 4 10 7 8
6 DJK Arminia Eilendorf Arminia 4 12 4 7
7 SV Eintracht Verlautenheide Eintracht 4 5 4 7
8 Hertha Walheim Hertha 4 9 7 6
9 Inde Hahn Inde Hahn 4 10 12 6
10 Germania Erftstadt Germania 4 5 11 6
11 1. FC Düren II Düren 4 7 11 3
12 GW Brauweiler Brauweiler 4 7 11 3
13 GKSC Hürth GKSC Hürth 4 4 8 3
14 SW Nierfeld SW Nierfeld 4 8 13 3
15 Germania Teveren Germania 4 6 13 3
16 Hilal Bergheim Hilal 4 4 15 1
TEMPORADA 2017/2018
LANDESLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 Germania Teveren Germania 2 6 1 6
2 Inde Hahn Inde Hahn 2 4 1 6
3 Düren Düren 2 4 2 6
4 Hertha Walheim Hertha 2 7 4 4
5 FC Düren-Niederau Düren-Niede 2 5 3 4
6 SW Nierfeld SW Nierfeld 2 2 1 4
7 SpVgg Frechen SpVgg 2 7 4 3
8 Union Schafhausen Union 2 5 2 3
9 Kohlscheider BC Kohlscheider 2 4 6 3
10 SV Eilendorf Eilendorf 2 3 3 2
11 GKSC Hürth GKSC Hürth 2 2 3 1
12 SC Alemannia Straß Alemannia 2 3 5 1
13 Germania Erftstadt Germania 2 1 3 1
14 BCV Glesch-Paffendorf Glesch-Paffe 2 1 5 0
15 SV Rott SV Rott 2 2 7 0
16 Schwarz-Weiß Düren Schwarz-Wei 2 0 6 0
TEMPORADA 2016/2017
LANDESLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 SV Breinig SV Breinig 30 64 29 62
2 VfL Vichttal Vichttal 30 70 37 61
3 FC Düren-Niederau Düren-Niede 30 70 47 60
4 SC Bruhl SC Bruhl 30 66 34 57
5 Hertha Walheim Hertha 30 69 44 52
6 SV Eilendorf Eilendorf 30 54 45 46
7 Kohlscheider BC Kohlscheider 30 53 56 46
8 BCV Glesch-Paffendorf Glesch-Paffe 30 55 60 40
9 SW Nierfeld SW Nierfeld 30 64 71 39
10 Düren Düren 30 59 48 38
11 Germania Teveren Germania 30 37 43 38
12 SC Alemannia Straß Alemannia 30 47 56 38
13 Germania Erftstadt Germania 30 48 59 37
14 SV Germania Eicherscheid Germania 30 42 59 30
15 Alemannia Aachen II Alemannia 30 51 81 24
16 Alemannia Mariadorf Alemannia 30 35 115 3
TEMPORADA 2015/2016
LANDESLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 Hilal Bergheim Hilal 26 67 27 60
2 Inde Hahn Inde Hahn 26 60 29 55
3 VfL Vichttal Vichttal 26 59 39 51
4 SC Bruhl SC Bruhl 26 55 40 46
5 Düren Düren 26 44 47 38
6 FC Düren-Niederau Düren-Niede 26 46 47 36
7 Germania Erftstadt Germania 26 51 54 36
8 SW Nierfeld SW Nierfeld 26 50 56 34
9 Germania Teveren Germania 26 39 45 33
10 BCV Glesch-Paffendorf Glesch-Paffe 26 34 43 32
11 Hertha Walheim Hertha 26 53 59 31
12 Alemannia Mariadorf Alemannia 26 44 54 31
13 SV Rott SV Rott 26 32 48 29
14 SF Düren SF Düren 26 34 80 13
TEMPORADA 1999/2000
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Wuppertaler SV Wuppertaler 30 60 28 61
2 Viktoria Köln Viktoria 30 47 28 55
3 B. Mönchengladbach II Mönchenglad 30 56 31 53
4 FC Remscheid Remscheid 30 48 30 51
5 Rheydter SV Rheydter SV 30 55 38 51
6 SV Straelen SV Straelen 30 47 44 50
7 SV Adler Osterfeld Adler 30 65 42 49
8 MSV Duisburg II Duisburg 30 50 41 45
9 Schwarz-Weiss Essen Schwarz-Weis 30 39 45 38
10 FC Bocholt FC Bocholt 30 39 56 37
11 Fortuna Düsseldorf II Fortuna 30 41 40 36
12 Wegberg-Beeck Wegberg-Beec 30 41 44 32
13 Köln II Köln II 30 40 49 30
14 Euskirchen Euskirchen 30 26 61 26
15 Bonner SC Bonner SC 30 22 47 24
16 Germania Teveren Germania 30 32 84 20
TEMPORADA 1998/1999
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Rot-Weiss Essen Rot-Weiss 30 59 28 67
2 SV Adler Osterfeld Adler 30 58 33 60
3 Wegberg-Beeck Wegberg-Beec 30 54 20 55
4 Viktoria Köln Viktoria 30 45 33 55
5 Rheydter SV Rheydter SV 30 56 42 49
6 SV Straelen SV Straelen 30 52 36 47
7 B. Mönchengladbach II Mönchenglad 30 49 35 46
8 Schwarz-Weiss Essen Schwarz-Weis 30 50 43 42
9 Germania Teveren Germania 30 45 52 34
10 Köln II Köln II 30 34 43 34
11 Fortuna Düsseldorf II Fortuna 30 41 59 34
12 FC Bocholt FC Bocholt 30 37 42 33
13 Bonner SC Bonner SC 30 32 48 32
14 SV Baesweiler 09 Baesweiler 30 23 50 31
15 TuS Langerwehe Langerwehe 30 38 53 29
16 Jahn Hiesfeld Jahn 30 25 81 8
TEMPORADA 1997/1998
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Rot-Weiß Oberhausen Rot-Weiß 34 66 31 71
2 Siegen Sportfreunde Siegen 34 69 37 65
3 FC 08 Homburg Homburg 34 70 38 59
4 1. FC Saarbrücken Saarbrücken 34 70 43 59
5 Eintracht Trier Eintracht 34 56 41 54
6 Rot Weiss Ahlen Weiss Ahlen 34 62 52 51
7 Alemannia Aachen Alemannia 34 62 46 49
8 Preußen Münster Preußen 34 57 48 49
9 Paderborn Paderborn 34 61 37 48
10 Verl Verl 34 52 56 47
11 Kaiserslautern II Kaiserslaute 34 45 46 46
12 Wuppertaler SV Wuppertaler 34 49 58 43
13 FC Remscheid Remscheid 34 40 55 38
14 Salmrohr Salmrohr 34 33 66 37
15 SpVgg Erkenschwick SpVgg 34 41 69 36
16 Bonner SC Bonner SC 34 34 65 35
17 Rot-Weiss Essen Rot-Weiss 34 41 80 30
18 Germania Teveren Germania 34 32 72 24
TEMPORADA 1996/1997
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Wattenscheid 09 Wattenscheid 34 78 35 77
2 Rot-Weiß Oberhausen Rot-Weiß 34 62 22 65
3 1. FC Saarbrücken Saarbrücken 34 64 38 61
4 Rot Weiss Ahlen Weiss Ahlen 34 61 38 57
5 Preußen Münster Preußen 34 52 32 57
6 Wuppertaler SV Wuppertaler 34 46 40 51
7 Verl Verl 34 61 52 49
8 FC 08 Homburg Homburg 34 47 47 45
9 Eintracht Trier Eintracht 34 41 45 43
10 Paderborn Paderborn 34 40 46 43
11 Alemannia Aachen Alemannia 34 40 48 42
12 Germania Teveren Germania 34 34 45 41
13 SpVgg Erkenschwick SpVgg 34 46 55 40
14 Salmrohr Salmrohr 34 39 54 39
15 FC Remscheid Remscheid 34 30 42 37
16 Hauenstein Hauenstein 34 46 62 36
17 FC Bocholt FC Bocholt 34 24 66 25
18 SV Elversberg Elversberg 34 34 78 20
TEMPORADA 1995/1996
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Germania Teveren Germania 30 63 22 68
2 FC Remscheid Remscheid 30 55 21 66
3 Schwarz-Weiss Essen Schwarz-Weis 30 52 22 54
4 Julich 1910 Julich 1910 30 63 44 53
5 B. Leverkusen II Leverkusen 30 58 45 50
6 SV Baesweiler 09 Baesweiler 30 43 36 48
7 Viktoria Köln Viktoria 30 39 37 43
8 Fortuna Düsseldorf II Fortuna 30 45 39 42
9 Köln II Köln II 30 52 43 40
10 FV Bad Honnef Honnef 30 42 47 39
11 Jahn Hiesfeld Jahn 30 28 36 39
12 Rheydter SV Rheydter SV 30 46 50 37
13 VfL Rheinbach Rheinbach 30 35 60 30
14 Union Solingen Union 30 35 45 28
15 TuS Langerwehe Langerwehe 30 42 60 24
16 Preußen Krefeld Preußen 30 12 103 3
TEMPORADA 1994/1995
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Rot-Weiß Oberhausen Rot-Weiß 30 82 19 74
2 FC Remscheid Remscheid 30 61 27 66
3 Julich 1910 Julich 1910 30 55 26 54
4 Germania Teveren Germania 30 48 28 53
5 Köln II Köln II 30 40 30 44
6 B. Leverkusen II Leverkusen 30 48 50 41
7 Schwarz-Weiss Essen Schwarz-Weis 30 46 54 41
8 SuS Dinslaken Dinslaken 30 39 36 40
9 Preußen Krefeld Preußen 30 35 34 39
10 Rheydter SV Rheydter SV 30 48 53 38
11 TuS Langerwehe Langerwehe 30 52 47 35
12 FV Bad Honnef Honnef 30 40 45 34
13 Union Solingen Union 30 28 52 28
14 DJK Winfriedia Mülheim Winfriedia 30 27 64 24
15 1. FC Viersen Viersen 30 28 62 20
16 Hamborn Hamborn 30 32 82 12

  USO DE MEMORIA  
6,365,944 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1111
Total Execution Time  0.1123
  CADENA URL  
/historico/Germania-Teveren
  GET DATOS  
$_GET['/historico/Germania-Teveren']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0031  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 = 'Germania-Teveren' 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.0018  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=85607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=85607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=85607 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85607 AND type_rel = 2
0.0024  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 = '85607' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '85607' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '85607' 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 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=85607 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72972,72069,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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72972 AND teamId = 85607
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72069 AND teamId = 85607
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 85607
0.0020  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 = '85607' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '85607' and rp.type = 4
0.0021  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 = '85607' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040  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 = 72972 WHERE rp.league_id = 72972 AND rp.teamId = 85607 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.0035  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 = 72972 WHERE rp.league_id = 72972 AND rp.teamId = 85607 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 72972 WHERE rp.league_id = 72972 AND rp.teamId = 85607 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 = 85607 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72972 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 58576 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 51145 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.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 `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 = 48747 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 46655 AND t.round = 2 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 = 46825 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 46843 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 `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 = 28340 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 `tables1999` 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 = 28343 AND t.round = 32 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 `tables1998` 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 = 22682 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1997` 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 = 22695 AND t.round = 34 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 `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 = 28371 AND t.round = 30 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 `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 = 28386 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC