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

Kjellerup

Temporada 2023/2024

TEMPORADA 2023/2024

SERIES DINAMARCA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Odder	18	36	14	45
2	Horsens	18	50	21	41
3	Marienlyst	18	46	16	39
4	Vorup	18	42	27	37
5	Viby	18	51	24	37
6	Odense	18	30	24	30
7	Kjellerup	18	27	28	28
8	Nörresundby	18	39	36	27
9	Aarhus	18	27	27	24
10	Boldklubben	18	26	29	22

TEMPORADA 2022/2023

SERIES DINAMARCA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Greve IF	32	49	38	56
2	Karlslunde	32	55	44	54
3	Tårnby FF	32	50	40	47
4	B 1908	32	48	55	43
5	KFUM	32	44	46	40
6	Gorslev	32	39	53	33
7	GVI	32	39	63	27
8	Herstedøste	32	54	86	26
9	Skjold	32	55	42	51
10	Ledøje-Smø	32	60	51	51
11	Allerød	32	58	52	45
12	Vaerebro	32	52	57	41
13	Næstved II	32	60	69	41
14	Herlev	32	49	58	37
15	Slagelse	32	49	65	36
16	KFUM	32	34	64	29
17	Odense	32	68	41	62
18	Tarup-Paarup	32	68	40	56
19	Hedensted	32	59	41	53
20	Varde Elite	31	48	49	43
21	Boldklubben	32	42	50	36
22	B 1913	32	42	58	32
23	Brabrand II	32	40	66	29
24	Otterup	31	32	93	14
25	Aarhus	32	81	29	65
26	Aalborg	32	60	47	55
27	Viby	32	71	44	55
28	Nörresundby	32	47	62	34
29	Kjellerup	32	47	101	33
30	VRI	32	42	59	30
31	ASA Aarhus	32	50	71	25
32	Djursland	32	45	84	22

TEMPORADA 2021/2022

SERIES DINAMARCA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Holstebro	26	45	31	56
2	Vejgaard B	27	63	41	53
3	Ringkøbing	26	50	37	49
4	Odder	27	64	44	47
5	Aalborg	27	51	45	40
6	Kjellerup	26	44	50	35
7	ASA Aarhus	26	36	54	28
8	VRI	27	32	48	24
9	Nörresundby	27	39	52	23
10	Fuglebakken	27	32	54	22

TEMPORADA 2020/2021

SERIES DINAMARCA GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Viby	7	14	6	14
2	Tarup-Paarup	7	11	8	13
3	Kjellerup	6	12	6	12
4	Nörresundby	7	11	10	12
5	Ringkøbing	7	12	10	11
6	Aarhus	6	10	4	10
7	Varde Elite	6	9	6	9
8	B 1913	6	14	13	9
9	Skjold Sæby	7	8	15	9
10	Djursland	7	11	14	7
11	Kolding	6	7	11	7
12	Horsens	7	13	17	6
13	Tjørring	6	8	14	6
14	Herning	7	11	17	4

TEMPORADA 2019/2020

SERIES DINAMARCA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Holstebro	14	32	20	29
2	Young Boys	14	36	31	28
3	IF Lyseng	14	35	26	26
4	Aarhus	14	32	16	24
5	Kjellerup	14	39	22	23
6	Djursland	14	20	26	18
7	Skjold Sæby	14	30	37	16
8	Nörresundby	14	21	34	12
9	Viby	14	24	36	10
10	VRI	14	14	35	10

TEMPORADA 2018/2019

SEGUNDA DINAMARCA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Frem 1886	11	26	16	55
2	Hillerød	11	18	14	49
3	Avarta	11	25	15	45
4	Slagelse	11	15	13	44
5	Vejgaard B	11	17	13	43
6	Dalum	11	21	20	37
7	Sydvest	11	19	17	36
8	Skovshoved	11	16	15	36
9	Odder	11	20	18	35
10	Tarup-Paarup	11	16	14	29
11	Kjellerup	11	14	31	19
12	Marienlyst	11	7	28	16

TEMPORADA 2017/2018

SEGUNDA DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Jammerbugt	14	27	16	29
2	Sydvest	14	30	23	25
3	Kjellerup	14	21	15	24
4	Ringkøbing	14	24	23	21
5	Aarhus	14	15	17	18
6	VSK Aarhus	14	23	27	14
7	IF Lyseng	14	16	24	13
8	Odder	14	21	32	13

TEMPORADA 2016/2017

SEGUNDA DINAMARCA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Thisted	16	38	9	52
2	Brabrand	16	32	17	41
3	Kolding IF	16	30	17	40
4	Avarta	16	32	20	37
5	B93	16	25	22	35
6	Kjellerup	16	32	27	29
7	Brønshøj	16	21	29	27
8	Marienlyst	16	22	30	26
9	Aarhus	16	18	21	24
10	Hvidovre IF	16	17	27	22
11	Dalum	16	12	32	18
12	Greve IF	16	15	43	16

TEMPORADA 2015/2016

SERIES DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kjellerup	26	68	34	60
2	Vejgaard B	26	39	28	48
3	Skanderborg	26	43	29	43
4	Randers	26	50	35	41
5	Aalborg	26	53	50	41
6	IF Lyseng	26	45	34	40
7	Ringkøbing	26	37	32	38
8	Lystrup	26	39	43	38
9	Holstrevo	26	37	36	37
10	Aarhus	26	40	51	33
11	Nörresundby	26	46	56	28
12	Viby	26	40	48	27
13	Aalborg	26	30	60	18
14	Aabyhøj IF	26	28	59	15

TEMPORADA 2014/2015

SEGUNDA DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Næstved	30	66	30	67
2	Marienlyst	30	73	39	58
3	Jammerbugt	30	58	42	54
4	Thisted	30	61	49	52
5	VSK Aarhus	30	50	48	51
6	Kolding IF	30	66	46	48
7	Næsby BK	30	62	49	44
8	Svendborg	30	45	40	39
9	Odder	30	49	45	39
10	Brabrand	30	44	47	39
11	Middelfart	30	50	56	39
12	Ringkøbing	30	41	51	39
13	Sydvest	30	45	62	35
14	Varde Elite	30	36	63	27
15	Kjellerup	30	47	74	20
16	Kolding	30	42	94	20

TEMPORADA 2013/2014

SERIES DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kjellerup	26	56	33	51
2	Varde	26	56	29	50
3	Viby	26	56	33	46
4	IF Lyseng	26	55	40	44
5	Lindholm	26	42	36	39
6	Hjørring	26	64	59	38
7	VRI	26	42	49	33
8	Aalborg	26	45	55	32
9	Randers	26	54	55	31
10	Hobro II	26	36	45	29
11	Aarhus	26	37	57	28
12	Hedensted	26	38	47	26
13	Aabyhøj IF	26	35	68	24
14	Vejgaard	26	34	44	22

TEMPORADA 2012/2013

SEGUNDA DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Marienlyst	30	81	45	68
2	Aarhus	30	63	17	61
3	Brabrand	30	47	36	52
4	Jammerbugt	30	53	42	48
5	Svendborg	30	54	45	48
6	Næsby BK	30	60	49	47
7	Middelfart	30	45	38	41
8	Thisted	30	51	49	41
9	Skanderborg	30	58	60	39
10	VSK Aarhus	30	45	51	37
11	Søllerød	30	49	58	36
12	Sydvest	30	44	59	33
13	Ringkøbing	30	47	61	31
14	Kjellerup	30	39	60	30
15	Otterup	30	47	73	29
16	Varde	30	33	73	17

TEMPORADA 2011/2012

SEGUNDA DINAMARCA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fyn	30	71	21	72
2	Næsby BK	30	77	29	70
3	Varde	30	42	27	55
4	Thisted	29	62	39	50
5	Aarhus	30	59	43	46
6	Marienlyst	30	57	55	45
7	Svendborg	30	50	39	43
8	VSK Aarhus	30	44	50	41
9	Nykøbing	30	47	58	38
10	Kjellerup	30	39	43	36
11	Otterup	30	42	64	33
12	Brabrand	30	36	40	32
13	Aarup	30	38	66	29
14	Lindholm	30	32	62	28
15	Skjold	29	38	58	21
16	Viby	30	27	67	17

TEMPORADA 2010/2011

SERIES DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Odder	25	53	30	49
2	Viby	25	53	30	48
3	Kjellerup	25	46	22	47
4	Brabrand II	25	54	39	41
5	Løgstør	25	46	37	40
6	Randers	25	54	35	39
7	Aalborg	25	44	39	36
8	Ringkøbing	25	44	45	36
9	Aarhus	25	34	33	33
10	Frederikshav	25	47	44	31
11	Herning	25	40	51	25
12	Aalborg	25	32	59	22
13	Vorup	25	30	76	16
14	Aalborg KFUM	25	21	58	15

Competiciones que juega

Grupo 4

Series Dinamarca Grupo 6

Pos	Equipos		Pts
1		Odder	45
2		AC Horsens II	41
3		Marienlyst	39
4		Vorup	37
5		Viby	37
6		Odense Kammeraternes SK	30
7		Kjellerup	28
8		Nörresundby FB	27
9		Aarhus Fremad II	24
10		Boldklubben 1909	22

	Ascenso : Odder
	Playoff Descenso : AC Horsens II

RIVALES EN Copa Danesa

RIVALES EN Series Dinamarca

USO DE MEMORIA

6,564,488 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1481
Total Execution Time	0.1493

CADENA URL

/historico/Kjellerup

GET DATOS

$_GET['/historico/Kjellerup']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0030	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 = 'Kjellerup' 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.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=7424 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=7424 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=7424 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=7424 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=7424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 75827
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 = 72498
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7424 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340 AND type_rel = 3
0.0027	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 = '7424' 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 = '7424' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023	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.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 = 75827 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=7424 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 (75827,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.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 75827 AND teamId = 7424
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 7424
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7424
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 = 75827 AND t.round = 4 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 75827 WHERE rp.league_id = 75827 AND rp.teamId = 7424 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.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 = 75827 WHERE rp.league_id = 75827 AND rp.teamId = 7424 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 = 75827 WHERE rp.league_id = 75827 AND rp.teamId = 7424 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 7424 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72498 AND t.round = 18 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 = 75827 AND t.round = 4 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 = 68399 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044	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 = 70733 AND t.round = 14 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 = 63286 AND t.round = 27 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 = 58346 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 = 62699 AND t.round = 7 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 = 50404 AND t.round = 14 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 = 44272 AND t.round = 22 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* `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 = 49554 AND t.round = 11 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 = 43168 AND t.round = 16 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 = 38876 AND t.round = 14 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 = 33545 AND t.round = 14 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* `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 = 38476 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 15861 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 4160 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* `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 = 2774 AND t.round = 26 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 = 2021 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 1733 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* `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 = 24328 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 = 75827 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

Kjellerup

Kjellerup

Selecciona un equipo

Competiciones que juega

Series Dinamarca Grupo 6

RIVALES EN Copa Danesa

RIVALES EN Series Dinamarca