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

JOS Watergraafsmeer

Temporada 2023/2024

TEMPORADA 2023/2024

HOOFDKLASSE ZATERDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Huizen	26	50	21	55
2	Ajax	26	59	29	51
3	Watergraafsm	26	49	35	50
4	AFC '34	26	46	35	47
5	HBC	26	61	33	45
6	Hollandia	26	47	34	42
7	Ter Leede	25	65	48	37
8	Purmersteijn	26	44	29	37
9	Hoogland	26	35	40	34
10	Swift	26	36	43	33
11	Noordwijk	26	46	61	32
12	Alphense	26	35	48	28
13	DHSC	26	29	63	28
14	BOL	25	29	49	26
15	WV-HEDW	26	48	65	23
16	Alphense	26	30	76	17

TEMPORADA 2022/2023

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	ADO 20	34	85	37	84
2	VVSB	34	87	52	71
3	Hercules	34	64	33	63
4	Blauw Geel	34	53	45	55
5	Rosmalen	34	58	56	54
6	HSC 21	34	64	42	51
7	UNA	34	55	41	49
8	TOGB	34	68	56	49
9	Quick	34	59	47	49
10	RKVV DEM	34	58	53	48
11	Gemert	34	52	59	47
12	GVV Unitas	34	43	59	45
13	Groene Ster	34	42	44	43
14	OSS '20	34	39	59	36
15	Watergraafsm	34	35	80	32
16	Baronie	34	44	70	28
17	Dongen	34	45	77	25
18	UDI '19	34	26	67	17

TEMPORADA 2021/2022

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Oostzaan	34	66	47	61
2	Hercules	34	74	46	59
3	ADO 20	34	64	46	58
4	Gemert	34	75	57	57
5	OSS '20	34	62	46	55
6	Groene Ster	34	48	50	51
7	Dongen	34	56	47	50
8	UNA	34	60	58	50
9	HSC 21	34	63	52	49
10	Quick	34	47	44	47
11	Blauw Geel	34	55	56	45
12	RKVV DEM	34	37	50	45
13	GVV Unitas	34	41	59	42
14	Watergraafsm	34	59	69	40
15	Hoogland	34	42	64	39
16	EVV	34	36	59	37
17	Hollandia	34	38	55	35
18	Westlandia	34	43	61	32

TEMPORADA 2020/2021

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hercules	5	12	2	13
2	Blauw Geel	6	17	8	13
3	Oostzaan	5	10	7	10
4	Groene Ster	5	9	6	10
5	OSS '20	6	10	11	10
6	UNA	6	15	9	8
7	GVV Unitas	6	13	8	8
8	Hollandia	5	6	7	7
9	Westlandia	6	10	11	7
10	Gemert	6	6	10	7
11	Watergraafsm	6	4	9	7
12	Quick	5	9	7	6
13	EVV	5	2	6	6
14	ADO 20	6	9	8	6
15	Dongen	6	5	9	6
16	Hoogland	5	8	11	5
17	RKVV DEM	5	6	13	5
18	HSC 21	6	5	14	2

TEMPORADA 2019/2020

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hollandia	20	42	20	43
2	Watergraafsm	19	47	24	40
3	RKAVV	21	53	33	36
4	Noordwijk	20	45	31	35
5	Alphense	20	43	28	34
6	Hoogeveen	19	36	31	33
7	Leonidas	19	38	33	30
8	HBS	20	30	26	29
9	Quick '20	20	52	46	28
10	SDO Bussum	20	45	44	26
11	RKVV Velsen	19	28	30	26
12	Quick 1887	21	32	25	25
13	VV Emmen	20	41	55	19
14	Alcides	20	24	48	14
15	MSC	19	18	67	14
16	VOC	21	25	58	11

TEMPORADA 2018/2019

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	RKVV Velsen	26	56	17	58
2	Watergraafsm	26	63	33	56
3	Boshuizen	26	45	33	46
4	Uitgeest	26	49	44	39
5	AFC '34	26	39	40	38
6	Zaanlandia	26	48	47	37
7	LSVV	26	39	51	37
8	AGB	26	44	43	35
9	Legmeervogel	26	47	53	33
10	DSOV	26	52	59	30
11	Hoofddorp	26	38	49	29
12	Zeeburgia	26	49	64	25
13	Hillegom	26	50	57	24
14	NVC	26	34	63	23

TEMPORADA 2017/2018

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fortuna	26	65	30	58
2	RKVV DEM	26	55	34	53
3	Legmeervogel	26	53	42	48
4	Watergraafsm	26	67	42	46
5	AFC '34	26	63	46	46
6	Uitgeest	26	41	41	42
7	Hoofddorp	26	54	59	35
8	LSVV	26	41	52	32
9	Zeeburgia	26	42	53	30
10	AGB	26	40	46	29
11	RKVV Velsen	26	26	46	28
12	Hillegom	26	31	47	23
13	Assendelft	26	29	51	19
14	EDO HFC	26	37	55	17

TEMPORADA 2016/2017

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	ADO 20	30	82	41	64
2	Woezik	30	57	32	55
3	Noordwijk	30	64	39	53
4	Hollandia	30	51	33	53
5	Silvolde	30	54	51	49
6	De Meern	30	70	55	45
7	SWZ	30	65	52	41
8	SDO Bussum	30	42	45	40
9	Heerenveen	30	49	52	38
10	De Bataven	30	45	60	38
11	MSC	30	53	55	37
12	RKHVV	30	42	52	37
13	Alverna	30	50	45	36
14	Watergraafsm	30	51	55	36
15	Hoogland	30	42	56	33
16	Dieze West	30	28	122	6

TEMPORADA 2015/2016

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Westlandia	26	75	39	65
2	De Dijk	26	68	37	55
3	DHC Delft	26	52	26	55
4	Oostzaan	26	55	35	52
5	Quick	26	51	38	48
6	ADO 20	26	54	34	42
7	De Meern	26	45	48	30
8	RKAVV	26	36	41	30
9	Watergraafsm	26	34	39	30
10	SDO Bussum	26	28	29	29
11	EDO HFC	26	35	52	24
12	Nieuwerkerk	26	33	62	23
13	Leonidas	26	31	79	12
14	Nieuw	26	21	59	11

TEMPORADA 2014/2015

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Magreb 90	24	61	32	52
2	De Dijk	24	51	32	50
3	Vlissingen	24	47	41	43
4	Oostzaan	24	54	38	38
5	Quick	24	50	51	36
6	Westlandia	23	43	35	35
7	Chabab	23	47	48	34
8	Watergraafsm	24	44	50	33
9	DHC Delft	24	48	55	30
10	Hollandia	24	37	38	27
11	VOC	24	41	57	24
12	De Zouaven	24	31	52	21
13	AFC '34	24	33	58	17
14	Haaglandia	0	0	0	0

TEMPORADA 2013/2014

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Watergraafsm	26	75	28	63
2	AFC '34	26	66	38	51
3	Oostzaan	26	74	33	50
4	De Meern	26	54	22	49
5	Elinkwijk	26	68	61	41
6	SDO Bussum	26	47	59	38
7	Stormvogels	26	69	72	34
8	Kennemers	26	41	49	33
9	Foresters	26	41	60	32
10	RKVV DEM	26	48	65	30
11	NVC	26	43	60	28
12	Pancratius	26	36	58	27
13	Uitgeest	26	42	73	27
14	Zeeburgia	26	39	65	18

TEMPORADA 2012/2013

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	De Dijk	26	75	24	62
2	Zeeburgia	26	56	31	58
3	Watergraafsm	26	68	26	53
4	Hercules	26	59	40	49
5	Hoogland	26	46	37	41
6	AFC '34	26	57	45	35
7	Stormvogels	26	54	71	34
8	Uitgeest	26	42	53	33
9	Pancratius	26	35	43	30
10	RKVV DEM	26	44	64	28
11	DWV	26	27	42	23
12	VVIJ	26	32	64	23
13	Purmersteijn	26	38	60	22
14	Blauw	26	34	67	20

TEMPORADA 2011/2012

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	EDO HFC	26	56	33	52
2	RKVV DEM	26	46	33	52
3	Blauw	26	57	38	45
4	Hercules	26	57	34	42
5	Hoogland	26	43	34	39
6	VVIJ	26	47	52	39
7	De Dijk	26	53	44	37
8	De Meern	26	51	36	36
9	DWV	26	43	56	33
10	Watergraafsm	26	42	44	32
11	Stormvogels	26	42	59	30
12	ZAP	26	41	51	29
13	Roda (Zon)	26	40	57	25
14	Kennemers	26	28	75	20

TEMPORADA 2010/2011

HOOFDKLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	HBS	26	48	27	49
2	Chabab	26	40	25	46
3	ADO 20	26	50	32	43
4	Feyenoord	26	52	35	42
5	AFC '34	26	36	39	37
6	Elinkwijk	26	37	42	37
7	De Zouaven	26	33	31	35
8	Leonidas	26	41	40	34
9	DHC Delft	26	51	52	34
10	Nieuwenhoorn	26	36	40	33
11	Alphense	26	40	49	33
12	Westlandia	26	41	44	31
13	Watergraafsm	26	31	37	28
14	IFC	26	32	75	18

TEMPORADA 2009/2010

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	De Zouaven	22	43	15	43
2	AFC '34	22	43	20	41
3	Watergraafsm	22	41	25	38
4	De Meern	22	26	21	37
5	NVC	22	44	34	35
6	Purmersteijn	22	36	30	30
7	Roda (Zon)	22	35	47	29
8	Kennemers	22	21	32	24
9	Blauw	22	20	29	22
10	DWV	22	26	40	22
11	Hercules	22	22	38	18
12	KFC	22	19	45	17

TEMPORADA 2008/2009

EERSTE KLASSE ZONDAG GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chabab	22	56	20	58
2	De Zouaven	22	48	18	48
3	AFC '34	22	40	23	42
4	Watergraafsm	22	31	21	36
5	NVC	22	36	41	31
6	KFC	22	35	43	28
7	Kennemers	22	29	36	26
8	Blauw	22	33	43	26
9	Amsterdam	22	31	41	22
10	Hercules	22	28	44	21
11	Kampong	22	25	41	17
12	Breukelen	22	21	42	17

Competiciones que juega

Hoofdklasse Zaterdag Grupo 1

Pos	Equipos		Pts
1		Huizen	55
2		Ajax Amateurs	51
3		JOS Watergraafsmeer	50
4		AFC '34	47
5		HBC	45
6		Hollandia	42
7		Ter Leede	37
8		Purmersteijn	37
9		Hoogland	34
10		Swift	33
11		SJC Noordwijk	32
12		ARC Alphense	28
13		DHSC	28
14		BOL	26
15		WV-HEDW	23
16		Alphense Boys	17

	Ascenso : Huizen
	Playoff Ascenso : Ajax Amateurs, JOS Watergraafsmeer, AFC '34
	Playoff Descenso : DHSC, BOL
	Descenso : WV-HEDW, Alphense Boys

RIVALES EN Hoofdklasse Zate.

USO DE MEMORIA

6,595,800 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5826
Total Execution Time	0.5839

CADENA URL

/historico/Jos-Watergraaf

GET DATOS

$_GET['/historico/Jos-Watergraaf']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7315 AND type_rel = 2
0.0179	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 = '7315' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0160	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=7315 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148	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,71882,68342,68213) 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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 68213 AND teamId = 7315
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 72976 AND teamId = 7315
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 68342 AND teamId = 7315
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 71882 AND teamId = 7315
0.0147	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 = '7315' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7315' and rp.type = 4
0.0146	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 = '7315' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 7315 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.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 = 7315 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 = 7315 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 7315 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 26 ORDER BY team.conference ASC,t.position 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* `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 = 68213 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* `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 = 63260 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 = 57890 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.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* `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 = 50984 AND t.round = 21 ORDER BY team.conference ASC,t.position 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* `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 = 45035 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* `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 = 39757 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* `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 = 33960 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* `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 = 15938 AND t.round = 26 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 = 9389 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* `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 = 9416 AND t.round = 26 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* `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 = 2219 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* `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 = 1724 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* `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 = 20400 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 = 20466 AND t.round = 22 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* `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 = 20472 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

JOS Watergraafsmeer

JOS Watergraafsmeer

Selecciona un equipo

Competiciones que juega

Hoofdklasse Zaterdag Grupo 1

RIVALES EN Hoofdklasse Zate.