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

Amsterdamsche FC

Entrenador: Benno Nihom

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

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Amsterdamsch	30	73	41	62
2	UNA	30	74	39	57
3	VVSB	30	54	31	57
4	JVC Cuijk	30	68	42	54
5	EVV	30	49	32	52
6	HBS	30	64	43	51
7	RKSV	30	47	53	44
8	ADO 20	30	49	52	38
9	HSC 21	30	61	66	38
10	Lienden	30	41	56	38
11	De Treffers	30	46	47	37
12	WKE Emmen	30	56	51	36
13	Haaglandia	30	56	66	33
14	Quick 1887	30	45	64	27
15	Juliana 31	30	31	83	20
16	Chabab	30	38	86	19

TEMPORADA 2012/2013

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Achilles 29	30	70	23	68
2	ADO 20	30	66	53	53
3	De Treffers	30	60	36	50
4	WKE	30	64	60	50
5	EVV	30	37	35	48
6	HSC 21	30	67	57	46
7	Lienden	30	50	45	46
8	HBS	30	47	55	44
9	VVSB	30	37	42	43
10	JVC Cuijk	30	47	43	39
11	Amsterdamsch	30	44	43	39
12	Chabab	30	36	42	39
13	Haaglandia	30	57	70	36
14	Hollandia	30	37	45	35
15	Gemert	30	33	62	23
16	SWZ	30	26	67	19

TEMPORADA 2011/2012

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Achilles 29	30	72	26	71
2	Haaglandia	30	82	50	62
3	WKE	30	52	49	53
4	De Treffers	30	59	41	50
5	HSC 21	30	61	40	49
6	EVV	30	50	43	47
7	Lienden	30	49	40	46
8	Hollandia	30	45	39	46
9	HBS	30	55	62	44
10	Amsterdamsch	30	57	55	38
11	VVSB	30	37	41	37
12	JVC Cuijk	30	44	49	37
13	UNA	30	48	62	32
14	Hilversum	30	35	60	31
15	SV Argon	30	38	63	25
16	Quick '20	30	23	87	8

TEMPORADA 2010/2011

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	TOP Oss	28	49	23	59
2	Achilles 29	28	52	25	53
3	SV Argon	28	38	34	47
4	Amsterdamsch	28	59	45	45
5	De Treffers	28	39	39	45
6	JVC Cuijk	28	47	48	41
7	Haaglandia	28	58	43	40
8	Quick '20	28	46	43	39
9	EVV	28	36	34	37
10	Lienden	28	50	58	37
11	VVSB	28	34	48	32
12	Hollandia	28	26	34	31
13	Hilversum	28	30	43	31
14	Gemert	28	24	43	25
15	Baronie	28	32	60	15
16	Dijkse Boys	0	0	0	0

TEMPORADA 2009/2010

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Amsterdamsch	26	64	29	57
2	SV Argon	26	42	28	48
3	Hilversum	26	42	34	46
4	Haaglandia	26	43	37	44
5	VVSB	26	37	32	38
6	Hollandia	26	39	41	36
7	HBS	26	36	39	36
8	ADO 20	26	33	30	35
9	Elinkwijk	26	40	39	31
10	Chabab	26	32	32	30
11	Feyenoord	26	33	45	29
12	Westlandia	26	34	43	28
13	TONEGIDO	26	38	59	27
14	Almere City	26	24	49	20

TEMPORADA 2008/2009

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Haaglandia	23	47	37	43
2	Westlandia	22	39	24	42
3	SV Argon	22	41	23	40
4	Hilversum	22	39	32	40
5	Amsterdamsch	22	41	31	36
6	VVSB	23	35	30	33
7	ADO 20	23	34	33	30
8	Hollandia	21	28	27	29
9	Almere City	22	38	33	28
10	HBS	22	26	41	27
11	VUC	22	23	36	21
12	Elinkwijk	22	26	40	21
13	DWV	22	11	41	11

TEMPORADA 2007/2008

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hollandia	26	44	20	54
2	SV Argon	26	40	28	48
3	VVSB	26	38	29	45
4	Haaglandia	26	49	43	43
5	Amsterdamsch	26	43	36	40
6	Almere City	26	43	36	37
7	ADO 20	26	31	34	37
8	VUC	26	40	40	36
9	Türkiyemspo	26	50	48	35
10	Westlandia	26	39	37	35
11	Elinkwijk	26	38	37	35
12	DWV	26	29	36	33
13	Amsterdam	26	17	41	15
14	DCV	26	16	52	9

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

7,370,728 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6175
Total Execution Time	0.6188

CADENA URL

/historico/Amsterdamsche-Fc

GET DATOS

$_GET['/historico/Amsterdamsche-Fc']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12266 AND type_rel = 2
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12266 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (533785,1220698) ORDER BY n.cover_points DESC, update_date DESC
0.0155	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 = '12266' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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.0149	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=12266 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 72649 AND teamId = 12266
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 12266
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12266
0.0146	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 = '12266' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12266' and rp.type = 4
0.0147	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 = '12266' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159	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 = 12266 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.0162	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 = 12266 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 12266 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 12266 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0294	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.0149	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.0149	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.0150	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.0150	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.0149	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.0150	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.0149	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.0149	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 = 2462 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 2185 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 1712 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 10821 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 20403 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 20406 AND t.round = 24 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 20409 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Amsterdamsche FC

Amsterdamsche FC

Selecciona un equipo

Competiciones que juega

Tweede Divisie

RIVALES EN KNVB Beker

RIVALES EN Tweede Divisie