4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Nürnberg Sub 19
TEMPORADA 2010/2011
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Kaiserslautern Sub 19 Kaiserslaute 26 55 38 55
2 1860 München Sub 19 1860 26 45 32 54
3 Freiburg Sub 19 Freiburg 26 67 27 50
4 VfB Stuttgart Sub 19 Stuttgart 26 58 32 48
5 Nürnberg Sub 19 Nürnberg 26 69 44 48
6 Mainz 05 Sub 19 Mainz 26 49 36 39
7 Bayern München Sub 19 Bayern 26 40 35 37
8 Eintracht Frankfurt Sub 19 Eintracht 26 34 41 34
9 Hoffenheim Sub 19 Hoffenheim 26 51 53 33
10 Greuther Fürth Sub 19 Greuther 26 54 58 30
11 Karlsruher SC Sub 19 Karlsruher 26 28 41 27
12 Ulm Sub 19 Ulm Sub 19 26 31 69 18
13 FC Augsburg Sub 19 Augsburg 26 22 58 17
14 Wehen Wiesbaden Sub 19 Wehen 26 21 60 16
TEMPORADA 2009/2010
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 VfB Stuttgart Sub 19 Stuttgart 26 62 24 58
2 Mainz 05 Sub 19 Mainz 26 61 44 53
3 Karlsruher SC Sub 19 Karlsruher 26 55 35 50
4 Freiburg Sub 19 Freiburg 26 56 39 49
5 Hoffenheim Sub 19 Hoffenheim 26 61 41 44
6 Nürnberg Sub 19 Nürnberg 26 49 35 44
7 1860 München Sub 19 1860 26 50 31 43
8 Kaiserslautern Sub 19 Kaiserslaute 26 44 40 40
9 Bayern München Sub 19 Bayern 26 54 40 34
10 Eintracht Frankfurt Sub 19 Eintracht 26 54 62 31
11 Greuther Fürth Sub 19 Greuther 26 41 52 31
12 Darmstadt 98 Sub 19 Darmstadt 26 28 56 21
13 Waldhof Mannheim Sub 19 Waldhof 26 25 67 13
14 SSV Jahn Regensburg Sub 19 Jahn 26 21 95 8
TEMPORADA 2006/2007
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 26 59 22 57
2 Kaiserslautern Sub 19 Kaiserslaute 26 42 29 49
3 Mainz 05 Sub 19 Mainz 26 53 39 48
4 VfB Stuttgart Sub 19 Stuttgart 26 50 31 45
5 Freiburg Sub 19 Freiburg 26 44 24 42
6 Greuther Fürth Sub 19 Greuther 26 29 27 42
7 1860 München Sub 19 1860 26 44 33 39
8 Wacker Burghausen Sub 19 Wacker 26 35 41 37
9 Karlsruher SC Sub 19 Karlsruher 26 34 37 31
10 Hoffenheim Sub 19 Hoffenheim 26 33 38 30
11 Stuttgarter Kickers Sub 19 Stuttgarter 26 32 50 28
12 Nürnberg Sub 19 Nürnberg 26 32 52 23
13 Reutlingen Sub 19 Reutlingen 26 24 60 19
14 Ulm Sub 19 Ulm Sub 19 26 25 53 18
TEMPORADA 2005/2006
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Freiburg Sub 19 Freiburg 26 70 18 56
2 Bayern München Sub 19 Bayern 26 71 27 56
3 VfB Stuttgart Sub 19 Stuttgart 26 52 29 51
4 1860 München Sub 19 1860 26 45 32 43
5 Karlsruher SC Sub 19 Karlsruher 26 45 37 38
6 Kaiserslautern Sub 19 Kaiserslaute 26 41 37 37
7 Ulm Sub 19 Ulm Sub 19 26 31 36 37
8 Nürnberg Sub 19 Nürnberg 26 33 28 36
9 Hoffenheim Sub 19 Hoffenheim 26 41 46 33
10 Greuther Fürth Sub 19 Greuther 26 36 41 33
11 Stuttgarter Kickers Sub 19 Stuttgarter 26 27 48 32
12 Eintracht Frankfurt Sub 19 Eintracht 26 37 44 27
13 SSV Jahn Regensburg Sub 19 Jahn 26 37 63 26
14 Eintracht Trier Sub 19 Eintracht 26 23 103 6
TEMPORADA 2004/2005
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 VfB Stuttgart Sub 19 Stuttgart 26 57 37 52
2 Greuther Fürth Sub 19 Greuther 26 56 35 50
3 Kaiserslautern Sub 19 Kaiserslaute 26 50 24 46
4 1860 München Sub 19 1860 26 64 47 46
5 Nürnberg Sub 19 Nürnberg 26 46 35 42
6 Bayern München Sub 19 Bayern 26 48 34 40
7 Karlsruher SC Sub 19 Karlsruher 26 40 46 35
8 Freiburg Sub 19 Freiburg 26 47 43 34
9 Eintracht Frankfurt Sub 19 Eintracht 26 29 40 32
10 Ulm Sub 19 Ulm Sub 19 26 39 57 29
11 Stuttgarter Kickers Sub 19 Stuttgarter 26 48 71 28
12 Unterhaching Sub 19 Unterhaching 26 30 44 24
13 Mainz 05 Sub 19 Mainz 26 44 59 23
14 Darmstadt 98 Sub 19 Darmstadt 26 36 62 19
TEMPORADA 2003/2004
BUNDESLIGA SUB 19 GRUPO 2
Equipo PJ GF GC Puntos
1 Bayern München Sub 19 Bayern 26 84 30 67
2 Greuther Fürth Sub 19 Greuther 26 55 24 58
3 1860 München Sub 19 1860 26 51 26 49
4 VfB Stuttgart Sub 19 Stuttgart 26 64 32 46
5 Freiburg Sub 19 Freiburg 26 65 31 44
6 Eintracht Frankfurt Sub 19 Eintracht 26 42 41 44
7 Kaiserslautern Sub 19 Kaiserslaute 26 46 29 42
8 Mainz 05 Sub 19 Mainz 26 44 44 36
9 Nürnberg Sub 19 Nürnberg 26 48 42 34
10 Stuttgarter Kickers Sub 19 Stuttgarter 26 39 41 34
11 Ulm Sub 19 Ulm Sub 19 26 37 45 22
12 Saarbrücken Sub 19 Saarbrücken 26 32 78 22
13 Kickers Offenbach FC Sub 19 Kickers 26 21 83 16
14 KSV Baunatal Sub 19 Baunatal 26 19 101 7

  USO DE MEMORIA  
5,346,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4417
Total Execution Time  0.4429
  CADENA URL  
/historico/Nurnberg-Sub19/2011
  GET DATOS  
$_GET['/historico/Nurnberg-Sub19/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0137  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 = 'Nurnberg-Sub19' AND l.year = 2011 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.0127  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=60926 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  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=60926 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60926 AND type_rel = 2
0.0130  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 = '60926' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '60926' AND l.year = 2011 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '60926' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 44067 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=60926 AND l.year in (2010,2011,2012) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (44166,44070) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 44070 AND teamId = 60926
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 44166 AND teamId = 60926
0.0151  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2011` 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 = 44067 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0130  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 = '60926' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '60926' and rp.type = 4
0.0130  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 = '60926' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 events2011 e ON e.player_id = p.id AND e.league_id = 44067 WHERE rp.league_id = 44067 AND rp.teamId = 60926 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.0151  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 events2011 e ON e.player_id = p.id AND e.league_id = 44067 WHERE rp.league_id = 44067 AND rp.teamId = 60926 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 events2011 e ON e.player_id = p.id AND e.league_id = 44067 WHERE rp.league_id = 44067 AND rp.teamId = 60926 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 60926 AND l.year <= 2011 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0132  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 `tables2010` 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 = 44070 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 `tables2007` 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 = 44087 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2006` 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 = 44088 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 `tables2005` 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 = 44089 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 `tables2004` 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 = 44090 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 44067 ORDER BY nameShow LIMIT 100