4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 1967/1968
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 26 51 19 56
2 Hansa Rostock Hansa 26 37 27 49
3 Magdeburg Magdeburg 26 43 38 46
4 FC Vorwärts Berlin Vorwärts 26 34 29 37
5 Zwickau Zwickau 26 36 34 36
6 Lokomotive Leipzig Lokomotive 26 39 35 34
7 Union Berlin Union Berlin 26 26 35 34
8 Chemnitzer Chemnitzer 26 33 30 33
9 Rot-Weiss Erfurt Rot-Weiss 26 34 39 31
10 BSG Wismut Aue Wismut 26 32 40 31
11 Hallescher FC Hallescher 26 32 41 31
12 Chemie Leipzig Chemie 26 26 32 28
13 Lok Stendal Lok Stendal 26 26 42 27
14 Dynamo Dresden Dynamo 26 25 33 26
TEMPORADA 1966/1967
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Chemnitzer Chemnitzer 26 39 23 51
2 Lokomotive Leipzig Lokomotive 26 39 32 44
3 Dynamo Dresden Dynamo 26 35 31 38
4 FC Carl Zeiss Jena Carl Zeiss. 26 31 29 38
5 Lok Stendal Lok Stendal 26 39 44 38
6 BSG Wismut Aue Wismut 26 45 43 37
7 Hallescher FC Hallescher 26 38 41 37
8 Zwickau Zwickau 26 41 26 36
9 FC Vorwärts Berlin Vorwärts 26 43 34 36
10 Union Berlin Union Berlin 26 33 35 36
11 Hansa Rostock Hansa 26 27 27 35
12 Chemie Leipzig Chemie 26 35 38 34
13 BFC Dynamo BFC Dynamo 26 28 40 27
14 Wismut Gera Wismut Gera 26 27 57 16
TEMPORADA 1964/1965
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 51 24 54
2 FC Carl Zeiss Jena Carl Zeiss. 26 41 27 46
3 Sachsen Leipzig Sachsen 26 53 34 42
4 Chemie Leipzig Chemie 26 47 29 42
5 Hansa Rostock Hansa 26 37 33 41
6 Lok Stendal Lok Stendal 26 47 42 35
7 Zwickau Zwickau 26 36 46 33
8 Dynamo Dresden Dynamo 26 34 38 32
9 Chemnitzer Chemnitzer 26 36 41 31
10 BFC Dynamo BFC Dynamo 26 27 37 30
11 BSG Wismut Aue Wismut 26 23 36 30
12 SV Steinach 1908 Steinach 26 28 49 27
13 Neubrandenburg 04 Neubrandenbu 26 34 58 27
14 Magdeburg Magdeburg 13 23 21 17
15 Magdeburg II Magdeburg 13 12 14 17
TEMPORADA 1963/1964
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Chemie Leipzig Chemie 26 38 21 48
2 Hansa Rostock Hansa 26 40 23 46
3 Sachsen Leipzig Sachsen 26 34 27 44
4 Chemnitzer Chemnitzer 26 31 29 39
5 FC Vorwärts Berlin Vorwärts 26 45 36 36
6 FC Carl Zeiss Jena Carl Zeiss. 26 43 35 36
7 SV Steinach 1908 Steinach 26 30 36 33
8 Lok Stendal Lok Stendal 26 31 34 32
9 BFC Dynamo BFC Dynamo 26 35 34 31
10 Zwickau Zwickau 26 37 41 30
11 BSG Wismut Aue Wismut 26 23 32 30
12 Hallescher FC Hallescher 26 24 35 30
13 Magdeburg Magdeburg 26 25 38 30
14 Rot-Weiss Erfurt Rot-Weiss 26 23 38 25
TEMPORADA 1962/1963
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Carl Zeiss Jena Carl Zeiss. 26 49 22 54
2 Hansa Rostock Hansa 26 42 24 46
3 FC Vorwärts Berlin Vorwärts 26 41 34 42
4 Lokomotive Leipzig Lokomotive 26 38 35 39
5 BSG Wismut Aue Wismut 26 43 42 38
6 Magdeburg Magdeburg 26 45 47 35
7 Zwickau Zwickau 26 38 41 35
8 Rot-Weiss Erfurt Rot-Weiss 26 45 45 34
9 Hallescher FC Hallescher 26 39 41 32
10 Sachsen Leipzig Sachsen 26 29 35 32
11 BFC Dynamo BFC Dynamo 26 37 32 31
12 Dynamo Dresden Dynamo 26 36 45 30
13 Chemnitzer Chemnitzer 26 39 44 29
14 Brieske-Senftenberg Brieske-Senf 26 22 56 23
TEMPORADA 1961/1962
DDR OBERLIGA
Equipo PJ GF GC Puntos
TEMPORADA 1960/1961
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 73 28 60
2 BFC Dynamo BFC Dynamo 26 44 27 44
3 BSG Wismut Aue Wismut 26 40 32 44
4 Lokomotive Leipzig Lokomotive 26 37 31 44
5 Zwickau Zwickau 26 37 33 44
6 Hansa Rostock Hansa 26 46 36 40
7 Magdeburg Magdeburg 26 47 59 39
8 FC Carl Zeiss Jena Carl Zeiss. 26 55 43 33
9 Sachsen Leipzig Sachsen 26 39 39 32
10 Brieske-Senftenberg Brieske-Senf 26 35 39 32
11 Hallescher FC Hallescher 26 37 42 30
12 SC Einheit Dresden Einheit 26 30 51 28
13 BSG Chemie Zeitz Chemie Zeitz 26 43 61 27
14 BSG Fortschritt Weißenfels Fortschritt 26 27 69 8
TEMPORADA 1959/1960
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 26 44 25 56
2 FC Vorwärts Berlin Vorwärts 26 49 24 48
3 BFC Dynamo BFC Dynamo 26 46 26 47
4 Hansa Rostock Hansa 26 36 26 39
5 FC Carl Zeiss Jena Carl Zeiss. 26 29 27 39
6 BSG Fortschritt Weißenfels Fortschritt 26 36 39 37
7 Zwickau Zwickau 26 30 32 33
8 BSG Chemie Zeitz Chemie Zeitz 26 42 52 33
9 Brieske-Senftenberg Brieske-Senf 26 36 30 32
10 Lokomotive Leipzig Lokomotive 26 28 36 32
11 Sachsen Leipzig Sachsen 26 31 40 28
12 Rot-Weiss Erfurt Rot-Weiss 26 27 45 24
13 SC Einheit Dresden Einheit 26 23 42 23
14 Lok Stendal Lok Stendal 26 19 32 21
TEMPORADA 1958/1959
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 FC Vorwärts Berlin Vorwärts 26 50 24 55
2 FC Carl Zeiss Jena Carl Zeiss. 26 49 36 47
3 Brieske-Senftenberg Brieske-Senf 26 41 25 42
4 SC Einheit Dresden Einheit 26 38 39 39
5 BSG Wismut Aue Wismut 26 43 32 38
6 BFC Dynamo BFC Dynamo 26 37 34 36
7 Hansa Rostock Hansa 26 33 31 36
8 Lokomotive Leipzig Lokomotive 26 38 41 35
9 Zwickau Zwickau 26 38 41 34
10 Sachsen Leipzig Sachsen 26 40 28 33
11 Rot-Weiss Erfurt Rot-Weiss 26 33 44 30
12 BSG Fortschritt Weißenfels Fortschritt 26 30 42 30
13 Hallescher FC Hallescher 14 17 32 20
14 SV Babelsberg 03 Babelsberg 26 32 65 19
15 Hallescher FC II Hallescher 12 13 18 9
TEMPORADA 1956/1957
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 BSG Wismut Aue Wismut 26 53 21 53
2 Brieske-Senftenberg Brieske-Senf 26 34 15 50
3 Lokomotive Leipzig Lokomotive 26 45 22 48
4 Lok Stendal Lok Stendal 26 55 54 40
5 SC Einheit Dresden Einheit 26 50 46 36
6 FC Vorwärts Berlin Vorwärts 26 41 41 35
7 SV Babelsberg 03 Babelsberg 26 41 53 35
8 Sachsen Leipzig Sachsen 26 35 41 33
9 Zwickau Zwickau 26 47 52 32
10 BFC Dynamo BFC Dynamo 26 39 48 30
11 BSG Fortschritt Weißenfels Fortschritt 26 36 38 29
12 Chemnitzer Chemnitzer 26 25 50 28
13 Rot-Weiss Erfurt Rot-Weiss 26 36 38 26
14 Hansa Rostock Hansa 26 31 49 24
TEMPORADA 1955/1956
DDR OBERLIGA
Equipo PJ GF GC Puntos
TEMPORADA 1954/1955
DDR OBERLIGA
Equipo PJ GF GC Puntos
1 Rot-Weiss Erfurt Rot-Weiss 26 58 25 47
2 BSG Wismut Aue Wismut 26 62 38 46
3 Zwickau Zwickau 26 51 49 41
4 Sachsen Leipzig Sachsen 26 56 46 40
5 BFC Dynamo BFC Dynamo 26 50 50 38
6 Brieske-Senftenberg Brieske-Senf 26 37 44 38
7 FC Vorwärts Berlin Vorwärts 26 43 46 36
8 SV Babelsberg 03 Babelsberg 26 36 36 33
9 Lokomotive Leipzig Lokomotive 26 33 38 33
10 Chemnitzer Chemnitzer 26 34 43 33
11 SC Einheit Dresden Einheit 15 41 33 25
12 Hallescher FC Hallescher 25 25 50 25
13 Hansa Rostock II Hansa 17 18 21 23
14 BSG Fortschritt Meerane Fortschritt 26 31 58 18
15 SC Einheit Dresden II Einheit 11 23 22 17
16 Hansa Rostock Hansa 9 11 12 15
17 Hallescher FC II Hallescher 1 2 0 3

  USO DE MEMORIA  
6,054,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.1443
Total Execution Time  0.1459
  CADENA URL  
/historico/Hansa-Rostock/1968
  GET DATOS  
$_GET['/historico/Hansa-Rostock/1968']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0039  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 = 'Hansa-Rostock' 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.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=1292 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=1292 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 45356
0.0030  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 = '1292' AND l.year = 1968 ORDER BY l.year DESC,cat.coefficient DESC
0.0034  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 = '1292' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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 = 45356 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0102  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=1292 AND l.year in (1967,1968,1969) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (45357,11086) 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.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 45357 AND teamId = 1292
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 11086 AND teamId = 1292
0.0024  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 = 45356 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0033  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 = 45356 WHERE rp.league_id = 45356 AND rp.teamId = 1292 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.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 events1968 e ON e.player_id = p.id AND e.league_id = 45356 WHERE rp.league_id = 45356 AND rp.teamId = 1292 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 events1968 e ON e.player_id = p.id AND e.league_id = 45356 WHERE rp.league_id = 45356 AND rp.teamId = 1292 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 = 1292 AND l.year <= 1968 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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,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 = 45356 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 45357 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 45359 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 45360 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 45361 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 45362 AND t.round = 39 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 45381 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 45364 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 `tables1959` 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 = 45368 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1957` 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 = 45370 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 `tables1956` 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 = 45371 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 `tables1955` 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 = 45382 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 45356 ORDER BY nameShow LIMIT 100