4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Schonnebeck
TEMPORADA 2023/2024
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 SF Baumberg SF Baumberg 28 66 27 63
2 KFC Uerdingen 05 Uerdingen 27 49 34 49
3 Schonnebeck Schonnebeck 27 55 37 48
4 Germania Ratingen Germania 27 50 34 48
5 Hilden Hilden 28 47 40 48
6 Schwarz-Weiss Essen Schwarz-Weis 27 44 37 39
7 FC Büderich Büderich 27 48 43 39
8 Homberg Homberg 27 37 37 37
9 SC Union Nettetal Union 29 45 55 37
10 TVD Velbert TVD Velbert 28 47 47 35
11 Sonsbeck Sonsbeck 28 36 44 35
12 SV Straelen SV Straelen 18 35 18 34
13 SC St. Tönis Tönis 27 41 48 30
14 Mülheimer FC 97 Mülheimer 28 41 52 30
15 Union Frintrop Union 28 32 53 28
16 Kleve Kleve 27 28 52 27
17 Hamborn Hamborn 27 27 54 26
18 Meerbusch Meerbusch 28 40 56 24
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 23
Equipo PJ GF GC Puntos
1 FC Bocholt FC Bocholt 10 24 8 24
2 Hilden Hilden 10 26 11 21
3 SF Baumberg SF Baumberg 10 26 21 15
4 Velbert Velbert 10 20 19 15
5 Germania Ratingen Germania 10 19 14 13
6 TVD Velbert TVD Velbert 10 16 18 12
7 Schonnebeck Schonnebeck 10 16 24 12
8 Schwarz-Weiss Essen Schwarz-Weis 10 21 23 11
9 1.FC Monheim 1.FC Monheim 10 12 16 11
10 Kleve Kleve 10 17 23 10
11 Meerbusch Meerbusch 10 10 30 5
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
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
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 SV Straelen SV Straelen 34 81 36 70
2 Schonnebeck Schonnebeck 34 78 41 69
3 Homberg Homberg 34 75 45 63
4 SF Baumberg SF Baumberg 34 78 51 58
5 Jahn Hiesfeld Jahn 34 66 48 56
6 Schwarz-Weiss Essen Schwarz-Weis 34 70 55 56
7 Germania Ratingen Germania 34 74 45 55
8 Velbert Velbert 34 67 46 55
9 Düsseldorf-West Düsseldorf- 34 68 67 52
10 FC Bocholt FC Bocholt 34 65 50 50
11 1.FC Monheim 1.FC Monheim 34 64 58 50
12 Speldorf Speldorf 34 64 67 47
13 Hilden Hilden 34 62 68 43
14 Turu 1880 Dusseldorf Turu 1880 D. 34 40 65 40
15 Krefeld-Fischeln Krefeld-Fisc 34 61 92 30
16 Cronenberger Cronenberger 34 42 84 30
17 TSG Vohwinkel 80 Vohwinkel 34 54 101 25
18 Düsseldorfer Düsseldorfe 34 36 126 8
TEMPORADA 2016/2017
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 KFC Uerdingen 05 Uerdingen 33 81 20 83
2 Schonnebeck Schonnebeck 34 71 40 72
3 FC Bocholt FC Bocholt 34 61 35 66
4 Krefeld-Fischeln Krefeld-Fisc 34 79 74 56
5 Velbert Velbert 34 65 44 54
6 Jahn Hiesfeld Jahn 34 65 60 54
7 Homberg Homberg 34 60 51 53
8 Germania Ratingen Germania 34 61 54 51
9 Düsseldorf-West Düsseldorf- 34 56 61 49
10 Hilden Hilden 33 67 58 48
11 Turu 1880 Dusseldorf Turu 1880 D. 34 39 49 44
12 SF Baumberg SF Baumberg 34 76 68 41
13 Schwarz-Weiss Essen Schwarz-Weis 34 51 65 36
14 Cronenberger Cronenberger 34 40 87 35
15 Meerbusch Meerbusch 34 56 74 31
16 Kapellen-Erft Kapellen-Erf 34 48 77 30
17 Honnepel-Niedermörmter Honnepel-Nie 34 46 73 27
18 Kray Kray 34 59 91 25
TEMPORADA 2015/2016
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Wuppertaler SV Wuppertaler 34 69 25 74
2 KFC Uerdingen 05 Uerdingen 34 59 38 62
3 Jahn Hiesfeld Jahn 34 70 48 58
4 Turu 1880 Dusseldorf Turu 1880 D. 34 46 40 52
5 Schonnebeck Schonnebeck 34 52 48 50
6 Krefeld-Fischeln Krefeld-Fisc 34 66 64 49
7 Kapellen-Erft Kapellen-Erf 34 55 51 48
8 Meerbusch Meerbusch 34 54 58 48
9 Düsseldorf-West Düsseldorf- 34 43 50 47
10 Honnepel-Niedermörmter Honnepel-Nie 34 56 48 46
11 Germania Ratingen Germania 34 47 46 45
12 FC Bocholt FC Bocholt 34 52 52 45
13 MSV Duisburg II Duisburg 34 50 42 43
14 Hilden Hilden 34 48 58 41
15 Schwarz-Weiss Essen Schwarz-Weis 34 51 62 40
16 Mönchengladbach Mönchenglad 34 41 67 33
17 Rot-Weiss Oberhausen II Rot-Weiss 34 43 72 31
18 Kalkum-Wittlaer Kalkum-Wittl 34 36 69 24

  USO DE MEMORIA  
6,105,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1121
Total Execution Time  0.1136
  CADENA URL  
/historico/Schonnebeck
  GET DATOS  
$_GET['/historico/Schonnebeck']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (29)  
0.0032  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 = 'Schonnebeck' 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=65729 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=65729 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=65729 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65729 AND type_rel = 2
0.0039  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 = '65729' ORDER BY l.year DESC,cat.coefficient DESC
0.0033  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 = '65729' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '65729' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  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=65729 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 (72634,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.0043  SELECT count(id) as num_players from rel_players WHERE league_id = 72634 AND teamId = 65729
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 65729
0.0021  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 = '65729' 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 = '65729' and rp.type = 4
0.0021  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 = '65729' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0039  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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 65729 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.0032  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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 65729 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 72634 WHERE rp.league_id = 72634 AND rp.teamId = 65729 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 65729 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72634 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.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.0025  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.0028  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 = 67169 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.0026  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 `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 = 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.0026  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 = 39087 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 33888 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15549 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC