4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CFC Hertha 06
TEMPORADA 2023/2024
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 FC Hertha 03 Zehlendorf Hertha 25 88 25 64
2 Lichtenberg Lichtenberg 25 74 17 59
3 Sparta Lichtenberg Sparta 26 69 40 50
4 Mahlsdorf Mahlsdorf 25 51 40 43
5 Tennis Borussia Tennis 25 43 39 38
6 TUS Makkabi TUS Makkabi 25 40 35 37
7 Tasmania Berlin Tasmania 25 43 38 35
8 Neustrelitz Neustrelitz 25 44 44 34
9 Anker Wismar Anker Wismar 25 41 44 33
10 Staaken Staaken 25 42 64 32
11 Optik Rathenow Optik 25 42 49 30
12 RSV Eintracht Eintracht 26 41 63 27
13 Dynamo Schwerin Dynamo 25 37 53 24
14 CFC Hertha 06 Hertha 15 29 26 23
15 Rostocker FC Rostocker 26 34 80 20
16 Union Fürstenwalde Union 26 21 82 8
TEMPORADA 2022/2023
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Hansa Rostock II Hansa 34 94 28 81
2 Rostocker FC Rostocker 34 77 38 69
3 TUS Makkabi TUS Makkabi 34 73 32 67
4 FC Hertha 03 Zehlendorf Hertha 34 71 40 62
5 RSV Eintracht Eintracht 34 56 53 57
6 CFC Hertha 06 Hertha 34 48 44 49
7 Blau-Weiß 1890 Berlin Blau-Weiß 34 59 60 48
8 Dynamo Schwerin Dynamo 34 48 54 48
9 Neustrelitz Neustrelitz 34 55 54 47
10 Union Fürstenwalde Union 34 48 56 47
11 Mahlsdorf Mahlsdorf 34 48 52 46
12 Tasmania Berlin Tasmania 36 46 69 39
13 Optik Rathenow Optik 34 42 60 34
14 Mecklenburg Schwerin Mecklenburg 36 55 90 34
15 Staaken Staaken 34 46 61 33
16 MSV Neuruppin Neuruppin 34 43 57 32
17 FC Frankfurt Frankfurt 34 43 72 31
18 Pampow Pampow 34 51 83 30
TEMPORADA 2021/2022
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Greifswalder Greifswalder 31 61 35 68
2 FC Hertha 03 Zehlendorf Hertha 32 67 31 66
3 CFC Hertha 06 Hertha 32 58 36 63
4 Blau-Weiß 1890 Berlin Blau-Weiß 31 64 41 60
5 Staaken Staaken 32 67 36 59
6 Neustrelitz Neustrelitz 30 44 25 58
7 Rostocker FC Rostocker 31 68 32 56
8 Mahlsdorf Mahlsdorf 31 55 38 51
9 Torgelower SV Greif Torgelower 31 60 37 48
10 Hansa Rostock II Hansa 31 73 49 47
11 RSV Eintracht Eintracht 31 49 43 45
12 Pampow Pampow 31 47 55 38
13 Mecklenburg Schwerin Mecklenburg 32 39 63 34
14 Ludwigsfelder FC Ludwigsfelde 31 31 46 33
15 MSV Neuruppin Neuruppin 31 35 63 28
16 Stern Stern 31 32 64 23
17 Brandenburger Brandenburge 32 26 55 22
18 Victoria Seelow Victoria 30 31 84 16
19 Lok Stendal Lok Stendal 31 27 101 13
TEMPORADA 2020/2021
OBERLIGA GRUPO 1
Equipo PJ GF GC Puntos
1 Tasmania Berlin Tasmania 9 21 7 21
2 Greifswalder Greifswalder 9 21 7 17
3 Staaken Staaken 8 17 6 16
4 RSV Eintracht Eintracht 9 18 16 16
5 Torgelower SV Greif Torgelower 8 17 8 15
6 FC Hertha 03 Zehlendorf Hertha 9 25 17 15
7 Neustrelitz Neustrelitz 9 19 15 13
8 Blau-Weiß 1890 Berlin Blau-Weiß 9 11 7 13
9 Pampow Pampow 9 18 17 13
10 Hansa Rostock II Hansa 8 14 13 13
11 Stern Stern 8 14 13 13
12 Rostocker FC Rostocker 10 16 26 12
13 Strausberg Strausberg 9 15 18 10
14 CFC Hertha 06 Hertha 9 12 25 9
15 Victoria Seelow Victoria 9 8 24 6
16 Lok Stendal Lok Stendal 9 9 18 5
17 BSC Süd 05 BSC Süd 05 9 7 25 5
TEMPORADA 2019/2020
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Tennis Borussia Tennis 19 61 17 47
2 Greifswalder Greifswalder 18 37 15 42
3 Hansa Rostock II Hansa 19 56 22 39
4 FC Hertha 03 Zehlendorf Hertha 19 40 20 39
5 Neustrelitz Neustrelitz 19 29 27 32
6 Pampow Pampow 19 41 28 30
7 Staaken Staaken 19 42 36 25
8 Blau-Weiß 1890 Berlin Blau-Weiß 18 25 25 24
9 Torgelower SV Greif Torgelower 19 26 30 24
10 Tasmania Berlin Tasmania 19 30 37 21
11 Ludwigsfelder FC Ludwigsfelde 19 26 39 18
12 Lok Stendal Lok Stendal 18 20 33 18
13 Victoria Seelow Victoria 18 25 44 18
14 CFC Hertha 06 Hertha 19 18 43 16
15 BSC Süd 05 BSC Süd 05 18 12 35 11
16 Strausberg Strausberg 18 17 54 11
TEMPORADA 2018/2019
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Lichtenberg Lichtenberg 30 69 12 74
2 Tennis Borussia Tennis 30 76 27 67
3 Greifswalder Greifswalder 30 67 44 59
4 FC Hertha 03 Zehlendorf Hertha 30 64 33 55
5 Hansa Rostock II Hansa 30 69 39 55
6 Altlüdersdorf Altlüdersdo 30 53 61 44
7 Blau-Weiß 1890 Berlin Blau-Weiß 30 58 42 41
8 Staaken Staaken 30 56 52 38
9 Torgelower SV Greif Torgelower 30 44 48 38
10 Neustrelitz Neustrelitz 30 37 46 37
11 CFC Hertha 06 Hertha 30 45 67 37
12 Lok Stendal Lok Stendal 30 42 72 35
13 Strausberg Strausberg 30 42 64 33
14 BSC Süd 05 BSC Süd 05 30 52 64 32
15 Anker Wismar Anker Wismar 30 25 47 32
16 Malchower SV Malchower 30 28 109 4
TEMPORADA 2017/2018
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Optik Rathenow Optik 32 77 22 78
2 Tennis Borussia Tennis 32 64 24 72
3 Lichtenberg Lichtenberg 32 69 34 67
4 FC Hertha 03 Zehlendorf Hertha 33 63 45 63
5 Staaken Staaken 32 74 46 56
6 Brandenburger Brandenburge 32 58 45 54
7 Strausberg Strausberg 32 66 51 51
8 Anker Wismar Anker Wismar 32 54 44 51
9 Altlüdersdorf Altlüdersdo 32 60 56 47
10 Hansa Rostock II Hansa 33 66 73 43
11 Torgelower SV Greif Torgelower 32 42 54 35
12 Malchower SV Malchower 32 55 78 33
13 CFC Hertha 06 Hertha 32 44 64 32
14 Mecklenburg Schwerin Mecklenburg 32 36 61 25
15 Victoria Seelow Victoria 32 49 78 25
16 FC Frankfurt Frankfurt 32 40 79 25
17 Grün-Weiß Brieselang Grün-Weiß 32 39 102 19
TEMPORADA 2016/2017
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Altglienicke Altglienicke 30 69 28 71
2 Optik Rathenow Optik 30 94 33 70
3 Lichtenberg Lichtenberg 30 88 33 60
4 Anker Wismar Anker Wismar 30 62 41 53
5 FC Hertha 03 Zehlendorf Hertha 30 65 53 51
6 Tennis Borussia Tennis 30 54 39 48
7 Malchower SV Malchower 30 50 65 42
8 Victoria Seelow Victoria 30 51 44 40
9 Hansa Rostock II Hansa 30 63 72 38
10 Altlüdersdorf Altlüdersdo 30 53 56 37
11 Mecklenburg Schwerin Mecklenburg 30 55 68 36
12 CFC Hertha 06 Hertha 30 48 76 33
13 Strausberg Strausberg 30 36 63 25
14 Grün-Weiß Brieselang Grün-Weiß 30 38 75 25
15 Germania Schöneiche Germania 30 38 68 23
16 FC Frankfurt Frankfurt 30 30 80 14
TEMPORADA 2015/2016
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 Union Fürstenwalde Union 30 84 35 69
2 Hansa Rostock II Hansa 30 78 30 65
3 FC Hertha 03 Zehlendorf Hertha 30 75 37 59
4 Tennis Borussia Tennis 30 55 35 55
5 Lichtenberg Lichtenberg 30 54 34 53
6 Malchower SV Malchower 30 65 46 48
7 Anker Wismar Anker Wismar 30 59 36 45
8 Germania Schöneiche Germania 30 32 30 40
9 Victoria Seelow Victoria 30 38 46 39
10 Altlüdersdorf Altlüdersdo 30 49 56 38
11 CFC Hertha 06 Hertha 30 45 49 37
12 Neubrandenburg 04 Neubrandenbu 30 55 61 36
13 BSC Süd 05 BSC Süd 05 30 38 61 33
14 Strausberg Strausberg 30 29 48 30
15 FC Frankfurt Frankfurt 30 31 77 21
16 BSV Hürtürkel Hürtürkel 30 24 130 10

  USO DE MEMORIA  
6,015,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0930
Total Execution Time  0.0942
  CADENA URL  
/historico/Cfc-Hertha
  GET DATOS  
$_GET['/historico/Cfc-Hertha']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (25)  
0.0040  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 = 72541
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65511 AND type_rel = 2
0.0022  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 = '65511' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72541 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=65511 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (72541,71432) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72541 AND teamId = 65511
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65511
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 72541 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '65511' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65511' and rp.type = 4
0.0021  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 = '65511' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 65511 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.0032  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 = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 65511 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 events2024 e ON e.player_id = p.id AND e.league_id = 72541 WHERE rp.league_id = 72541 AND rp.teamId = 65511 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 65511 AND l.year <= 2024 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 `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 = 72541 AND t.round = 27 ORDER BY team.conference ASC,t.position 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 `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 = 68171 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 63242 AND t.round = 33 ORDER BY team.conference ASC,t.position 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 `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 = 57316 AND t.round = 10 ORDER BY team.conference ASC,t.position 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 `tables2020` 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 = 50468 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.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 `tables2019` 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 = 44325 AND t.round = 30 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 `tables2018` 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 = 39082 AND t.round = 34 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 `tables2017` 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 = 33812 AND t.round = 30 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 `tables2016` 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 = 15540 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC