4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Randers

Randers

Entrenador: Rasmus Bertelsen

Temporada 2020/2021
TEMPORADA 2020/2021
SUPERLIGA DANESA GRUPO 1
Equipo PJ GF GC Puntos
1 Brøndby IF Brøndby IF 22 40 24 45
2 Midtjylland Midtjylland 22 35 20 43
3 AGF Aarhus AGF Aarhus 22 35 22 38
4 Kobenhavn Kobenhavn 22 39 35 35
5 Randers Randers 22 31 21 32
6 Nordsjaelland Nordsjaellan 22 35 30 29
7 SonderjyskE SonderjyskE 22 30 32 28
8 Odense BK Odense BK 22 25 28 28
9 Aalborg BK Aalborg BK 22 24 30 28
10 Vejle BK Vejle BK 22 25 37 24
11 Lyngby BK Lyngby BK 22 25 43 20
12 AC Horsens AC Horsens 22 15 37 12
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 3
Equipo PJ GF GC Puntos
1 AGF Aarhus AGF Aarhus 6 15 6 47
2 SonderjyskE SonderjyskE 6 7 8 35
3 AC Horsens AC Horsens 6 1 10 33
4 Vejle BK Vejle BK 6 12 11 28
5 Randers Randers 6 6 5 47
6 Aalborg BK Aalborg BK 6 6 6 40
7 Vendsyssel Vendsyssel 6 8 8 29
8 Hobro Hobro 6 9 10 27
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
SUPERLIGA DANESA GRUPO 3
Equipo PJ GF GC Puntos
1 Randers Randers 6 7 3 41
2 Odense BK Odense BK 6 7 6 39
3 AC Horsens AC Horsens 6 5 8 36
4 Esbjerg Esbjerg 6 4 6 30
5 Silkeborg IF Silkeborg 6 5 5 38
6 Aalborg BK Aalborg BK 6 2 7 38
7 AGF Aarhus AGF Aarhus 6 12 6 37
8 Viborg FF Viborg FF 6 6 7 33
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
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 33 60 38 62
2 Kobenhavn Kobenhavn 33 54 38 56
3 Midtjylland Midtjylland 33 61 38 55
4 Brøndby IF Brøndby IF 33 47 38 52
5 Esbjerg Esbjerg 33 47 38 48
6 Nordsjaelland Nordsjaellan 33 38 44 46
7 Randers Randers 33 41 45 41
8 Odense BK Odense BK 33 47 46 40
9 Vestsjælland Vestsjællan 33 31 42 38
10 SonderjyskE SonderjyskE 33 41 53 38
11 AGF Aarhus AGF Aarhus 33 38 60 32
12 Viborg FF Viborg FF 33 38 63 28
TEMPORADA 2012/2013
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 62 32 65
2 Nordsjaelland Nordsjaellan 33 60 37 60
3 Randers Randers 33 36 42 52
4 Esbjerg Esbjerg 33 38 32 47
5 Aalborg BK Aalborg BK 33 51 46 47
6 Midtjylland Midtjylland 33 51 47 47
7 AGF Aarhus AGF Aarhus 33 50 49 41
8 SonderjyskE SonderjyskE 33 53 57 41
9 Brøndby IF Brøndby IF 33 39 45 39
10 Odense BK Odense BK 33 52 59 38
11 AC Horsens AC Horsens 33 31 49 34
12 Silkeborg IF Silkeborg 33 38 66 31
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
TEMPORADA 2010/2011
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 77 29 81
2 Odense BK Odense BK 33 55 41 55
3 Brøndby IF Brøndby IF 33 52 39 51
4 Midtjylland Midtjylland 33 50 42 49
5 Silkeborg IF Silkeborg 33 43 49 43
6 Nordsjaelland Nordsjaellan 33 38 50 39
7 SonderjyskE SonderjyskE 33 32 46 39
8 Lyngby BK Lyngby BK 33 42 52 38
9 AC Horsens AC Horsens 33 29 40 37
10 Aalborg BK Aalborg BK 33 38 48 35
11 Randers Randers 33 41 48 34
12 Esbjerg Esbjerg 33 36 49 33
TEMPORADA 2009/2010
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 61 22 68
2 Odense BK Odense BK 33 46 34 59
3 Brøndby IF Brøndby IF 33 57 50 52
4 Esbjerg Esbjerg 33 48 43 50
5 Aalborg BK Aalborg BK 33 36 30 48
6 Midtjylland Midtjylland 33 45 48 47
7 Nordsjaelland Nordsjaellan 33 40 41 43
8 Silkeborg IF Silkeborg 33 47 51 43
9 SonderjyskE SonderjyskE 33 32 37 41
10 Randers Randers 33 37 43 40
11 AGF Aarhus AGF Aarhus 33 36 47 38
12 Køge BK Køge BK 33 30 69 19
TEMPORADA 2008/2009
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 67 26 74
2 Odense BK Odense BK 33 65 31 69
3 Brøndby IF Brøndby IF 33 55 31 68
4 Midtjylland Midtjylland 33 55 46 55
5 Randers Randers 33 52 50 46
6 AGF Aarhus AGF Aarhus 33 39 44 45
7 Aalborg BK Aalborg BK 33 40 49 39
8 Nordsjaelland Nordsjaellan 33 44 53 35
9 Esbjerg Esbjerg 33 32 41 32
10 SonderjyskE SonderjyskE 33 30 56 28
11 Vejle BK Vejle BK 33 30 59 25
12 AC Horsens AC Horsens 33 35 58 24
TEMPORADA 2007/2008
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Aalborg BK Aalborg BK 33 60 38 71
2 Midtjylland Midtjylland 33 53 36 62
3 Kobenhavn Kobenhavn 33 51 29 60
4 Odense BK Odense BK 33 46 27 52
5 AC Horsens AC Horsens 33 47 43 52
6 Randers Randers 33 41 33 47
7 Esbjerg Esbjerg 33 59 54 45
8 Brøndby IF Brøndby IF 33 44 44 43
9 Nordsjaelland Nordsjaellan 33 47 51 43
10 AGF Aarhus AGF Aarhus 33 33 51 29
11 Viborg FF Viborg FF 33 29 68 20
12 Lyngby BK Lyngby BK 33 33 69 18
TEMPORADA 2006/2007
SUPERLIGA DANESA
Equipo PJ GF GC Puntos
1 Kobenhavn Kobenhavn 33 60 23 76
2 Midtjylland Midtjylland 33 58 39 63
3 Aalborg BK Aalborg BK 33 55 35 61
4 Odense BK Odense BK 33 46 36 58
5 Nordsjaelland Nordsjaellan 33 67 39 57
6 Brøndby IF Brøndby IF 33 50 38 49
7 Esbjerg Esbjerg 33 47 50 40
8 Randers Randers 33 41 53 38
9 Viborg FF Viborg FF 33 34 64 29
10 AC Horsens AC Horsens 33 29 53 28
11 Vejle BK Vejle BK 33 35 64 25
12 Silkeborg IF Silkeborg 33 33 61 22

  USO DE MEMORIA  
6,502,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4686
Total Execution Time  0.4698
  CADENA URL  
/historico/Randers/2021
  GET DATOS  
$_GET['/historico/Randers/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0259  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 = 57888
0.0132  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 = 61994
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9793 AND type_rel = 2
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9793 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (43305,50215,53750,62803,83900) ORDER BY n.cover_points DESC, update_date DESC
0.0137  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 = '9793' 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 = 57888 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134  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=9793 AND l.year in (2020,2021,2022) 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 (66997,66139,63370,63059,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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 66997 AND teamId = 9793
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 66139 AND teamId = 9793
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 63059 AND teamId = 9793
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 63370 AND teamId = 9793
0.0218  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 9793
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 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 = 57888 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0145  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 events2021 e ON e.player_id = p.id AND e.league_id = 57888 WHERE rp.league_id = 57888 AND rp.teamId = 9793 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.0154  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 events2021 e ON e.player_id = p.id AND e.league_id = 57888 WHERE rp.league_id = 57888 AND rp.teamId = 9793 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0175  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 events2021 e ON e.player_id = p.id AND e.league_id = 57888 WHERE rp.league_id = 57888 AND rp.teamId = 9793 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 9793 AND l.year <= 2021 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 `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 = 61994 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.0133  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 = 57888 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.0132  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.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 `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.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 `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.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 `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 = 38110 AND t.round = 6 ORDER BY team.conference 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 `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