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

Silkeborg IF

Entrenador: Kent Nielsen

Temporada 2023/2024

TEMPORADA 2023/2024

SUPERLIGA DANESA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Brøndby IF	26	51	25	55
2	Midtjylland	26	49	30	52
3	Kobenhavn	26	51	29	49
4	Nordsjaellan	26	48	26	49
5	AGF Aarhus	26	32	33	38
6	Silkeborg	26	31	38	29

TEMPORADA 2022/2023

SUPERLIGA DANESA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Midtjylland	32	55	39	51
2	Odense BK	32	47	53	46
3	Silkeborg	32	44	49	41
4	Lyngby BK	32	30	49	28
5	AC Horsens	32	33	58	28
6	Aalborg BK	32	34	45	27

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

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

SUPERLIGA DANESA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	AC Horsens	6	11	6	46
2	Randers	6	12	10	45
3	Hobro	6	10	13	30
4	Esbjerg	6	10	14	22
5	Odense BK	6	9	12	43
6	SonderjyskE	6	6	5	38
7	Lyngby BK	6	3	9	34
8	Silkeborg	6	12	4	26

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

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

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

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

PRIMERA DINAMARCA
Equipo		PJ	GF	GC	Puntos
1	Silkeborg	33	67	38	66
2	Hobro	33	58	36	65
3	Lyngby BK	33	58	41	57
4	Brønshøj	33	47	39	53
5	AC Horsens	33	60	48	52
6	HB Køge	33	39	31	49
7	Vejle BK	33	49	38	47
8	Fredericia	33	47	45	43
9	Vendsyssel	33	35	59	38
10	Akademisk	33	42	57	36
11	Hvidovre IF	33	43	63	36
12	Marienlyst	33	28	78	15

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

TEMPORADA 2011/2012

SUPERLIGA DANESA
Equipo		PJ	GF	GC	Puntos
1	Nordsjaellan	33	49	22	68
2	Kobenhavn	33	55	26	66
3	Midtjylland	33	50	40	58
4	AC Horsens	33	53	39	57
5	AGF Aarhus	33	47	40	48
6	SonderjyskE	33	48	51	44
7	Aalborg BK	33	42	48	44
8	Silkeborg	33	51	47	43
9	Brøndby IF	33	35	46	36
10	Odense BK	33	46	50	34
11	Lyngby BK	33	32	60	28
12	Køge BK	33	32	71	19

Competiciones que juega

Grupo 1

Superliga Danesa Grupo 2

Pos	Equipos		Pts
1		Brøndby IF	55
2		Midtjylland	52
3		Kobenhavn	49
4		Nordsjaelland	49
5		AGF Aarhus	38
6		Silkeborg IF	29

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

RIVALES EN Copa Danesa

RIVALES EN Superliga Danesa

USO DE MEMORIA

6,177,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1354
Total Execution Time	0.1366

CADENA URL

/historico/Silkeborg-If

GET DATOS

$_GET['/historico/Silkeborg-If']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

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 = 'Silkeborg-If' 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.0019	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=2339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=2339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=2339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=2339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=2339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=2339 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2339 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2339 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (97060,103926,138715,600008,910998) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '2339' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027	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 = '2339' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=2339 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,75120,72646,71432,68866,67754) 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 = 2339
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 68866 AND teamId = 2339
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 67754 AND teamId = 2339
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 2339
0.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 2339
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 75120 AND teamId = 2339
0.0040	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.0031	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 = 2339 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.0027	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 = 2339 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 = 2339 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 2339 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* `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.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* `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 = 71335 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 = 66997 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* `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.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 = 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 = 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.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* `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.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* `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.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* `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.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* `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.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* `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.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 = 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.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.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 = 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.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* `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 = 2474 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
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* `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 = 1360 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Silkeborg IF

Silkeborg IF

Selecciona un equipo

Competiciones que juega

Superliga Danesa Grupo 2

RIVALES EN Copa Danesa

RIVALES EN Superliga Danesa