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 16 47 12 42
2 FC Frankfurt Frankfurt 16 49 15 36
3 MSV Neuruppin Neuruppin 16 34 24 29
4 Union Klosterfelde Union 16 32 21 28
5 Germania Schöneiche Germania 16 30 19 28
6 Petershagen Petershagen 16 32 25 26
7 TuS 1896 Sachsenhausen 1896 15 40 20 25
8 Brandenburger Brandenburge 15 23 15 20
9 SV Zehdenick 1920 Zehdenick 16 35 33 19
10 OFC Eintracht Eintracht 16 21 27 19
11 Preussen Eberswalde Preussen 16 26 34 19
12 TSG Einheit Bernau Einheit 16 23 36 19
13 Fortuna Babelsberg Fortuna 16 30 44 17
14 Werderaner Werderaner 16 23 31 16
15 Concordia Buckow / ​Wald Concordia 16 27 45 12
16 SV GW Lübben Lübben 16 29 53 11
17 Victoria Seelow Victoria 16 12 59 7
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,447,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1211
Total Execution Time  0.1223
  CADENA URL  
/historico/Fc-Frankfurt
  GET DATOS  
$_GET['/historico/Fc-Frankfurt']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0124  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.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=65522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=65522 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65522 AND type_rel = 2
0.0046  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.0048  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.0033  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.0033  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.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 (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.0064  SELECT count(id) as num_players from rel_players WHERE league_id = 68171 AND teamId = 65522
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 73448 AND teamId = 65522
0.0035  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65522
0.0040  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 = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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.0021  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65522' and rp.type = 4
0.0020  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.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 = 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.0035  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.0030  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.0025  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.0039  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 = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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.0026  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.0029  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.0029  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.0027  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