4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del ESC Rellinghausen 06
TEMPORADA 2023/2024
LANDESLIGA GRUPO 21
Equipo PJ GF GC Puntos
1 SF Niederwenigern Niederwenige 30 82 39 66
2 BW Dingden BW Dingden 32 72 30 62
3 Biemenhorst Biemenhorst 32 91 51 61
4 Sportfreunde 97/30 Lowick Sportfreunde 32 72 53 54
5 Budberg Budberg 32 84 58 53
6 Kray Kray 33 60 44 51
7 Speldorf Speldorf 32 65 55 51
8 Scherpenberg Scherpenberg 32 89 71 50
9 ESC Rellinghausen 06 Rellinghause 32 55 43 50
10 Wesel-Lackhausen Wesel-Lackha 31 65 46 47
11 Arminia Klosterhardt Arminia 31 48 51 47
12 BW Mintard BW Mintard 32 64 67 46
13 FC Lintfort FC Lintfort 32 64 58 43
14 SGS Essen SGS Essen 31 49 59 41
15 SGE Bedburg-Hau Bedburg-Hau 32 60 62 39
16 SpVgg Steele SpVgg Steele 32 50 70 34
17 VfB Frohnhausen Frohnhausen 31 50 80 31
18 FSV Duisburg Duisburg 33 57 115 26
19 SpVgg Sterkrade-Nord SpVgg 26 36 74 17
20 Honnepel-Niedermörmter Honnepel-Nie 32 16 103 5
TEMPORADA 2021/2022
LANDESLIGA GRUPO 5
Equipo PJ GF GC Puntos
1 Hamborn Hamborn 16 43 25 31
2 SpVgg Steele SpVgg Steele 16 31 23 27
3 ESC Rellinghausen 06 Rellinghause 16 22 18 27
4 Mülheimer FC 97 Mülheimer 16 29 27 26
5 SV Wermelskirchen Wermelskirch 16 26 29 25
6 FC Remscheid Remscheid 16 22 18 23
7 BW Mintard BW Mintard 16 30 27 23
8 Speldorf Speldorf 16 33 35 23
9 VfB Frohnhausen Frohnhausen 16 36 30 22
10 Arminia Klosterhardt Arminia 16 29 31 21
11 SV Burgaltendorf Burgaltendor 16 20 25 19
12 SV Genc Osman Duisburg Genc Osman. 16 20 26 18
13 Duisburger SV 1900 Duisburger 16 18 27 18
14 FC Blau-Gelb Überruhr Blau-Gelb 16 17 35 6
TEMPORADA 2019/2020
LANDESLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Jahn Hiesfeld Jahn 22 66 26 54
2 FSV Duisburg Duisburg 22 57 29 49
3 Düsseldorf-West Düsseldorf- 22 60 25 48
4 Rather SV Rather SV 22 40 27 44
5 VfB Frohnhausen Frohnhausen 22 57 41 38
6 SV Genc Osman Duisburg Genc Osman. 22 41 36 32
7 MSV Düsseldorf Düsseldorf 22 37 38 31
8 SV Burgaltendorf Burgaltendor 22 52 47 28
9 ESC Rellinghausen 06 Rellinghause 22 38 38 28
10 Schwarz-Weiß 06 Schwarz-Wei 22 45 51 28
11 BW Mintard BW Mintard 22 52 45 27
12 FC Remscheid Remscheid 21 37 43 26
13 Hamborn Hamborn 22 31 49 23
14 SV Wermelskirchen Wermelskirch 22 31 45 22
15 Duisburger SV 1900 Duisburger 22 33 51 22
16 SpVgg Steele SpVgg Steele 21 40 59 17
17 Speldorf Speldorf 22 32 62 17
18 VfB Solingen Solingen 22 29 66 16
TEMPORADA 2018/2019
LANDESLIGA GRUPO 12
Equipo PJ GF GC Puntos
TEMPORADA 2017/2018
LANDESLIGA GRUPO 12
Equipo PJ GF GC Puntos
TEMPORADA 2016/2017
LANDESLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 SV Straelen SV Straelen 34 90 34 77
2 Speldorf Speldorf 34 88 39 71
3 Rhede Rhede 34 74 47 66
4 Sonsbeck Sonsbeck 34 58 42 61
5 Rot-Weiss Oberhausen II Rot-Weiss 34 75 51 60
6 FSV Duisburg Duisburg 34 73 61 51
7 Kleve Kleve 34 53 47 51
8 SpVgg Sterkrade-Nord SpVgg 34 71 61 46
9 ESC Rellinghausen 06 Rellinghause 34 58 63 45
10 Duisburger SV 1900 Duisburger 34 59 62 44
11 SF Niederwenigern Niederwenige 34 54 58 42
12 TuS Viktoria Buchholz Viktoria 34 46 64 42
13 Wesel-Lackhausen Wesel-Lackha 34 45 78 38
14 Arminia Klosterhardt Arminia 34 46 67 36
15 VfL Repelen VfL Repelen 34 36 62 36
16 SV Schwafheim Schwafheim 34 38 79 34
17 TSV Essen-West 81 Essen-West 34 57 84 29
18 SF Königshardt Königshardt 34 34 56 28
TEMPORADA 2015/2016
LANDESLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 SF Baumberg SF Baumberg 34 107 49 76
2 Cronenberger Cronenberger 34 83 48 66
3 SC Velbert SC Velbert 34 77 51 61
4 Arminia Klosterhardt Arminia 34 58 39 61
5 SpVgg Sterkrade-Nord SpVgg 34 73 57 60
6 Nievenheim Nievenheim 34 74 63 52
7 Düsseldorfer Düsseldorfe 34 63 59 49
8 ESC Rellinghausen 06 Rellinghause 34 72 81 45
9 SSVg 09/12 Heiligenhaus SSVg 09/12. 34 60 60 43
10 TSV Essen-West 81 Essen-West 34 74 85 43
11 SF Niederwenigern Niederwenige 34 69 72 42
12 Rather SV Rather SV 34 75 89 42
13 VfL Jüchen-Garzweiler Jüchen-Garz 34 53 72 41
14 VfL Benrath VfL Benrath 34 52 83 40
15 FC Remscheid Remscheid 34 47 54 36
16 Wulfrath Wulfrath 34 54 68 36
17 BW Oberhausen-Lirich Oberhausen-L 34 61 89 34
18 TSV 05 Ronsdorf Ronsdorf 34 53 86 27

  USO DE MEMORIA  
5,408,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.3760
Total Execution Time  0.3772
  CADENA URL  
/historico/Esc-Rellinghausen-06
  GET DATOS  
$_GET['/historico/Esc-Rellinghausen-06']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0255  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 = 73064
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=115603 AND type_rel = 2
0.0133  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 = '115603' 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 = 73064 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=115603 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (73064,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 = 73064 AND teamId = 115603
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 115603
0.0136  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 = 73064 WHERE rp.league_id = 73064 AND rp.teamId = 115603 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.0135  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 = 73064 WHERE rp.league_id = 73064 AND rp.teamId = 115603 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 73064 WHERE rp.league_id = 73064 AND rp.teamId = 115603 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 115603 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142  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 = 73064 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.0141  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 = 66646 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141  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 = 51138 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.0132  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 = 48743 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 46653 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 46823 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 46840 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 73064 ORDER BY nameShow LIMIT 100