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

Koninklijke HFC

Entrenador: Gertjan Tamerus

Temporada 2023/2024

TEMPORADA 2023/2024

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Spakenburg	30	75	34	70
2	De Treffers	30	60	36	65
3	Quick Boys	30	61	38	57
4	Katwijk	30	55	41	53
5	GVVV	30	48	44	50
6	Amsterdamsch	30	53	44	48
7	Jong Almere	30	55	48	45
8	Jong Sparta	30	49	44	43
9	ACV Assen	30	46	48	43
10	Hardenberg	30	43	36	42
11	Koninklijke	30	48	43	42
12	ADO 20	30	38	48	37
13	Rijnsburgse	30	41	50	36
14	Noordwijk	30	35	46	31
15	Scheveningen	30	38	56	28
16	Excelsior	30	35	57	25
17	Kozakken	30	32	55	20
18	Lisse	30	32	76	15

TEMPORADA 2022/2023

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Katwijk	34	74	36	71
2	Rijnsburgse	34	73	42	69
3	Amsterdamsch	34	60	31	69
4	Hardenberg	34	75	48	60
5	De Treffers	34	66	45	60
6	Quick Boys	34	72	48	56
7	Koninklijke	34	52	41	55
8	Scheveningen	34	38	46	45
9	Noordwijk	34	45	45	43
10	Jong Sparta	34	58	61	43
11	Spakenburg	34	50	55	43
12	Lisse	34	45	51	42
13	Kozakken	34	50	58	40
14	Excelsior	34	50	69	39
15	SV TEC Tiel	34	41	60	39
16	IJsselmeervo	34	51	71	33
17	Jong	34	45	82	26
18	Oostzaan	34	33	89	20

TEMPORADA 2021/2022

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Katwijk	34	73	34	71
2	Hardenberg	34	58	43	62
3	Koninklijke	34	54	39	57
4	Rijnsburgse	34	63	43	55
5	Jong Sparta	34	57	49	55
6	Amsterdamsch	34	61	49	54
7	Noordwijk	34	53	46	54
8	Scheveningen	34	43	44	50
9	Spakenburg	34	64	62	49
10	Excelsior	34	50	55	47
11	Jong	34	66	65	45
12	Quick Boys	34	43	53	44
13	IJsselmeervo	34	44	48	42
14	SV TEC Tiel	34	44	63	42
15	De Treffers	34	38	51	41
16	Kozakken	34	46	62	35
17	GVVV	34	45	54	34
18	ASWH	34	38	80	21

TEMPORADA 2020/2021

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Amsterdamsch	5	15	5	13
2	ASWH	6	12	7	12
3	Spakenburg	6	11	6	12
4	Quick Boys	6	7	8	12
5	IJsselmeervo	5	9	10	9
6	Rijnsburgse	5	10	6	8
7	Kozakken	5	12	10	8
8	Katwijk	5	9	7	8
9	Hardenberg	6	7	7	8
10	Koninklijke	4	6	5	6
11	Jong	6	9	13	5
12	GVVV	6	6	11	5
13	SV TEC Tiel	4	6	6	4
14	Excelsior	5	6	10	4
15	Jong Sparta	6	6	9	4
16	Scheveningen	4	3	4	3
17	Noordwijk	5	7	10	3
18	De Treffers	5	2	9	2

TEMPORADA 2019/2020

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Katwijk	24	48	26	49
2	Hardenberg	24	54	27	46
3	Amsterdamsch	24	50	33	45
4	Rijnsburgse	24	55	42	45
5	IJsselmeervo	24	57	37	44
6	Kozakken	24	38	29	42
7	Spakenburg	24	37	44	37
8	Koninklijke	23	43	36	35
9	De Treffers	24	42	36	35
10	Noordwijk	24	47	44	32
11	Jong Sparta	24	43	42	31
12	Excelsior	24	36	47	31
13	GVVV	24	38	48	30
14	Quick Boys	24	25	32	27
15	Scheveningen	23	24	36	25
16	SV TEC Tiel	24	17	40	16
17	Jong	24	40	61	14
18	ASWH	24	26	60	14

