4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SFL Bremerhaven
TEMPORADA 2021/2022
OBERLIGA GRUPO 13
Equipo PJ GF GC Puntos
1 Bremer SV Bremer SV 34 152 25 98
2 Brinkumer SV Brinkumer 34 138 36 86
3 OSC Bremerhaven Bremerhaven 34 78 43 61
4 BTS Neustadt Neustadt 34 66 55 56
5 Union Bremen Union Bremen 34 76 56 55
6 Geestemünde Geestemünde 34 68 80 55
7 SV Hemelingen Hemelingen 34 88 83 52
8 Vatan Sport Vatan Sport 34 61 63 51
9 Schwachhausen Schwachhause 34 74 74 49
10 SFL Bremerhaven Bremerhaven 34 67 71 49
11 Leher TS Bremerhaven Leher 34 67 68 46
12 TuS Komet Arsten Komet Arsten 34 61 70 46
13 SG Aumund-Vegesack Aumund-Veges 34 69 78 45
14 Blumenthaler SV Blumenthaler 34 76 76 42
15 Werder Bremen III Werder 34 64 79 32
16 Hastedt Hastedt 34 46 119 24
17 Habenhauser FV Habenhauser 34 47 110 18
18 SC Borgfeld SC Borgfeld 34 38 150 14
TEMPORADA 2020/2021
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 Brinkumer SV Brinkumer 8 26 8 22
2 Bremer SV Bremer SV 8 25 8 22
3 SFL Bremerhaven Bremerhaven 8 23 15 19
4 Leher TS Bremerhaven Leher 8 17 6 17
5 Geestemünde Geestemünde 8 27 22 13
6 Blumenthaler SV Blumenthaler 8 18 12 12
7 Vatan Sport Vatan Sport 6 14 13 12
8 Schwachhausen Schwachhause 6 17 9 10
9 SG Aumund-Vegesack Aumund-Veges 8 12 14 9
10 Habenhauser FV Habenhauser 8 13 19 9
11 TuS Komet Arsten Komet Arsten 7 7 9 8
12 SV Hemelingen Hemelingen 7 16 22 8
13 SC Borgfeld SC Borgfeld 8 15 31 7
14 Hastedt Hastedt 8 13 19 6
15 BTS Neustadt Neustadt 8 22 29 6
16 OSC Bremerhaven Bremerhaven 7 9 15 5
17 Union Bremen Union Bremen 7 10 20 4
18 Werder Bremen III Werder 8 9 22 4
TEMPORADA 2019/2020
OBERLIGA GRUPO 12
Equipo PJ GF GC Puntos
1 Oberneuland Oberneuland 19 74 18 51
2 Schwachhausen Schwachhause 20 55 26 48
3 Brinkumer SV Brinkumer 21 57 33 47
4 SFL Bremerhaven Bremerhaven 21 61 29 45
5 Bremer SV Bremer SV 20 54 24 37
6 SV Hemelingen Hemelingen 21 47 39 37
7 Blumenthaler SV Blumenthaler 21 59 48 35
8 SC Borgfeld SC Borgfeld 21 44 53 25
9 SG Aumund-Vegesack Aumund-Veges 21 44 53 24
10 Geestemünde Geestemünde 21 49 65 24
11 Hastedt Hastedt 21 34 50 23
12 Leher TS Bremerhaven Leher 21 38 61 18
13 Union Bremen Union Bremen 21 31 51 16
14 BTS Neustadt Neustadt 21 27 67 16
15 Habenhauser FV Habenhauser 21 29 58 14
16 Werder Bremen III Werder 21 24 52 12
TEMPORADA 2018/2019
OBERLIGA GRUPO 9
Equipo PJ GF GC Puntos
1 Bremer SV Bremer SV 30 115 12 85
2 Oberneuland Oberneuland 30 139 18 84
3 SFL Bremerhaven Bremerhaven 30 70 37 61
4 Schwachhausen Schwachhause 30 85 59 55
5 Geestemünde Geestemünde 30 101 92 46
6 SG Aumund-Vegesack Aumund-Veges 30 71 63 42
7 Blumenthaler SV Blumenthaler 30 68 70 42
8 Brinkumer SV Brinkumer 30 75 79 41
9 Leher TS Bremerhaven Leher 30 67 80 39
10 Hastedt Hastedt 30 52 72 39
11 Werder Bremen III Werder 30 52 73 31
12 SC Borgfeld SC Borgfeld 30 58 88 31
13 Habenhauser FV Habenhauser 30 48 103 25
14 BTS Neustadt Neustadt 30 33 69 23
15 OSC Bremerhaven Bremerhaven 30 43 88 23
16 Vatan Sport Vatan Sport 30 27 101 15
TEMPORADA 2017/2018
LANDESLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 SC Borgfeld SC Borgfeld 30 115 38 75
2 SFL Bremerhaven Bremerhaven 30 130 39 73
3 TuRa Bremen TuRa Bremen 30 81 54 55
4 SV Lemwerder Lemwerder 30 75 48 54
5 Union Bremen Union Bremen 30 81 58 50
6 TuS Komet Arsten Komet Arsten 30 93 59 49
7 SV Hemelingen Hemelingen 30 91 62 49
8 Vahr-Blockdiek Vahr-Blockdi 30 67 65 44
9 Woltmershausen Woltmershaus 30 79 67 40
10 TV Bremen-Walle Bremen-Walle 30 57 81 38
11 SV Grohn SV Grohn 30 68 91 34
12 OT Bremen OT Bremen 30 72 99 34
13 Melchiorshausen Melchiorshau 30 46 90 32
14 TSV Lesum-Burgdamm Lesum-Burgda 30 48 104 30
15 DJK Blumenthal Blumenthal 30 43 90 23
16 TSV Farge TSV Farge 30 44 145 13
TEMPORADA 2016/2017
LANDESLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Hastedt Hastedt 30 115 31 71
2 Vatan Sport Vatan Sport 30 74 34 70
3 SFL Bremerhaven Bremerhaven 30 77 37 68
4 SC Borgfeld SC Borgfeld 30 99 44 63
5 SV Lemwerder Lemwerder 30 73 67 47
6 TuS Komet Arsten Komet Arsten 30 76 73 44
7 DJK Blumenthal Blumenthal 30 58 65 44
8 TSV Lesum-Burgdamm Lesum-Burgda 30 65 82 42
9 SV Hemelingen Hemelingen 30 68 67 38
10 Union Bremen Union Bremen 30 56 70 35
11 Vahr-Blockdiek Vahr-Blockdi 30 66 87 33
12 Woltmershausen Woltmershaus 30 52 64 32
13 OT Bremen OT Bremen 30 55 71 32
14 Türkspor Bremen Türkspor 30 48 68 32
15 TuSpo Surheide TuSpo 30 57 80 30
16 Burg Burg 30 30 129 4
TEMPORADA 2015/2016
LANDESLIGA GRUPO 8
Equipo PJ GF GC Puntos
1 Oberneuland Oberneuland 30 112 37 78
2 Melchiorshausen Melchiorshau 30 81 39 65
3 SFL Bremerhaven Bremerhaven 30 104 30 63
4 SV Hemelingen Hemelingen 30 68 38 62
5 Vahr-Blockdiek Vahr-Blockdi 30 83 45 61
6 OT Bremen OT Bremen 30 99 52 55
7 SC Borgfeld SC Borgfeld 30 105 49 54
8 TuSpo Surheide TuSpo 30 71 73 43
9 Wulsdorf Wulsdorf 30 52 75 39
10 SV Lemwerder Lemwerder 30 55 56 35
11 Woltmershausen Woltmershaus 30 48 68 29
12 DJK Blumenthal Blumenthal 30 51 87 28
13 Türkspor Bremen Türkspor 30 45 94 28
14 Burg Burg 30 59 113 25
15 ATSV Sebaldsbrück Bremen ATSV 30 27 100 16
16 FC Sparta Bremerhaven Sparta 30 25 129 5

  USO DE MEMORIA  
5,655,816 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6429
Total Execution Time  0.6441
  CADENA URL  
/historico/Sfl-Bremerhaven
  GET DATOS  
$_GET['/historico/Sfl-Bremerhaven']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0131  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 = 'Sfl-Bremerhaven' 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.0136  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 = 'Sfl-Bremerhaven' 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.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=111901 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=111901 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 63701
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=111901 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=573 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 573 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  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 (1247431,1040230,935468,822575,807123) ORDER BY n.cover_points DESC, update_date DESC
0.0127  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 = '111901' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '111901' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = '111901' 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 = 63701 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=111901 AND l.year in (2021,2022,2023) 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 (63701,62807) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 63701 AND teamId = 111901
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 111901
0.0254  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63701 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '111901' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '111901' and rp.type = 4
0.0127  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 = '111901' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 events2022 e ON e.player_id = p.id AND e.league_id = 63701 WHERE rp.league_id = 63701 AND rp.teamId = 111901 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.0126  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 events2022 e ON e.player_id = p.id AND e.league_id = 63701 WHERE rp.league_id = 63701 AND rp.teamId = 111901 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2022 e ON e.player_id = p.id AND e.league_id = 63701 WHERE rp.league_id = 63701 AND rp.teamId = 111901 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 111901 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0252  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 = 63701 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.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 `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 = 58499 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.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 `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 = 50541 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.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 `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 = 46649 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 `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 = 46819 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 46837 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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 63701 ORDER BY nameShow LIMIT 100