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

ODIN '59

Temporada 2023/2024

TEMPORADA 2023/2024

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RKAV	31	83	48	60
2	IJsselmeervo	31	67	39	57
3	Sparta	31	77	56	56
4	Genemuiden	31	64	36	55
5	Hercules	31	55	41	51
6	DOVO	31	57	39	49
7	Harkemase	31	58	45	48
8	HSC 21	31	54	47	48
9	Rijnvogels	31	53	56	44
10	Eemdijk	31	49	56	42
11	Urk	31	52	64	42
12	DVS'33	31	48	39	41
13	VVSB	31	56	62	41
14	RKVV DEM	31	43	53	40
15	Staphorst	31	50	62	37
16	Hoogeveen	31	42	78	33
17	Kampong	31	41	60	22
18	ODIN '59	31	27	95	14

TEMPORADA 2022/2023

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kloetinge	30	61	38	62
2	Capelle	30	56	38	57
3	Smitshoek	30	57	41	57
4	GOES	30	65	41	54
5	Alphense	30	65	50	51
6	Nieuwenhoorn	30	58	56	51
7	Poortugaal	30	55	42	49
8	ODIN '59	30	73	58	44
9	Gravenzande	30	62	52	43
10	Zwaluwen	30	33	36	36
11	Achilles	30	35	51	36
12	Feyenoord	30	37	48	34
13	Spijkenisse	30	51	39	32
14	WNC	30	38	63	31
15	Jodan Boys	30	38	61	27
16	De Dijk	30	18	88	5

TEMPORADA 2021/2022

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lisse	34	70	38	70
2	Sparta	34	65	38	64
3	Sportlust	34	63	40	58
4	DVS'33	34	61	41	58
5	Hoek	34	53	49	55
6	ACV Assen	34	50	42	51
7	Excelsior	34	53	47	51
8	Barendrecht	34	72	57	50
9	SteDoCo	34	49	48	45
10	Staphorst	34	54	56	45
11	Ter Leede	34	49	67	44
12	Harkemase	34	63	62	42
13	DOVO	34	43	57	38
14	VVSB	34	50	66	38
15	ODIN '59	34	52	68	37
16	VVOG	34	61	82	37
17	Ajax	34	38	54	36
18	GOES	34	44	78	28

TEMPORADA 2020/2021

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SteDoCo	6	13	5	13
2	Lisse	5	11	7	10
3	Sparta	5	9	5	10
4	Excelsior	5	8	5	10
5	VVSB	5	10	7	9
6	Sportlust	5	6	5	9
7	Hoek	6	11	9	8
8	Barendrecht	5	7	8	8
9	DOVO	5	16	8	7
10	Harkemase	3	5	2	7
11	ODIN '59	4	6	6	6
12	Staphorst	6	12	14	6
13	Ajax	5	11	21	6
14	DVS'33	5	9	10	4
15	VVOG	4	1	3	4
16	Ter Leede	5	6	9	4
17	ACV Assen	4	1	8	2
18	GOES	5	2	12	0

TEMPORADA 2019/2020

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sparta	22	58	27	52
2	ODIN '59	22	63	30	47
3	Harkemase	22	43	34	42
4	DVS'33	23	39	30	42
5	Lisse	23	44	33	38
6	Hoek	23	54	42	34
7	Barendrecht	23	37	38	34
8	Ajax	22	31	38	31
9	Excelsior	23	50	40	31
10	Jong Almere	23	54	48	31
11	GOES	23	33	44	31
12	VVSB	22	47	48	28
13	SteDoCo	22	41	42	28
14	Ter Leede	23	36	53	27
15	DOVO	23	45	55	22
16	ONS Sneek	23	32	72	12
17	VVOG	22	26	59	11

TEMPORADA 2018/2019

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Noordwijk	34	94	41	80
2	Quick Boys	34	84	41	72
3	DVS'33	34	102	47	68
4	Hoek	34	82	55	64
5	Groningen	34	66	39	58
6	Harkemase	34	68	59	57
7	ASWH	34	75	54	55
8	SteDoCo	34	65	56	55
9	ODIN '59	34	71	66	54
10	Lisse	34	62	64	51
11	DOVO	34	76	66	48
12	Ajax	34	52	61	41
13	ONS Sneek	34	57	58	39
14	VVOG	34	41	72	35
15	Eemdijk	34	51	87	29
16	Noordwijk	34	50	105	26
17	Achilles 29	34	44	107	20
18	De Dijk	34	49	111	19

TEMPORADA 2017/2018

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spakenburg	34	68	32	71
2	Scheveningen	34	68	44	65
3	DVS'33	34	74	37	62
4	Jong Almere	34	73	54	61
5	Groningen	34	72	34	58
6	Quick Boys	34	63	45	58
7	Jong	34	60	48	56
8	ODIN '59	34	56	51	49
9	DOVO	34	54	52	49
10	Twente	34	52	45	48
11	ASWH	34	52	51	47
12	Harkemase	34	55	56	46
13	VVOG	34	36	51	42
14	ONS Sneek	34	62	88	37
15	Capelle	34	44	57	35
16	Spijkenisse	34	56	83	33
17	ACV Assen	34	57	83	32
18	Magreb 90	34	31	122	10

TEMPORADA 2016/2017

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	IJsselmeervo	34	74	36	70
2	Lisse	34	55	38	65
3	Rijnsburgse	34	84	62	61
4	ASWH	34	64	53	58
5	Scheveningen	34	54	48	56
6	Jong	34	60	56	56
7	DVS'33	34	54	49	48
8	Harkemase	34	55	60	46
9	Groningen	34	48	46	45
10	VVOG	34	49	55	44
11	Quick Boys	34	47	54	43
12	Capelle	34	42	52	41
13	ONS Sneek	34	51	60	40
14	Jong Almere	34	63	61	38
15	ODIN '59	34	58	63	36
16	SteDoCo	34	46	69	35
17	Huizen	34	38	57	33
18	Rijnvogels	34	55	78	33

TEMPORADA 2015/2016

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ODIN '59	24	57	32	51
2	Huizen	24	54	26	48
3	DOVO	24	47	29	44
4	Achilles	24	46	30	43
5	Eemdijk	24	34	28	40
6	Ajax	24	42	38	35
7	Sparta	24	38	38	33
8	SDC Putten	24	35	35	32
9	Swift	24	31	44	30
10	NSC	24	31	46	28
11	Bennekom	24	28	43	24
12	SVL	24	40	63	20
13	LRC	24	20	51	14

TEMPORADA 2014/2015

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	SteDoCo	26	50	30	51
2	ODIN '59	26	45	38	46
3	DOVO	26	39	30	40
4	Achilles	26	43	39	40
5	VVA .71	26	44	33	39
6	Jodan Boys	26	46	35	35
7	SDC Putten	26	38	39	34
8	NSC	26	44	51	34
9	Breukelen	26	47	60	32
10	Bennekom	26	32	36	31
11	Huizen	26	37	32	30
12	Door Fusie.	26	32	46	29
13	Montfoort	26	30	40	24
14	RKAV	26	46	64	24

TEMPORADA 2013/2014

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sparta	26	61	31	60
2	Ajax	26	59	28	53
3	Quick Boys	26	51	37	50
4	DVS'33	26	49	38	43
5	Huizen	26	52	44	37
6	Bennekom	26	41	38	35
7	ODIN '59	26	41	43	34
8	SDC Putten	26	46	51	32
9	RKAV	26	43	56	32
10	VVA .71	26	38	49	30
11	DOVO	26	36	45	29
12	Montfoort	26	38	55	26
13	Sportlust	26	26	38	23
14	Barneveld	26	23	51	19

TEMPORADA 2012/2013

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ter Leede	26	56	20	54
2	DOVO	26	39	29	46
3	Ajax	26	53	27	42
4	ODIN '59	26	43	32	40
5	VVA .71	26	42	43	40
6	Montfoort	26	37	43	40
7	Huizen	26	57	42	38
8	Quick Boys	26	54	40	37
9	Bennekom	26	43	41	37
10	Sportlust	26	32	44	34
11	Apeldoorn	26	39	47	29
12	Alphense	26	43	65	26
13	RKAV	26	35	58	26
14	DTS Ede	26	27	69	13

TEMPORADA 2011/2012

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Jodan Boys	24	41	23	49
2	Ter Leede	24	46	30	42
3	Quick Boys	24	41	34	41
4	Huizen	23	37	34	39
5	Sparta	24	39	34	34
6	Bennekom	24	35	33	34
7	RKAV	24	39	49	34
8	DOVO	24	35	38	33
9	Sportlust	24	44	51	33
10	Voorschoten	24	49	41	32
11	ODIN '59	23	35	34	31
12	Zwaluwen	24	32	45	24
13	SDC Putten	24	30	57	18

TEMPORADA 2010/2011

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Quick Boys	26	64	25	58
2	Noordwijk	26	57	24	58
3	Young Boys	26	58	34	51
4	Scheveningen	26	47	28	46
5	Excelsior	26	51	39	45
6	ODIN '59	26	40	29	44
7	RKAV	26	52	54	34
8	Voorschoten	26	32	49	32
9	Ter Leede	26	28	51	30
10	Jodan Boys	26	35	45	29
11	Zwaluwen	26	36	45	27
12	Huizen	26	38	54	23
13	Vitesse	26	28	53	18
14	Swift	26	28	64	17

TEMPORADA 2009/2010

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	IJsselmeervo	26	64	18	60
2	Sparta	26	69	35	58
3	Spakenburg	26	62	36	50
4	Hoek	26	38	29	45
5	Zwaluwen	26	50	49	38
6	GVVV	26	46	43	37
7	SDC Putten	26	43	45	35
8	Kozakken	26	46	47	33
9	ODIN '59	26	46	51	31
10	Jodan Boys	26	40	54	31
11	LRC	26	43	51	30
12	RKAV	26	45	60	26
13	DOVO	26	33	66	20
14	Bennekom	26	32	73	13

TEMPORADA 2008/2009

EERSTE KLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Young Boys	22	52	11	53
2	ODIN '59	21	43	16	51
3	Sportlust	23	62	32	50
4	Rijnvogels	23	54	24	45
5	Zuidvogels	23	42	43	36
6	Huizen	22	40	30	34
7	Beursbengels	21	29	38	24
8	Roda'46	22	28	36	21
9	De Merino.s	22	23	40	21
10	Montfoort	21	24	39	20
11	Gouda	21	25	59	9
12	Voorland	23	23	77	6

Competiciones que juega

Derde Divisie Grupo 1

Pos	Equipos		Pts
1		RKAV Volendam	60
2		IJsselmeervogels	57
3		Sparta Nijkerk	56
4		Genemuiden	55
5		USV Hercules	51
6		DOVO	49
7		Harkemase Boys	48
8		HSC 21	48
9		Rijnvogels	44
10		Eemdijk	42
11		Urk	42
12		DVS'33	41
13		VVSB	41
14		RKVV DEM	40
15		Staphorst	37
16		Hoogeveen	33
17		Kampong	22
18		ODIN '59	14

	Ascenso : RKAV Volendam
	Playoff Descenso : Staphorst, Hoogeveen
	Descenso : Kampong, ODIN '59

RIVALES EN KNVB Beker

RIVALES EN Derde Divisie

USO DE MEMORIA

6,983,336 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1370
Total Execution Time	0.1382

CADENA URL

/historico/Odin-59

GET DATOS

$_GET['/historico/Odin-59']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0027	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 = 'Odin-59' 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=7159 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=7159 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=7159 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=7159 AND type_rel = 2
0.0025	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 = '7159' ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '7159' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022	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 = '7159' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72699 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=7159 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 (72699,72637,71881,70053) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72699 AND teamId = 7159
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 70053 AND teamId = 7159
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7159
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 71881 AND teamId = 7159
0.0027	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 = 72699 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '7159' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7159' and rp.type = 4
0.0021	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 = '7159' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036	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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7159 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.0033	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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7159 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 72699 WHERE rp.league_id = 72699 AND rp.teamId = 7159 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 7159 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72699 AND t.round = 31 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 = 70053 AND t.round = 30 ORDER BY team.conference ASC,t.position 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* `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 = 63259 AND t.round = 34 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 = 57889 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.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 = 50980 AND t.round = 24 ORDER BY team.conference ASC,t.position 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* `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 = 38963 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 33929 AND t.round = 34 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* `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 = 20351 AND t.round = 26 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* `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 = 9387 AND t.round = 26 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* `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 = 9393 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* `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 = 2189 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 1713 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 20374 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* `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 = 20379 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* `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 = 20439 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 72699 ORDER BY nameShow LIMIT 100

ODIN '59

ODIN '59

Selecciona un equipo

Competiciones que juega

Derde Divisie Grupo 1

RIVALES EN KNVB Beker

RIVALES EN Derde Divisie