4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SC St. Tönis
TEMPORADA 2023/2024
OBERLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 SF Baumberg SF Baumberg 29 68 30 63
2 Schonnebeck Schonnebeck 29 64 39 54
3 KFC Uerdingen 05 Uerdingen 28 50 34 52
4 Germania Ratingen Germania 29 53 41 51
5 Hilden Hilden 29 47 42 48
6 Homberg Homberg 29 43 39 43
7 Sonsbeck Sonsbeck 31 46 47 41
8 Schwarz-Weiss Essen Schwarz-Weis 28 44 39 39
9 FC Büderich Büderich 28 49 46 39
10 SC Union Nettetal Union 30 45 55 38
11 TVD Velbert TVD Velbert 29 48 54 35
12 SV Straelen SV Straelen 18 35 18 34
13 SC St. Tönis Tönis 29 47 54 33
14 Kleve Kleve 30 30 54 31
15 Meerbusch Meerbusch 30 49 61 30
16 Mülheimer FC 97 Mülheimer 29 43 56 30
17 Union Frintrop Union 29 32 54 28
18 Hamborn Hamborn 28 28 58 26
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 3
Equipo PJ GF GC Puntos
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 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,662,448 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0985
Total Execution Time  0.0997
  CADENA URL  
/historico/Teutonia-05
  GET DATOS  
$_GET['/historico/Teutonia-05']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
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 = 'Teutonia-05' 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=101809 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=101809 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=101809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101809 AND type_rel = 2
0.0027  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 = '101809' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '101809' 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 = '101809' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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=101809 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72634 AND teamId = 101809
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 101809
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 = '101809' 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 = '101809' 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 = '101809' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049  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 = 101809 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.0035  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 = 101809 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 101809 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 101809 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0030  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 = 31 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 `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.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 = 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.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 `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.0019  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 = 51135 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.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 `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.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