4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Fluminense Sub 20
TEMPORADA 2020/2021
LIGA BRASILEÑA SUB 20
Equipo PJ GF GC Puntos
1 Flamengo Sub 20 Flamengo 19 40 20 39
2 Palmeiras Sub 20 Palmeiras 19 40 24 38
3 Atlético Mineiro Sub 20 Atlético 19 39 18 37
4 São Paulo Sub 20 São Paulo 19 34 24 34
5 Athlético PR Sub 20 Athlético 19 38 33 33
6 Botafogo Sub 20 Botafogo 19 33 28 33
7 Internacional Sub 20 Internaciona 19 32 23 32
8 Vasco Da Gama Sub 20 Vasco Gama 19 36 21 31
9 Fluminense Sub 20 Fluminense 19 30 22 29
10 Cruzeiro Sub 20 Cruzeiro 19 29 26 29
11 Grêmio Sub 20 Grêmio 19 38 36 29
12 Corinthians Sub 20 Corinthians 19 38 34 27
13 América Mineiro Sub 20 América 19 28 25 27
14 Chapecoense Sub 20 Chapecoense 19 30 34 21
15 Sport Recife Sub 20 Sport Recife 19 20 36 18
16 Ceará Sub 20 Ceará 19 20 29 18
17 Santos Sub 20 Santos 19 20 43 13
18 Fortaleza Sub 20 Fortaleza 19 16 38 13
19 Bahia Sub 20 Bahia 19 25 45 13
20 Atlético GO Sub 20 Atlético 19 17 44 12
TEMPORADA 2019/2020
LIGA BRASILEÑA SUB 20
Equipo PJ GF GC Puntos
1 Atlético Mineiro Sub 20 Atlético 19 36 20 38
2 Athlético PR Sub 20 Athlético 19 44 21 37
3 Fluminense Sub 20 Fluminense 19 29 20 35
4 Grêmio Sub 20 Grêmio 19 36 27 33
5 Corinthians Sub 20 Corinthians 19 31 27 31
6 Flamengo Sub 20 Flamengo 19 30 18 31
7 São Paulo Sub 20 São Paulo 19 29 22 31
8 Palmeiras Sub 20 Palmeiras 19 31 33 30
9 Botafogo Sub 20 Botafogo 19 30 20 30
10 Internacional Sub 20 Internaciona 19 23 23 28
11 Vitória Sub 20 Vitória 19 25 28 27
12 Sport Recife Sub 20 Sport Recife 19 18 32 23
13 Vasco Da Gama Sub 20 Vasco Gama 19 27 27 23
14 Goiás Sub 20 Goiás 19 29 34 23
15 América Mineiro Sub 20 América 19 25 29 21
16 Bahia Sub 20 Bahia 19 22 32 20
17 Chapecoense Sub 20 Chapecoense 19 22 37 19
18 Santos Sub 20 Santos 19 21 35 18
19 Cruzeiro Sub 20 Cruzeiro 19 21 37 17
20 Ceará Sub 20 Ceará 19 26 33 16
TEMPORADA 2018/2019
LIGA BRASILEÑA SUB 20
Equipo PJ GF GC Puntos
1 Vasco Da Gama Sub 20 Vasco Gama 19 33 16 42
2 Flamengo Sub 20 Flamengo 19 38 18 41
3 Corinthians Sub 20 Corinthians 19 30 13 41
4 Palmeiras Sub 20 Palmeiras 19 29 17 36
5 Cruzeiro Sub 20 Cruzeiro 19 25 18 34
6 Fluminense Sub 20 Fluminense 19 29 25 32
7 São Paulo Sub 20 São Paulo 19 31 19 31
8 Atlético Mineiro Sub 20 Atlético 19 28 20 31
9 Sport Recife Sub 20 Sport Recife 19 25 27 27
10 América Mineiro Sub 20 América 19 25 28 27
11 Athlético PR Sub 20 Athlético 19 32 29 26
12 Bahia Sub 20 Bahia 19 15 20 23
13 Santos Sub 20 Santos 19 29 37 23
14 Vitória Sub 20 Vitória 19 18 25 22
15 Coritiba Sub 20 Coritiba 19 18 28 21
16 Botafogo Sub 20 Botafogo 19 21 30 19
17 Internacional Sub 20 Internaciona 19 23 32 17
18 Grêmio Sub 20 Grêmio 19 22 33 17
19 Chapecoense Sub 20 Chapecoense 19 20 36 13
20 Ponte Preta Sub 20 Ponte Preta 19 8 28 6

  USO DE MEMORIA  
5,476,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1305
Total Execution Time  0.1320
  CADENA URL  
/historico/Fluminense-U20-Juvenil/2021
  GET DATOS  
$_GET['/historico/Fluminense-U20-Juvenil/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0034  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-U20-Juvenil' AND l.year = 2021 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=100404 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=100404 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=100404 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=100404 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 63064
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 = 61965
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 = 64000
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100404 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2175 AND type_rel = 3
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2175 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  SELECT /*53 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 (1286000,1242287,1196930,1194256,1187672) ORDER BY n.cover_points DESC, update_date DESC
0.0034  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 = '100404' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '100404' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 61965 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0068  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 = 63064 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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=100404 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (69595,67781,67745,66334) 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.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 67745 AND teamId = 100404
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 67781 AND teamId = 100404
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 69595 AND teamId = 100404
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 66334 AND teamId = 100404
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 `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 = 63064 AND t.round = 19 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 = '100404' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '100404' 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 = '100404' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 events2021 e ON e.player_id = p.id AND e.league_id = 63064 WHERE rp.league_id = 63064 AND rp.teamId = 100404 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.0031  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 events2021 e ON e.player_id = p.id AND e.league_id = 63064 WHERE rp.league_id = 63064 AND rp.teamId = 100404 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 events2021 e ON e.player_id = p.id AND e.league_id = 63064 WHERE rp.league_id = 63064 AND rp.teamId = 100404 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 100404 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0046  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 = 63064 AND t.round = 19 ORDER BY team.conference ASC,t.position 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 `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 = 58660 AND t.round = 19 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 = 51652 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC