4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PRIMERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Hillerød Hillerød 27 46 36 36
2 AC Horsens AC Horsens 27 33 41 35
3 B93 B93 27 33 49 32
4 HB Køge HB Køge 26 36 56 25
5 Næstved Næstved 27 30 48 21
6 FC Helsingør Helsingør 26 29 54 15
TEMPORADA 2022/2023
PRIMERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Vejle BK Vejle BK 32 61 30 67
2 Hvidovre IF Hvidovre IF 32 65 41 58
3 SonderjyskE SonderjyskE 32 60 45 56
4 Vendsyssel Vendsyssel 32 48 43 46
5 Næstved Næstved 32 50 48 43
6 FC Helsingør Helsingør 32 47 56 42
TEMPORADA 2021/2022
PRIMERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 AC Horsens AC Horsens 32 55 29 64
2 Lyngby BK Lyngby BK 32 62 29 63
3 Hvidovre IF Hvidovre IF 32 49 31 57
4 FC Helsingør Helsingør 32 65 44 55
5 Fredericia Fredericia 32 55 53 50
6 Nykøbing FC Nykøbing 32 50 63 35
TEMPORADA 2020/2021
PRIMERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Viborg FF Viborg FF 32 71 24 76
2 Silkeborg IF Silkeborg 32 76 28 73
3 Esbjerg Esbjerg 32 43 38 59
4 FC Helsingør Helsingør 32 50 41 53
5 Fredericia Fredericia 32 42 44 44
6 HB Køge HB Køge 32 28 53 31
TEMPORADA 2019/2020
SEGUNDA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Aarhus Fremad Aarhus 6 21 2 54
2 FC Helsingør Helsingør 6 9 4 54
3 Middelfart Middelfart 6 15 10 43
4 Brabrand Brabrand 6 7 10 39
5 Thisted Thisted 6 8 9 38
6 Jammerbugt Jammerbugt 6 11 3 37
7 Akademisk Boldklub Akademisk 6 13 12 36
8 Hellerup IK Hellerup IK 6 9 9 35
9 Vanløse Vanløse 6 6 11 34
10 Brønshøj Brønshøj 6 6 20 31
11 Frem 1886 Frem 1886 6 9 17 29
12 Avarta Avarta 6 7 14 25
TEMPORADA 2018/2019
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Silkeborg IF Silkeborg 33 60 41 61
2 Viborg FF Viborg FF 33 61 37 60
3 Lyngby BK Lyngby BK 33 51 47 52
4 Næstved Næstved 33 43 40 50
5 Fremad Amager Fremad 33 42 45 50
6 Fredericia Fredericia 33 51 47 47
7 HB Køge HB Køge 33 52 47 45
8 Nykøbing FC Nykøbing 33 44 47 45
9 Roskilde Roskilde 33 57 66 35
10 Hvidovre IF Hvidovre IF 33 39 49 35
11 FC Helsingør Helsingør 33 35 43 31
12 Thisted Thisted 33 35 61 30
TEMPORADA 2017/2018
SUPERLIGA DANESA GRUPO 2
Equipo PJ GF GC Puntos
1 Hobro Hobro 6 8 6 44
2 AGF Aarhus AGF Aarhus 6 12 7 41
3 Silkeborg IF Silkeborg 6 7 11 32
4 FC Helsingør Helsingør 6 6 9 27
5 Odense BK Odense BK 6 11 6 42
6 SonderjyskE SonderjyskE 6 6 6 41
7 Randers Randers 6 9 6 30
8 Lyngby BK Lyngby BK 6 4 12 23
TEMPORADA 2016/2017
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Hobro Hobro 33 54 34 58
2 Vendsyssel Vendsyssel 33 51 39 55
3 FC Helsingør Helsingør 33 43 31 53
4 Roskilde Roskilde 33 45 42 53
5 Skive Skive 33 41 51 49
6 Nykøbing FC Nykøbing 33 50 51 46
7 HB Køge HB Køge 33 32 28 44
8 Fredericia Fredericia 33 36 43 43
9 Vejle BK Vejle BK 33 49 46 41
10 Fremad Amager Fremad 33 42 45 41
11 Næstved Næstved 33 45 51 35
12 Akademisk Boldklub Akademisk 33 34 61 24
TEMPORADA 2015/2016
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Lyngby BK Lyngby BK 33 59 37 64
2 Silkeborg IF Silkeborg 33 59 29 63
3 AC Horsens AC Horsens 33 52 34 60
4 Vendsyssel Vendsyssel 33 41 33 56
5 Vejle BK Vejle BK 33 55 47 50
6 Fredericia Fredericia 33 45 45 47
7 FC Helsingør Helsingør 33 40 42 47
8 HB Køge HB Køge 33 34 35 45
9 Roskilde Roskilde 33 51 58 39
10 Næstved Næstved 33 38 47 37
11 Skive Skive 33 37 50 31
12 Vestsjælland Vestsjællan 33 19 73 13
TEMPORADA 2014/2015
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Helsingør Helsingør 30 59 22 71
2 Frem 1886 Frem 1886 30 58 28 61
3 Hvidovre IF Hvidovre IF 30 67 38 57
4 Fremad Amager Fremad 30 55 35 56
5 Nykøbing FC Nykøbing 30 69 34 55
6 HIK HIK 30 61 36 48
7 B93 B93 30 36 35 43
8 Avarta Avarta 30 57 48 42
9 Holbæk Holbæk 30 41 44 41
10 B 1908 B 1908 30 42 36 37
11 Rishøj Rishøj 30 31 40 36
12 Avedøre Avedøre 30 33 46 36
13 GVI GVI 30 28 57 26
14 BSV Søllerød Søllerød 30 30 62 21
15 Herlev Herlev 30 29 78 14
16 Svebølle Svebølle 30 20 77 10
TEMPORADA 2013/2014
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Roskilde Roskilde 30 88 22 80
2 Næstved Næstved 29 67 33 58
3 Fremad Amager Fremad 30 76 55 51
4 B 1908 B 1908 29 45 34 50
5 FC Helsingør Helsingør 30 55 38 47
6 Nordvest Nordvest 30 66 58 45
7 Nykøbing FC Nykøbing 30 55 60 40
8 Frem 1886 Frem 1886 30 50 46 40
9 BSV Søllerød Søllerød 29 38 41 38
10 B93 B93 30 42 43 36
11 GVI GVI 29 40 60 35
12 Svebølle Svebølle 30 32 46 32
13 Avarta Avarta 30 50 67 31
14 Skjold Birkerød Skjold 30 41 70 30
15 Vanløse Vanløse 30 34 67 29
16 SC Egedal SC Egedal 30 31 70 20
TEMPORADA 2012/2013
SEGUNDA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 30 84 31 69
2 FC Helsingør Helsingør 30 79 38 64
3 Rishøj Rishøj 30 50 29 60
4 Næstved Næstved 30 64 32 59
5 HIK HIK 30 58 45 51
6 B 1908 B 1908 30 46 41 51
7 Frem 1886 Frem 1886 30 45 40 48
8 Roskilde Roskilde 30 52 41 46
9 Nordvest Nordvest 30 51 49 44
10 Nykøbing FC Nykøbing 30 48 59 36
11 Avarta Avarta 30 39 47 33
12 Svebølle Svebølle 30 37 61 31
13 Skjold Birkerød Skjold 30 44 65 29
14 Fremad Amager Fremad 30 39 59 23
15 Herlev Herlev 30 27 67 21
16 NB Bornholm NB Bornholm 30 14 73 6
TEMPORADA 2010/2011
SEGUNDA DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 Nordvest Nordvest 30 59 29 65
2 FC Helsingør Helsingør 30 63 41 57
3 Hellerup IK Hellerup IK 30 43 24 54
4 Nykøbing FC Nykøbing 30 56 25 53
5 BSV Søllerød Søllerød 30 58 47 50
6 B93 B93 30 57 44 45
7 Avarta Avarta 30 51 44 42
8 Vanløse Vanløse 30 58 52 42
9 Herlev Herlev 30 44 51 41
10 Stenløse BK Stenløse 30 38 44 37
11 BGA BGA 30 40 45 35
12 Skjold Skjold 30 36 43 33
13 Frederikssund IK Frederikssun 30 43 66 32
14 Allerød Allerød 30 32 61 22
15 Greve IF Greve IF 30 32 65 21
16 Ballerup-Skovlunde Ballerup-Sko 30 30 59 20
TEMPORADA 2009/2010
SERIES DINAMARCA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Helsingør Helsingør 26 94 25 69
2 Frederikssund IK Frederikssun 26 52 30 45
3 Lyngby BK II Lyngby 26 55 35 43
4 Ballerup-Skovlunde Ballerup-Sko 26 32 25 41
5 Frederiksberg Boldklub Frederiksber 26 39 54 36
6 NB Bornholm NB Bornholm 26 42 37 35
7 GVI GVI 26 33 37 35
8 Værløse Værløse 26 45 49 33
9 B 1903 B 1903 26 27 40 33
10 AB Tårnby AB Tårnby 26 46 62 32
11 B 1921 B 1921 26 36 50 31
12 BK Frem 1886 II Frem 1886 26 39 41 28
13 Herfølge BK II Herfølge 26 40 57 24
14 Døllefjelde-Musse Døllefjelde 26 22 60 19

  USO DE MEMORIA  
6,272,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5454
Total Execution Time  0.5466
  CADENA URL  
/historico/Fc-Helsingor
  GET DATOS  
$_GET['/historico/Fc-Helsingor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
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 = 75694
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9809 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=155 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 155 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 (1072160,1054005,1028975,1016371,932545) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '9809' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 72210 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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=9809 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 (75694,72646,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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75694 AND teamId = 9809
0.0168  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 9809
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9809
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 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 = 75694 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '9809' 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 = '9809' and rp.type = 4
0.0131  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 = '9809' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75694 WHERE rp.league_id = 75694 AND rp.teamId = 9809 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.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 = 75694 WHERE rp.league_id = 75694 AND rp.teamId = 9809 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 75694 WHERE rp.league_id = 75694 AND rp.teamId = 9809 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 9809 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72210 AND t.round = 22 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 `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 = 75694 AND t.round = 5 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 `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 = 67913 AND t.round = 22 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 `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 = 71291 AND t.round = 10 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 `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 = 61987 AND t.round = 10 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 = 50399 AND t.round = 17 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 `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 = 56776 AND t.round = 6 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 `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 = 33345 AND t.round = 33 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 `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 = 4158 AND t.round = 30 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 `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 = 2480 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 `tables2013` 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 = 2022 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 `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 = 24342 AND t.round = 30 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 `tables2010` 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 = 24330 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC