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

UNA

Temporada 2023/2024

TEMPORADA 2023/2024

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	SteDoCo	30	64	28	61
2	Barendrecht	30	66	32	61
3	Blauw Geel	30	57	33	57
4	SV TEC Tiel	30	60	24	56
5	Meerssen	30	64	47	50
6	Sportlust	30	45	33	49
7	Gemert	30	51	53	49
8	TOGB	30	45	40	46
9	Kloetinge	30	43	41	46
10	UNA	30	47	41	44
11	Quick	30	58	57	43
12	Hoek	30	67	48	41
13	OSS '20	30	40	58	33
14	Rosmalen	30	44	60	31
15	AWC	30	24	57	29
16	Groene Ster	30	24	65	26
17	GVV Unitas	30	31	55	23
18	Baronie	30	21	79	13

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

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	OSS '20	22	55	24	53
2	Haag	22	47	36	39
3	Oostzaan	22	38	27	36
4	Gemert	22	42	42	35
5	Dongen	20	34	19	34
6	UNA	22	35	39	32
7	EVV	22	30	27	31
8	Blauw Geel	22	38	38	29
9	HSC 21	22	34	39	29
10	Hercules	21	35	38	27
11	RKVV DEM	22	31	31	27
12	Groene Ster	22	28	33	27
13	Quick	21	29	26	26
14	Westlandia	22	31	40	24
15	ADO 20	21	29	35	21
16	Lienden	21	17	39	18
17	Hoogland	22	31	51	17

TEMPORADA 2018/2019

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Jong	34	97	44	71
2	SV TEC Tiel	34	63	38	70
3	Oostzaan	34	79	43	62
4	GOES	34	80	55	61
5	UNA	34	68	55	56
6	OSS '20	34	70	53	54
7	Quick	34	67	66	50
8	ADO 20	34	59	57	47
9	Westlandia	34	59	73	46
10	Dongen	34	51	70	45
11	EVV	34	40	43	44
12	Hercules	34	55	63	44
13	HSC 21	34	51	73	44
14	Blauw Geel	34	62	65	43
15	JVC Cuijk	34	43	77	39
16	Rosmalen	34	49	61	35
17	Quick '20	34	53	84	31
18	HBS	34	37	63	27

TEMPORADA 2017/2018

DERDE DIVISIE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vitesse	34	96	36	75
2	UNA	34	74	38	71
3	Quick	34	74	58	63
4	Dongen	34	61	65	55
5	Westlandia	34	77	74	54
6	Oostzaan	34	64	47	52
7	ADO 20	34	76	70	52
8	JVC Cuijk	34	60	58	50
9	Hercules	34	63	59	49
10	Blauw Geel	34	60	62	47
11	Rosmalen	34	52	61	47
12	HBS	34	43	43	40
13	EVV	34	32	48	39
14	HSC 21	34	44	57	38
15	Quick '20	34	52	67	38
16	Quick 1887	34	61	85	33
17	Graafschap	34	48	61	32
18	De Meern	34	28	76	25

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

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UNA	26	70	33	61
2	Schijndel	26	57	41	46
3	Venray	26	52	39	45
4	Hoensbroek	26	43	57	41
5	Blauw Geel	26	67	59	39
6	Baronie	26	44	44	39
7	UDI '19	26	46	42	38
8	Groene Ster	26	43	37	37
9	Dongen	26	48	46	37
10	RKSV Nuenen	26	48	48	36
11	Deurne	26	46	44	33
12	GOES	26	42	48	30
13	Brabantia	26	34	60	23
14	Someren	26	13	55	10

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

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	UNA	26	55	24	54
2	Hoensbroek	26	53	49	42
3	Dongen	26	53	40	41
4	UDI '19	26	51	42	37
5	De Valk	26	43	47	37
6	Venray	26	53	40	36
7	Rosmalen	26	46	59	36
8	DESK	26	37	52	36
9	Meerssen	26	43	44	35
10	Blauw Geel	26	42	43	35
11	Juliana 31	26	47	44	34
12	Deurne	26	37	45	33
13	Papendrecht	26	25	33	32
14	Schijndel	26	32	55	17

TEMPORADA 2009/2010

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gemert	26	48	27	54
2	Baronie	26	42	19	52
3	EVV	26	43	33	46
4	JVC Cuijk	26	53	36	45
5	Dijkse Boys	26	53	40	43
6	Venray	26	59	40	41
7	UNA	26	45	38	37
8	Meerssen	26	38	51	31
9	UDI '19	26	37	44	30
10	Rosmalen	26	34	44	30
11	Papendrecht	26	40	59	30
12	Schijndel	26	35	40	28
13	DESK	26	33	61	26
14	OSS '20	26	27	55	13

TEMPORADA 2008/2009

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Baronie	26	47	28	53
2	Gemert	26	50	20	52
3	EVV	25	39	23	48
4	UNA	26	45	37	40
5	Dijkse Boys	26	39	31	40
6	DESK	26	39	52	36
7	Meerssen	26	40	46	35
8	Papendrecht	26	30	38	34
9	JVC Cuijk	26	41	39	33
10	Venray	25	53	47	32
11	Schijndel	26	29	31	31
12	Deurne	26	30	33	30
13	Rosmalen	26	29	34	25
14	LONGA	26	25	77	10

TEMPORADA 2007/2008

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deurne	26	45	22	51
2	UNA	26	59	34	47
3	Papendrecht	26	43	30	45
4	Gemert	26	39	30	40
5	Baronie	26	43	38	40
6	Meerssen	26	37	43	36
7	DESK	26	44	52	36
8	EVV	26	54	41	35
9	JVC Cuijk	26	40	38	34
10	Dijkse Boys	26	38	52	31
11	Rosmalen	26	29	35	28
12	Schijndel	26	28	35	25
13	UDI '19	26	26	46	22
14	Geldrop	26	30	59	21

TEMPORADA 2006/2007

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	JVC Cuijk	26	60	25	51
2	EVV	26	42	31	47
3	Baronie	26	43	30	44
4	Schijndel	26	46	30	43
5	Gemert	26	51	36	42
6	UDI '19	26	39	31	42
7	Papendrecht	26	42	50	39
8	Rosmalen	26	50	38	37
9	Meerssen	26	43	39	37
10	UNA	26	45	35	36
11	Geldrop	26	37	34	33
12	Blauw Geel	26	29	43	30
13	Groene Ster	26	43	71	21
14	SV Triborgh	26	17	94	5

TEMPORADA 2005/2006

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schijndel	26	59	28	59
2	Gemert	25	43	23	49
3	JVC Cuijk	25	49	30	47
4	Meerssen	26	35	31	43
5	Geldrop	26	45	38	40
6	EVV	26	50	35	36
7	UNA	26	33	29	36
8	UDI '19	26	39	41	34
9	Baronie	26	38	40	33
10	Papendrecht	26	34	36	32
11	SV Triborgh	26	39	51	29
12	Deurne	25	31	43	27
13	Amateurs	26	22	61	17
14	Panningen	25	28	59	16

TEMPORADA 2004/2005

HOOFDKLASSE ZONDAG GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Schijndel	26	67	27	58
2	Gemert	26	54	26	54
3	Baronie	26	50	35	46
4	EVV	26	49	39	42
5	JVC Cuijk	26	44	42	40
6	Meerssen	26	55	54	39
7	UDI '19	26	42	43	38
8	Geldrop	25	47	35	36
9	Deurne	26	34	40	35
10	Amateurs	26	49	55	28
11	UNA	26	29	44	27
12	Internos	26	31	49	25
13	Groene Ster	26	34	57	21
14	Vinkenslag	25	30	69	17

Competiciones que juega

Grupo 2

Derde Divisie Grupo 2

Pos	Equipos		Pts
1		SteDoCo	61
2		BVV Barendrecht	61
3		Blauw Geel '38	57
4		SV TEC Tiel	56
5		Meerssen	50
6		Sportlust 46	49
7		Gemert	49
8		TOGB	46
9		Kloetinge	46
10		UNA	44
11		HV & CV Quick	43
12		Hoek	41
13		OSS '20	33
14		OJC Rosmalen	31
15		AWC	29
16		Groene Ster	26
17		GVV Unitas	23
18		Baronie	13

	Ascenso : SteDoCo
	Playoff Descenso : AWC, Groene Ster
	Descenso : GVV Unitas, Baronie

RIVALES EN KNVB Beker

RIVALES EN Derde Divisie

USO DE MEMORIA

7,615,912 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1268
Total Execution Time	0.1282

CADENA URL

/historico/Una

GET DATOS

$_GET['/historico/Una']

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12273 AND type_rel = 2
0.0026	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 = '12273' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 72700 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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=12273 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 (72700,72637,67320) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 72700 AND teamId = 12273
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 72637 AND teamId = 12273
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 12273
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 = 72700 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0030	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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 12273 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.0028	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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 12273 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 72700 WHERE rp.league_id = 72700 AND rp.teamId = 12273 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 12273 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029	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.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* `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.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* `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.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* `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 = 50981 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.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* `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 = 44606 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 38964 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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.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* `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.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* `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.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* `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.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* `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 = 2187 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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.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 = 20401 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* `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 = 20404 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 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 = 20407 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* `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 = 20410 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* `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 = 20413 AND t.round = 26 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* `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 = 20416 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 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 = 20420 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 72700 ORDER BY nameShow LIMIT 100

UNA

UNA

Selecciona un equipo

Competiciones que juega

Derde Divisie Grupo 2

RIVALES EN KNVB Beker

RIVALES EN Derde Divisie