4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SF Niederwenigern
TEMPORADA 2023/2024
LANDESLIGA GRUPO 21
Equipo PJ GF GC Puntos
1 SF Niederwenigern Niederwenige 31 83 39 69
2 Biemenhorst Biemenhorst 33 98 53 64
3 BW Dingden BW Dingden 33 73 31 63
4 Sportfreunde 97/30 Lowick Sportfreunde 34 79 57 60
5 Budberg Budberg 34 89 62 56
6 Scherpenberg Scherpenberg 33 92 72 53
7 Kray Kray 34 62 48 51
8 Speldorf Speldorf 33 67 58 51
9 Wesel-Lackhausen Wesel-Lackha 32 67 47 50
10 ESC Rellinghausen 06 Rellinghause 33 55 44 50
11 BW Mintard BW Mintard 33 65 67 49
12 Arminia Klosterhardt Arminia 33 50 56 47
13 FC Lintfort FC Lintfort 33 66 59 46
14 SGS Essen SGS Essen 32 50 60 42
15 SGE Bedburg-Hau Bedburg-Hau 33 61 65 39
16 SpVgg Steele SpVgg Steele 32 50 70 34
17 VfB Frohnhausen Frohnhausen 33 57 87 34
18 FSV Duisburg Duisburg 33 57 115 26
19 SpVgg Sterkrade-Nord SpVgg 26 36 74 17
20 Honnepel-Niedermörmter Honnepel-Nie 34 17 110 5
TEMPORADA 2021/2022
OBERLIGA GRUPO 24
Equipo PJ GF GC Puntos
1 Jahn Hiesfeld Jahn 11 28 23 23
2 SC Union Nettetal Union 11 29 17 21
3 Turu 1880 Dusseldorf Turu 1880 D. 11 22 16 21
4 SC St. Tönis Tönis 11 25 16 19
5 SpVgg Sterkrade-Nord SpVgg 11 25 23 19
6 Cronenberger Cronenberger 11 29 23 18
7 SF Niederwenigern Niederwenige 11 20 27 16
8 FSV Duisburg Duisburg 11 20 17 14
9 Düsseldorf-West Düsseldorf- 11 19 20 14
10 Kray Kray 11 17 19 14
11 SC Velbert SC Velbert 11 17 26 10
12 Mönchengladbach Mönchenglad 11 12 36 1
TEMPORADA 2020/2021
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 FC Bocholt FC Bocholt 10 32 9 28
2 Velbert Velbert 10 23 15 22
3 SF Baumberg SF Baumberg 11 28 17 21
4 Germania Ratingen Germania 9 30 11 19
5 Kleve Kleve 10 20 16 19
6 SpVgg Sterkrade-Nord SpVgg 10 20 17 17
7 Düsseldorf-West Düsseldorf- 7 18 9 16
8 SC St. Tönis Tönis 8 18 9 14
9 Schwarz-Weiss Essen Schwarz-Weis 11 17 14 14
10 TVD Velbert TVD Velbert 9 19 17 14
11 1.FC Monheim 1.FC Monheim 9 17 15 14
12 Schonnebeck Schonnebeck 8 14 11 13
13 SC Velbert SC Velbert 10 18 17 11
14 Meerbusch Meerbusch 9 11 18 11
15 Hilden Hilden 7 17 15 10
16 SC Union Nettetal Union 11 12 20 10
17 Turu 1880 Dusseldorf Turu 1880 D. 9 10 21 10
18 Cronenberger Cronenberger 8 13 15 9
19 SF Niederwenigern Niederwenige 10 16 20 8
20 Kray Kray 8 12 17 7
21 Jahn Hiesfeld Jahn 9 9 22 7
22 FSV Duisburg Duisburg 9 11 25 4
23 Mönchengladbach Mönchenglad 10 8 43 3
TEMPORADA 2019/2020
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 SV Straelen SV Straelen 22 67 22 61
2 1.FC Monheim 1.FC Monheim 22 40 24 42
3 Schonnebeck Schonnebeck 22 36 24 42
4 FC Bocholt FC Bocholt 23 50 33 40
5 Velbert Velbert 22 42 27 40
6 Meerbusch Meerbusch 23 43 36 35
7 SF Baumberg SF Baumberg 23 52 46 35
8 Hilden Hilden 23 43 40 34
9 Schwarz-Weiss Essen Schwarz-Weis 22 32 32 31
10 Turu 1880 Dusseldorf Turu 1880 D. 22 32 32 31
11 Kleve Kleve 23 32 34 31
12 Kray Kray 23 46 40 30
13 TVD Velbert TVD Velbert 23 30 30 30
14 Germania Ratingen Germania 23 37 42 30
15 SC Velbert SC Velbert 22 22 48 18
16 SC Union Nettetal Union 22 21 50 13
17 Cronenberger Cronenberger 23 22 53 13
18 SF Niederwenigern Niederwenige 23 27 61 11
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,472,392 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1299
Total Execution Time  0.1319
  CADENA URL  
/historico/Sf-Niederwenigern
  GET DATOS  
$_GET['/historico/Sf-Niederwenigern']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0028  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 = 'Sf-Niederwenigern' 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=115600 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=115600 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=115600 AND type_rel = 2
0.0023  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 = '115600' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0035  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 = '115600' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0030  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.0038  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=115600 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0025  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,67320) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 73064 AND teamId = 115600
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 115600
0.0028  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 = '115600' 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 = '115600' and rp.type = 4
0.0029  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 = '115600' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 115600 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.0029  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 = 115600 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 115600 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  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 = 115600 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0045  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 = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0064  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 = 63365 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.0033  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 = 67170 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0042  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 = 58331 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 50471 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.0023  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.0020  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.0037  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.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 `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