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

De Graafschap

Entrenador: Jan Vreman

Temporada 2023/2024

TEMPORADA 2023/2024

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Willem II	36	73	32	75
2	Roda JC	36	67	32	72
3	Groningen	36	68	29	71
4	Dordrecht	36	72	49	67
5	Graafschap	36	58	48	62
6	Haag	35	66	45	59
7	Jong AZ	36	56	57	53
8	NAC Breda	35	58	53	51
9	Maastricht	36	59	58	50
10	Emmen	35	52	58	48
11	Helmond	35	49	51	47
12	Cambuur	36	70	71	46
13	VVV Venlo	36	51	56	45
14	Jong Ajax	36	53	63	40
15	Eindhoven	36	42	54	40
16	Jong PSV	35	56	76	34
17	SC Telstar	36	43	63	34
18	Den Bosch	36	37	64	33
19	TOP Oss	36	30	61	33
20	Jong Utrecht	35	29	69	24

TEMPORADA 2022/2023

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Heracles	38	103	42	85
2	PEC Zwolle	38	99	43	85
3	Almere City	38	58	41	70
4	Willem II	38	68	40	68
5	Maastricht	38	65	65	59
6	NAC Breda	38	64	64	59
7	VVV Venlo	38	56	51	58
8	Eindhoven	38	58	54	58
9	SC Telstar	38	39	52	53
10	Graafschap	38	64	54	52
11	Jong AZ	38	60	58	51
12	Haag	38	51	57	51
13	Jong Ajax	38	69	72	46
14	Jong PSV	38	59	63	45
15	Roda JC	38	49	59	43
16	Helmond	38	39	57	43
17	TOP Oss	38	45	76	37
18	Dordrecht	38	41	68	35
19	Den Bosch	38	46	85	35
20	Jong Utrecht	38	33	65	28

TEMPORADA 2021/2022

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Emmen	38	64	24	83
2	FC Volendam	38	81	53	75
3	Eindhoven	38	69	43	71
4	Haag	38	76	53	67
5	Roda JC	38	77	50	66
6	Excelsior	38	82	57	66
7	Jong Ajax	38	82	63	63
8	NAC Breda	38	60	45	59
9	Graafschap	38	52	43	56
10	VVV Venlo	38	50	64	48
11	Den Bosch	38	42	61	47
12	Jong PSV	38	61	63	44
13	Jong AZ	38	39	50	42
14	Almere City	38	57	69	41
15	TOP Oss	38	48	62	41
16	Maastricht	38	43	75	40
17	Dordrecht	38	53	77	39
18	Jong Utrecht	38	43	67	38
19	SC Telstar	38	47	74	35
20	Helmond	38	39	72	28

TEMPORADA 2020/2021

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Cambuur	38	109	36	92
2	Ahead Eagles	38	62	25	77
3	Graafschap	38	67	47	77
4	Almere City	38	75	48	75
5	NAC Breda	38	75	41	73
6	FC Volendam	38	79	52	66
7	Nijmegen	38	68	45	66
8	Roda JC	38	67	61	57
9	Excelsior	38	65	66	48
10	TOP Oss	38	40	57	47
11	Maastricht	38	50	72	46
12	Helmond	38	51	68	45
13	SC Telstar	38	57	61	41
14	Jong PSV	38	54	65	40
15	Eindhoven	38	50	62	40
16	Jong Ajax	38	55	71	40
17	Jong AZ	38	56	92	38
18	Jong Utrecht	38	53	77	35
19	Den Bosch	38	59	85	32
20	Dordrecht	38	36	97	27

TEMPORADA 2019/2020

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Cambuur	29	68	25	66
2	Graafschap	29	63	28	62
3	FC Volendam	29	57	42	55
4	Jong Ajax	29	72	47	54
5	NAC Breda	29	48	30	50
6	Ahead Eagles	29	49	41	48
7	Excelsior	29	65	55	47
8	Nijmegen	29	51	37	45
9	Almere City	29	44	42	44
10	SC Telstar	29	47	48	44
11	Den Bosch	29	56	49	38
12	Jong Utrecht	29	48	47	38
13	Eindhoven	29	46	59	34
14	Jong AZ	29	45	61	28
15	Maastricht	29	37	53	27
16	TOP Oss	29	28	53	25
17	Roda JC	29	36	52	22
18	Jong PSV	29	34	56	22
19	Dordrecht	29	34	66	20
20	Helmond	29	25	62	17

