4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Viktoria Berlin Sub 17
TEMPORADA 2023/2024
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 RB Leipzig Sub 17 Leipzig 26 87 26 66
2 Wolfsburg Sub 17 Wolfsburg 26 84 34 59
3 Werder Bremen Sub 17 Werder 26 92 48 53
4 Hertha BSC Sub 17 Hertha 26 68 33 52
5 Holstein Kiel Sub 17 Holstein 26 53 65 39
6 Chemnitzer Sub 17 Chemnitzer 26 34 53 36
7 Hamburger SV Sub 17 Hamburger 26 56 56 35
8 Energie Cottbus Sub 17 Energie 26 58 69 34
9 Hannover 96 Sub 17 Hannover 26 50 48 33
10 Union Berlin Sub 17 Union Berlin 26 51 58 33
11 Dynamo Dresden Sub 17 Dynamo 26 37 51 32
12 Viktoria Berlin Sub 17 Viktoria 26 46 65 23
13 Blumenthaler Sub 17 Blumenthaler 26 27 83 13
14 FC St. Pauli Sub 17 Pauli 26 26 80 11
TEMPORADA 2022/2023
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Wolfsburg Sub 17 Wolfsburg 16 38 15 42
2 Chemnitzer Sub 17 Chemnitzer 16 32 24 32
3 RB Leipzig Sub 17 Leipzig 16 45 25 30
4 Werder Bremen Sub 17 Werder 16 44 31 29
5 Hertha BSC Sub 17 Hertha 16 39 26 27
6 Dynamo Dresden Sub 17 Dynamo 16 34 19 26
7 Hamburger SV Sub 17 Hamburger 16 39 27 26
8 Hannover 96 Sub 17 Hannover 16 32 24 25
9 FC St. Pauli Sub 17 Pauli 16 25 24 24
10 Viktoria Berlin Sub 17 Viktoria 16 36 33 23
11 Union Berlin Sub 17 Union Berlin 16 33 35 23
12 1. FC Magdeburg Sub 17 Magdeburg 16 25 26 22
13 Hansa Rostock Sub 17 Hansa 16 23 33 20
14 Niendorfer TSV Sub 17 Niendorfer 16 25 35 18
15 Meppen Sub 17 Meppen 16 15 40 7
16 Erzgebirge Aue Sub 17 Erzgebirge 16 13 36 6
17 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 16 14 59 4
TEMPORADA 2021/2022
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Hertha BSC Sub 17 Hertha 18 57 9 48
2 Hamburger SV Sub 17 Hamburger 18 41 17 39
3 FC St. Pauli Sub 17 Pauli 18 38 14 38
4 Chemnitzer Sub 17 Chemnitzer 18 26 21 34
5 Wolfsburg Sub 17 Wolfsburg 18 42 21 33
6 RB Leipzig Sub 17 Leipzig 18 34 23 33
7 Dynamo Dresden Sub 17 Dynamo 18 31 23 31
8 Werder Bremen Sub 17 Werder 18 43 33 30
9 Union Berlin Sub 17 Union Berlin 18 26 21 29
10 Hannover 96 Sub 17 Hannover 18 27 30 29
11 Viktoria Berlin Sub 17 Viktoria 18 25 30 24
12 Hansa Rostock Sub 17 Hansa 18 23 28 23
13 Erzgebirge Aue Sub 17 Erzgebirge 18 13 29 17
14 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 18 14 26 16
15 Holstein Kiel Sub 17 Holstein 18 26 40 16
16 Energie Cottbus Sub 17 Energie 18 24 47 16
17 Hertha Zehlendorf Sub 17 Hertha 18 17 32 12
18 E. Braunschweig Sub 17 Braunschweig 18 12 34 11
19 Hallescher FC Sub 17 Hallescher 18 12 53 9
TEMPORADA 2020/2021
BUNDESLIGA SUB 17 GRUPO 1
Equipo PJ GF GC Puntos
1 Werder Bremen Sub 17 Werder 5 16 2 13
2 Dynamo Dresden Sub 17 Dynamo 5 18 5 13
3 Hannover 96 Sub 17 Hannover 4 17 1 12
4 Viktoria Berlin Sub 17 Viktoria 5 8 6 12
5 RB Leipzig Sub 17 Leipzig 5 13 7 10
6 Hertha BSC Sub 17 Hertha 4 11 6 10
7 FC St. Pauli Sub 17 Pauli 5 12 8 7
8 Holstein Kiel Sub 17 Holstein 5 13 12 7
9 Hertha Zehlendorf Sub 17 Hertha 5 12 11 7
10 Wolfsburg Sub 17 Wolfsburg 5 12 11 7
11 Hallescher FC Sub 17 Hallescher 5 6 8 7
12 Union Berlin Sub 17 Union Berlin 4 11 7 6
13 Hamburger SV Sub 17 Hamburger 4 5 7 4
14 E. Braunschweig Sub 17 Braunschweig 4 4 15 0
15 Energie Cottbus Sub 17 Energie 5 1 14 0
16 FC Carl Zeiss Jena Sub 17 Carl Zeiss. 5 3 21 0
17 Chemnitzer Sub 17 Chemnitzer 5 3 24 0

  USO DE MEMORIA  
5,192,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.5382
Total Execution Time  0.5403
  CADENA URL  
/historico/Viktoria-Berlin-Sub-17
  GET DATOS  
$_GET['/historico/Viktoria-Berlin-Sub-17']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0187  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 = 'Viktoria-Berlin-Sub-17' 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.0151  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=138030 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=138030 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0314  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 = 72763
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=138030 AND type_rel = 2
0.0153  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2021 AND type_rel = 3
0.0158  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2021 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0159  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 (1241729,1237020,1178797,1135514,949672) ORDER BY n.cover_points DESC, update_date DESC
0.0158  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 = '138030' ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '138030' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '138030' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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 = 72763 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0161  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=138030 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (72763) 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.0160  SELECT count(id) as num_players from rel_players WHERE league_id = 72763 AND teamId = 138030
0.0149  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 = '138030' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '138030' and rp.type = 4
0.0148  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 = '138030' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0170  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 = 72763 WHERE rp.league_id = 72763 AND rp.teamId = 138030 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.0182  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 = 72763 WHERE rp.league_id = 72763 AND rp.teamId = 138030 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0185  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 = 72763 WHERE rp.league_id = 72763 AND rp.teamId = 138030 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 138030 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0162  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 = 72763 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2023` 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 = 68734 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.0165  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 `tables2022` 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 = 63884 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.0164  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 = 57817 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