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

Nordsjaelland

Entrenador: Johannes Thorup

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 1
Equipo		PJ	GF	GC	Puntos
1	Kobenhavn	22	43	13	48
2	Midtjylland	22	37	22	42
3	Brøndby IF	22	30	24	40
4	Aalborg BK	22	36	26	38
5	Randers	22	26	25	33
6	Silkeborg	22	34	21	31
7	Viborg FF	22	31	33	27
8	AGF Aarhus	22	24	29	26
9	Odense BK	22	31	35	21
10	Nordsjaellan	22	24	37	21
11	Vejle BK	22	21	48	16
12	SonderjyskE	22	17	41	13

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 2
Equipo		PJ	GF	GC	Puntos
1	Kobenhavn	10	21	14	82
2	Midtjylland	10	14	17	71
3	Esbjerg	10	13	12	56
4	Brøndby IF	10	16	12	52
5	Odense BK	10	13	17	52
6	Nordsjaellan	10	10	15	44

TEMPORADA 2017/2018

SUPERLIGA DANESA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Midtjylland	10	20	10	85
2	Brøndby IF	10	24	13	81
3	Nordsjaellan	10	14	17	59
4	Kobenhavn	10	15	14	58
5	Aalborg BK	10	10	17	45
6	AC Horsens	10	11	23	40

TEMPORADA 2016/2017

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kobenhavn	10	17	10	84
2	Brøndby IF	10	10	17	62
3	Lyngby BK	10	17	12	58
4	Midtjylland	10	23	24	54
5	Nordsjaellan	10	18	14	49
6	SonderjyskE	10	14	22	46

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

SUPERLIGA DANESA
Equipo		PJ	GF	GC	Puntos
1	Midtjylland	33	64	34	71
2	Kobenhavn	33	40	22	67
3	Brøndby IF	33	43	29	55
4	Randers	33	39	28	52
5	Aalborg BK	33	39	31	48
6	Nordsjaellan	33	39	44	44
7	Hobro	33	40	47	43
8	Esbjerg	33	47	45	40
9	Odense BK	33	35	43	40
10	SonderjyskE	33	35	44	37
11	Vestsjællan	33	31	52	33
12	Silkeborg	33	26	59	14

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

Conference League Grupo 8

Pos	Equipos		Pts
1		Fenerbahçe	12
2		Ludogorets	12
3		Nordsjaelland	10
4		Spartak Trnava	1

	: Fenerbahçe
	: Ludogorets
	Eliminado : Nordsjaelland, Spartak Trnava

RIVALES EN Fase Previa Conf.

RIVALES EN Conference Leagu.

RIVALES EN Copa Danesa

RIVALES EN Superliga Danesa

USO DE MEMORIA

6,218,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.6453
Total Execution Time	0.6467

CADENA URL

/historico/Nordsj-Aelig-Lland

GET DATOS

$_GET['/historico/Nordsj-Aelig-Lland']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0258	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 = 73887
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9801 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9801 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 (70996,72778,95767,104368,123084) ORDER BY n.cover_points DESC, update_date DESC
0.0135	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 = '9801' 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 = 73887 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	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=9801 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 (75670,73887,72646,72103,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.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 75670 AND teamId = 9801
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 73887 AND teamId = 9801
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 72103 AND teamId = 9801
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 9801
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9801
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 = 73887 AND t.round = 6 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 = '9801' 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 = '9801' 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 = '9801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0138	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 = 73887 WHERE rp.league_id = 73887 AND rp.teamId = 9801 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 = 73887 WHERE rp.league_id = 73887 AND rp.teamId = 9801 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 events2024 e ON e.player_id = p.id AND e.league_id = 73887 WHERE rp.league_id = 73887 AND rp.teamId = 9801 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 9801 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 = 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.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 = 75670 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.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* `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.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* `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.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* `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.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* `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.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 = 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.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 = 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.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.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 = 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.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* `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.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* `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 = 49320 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 43138 AND t.round = 10 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 = 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.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 = 38109 AND t.round = 10 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* `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.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 = 3817 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 = 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.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 = 2019 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nordsjaelland

Nordsjaelland

Selecciona un equipo

Competiciones que juega

Conference League Grupo 8

RIVALES EN Fase Previa Conf.

RIVALES EN Conference Leagu.

RIVALES EN Copa Danesa

RIVALES EN Superliga Danesa