TEMPORADA 2018/2019

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Amsterdamsch	34	85	43	71
2	Excelsior	34	69	38	63
3	IJsselmeervo	34	70	52	63
4	Koninklijke	33	62	37	60
5	Katwijk	34	51	39	55
6	Hardenberg	34	68	54	54
7	Kozakken	34	59	49	54
8	Vitesse	34	62	46	53
9	Spakenburg	34	55	52	52
10	GVVV	34	61	64	49
11	Jong Sparta	34	59	54	47
12	De Treffers	33	47	48	47
13	Rijnsburgse	34	77	79	47
14	Scheveningen	34	59	65	43
15	VVSB	34	57	82	30
16	Jong Almere	34	46	69	28
17	Lienden	34	42	95	26
18	Barendrecht	34	29	92	19

TEMPORADA 2017/2018

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Katwijk	34	67	33	72
2	Kozakken	34	74	34	70
3	Hardenberg	34	77	56	59
4	Barendrecht	34	64	57	59
5	Rijnsburgse	34	60	63	56
6	GVVV	34	54	44	54
7	Excelsior	34	43	30	51
8	VVSB	34	47	54	51
9	IJsselmeervo	34	59	45	49
10	Koninklijke	34	55	46	48
11	Jong Sparta	34	72	64	43
12	Amsterdamsch	34	45	56	43
13	De Treffers	34	51	55	41
14	Lienden	34	52	67	41
15	Lisse	34	48	57	40
16	SV TEC Tiel	34	53	66	38
17	De Dijk	34	50	85	30
18	Achilles 29	34	41	100	12

TEMPORADA 2016/2017

TWEEDE DIVISIE
Equipo		PJ	GF	GC	Puntos
1	Jong AZ	34	85	29	76
2	Kozakken	34	70	54	57
3	Katwijk	34	52	42	55
4	De Treffers	34	70	55	54
5	Excelsior	34	52	43	49
6	Lienden	34	52	48	48
7	Jong Sparta	34	74	67	47
8	Barendrecht	34	57	57	47
9	VVSB	34	62	64	47
10	GVVV	34	51	63	47
11	Amsterdamsch	34	59	63	45
12	SV TEC Tiel	34	53	67	45
13	Koninklijke	34	49	50	42
14	Hardenberg	34	41	53	41
15	UNA	34	57	79	41
16	Spakenburg	34	61	66	37
17	Vitesse	34	66	79	34
18	Twente	34	32	64	25

TEMPORADA 2015/2016

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lienden	28	35	18	53
2	SV TEC Tiel	28	45	29	52
3	Koninklijke	28	51	33	49
4	De Treffers	28	57	33	48
5	VVSB	28	45	25	47
6	Amsterdamsch	28	46	43	44
7	UNA	28	45	31	43
8	HSC 21	28	38	32	43
9	JVC Cuijk	28	42	45	41
10	Hercules	28	35	43	37
11	EVV	28	22	31	30
12	HBS	28	38	50	28
13	Magreb 90	28	32	52	24
14	Rosmalen	28	25	49	24
15	SWZ	28	26	68	18
16	WKE Emmen	0	0	0	0

TEMPORADA 2014/2015

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lienden	30	65	33	62
2	UNA	30	70	41	58
3	VVSB	30	67	48	54
4	De Treffers	30	62	45	47
5	JVC Cuijk	30	58	46	47
6	Koninklijke	30	56	49	47
7	EVV	30	33	28	46
8	WKE Emmen	30	62	60	43
9	Rosmalen	30	41	42	40
10	Amsterdamsch	30	37	41	40
11	HSC 21	30	63	54	39
12	Hercules	30	41	49	39
13	HBS	30	53	51	35
14	ADO 20	30	48	78	29
15	Leonidas	30	43	87	23
16	EDO HFC	30	33	80	12

TEMPORADA 2013/2014

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Koninklijke	26	62	36	56
2	EDO HFC	26	56	31	51
3	Westlandia	26	64	43	49
4	De Zouaven	26	53	52	40
5	De Dijk	26	47	46	39
6	VOC	26	58	50	37
7	Quick	26	45	43	36
8	DOSKO	26	45	47	36
9	DHC Delft	26	47	51	35
10	Hollandia	26	39	42	34
11	GOES	26	55	56	31
12	RKAVV	26	42	62	31
13	Nieuwenhoorn	26	44	52	29
14	Boshuizen	26	41	87	8

