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 2
Equipo PJ GF GC Puntos
1 SonderjyskE SonderjyskE 27 65 25 59
2 Aalborg BK Aalborg BK 27 56 31 56
3 Fredericia Fredericia 27 41 36 44
4 Vendsyssel Vendsyssel 27 40 34 42
5 Kolding IF Kolding IF 27 42 39 39
6 Hobro Hobro 27 31 33 37
TEMPORADA 2022/2023
PRIMERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 Fredericia Fredericia 32 56 48 45
2 HB Køge HB Køge 32 50 51 44
3 Hillerød Hillerød 32 37 51 41
4 Hobro Hobro 32 33 42 38
5 Fremad Amager Fremad 32 38 60 34
6 Nykøbing FC Nykøbing 32 43 73 23
TEMPORADA 2021/2022
PRIMERA DINAMARCA GRUPO 3
Equipo PJ GF GC Puntos
1 HB Køge HB Køge 32 45 41 42
2 Hobro Hobro 32 47 50 39
3 Vendsyssel Vendsyssel 32 39 44 36
4 Fremad Amager Fremad 32 39 62 33
5 Esbjerg Esbjerg 32 36 54 28
6 Jammerbugt Jammerbugt 32 32 74 26
TEMPORADA 2020/2021
PRIMERA DINAMARCA GRUPO 2
Equipo PJ GF GC Puntos
1 Hvidovre IF Hvidovre IF 32 40 47 39
2 Fremad Amager Fremad 32 47 41 35
3 Hobro Hobro 32 38 51 34
4 Vendsyssel Vendsyssel 32 33 51 32
5 Kolding IF Kolding IF 32 31 49 32
6 Skive Skive 32 28 60 28
TEMPORADA 2019/2020
SUPERLIGA DANESA GRUPO 3
Equipo PJ GF GC Puntos
1 AC Horsens AC Horsens 6 11 6 46
2 Randers Randers 6 12 10 45
3 Hobro Hobro 6 10 13 30
4 Esbjerg Esbjerg 6 10 14 22
5 Odense BK Odense BK 6 9 12 43
6 SonderjyskE SonderjyskE 6 6 5 38
7 Lyngby BK Lyngby BK 6 3 9 34
8 Silkeborg IF Silkeborg 6 12 4 26
TEMPORADA 2018/2019
SUPERLIGA DANESA GRUPO 1
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 26 65 23 61
2 Midtjylland Midtjylland 26 62 26 60
3 Odense BK Odense BK 26 35 31 42
4 Brøndby IF Brøndby IF 26 44 40 38
5 Esbjerg Esbjerg 26 32 35 38
6 Nordsjaelland Nordsjaellan 26 42 39 36
7 Aalborg BK Aalborg BK 26 38 35 36
8 Randers Randers 26 29 34 34
9 AGF Aarhus AGF Aarhus 26 31 34 31
10 AC Horsens AC Horsens 26 31 45 31
11 SonderjyskE SonderjyskE 26 30 37 28
12 Vendsyssel Vendsyssel 26 24 41 22
13 Hobro Hobro 26 22 45 21
14 Vejle BK Vejle BK 26 22 42 20
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
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 62 28 71
2 SonderjyskE SonderjyskE 33 56 36 62
3 Midtjylland Midtjylland 33 57 33 59
4 Brøndby IF Brøndby IF 33 43 37 54
5 Aalborg BK Aalborg BK 33 56 44 50
6 Randers Randers 33 45 43 47
7 Odense BK Odense BK 33 50 52 46
8 Viborg FF Viborg FF 33 34 42 40
9 Nordsjaelland Nordsjaellan 33 35 51 38
10 AGF Aarhus AGF Aarhus 33 47 49 37
11 Esbjerg Esbjerg 33 38 64 30
12 Hobro Hobro 33 26 70 18
TEMPORADA 2014/2015
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Midtjylland Midtjylland 33 64 34 71
2 Kobenhavn Kobenhavn 33 40 22 67
3 Brøndby IF Brøndby IF 33 43 29 55
4 Randers Randers 33 39 28 52
5 Aalborg BK Aalborg BK 33 39 31 48
6 Nordsjaelland Nordsjaellan 33 39 44 44
7 Hobro Hobro 33 40 47 43
8 Esbjerg Esbjerg 33 47 45 40
9 Odense BK Odense BK 33 35 43 40
10 SonderjyskE SonderjyskE 33 35 44 37
11 Vestsjælland Vestsjællan 33 31 52 33
12 Silkeborg IF Silkeborg 33 26 59 14
TEMPORADA 2013/2014
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Silkeborg IF Silkeborg 33 67 38 66
2 Hobro Hobro 33 58 36 65
3 Lyngby BK Lyngby BK 33 58 41 57
4 Brønshøj Brønshøj 33 47 39 53
5 AC Horsens AC Horsens 33 60 48 52
6 HB Køge HB Køge 33 39 31 49
7 Vejle BK Vejle BK 33 49 38 47
8 Fredericia Fredericia 33 47 45 43
9 Vendsyssel Vendsyssel 33 35 59 38
10 Akademisk Boldklub Akademisk 33 42 57 36
11 Hvidovre IF Hvidovre IF 33 43 63 36
12 Marienlyst Marienlyst 33 28 78 15
TEMPORADA 2012/2013
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Viborg FF Viborg FF 33 60 30 62
2 Vestsjælland Vestsjællan 33 39 27 62
3 Vejle BK Vejle BK 33 46 29 58
4 Lyngby BK Lyngby BK 33 55 42 56
5 Fredericia Fredericia 33 53 48 44
6 HB Køge HB Køge 33 39 45 44
7 Vendsyssel Vendsyssel 33 38 41 40
8 Brønshøj Brønshøj 33 41 36 39
9 Hobro Hobro 33 37 43 38
10 Akademisk Boldklub Akademisk 33 33 34 37
11 Skive Skive 33 47 55 37
12 Fyn Fyn 33 26 84 11
TEMPORADA 2011/2012
PRIMERA DINAMARCA
Equipo PJ GF GC Puntos
1 Esbjerg Esbjerg 26 60 19 66
2 Randers Randers 26 38 22 49
3 Vejle BK Vejle BK 26 58 32 44
4 Viborg FF Viborg FF 26 45 34 40
5 Brønshøj Brønshøj 26 35 34 40
6 Vestsjælland Vestsjællan 26 42 35 38
7 Fredericia Fredericia 26 33 30 35
8 Skive Skive 26 31 41 34
9 Hobro Hobro 26 37 35 33
10 Vendsyssel Vendsyssel 26 31 42 31
11 Akademisk Boldklub Akademisk 26 32 44 29
12 Roskilde Roskilde 26 28 38 27
13 Næstved Næstved 26 32 51 22
14 Jammerbugt Jammerbugt 26 27 72 11

  USO DE MEMORIA  
