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 74 43 53
4 TSB Flensburg Flensburg 26 58 33 47
5 Eckernförder SV Eckernförde 25 52 39 42
6 SV Preußen Reinfeld Preußen 26 48 38 41
7 Heider SV Heider SV 26 55 47 39
8 Oldenburger SV Oldenburger 27 53 60 33
9 VfR Neumunster Neumunster 27 38 48 32
10 VfB Lübeck II Lübeck 27 52 64 28
11 Nordmark Satrup Nordmark 25 43 55 28
12 Hohenwestedt Hohenwestedt 26 30 64 27
13 Inter Turkspor Kiel Inter 27 54 71 26
14 Dornbreite Lübeck Dornbreite 26 30 57 26
15 Bordesholm Bordesholm 27 35 80 21
16 Weiche Flensburg 08 II Weiche 27 37 69 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 25
Equipo PJ GF GC Puntos
1 Todesfelde Todesfelde 8 24 11 31
2 SV Eichede SV Eichede 8 15 11 25
3 Eckernförder SV Eckernförde 8 15 15 22
4 TSB Flensburg Flensburg 8 15 22 18
5 Oldenburger SV Oldenburger 8 33 20 17
6 Bordesholm Bordesholm 8 15 18 16
7 Pansdorf Pansdorf 8 14 20 12
8 Inter Turkspor Kiel Inter 8 17 31 8
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,893,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0987
Total Execution Time  0.0999
  CADENA URL  
/historico/Bordesholm
  GET DATOS  
$_GET['/historico/Bordesholm']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0040  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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20200 AND type_rel = 2
0.0025  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.0020  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.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=20200 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72559 AND teamId = 20200
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 20200
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 = 72559 AND t.round = 27 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 = '20200' 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 = '20200' 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 = '20200' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0029  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.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 = 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.0023  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.0026  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.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 `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.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 `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.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 = 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.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 = 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.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 = 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.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 `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.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 `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.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 `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.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 `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.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 `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