11 Ene 20	Finalizado	Livingston	1 - 1	Anderlecht	0
31 Jul 19	Finalizado	Anderlecht	1 - 2	Fortuna Düsseldorf	11
23 Jul 19	Finalizado	Anderlecht	1 - 3	PAOK	8
20 Jul 19	Finalizado	Hamburger SV	2 - 2	Anderlecht	3
10 Jul 19	Finalizado	Benfica	1 - 2	Anderlecht	16

Liga Belga »

~~15 Mar 20~~	Aplazado	Sint-Truidense V.V.	-	Anderlecht	3
07 Mar 20	Finalizado	Anderlecht	7 - 0	Zulte-Waregem	1
29 Feb 20	Finalizado	SK Beveren	0 - 3	Anderlecht	0
23 Feb 20	Finalizado	Anderlecht	6 - 1	KAS Eupen	1
15 Feb 20	Finalizado	KV Mechelen	2 - 0	Anderlecht	8
07 Feb 20	Finalizado	KAA Gent	1 - 1	Anderlecht	29
02 Feb 20	Finalizado	Anderlecht	1 - 0	Mouscron	5
26 Ene 20	Finalizado	Cercle Brugge	1 - 2	Anderlecht	3
19 Ene 20	Finalizado	Anderlecht	1 - 2	Club Brugge	28
27 Dic 19	Finalizado	Antwerp	0 - 0	Anderlecht	196
22 Dic 19	Finalizado	Anderlecht	2 - 0	Genk	27
15 Dic 19	Finalizado	Standard de Liège	1 - 1	Anderlecht	8
08 Dic 19	Finalizado	Anderlecht	0 - 0	Charleroi	18
01 Dic 19	Finalizado	KV Oostende	3 - 2	Anderlecht	5
24 Nov 19	Finalizado	Anderlecht	0 - 0	Kortrijk	17
08 Nov 19	Finalizado	Zulte-Waregem	1 - 2	Anderlecht	8
03 Nov 19	Finalizado	Anderlecht	2 - 1	Cercle Brugge	4
31 Oct 19	Finalizado	Anderlecht	3 - 3	KAA Gent	16
25 Oct 19	Finalizado	KAS Eupen	0 - 0	Anderlecht	21
20 Oct 19	Finalizado	Anderlecht	4 - 1	Sint-Truidense V.V.	0
04 Oct 19	Finalizado	Charleroi	1 - 2	Anderlecht	6
29 Sep 19	Finalizado	Anderlecht	0 - 0	SK Beveren	11
22 Sep 19	Finalizado	Club Brugge	2 - 1	Anderlecht	4
15 Sep 19	Finalizado	Anderlecht	1 - 2	Antwerp	12
01 Sep 19	Finalizado	Anderlecht	1 - 0	Standard de Liège	31
23 Ago 19	Finalizado	Genk	1 - 0	Anderlecht	12
17 Ago 19	Finalizado	Kortrijk	4 - 2	Anderlecht	8
09 Ago 19	Finalizado	Anderlecht	0 - 0	KV Mechelen	48
04 Ago 19	Finalizado	Mouscron	0 - 0	Anderlecht	7
28 Jul 19	Finalizado	Anderlecht	1 - 2	KV Oostende	8

Copa Belga »

19 Dic 19	Finalizado	Anderlecht	0 - 2	Club Brugge	53
05 Dic 19	Finalizado	Mouscron	2 - 3	Anderlecht	5
25 Sep 19	Finalizado	Beerschot VA	2 - 3	Anderlecht	2

Estadísticas

GOLEADORES

M. Vlap11

AMARILLAS

ROJAS

Plantilla del Anderlecht Temporada 2019/2020

		Edad	Altura	Peso
Portero
33	Davy Roef	30	187	84	-	-	-
	F. Boeckx	37	183	76	-	-	-
30	H. Van Crombrugge	30	187	86	-	-	-
70	R. Vercauteren	22	186	74	-	-	-
Defensa
	A. Najar	31	171	68	-	-	-
	A. Vanden Borre	36	185	80	-	-	-
32	D. Luckassen	28	186	79	-	-	2
22	E. Cobbaut	26	188	77	-	-	-
54	K. Sardella	21	174	64	-	-	2
47	Lucas Lissens	22	184	74	-	-	-
34	P. Sandler	27	190	82	-	-	3
43	T. Lutonda	23	167	62	-	-	-
4	V. Kompany	38	190	91	1	-	2
Centrocampista
46	A. El Hadj	22	167	70	-	-	-
48	A. Lokonga	24	183	70	-	1	4
25	Adrien Trebel	33	174	70	-	-	1
39	Edo Kayembe	25	183	70	-	-	3
10	M. Vlap	26	190	69	11	-	1
55	Marco Kana	21	182	62	1	-	3
8	P. Gerkens	29	179	63	-	-	-
23	P. Zulj	30	185	80	-	-	4
50	S. Dewaele	25	180	69	-	1	4
14	S. Nasri	36	178	75	1	-	1
51	Y. Verschaeren	22	170	63	2	-	1
Delantero
53	A. Colassin	23	186	73	3	-	-
28	Dejan Joveljić	24	180	72	-	-	1
40	Francis Amuzu	24	169	65	3	-	2
49	Jérémy Doku	21	173	68	3	1	4
93	K. Roofe	31	178	71	6	-	2
	L. Dimata	26	185	80	-	-	-
