4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Eddersheim
TEMPORADA 2023/2024
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 FC Giessen FC Giessen 30 60 22 64
2 Türkgücü Friedberg Türkgücü 30 79 39 62
3 KSV Baunatal Baunatal 30 64 38 60
4 Bayern Alzenau Bayern 30 66 34 59
5 Eddersheim Eddersheim 30 52 38 52
6 Hanauer SC 1960 Hanauer 1960 29 56 47 50
7 Hünfelder SV Hünfelder 29 62 53 48
8 Fernwald Fernwald 30 53 47 43
9 Adler Weidenhausen Adler 30 51 47 43
10 Rot-Weiß Walldorf Rot-Weiß 30 57 59 39
11 Waldgirmes Waldgirmes 30 43 70 36
12 Eintracht Stadtallendorf Eintracht 30 49 51 34
13 FC Hanau 93 FC Hanau 93 30 51 65 33
14 Marburg Marburg 30 42 59 33
15 FC Erlensee FC Erlensee 30 40 63 26
16 SV Steinbach 1920 Steinbach 30 37 61 26
17 Viktoria Griesheim Viktoria 30 33 68 23
18 Dietkirchen Dietkirchen 30 39 73 21
TEMPORADA 2022/2023
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Eintracht Frankfurt II Eintracht 38 113 35 89
2 FC Giessen FC Giessen 38 80 41 82
3 Türkgücü Friedberg Türkgücü 38 89 64 70
4 Fernwald Fernwald 38 86 58 69
5 Eintracht Stadtallendorf Eintracht 38 80 51 65
6 KSV Baunatal Baunatal 38 67 51 62
7 Rot-Weiß Walldorf Rot-Weiß 38 87 68 60
8 FC Hanau 93 FC Hanau 93 38 71 64 58
9 SV Steinbach 1920 Steinbach 38 64 60 52
10 FC Erlensee FC Erlensee 38 64 60 49
11 Eddersheim Eddersheim 38 53 53 47
12 Bayern Alzenau Bayern 38 51 60 47
13 Waldgirmes Waldgirmes 38 67 73 46
14 Adler Weidenhausen Adler 38 55 83 45
15 Viktoria Griesheim Viktoria 38 53 89 44
16 Dietkirchen Dietkirchen 38 59 80 41
17 Unter-Flockenbach Unter-Flocke 38 65 110 40
18 Neuhof Neuhof 38 44 70 37
19 Rot-Weiß Hadamar Rot-Weiß 38 57 96 37
20 TSV Steinbach Haiger II Steinbach 38 54 93 25
TEMPORADA 2021/2022
OBERLIGA GRUPO 18
Equipo PJ GF GC Puntos
1 Barockstadt Barockstadt 10 33 9 36
2 Eintracht Stadtallendorf Eintracht 10 24 13 34
3 Hessen Dreieich Hessen 10 19 20 31
4 Eddersheim Eddersheim 10 17 13 27
5 FC Erlensee FC Erlensee 10 22 21 27
6 Rot-Weiß Hadamar Rot-Weiß 10 16 19 24
7 Fernwald Fernwald 10 25 22 22
8 Waldgirmes Waldgirmes 10 17 27 22
9 Neuhof Neuhof 10 10 11 19
10 Dietkirchen Dietkirchen 10 7 35 9
TEMPORADA 2020/2021
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Barockstadt Barockstadt 12 31 6 33
2 Hessen Dreieich Hessen 12 37 11 31
3 Rot-Weiß Walldorf Rot-Weiß 12 31 17 23
4 FC Hanau 93 FC Hanau 93 11 28 16 23
5 Türkgücü München Türkgücü 11 24 9 22
6 Rot-Weiß Hadamar Rot-Weiß 12 15 15 19
7 Waldgirmes Waldgirmes 12 24 21 18
8 Buchonia Flieden Buchonia 12 20 17 18
9 SV Zeilsheim Zeilsheim 12 23 22 15
10 Fernwald Fernwald 11 16 18 15
11 SV Steinbach 1920 Steinbach 12 15 17 15
12 Bad Vilbel Bad Vilbel 12 12 14 13
13 KSV Baunatal Baunatal 11 14 19 13
14 Neuhof Neuhof 12 14 25 13
15 Dietkirchen Dietkirchen 12 16 34 13
16 VfB Ginsheim Ginsheim 12 17 25 11
17 Viktoria Griesheim Viktoria 12 12 16 10
18 Hünfelder SV Hünfelder 12 8 23 9
19 Eddersheim Eddersheim 11 19 28 8
20 FC Erlensee FC Erlensee 11 7 30 7
TEMPORADA 2019/2020
OBERLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Eintracht Stadtallendorf Eintracht 22 54 27 48
2 Hessen Kassel Hessen 22 71 26 47
3 Eddersheim Eddersheim 21 43 22 43
4 Barockstadt Barockstadt 22 55 23 42
5 VfB Ginsheim Ginsheim 21 56 41 37
6 Rot-Weiß Hadamar Rot-Weiß 22 53 38 37
7 Hessen Dreieich Hessen 23 44 38 36
8 Rot-Weiß Walldorf Rot-Weiß 23 42 42 33
9 Waldgirmes Waldgirmes 23 40 44 32
10 Viktoria Griesheim Viktoria 22 35 53 32
11 KSV Baunatal Baunatal 23 32 34 30
12 Türkgücü Friedberg Türkgücü 21 34 37 30
13 FC Hanau 93 FC Hanau 93 23 30 48 26
14 Dietkirchen Dietkirchen 22 29 44 23
15 Bad Vilbel Bad Vilbel 20 29 41 20
16 SV Steinbach 1920 Steinbach 20 21 51 16
17 Neuhof Neuhof 21 24 57 13
18 Fernwald Fernwald 23 35 61 11
TEMPORADA 2018/2019
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 FC Giessen FC Giessen 35 124 26 88
2 Hessen Kassel Hessen 35 78 33 79
3 Bayern Alzenau Bayern 36 97 45 78
4 Rot-Weiß Hadamar Rot-Weiß 35 86 62 60
5 Barockstadt Barockstadt 35 75 54 58
6 KSV Baunatal Baunatal 36 59 61 57
7 VfB Ginsheim Ginsheim 36 81 82 56
8 Waldgirmes Waldgirmes 36 61 57 54
9 Eddersheim Eddersheim 35 60 67 49
10 Bad Vilbel Bad Vilbel 35 48 52 43
11 Lohfelden Lohfelden 35 52 61 41
12 Viktoria Griesheim Viktoria 35 49 79 39
13 Türkgücü Friedberg Türkgücü 36 62 86 37
14 Buchonia Flieden Buchonia 34 51 65 35
15 Hünfelder SV Hünfelder 35 35 76 33
16 Ederbergland Ederbergland 35 42 105 24
17 Neu-Isenburg Neu-Isenburg 34 43 92 21
TEMPORADA 2012/2013
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 KSV Baunatal Baunatal 34 69 43 65
2 Jügesheim Jügesheim 34 49 22 64
3 Buchonia Flieden Buchonia 34 69 54 60
4 Rot-Weiß Hadamar Rot-Weiß 34 69 45 58
5 Wehen Wiesbaden II Wehen 34 64 51 58
6 Lohfelden Lohfelden 34 58 47 56
7 Fernwald Fernwald 34 79 42 53
8 Hünfelder SV Hünfelder 34 63 51 51
9 Eintracht Stadtallendorf Eintracht 34 53 50 50
10 Viktoria Griesheim Viktoria 34 58 57 50
11 Vellmar Vellmar 34 70 60 49
12 Rot-Weiß Darmstadt Rot-Weiß 34 63 63 49
13 Kickers Offenbach FC II Kickers 34 51 49 45
14 Viktoria Urberach Viktoria 34 55 73 39
15 Waldgirmes Waldgirmes 34 56 64 37
16 FSV Braunfels Braunfels 34 32 71 33
17 Eddersheim Eddersheim 34 46 91 25
18 FCA Darmstadt Darmstadt 34 26 97 23

  USO DE MEMORIA  
5,735,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5751
Total Execution Time  0.5763
  CADENA URL  
/historico/Eddersheim
  GET DATOS  
$_GET['/historico/Eddersheim']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0155  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 = 'Eddersheim' 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=83222 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=83222 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=83222 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 72701
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83222 AND type_rel = 2
0.0149  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 = '83222' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '83222' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '83222' 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 = 72701 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=83222 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (72701,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72701 AND teamId = 83222
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83222
0.0149  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 = 72701 AND t.round = 30 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 = '83222' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '83222' 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 = '83222' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 83222 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.0158  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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 83222 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 72701 WHERE rp.league_id = 72701 AND rp.teamId = 83222 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 83222 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0155  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 = 72701 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 68314 AND t.round = 38 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 `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 = 63907 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 66921 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.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 `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 = 58332 AND t.round = 12 ORDER BY team.conference ASC,t.position 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 `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 = 50466 AND t.round = 23 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 `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 = 44342 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2013` 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 = 19809 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC