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

Resultados de Fútbol

FC Helsingør

Entrenador: Álvaro Santos

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hillerød	27	46	36	36
2	AC Horsens	27	33	41	35
3	B93	27	33	49	32
4	HB Køge	27	36	56	26
5	Næstved	27	30	48	21
6	Helsingør	27	29	54	16

TEMPORADA 2022/2023

PRIMERA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vejle BK	32	61	30	67
2	Hvidovre IF	32	65	41	58
3	SonderjyskE	32	60	45	56
4	Vendsyssel	32	48	43	46
5	Næstved	32	50	48	43
6	Helsingør	32	47	56	42

TEMPORADA 2021/2022

PRIMERA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	AC Horsens	32	55	29	64
2	Lyngby BK	32	62	29	63
3	Hvidovre IF	32	49	31	57
4	Helsingør	32	65	44	55
5	Fredericia	32	55	53	50
6	Nykøbing	32	50	63	35

TEMPORADA 2020/2021

PRIMERA DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Viborg FF	32	71	24	76
2	Silkeborg	32	76	28	73
3	Esbjerg	32	43	38	59
4	Helsingør	32	50	41	53
5	Fredericia	32	42	44	44
6	HB Køge	32	28	53	31

TEMPORADA 2019/2020

SEGUNDA DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Aarhus	6	21	2	54
2	Helsingør	6	9	4	54
3	Middelfart	6	15	10	43
4	Brabrand	6	7	10	39
5	Thisted	6	8	9	38
6	Jammerbugt	6	11	3	37
7	Akademisk	6	13	12	36
8	Hellerup IK	6	9	9	35
9	Vanløse	6	6	11	34
10	Brønshøj	6	6	20	31
11	Frem 1886	6	9	17	29
12	Avarta	6	7	14	25

TEMPORADA 2018/2019

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos
1	Silkeborg	33	60	41	61
2	Viborg FF	33	61	37	60
3	Lyngby BK	33	51	47	52
4	Næstved	33	43	40	50
5	Fremad	33	42	45	50
6	Fredericia	33	51	47	47
7	HB Køge	33	52	47	45
8	Nykøbing	33	44	47	45
9	Roskilde	33	57	66	35
10	Hvidovre IF	33	39	49	35
11	Helsingør	33	35	43	31
12	Thisted	33	35	61	30

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

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos
1	Hobro	33	54	34	58
2	Vendsyssel	33	51	39	55
3	Helsingør	33	43	31	53
4	Roskilde	33	45	42	53
5	Skive	33	41	51	49
6	Nykøbing	33	50	51	46
7	HB Køge	33	32	28	44
8	Fredericia	33	36	43	43
9	Vejle BK	33	49	46	41
10	Fremad	33	42	45	41
11	Næstved	33	45	51	35
12	Akademisk	33	34	61	24

TEMPORADA 2015/2016

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos
1	Lyngby BK	33	59	37	64
2	Silkeborg	33	59	29	63
3	AC Horsens	33	52	34	60
4	Vendsyssel	33	41	33	56
5	Vejle BK	33	55	47	50
6	Fredericia	33	45	45	47
7	Helsingør	33	40	42	47
8	HB Køge	33	34	35	45
9	Roskilde	33	51	58	39
10	Næstved	33	38	47	37
11	Skive	33	37	50	31
12	Vestsjællan	33	19	73	13

TEMPORADA 2014/2015

SEGUNDA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Helsingør	30	59	22	71
2	Frem 1886	30	58	28	61
3	Hvidovre IF	30	67	38	57
4	Fremad	30	55	35	56
5	Nykøbing	30	69	34	55
6	HIK	30	61	36	48
7	B93	30	36	35	43
8	Avarta	30	57	48	42
9	Holbæk	30	41	44	41
10	B 1908	30	42	36	37
11	Rishøj	30	31	40	36
12	Avedøre	30	33	46	36
13	GVI	30	28	57	26
14	Søllerød	30	30	62	21
15	Herlev	30	29	78	14
16	Svebølle	30	20	77	10

TEMPORADA 2013/2014

SEGUNDA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Roskilde	30	88	22	80
2	Næstved	29	67	33	58
3	Fremad	30	76	55	51
4	B 1908	29	45	34	50
5	Helsingør	30	55	38	47
6	Nordvest	30	66	58	45
7	Nykøbing	30	55	60	40
8	Frem 1886	30	50	46	40
9	Søllerød	29	38	41	38
10	B93	30	42	43	36
11	GVI	29	40	60	35
12	Svebølle	30	32	46	32
13	Avarta	30	50	67	31
14	Skjold	30	41	70	30
15	Vanløse	30	34	67	29
16	SC Egedal	30	31	70	20

TEMPORADA 2012/2013

SEGUNDA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hvidovre IF	30	84	31	69
2	Helsingør	30	79	38	64
3	Rishøj	30	50	29	60
4	Næstved	30	64	32	59
5	HIK	30	58	45	51
6	B 1908	30	46	41	51
7	Frem 1886	30	45	40	48
8	Roskilde	30	52	41	46
9	Nordvest	30	51	49	44
10	Nykøbing	30	48	59	36
11	Avarta	30	39	47	33
12	Svebølle	30	37	61	31
13	Skjold	30	44	65	29
14	Fremad	30	39	59	23
15	Herlev	30	27	67	21
16	NB Bornholm	30	14	73	6

TEMPORADA 2010/2011

SEGUNDA DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nordvest	30	59	29	65
2	Helsingør	30	63	41	57
3	Hellerup IK	30	43	24	54
4	Nykøbing	30	56	25	53
5	Søllerød	30	58	47	50
6	B93	30	57	44	45
7	Avarta	30	51	44	42
8	Vanløse	30	58	52	42
9	Herlev	30	44	51	41
10	Stenløse	30	38	44	37
11	BGA	30	40	45	35
12	Skjold	30	36	43	33
13	Frederikssun	30	43	66	32
14	Allerød	30	32	61	22
15	Greve IF	30	32	65	21
16	Ballerup-Sko	30	30	59	20

TEMPORADA 2009/2010

SERIES DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Helsingør	26	94	25	69
2	Frederikssun	26	52	30	45
3	Lyngby	26	55	35	43
4	Ballerup-Sko	26	32	25	41
5	Frederiksber	26	39	54	36
6	NB Bornholm	26	42	37	35
7	GVI	26	33	37	35
8	Værløse	26	45	49	33
9	B 1903	26	27	40	33
10	AB Tårnby	26	46	62	32
11	B 1921	26	36	50	31
12	Frem 1886	26	39	41	28
13	Herfølge	26	40	57	24
14	Døllefjelde	26	22	60	19

Competiciones que juega

Grupo 1

Primera Dinamarca Grupo 3

Pos	Equipos		Pts
1		Hillerød	36
2		AC Horsens	35
3		B93	32
4		HB Køge	26
5		Næstved	21
6		FC Helsingør	16

	Descenso : Næstved, FC Helsingør

RIVALES EN Copa Danesa

RIVALES EN Primera Dinamarc.

USO DE MEMORIA

6,269,096 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1471
Total Execution Time	0.1483

CADENA URL

/historico/Fc-Helsingor

GET DATOS

$_GET['/historico/Fc-Helsingor']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0034	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fc-Helsingor' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0020	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9809 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9809 AND type_rel = 2
0.0031	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 = '9809' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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.0026	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 = 72646 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 75694 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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.0020	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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 75694 AND teamId = 9809
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 9809
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9809
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 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 = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	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.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9809' and rp.type = 4
0.0022	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.0040	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.0034	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.0023	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.0033	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.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 = 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.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* `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 = 6 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 = 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.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* `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.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* `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.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* `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 = 67134 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 = 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.0020	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.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* `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.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 = 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.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 = 43923 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* `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 = 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.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* `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 = 15719 AND t.round = 33 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* `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.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 = 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.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* `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.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* `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.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* `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
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 75694 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

FC Helsingør

FC Helsingør

Selecciona un equipo

Competiciones que juega

Primera Dinamarca Grupo 3

RIVALES EN Copa Danesa

RIVALES EN Primera Dinamarc.