31 May 87	Finalizado	Sporting Braga	1 - 1	Benfica
24 May 87	Finalizado	Benfica	2 - 1	Sporting CP
17 May 87	Finalizado	Os Belenenses	1 - 1	Benfica
03 May 87	Finalizado	Benfica	1 - 1	Portimonense
26 Abr 87	Finalizado	Académica	0 - 0	Benfica
12 Abr 87	Finalizado	Benfica	1 - 0	SC Salgueiros
04 Abr 87	Finalizado	Rio Ave	0 - 2	Benfica
22 Mar 87	Finalizado	Benfica	0 - 0	Chaves
14 Mar 87	Finalizado	Vitória Guimarães	1 - 2	Benfica
01 Mar 87	Finalizado	Boavista	0 - 2	Benfica
22 Feb 87	Finalizado	Benfica	2 - 0	O Elvas
01 Feb 87	Finalizado	Farense	0 - 2	Benfica
25 Ene 87	Finalizado	Benfica	3 - 1	Marítimo
10 Ene 87	Finalizado	Varzim	0 - 0	Benfica
04 Ene 87	Finalizado	Benfica	3 - 1	Porto
28 Dic 86	Finalizado	Benfica	2 - 1	Sporting Braga
14 Dic 86	Finalizado	Sporting CP	7 - 1	Benfica
07 Dic 86	Finalizado	Benfica	2 - 0	Os Belenenses
30 Nov 86	Finalizado	Portimonense	0 - 3	Benfica
16 Nov 86	Finalizado	Benfica	2 - 0	Académica
09 Nov 86	Finalizado	SC Salgueiros	1 - 1	Benfica
01 Nov 86	Finalizado	Benfica	3 - 1	Rio Ave
19 Oct 86	Finalizado	Chaves	1 - 2	Benfica
05 Oct 86	Finalizado	Benfica	1 - 0	Vitória Guimarães
27 Sep 86	Finalizado	Benfica	3 - 1	Boavista
21 Sep 86	Finalizado	O Elvas	0 - 2	Benfica
13 Sep 86	Finalizado	Benfica	1 - 0	Farense
07 Sep 86	Finalizado	Marítimo	2 - 2	Benfica
31 Ago 86	Finalizado	Benfica	2 - 0	Varzim
24 Ago 86	Finalizado	Porto	2 - 2	Benfica

Taça de Portugal »

07 Jun 87	Finalizado	Benfica	2 - 1	Sporting CP
10 May 87	Finalizado	Benfica	4 - 0	Portimonense
18 Abr 87	Finalizado	Boavista	1 - 3	Benfica
08 Mar 87	Finalizado	Benfica	6 - 1	Torreense

Supercopa Portugal »

	26 Nov 86	Finalizado	Benfica	2 - 4	Porto			0
	19 Nov 86	Finalizado	Porto	1 - 1	Benfica			0

Recopa de Europa »

05 Nov 86	Finalizado	Girondins Bordeaux	1 - 0	Benfica
22 Oct 86	Finalizado	Benfica	1 - 1	Girondins Bordeaux
01 Oct 86	Finalizado	Lillestrom SK	1 - 2	Benfica
17 Sep 86	Finalizado	Benfica	2 - 0	Lillestrom SK

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del Benfica Temporada 1986/1987

		Edad	Altura	Peso
Portero
	Barros Neno	62	-	-	-	-	-
	M. Bento	75	-	-	-	-	1
	Silvino Louro	65	-	-	-	-	-
Defensa
	Á. Monteiro	63	-	-	2	-	3
	António Veloso	67	-	-	-	-	3
	Bastos Lopes	70	-	-	-	-	-
	Dito	62	-	-	1	-	-
	Edmundo	60	186	74	2	-	-
	Minervino Pietra	70	172	65	-	-	-
	Oliveira	65	187	80	-	-	-
	Samuel Quina	57	-	-	-	-	-
Centrocampista
	Adelino Nunes	63	-	-	8	-	2
	Carlos Manuel	66	176	73	3	-	1
	José Luis	65	175	-	-	-	-
	M. Diamantino	64	-	-	4	-	1
	Paulo Guilherme	57	-	-	-	-	-
	Rui Pedro	57	179	76	-	-	-
	Sheu Han	70	178	-	-	-	-
	Tueba	61	174	76	1	-	-
	Wando	61	180	85	2	-	1
Delantero
	César Brito	59	176	73	-	-	-
	Chiquinho Carlos	61	-	-	9	-	-
	Michael Manniche	64	-	-	5	-	-
	Rui Águas	63	-	-	13	-	1
	Z. Živković	64	186	76	-	-	-

Noticias del Benfica

Ver últimas noticias

Difícil, pero no imposible

BeSoccer - Domingo, 28 Abril 2024

0 1.102

