4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del MSV Düsseldorf
TEMPORADA 2023/2024
LANDESLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 1.FC Monheim 1.FC Monheim 35 94 31 82
2 Kapellen-Erft Kapellen-Erf 35 93 31 76
3 Hilden II Hilden II 35 84 53 73
4 VfL Jüchen-Garzweiler Jüchen-Garz 35 66 40 65
5 FC Remscheid Remscheid 35 69 50 60
6 Holzheimer SG Holzheimer 35 70 65 54
7 SC Velbert SC Velbert 35 59 67 54
8 DV Solingen DV Solingen 34 72 60 53
9 Turu 1880 Dusseldorf Turu 1880 D. 35 51 59 49
10 1. FC Viersen Viersen 34 47 44 48
11 Cronenberger Cronenberger 35 59 67 48
12 ASV Süchteln Süchteln 35 68 68 45
13 Victoria Mennrath Victoria 35 66 78 43
14 VSF Amern VSF Amern 34 65 64 41
15 Unterrath Unterrath 34 45 52 40
16 Fortuna Dilkrath Fortuna 35 65 76 39
17 SV Wermelskirchen Wermelskirch 35 72 101 35
18 MSV Düsseldorf Düsseldorf 35 40 85 27
19 ASV Mettmann Mettmann 34 36 74 19
20 Düsseldorf-West Düsseldorf- 34 41 97 16
TEMPORADA 2022/2023
OBERLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 Velbert Velbert 40 93 33 94
2 Hilden Hilden 40 89 45 79
3 TVD Velbert TVD Velbert 40 86 46 78
4 Germania Ratingen Germania 40 79 55 74
5 Schwarz-Weiss Essen Schwarz-Weis 40 84 52 73
6 KFC Uerdingen 05 Uerdingen 40 80 58 72
7 Schonnebeck Schonnebeck 40 84 70 61
8 Meerbusch Meerbusch 40 81 67 59
9 SF Baumberg SF Baumberg 40 78 54 58
10 Hamborn Hamborn 40 77 79 56
11 SC Union Nettetal Union 40 65 72 55
12 Homberg Homberg 40 68 57 54
13 Sonsbeck Sonsbeck 40 71 68 53
14 SC St. Tönis Tönis 40 59 60 53
15 Kleve Kleve 40 67 77 52
16 MSV Düsseldorf Düsseldorf 40 71 68 50
17 1.FC Monheim 1.FC Monheim 40 58 76 42
18 Cronenberger Cronenberger 40 38 87 30
19 Turu 1880 Dusseldorf Turu 1880 D. 40 35 85 29
20 Kray Kray 40 47 110 24
21 FSV Duisburg Duisburg 40 36 127 18
TEMPORADA 2020/2021
LANDESLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Rather SV Rather SV 7 20 4 21
2 1. FC Viersen Viersen 8 21 9 20
3 MSV Düsseldorf Düsseldorf 7 29 13 18
4 ASV Süchteln Süchteln 8 19 10 13
5 Hilden II Hilden II 7 14 12 13
6 SC Teutonia Kleinenbroich Teutonia 7 4 10 8
7 Holzheimer SG Holzheimer 6 14 12 7
8 Kapellen-Erft Kapellen-Erf 7 19 18 7
9 Wulfrath Wulfrath 7 11 14 7
10 Schwarz-Weiß 06 Schwarz-Wei 7 9 15 7
11 Unterrath Unterrath 7 12 21 7
12 SC Reusrath SC Reusrath 5 12 12 6
13 FSV Vohwinkel Vohwinkel 8 14 24 6
14 VfB Solingen Solingen 7 17 28 6
15 Giesenkirchen Giesenkirche 8 12 25 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 11
Equipo PJ GF GC Puntos
1 TVD Velbert TVD Velbert 36 108 51 87
2 Cronenberger Cronenberger 36 117 52 83
3 Mönchengladbach Mönchenglad 36 96 48 81
4 Kapellen-Erft Kapellen-Erf 36 106 56 76
5 VSF Amern VSF Amern 36 89 66 57
6 SC St. Tönis Tönis 36 97 80 55
7 Krefeld-Fischeln Krefeld-Fisc 36 75 69 53
8 Rather SV Rather SV 36 75 78 52
9 ASV Süchteln Süchteln 36 82 81 44
10 MSV Düsseldorf Düsseldorf 36 65 79 44
11 VfB Solingen Solingen 36 66 91 44
12 FC Remscheid Remscheid 36 54 71 43
13 Holzheimer SG Holzheimer 36 71 94 43
14 TSV Meerbusch II Meerbusch 36 63 67 42
15 SpVg Odenkirchen SpVg 36 49 90 42
16 SSVg 09/12 Heiligenhaus SSVg 09/12. 36 65 78 38
17 FSV Vohwinkel Vohwinkel 36 55 90 34
18 VfL Jüchen-Garzweiler Jüchen-Garz 36 55 83 31
19 Düsseldorfer Düsseldorfe 36 44 108 24
TEMPORADA 2017/2018
LANDESLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 Meerbusch Meerbusch 34 114 31 85
2 SC Velbert SC Velbert 34 84 41 76
3 SC Union Nettetal Union 34 84 38 74
4 Mönchengladbach Mönchenglad 34 87 64 55
5 Rather SV Rather SV 34 73 62 53
6 SpVg Odenkirchen SpVg 34 73 59 52
7 Kapellen-Erft Kapellen-Erf 34 49 57 51
8 MSV Düsseldorf Düsseldorf 34 49 57 45
9 VfL Jüchen-Garzweiler Jüchen-Garz 34 53 57 44
10 ASV Süchteln Süchteln 34 63 67 43
11 SSVg 09/12 Heiligenhaus SSVg 09/12. 34 58 75 43
12 FC Remscheid Remscheid 34 61 71 41
13 TSV Meerbusch II Meerbusch 34 53 75 38
14 VSF Amern VSF Amern 34 63 74 37
15 1. FC Viersen Viersen 34 54 89 35
16 Nievenheim Nievenheim 34 71 84 33
17 ASV Mettmann Mettmann 34 51 83 32
18 VfL Benrath VfL Benrath 34 58 114 24

  USO DE MEMORIA  
5,615,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5828
Total Execution Time  0.5840
  CADENA URL  
/historico/Msv-Dusseldorf
  GET DATOS  
$_GET['/historico/Msv-Dusseldorf']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0189  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 = 'Msv-Dusseldorf' 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.0150  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=90350 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=90350 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=90350 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0317  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 = 73080
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=90350 AND type_rel = 2
0.0153  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 = '90350' ORDER BY l.year DESC,cat.coefficient DESC
0.0159  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 = '90350' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '90350' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155  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 = 73080 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0160  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=90350 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0153  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 (73080,71432,68317) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 68317 AND teamId = 90350
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73080 AND teamId = 90350
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 90350
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 = 73080 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '90350' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '90350' and rp.type = 4
0.0147  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 = '90350' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73080 WHERE rp.league_id = 73080 AND rp.teamId = 90350 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.0147  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 = 73080 WHERE rp.league_id = 73080 AND rp.teamId = 90350 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  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 = 73080 WHERE rp.league_id = 73080 AND rp.teamId = 90350 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 90350 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73080 AND t.round = 35 ORDER BY team.conference ASC,t.position 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 `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 = 68317 AND t.round = 42 ORDER BY team.conference ASC,t.position 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 `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 = 58572 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.0159  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.0161  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 = 48742 AND t.round = 38 ORDER BY team.conference 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 `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 = 46652 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 73080 ORDER BY nameShow LIMIT 100