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 1995/1996
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 2
Equipo PJ GF GC Puntos
1 Fluminense Fluminense 11 10 4 21
2 Internacional Internaciona 11 15 10 21
3 São Paulo São Paulo 11 9 5 19
4 Santos FC Santos FC 11 19 18 19
5 Portuguesa Portuguesa 11 16 14 18
6 Goiás EC Goiás EC 11 15 9 16
7 Criciúma Criciúma 11 10 8 15
8 Bahía Bahía 11 13 16 14
9 Sport Recife Sport Recife 11 9 11 12
10 Atl. Mineiro Atl. Mineiro 11 9 12 11
11 Vasco da Gama Vasco Gama 11 14 20 11
12 União São João União São 11 7 19 4
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 4
Equipo PJ GF GC Puntos
1 São Paulo São Paulo 8 14 4 13
2 Botafogo Botafogo 8 10 8 11
3 Flamengo Flamengo 8 10 6 9
4 Atl. Mineiro Atl. Mineiro 8 8 5 8
5 Corinthians Corinthians 8 4 7 7
6 Inter de Limeira Inter 8 5 11 5
7 Náutico Náutico 8 11 18 5
8 Internacional Internaciona 8 8 13 4
9 Cruzeiro Cruzeiro 8 15 6 13
10 Vasco da Gama Vasco Gama 8 12 9 10
11 Portuguesa Portuguesa 8 9 6 9
12 Palmeiras Palmeiras 8 8 8 8
13 Goiás EC Goiás EC 8 7 9 8
14 Grêmio Grêmio 8 8 8 7
15 Santos FC Santos FC 8 7 9 7
16 Fluminense Fluminense 8 6 15 4
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 1
Equipo PJ GF GC Puntos
1 São Paulo São Paulo 10 21 7 17
2 Internacional Internaciona 10 13 5 14
3 Sport Recife Sport Recife 10 11 6 13
4 Bangu Bangu 10 11 6 12
5 Fluminense Fluminense 10 9 7 12
6 Ceará Ceará 10 8 10 10
7 Sobradinho Sobradinho 10 8 12 8
8 Operário MS Operário 10 9 15 7
9 Remo Remo 10 9 15 6
10 Sampaio Correa Sampaio 10 5 15 6
11 Coritiba Coritiba 10 3 9 5
TEMPORADA 1984/1985
LIGA BRASILEÑA GRUPO 1
Equipo PJ GF GC Puntos
1 Atl. Mineiro Atl. Mineiro 10 17 8 15
2 Corinthians Corinthians 10 14 6 13
3 Guaraní Guaraní 10 17 12 12
4 Grêmio Grêmio 10 13 9 12
5 Fluminense Fluminense 10 12 11 10
6 Botafogo Botafogo 10 14 16 10
7 Palmeiras Palmeiras 10 13 14 8
8 Coritiba Coritiba 10 8 14 7
9 América RJ América RJ 10 8 15 6
10 Santa Cruz Santa Cruz 10 8 20 6
11 Flamengo Flamengo 10 12 5 14
12 Internacional Internaciona 10 18 9 13
13 Vasco da Gama Vasco Gama 10 18 16 11
14 Náutico Náutico 10 11 9 11
15 Cruzeiro Cruzeiro 10 11 10 10
16 São Paulo São Paulo 10 17 19 10
17 Santos FC Santos FC 10 11 13 10
18 Bahía Bahía 10 8 10 10
19 Goiás EC Goiás EC 10 10 17 6
20 Portuguesa Portuguesa 10 9 16 6

  USO DE MEMORIA  
6,519,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1448
Total Execution Time  0.1464
  CADENA URL  
/historico/Fluminense-Rio-Janeiro/1996
  GET DATOS  
$_GET['/historico/Fluminense-Rio-Janeiro/1996']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0039  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 = 1996 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=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.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=1158 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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 = 25248
0.0023  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 = 26034
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1158 AND type_rel = 2
0.0038  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.0024  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 = 1996 ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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.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 = 25248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 26034 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0049  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 (1995,1996,1997) 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,25287) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 25287 AND teamId = 1158
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 26034 AND teamId = 1158
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 events1996 e ON e.player_id = p.id AND e.league_id = 25248 WHERE rp.league_id = 25248 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.0018  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 events1996 e ON e.player_id = p.id AND e.league_id = 25248 WHERE rp.league_id = 25248 AND rp.teamId = 1158 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0018  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 events1996 e ON e.player_id = p.id AND e.league_id = 25248 WHERE rp.league_id = 25248 AND rp.teamId = 1158 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032  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 <= 1996 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 `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.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 = 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.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 `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.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 `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.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 `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.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 = 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.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 `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.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 `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.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.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 `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.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 `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.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 `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.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 `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.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 `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 = 25451 AND t.round = 10 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 = 25248 ORDER BY nameShow LIMIT 100