20	Marko Pjaca	28	186	81	1	-	-
19	N. Chadli	34	187	80	8	-	2
99	Z. Bakkali	28	170	60	1	-	1

Noticias del Anderlecht

Ver últimas noticias

El Newcastle ficha al defensa congolés Chancel Mbemba

BeSoccer - Lunes, 27 Julio 2015

2 2.618

El Newcastle ha anunciado hoy mediante un comunicado en su página web que ha acordado con el Anderlecht el fichaje del joven defensa internacional congolés Chancel Mbemba.

Aleksandar Mitrovic, nuevo refuerzo del Newcastle

BeSoccer - Martes, 21 Julio 2015

0 519

El delantero Aleksandar Mitrovic cambia el Anderlecht y la Liga belga por el Newcastle y la Premier.

Borja Bastón, clave en el futuro de Mbemba

BeSoccer - Lunes, 06 Julio 2015

0 1.831

El Anderlecht podría pedir al canterano colchonero Borja Bastón a cambio de Mbemba.

Chacel Mbemba, ¿a un paso del Atleti?

BeSoccer - Lunes, 06 Julio 2015

0 228

El Atlético de Madrid podría fichar al jugador congoleño Chacel Mbemba por 10 millones de euros para suplir a Toby Alderweireld.

El Atlético va a por Mbemba

Manuel Gutiérrez - Domingo, 05 Julio 2015

0 908

Un central joven parece la solución a la salida de Miranda. Se trata de Chancel Mbemba, central de 20 años y que es una de las perlas de la cantera belga. Incluso, la web dh.be asegura podría pasar reconocimiento médico con el Atlético mañana mismo. El director deportivo del Anderlecht estuvo la semana pasada en Madrid.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Club Brugge	70
2		KAA Gent	55
3		Charleroi	54
4		Antwerp	53
5		Standard de Liège	49
6		KV Mechelen	44
7		Genk	44
8		Anderlecht	43
9		Zulte-Waregem	36
10		Mouscron	36
11		Kortrijk	33
12		Sint-Truidense V.V.	33
13		KAS Eupen	30
14		Cercle Brugge	23
15		KV Oostende	22
16		SK Beveren	20

Pos

Equipos

Pts

	Champions League : Club Brugge
	Previa de Champions : KAA Gent
	Europa League : Charleroi, Antwerp

Champions League : Club Brugge

Previa de Champions : KAA Gent

Europa League : Charleroi, Antwerp

USO DE MEMORIA

6,119,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0035
Controller Execution Time ( Home / Category )	0.5541
Total Execution Time	0.5576

CADENA URL

/Anderlecht/2020

GET DATOS

$_GET['/Anderlecht/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0105	SELECT type FROM routes WHERE alias = 'anderlecht'
0.0140	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 = 'Anderlecht' AND l.year = 2020 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.0106	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=218 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=218 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=218 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=218 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=218 AND type_rel = 2
0.0117	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 218 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1563,1633,1642,3232,3781) ORDER BY n.cover_points DESC, update_date DESC
0.0123	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 = '218' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0134	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 = '218' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0108	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 218 or c.datateam2 = 218) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0113	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 218 or c.datateam2 = 218) AND l.year = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0110	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 218 or c.datateam2 = 218) AND l.year = 2020)
0.0126	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=218 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0106	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 (62243,57008,56547,44993) 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.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 62243 AND teamId = 218
0.0106	SELECT count(id) as num_players from rel_players WHERE league_id = 44993 AND teamId = 218
0.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 57008 AND teamId = 218
0.0216	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 218
0.0110	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 = '218' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '218' and rp.type = 4
0.0110	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 = '218' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '218' and rp.type = 4
0.0128	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 events2020 e ON e.player_id = p.id AND e.league_id = 49865 WHERE rp.league_id = 49865 AND rp.teamId = 218 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.0122	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 events2020 e ON e.player_id = p.id AND e.league_id = 49865 WHERE rp.league_id = 49865 AND rp.teamId = 218 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 events2020 e ON e.player_id = p.id AND e.league_id = 49865 WHERE rp.league_id = 49865 AND rp.teamId = 218 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 218 AND rp.league_id = 49865 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0112	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6280140 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0105	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6280140
0.0114	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280140 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0115	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280140 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0125	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280140 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0111	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280140 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0115	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280140 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Anderlecht

Información sobre Anderlecht

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Anderlecht

Estadísticas

Plantilla del Anderlecht Temporada 2019/2020

Noticias del Anderlecht

Anderlecht

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Belga

RIVALES EN Liga Belga