TEMPORADA 2012/2013

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Leonidas	26	43	25	50
2	Alphense	26	56	40	46
3	De Zouaven	26	42	29	44
4	Westlandia	26	44	38	39
5	DHC	26	42	46	39
6	Nieuwenhoorn	26	48	39	38
7	Koninklijke	26	43	33	36
8	EDO HFC	26	47	39	36
9	Hilversum	26	41	56	33
10	RKAVV	26	34	49	33
11	Feyenoord	26	42	40	31
12	Quick	26	35	45	30
13	SV Argon	26	34	46	26
14	Elinkwijk	26	33	59	25

TEMPORADA 2011/2012

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ADO 20	24	62	21	55
2	Leonidas	24	47	31	45
3	Alphense	24	42	31	40
4	Feyenoord	24	51	35	39
5	RKAVV	24	26	26	37
6	De Zouaven	24	42	33	36
7	Nieuwenhoorn	24	36	39	36
8	Chabab	24	42	39	33
9	Elinkwijk	24	33	36	29
10	DHC	24	40	43	24
11	Koninklijke	24	34	45	24
12	Westlandia	24	33	50	23
13	Purmersteijn	24	26	55	18
14	AFC '34	24	27	57	15

TEMPORADA 2010/2011

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Koninklijke	26	42	27	49
2	EDO HFC	26	54	29	47
3	RKVV DEM	26	54	41	44
4	Pancratius	26	45	39	43
5	Roda (Zon)	26	59	50	42
6	Stormvogels	26	45	39	40
7	Purmersteijn	26	41	31	38
8	DWV	26	46	46	38
9	De Meern	26	48	35	36
10	VVIJ	26	44	44	34
11	Almere City	26	38	44	31
12	Kennemers	26	28	51	24
13	NVC	26	28	55	20
14	SVW 27	26	31	72	19

Competiciones que juega

Tweede Divisie

Pos	Equipos		Pts
1		Spakenburg	70
2		De Treffers	65
3		Quick Boys	57
4		Katwijk	53
5		GVVV	50
6		Amsterdamsche FC	48
7		Jong Almere City	45
8		Jong Sparta	43
9		ACV Assen	43
10		HHC Hardenberg	42
11		Koninklijke HFC	42
12		ADO 20	37
13		Rijnsburgse Boys	36
14		VV Noordwijk	31
15		Scheveningen	28
16		Excelsior Maassluis	25
17		Kozakken Boys	20
18		Lisse	15

	Campeón : Spakenburg
	Playoff Descenso : Excelsior Maassluis, Kozakken Boys
	Descenso : Lisse

RIVALES EN KNVB Beker

RIVALES EN Tweede Divisie

USO DE MEMORIA

6,967,072 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1382
Total Execution Time	0.1398

CADENA URL

/historico/Koninklijke-Hfc

GET DATOS

$_GET['/historico/Koninklijke-Hfc']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0029	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 = 'Koninklijke-Hfc' 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=7202 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=7202 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=7202 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=7202 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 = 72637
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7202 AND type_rel = 2
0.0024	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 = '7202' 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 = '7202' 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 = '7202' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 72637 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 72649 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029	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=7202 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 (72649,72637,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72649 AND teamId = 7202
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 7202
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7202
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 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 = 72649 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '7202' 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 = '7202' and rp.type = 4
0.0020	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 = '7202' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 = 72649 WHERE rp.league_id = 72649 AND rp.teamId = 7202 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.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 = 72649 WHERE rp.league_id = 72649 AND rp.teamId = 7202 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 = 72649 WHERE rp.league_id = 72649 AND rp.teamId = 7202 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 7202 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68065 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.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* `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 = 63256 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.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 = 57795 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* `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 = 50350 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* `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 = 44341 AND t.round = 34 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 = 38921 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* `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 = 33765 AND t.round = 34 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 = 15932 AND t.round = 30 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* `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 = 4004 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 = 9396 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* `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 = 2186 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* `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 = 1716 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* `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 = 20460 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 72649 ORDER BY nameShow LIMIT 100

Koninklijke HFC

Koninklijke HFC

Selecciona un equipo

Competiciones que juega

Tweede Divisie

RIVALES EN KNVB Beker

RIVALES EN Tweede Divisie