El Benfica remontó al Sporting Braga (3-1) en la jornada 31 de la Liga Portuguesa. En el mejor de los casos, el cuadro de Roger Schmidt se quedará a 4 puntos del Sporting CP con 9 por disputar. En el peor, a 7 en la carrera final por el título.

30 millones para convencer a Gaitán

BeSoccer - Jueves, 02 Julio 2015

0 169

El Benfica quiere que el club colchonero pague la cláusula de rescisión y seguirá negociando.

El Atlético le echa el ojo a Gaitán

BeSoccer - Miércoles, 01 Julio 2015

0 146

El centrocampista Nico Gaitán podría ser el hombre que busca el Atlético para sustituir a Arda Turan. El club madrileño ya habría intentado hacerse con sus servicios la pasada campaña y, ahora, vuelve a lanzarse a por su fichaje.

El Valencia adquiere en propiedad al delantero internacional Rodrigo Moreno

BeSoccer - Lunes, 22 Junio 2015

0 496

El Valencia ha comunicado que ha llegado a un acuerdo con el SL Benfica para la compra del futbolista Rodrigo Moreno, que ha firmado su contrato por cuatro temporadas, hasta el 30 de junio de 2019.

El portugués André Gomes firma con el Valencia por cinco temporadas

BeSoccer - Lunes, 22 Junio 2015

0 246

El portugués André Gomes ha firmado con el Valencia por cinco temporadas tras militar en el club valenciano el pasado año en calidad de cedido y después de llegar a un acuerdo para su traspaso con el Benfica, que hasta ahora era su propietario.

Ver más noticias del equipo»

Competiciones que juega

Liga Portuguesa

Pos	Equipos		Pts
1		Benfica	49
2		Porto	46
3		Vitória Guimarães	41
4		Sporting CP	38
5		Chaves	33
6		Os Belenenses	30
7		Varzim	29
8		Boavista	27
9		Sporting Braga	26
10		Académica	26
11		Portimonense	26
12		Marítimo	25
13		Rio Ave	25
14		SC Salgueiros	24
15		Farense	21
16		O Elvas	14

	Copa de Europa : Benfica, Porto
	UEFA : Vitória Guimarães, Chaves, Os Belenenses
	Recopa : Sporting CP

RIVALES EN Liga Portuguesa

RIVALES EN Recopa de Europa

RIVALES EN Supercopa Portug.

RIVALES EN Taça de Portugal

USO DE MEMORIA

6,236,728 bytes

BENCHMARKS

Loading Time Base Classes	0.0028
Controller Execution Time ( Home / Category )	0.7706
Total Execution Time	0.7734

CADENA URL

/Benfica/1987

GET DATOS

$_GET['/Benfica/1987']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0126	SELECT type FROM routes WHERE alias = 'benfica'
0.0186	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 = 'Benfica' AND l.year = 1987 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.0129	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=466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135	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=466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=466 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0135	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 = 5754
0.0132	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 = 22925
0.0131	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 = 25337
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=466 AND type_rel = 2
0.0167	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 466 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127	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 (1312903,286,372,1185,1301) ORDER BY n.cover_points DESC, update_date DESC
0.0143	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 = '466' AND l.year = 1987 ORDER BY l.year DESC,cat.coefficient DESC
0.0145	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 = '466' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 5754 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 25337 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 22925 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0202	(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 calendars1987 as c ON c.league_id = l.id WHERE (c.datateam1 = 466 or c.datateam2 = 466) AND l.year = 1987 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0223	(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 calendars1987 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 = 466 or c.datateam2 = 466) AND l.year = 1987 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0313	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1987 as c ON c.league_id = l.id INNER JOIN events1987 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 = 466 or c.datateam2 = 466) AND l.year = 1987)
0.0149	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=466 AND l.year in (1986,1987,1988) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (73126,72715,25338,22926,11043,10916,5755) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 5755 AND teamId = 466
0.0161	SELECT count(id) as num_players from rel_players WHERE league_id = 10916 AND teamId = 466
0.0167	SELECT count(id) as num_players from rel_players WHERE league_id = 22926 AND teamId = 466
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 25338 AND teamId = 466
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 11043 AND teamId = 466
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 72715 AND teamId = 466
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 73126 AND teamId = 466
0.0134	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1987` 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 = 5754 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0176	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 events1987 e ON e.player_id = p.id AND e.league_id = 5754 WHERE rp.league_id = 5754 AND rp.teamId = 466 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.0198	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 events1987 e ON e.player_id = p.id AND e.league_id = 5754 WHERE rp.league_id = 5754 AND rp.teamId = 466 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162	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 events1987 e ON e.player_id = p.id AND e.league_id = 5754 WHERE rp.league_id = 5754 AND rp.teamId = 466 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 466 AND rp.league_id = 5754 AND l.year= 1987 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0132	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=98604 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=98604
0.0136	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=98604 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.0133	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=98604 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0155	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=98604 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0143	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=98604 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0143	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 events1987 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=98604 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Benfica

Información sobre Benfica

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Benfica