TEMPORADA 2018/2019

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	119	32	86
2	PSV	34	98	26	83
3	Feyenoord	34	75	41	65
4	AZ Alkmaar	34	64	43	58
5	Vitesse	34	70	51	53
6	Utrecht	34	60	51	53
7	Heracles	34	61	68	48
8	Groningen	34	39	41	45
9	Haag	34	58	63	45
10	Willem II	34	58	72	44
11	Heerenveen	34	64	73	41
12	VVV Venlo	34	47	63	41
13	PEC Zwolle	34	44	57	39
14	Emmen	34	41	72	38
15	Fortuna	34	50	80	34
16	Excelsior	34	46	79	33
17	Graafschap	34	38	75	29
18	NAC Breda	34	29	74	23

TEMPORADA 2017/2018

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Jong Ajax	38	89	54	79
2	Fortuna	38	81	41	78
3	Nijmegen	38	82	46	74
4	Graafschap	38	78	47	65
5	Jong PSV	38	76	54	64
6	SC Telstar	38	66	63	61
7	Emmen	38	58	50	58
8	Cambuur	38	58	53	58
9	Almere City	38	70	76	52
10	Maastricht	38	57	56	50
11	Den Bosch	38	59	55	47
12	Eindhoven	38	61	83	47
13	Dordrecht	38	57	81	47
14	FC Volendam	38	59	67	46
15	TOP Oss	38	53	65	46
16	Jong AZ	38	57	70	46
17	Ahead Eagles	38	48	68	37
18	Waalwijk	38	37	61	37
19	Helmond	38	50	67	36
20	Jong Utrecht	38	37	76	27

TEMPORADA 2016/2017

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	VVV Venlo	38	75	35	80
2	Jong Ajax	38	93	54	76
3	Cambuur	38	78	42	71
4	Jong PSV	38	66	35	69
5	NAC Breda	38	65	50	64
6	FC Volendam	38	63	44	62
7	Maastricht	38	55	45	59
8	Almere City	38	74	66	59
9	Emmen	38	50	40	55
10	Waalwijk	38	62	70	54
11	Eindhoven	38	64	71	53
12	Graafschap	38	70	63	50
13	Helmond	38	51	67	49
14	Den Bosch	38	48	67	45
15	TOP Oss	38	67	95	41
16	SC Telstar	38	46	64	40
17	Fortuna	38	54	67	39
18	Jong Utrecht	38	50	71	37
19	Dordrecht	38	42	72	24
20	Achilles 29	38	37	92	19

TEMPORADA 2015/2016

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	34	88	32	84
2	Ajax	34	81	21	82
3	Feyenoord	34	62	40	63
4	AZ Alkmaar	34	70	53	59
5	Utrecht	34	57	48	53
6	Heracles	34	47	49	51
7	Groningen	34	41	48	50
8	PEC Zwolle	34	56	54	48
9	Vitesse	34	55	38	46
10	Nijmegen	34	37	42	46
11	Haag	34	48	49	43
12	Twente	34	49	64	43
13	Heerenveen	34	46	61	42
14	Roda JC	34	34	55	34
15	Excelsior	34	34	60	30
16	Willem II	34	35	53	29
17	Graafschap	34	39	66	23
18	Cambuur	34	33	79	18

TEMPORADA 2014/2015

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Nijmegen	38	100	32	101
2	Eindhoven	38	70	39	80
3	Roda JC	38	69	58	69
4	Emmen	38	88	57	67
5	FC Volendam	38	83	68	62
6	Graafschap	38	73	49	61
7	VVV Venlo	38	48	43	60
8	Sparta	38	72	46	58
9	TOP Oss	38	73	67	56
10	Almere City	38	64	63	48
11	Maastricht	38	51	70	48
12	Jong Ajax	38	64	67	47
13	Jong Twente	38	49	64	47
14	Jong PSV	38	50	56	46
15	SC Telstar	38	53	68	42
16	Den Bosch	38	46	61	39
17	Helmond	38	52	85	38
18	Achilles 29	38	44	71	33
19	Fortuna	38	30	72	29
20	Waalwijk	38	39	82	29

TEMPORADA 2013/2014

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Willem II	38	78	38	79
2	Dordrecht	38	83	50	73
3	Excelsior	38	70	39	66
4	Den Bosch	38	61	60	62
5	VVV Venlo	38	58	52	61
6	Eindhoven	38	69	60	60
7	Graafschap	38	67	48	58
8	Fortuna	38	59	45	56
9	FC Volendam	38	67	71	56
10	Jong PSV	38	62	57	54
11	Maastricht	38	46	46	53
12	Emmen	38	64	68	51
13	Helmond	38	62	67	51
14	Jong Ajax	38	57	72	50
15	SC Telstar	38	50	79	45
16	Sparta	38	58	51	44
17	Jong Twente	38	47	61	43
18	Almere City	38	49	65	41
19	TOP Oss	38	49	78	31
20	Achilles 29	38	40	89	25

TEMPORADA 2012/2013

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Cambuur	30	59	33	61
2	FC Volendam	30	70	43	60
3	Sparta	30	59	36	55
4	Helmond	30	55	45	55
5	Maastricht	30	56	44	50
6	Ahead Eagles	30	60	46	48
7	Fortuna	30	39	33	46
8	Graafschap	30	57	41	45
9	Dordrecht	30	56	56	40
10	TOP Oss	30	40	57	37
11	Emmen	33	42	60	36
12	Den Bosch	30	38	49	35
13	Almere City	30	41	67	31
14	SC Telstar	30	31	46	29
15	Excelsior	30	39	63	21
16	Eindhoven	30	40	67	21
17	AGOVV	1	6	1	3
18	SC Veendam	2	2	3	1

TEMPORADA 2011/2012

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	93	36	76
2	Feyenoord	34	70	37	70
3	PSV	34	87	47	69
4	AZ Alkmaar	34	64	35	65
5	Heerenveen	34	79	59	64
6	Twente	34	82	46	60
7	Vitesse	34	48	43	53
8	Nijmegen	34	41	45	45
9	Waalwijk	34	40	49	45
10	Roda JC	34	55	70	44
11	Utrecht	34	55	58	43
12	Heracles	34	52	62	40
13	NAC Breda	34	44	55	38
14	Groningen	34	41	61	37
15	Haag	34	38	66	32
16	VVV Venlo	34	43	77	31
17	Graafschap	34	36	74	24
18	Excelsior	34	28	76	19

TEMPORADA 2010/2011

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	Ajax	34	72	30	73
2	Twente	34	65	34	71
3	PSV	34	79	34	69
4	AZ Alkmaar	34	55	44	59
5	Groningen	34	65	52	57
6	Roda JC	34	65	50	55
7	Haag	34	63	55	54
8	Heracles	34	65	56	49
9	Utrecht	34	55	51	47
10	Feyenoord	34	53	54	44
11	Nijmegen	34	57	56	43
12	Heerenveen	34	60	54	41
13	NAC Breda	34	44	60	40
14	Graafschap	34	31	56	38
15	Vitesse	34	42	61	35
16	Excelsior	34	45	66	35
17	VVV Venlo	34	34	76	21
18	Willem II	34	37	98	15

TEMPORADA 2009/2010

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Graafschap	37	89	35	84
2	Cambuur	38	86	49	77
3	Excelsior	37	78	49	68
4	PEC Zwolle	37	61	38	68
5	Ahead Eagles	37	56	35	66
6	AGOVV	37	65	53	60
7	Helmond	37	67	54	57
8	SC Veendam	37	63	49	56
9	Den Bosch	37	67	58	54
10	Maastricht	37	59	67	50
11	Roosendaal	37	49	55	47
12	Dordrecht	37	57	59	46
13	Eindhoven	37	64	83	46
14	Omniworld	37	44	67	43
15	FC Volendam	38	68	82	41
16	Emmen	37	51	83	38
17	Fortuna	37	36	58	33
18	TOP Oss	38	44	80	33
19	SC Telstar	37	47	67	30
20	Haarlem	22	27	57	13

TEMPORADA 2008/2009

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	AZ Alkmaar	34	66	22	80
2	Twente	34	62	31	69
3	Ajax	34	74	41	68
4	PSV	34	71	33	65
5	Heerenveen	34	66	57	60
6	Groningen	34	53	36	56
7	Feyenoord	34	54	46	45
8	NAC Breda	34	44	54	45
9	Utrecht	34	41	44	44
10	Vitesse	34	41	48	43
11	Nijmegen	34	41	40	42
12	Willem II	34	35	58	37
13	Sparta	34	46	66	35
14	Haag	34	41	58	32
15	Heracles	34	35	53	32
16	Roda JC	34	38	58	30
17	Graafschap	34	24	58	30
18	FC Volendam	34	38	67	29

TEMPORADA 2007/2008

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	34	65	24	72
2	Ajax	34	94	45	69
3	NAC Breda	34	48	40	63
4	Twente	34	52	32	62
5	Heerenveen	34	88	48	60
6	Feyenoord	34	64	41	60
7	Groningen	34	53	54	51
8	Nijmegen	34	49	50	49
9	Roda JC	34	55	55	47
10	Utrecht	34	59	55	46
11	AZ Alkmaar	34	48	53	43
12	Vitesse	34	46	55	43
13	Sparta	34	52	76	34
14	Heracles	34	34	64	32
15	Willem II	34	40	49	31
16	Graafschap	34	33	64	30
17	VVV Venlo	34	44	76	29
18	Excelsior	34	32	75	27

TEMPORADA 2006/2007

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Graafschap	38	88	41	83
2	VVV Venlo	38	64	44	71
3	Roosendaal	38	82	44	70
4	FC Volendam	38	65	40	68
5	Den Bosch	38	65	43	68
6	Dordrecht	38	76	49	67
7	Ahead Eagles	38	56	51	57
8	SC Veendam	38	57	50	55
9	PEC Zwolle	38	66	51	53
10	SC Telstar	38	61	61	48
11	Emmen	38	59	65	48
12	Cambuur	38	44	57	47
13	Maastricht	38	49	51	46
14	Haarlem	38	43	57	43
15	Fortuna	38	38	57	43
16	Omniworld	38	55	82	41
17	TOP Oss	38	59	78	40
18	Helmond	38	40	76	36
19	Eindhoven	38	47	80	33
20	AGOVV	38	42	79	29

TEMPORADA 2005/2006

EERSTE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Excelsior	38	68	25	75
2	VVV Venlo	38	53	34	68
3	FC Volendam	38	59	43	66
4	Helmond	38	62	55	64
5	Graafschap	38	63	51	62
6	Emmen	38	68	56	60
7	Den Bosch	38	62	51	59
8	Haarlem	38	57	51	59
9	Dordrecht	38	61	45	56
10	AGOVV	38	64	62	56
11	TOP Oss	38	51	53	55
12	PEC Zwolle	38	57	52	54
13	Maastricht	38	53	52	51
14	SC Veendam	38	54	60	51
15	Cambuur	38	48	50	50
16	SC Telstar	38	37	53	40
17	Eindhoven	38	53	65	39
18	Ahead Eagles	38	45	70	35
19	Omniworld	38	50	87	29
20	Fortuna	38	35	85	17

TEMPORADA 2004/2005

EREDIVISIE
Equipo		PJ	GF	GC	Puntos
1	PSV	34	89	18	87
2	Ajax	34	74	33	77
3	AZ Alkmaar	34	71	41	64
4	Feyenoord	34	90	51	62
5	Heerenveen	34	64	52	60
6	Twente	34	48	38	54
7	Vitesse	34	53	49	54
8	Roda JC	34	60	55	47
9	Waalwijk	34	44	51	47
10	Willem II	34	44	56	45
11	Utrecht	34	40	43	44
12	Groningen	34	50	58	40
13	Nijmegen	34	41	47	37
14	Haag	34	44	59	36
15	NAC Breda	34	43	67	35
16	Roosendaal	34	38	77	32
17	Graafschap	34	32	78	19
18	Den Bosch	34	23	75	19

Competiciones que juega

Eerste Divisie

Pos	Equipos		Pts
1		Willem II	75
2		Roda JC	72
3		Groningen	71
4		Dordrecht	67
5		De Graafschap	62
6		ADO Den Haag	59
7		Jong AZ	53
8		NAC Breda	51
9		MVV Maastricht	50
10		Emmen	48
11		Helmond Sport	47
12		Cambuur	46
13		VVV Venlo	45
14		FC Eindhoven	42
15		Jong Ajax	40
16		Jong PSV	34
17		SC Telstar	33
18		Den Bosch	33
19		TOP Oss	33
20		Jong Utrecht	24

	Ascenso : Willem II, Roda JC
	Playoff Ascenso : Groningen, Dordrecht, De Graafschap, ADO Den Haag, Jong AZ, NAC Breda

RIVALES EN KNVB Beker

RIVALES EN Eerste Divisie

USO DE MEMORIA

8,391,552 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.6911
Total Execution Time	0.6931

CADENA URL

/historico/Graafschap

GET DATOS

$_GET['/historico/Graafschap']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0141	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 = 'Graafschap' 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.0126	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=889 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=889 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=889 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=889 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=889 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 889 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0131	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 (38335,74982,95692,112378,141883) ORDER BY n.cover_points DESC, update_date DESC
0.0133	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 = '889' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '889' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 72062 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133	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=889 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (72637,72062,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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 72062 AND teamId = 889
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 889
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 889
0.0254	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 = 72062 AND t.round = 36 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128	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 = '889' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '889' and rp.type = 4
0.0127	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 = '889' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '889' and rp.type = 4
0.0143	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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 889 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.0138	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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 889 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 72062 WHERE rp.league_id = 72062 AND rp.teamId = 889 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 889 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130	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 = 67927 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 62750 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 57108 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 43582 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137	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 = 38712 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 30796 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 15117 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 3873 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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 = 2451 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 1329 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 1090 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 884 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 280 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 28 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables2007` 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 = 563 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables2006` 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 = 564 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

De Graafschap

De Graafschap

Selecciona un equipo

Competiciones que juega

Eerste Divisie

RIVALES EN KNVB Beker

RIVALES EN Eerste Divisie