4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Husumer SV
TEMPORADA 2023/2024
LANDESLIGA GRUPO 10
Equipo PJ GF GC Puntos
1 Rotenhof Rotenhof 22 74 20 60
2 Rot Schwarz Kiel Schwarz Kiel 23 62 35 45
3 SpVg Eidertal SpVg 22 56 35 44
4 TSV Rantrum TSV Rantrum 21 50 31 37
5 Klausdorf Klausdorf 24 76 40 36
6 Kropp Kropp 22 36 24 36
7 Friedrichsberg-Busdorf Friedrichsbe 22 36 41 33
8 Altenholz Altenholz 22 46 60 33
9 Stjernen Flensborg Stjernen 24 47 59 29
10 SV Frisia 03 Frisia 23 38 46 27
11 Dörpum Dörpum 22 36 49 26
12 Slesvig IF Slesvig IF 22 52 65 25
13 SG Fleckeby SG Fleckeby 22 43 58 23
14 Osterrönfelder TSV Osterrönfel 23 25 45 20
15 Gettorfer Gettorfer 24 33 65 15
16 Husumer SV Husumer SV 20 26 63 14
TEMPORADA 2022/2023
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Kilia Kiel Kilia Kiel 32 125 25 81
2 SV Eichede SV Eichede 32 63 23 75
3 Todesfelde Todesfelde 32 112 34 73
4 Union Neumünster Union 32 111 39 66
5 TSB Flensburg Flensburg 32 75 46 60
6 Heider SV Heider SV 32 78 68 55
7 Eckernförder SV Eckernförde 32 59 58 48
8 VfB Lübeck II Lübeck 32 77 86 46
9 Inter Turkspor Kiel Inter 32 78 76 43
10 Bordesholm Bordesholm 32 55 67 37
11 Oldenburger SV Oldenburger 32 51 68 37
12 Weiche Flensburg 08 II Weiche 32 51 76 30
13 Dornbreite Lübeck Dornbreite 32 32 85 27
14 SV Frisia 03 Frisia 32 33 94 24
15 Pansdorf Pansdorf 32 42 96 23
16 Husumer SV Husumer SV 32 41 95 23
17 GW Siebenbäumen Siebenbäume 32 37 84 21
TEMPORADA 2020/2021
OBERLIGA GRUPO 11
Equipo PJ GF GC Puntos
1 Todesfelde Todesfelde 7 17 5 16
2 Bordesholm Bordesholm 6 14 5 14
3 SV Eichede SV Eichede 5 19 3 12
4 Altenholz Altenholz 6 8 9 10
5 TSB Flensburg Flensburg 4 16 9 9
6 Oldenburger SV Oldenburger 5 14 7 9
7 Union Neumünster Union 5 9 9 8
8 Kronshagen Kronshagen 6 7 9 8
9 Weiche Flensburg 08 II Weiche 4 7 5 7
10 VfB Lübeck II Lübeck 6 11 13 6
11 Pansdorf Pansdorf 5 8 15 5
12 Dornbreite Lübeck Dornbreite 6 8 19 4
13 SV Frisia 03 Frisia 2 5 6 3
14 Eckernförder SV Eckernförde 5 8 12 3
15 SV Preußen Reinfeld Preußen 3 3 8 3
16 Eutin 08 Eutin 08 6 8 18 3
17 Husumer SV Husumer SV 4 6 9 2
18 Inter Turkspor Kiel Inter 5 4 11 1
TEMPORADA 2019/2020
OBERLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 1. FC Phönix Lübeck Phönix 20 63 21 47
2 Todesfelde Todesfelde 19 51 21 47
3 TSB Flensburg Flensburg 19 64 31 39
4 Weiche Flensburg 08 II Weiche 17 49 26 36
5 SV Eichede SV Eichede 20 44 29 36
6 VfB Lübeck II Lübeck 21 55 44 36
7 Oldenburger SV Oldenburger 20 60 51 33
8 Bordesholm Bordesholm 20 42 33 31
9 SV Preußen Reinfeld Preußen 19 37 43 28
10 Eutin 08 Eutin 08 20 28 29 24
11 Union Neumünster Union 18 30 44 23
12 SV Frisia 03 Frisia 21 31 59 21
13 Husumer SV Husumer SV 19 41 55 19
14 Inter Turkspor Kiel Inter 20 29 54 16
15 Kropp Kropp 17 17 52 3
16 Eckernförder SV Eckernförde 18 20 69 1
TEMPORADA 2017/2018
LANDESLIGA GRUPO 19
Equipo PJ GF GC Puntos
1 Klausdorf Klausdorf 2 7 3 6
2 Büdelsdorfer TSV Büdelsdorfe 2 5 1 6
3 Husumer SV Husumer SV 2 5 2 6
4 Kropp Kropp 2 10 3 4
5 Altenholz Altenholz 2 8 1 4
6 Bordesholm Bordesholm 2 7 5 4
7 Schleswig 06 Schleswig 2 4 3 4
8 Osterrönfelder TSV Osterrönfel 2 1 0 4
9 SG Geest 05 SG Geest 05 2 2 7 3
10 TSV Rantrum TSV Rantrum 2 1 1 2
11 BW Löwenstedt Löwenstedt 2 4 6 1
12 Heikendorfer SV Heikendorfer 2 2 4 0
13 Gettorfer Gettorfer 2 1 3 0
14 Eckernförder SV Eckernförde 2 2 5 0
15 Concordia Schönkirchen Concordia 2 2 8 0
16 Kilia Kiel Kilia Kiel 2 0 9 0
TEMPORADA 2013/2014
OBERLIGA GRUPO 3
Equipo PJ GF GC Puntos
1 VfB Lübeck VfB Lübeck 34 116 17 96
2 Preetzer TSV Preetzer 34 69 52 60
3 Union Neumünster Union 34 77 48 59
4 Holstein Kiel II Holstein 34 82 52 58
5 Altenholz Altenholz 34 85 61 58
6 Kropp Kropp 34 78 61 54
7 Todesfelde Todesfelde 34 66 59 52
8 Flensburg 08 Flensburg 34 67 65 52
9 TuRa Meldorf TuRa Meldorf 34 49 56 48
10 Heider SV Heider SV 34 54 57 44
11 Schilksee Schilksee 34 51 52 43
12 NTSV Strand NTSV Strand 34 47 58 43
13 Hartenholm Hartenholm 34 48 65 40
14 Dornbreite Lübeck Dornbreite 34 58 76 35
15 Husumer SV Husumer SV 34 51 76 33
16 Hagen Ahrensburg Hagen 34 38 74 32
17 SV Eichede II Eichede 34 35 76 29
18 Heikendorfer SV Heikendorfer 34 33 99 17
TEMPORADA 2011/2012
OBERLIGA GRUPO 6
Equipo PJ GF GC Puntos
1 VfR Neumunster Neumunster 34 88 29 80
2 Weiche Flensburg Weiche 34 71 28 72
3 Holstein Kiel II Holstein 34 97 34 71
4 SV Eichede SV Eichede 34 85 53 60
5 VfB Lübeck II Lübeck 34 80 63 54
6 Kropp Kropp 34 61 55 54
7 NTSV Strand NTSV Strand 34 71 56 53
8 Flensburg 08 Flensburg 34 60 52 52
9 Sylt Sylt 34 63 71 47
10 Preetzer TSV Preetzer 34 46 54 45
11 Todesfelde Todesfelde 34 79 73 42
12 Henstedt-Ulzburg Henstedt-Ulz 34 60 70 40
13 Heider SV Heider SV 34 53 78 40
14 Heikendorfer SV Heikendorfer 34 48 53 38
15 Eider Büdelsdorf Eider 34 46 69 36
16 Husumer SV Husumer SV 34 51 97 29
17 Schackendorf Schackendorf 34 38 97 29
18 Breitenfelde Breitenfelde 34 43 108 22
TEMPORADA 2008/2009
OBERLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Holstein Kiel II Holstein 34 92 26 77
2 VfR Neumunster Neumunster 34 89 31 75
3 Henstedt-Ulzburg Henstedt-Ulz 34 109 38 69
4 Heider SV Heider SV 34 61 42 56
5 Eider Büdelsdorf Eider 34 64 49 54
6 Comet Kiel Comet Kiel 34 51 50 53
7 Heikendorfer SV Heikendorfer 34 61 55 52
8 VfB Lübeck II Lübeck 34 67 55 51
9 Schleswig 06 Schleswig 34 51 61 51
10 Flensburg 08 Flensburg 34 56 39 50
11 Itzehoe Itzehoe 34 55 59 42
12 Eckernförder SV Eckernförde 34 47 71 40
13 Kropp Kropp 34 43 56 38
14 Altenholz Altenholz 34 50 71 38
15 VFR Horst 1946 Horst 1946 34 49 77 38
16 Husumer SV Husumer SV 34 44 76 26
17 Kilia Kiel Kilia Kiel 34 41 106 24
18 NTSV Strand NTSV Strand 34 37 105 16

  USO DE MEMORIA  
5,666,696 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.5528
Total Execution Time  0.5545
  CADENA URL  
/historico/Husumer-Sv
  GET DATOS  
$_GET['/historico/Husumer-Sv']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0152  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 = 'Husumer-Sv' 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.0145  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=17120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=17120 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17120 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2090 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2090 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (184451,1011237,984949) ORDER BY n.cover_points DESC, update_date DESC
0.0147  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 = '17120' ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '17120' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '17120' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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=17120 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (73090,68312,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 68312 AND teamId = 17120
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73090 AND teamId = 17120
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 17120
0.0146  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 = '17120' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17120' and rp.type = 4
0.0146  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 = '17120' 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 = 73090 WHERE rp.league_id = 73090 AND rp.teamId = 17120 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 = 73090 WHERE rp.league_id = 73090 AND rp.teamId = 17120 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 = 73090 WHERE rp.league_id = 73090 AND rp.teamId = 17120 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 = 17120 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 = 73090 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 68312 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.0149  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 = 58661 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 50542 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 46660 AND t.round = 2 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 `tables2014` 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 = 3539 AND t.round = 34 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 `tables2012` 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 = 19825 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,team.teamId FROM `tables2009` 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 = 19861 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC