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

Fremad Amager

Entrenador: Carit Falch

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Fremad	4	8	4	32
2	Skive	4	6	6	29
3	Hellerup IK	4	3	4	28
4	FA 2000	4	5	5	22
5	Thisted	4	3	4	21
6	Brabrand	4	2	4	20

TEMPORADA 2022/2023

PRIMERA DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Fredericia	32	56	48	45
2	HB Køge	32	50	51	44
3	Hillerød	32	37	51	41
4	Hobro	32	33	42	38
5	Fremad	32	38	60	34
6	Nykøbing	32	43	73	23

TEMPORADA 2021/2022

PRIMERA DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Helsingør	22	52	20	51
2	Lyngby BK	22	45	21	43
3	Hvidovre IF	22	37	22	43
4	AC Horsens	22	37	21	40
5	Fredericia	22	38	36	37
6	Nykøbing	22	35	37	25
7	HB Køge	22	28	32	25
8	Vendsyssel	22	25	31	24
9	Hobro	22	31	38	22
10	Esbjerg	22	24	38	20
11	Fremad	22	24	48	18
12	Jammerbugt	22	19	51	16

TEMPORADA 2020/2021

PRIMERA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hvidovre IF	32	40	47	39
2	Fremad	32	47	41	35
3	Hobro	32	38	51	34
4	Vendsyssel	32	33	51	32
5	Kolding IF	32	31	49	32
6	Skive	32	28	60	28

TEMPORADA 2019/2020

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos

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

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos
1	Vejle BK	33	47	24	65
2	Esbjerg	33	61	36	60
3	Vendsyssel	33	59	42	56
4	Viborg FF	33	58	42	54
5	HB Køge	33	42	31	52
6	Fredericia	33	48	47	42
7	Nykøbing	33	54	59	40
8	Thisted	33	42	53	40
9	Fremad	33	27	42	40
10	Roskilde	33	41	49	38
11	Brabrand	33	34	61	34
12	Skive	33	33	60	18

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

SEGUNDA DINAMARCA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Akademisk	16	40	11	38
2	Nykøbing	16	37	21	31
3	Fremad	16	29	19	30
4	Brønshøj	16	30	24	26
5	Frem 1886	16	19	16	23
6	Aarhus	16	16	24	23
7	Thisted	16	28	27	21
8	Brabrand	16	24	21	20
9	Hvidovre IF	16	21	20	18
10	Marienlyst	16	22	39	17
11	Hellerup IK	16	13	33	15
12	Middelfart	16	12	36	7

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 2011/2012

SEGUNDA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	HIK	30	69	44	71
2	Hvidovre IF	30	79	36	66
3	Herlev	30	56	42	48
4	Rishøj	30	48	42	44
5	Fremad	30	50	47	44
6	Svebølle	30	54	55	43
7	Elite 3	30	49	51	43
8	Søllerød	30	40	41	42
9	Skjold	30	43	45	42
10	Nordvest	30	46	41	41
11	Avarta	30	38	36	38
12	Vanløse	30	41	48	35
13	B93	30	37	44	33
14	SC Egedal	30	47	50	32
15	BGA	30	21	94	5

TEMPORADA 2010/2011

SERIES DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Skjold	26	44	18	53
2	Fremad	26	50	28	51
3	Svebølle	26	45	29	50
4	Avedøre	26	56	36	48
5	FC Oresund	26	52	27	41
6	Frederiksber	26	41	35	39
7	NB Bornholm	26	40	42	39
8	B 1903	26	52	45	37
9	GVI	26	35	36	33
10	AB Tårnby	26	35	40	27
11	Ledoeje-Smoe	26	36	52	27
12	Værløse	26	50	56	25
13	Jaegersborg	26	24	50	20
14	Brøndby	26	12	78	8

TEMPORADA 2007/2008

SEGUNDA DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Roskilde	30	64	29	68
2	Fremad	30	63	34	63
3	Brønshøj	30	61	45	60
4	Brøndby	30	75	38	59
5	Slagelse	30	49	49	49
6	Copenhague	30	54	38	44
7	Skovlunde	30	47	47	43
8	Skjold	29	44	53	40
9	B93	30	48	51	39
10	Greve IF	30	41	57	36
11	BGA	30	45	55	35
12	Stenløse	30	37	50	33
13	Værløse	30	39	55	31
14	Søllerød	29	36	59	30
15	B 1908	30	44	62	25
16	Nordvest	30	39	64	25

Competiciones que juega

Grupo 1

Segunda Dinamarca Grupo 3

Pos	Equipos		Pts
1		Fremad Amager	32
2		Skive	29
3		Hellerup IK	28
4		FA 2000	22
5		Thisted	21
6		Brabrand	20

	Descenso : Thisted, Brabrand

RIVALES EN Copa Danesa

RIVALES EN Segunda Dinamarc.

USO DE MEMORIA

6,313,672 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8314
Total Execution Time	0.8326

CADENA URL

/historico/Fremad-Amager

GET DATOS

$_GET['/historico/Fremad-Amager']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0175	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 = 'Fremad-Amager' 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.0147	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=7449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=7449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=7449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=7449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=7449 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7449 AND type_rel = 2
0.0147	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7449 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0151	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 (104174,577243) ORDER BY n.cover_points DESC, update_date DESC
0.0199	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 = '7449' ORDER BY l.year DESC,cat.coefficient DESC
0.0180	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 = '7449' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0170	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 = '7449' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0154	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 = 75800 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0175	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=7449 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (75800,72646,71432,71292) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 71292 AND teamId = 7449
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 75800 AND teamId = 7449
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 7449
0.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7449
0.0149	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 = 75800 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0149	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 = '7449' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7449' and rp.type = 4
0.0156	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 = '7449' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0184	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 = 75800 WHERE rp.league_id = 75800 AND rp.teamId = 7449 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.0157	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 = 75800 WHERE rp.league_id = 75800 AND rp.teamId = 7449 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0160	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 = 75800 WHERE rp.league_id = 75800 AND rp.teamId = 7449 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0174	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 = 7449 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0166	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 = 72491 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.0160	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.0158	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.0159	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.0153	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.0148	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.0149	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.0146	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 = 50116 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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.0148	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 = 38748 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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.0150	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 = 16251 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 20328 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156	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.0153	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.0154	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 = 1734 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 24326 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2008` 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 = 24411 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 75800 ORDER BY nameShow LIMIT 100

Fremad Amager

Fremad Amager

Selecciona un equipo

Competiciones que juega

Segunda Dinamarca Grupo 3

RIVALES EN Copa Danesa

RIVALES EN Segunda Dinamarc.