4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1967/1968
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Nürnberg Nürnberg 34 71 37 47
2 Werder Bremen Werder 34 68 51 44
3 B. Mönchengladbach Mönchenglad 34 77 45 42
4 Köln Köln 34 68 52 38
5 Bayern München Bayern 34 68 58 38
6 Eintracht Frankfurt Eintracht 34 58 51 38
7 MSV Duisburg Duisburg 34 69 58 36
8 Stuttgart Stuttgart 34 65 54 35
9 Eintracht Braunschweig Eintracht 34 37 39 35
10 Hannover 96 Hannover 96 34 48 52 34
11 Alemannia Aachen Alemannia 34 52 66 34
12 1860 München 1860 34 55 39 33
13 Hamburger SV Hamburger 34 51 54 33
14 B. Dortmund B. Dortmund 34 60 59 31
15 Schalke 04 Schalke 04 34 42 48 30
16 Kaiserslautern Kaiserslaute 34 39 67 28
17 Neunkirchen Neunkirchen 34 33 93 19
18 Karlsruher SC Karlsruher 34 32 70 17
TEMPORADA 1966/1967
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Eintracht Braunschweig Eintracht 34 49 27 43
2 1860 München 1860 34 60 47 41
3 B. Dortmund B. Dortmund 34 70 41 39
4 Eintracht Frankfurt Eintracht 34 66 49 39
5 Kaiserslautern Kaiserslaute 34 43 42 38
6 Bayern München Bayern 34 62 47 37
7 Köln Köln 34 48 48 37
8 B. Mönchengladbach Mönchenglad 34 70 49 34
9 Hannover 96 Hannover 96 34 40 46 34
10 Nürnberg Nürnberg 34 43 50 34
11 MSV Duisburg Duisburg 34 40 42 33
12 Stuttgart Stuttgart 34 48 54 33
13 Karlsruher SC Karlsruher 34 54 62 31
14 Hamburger SV Hamburger 34 37 53 30
15 Schalke 04 Schalke 04 34 37 63 30
16 Werder Bremen Werder 34 49 56 29
17 Fortuna Düsseldorf Fortuna 34 44 66 25
18 Rot-Weiss Essen Rot-Weiss 34 35 53 25
TEMPORADA 1965/1966
BUNDESLIGA
Equipo PJ GF GC Puntos
1 1860 München 1860 34 80 40 50
2 B. Dortmund B. Dortmund 34 70 36 47
3 Bayern München Bayern 34 71 38 47
4 Werder Bremen Werder 34 76 40 45
5 Köln Köln 34 74 41 44
6 Nürnberg Nürnberg 34 54 43 39
7 Eintracht Frankfurt Eintracht 34 64 46 38
8 MSV Duisburg Duisburg 34 70 48 36
9 Hamburger SV Hamburger 34 64 52 34
10 Eintracht Braunschweig Eintracht 34 49 49 34
11 Stuttgart Stuttgart 34 42 48 32
12 Hannover 96 Hannover 96 34 59 57 30
13 B. Mönchengladbach Mönchenglad 34 57 68 29
14 Schalke 04 Schalke 04 34 33 55 27
15 Kaiserslautern Kaiserslaute 34 42 65 26
16 Karlsruher SC Karlsruher 34 35 71 24
17 Neunkirchen Neunkirchen 34 32 82 22
18 Tasmania Berlin Tasmania 34 15 108 8
TEMPORADA 1964/1965
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Werder Bremen Werder 30 54 29 41
2 Köln Köln 30 66 45 38
3 B. Dortmund B. Dortmund 30 67 48 36
4 1860 München 1860 30 70 50 35
5 Hannover 96 Hannover 96 30 48 42 33
6 Nürnberg Nürnberg 30 44 38 32
7 MSV Duisburg Duisburg 30 46 48 32
8 Eintracht Frankfurt Eintracht 30 50 58 29
9 Eintracht Braunschweig Eintracht 30 42 47 28
10 Neunkirchen Neunkirchen 30 44 48 27
11 Hamburger SV Hamburger 30 46 56 27
12 Stuttgart Stuttgart 30 46 50 26
13 Kaiserslautern Kaiserslaute 30 41 53 25
14 Hertha BSC Hertha BSC 30 40 62 25
15 Karlsruher SC Karlsruher 30 47 62 24
16 Schalke 04 Schalke 04 30 45 60 22
TEMPORADA 1963/1964
BUNDESLIGA
Equipo PJ GF GC Puntos
1 Köln Köln 30 78 40 45
2 MSV Duisburg Duisburg 30 60 36 39
3 Eintracht Frankfurt Eintracht 30 65 41 39
4 B. Dortmund B. Dortmund 30 73 57 33
5 Stuttgart Stuttgart 30 48 40 33
6 Hamburger SV Hamburger 30 69 60 32
7 1860 München 1860 30 66 50 31
8 Schalke 04 Schalke 04 30 51 53 29
9 Nürnberg Nürnberg 30 45 56 29
10 Werder Bremen Werder 30 53 62 28
11 Eintracht Braunschweig Eintracht 30 36 49 28
12 Kaiserslautern Kaiserslaute 30 48 69 26
13 Karlsruher SC Karlsruher 30 42 55 24
14 Hertha BSC Hertha BSC 30 45 65 24
15 Preußen Münster Preußen 30 34 52 23
16 1. FC Saarbrücken Saarbrücken 30 44 72 17
TEMPORADA 1962/1963
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Hamburger SV Hamburger 30 100 40 71
2 Werder Bremen Werder 30 102 44 69
3 Eintracht Braunschweig Eintracht 30 62 41 54
4 VfR Neumunster Neumunster 30 48 46 49
5 Holstein Kiel Holstein 30 73 58 48
6 FC St Pauli FC St Pauli 30 48 45 41
7 VfL Osnabrück Osnabrück 30 44 46 40
8 Hannover 96 Hannover 96 30 47 61 39
9 VfV 06 Hildesheim Hildesheim 30 51 62 38
10 Arminia Hannover Arminia 30 56 64 37
11 Bergedorf 85 Bergedorf 30 44 57 35
12 TuS Bremerhaven 93 Bremerhaven 30 40 56 33
13 VfB Oldenburg Oldenburg 30 46 67 32
14 Concordia Hamburg Concordia 30 43 64 32
15 Altona 93 Altona 93 30 51 76 32
16 VfB Lübeck VfB Lübeck 30 37 65 27
TEMPORADA 1961/1962
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Hamburger SV Hamburger 28 93 33 68
2 Werder Bremen Werder 28 84 30 60
3 VfV 06 Hildesheim Hildesheim 28 73 35 59
4 Holstein Kiel Holstein 28 82 47 53
5 FC St Pauli FC St Pauli 28 67 47 53
6 Eintracht Braunschweig Eintracht 28 62 51 46
7 Bergedorf 85 Bergedorf 28 45 50 37
8 VfR Neumunster Neumunster 28 47 54 36
9 VfL Osnabrück Osnabrück 28 37 52 36
10 VfB Oldenburg Oldenburg 28 39 56 33
11 Altona 93 Altona 93 28 42 73 31
12 TuS Bremerhaven 93 Bremerhaven 28 31 62 28
13 Concordia Hamburg Concordia 28 42 48 27
14 Hannover 96 Hannover 96 28 44 57 27
15 Bremer SV Bremer SV 28 38 79 24
16 Eintracht Nordhorn Eintracht 28 40 92 14
TEMPORADA 1960/1961
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Hamburger SV Hamburger 30 101 31 74
2 Werder Bremen Werder 30 73 47 62
3 VfL Osnabrück Osnabrück 30 69 43 56
4 FC St Pauli FC St Pauli 30 60 46 52
5 Hannover 96 Hannover 96 30 64 43 50
6 Altona 93 Altona 93 30 49 53 43
7 Holstein Kiel Holstein 30 49 49 41
8 VfV 06 Hildesheim Hildesheim 30 48 52 40
9 Eintracht Braunschweig Eintracht 30 52 57 38
10 VfB Oldenburg Oldenburg 30 45 55 33
11 VfR Neumunster Neumunster 30 44 56 33
12 Concordia Hamburg Concordia 30 44 69 32
13 TuS Bremerhaven 93 Bremerhaven 30 38 68 32
14 Bergedorf 85 Bergedorf 30 37 57 31
15 VfB Lübeck VfB Lübeck 30 38 50 29
16 Heider SV Heider SV 30 38 73 25
TEMPORADA 1959/1960
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Hamburger SV Hamburger 22 69 25 48
2 Werder Bremen Werder 22 58 35 43
3 VfL Osnabrück Osnabrück 22 41 26 42
4 FC St Pauli FC St Pauli 22 43 24 40
5 TuS Bremerhaven 93 Bremerhaven 22 42 31 39
6 Eintracht Braunschweig Eintracht 22 35 30 34
7 Concordia Hamburg Concordia 22 34 42 31
8 Holstein Kiel Holstein 22 36 28 30
9 Hannover 96 Hannover 96 22 36 39 29
10 VfB Lübeck VfB Lübeck 22 30 38 29
11 VfV 06 Hildesheim Hildesheim 21 27 35 28
12 Altona 93 Altona 93 22 29 34 23
13 VfR Neumunster Neumunster 22 31 38 23
14 Phönix Lübeck Phönix 22 24 51 22
15 Bergedorf 85 Bergedorf 22 31 52 18
16 Eintracht Osnabruck Eintracht 21 19 57 8

  USO DE MEMORIA  
6,614,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5588
Total Execution Time  0.5603
  CADENA URL  
/historico/Hamburger-Sv/1968
  GET DATOS  
$_GET['/historico/Hamburger-Sv/1968']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0143  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 = 'Hamburger-Sv' AND l.year = 1968 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=1286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=1286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=1286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1286 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 5430
0.0136  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 = 22461
0.0137  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 = 11039
0.0172  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 = '1286' AND l.year = 1968 ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '1286' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 5430 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 22461 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 11039 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=1286 AND l.year in (1967,1968,1969) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (22463,11086,11039,5431) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 5431 AND teamId = 1286
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 22463 AND teamId = 1286
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 11086 AND teamId = 1286
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 11039 AND teamId = 1286
0.0129  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables1968` 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 = 5430 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141  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 events1968 e ON e.player_id = p.id AND e.league_id = 5430 WHERE rp.league_id = 5430 AND rp.teamId = 1286 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.0130  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 events1968 e ON e.player_id = p.id AND e.league_id = 5430 WHERE rp.league_id = 5430 AND rp.teamId = 1286 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 events1968 e ON e.player_id = p.id AND e.league_id = 5430 WHERE rp.league_id = 5430 AND rp.teamId = 1286 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 1286 AND l.year <= 1968 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 `tables1968` 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 = 5430 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1967` 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 = 5429 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1966` 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 = 5428 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1965` 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 = 5427 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables1964` 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 = 5426 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables1963` 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 = 47428 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables1962` 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 = 47432 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 `tables1961` 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 = 47434 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 47456 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC