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

Ajax Amateurs

Temporada 2023/2024

TEMPORADA 2023/2024

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	AFC '34	0	0	0	0
2	Ajax	0	0	0	0
3	Alphense	0	0	0	0
4	Alphense	0	0	0	0
5	BOL	0	0	0	0
6	DHSC	0	0	0	0
7	HBC	0	0	0	0
8	Hollandia	0	0	0	0
9	Hoogland	0	0	0	0
10	Huizen	0	0	0	0
11	Watergraafsm	0	0	0	0
12	Purmersteijn	0	0	0	0
13	Noordwijk	0	0	0	0
14	Swift	0	0	0	0
15	Ter Leede	0	0	0	0
16	WV-HEDW	0	0	0	0

TEMPORADA 2022/2023

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eemdijk	30	83	39	66
2	Swift	30	58	39	57
3	Genemuiden	30	57	41	54
4	AZSV	30	49	38	48
5	DETO	30	60	45	47
6	Huizen	30	59	45	43
7	DHSC	29	52	53	43
8	Berkum	30	45	37	41
9	Ajax	30	41	37	41
10	WV-HEDW	29	47	54	40
11	Barneveld	30	40	47	37
12	Buitenpost	29	26	52	32
13	Flevo Boys	30	41	59	30
14	Olde Veste	30	39	61	29
15	Apeldoorn	29	34	56	29
16	HZVV	30	31	59	24

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

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eemdijk	30	63	33	58
2	Berkum	30	52	36	56
3	Genemuiden	30	74	45	54
4	Ajax	30	69	45	54
5	Staphorst	30	55	44	46
6	Urk	30	47	44	43
7	AZSV	30	38	39	42
8	Door Fusie.	30	47	43	41
9	Excelsior	30	40	45	41
10	SDC Putten	30	40	50	41
11	Sparta	30	47	37	40
12	Apeldoorn	30	51	61	36
13	HZVV	30	37	54	32
14	Huizen	30	47	65	26
15	Zuidvogels	30	40	70	26
16	NSC	30	46	82	26

TEMPORADA 2016/2017

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Spijkenisse	28	62	35	56
2	Ter Leede	28	55	38	56
3	Noordwijk	28	66	42	53
4	Achilles	28	52	36	53
5	Swift	28	56	34	49
6	Ajax	28	50	47	45
7	Jodan Boys	28	52	39	41
8	Hoek	28	41	43	38
9	Door Fusie.	28	40	51	38
10	SV Argon	28	44	46	36
11	RVVH	28	45	50	33
12	Zwaluwen	28	43	56	30
13	Sliedrecht	28	49	72	24
14	Smitshoek	28	35	62	24
15	Breukelen	28	29	68	12
16	Haaglandia	0	0	0	0

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

DERDE DIVISIE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kozakken	30	70	41	59
2	Spakenburg	30	65	37	56
3	Hardenberg	30	57	31	53
4	Barendrecht	30	44	31	51
5	IJsselmeervo	30	48	40	48
6	GVVV	30	56	46	46
7	Rijnsburgse	30	41	41	46
8	Capelle	30	41	37	44
9	Scheveningen	30	54	51	39
10	Excelsior	30	37	48	39
11	Lisse	30	36	47	36
12	ONS Sneek	30	44	64	34
13	Hoek	30	39	51	32
14	Ajax	30	38	57	28
15	Sparta	30	41	64	28
16	Genemuiden	30	51	76	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

EERSTE KLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ajax	26	77	33	53
2	VVZ .49	26	61	40	49
3	Zuidvogels	26	59	42	47
4	Swift	25	49	37	44
5	SVL	26	48	41	42
6	VVA .71	26	37	31	40
7	Roda'46	26	41	46	39
8	Eemdijk	26	36	51	36
9	CSW	26	46	54	32
10	De Merino.s	25	33	38	29
11	Marken	26	50	64	28
12	Lelystad	26	37	49	26
13	HBOK	26	31	52	21
14	DVVA	26	29	56	16

TEMPORADA 2010/2011

EERSTE KLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	DOVO	26	77	26	67
2	HBOK	26	58	38	47
3	Zuidvogels	26	43	35	42
4	VVZ .49	26	62	46	41
5	VVA .71	26	37	27	41
6	De Merino.s	26	46	47	37
7	Ajax	26	55	40	36
8	Eemdijk	26	35	43	35
9	CSW	26	36	43	34
10	Marken	26	38	52	34
11	Breukelen	26	33	40	32
12	SV Geinoord	26	29	55	25
13	SVL	26	34	51	22
14	Veensche	26	18	58	14

TEMPORADA 2009/2010

EERSTE KLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Young Boys	22	59	15	52
2	Huizen	22	47	23	49
3	Montfoort	22	33	23	36
4	Swift	22	38	29	36
5	VVZ .49	22	30	36	36
6	Sportlust	22	41	33	35
7	Ajax	22	34	31	32
8	Geinoord	22	30	37	24
9	Zuidvogels	22	29	44	23
10	De Merino.s	22	33	43	22
11	Roda'46	22	18	47	18
12	Beursbengels	22	20	51	8

TEMPORADA 2008/2009

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	IJsselmeervo	26	59	22	54
2	Hoek	26	47	31	44
3	Spakenburg	26	52	39	42
4	GVVV	26	45	37	41
5	Bennekom	26	37	34	41
6	SDC Putten	26	36	40	38
7	Sparta	26	40	44	37
8	RKAV	26	44	40	36
9	Jodan Boys	26	47	36	34
10	Zwaluwen	26	45	43	33
11	Kozakken	26	39	40	31
12	DOVO	26	33	48	31
13	Ajax	26	22	46	22
14	SV Geinoord	26	35	81	15

TEMPORADA 2007/2008

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Spakenburg	26	73	25	56
2	Sparta	26	44	16	53
3	GVVV	25	49	24	47
4	Kozakken	26	44	35	44
5	Hoek	26	35	28	40
6	IJsselmeervo	26	50	48	40
7	DOVO	26	36	36	38
8	SV Geinoord	26	28	36	35
9	Bennekom	26	33	50	32
10	Ajax	26	29	44	29
11	LRC	26	33	43	26
12	Nunspeet	26	30	44	23
13	Nivo Sparta	26	27	51	18
14	Kloetinge	25	14	45	15

TEMPORADA 2006/2007

HOOFDKLASSE ZATERDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	IJsselmeervo	26	65	29	59
2	Sparta	25	59	34	49
3	Quick Boys	25	56	32	48
4	Nunspeet	26	49	37	44
5	Spakenburg	26	47	35	42
6	GVVV	26	48	35	40
7	Hoek	26	57	48	39
8	Ajax	26	34	41	31
9	Bennekom	26	43	51	30
10	Kloetinge	26	29	42	29
11	SV Geinoord	26	31	49	29
12	Huizen	26	26	41	23
13	VVOG	26	27	50	23
14	GOES	26	21	68	5

TEMPORADA 2005/2006

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rijnsburgse	27	44	23	51
2	Lisse	26	54	36	49
3	DOTO	26	48	35	49
4	Katwijk	26	47	35	41
5	Ter Leede	27	33	33	41
6	Quick Boys	25	39	32	37
7	Noordwijk	25	43	42	35
8	Excelsior	26	43	45	35
9	Capelle	26	36	39	33
10	Ajax	26	26	34	30
11	Kloetinge	26	30	47	30
12	Hoek	26	44	52	28
13	Alphense	26	35	47	21
14	Scheveningen	26	22	44	17

TEMPORADA 2004/2005

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ASWH	26	53	23	58
2	Hoek	26	57	35	46
3	Kozakken	26	42	21	46
4	Ter Leede	26	45	25	46
5	Lisse	26	62	43	46
6	Bennekom	26	44	31	45
7	Noordwijk	26	42	42	38
8	DOVO	26	40	37	37
9	Heerjansdam	26	37	46	33
10	Alphense	26	28	37	32
11	Ajax	26	25	37	31
12	Barendrecht	26	27	53	21
13	Marken	26	27	53	20
14	RKAV	26	18	64	11

Competiciones que juega

Grupo 1

Hoofdklasse Zaterdag Grupo 1

Pos	Equipos		Pts
1		AFC '34	0
2		Ajax Amateurs	0
3		Alphense Boys	0
4		ARC Alphense	0
5		BOL	0
6		DHSC	0
7		HBC	0
8		Hollandia	0
9		Hoogland	0
10		Huizen	0
11		JOS Watergraafsmeer	0
12		Purmersteijn	0
13		SJC Noordwijk	0
14		Swift	0
15		Ter Leede	0
16		WV-HEDW	0

	Ascenso : AFC '34
	Playoff Ascenso : Ajax Amateurs, Alphense Boys, ARC Alphense
	Playoff Descenso : SJC Noordwijk, Swift
	Descenso : Ter Leede, WV-HEDW

RIVALES EN Hoofdklasse Zate.

USO DE MEMORIA

7,094,048 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7866
Total Execution Time	0.7878

CADENA URL

/historico/Ajax-Amateurs

GET DATOS

$_GET['/historico/Ajax-Amateurs']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0182	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 = 'Ajax-Amateurs' 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.0149	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=7256 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=7256 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0299	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 = 72976
0.0147	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7256 AND type_rel = 2
0.0147	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=226 AND type_rel = 3
0.0154	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 226 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0158	SELECT /53 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 (859778,183993,112119,50354,49516) ORDER BY n.cover_points DESC, update_date DESC
0.0166	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 = '7256' ORDER BY l.year DESC,cat.coefficient DESC
0.0164	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 = '7256' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0169	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 = '7256' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0155	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 = 72976 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0164	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=7256 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0150	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 (72976) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 72976 AND teamId = 7256
0.0154	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 = '7256' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7256' and rp.type = 4
0.0155	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 = '7256' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152	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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7256 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.0149	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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7256 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 72976 WHERE rp.league_id = 72976 AND rp.teamId = 7256 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0155	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 = 7256 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72976 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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 = 70054 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.0167	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.0162	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.0163	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.0157	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 = 44605 AND t.round = 34 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* `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 = 39747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 33955 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* `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.0151	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 = 4005 AND t.round = 30 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* `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.0153	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.0151	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 = 1719 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 20429 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 20434 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 20382 AND t.round = 26 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* `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 = 20387 AND t.round = 26 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* `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 = 20390 AND t.round = 26 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* `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 = 20392 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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* `tables2005` 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 = 20395 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Ajax Amateurs

Ajax Amateurs

Selecciona un equipo

Competiciones que juega

Hoofdklasse Zaterdag Grupo 1

RIVALES EN Hoofdklasse Zate.