4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FSV Duisburg
TEMPORADA 2023/2024
LANDESLIGA GRUPO 21
Equipo PJ GF GC Puntos
1 Arminia Klosterhardt Arminia 0 0 0 0
2 Biemenhorst Biemenhorst 0 0 0 0
3 Budberg Budberg 0 0 0 0
4 BW Dingden BW Dingden 0 0 0 0
5 BW Mintard BW Mintard 0 0 0 0
6 ESC Rellinghausen 06 Rellinghause 0 0 0 0
7 FC Lintfort FC Lintfort 0 0 0 0
8 FSV Duisburg Duisburg 0 0 0 0
9 Honnepel-Niedermörmter Honnepel-Nie 0 0 0 0
10 Kray Kray 0 0 0 0
11 Scherpenberg Scherpenberg 0 0 0 0
12 SF Niederwenigern Niederwenige 0 0 0 0
13 SGE Bedburg-Hau Bedburg-Hau 0 0 0 0
14 SGS Essen SGS Essen 0 0 0 0
15 Speldorf Speldorf 0 0 0 0
16 Sportfreunde 97/30 Lowick Sportfreunde 0 0 0 0
17 SpVgg Steele SpVgg Steele 0 0 0 0
18 SpVgg Sterkrade-Nord SpVgg 0 0 0 0
19 VfB Frohnhausen Frohnhausen 0 0 0 0
20 Wesel-Lackhausen Wesel-Lackha 0 0 0 0
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 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
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
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Homberg Homberg 34 100 34 83
2 SF Baumberg SF Baumberg 34 83 57 69
3 FC Bocholt FC Bocholt 34 61 45 57
4 1.FC Monheim 1.FC Monheim 34 66 57 55
5 Velbert Velbert 34 73 44 54
6 Germania Ratingen Germania 34 67 51 54
7 Meerbusch Meerbusch 34 70 60 51
8 Turu 1880 Dusseldorf Turu 1880 D. 34 51 56 49
9 Schonnebeck Schonnebeck 34 58 65 48
10 Hilden Hilden 34 73 68 47
11 SC Velbert SC Velbert 34 47 58 47
12 Kleve Kleve 34 56 49 45
13 Schwarz-Weiss Essen Schwarz-Weis 34 57 51 43
14 SC Union Nettetal Union 34 41 54 43
15 Düsseldorf-West Düsseldorf- 34 50 59 41
16 Jahn Hiesfeld Jahn 34 45 82 29
17 Speldorf Speldorf 34 48 87 26
18 FSV Duisburg Duisburg 34 41 110 13
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 12
Equipo PJ GF GC Puntos
1 Homberg Homberg 34 90 39 74
2 Kleve Kleve 34 72 32 72
3 FSV Duisburg Duisburg 34 70 31 71
4 SC Union Nettetal Union 34 63 43 63
5 Rhede Rhede 34 69 49 58
6 Wesel-Lackhausen Wesel-Lackha 34 64 80 50
7 Sonsbeck Sonsbeck 34 56 71 49
8 SV Straelen SV Straelen 34 65 63 45
9 Duisburger SV 1900 Duisburger 34 46 46 43
10 1. FC Viersen Viersen 34 43 43 43
11 VfL Repelen VfL Repelen 34 41 45 43
12 SpVg Odenkirchen SpVg 34 50 67 41
13 Speldorf Speldorf 34 75 71 40
14 VSF Amern VSF Amern 34 44 58 40
15 VfB Uerdingen Uerdingen 34 43 60 36
16 SC St. Tönis Tönis 34 54 70 35
17 Hönnepel-Niedermörmter II Hönnepel-Ni 34 42 93 26
18 Viktoria Goch Viktoria 34 46 72 24

  USO DE MEMORIA  
5,927,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1043
Total Execution Time  0.1055
  CADENA URL  
/historico/Fsv-Duisburg
  GET DATOS  
$_GET['/historico/Fsv-Duisburg']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0037  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 = 'Fsv-Duisburg' 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.0019  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=111905 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=111905 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=111905 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111905 AND type_rel = 2
0.0022  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 = '111905' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '111905' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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.0021  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=111905 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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,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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 68317 AND teamId = 111905
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 73064 AND teamId = 111905
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 111905
0.0022  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 = 73064 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '111905' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111905' and rp.type = 4
0.0020  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 = '111905' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 111905 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.0019  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 = 111905 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 111905 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 111905 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0021  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 = 35 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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.0024  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.0022  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.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 `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.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 = 44366 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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.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 `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.0024  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 = 46841 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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