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

Fluminense

Entrenador: Fernando Diniz

Temporada 1996/1997
TEMPORADA 1996/1997
LIGA BRASILEÑA GRUPO 1
Equipo PJ GF GC Puntos
1 Vasco da Gama Vasco Gama 25 55 32 54
2 Internacional Internaciona 25 52 21 51
3 Atl. Mineiro Atl. Mineiro 25 42 33 47
4 Portuguesa Portuguesa 25 45 28 45
5 Flamengo Flamengo 25 30 24 42
6 Santos FC Santos FC 25 39 33 41
7 Palmeiras Palmeiras 25 47 24 40
8 EC Juventude Juventude 25 24 20 37
9 Vitória Vitória 25 44 40 36
10 Botafogo Botafogo 25 32 32 34
11 São Paulo São Paulo 25 41 32 33
12 Sport Recife Sport Recife 25 34 32 33
13 Athletico Paranaense Athletico 25 37 41 33
14 Paraná Paraná 25 30 30 32
15 Grêmio Grêmio 25 34 47 31
16 Coritiba Coritiba 25 31 32 30
17 América RN América RN 25 31 40 30
18 Corinthians Corinthians 25 23 27 29
19 Cruzeiro Cruzeiro 25 30 35 28
20 Guaraní Guaraní 25 36 43 28
21 Goiás EC Goiás EC 25 30 40 28
22 Bahía Bahía 25 39 49 26
23 RB Bragantino Bragantino 25 27 46 26
24 Criciúma Criciúma 25 27 35 25
25 Fluminense Fluminense 25 26 41 22
26 União São João União São 25 18 47 15
TEMPORADA 1995/1996
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 23 31 17 44
2 Palmeiras Palmeiras 23 42 20 43
3 Guaraní Guaraní 23 23 14 43
4 Athletico Paranaense Athletico 23 41 28 39
5 Atl. Mineiro Atl. Mineiro 23 39 32 39
6 Grêmio Grêmio 23 42 27 38
7 Goiás EC Goiás EC 23 37 27 37
8 Portuguesa Portuguesa 23 32 29 36
9 São Paulo São Paulo 23 39 32 35
10 Internacional Internaciona 23 31 27 35
11 Sport Recife Sport Recife 23 32 31 35
12 Corinthians Corinthians 23 20 19 32
13 Flamengo Flamengo 23 24 31 30
14 Coritiba Coritiba 23 25 30 29
15 Vitória Vitória 23 32 39 29
16 Botafogo Botafogo 23 33 35 28
17 Paraná Paraná 23 26 30 28
18 Santos FC Santos FC 23 26 31 27
19 Vasco da Gama Vasco Gama 23 37 43 27
20 EC Juventude Juventude 23 31 37 27
21 Criciúma Criciúma 23 31 39 23
22 Bahía Bahía 23 25 35 23
23 Fluminense Fluminense 23 26 50 22
24 RB Bragantino Bragantino 23 26 48 19
TEMPORADA 1994/1995
LIGA BRASILEÑA GRUPO 3
Equipo PJ GF GC Puntos
1 Botafogo Botafogo 12 22 6 27
2 EC Juventude Juventude 12 19 12 23
3 Corinthians Corinthians 12 19 15 23
4 Palmeiras Palmeiras 12 18 11 22
5 RB Bragantino Bragantino 12 20 16 19
6 Grêmio Grêmio 12 14 14 19
7 Flamengo Flamengo 12 14 15 16
8 Cruzeiro Cruzeiro 12 17 15 14
9 Paraná Paraná 12 17 16 14
10 Guaraní Guaraní 12 14 19 13
11 Vitória Vitória 12 14 18 11
12 Paysandu Paysandu 12 11 24 8
13 Santos FC Santos FC 12 25 13 27
14 Atl. Mineiro Atl. Mineiro 12 23 15 26
15 Goiás EC Goiás EC 12 17 14 19
16 Portuguesa Portuguesa 12 12 14 17
17 Internacional Internaciona 12 14 12 14
18 São Paulo São Paulo 12 17 18 14
19 Vasco da Gama Vasco Gama 12 18 19 13
20 Sport Recife Sport Recife 12 16 18 13
21 Fluminense Fluminense 12 9 12 13
22 Criciúma Criciúma 12 10 12 12
23 Bahía Bahía 12 9 24 12
24 União São João União São 12 11 28 5
TEMPORADA 1993/1994
LIGA BRASILEÑA GRUPO 7
Equipo PJ GF GC Puntos
1 Guaraní Guaraní 8 11 5 12
2 Portuguesa Portuguesa 8 16 8 11
3 Fluminense Fluminense 8 14 13 8
4 Vasco da Gama Vasco Gama 8 4 7 8
5 Internacional Internaciona 8 4 5 7
6 Grêmio Grêmio 8 6 12 5
7 Paysandu Paysandu 8 2 11 4
8 Corinthians Corinthians 8 6 16 4
9 Botafogo Botafogo 8 13 5 13
10 Santos FC Santos FC 8 10 3 11
11 São Paulo São Paulo 8 14 9 10
12 Bahía Bahía 8 10 6 10
13 Paraná Paraná 8 9 9 8
14 Flamengo Flamengo 8 5 9 7
15 Palmeiras Palmeiras 8 11 12 6
16 Sport Recife Sport Recife 8 5 10 4
TEMPORADA 1992/1993
LIGA BRASILEÑA GRUPO 2
Equipo PJ GF GC Puntos
1 Palmeiras Palmeiras 14 27 14 22
2 Santos FC Santos FC 14 24 14 20
3 Guaraní Guaraní 14 21 13 19
4 Grêmio Grêmio 14 20 17 15
5 Vasco da Gama Vasco Gama 14 19 20 13
6 Sport Recife Sport Recife 14 10 21 11
7 Fluminense Fluminense 14 18 26 8
8 Atl. Mineiro Atl. Mineiro 14 7 21 4
TEMPORADA 1991/1992
LIGA BRASILEÑA GRUPO 1
Equipo PJ GF GC Puntos
1 Vasco da Gama Vasco Gama 19 31 14 36
2 Botafogo Botafogo 19 37 23 35
3 RB Bragantino Bragantino 19 16 13 33
4 Flamengo Flamengo 19 32 24 30
5 Corinthians Corinthians 19 24 22 30
6 São Paulo São Paulo 19 22 16 29
7 Cruzeiro Cruzeiro 19 20 14 28
8 Santos FC Santos FC 19 23 18 28
9 Guaraní Guaraní 19 15 19 28
10 Palmeiras Palmeiras 19 23 17 27
11 Internacional Internaciona 19 19 20 27
12 Atl. Mineiro Atl. Mineiro 19 15 18 24
13 Fluminense Fluminense 19 21 19 23
14 Sport Recife Sport Recife 19 15 15 23
15 Athletico Paranaense Athletico 19 19 32 21
16 Portuguesa Portuguesa 19 21 26 19
17 Goiás EC Goiás EC 19 23 34 19
18 Bahía Bahía 19 20 24 18
19 Paysandu Paysandu 19 19 35 17
20 Náutico Náutico 19 17 29 16
TEMPORADA 1990/1991
LIGA BRASILEÑA
Equipo PJ GF GC Puntos
1 RB Bragantino Bragantino 19 27 14 26
2 São Paulo São Paulo 19 26 14 26
3 Atl. Mineiro Atl. Mineiro 19 29 19 24
4 Corinthians Corinthians 19 23 17 24
5 Fluminense Fluminense 18 27 19 22
6 Palmeiras Palmeiras 19 20 19 22
7 Internacional Internaciona 19 19 16 20
8 Santos FC Santos FC 19 23 20 19
9 Portuguesa Portuguesa 19 14 15 19
10 Vasco da Gama Vasco Gama 19 22 26 19
11 Flamengo Flamengo 19 20 24 19
12 Botafogo Botafogo 18 19 20 18
13 Bahía Bahía 19 16 18 18
14 Goiás EC Goiás EC 19 27 24 17
15 Náutico Náutico 19 19 25 17
16 Cruzeiro Cruzeiro 19 23 28 16
17 Athletico Paranaense Athletico 19 27 29 15
18 Sport Recife Sport Recife 19 15 30 13
19 Grêmio Grêmio 19 15 24 12
20 Vitória Vitória 19 17 27 12
TEMPORADA 1989/1990
LIGA BRASILEÑA GRUPO 3
Equipo PJ GF GC Puntos
1 Palmeiras Palmeiras 9 13 6 15
2 São Paulo São Paulo 9 11 4 13
3 Flamengo Flamengo 9 13 6 12
4 Grêmio Grêmio 9 13 7 12
5 Cruzeiro Cruzeiro 9 12 9 9
6 Fluminense Fluminense 9 6 7 8
7 EC São José São José 9 4 8 8
8 Náutico Náutico 9 5 10 8
9 Vitória Vitória 9 9 17 3
10 Inter de Limeira Inter 9 2 14 2
TEMPORADA 1988/1989
LIGA BRASILEÑA GRUPO 2
Equipo PJ GF GC Puntos
1 Palmeiras Palmeiras 10 13 5 14
2 Vasco da Gama Vasco Gama 10 14 7 14
3 Portuguesa Portuguesa 10 12 7 11
4 Grêmio Grêmio 10 11 11 10
5 Cruzeiro Cruzeiro 10 8 8 10
6 Fluminense Fluminense 10 9 10 10
7 Goiás EC Goiás EC 10 10 12 10
8 Santos FC Santos FC 10 6 7 9
9 Coritiba Coritiba 10 10 15 9
10 Sport Recife Sport Recife 10 9 12 8
11 Bahía Bahía 10 9 17 5
TEMPORADA 1987/1988
LIGA BRASILEÑA GRUPO 2
Equipo PJ GF GC Puntos
1 Flamengo Flamengo 11 14 9 20
2 Portuguesa Portuguesa 11 11 10 19
3 Sport Recife Sport Recife 11 10 10 18
4 Internacional Internaciona 11 17 15 17
5 São Paulo São Paulo 11 14 10 15
6 Palmeiras Palmeiras 11 9 8 14
7 Atl. Mineiro Atl. Mineiro 11 12 14 13
8 Goiás EC Goiás EC 11 12 9 12
9 Athletico Paranaense Athletico 11 8 8 12
10 Vitória Vitória 11 11 17 12
11 Fluminense Fluminense 11 9 12 10
12 Bangu Bangu 11 7 12 9
TEMPORADA 1986/1987
LIGA BRASILEÑA GRUPO 4
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 7 12 1 17
2 São Paulo São Paulo 7 14 5 16
3 Fluminense Fluminense 7 7 6 11
4 Coritiba Coritiba 7 9 12 8
5 Vasco da Gama Vasco Gama 7 7 11 8
6 Santos FC Santos FC 7 4 8 6
7 Internacional Internaciona 7 2 8 5
8 Goiás EC Goiás EC 7 3 7 4
TEMPORADA 1985/1986
LIGA BRASILEÑA GRUPO 10
Equipo PJ GF GC Puntos
1 Guaraní Guaraní 16 26 6 25
2 Fluminense Fluminense 16 21 8 22
3 Flamengo Flamengo 16 18 10 17
4 Grêmio Grêmio 16 16 15 15
5 Santa Cruz Santa Cruz 16 13 16 15
6 Goiás EC Goiás EC 16 17 21 15
7 Atlético GO Atlético 16 14 20 13
8 Vitória Vitória 16 11 20 12
9 Central SC Central SC 16 11 31 10

  USO DE MEMORIA  
6,648,512 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1490
Total Execution Time  0.1502
  CADENA URL  
/historico/Fluminense-Rio-Janeiro/1997
  GET DATOS  
$_GET['/historico/Fluminense-Rio-Janeiro/1997']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0078  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 = 'Fluminense-Rio-Janeiro' AND l.year = 1997 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.0021  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=1158 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=1158 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=1158 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 25238
0.0026  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 = 26031
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1158 AND type_rel = 2
0.0034  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1158 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1313522,1232,1508,2367,2395) ORDER BY n.cover_points DESC, update_date DESC
0.0041  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 = '1158' AND l.year = 1997 ORDER BY l.year DESC,cat.coefficient DESC
0.0040  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 = '1158' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 25238 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 26031 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043  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=1158 AND l.year in (1996,1997,1998) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (26034,25248) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 25248 AND teamId = 1158
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 26034 AND teamId = 1158
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 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 = 25238 AND t.round = 25 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 events1997 e ON e.player_id = p.id AND e.league_id = 25238 WHERE rp.league_id = 25238 AND rp.teamId = 1158 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.0019  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 events1997 e ON e.player_id = p.id AND e.league_id = 25238 WHERE rp.league_id = 25238 AND rp.teamId = 1158 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 events1997 e ON e.player_id = p.id AND e.league_id = 25238 WHERE rp.league_id = 25238 AND rp.teamId = 1158 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042  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 = 1158 AND l.year <= 1997 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 25238 AND t.round = 25 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 = 25248 AND t.round = 23 ORDER BY team.conference 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 `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 = 25264 AND t.round = 11 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 `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 = 25265 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 `tables1994` 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 = 25272 AND t.round = 10 ORDER BY team.conference 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 `tables1994` 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 = 25275 AND t.round = 7 ORDER BY team.conference 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 `tables1994` 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 = 25278 AND t.round = 8 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 `tables1993` 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 = 25298 AND t.round = 14 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 `tables1992` 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 = 25323 AND t.round = 19 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 `tables1991` 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 = 25329 AND t.round = 19 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 `tables1990` 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 = 25331 AND t.round = 10 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 `tables1990` 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 = 25333 AND t.round = 9 ORDER BY team.conference 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 `tables1989` 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 = 25346 AND t.round = 8 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 `tables1989` 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 = 25343 AND t.round = 11 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 `tables1988` 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 = 25348 AND t.round = 12 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 `tables1988` 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 = 25349 AND t.round = 11 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 `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 = 25400 AND t.round = 8 ORDER BY team.conference 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 `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 = 25403 AND t.round = 7 ORDER BY team.conference 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 `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 = 25410 AND t.round = 11 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 `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 = 25434 AND t.round = 21 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 = 25238 ORDER BY nameShow LIMIT 100