5,997,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5873
Total Execution Time  0.5886
  CADENA URL  
/historico/Hobro
  GET DATOS  
$_GET['/historico/Hobro']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4811 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4811 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  SELECT /*35 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 (53655,387488) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '4811' ORDER BY l.year DESC,cat.coefficient DESC
0.0136  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 = '4811' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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 = 75693 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=4811 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (75693,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.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 75693 AND teamId = 4811
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 4811
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4811
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 = 75693 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '4811' 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 = '4811' 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 = '4811' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 75693 WHERE rp.league_id = 75693 AND rp.teamId = 4811 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.0137  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 = 75693 WHERE rp.league_id = 75693 AND rp.teamId = 4811 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 75693 WHERE rp.league_id = 75693 AND rp.teamId = 4811 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0143  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 = 4811 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0144  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.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 `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 = 75693 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.0143  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.0142  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 = 71292 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.0141  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 = 63039 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.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 `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 = 67135 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.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 `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 = 57736 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.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 `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 = 61986 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.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 `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 = 49908 AND t.round = 26 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 = 56774 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.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 `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 = 49321 AND t.round = 6 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 `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 = 43820 AND t.round = 26 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 = 38692 AND t.round = 26 ORDER BY team.conference 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 `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 = 43137 AND t.round = 6 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 `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 `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 = 2474 AND t.round = 33 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 `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 = 1361 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC