4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Neu-Isenburg
TEMPORADA 2023/2024
LANDESLIGA GRUPO 19
Equipo PJ GF GC Puntos
1 Unter-Flockenbach Unter-Flocke 26 90 39 64
2 Neu-Isenburg Neu-Isenburg 26 65 45 55
3 Rot-Weiß Darmstadt Rot-Weiß 26 75 41 52
4 SF Seligenstadt Seligenstadt 27 49 37 48
5 Eintr. Wald-Michelbach Eintr. 27 56 40 46
6 SF Bad Homburg Homburg 26 57 34 45
7 SC Dortelweil Dortelweil 26 51 34 42
8 Rot-Weiß Walldorf II Rot-Weiß 26 51 53 40
9 Bornheim GW Bornheim GW 27 53 70 37
10 Germania Ober-Roden Germania 26 47 53 33
11 TS Ober-Roden Ober-Roden 27 48 59 30
12 Neu-Isenburg Neu-Isenburg 26 52 62 29
13 FCA Darmstadt Darmstadt 27 48 58 28
14 Rot-Weiß Frankfurt Rot-Weiß 27 50 69 27
15 JSK Rodgau JSK Rodgau 26 44 59 26
16 Fehlheim Fehlheim 25 48 59 24
17 FFV Sportfreunde 1904 Sportfreunde 27 19 91 6
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 2017/2018
OBERLIGA GRUPO 2
Equipo PJ GF GC Puntos
1 Hessen Dreieich Hessen 32 88 29 72
2 Bayern Alzenau Bayern 32 89 39 66
3 Lehnerz Lehnerz 32 82 41 66
4 FC Giessen FC Giessen 32 96 37 63
5 Waldgirmes Waldgirmes 32 58 42 57
6 Rot-Weiß Hadamar Rot-Weiß 32 79 50 52
7 Borussia Fulda Borussia 32 63 38 52
8 VfB Ginsheim Ginsheim 32 53 51 46
9 KSV Baunatal Baunatal 32 59 52 44
10 Lohfelden Lohfelden 32 52 55 44
11 Neu-Isenburg Neu-Isenburg 32 41 56 39
12 Buchonia Flieden Buchonia 32 48 71 37
13 Ederbergland Ederbergland 32 37 73 34
14 Viktoria Griesheim Viktoria 32 45 89 27
15 Rot-Weiß Frankfurt Rot-Weiß 32 46 85 26
16 Vellmar Vellmar 32 41 95 23
17 SV Steinbach 1920 Steinbach 32 39 113 15
TEMPORADA 1963/1964
REGIONALLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 Hessen Kassel Hessen 38 116 61 80
2 Bayern München Bayern 38 115 61 74
3 Kickers Offenbach FC Kickers 38 96 66 71
4 TSV Schwaben Augsburg Schwaben 38 77 56 68
5 Reutlingen Reutlingen 38 76 61 66
6 VfR Mannheim Mannheim 38 68 50 63
7 Ulm Ulm 38 73 74 62
8 Schweinfurt Schweinfurt 38 82 55 60
9 Greuther Fürth Greuther 38 68 61 53
10 Freiburger FC Freiburger 38 58 61 51
11 Waldhof Mannheim Waldhof 38 56 60 51
12 Ingolstadt 04 Ingolstadt 38 61 81 47
13 Bayern Hof Bayern Hof 38 61 64 45
14 Stuttgarter Kickers Stuttgarter 38 54 74 45
15 Pforzheim Pforzheim 38 51 75 45
16 FSV Frankfurt Frankfurt 38 69 85 44
17 Neu-Isenburg Neu-Isenburg 38 49 80 38
18 FC Augsburg FC Augsburg 38 48 90 35
19 Borussia Fulda Borussia 38 53 77 34
20 Amicitia Viernheim Amicitia 38 47 86 30

  USO DE MEMORIA  
5,226,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.4029
Total Execution Time  0.4042
  CADENA URL  
/historico/Spvgg-Neu-Isenburg
  GET DATOS  
$_GET['/historico/Spvgg-Neu-Isenburg']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0133  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 = 'Spvgg-Neu-Isenburg' 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.0126  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=85389 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=85389 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=85389 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 73086
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=85389 AND type_rel = 2
0.0131  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 = '85389' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '85389' 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 = 73086 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=85389 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73086,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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 73086 AND teamId = 85389
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 85389
0.0135  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 = 73086 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = 73086 WHERE rp.league_id = 73086 AND rp.teamId = 85389 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.0126  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 = 73086 WHERE rp.league_id = 73086 AND rp.teamId = 85389 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73086 WHERE rp.league_id = 73086 AND rp.teamId = 85389 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 85389 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 73086 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.0131  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.0129  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 = 38844 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 22890 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 73086 ORDER BY nameShow LIMIT 100