4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1959/1960
Equipo PJ GF GC Puntos
1 Karlsruher SC Karlsruher 30 78 39 65
2 Kickers Offenbach FC Kickers 30 75 45 56
3 Bayern München Bayern 30 81 55 55
4 Eintracht Frankfurt Eintracht 30 81 57 53
5 Nürnberg Nürnberg 30 73 54 49
6 1860 München 1860 30 65 56 49
7 Stuttgart Stuttgart 30 66 57 46
8 Reutlingen Reutlingen 30 55 57 43
9 FSV Frankfurt Frankfurt 30 59 53 39
10 VfR Mannheim Mannheim 30 55 52 38
11 Greuther Fürth Greuther 30 48 59 36
12 Schweinfurt Schweinfurt 30 48 64 35
13 Bayern Hof Bayern Hof 30 45 84 35
14 Ulm Ulm 30 39 64 29
15 Viktoria Aschaffenburg Viktoria 30 43 73 28
16 Stuttgarter Kickers Stuttgarter 30 38 80 20

  USO DE MEMORIA  
4,937,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.3017
Total Execution Time  0.3036
  CADENA URL  
/oberliga1960/grupo4/historico
  GET DATOS  
$_GET['/oberliga1960/grupo4/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0125  SELECT type FROM routes WHERE alias = 'oberliga1960'
0.0264  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'oberliga' AND (l.group_code = 4 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1960 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=4 DESC LIMIT 1
0.0129  SELECT id,name,alias,stepParent FROM categories WHERE parentId=573 ORDER BY order_id ASC
0.0136  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 28418 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 573 AND group_code = 4 and tables = 1 AND year <= 1960 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1960` 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 = 28418 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 22:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 22:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 22:10:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0139  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'oberliga' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1960 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0135  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1960 e ON e.player_id = p.id AND e.league_id = 28418 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28418 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1960 e ON e.player_id = p.id AND e.league_id = 28418 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28418 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0129  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1960 e ON e.player_id = p.id AND e.league_id = 28418 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 28418 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0155  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1960` 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 = 28418 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC