4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Bordesholm
TEMPORADA 2023/2024
OBERLIGA GRUPO 7
Equipo PJ GF GC Puntos
1 Todesfelde Todesfelde 26 83 18 66
2 SV Eichede SV Eichede 26 64 20 57
3 Union Neumünster Union 26 72 42 51
4 TSB Flensburg Flensburg 25 58 32 47
5 Eckernförder SV Eckernförde 25 52 39 42
6 SV Preußen Reinfeld Preußen 25 47 36 41
7 Heider SV Heider SV 25 54 45 39
8 Oldenburger SV Oldenburger 26 51 59 30
9 VfR Neumunster Neumunster 26 37 48 29
10 VfB Lübeck II Lübeck 26 51 63 27
11 Dornbreite Lübeck Dornbreite 26 30 57 26
12 Hohenwestedt Hohenwestedt 25 29 63 26
13 Nordmark Satrup Nordmark 24 39 54 25
14 Inter Turkspor Kiel Inter 26 52 70 23
15 Bordesholm Bordesholm 27 34 78 22
16 Weiche Flensburg 08 II Weiche 26 36 65 16
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 2021/2022
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Eckernförder SV Eckernförde 14 23 11 28
2 TSB Flensburg Flensburg 14 47 19 27
3 Bordesholm Bordesholm 13 29 16 24
4 Inter Turkspor Kiel Inter 14 30 32 22
5 SV Frisia 03 Frisia 14 23 27 17
6 Altenholz Altenholz 14 18 35 15
7 Weiche Flensburg 08 II Weiche 14 27 29 14
8 Kronshagen Kronshagen 13 10 38 3
9 Todesfelde Todesfelde 16 51 11 43
10 SV Eichede SV Eichede 16 59 16 39
11 Oldenburger SV Oldenburger 16 36 31 22
12 Pansdorf Pansdorf 16 28 31 21
13 SV Preußen Reinfeld Preußen 16 23 32 20
14 Union Neumünster Union 16 20 31 19
15 VfB Lübeck II Lübeck 16 21 35 18
16 Dornbreite Lübeck Dornbreite 16 20 45 14
17 Eutin 08 Eutin 08 16 20 46 12
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 2018/2019
OBERLIGA GRUPO 14
Equipo PJ GF GC Puntos
1 NTSV Strand NTSV Strand 30 74 27 69
2 Heider SV Heider SV 31 75 49 61
3 TSB Flensburg Flensburg 30 83 42 58
4 Todesfelde Todesfelde 31 78 41 58
5 Weiche Flensburg 08 II Weiche 31 59 50 50
6 Bordesholm Bordesholm 31 53 54 46
7 VfB Lübeck II Lübeck 30 60 60 44
8 SV Eichede SV Eichede 30 61 46 43
9 Eutin 08 Eutin 08 32 65 57 42
10 Inter Turkspor Kiel Inter 31 46 68 37
11 Union Neumünster Union 29 49 61 35
12 Kropp Kropp 30 48 68 31
13 SV Frisia 03 Frisia 30 35 62 30
14 Schilksee Schilksee 28 39 61 27
15 VfR Neumunster Neumunster 30 34 63 23
16 TSV Lägerdorf Lägerdorf 30 28 78 16
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 2014/2015
OBERLIGA GRUPO 4
Equipo PJ GF GC Puntos
1 Schilksee Schilksee 34 94 33 74
2 Holstein Kiel II Holstein 34 90 38 72
3 SV Eichede SV Eichede 34 102 48 71
4 Eutin 08 Eutin 08 34 70 45 64
5 Todesfelde Todesfelde 34 88 55 59
6 Kropp Kropp 34 81 54 59
7 Preetzer TSV Preetzer 34 65 60 53
8 Altenholz Altenholz 34 68 71 51
9 Flensburg 08 Flensburg 34 90 76 47
10 Henstedt-Ulzburg Henstedt-Ulz 34 52 75 46
11 Hartenholm Hartenholm 34 62 75 45
12 Union Neumünster Union 34 60 69 41
13 TuRa Meldorf TuRa Meldorf 34 55 66 39
14 Heider SV Heider SV 34 42 49 37
15 NTSV Strand NTSV Strand 34 45 84 36
16 Dornbreite Lübeck Dornbreite 34 48 93 33
17 Bordesholm Bordesholm 34 46 96 22
18 Angeln 02 Angeln 02 34 34 105 15
TEMPORADA 2010/2011
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 VfR Neumunster Neumunster 34 74 20 82
2 SV Eichede SV Eichede 34 71 28 67
3 Sylt Sylt 34 80 36 63
4 VfB Lübeck II Lübeck 34 75 55 59
5 NTSV Strand NTSV Strand 34 73 55 56
6 Weiche Flensburg Weiche 34 67 45 53
7 Holstein Kiel II Holstein 34 62 44 53
8 Kropp Kropp 34 56 51 51
9 Henstedt-Ulzburg Henstedt-Ulz 34 76 52 48
10 Flensburg 08 Flensburg 34 59 64 47
11 Heikendorfer SV Heikendorfer 34 56 70 47
12 Eider Büdelsdorf Eider 34 38 57 42
13 Todesfelde Todesfelde 34 50 65 40
14 Heider SV Heider SV 34 43 62 39
15 Union Neumünster Union 34 60 89 34
16 Bordesholm Bordesholm 34 50 93 27
17 Eckernförder SV Eckernförde 34 29 80 21
18 Schleswig 06 Schleswig 34 46 99 21

  USO DE MEMORIA  
5,960,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5128
Total Execution Time  0.5139
  CADENA URL  
/historico/Bordesholm
  GET DATOS  
$_GET['/historico/Bordesholm']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0171  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 = 'Bordesholm' 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.0128  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=20200 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=20200 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=20200 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 72559
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20200 AND type_rel = 2
0.0131  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 = '20200' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130  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 = '20200' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 72559 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  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=20200 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72559,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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 72559 AND teamId = 20200
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20200
0.0127  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 = '20200' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20200' and rp.type = 4
0.0126  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 = '20200' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 72559 WHERE rp.league_id = 72559 AND rp.teamId = 20200 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.0133  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 = 72559 WHERE rp.league_id = 72559 AND rp.teamId = 20200 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 72559 WHERE rp.league_id = 72559 AND rp.teamId = 20200 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 20200 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 72559 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.0131  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.0127  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 = 67217 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 63478 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.0135  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.0137  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.0139  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 = 44493 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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.0129  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 `tables2015` 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 = 4376 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2011` 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 = 19839 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC