4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Frankfurt
TEMPORADA 2023/2024
LANDESLIGA GRUPO 36
Equipo PJ GF GC Puntos
1 GW Ahrensfelde Ahrensfelde 27 81 23 70
2 FC Frankfurt Frankfurt 27 71 31 53
3 MSV Neuruppin Neuruppin 26 68 46 47
4 Union Klosterfelde Union 26 51 32 47
5 TuS 1896 Sachsenhausen 1896 25 68 33 46
6 OFC Eintracht Eintracht 27 44 39 44
7 Petershagen Petershagen 26 44 41 37
8 Germania Schöneiche Germania 26 38 37 35
9 Brandenburger Brandenburge 25 40 35 33
10 TSG Einheit Bernau Einheit 26 32 49 33
11 Werderaner Werderaner 26 48 51 32
12 SV GW Lübben Lübben 26 57 72 30
13 SV Zehdenick 1920 Zehdenick 27 55 64 29
14 Fortuna Babelsberg Fortuna 26 43 70 25
15 Preussen Eberswalde Preussen 27 43 75 25
16 Concordia Buckow / ​Wald Concordia 26 48 75 23
17 Victoria Seelow Victoria 27 27 85 14
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 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
TEMPORADA 1997/1998
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Croatia Berlin Croatia 28 50 16 62
2 Hertha BSC II Hertha 28 62 31 50
3 Greifswalder Greifswalder 28 58 38 49
4 Eintracht Schwerin Eintracht 28 57 39 46
5 FC Frankfurt Frankfurt 28 40 33 46
6 Tasmania Berlin Tasmania 28 48 44 42
7 Preussen Eberswalde Preussen 28 34 39 40
8 Lichterfelder Lichterfelde 28 43 43 38
9 Köpenicker SC Köpenicker 28 36 37 38
10 SC Charlottenburg Charlottenbu 28 39 47 38
11 Neustrelitz Neustrelitz 28 44 62 34
12 Optik Rathenow Optik 28 37 49 31
13 Türkiyemspor Berlin Türkiyemspo 28 28 32 30
14 SG Bornim SG Bornim 28 23 55 23
15 Parchimer FC Parchimer 28 20 54 17

  USO DE MEMORIA  
5,457,968 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.6054
Total Execution Time  0.6068
  CADENA URL  
/historico/Fc-Frankfurt
  GET DATOS  
$_GET['/historico/Fc-Frankfurt']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0160  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 = 'Fc-Frankfurt' AND l.year = 2024 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.0145  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=65522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=65522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=65522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 73448
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65522 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2090 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (184451,1011237,984949) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '65522' ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '65522' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '65522' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 73448 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=65522 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (73448,71432,68171) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 68171 AND teamId = 65522
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73448 AND teamId = 65522
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65522
0.0148  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 = 73448 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '65522' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65522' and rp.type = 4
0.0146  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 = '65522' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2024 e ON e.player_id = p.id AND e.league_id = 73448 WHERE rp.league_id = 73448 AND rp.teamId = 65522 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 73448 WHERE rp.league_id = 73448 AND rp.teamId = 65522 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 events2024 e ON e.player_id = p.id AND e.league_id = 73448 WHERE rp.league_id = 73448 AND rp.teamId = 65522 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 65522 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 = 73448 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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.0150  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.0148  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.0148  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
0.0148  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 `tables1998` 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 = 28344 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 73448 ORDER BY nameShow LIMIT 100