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

Eendracht Aalst

Temporada 2023/2024

TEMPORADA 2023/2024

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Eendracht	31	56	31	61
2	Ninove	31	51	39	55
3	Dikkelvenne	32	64	44	55
4	Merelbeke	32	63	40	51
5	Jong Essevee	32	52	39	48
6	Cercle	31	59	47	47
7	Voorde	32	48	53	47
8	Oostkamp	32	54	64	46
9	Oudenaarde	32	39	38	44
10	Gullegem	32	52	61	43
11	KRC Gent	32	51	51	42
12	Torhout	32	43	60	41
13	Zelzate	31	57	54	39
14	Olsa Brakel	31	37	38	39
15	Mandel	32	27	40	37
16	Racing Club	31	43	53	33
17	Sparta	31	42	59	29
18	Wetteren	31	45	72	29

TEMPORADA 2022/2023

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Lokeren-Tems	34	66	35	73
2	Sparta	34	68	55	59
3	Oostkamp	34	77	51	58
4	Cercle	34	54	43	55
5	KRC Gent	34	63	51	53
6	Merelbeke	34	47	36	53
7	Eendracht	34	55	44	51
8	Jong Essevee	34	64	49	50
9	Dikkelvenne	34	53	55	50
10	Oudenaarde	34	60	64	49
11	Zelzate	34	53	55	45
12	Torhout	34	57	46	44
13	Olsa Brakel	34	49	54	44
14	Gullegem	34	57	53	41
15	Racing Club	34	46	60	41
16	Westhoek	34	44	66	35
17	Standaard	34	41	67	35
18	Erpe-Mere	34	23	93	9

TEMPORADA 2021/2022

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Hoogstraten	30	72	22	70
2	Eendracht	30	61	35	57
3	Lyra-Lierse	30	52	29	57
4	Cappellen	30	53	40	53
5	Belisia	30	44	32	52
6	Bocholt	30	47	38	51
7	City Pirates	30	44	56	43
8	Londerzeel	30	36	37	38
9	Diegem Sport	30	36	45	35
10	Sporting	30	38	50	34
11	Berchem	30	36	45	33
12	Hades	30	34	45	32
13	Heur	30	37	49	32
14	Pepingen-Hal	30	34	51	28
15	Houtvenne	30	30	52	26
16	Olympia	30	30	58	25

TEMPORADA 2020/2021

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bocholt	4	11	5	10
2	Hoogstraten	4	9	4	7
3	Lyra-Lierse	4	7	4	7
4	Sporting	3	6	3	7
5	Diegem Sport	4	8	7	7
6	Londerzeel	4	7	9	7
7	Hades	3	9	3	6
8	Pepingen-Hal	3	5	3	6
9	Berchem	3	4	3	5
10	Houtvenne	4	4	7	4
11	Cappellen	3	6	6	3
12	Belisia	3	5	8	3
13	Heur	3	1	7	1
14	Eendracht	2	1	3	0
15	City Pirates	2	3	7	0
16	Olympia	3	2	9	0

TEMPORADA 2019/2020

DIVISIÓN BELGA 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tienen	24	43	30	47
2	Eendracht	24	43	27	44
3	Bocholt	24	40	26	43
4	Cappellen	24	36	28	37
5	Sporting	24	31	31	37
6	Hades	23	33	30	34
7	Diegem Sport	23	29	27	34
8	Vosselaar	23	35	33	32
9	Berchem	24	35	38	31
10	Londerzeel	24	32	39	28
11	Geel-Meerhou	24	29	35	27
12	Olympia	24	38	40	26
13	Pepingen-Hal	24	24	32	25
14	KFC Duffel	19	32	32	24
15	Hoogstraten	23	27	31	24
16	Belisia	23	23	51	21

TEMPORADA 2018/2019

DIVISIÓN NACIONAL BELGA 1
Equipo		PJ	GF	GC	Puntos
1	Thes Sport	30	62	28	62
2	Deinze	30	53	30	59
3	Excelsior	30	42	20	54
4	Lierse	30	42	36	48
5	Rupel Boom	30	44	40	45
6	RFC Seraing	30	46	40	41
7	RFC Liège	30	41	35	41
8	Molenbeek	30	39	45	40
9	FCV Dender	30	42	40	40
10	Heist	30	29	44	38
11	Châtelet	30	30	37	36
12	Dessel Sport	30	30	39	35
13	Oudenaarde	30	37	59	34
14	Eendracht	30	35	49	31
15	Geel-Meerhou	30	42	62	31
16	Knokke	30	35	45	24

TEMPORADA 2017/2018

DIVISIÓN NACIONAL BELGA 1
Equipo		PJ	GF	GC	Puntos
1	Lommel SK	30	69	20	71
2	Knokke	30	69	32	61
3	Dessel Sport	30	53	29	60
4	Deinze	30	44	30	50
5	RFC Seraing	30	50	34	48
6	Heist	30	47	45	47
7	Oudenaarde	30	50	36	45
8	Eendracht	30	48	46	44
9	Geel-Meerhou	30	47	53	39
10	Excelsior	30	40	45	37
11	FCV Dender	30	39	52	36
12	Oosterwijk	30	39	47	34
13	Châtelet	30	34	53	29
14	VW Hamme	30	32	59	28
15	Berchem	30	34	53	25
16	Patro Eisden	30	18	79	14

TEMPORADA 2016/2017

DIVISIÓN BELGA 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Knokke	30	73	25	72
2	Sparta	30	60	44	58
3	Eendracht	30	55	37	56
4	Winkel Sport	30	55	30	53
5	Izegem	30	53	42	53
6	Olsa Brakel	30	59	51	43
7	Temse	30	38	45	42
8	KRC Gent	30	46	43	41
9	Torhout	30	36	45	39
10	Gullegem	30	46	52	37
11	Sint-Niklaas	30	45	49	35
12	Bornem	30	31	39	34
13	Racing Club	30	36	45	34
14	Westhoek	30	40	56	34
15	Halle	30	27	55	23
16	KSCT Menen	30	35	77	16

TEMPORADA 2015/2016

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	VW Hamme	34	66	31	68
2	Winkel Sport	34	61	43	63
3	Oudenaarde	34	70	45	60
4	FCV Dender	34	69	43	59
5	Londerzeel	34	58	37	59
6	Sparta	34	66	54	56
7	Eendracht	34	66	55	54
8	Temse	34	60	48	53
9	Louvière	34	54	44	50
10	Olsa Brakel	34	56	46	46
11	Gullegem	34	50	45	45
12	KRC Gent	34	50	56	43
13	Sint-Niklaas	34	51	57	42
14	Bornem	34	54	56	38
15	Izegem	34	51	73	28
16	Torhout	34	29	75	28
17	Acren	34	37	91	23
18	Racing	34	33	82	22

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Sint-Truiden	34	62	28	79
2	Lommel SK	34	65	27	70
3	KAS Eupen	34	63	30	67
4	RFC Seraing	34	69	39	61
5	OH Leuven	34	66	39	61
6	Excelsior	34	58	35	59
7	Mons	34	52	30	55
8	Tubize	34	43	40	50
9	Eendracht	34	48	45	46
10	Antwerp	34	41	41	42
11	Roeselare	34	44	45	42
12	Bruxelles	34	43	48	40
13	Geel-Meerhou	34	42	62	39
14	Heist	34	41	61	36
15	Dessel Sport	34	36	58	31
16	Patro Eisden	34	38	68	26
17	Racing	34	23	87	19
18	Woluwe	34	30	81	15

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Westerlo	34	67	23	78
2	KAS Eupen	34	75	27	74
3	Sint-Truiden	34	47	31	67
4	Mouscron	34	53	27	66
5	Lommel SK	34	56	34	59
6	Tubize	34	59	45	54
7	Antwerp	33	44	31	46
8	Molenbeek	34	38	41	45
9	Borinage	34	45	51	45
10	Geel-Meerhou	34	45	49	43
11	Eendracht	34	37	49	42
12	Bruxelles	34	37	38	40
13	Excelsior	33	47	45	38
14	Dessel Sport	34	37	60	35
15	Roeselare	34	41	62	35
16	Heist	34	38	74	31
17	Hoogstraten	34	33	61	28
18	Visé	34	26	77	13

TEMPORADA 2012/2013

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	KV Oostende	34	61	27	75
2	Mouscron	34	58	29	67
3	Westerlo	34	54	29	63
4	Sint-Truiden	34	54	36	57
5	Borinage	34	44	34	55
6	White Star.	34	44	39	53
7	Lommel SK	34	50	48	50
8	KAS Eupen	34	44	37	49
9	Tubize	34	43	42	46
10	Antwerp	34	42	44	45
11	Roeselare	34	44	47	42
12	Dessel Sport	34	35	42	41
13	Eendracht	34	38	52	41
14	Visé	34	47	57	33
15	Brussels	34	32	49	33
16	Heist	34	39	57	30
17	Sint-Niklaas	34	34	64	30
18	Oudenaarde	34	31	61	30

TEMPORADA 2011/2012

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Charleroi	34	64	34	74
2	KAS Eupen	34	61	34	68
3	SK Beveren	34	61	34	68
4	KV Oostende	34	61	29	66
5	Lommel SK	34	48	42	52
6	White Star.	34	48	43	51
7	Heist	34	46	46	46
8	Eendracht	34	46	52	46
9	Visé	34	44	41	44
10	Antwerp	34	39	42	43
11	Borinage	34	44	54	42
12	Tubize	34	36	55	41
13	Roeselare	34	46	51	40
14	Brussels	34	44	46	38
15	Sint-Niklaas	34	41	54	34
16	FCV Dender	34	33	43	33
17	Tienen	34	34	61	33
18	Standaard	34	19	54	21

TEMPORADA 2010/2011

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Eendracht	34	71	29	74
2	Hoogstraten	34	74	39	62
3	Deinze	34	62	54	59
4	Coxyde	34	70	54	58
5	Dessel Sport	34	56	38	57
6	Oudenaarde	34	57	49	55
7	Sint-Niklaas	34	47	36	54
8	Geel-Meerhou	34	51	45	53
9	Ronse	34	42	39	45
10	VW Hamme	34	40	49	43
11	Torhout	34	43	57	42
12	Temse	34	45	61	42
13	Olsa Brakel	34	53	64	38
14	Racing	34	31	50	38
15	Bornem	34	44	48	37
16	Cappellen	34	45	51	35
17	Izegem	34	44	57	34
18	Wielsbeke	34	31	86	18

TEMPORADA 2009/2010

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Heist	36	73	34	76
2	Rupel Boom	36	82	46	72
3	Eendracht	36	82	44	67
4	Deinze	36	50	38	60
5	Temse	36	61	61	56
6	Coxyde	36	67	43	55
7	VW Hamme	36	59	51	55
8	Hoogstraten	36	59	55	50
9	Sint-Niklaas	36	62	55	49
10	Oudenaarde	36	62	62	48
11	Racing	36	43	51	48
12	Torhout	36	49	51	45
13	Wielsbeke	36	50	62	45
14	Ternat	36	53	72	41
15	Cappellen	36	40	62	39
16	Sottegem	36	32	65	38
17	Westhoek	36	53	70	37
18	Racing	36	52	71	37
19	Willebroek-M	36	40	76	30

TEMPORADA 2008/2009

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Standaard	30	68	30	64
2	Woluwe	30	46	22	60
3	Francs	30	62	31	55
4	Diegem Sport	30	43	27	54
5	Louvière	30	56	45	45
6	Sottegem	30	35	30	45
7	Oudenaarde	30	43	40	45
8	Racing	30	40	37	45
9	Sint-Niklaas	30	55	44	43
10	Bruxelles	30	44	45	39
11	Eendracht	30	38	50	38
12	Union	30	39	43	33
13	RAAL	30	36	61	28
14	Wielsbeke	30	40	58	27
15	Mouscron	30	27	83	27
16	KRC Gent	30	39	65	22

TEMPORADA 2007/2008

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ronse	30	49	23	57
2	RAAL	30	41	23	54
3	Mouscron	30	49	37	54
4	Racing	30	42	30	51
5	Racing	30	34	28	50
6	Sottegem	30	37	34	48
7	Eendracht	30	50	32	46
8	Willebroek-M	30	45	39	43
9	Sint-Niklaas	30	46	37	40
10	Francs	30	38	40	39
11	Diegem Sport	30	31	39	39
12	Oudenaarde	30	39	43	34
13	Standaard	30	34	51	33
14	Londerzeel	30	34	40	30
15	Torhout	30	39	70	24
16	Charleroi	30	29	71	19

TEMPORADA 2005/2006

DIVISIÓN BELGA 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	FCV Dender	30	66	36	65
2	Cappellen	30	67	33	59
3	Standaard	30	54	41	52
4	Sint-Niklaas	30	55	30	48
5	Racing Club	30	48	39	48
6	Racing	30	44	37	48
7	Turnhout	30	52	40	44
8	Diegem Sport	30	36	44	44
9	Bruxelles	30	44	46	42
10	Torhout	30	51	47	41
11	Willebroek-M	30	42	48	37
12	Racing	30	37	44	35
13	Maldegem	29	39	56	28
14	Eendracht	29	28	66	22
15	Rupel Boom	30	29	59	19
16	Bornem	30	22	48	18

TEMPORADA 2004/2005

SEGUNDA DIVISIÓN BÉLGICA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Zulte-Warege	34	71	35	73
2	Roeselare	34	51	31	60
3	Verbroederin	34	49	36	56
4	Antwerp	34	48	40	50
5	SK Beveren	34	51	55	50
6	Kortrijk	34	56	48	48
7	Tubize	34	54	49	48
8	Ronse	34	42	51	48
9	Beringen	34	41	41	47
10	Deinze	34	47	59	43
11	KAS Eupen	34	52	46	41
12	VW Hamme	34	50	47	41
13	Excelsior	34	43	54	41
14	Union	34	41	53	39
15	Dessel Sport	34	31	46	39
16	Visé	34	52	54	37
17	Patro Eisden	34	35	53	37
18	Eendracht	34	41	57	34

TEMPORADA 2003/2004

SEGUNDA DIVISIÓN BÉLGICA
Equipo		PJ	GF	GC	Puntos
1	Molenbeek	34	79	29	70
2	KV Oostende	34	69	43	65
3	Roeselare	34	59	38	63
4	Tubize	34	60	33	58
5	Zulte-Warege	34	58	45	52
6	Excelsior	34	38	33	51
7	Deinze	34	45	46	50
8	Patro Eisden	34	47	50	49
9	Dessel Sport	34	41	42	48
10	Verbroederin	34	38	41	47
11	VW Hamme	34	43	44	46
12	Eendracht	34	54	59	45
13	Visé	34	48	59	44
14	KAS Eupen	34	32	41	37
15	Ronse	34	27	46	32
16	Racing Club	34	41	61	31
17	Tienen	34	30	64	25
18	Denderleeuw	34	32	67	22

Competiciones que juega

Grupo 2

División Belga 2 Grupo 2

Pos	Equipos		Pts
1		Eendracht Aalst	61
2		Ninove	55
3		Dikkelvenne	55
4		Merelbeke	51
5		Jong Essevee	48
6		Cercle Brugge Sub 21	47
7		Voorde Appelterre	47
8		Oostkamp	46
9		Oudenaarde	44
10		Gullegem	43
11		KRC Gent	42
12		Torhout	41
13		Zelzate	39
14		Olsa Brakel	39
15		Mandel United	37
16		Racing Club Harelbeke	33
17		Sparta Petegem	29
18		Wetteren	29

	Ascenso : Eendracht Aalst
	Playoff Ascenso : Ninove, Dikkelvenne, Merelbeke, Jong Essevee
	Playoff Descenso : Racing Club Harelbeke
	Descenso : Sparta Petegem, Wetteren

RIVALES EN División Belga 2

RIVALES EN Copa Belga

USO DE MEMORIA

7,872,432 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1401
Total Execution Time	0.1414

CADENA URL

/historico/Eendracht-Aalst

GET DATOS

$_GET['/historico/Eendracht-Aalst']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7518 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=241 AND type_rel = 3
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 241 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	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 (900137,520396,273795,255821,104680) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '7518' 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 = 72695 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=7518 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 (73206,72695,71730,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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72695 AND teamId = 7518
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 7518
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71730 AND teamId = 7518
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 7518
0.0042	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 = 72695 AND t.round = 33 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = 72695 WHERE rp.league_id = 72695 AND rp.teamId = 7518 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.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 = 72695 WHERE rp.league_id = 72695 AND rp.teamId = 7518 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 72695 WHERE rp.league_id = 72695 AND rp.teamId = 7518 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 7518 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 = 68501 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* `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 = 63434 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.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* `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 = 57813 AND t.round = 15 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* `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 = 50976 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 = 44699 AND t.round = 30 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 = 38873 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* `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 = 33882 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* `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 = 15755 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* `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 = 3908 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 2473 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 2016 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* `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 = 1741 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* `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 = 24294 AND t.round = 34 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* `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 = 24297 AND t.round = 38 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* `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 = 24299 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* `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 = 24303 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* `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 = 24319 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* `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 = 13511 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* `tables2004` 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 = 13510 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Eendracht Aalst

Eendracht Aalst

Selecciona un equipo

Competiciones que juega

División Belga 2 Grupo 2

RIVALES EN División Belga 2

RIVALES EN Copa Belga