Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

AGF Aarhus

Entrenador: Uwe Rösler

Temporada 2023/2024

TEMPORADA 2023/2024

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Brøndby IF	27	52	26	56
2	Midtjylland	27	49	33	52
3	Kobenhavn	27	54	31	52
4	Nordsjaellan	27	49	27	50
5	AGF Aarhus	27	34	36	38
6	Silkeborg	27	34	38	32

TEMPORADA 2022/2023

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kobenhavn	32	61	35	59
2	Nordsjaellan	32	50	35	55
3	AGF Aarhus	32	42	31	51
4	Viborg FF	32	44	35	51
5	Brøndby IF	32	48	52	44
6	Randers	32	40	47	41

TEMPORADA 2021/2022

SUPERLIGA DANESA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Viborg FF	32	45	43	44
2	Odense BK	32	45	46	38
3	Nordsjaellan	32	38	47	36
4	AGF Aarhus	32	31	43	30
5	Vejle BK	32	31	60	29
6	SonderjyskE	32	28	54	23

TEMPORADA 2020/2021

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Brøndby IF	32	58	38	61
2	Midtjylland	32	57	33	60
3	Kobenhavn	32	61	53	55
4	AGF Aarhus	32	48	42	48
5	Nordsjaellan	32	51	51	43
6	Randers	32	43	38	40

TEMPORADA 2019/2020

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Midtjylland	10	19	15	82
2	Kobenhavn	10	11	13	68
3	AGF Aarhus	10	16	13	64
4	Brøndby IF	10	9	5	56
5	Aalborg BK	10	10	11	54
6	Nordsjaellan	10	11	19	47

TEMPORADA 2018/2019

SUPERLIGA DANESA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	AGF Aarhus	6	15	6	47
2	SonderjyskE	6	7	8	35
3	AC Horsens	6	1	10	33
4	Vejle BK	6	12	11	28
5	Randers	6	6	5	47
6	Aalborg BK	6	6	6	40
7	Vendsyssel	6	8	8	29
8	Hobro	6	9	10	27

TEMPORADA 2017/2018

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hobro	6	8	6	44
2	AGF Aarhus	6	12	7	41
3	Silkeborg	6	7	11	32
4	Helsingør	6	6	9	27
5	Odense BK	6	11	6	42
6	SonderjyskE	6	6	6	41
7	Randers	6	9	6	30
8	Lyngby BK	6	4	12	23

TEMPORADA 2016/2017

SUPERLIGA DANESA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Randers	6	7	3	41
2	Odense BK	6	7	6	39
3	AC Horsens	6	5	8	36
4	Esbjerg	6	4	6	30
5	Silkeborg	6	5	5	38
6	Aalborg BK	6	2	7	38
7	AGF Aarhus	6	12	6	37
8	Viborg FF	6	6	7	33

TEMPORADA 2015/2016

SUPERLIGA DANESA
Equipo		PJ	GF	GC	Puntos
1	Kobenhavn	33	62	28	71
2	SonderjyskE	33	56	36	62
3	Midtjylland	33	57	33	59
4	Brøndby IF	33	43	37	54
5	Aalborg BK	33	56	44	50
6	Randers	33	45	43	47
7	Odense BK	33	50	52	46
8	Viborg FF	33	34	42	40
9	Nordsjaellan	33	35	51	38
10	AGF Aarhus	33	47	49	37
11	Esbjerg	33	38	64	30
12	Hobro	33	26	70	18

TEMPORADA 2014/2015

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos
1	Viborg FF	33	47	20	65
2	AGF Aarhus	33	59	33	61
3	Lyngby BK	33	49	37	51
4	Vendsyssel	33	35	29	49
5	Vejle BK	33	41	46	45
6	AC Horsens	33	43	42	42
7	HB Køge	33	33	35	42
8	Skive	33	40	42	41
9	Roskilde	33	40	38	38
10	Fredericia	33	28	40	34
11	Akademisk	33	35	61	32
12	Brønshøj	33	20	47	23

TEMPORADA 2013/2014

SUPERLIGA DANESA
Equipo		PJ	GF	GC	Puntos
1	Aalborg BK	33	60	38	62
2	Kobenhavn	33	54	38	56
3	Midtjylland	33	61	38	55
4	Brøndby IF	33	47	38	52
5	Esbjerg	33	47	38	48
6	Nordsjaellan	33	38	44	46
7	Randers	33	41	45	41
8	Odense BK	33	47	46	40
9	Vestsjællan	33	31	42	38
10	SonderjyskE	33	41	53	38
11	AGF Aarhus	33	38	60	32
12	Viborg FF	33	38	63	28

TEMPORADA 2012/2013

SUPERLIGA DANESA
Equipo		PJ	GF	GC	Puntos
1	Kobenhavn	33	62	32	65
2	Nordsjaellan	33	60	37	60
3	Randers	33	36	42	52
4	Esbjerg	33	38	32	47
5	Aalborg BK	33	51	46	47
6	Midtjylland	33	51	47	47
7	AGF Aarhus	33	50	49	41
8	SonderjyskE	33	53	57	41
9	Brøndby IF	33	39	45	39
10	Odense BK	33	52	59	38
11	AC Horsens	33	31	49	34
12	Silkeborg	33	38	66	31

Competiciones que juega

Superliga Danesa Grupo 2

Pos	Equipos		Pts
1		Brøndby IF	56
2		Midtjylland	52
3		Kobenhavn	52
4		Nordsjaelland	50
5		AGF Aarhus	38
6		Silkeborg IF	32

	Previa de Champions : Brøndby IF
	: Midtjylland
	Playoffs : Kobenhavn

RIVALES EN Fase Previa Conf.

RIVALES EN Copa Danesa

RIVALES EN Superliga Danesa

USO DE MEMORIA

6,081,096 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1492
Total Execution Time	0.1504

CADENA URL

/historico/Agf-Aarhus

GET DATOS

$_GET['/historico/Agf-Aarhus']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0062	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 = 75670
0.0049	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 = 72100
0.0022	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=83 AND type_rel = 2
0.0036	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 83 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0034	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 (8143,52866,75436,256335,468173) ORDER BY n.cover_points DESC, update_date DESC
0.0071	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 = '83' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 72110 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0034	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=83 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (75670,72646,72100,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 75670 AND teamId = 83
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72100 AND teamId = 83
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 83
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 83
0.0025	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 = 75670 AND t.round = 5 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 = '83' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '83' and rp.type = 4
0.0021	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 = '83' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 75670 WHERE rp.league_id = 75670 AND rp.teamId = 83 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.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 = 75670 WHERE rp.league_id = 75670 AND rp.teamId = 83 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 75670 WHERE rp.league_id = 75670 AND rp.teamId = 83 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 83 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72110 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.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* `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 = 75670 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.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* `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 = 67759 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.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* `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 = 71334 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.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* `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 = 62854 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.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* `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 = 66998 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.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* `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.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* `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.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* `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.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* `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 = 56773 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.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* `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.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 = 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.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* `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.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* `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.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* `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 = 31724 AND t.round = 26 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* `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.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* `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 = 15435 AND t.round = 33 ORDER BY team.conference 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* `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 = 3986 AND t.round = 33 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* `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 = 2366 AND t.round = 33 ORDER BY team.conference 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* `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 = 2019 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

AGF Aarhus

AGF Aarhus

Selecciona un equipo

Competiciones que juega

Superliga Danesa Grupo 2

RIVALES EN Fase Previa Conf.

RIVALES EN Copa Danesa

RIVALES EN Superliga Danesa