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

SC Freiburg

Entrenador: Christian Streich

Temporada 1986/1987
TEMPORADA 1986/1987
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Hannover 96 Hannover 96 38 86 48 56
2 Karlsruher SC Karlsruher 38 79 49 52
3 FC St Pauli FC St Pauli 38 63 45 49
4 Darmstadt 98 Darmstadt 38 72 48 47
5 Alemannia Aachen Alemannia 38 55 36 46
6 VfL Osnabrück Osnabrück 38 69 66 44
7 Stuttgarter Kickers Stuttgarter 38 72 55 42
8 SC Freiburg SC Freiburg 38 59 56 39
9 Arminia Bielefeld Arminia 38 58 55 38
10 Rot-Weiss Essen Rot-Weiss 38 70 69 38
11 Wattenscheid 09 Wattenscheid 38 59 66 38
12 Union Solingen Union 38 61 65 35
13 Ulm Ulm 38 55 63 35
14 Fortuna Köln Fortuna 38 51 66 35
15 1. FC Saarbrücken Saarbrücken 38 53 71 34
16 Rot-Weiß Oberhausen Rot-Weiß 38 52 55 33
17 Eintracht Braunschweig Eintracht 38 52 47 32
18 Viktoria Aschaffenburg Viktoria 38 47 72 24
19 Hessen Kassel Hessen 38 40 75 22
20 Salmrohr Salmrohr 38 48 94 21
TEMPORADA 1985/1986
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 FC 08 Homburg Homburg 38 75 42 49
2 Blau-Weiß 1890 Berlin Blau-Weiß 38 76 48 47
3 Fortuna Köln Fortuna 38 64 52 46
4 Arminia Bielefeld Arminia 38 60 47 45
5 Hessen Kassel Hessen 38 58 47 44
6 Stuttgarter Kickers Stuttgarter 38 73 55 43
7 Karlsruher SC Karlsruher 38 64 50 43
8 Alemannia Aachen Alemannia 38 56 45 43
9 Wattenscheid 09 Wattenscheid 38 63 56 43
10 Darmstadt 98 Darmstadt 38 63 57 41
11 Rot-Weiß Oberhausen Rot-Weiß 38 61 60 37
12 Eintracht Braunschweig Eintracht 38 65 62 36
13 Viktoria Aschaffenburg Viktoria 38 57 59 35
14 VfL Osnabrück Osnabrück 38 48 57 35
15 Union Solingen Union 38 48 64 34
16 SC Freiburg SC Freiburg 38 54 62 33
17 Hertha BSC Hertha BSC 38 50 62 31
18 Bayreuth SpVgg Bayreuth 38 40 73 31
19 Tennis Borussia Tennis 38 48 73 29
20 MSV Duisburg Duisburg 38 34 86 15
TEMPORADA 1984/1985
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 38 71 45 50
2 Hannover 96 Hannover 96 38 79 58 50
3 1. FC Saarbrücken Saarbrücken 38 70 41 49
4 Hessen Kassel Hessen 38 72 48 49
5 Alemannia Aachen Alemannia 38 60 46 43
6 Union Solingen Union 38 64 70 41
7 Blau-Weiß 1890 Berlin Blau-Weiß 38 66 56 39
8 SC Freiburg SC Freiburg 38 45 49 38
9 Stuttgarter Kickers Stuttgarter 38 51 49 37
10 Wattenscheid 09 Wattenscheid 38 61 68 36
11 Fortuna Köln Fortuna 38 58 67 36
12 Rot-Weiß Oberhausen Rot-Weiß 38 64 70 35
13 MSV Duisburg Duisburg 38 56 63 35
14 Hertha BSC Hertha BSC 38 50 59 35
15 Darmstadt 98 Darmstadt 38 52 64 35
16 FC 08 Homburg Homburg 38 57 58 34
17 FC St Pauli FC St Pauli 38 48 59 33
18 Kickers Offenbach FC Kickers 38 43 56 32
19 VfR Bürstadt Bürstadt 38 48 56 31
20 Ulm Ulm 38 48 81 22
TEMPORADA 1983/1984
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 38 94 45 57
2 Schalke 04 Schalke 04 38 95 45 55
3 MSV Duisburg Duisburg 38 69 41 50
4 Hessen Kassel Hessen 38 68 39 48
5 Union Solingen Union 38 70 54 44
6 Alemannia Aachen Alemannia 38 49 43 44
7 SC Freiburg SC Freiburg 38 50 49 43
8 Stuttgarter Kickers Stuttgarter 38 54 52 39
9 Fortuna Köln Fortuna 38 66 65 38
10 1. FC Saarbrücken Saarbrücken 38 61 69 38
11 Hertha BSC Hertha BSC 38 64 57 37
12 Darmstadt 98 Darmstadt 38 48 72 35
13 Ulm Ulm 38 58 68 32
14 Hannover 96 Hannover 96 38 54 69 32
15 Wattenscheid 09 Wattenscheid 38 58 74 32
16 Rot-Weiß Oberhausen Rot-Weiß 38 51 62 31
17 Rot-Weiss Essen Rot-Weiss 38 48 63 29
18 SC Charlottenburg Charlottenbu 38 49 68 29
19 VfL Osnabrück Osnabrück 38 46 66 29
20 BV 08 Lüttringhausen Lüttringhau 38 36 87 18
TEMPORADA 1982/1983
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Waldhof Mannheim Waldhof 38 83 38 52
2 Kickers Offenbach FC Kickers 38 77 45 50
3 KFC Uerdingen 05 Uerdingen 38 65 44 48
4 Hessen Kassel Hessen 38 69 54 45
5 Stuttgarter Kickers Stuttgarter 38 78 51 44
6 Fortuna Köln Fortuna 38 76 50 43
7 Darmstadt 98 Darmstadt 38 77 61 42
8 SC Freiburg SC Freiburg 38 50 45 42
9 Alemannia Aachen Alemannia 38 49 53 40
10 VfL Osnabrück Osnabrück 38 66 65 38
11 MSV Duisburg Duisburg 38 55 57 37
12 Hannover 96 Hannover 96 38 70 72 36
13 BV 08 Lüttringhausen Lüttringhau 38 53 76 34
14 Rot-Weiss Essen Rot-Weiss 38 56 60 33
15 Wattenscheid 09 Wattenscheid 38 59 65 33
16 Union Solingen Union 38 56 76 32
17 FC Augsburg FC Augsburg 38 32 54 32
18 Greuther Fürth Greuther 38 55 75 31
19 FSV Frankfurt Frankfurt 38 50 86 26
20 TuS Schloß-Neuhaus Schloß-Neuh 38 43 92 22
TEMPORADA 1981/1982
2. BUNDESLIGA
Equipo PJ GF GC Puntos
1 Schalke 04 Schalke 04 38 70 35 51
2 Hertha BSC Hertha BSC 38 84 47 48
3 Kickers Offenbach FC Kickers 38 70 67 46
4 1860 München 1860 38 87 56 45
5 Hannover 96 Hannover 96 38 72 52 45
6 Waldhof Mannheim Waldhof 38 51 44 44
7 Stuttgarter Kickers Stuttgarter 38 76 55 43
8 Hessen Kassel Hessen 38 56 46 43
9 Alemannia Aachen Alemannia 38 47 39 41
10 Fortuna Köln Fortuna 38 70 72 39
11 Rot-Weiss Essen Rot-Weiss 38 60 62 38
12 KFC Uerdingen 05 Uerdingen 38 47 57 38
13 VfL Osnabrück Osnabrück 38 49 59 37
14 Greuther Fürth Greuther 38 61 60 35
15 SC Freiburg SC Freiburg 38 49 54 34
16 Union Solingen Union 38 51 62 33
17 Wattenscheid 09 Wattenscheid 38 41 62 31
18 Wormatia Worms Wormatia 38 34 74 24
19 Freiburger FC Freiburger 38 52 88 23
20 Bayreuth SpVgg Bayreuth 38 40 76 22
TEMPORADA 1980/1981
2. BUNDESLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Darmstadt 98 Darmstadt 38 85 42 55
2 Kickers Offenbach FC Kickers 38 87 42 50
3 Stuttgarter Kickers Stuttgarter 38 81 40 48
4 Hessen Kassel Hessen 38 59 35 48
5 Ulm Ulm 38 59 39 47
6 Waldhof Mannheim Waldhof 38 65 43 45
7 SC Freiburg SC Freiburg 38 57 50 41
8 Eintracht Trier Eintracht 38 56 52 41
9 Bayreuth SpVgg Bayreuth 38 60 53 39
10 Freiburger FC Freiburger 38 76 75 39
11 FC 08 Homburg Homburg 38 66 69 38
12 Wormatia Worms Wormatia 38 60 70 37
13 VfR Bürstadt Bürstadt 38 54 66 37
14 Greuther Fürth Greuther 38 54 54 35
15 FSV Frankfurt Frankfurt 38 51 76 32
16 ESV Ingolstadt Ingolstadt 38 62 92 31
17 1. FC Saarbrücken Saarbrücken 38 43 61 28
18 FC Augsburg FC Augsburg 38 55 88 24
19 Borussia Neunkirchen Borussia 38 44 85 23
20 VfB Eppingen Eppingen 38 44 86 22
TEMPORADA 1979/1980
2. BUNDESLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 40 88 38 61
2 Karlsruher SC Karlsruher 40 104 52 59
3 Stuttgarter Kickers Stuttgarter 40 94 54 52
4 Darmstadt 98 Darmstadt 40 81 42 48
5 1. FC Saarbrücken Saarbrücken 40 69 56 47
6 SC Freiburg SC Freiburg 40 68 54 46
7 Greuther Fürth Greuther 40 56 51 44
8 Kickers Offenbach FC Kickers 40 78 64 43
9 Freiburger FC Freiburger 40 78 83 43
10 Wormatia Worms Wormatia 40 67 73 38
11 Waldhof Mannheim Waldhof 40 57 69 38
12 FC 08 Homburg Homburg 40 58 62 37
13 Bayreuth SpVgg Bayreuth 40 77 82 37
14 VfR Bürstadt Bürstadt 40 57 68 37
15 Eintracht Trier Eintracht 40 60 57 36
16 Ulm Ulm 40 51 57 36
17 ESV Ingolstadt Ingolstadt 40 57 89 34
18 FSV Frankfurt Frankfurt 40 63 97 32
19 MTV Ingolstadt Ingolstadt 40 58 81 29
20 Rochling Volklingen Rochling 40 49 101 22
21 Würzburger FV Würzburger 40 42 82 21
TEMPORADA 1978/1979
2. BUNDESLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 1860 München 1860 38 75 38 53
2 Bayreuth SpVgg Bayreuth 38 86 53 52
3 Wormatia Worms Wormatia 38 66 33 50
4 Greuther Fürth Greuther 38 66 45 49
5 Karlsruher SC Karlsruher 38 77 50 47
6 Kickers Offenbach FC Kickers 38 86 62 43
7 FC 08 Homburg Homburg 38 65 47 43
8 1. FC Saarbrücken Saarbrücken 38 70 58 41
9 Stuttgarter Kickers Stuttgarter 38 68 59 41
10 Eintracht Trier Eintracht 38 58 57 36
11 MTV Ingolstadt Ingolstadt 38 62 82 35
12 FSV Frankfurt Frankfurt 38 59 66 34
13 Freiburger FC Freiburger 38 58 75 33
14 Würzburger FV Würzburger 38 40 62 33
15 SC Freiburg SC Freiburg 38 51 75 32
16 Waldhof Mannheim Waldhof 38 46 56 31
17 FC Hanau 93 FC Hanau 93 38 72 98 29
18 FC Augsburg FC Augsburg 38 55 89 28
19 KSV Baunatal Baunatal 38 49 67 26
20 Borussia Neunkirchen Borussia 38 47 84 24

  USO DE MEMORIA  
6,581,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.2390
Total Execution Time  0.2412
  CADENA URL  
/historico/Sc-Freiburg/1987
  GET DATOS  
$_GET['/historico/Sc-Freiburg/1987']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0038  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 = 'Sc-Freiburg' AND l.year = 1987 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.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=2286 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=2286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=2286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 9864
0.0025  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 = 22439
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2286 AND type_rel = 2
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2286 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (3005,3494,30857,38230,73840) ORDER BY n.cover_points DESC, update_date DESC
0.0036  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 = '2286' AND l.year = 1987 ORDER BY l.year DESC,cat.coefficient DESC
0.0102  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 = '2286' 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 = 9864 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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 = 22439 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=2286 AND l.year in (1986,1987,1988) ORDER BY l.id DESC, l.year DESC ;
0.0021  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 (22440,9865) 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 = 9865 AND teamId = 2286
0.0037  SELECT count(id) as num_players from rel_players WHERE league_id = 22440 AND teamId = 2286
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 `tables1987` 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 = 9864 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0042  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 events1987 e ON e.player_id = p.id AND e.league_id = 9864 WHERE rp.league_id = 9864 AND rp.teamId = 2286 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.0032  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 events1987 e ON e.player_id = p.id AND e.league_id = 9864 WHERE rp.league_id = 9864 AND rp.teamId = 2286 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038  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 events1987 e ON e.player_id = p.id AND e.league_id = 9864 WHERE rp.league_id = 9864 AND rp.teamId = 2286 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 = 2286 AND l.year <= 1987 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables1987` 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 = 9864 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 `tables1986` 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 = 9863 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0093  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 `tables1985` 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 = 9862 AND t.round = 38 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 `tables1984` 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 = 9861 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1983` 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 = 9860 AND t.round = 38 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 `tables1982` 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 = 9859 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1981` 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 = 9889 AND t.round = 38 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 `tables1980` 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 = 9903 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 `tables1979` 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 = 9912 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 9864 ORDER BY nameShow LIMIT 100