Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Odense Kammeraternes SK

Temporada 2023/2024

TEMPORADA 2023/2024

SERIES DINAMARCA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Odder	22	45	16	57
2	Horsens	22	64	27	51
3	Marienlyst	22	56	23	46
4	Viby	22	60	31	43
5	Vorup	22	49	36	40
6	Odense	22	37	28	37
7	Nörresundby	22	46	42	32
8	Kjellerup	22	30	41	29
9	Aarhus	22	30	39	27
10	Boldklubben	22	29	35	25

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 3
Equipo		PJ	GF	GC	Puntos
1	SfB-Oure	27	74	33	64
2	Odense	27	59	46	48
3	Marienlyst	27	50	43	43
4	Aarhus	27	51	45	41
5	B 1913	27	40	38	39
6	Boldklubben	27	42	50	34
7	Tarup-Paarup	27	42	43	32
8	Hedensted	27	34	37	32
9	Varde Elite	27	23	45	22
10	Sydvest	27	34	69	15

TEMPORADA 2020/2021

SERIES DINAMARCA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	IF Lyseng	8	20	7	17
2	Young Boys	8	13	9	16
3	Marienlyst	8	17	15	15
4	Vejgaard B	8	19	9	14
5	Hedensted	8	9	13	12
6	Odder	8	12	15	7
7	VRI	8	9	20	6
8	Odense	8	7	18	4

TEMPORADA 2019/2020

SERIES DINAMARCA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	SfB-Oure	14	34	12	33
2	Otterup	14	41	18	30
3	Varde Elite	14	36	27	23
4	Herning	14	28	30	21
5	Tarup-Paarup	14	17	19	20
6	Marienlyst	14	18	19	19
7	Hedensted	14	20	26	14
8	Odder	14	29	34	13
9	Odense	14	15	35	11
10	Kolding	14	15	33	7

TEMPORADA 2012/2013

SERIES DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SC Egedal	25	79	23	58
2	GVI	25	56	31	56
3	Ringsted	25	59	28	55
4	Næsby	25	62	42	43
5	Aarup	25	46	37	43
6	Hedensted	25	52	40	42
7	Marstal/Rise	25	47	36	42
8	Greve IF	25	49	45	36
9	Slagelse	25	40	50	34
10	Frem	25	50	47	32
11	Næstved II	25	34	41	30
12	Døllefjelde	25	35	83	14
13	Nakskov	25	30	79	9
14	Odense	25	27	84	6

TEMPORADA 2011/2012

SERIES DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Middelfart	26	89	33	59
2	Sydvest	26	75	28	58
3	Næstved II	26	62	40	51
4	Ringsted	26	60	35	48
5	Kolding IF	26	62	41	43
6	Næsby	26	62	55	43
7	Frem	26	44	38	39
8	Odense	26	47	48	33
9	Døllefjelde	26	60	71	33
10	Herlufsholm	26	48	56	32
11	Haderslev	26	48	63	32
12	Sønderborg	26	38	67	27
13	Fjordager	26	28	77	12
14	Korup	26	21	92	7

TEMPORADA 2010/2011

SERIES DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Marienlyst	26	84	38	62
2	Aarup	26	75	47	54
3	Frem	26	62	47	50
4	Sydvest	26	62	37	49
5	Næstved II	26	74	44	46
6	Odense	26	46	39	46
7	Haderslev	26	71	57	41
8	Ringsted	26	59	50	34
9	Næsby	26	52	58	32
10	Kolding IF	26	39	59	25
11	Fjordager	26	40	55	24
12	Tarup-Paarup	26	37	72	21
13	B 1921	26	35	73	15
14	B 1913	26	23	83	10

TEMPORADA 2009/2010

SERIES DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Rishøj	25	71	36	51
2	Svebølle	25	67	38	51
3	Middelfart	25	52	32	51
4	Herlev	25	55	32	50
5	Næstved II	25	52	37	47
6	Avedøre	25	51	39	42
7	Skjold	25	56	41	39
8	Marienlyst	25	56	51	37
9	Fjordager	25	37	52	30
10	Kolding IF	25	31	38	28
11	Odense	25	22	54	23
12	B 1913	25	26	52	22
13	Dalum	25	22	61	13
14	Boldklubben	25	18	53	10

TEMPORADA 2008/2009

SERIES DINAMARCA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Otterup	26	82	37	61
2	Nordvest	26	78	34	57
3	Næstved II	26	71	36	51
4	Middelfart	26	67	49	45
5	B 1921	26	59	41	45
6	Svebølle	26	57	53	40
7	Dalum	26	53	43	39
8	Herfølge	26	59	52	38
9	Boldklubben	26	58	57	38
10	B 1913	25	34	50	31
11	Odense	26	44	59	29
12	Frem	25	54	59	25
13	Nakskov	26	27	95	8
14	Køge BK II	26	4	82	3

Competiciones que juega

Grupo 3

Series Dinamarca Grupo 6

Pos	Equipos		Pts
1		Odder	57
2		AC Horsens II	51
3		Marienlyst	46
4		Viby	43
5		Vorup	40
6		Odense Kammeraternes SK	37
7		Nörresundby FB	32
8		Kjellerup	29
9		Aarhus Fremad II	27
10		Boldklubben 1909	25

	Ascenso : Odder
	Playoff Descenso : AC Horsens II

RIVALES EN Copa Danesa

RIVALES EN Series Dinamarca

USO DE MEMORIA

6,042,072 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5569
Total Execution Time	0.5581

CADENA URL

/historico/Oks

GET DATOS

$_GET['/historico/Oks']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0115	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 = 'Oks' 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.0105	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=30808 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=30808 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=30808 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=30808 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=30808 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0214	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.0112	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 = 72497
0.0112	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 = 72646
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30808 AND type_rel = 2
0.0106	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=340 AND type_rel = 3
0.0110	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 = '30808' ORDER BY l.year DESC,cat.coefficient DESC
0.0110	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 = '30808' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0109	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 = '30808' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0110	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.0106	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 = 72497 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110	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=30808 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106	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.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 75827 AND teamId = 30808
0.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 72646 AND teamId = 30808
0.0108	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30808
0.0110	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.0106	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 = '30808' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30808' and rp.type = 4
0.0108	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 = '30808' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0107	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 = 30808 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.0106	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 = 30808 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0107	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 = 30808 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109	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 = 30808 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0108	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 = 72497 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.0108	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.0108	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 = 68398 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.0114	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.0108	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 = 63285 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.0108	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 = 58347 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.0108	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 = 62700 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108	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 = 50403 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.0108	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 = 24316 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 24323 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 24327 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 24331 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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* `tables2009` 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 = 24336 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Odense Kammeraternes SK

Odense Kammeraternes SK

Selecciona un equipo

Competiciones que juega

Series Dinamarca Grupo 6

RIVALES EN Copa Danesa

RIVALES EN Series Dinamarca