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

Benfica

Entrenador: Roger Schmidt

Temporada 1996/1997

Información sobre Benfica

Enviar Datos

Información

Nombre del equipo Benfica
Nombre completo Sport Lisboa e Benfica
Nombre corto SLB
País Portugal
Ciudad Lisboa
Entrenador Roger Schmidt
URL del equipo en RF //m.resultados-futbol.com/Benfica

Otros Datos

Año de Fundación 1904
Patrocinador Fly Emirates
Patrocinador Secundario Sagres
Equipo Filial Benfica II
Marca de Ropa Adidas
Socios 200000

Internet

Sitio Web https://www.slbenfica.pt/
Twitter principal @SLBenfica

Información sobre el estadio

Nombre del estadio Estádio da Luz
Capacidad 65647
Dirección Rua José Maria Nicolau
Teléfono +351 (21) 721 9555
Fax +351 (21) 721 9551
Año de construcción 2001
Tamaño 105 x 68 metros

Histórico de participación

Liga Portuguesa

90 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1939, 1938, 1937, 1936, 1935)

Taça de Portugal

80 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1978, 1977, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1949, 1948, 1946, 1945, 1944, 1943, 1942, 1941, 1940, 1939)

Champions League Grupo 4

47 veces

(2024, 2023, 2023, 2022, 2022, 2020, 2019, 2018, 2017, 2017, 2016, 2016, 2015, 2014, 2013, 2012, 2012, 2011, 2008, 2007, 2006, 2006, 1999, 1995, 1995, 1992, 1990, 1988, 1985, 1984, 1982, 1978, 1977, 1976, 1974, 1973, 1972, 1970, 1969, 1968, 1966, 1965, 1964, 1963, 1962, 1961, 1958)

Europa League Grupo 0

27 veces

(2024, 2021, 2021, 2020, 2019, 2014, 2013, 2011, 2010, 2010, 2009, 2009, 2008, 2007, 2005, 2005, 2004, 2001, 2000, 1998, 1996, 1993, 1991, 1989, 1983, 1980, 1979)

Copa de la Liga Portugal Grupo 0

25 veces

(2024, 2024, 2023, 2022, 2022, 2021, 2020, 2019, 2019, 2018, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2013, 2012, 2011, 2010, 2010, 2009, 2009, 2008)

Supercopa Portugal

23 veces

(2024, 2021, 2020, 2018, 2017, 2016, 2015, 2011, 2006, 2005, 1997, 1995, 1994, 1992, 1990, 1988, 1987, 1986, 1985, 1984, 1982, 1981, 1945)

Fase Previa Champions League Grupo 4

15 veces

(2023, 2023, 2022, 2022, 2021, 2019, 2019, 2012, 2012, 2008, 2007, 2005, 2004, 1999, 1992)

Partidos Amistosos

14 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Recopa de Europa

7 veces

(1997, 1994, 1987, 1986, 1981, 1975, 1971)

Fases Previas Copa de la Liga Grupo 0

6 veces

(2017, 2015, 2014, 2013, 2012, 2011)

Fase Previa Europa League Grupo 4

1 vez

(2010)

Partidos del Benfica

Ir al LIVESCORE

Liga Portuguesa »

15 Jun 97	Finalizado	Os Belenenses	1 - 0	Benfica
30 May 97	Finalizado	Benfica	0 - 2	Vitória Guimarães
24 May 97	Finalizado	Porto	3 - 1	Benfica
18 May 97	Finalizado	Benfica	1 - 0	Leça FC
10 May 97	Finalizado	Marítimo	2 - 0	Benfica
04 May 97	Finalizado	Benfica	0 - 0	Rio Ave
26 Abr 97	Finalizado	Farense	1 - 2	Benfica
20 Abr 97	Finalizado	Benfica	2 - 0	Espinho
12 Abr 97	Finalizado	Boavista	1 - 1	Benfica
05 Abr 97	Finalizado	Benfica	1 - 0	Sporting CP
24 Mar 97	Finalizado	Estrela Amadora	1 - 1	Benfica
16 Mar 97	Finalizado	Benfica	3 - 4	SC Salgueiros
01 Mar 97	Finalizado	Chaves	3 - 1	Benfica
23 Feb 97	Finalizado	Benfica	1 - 0	União de Leiria
15 Feb 97	Finalizado	Vitória Setúbal	0 - 2	Benfica
08 Feb 97	Finalizado	Benfica	1 - 0	Gil Vicente
01 Feb 97	Finalizado	Sporting Braga	1 - 1	Benfica
25 Ene 97	Finalizado	Benfica	1 - 2	Os Belenenses
19 Ene 97	Finalizado	Vitória Guimarães	1 - 0	Benfica
11 Ene 97	Finalizado	Benfica	1 - 2	Porto
03 Ene 97	Finalizado	Leça FC	1 - 5	Benfica
22 Dic 96	Finalizado	Benfica	0 - 0	Marítimo
30 Nov 96	Finalizado	Rio Ave	0 - 1	Benfica
24 Nov 96	Finalizado	Benfica	2 - 1	Farense
16 Nov 96	Finalizado	Espinho	0 - 3	Benfica
03 Nov 96	Finalizado	Benfica	1 - 1	Boavista
27 Oct 96	Finalizado	Sporting CP	1 - 0	Benfica
20 Oct 96	Finalizado	Benfica	2 - 0	Estrela Amadora
13 Oct 96	Finalizado	SC Salgueiros	0 - 1	Benfica
30 Sep 96	Finalizado	Benfica	3 - 0	Chaves
22 Sep 96	Finalizado	União de Leiria	0 - 2	Benfica
15 Sep 96	Finalizado	Benfica	5 - 1	Vitória Setúbal
07 Sep 96	Finalizado	Gil Vicente	0 - 3	Benfica
25 Ago 96	Finalizado	Benfica	1 - 1	Sporting Braga

Taça de Portugal »

10 Jun 97	Finalizado	Boavista	3 - 2	Benfica
30 Abr 97	Finalizado	Benfica	2 - 0	Porto
02 Abr 97	Finalizado	Benfica	5 - 1	Dragões Sandinenses
09 Mar 97	Finalizado	Benfica	3 - 1	Desportivo Aves

Trofeo Santiago Bernabéu »

27 Ago 96

Finalizado

Real Madrid

4 - 0

Benfica

Supercopa Portugal »

	18 Sep 96	Finalizado	Benfica	0 - 5	Porto			0
	18 Ago 96	Finalizado	Porto	1 - 0	Benfica			0

Recopa de Europa »

20 Mar 97	Finalizado	Fiorentina	0 - 1	Benfica
06 Mar 97	Finalizado	Benfica	0 - 2	Fiorentina
31 Oct 96	Finalizado	Lokomotiv Moskva	2 - 3	Benfica
17 Oct 96	Finalizado	Benfica	1 - 0	Lokomotiv Moskva
26 Sep 96	Finalizado	Ruch Chorzów	0 - 0	Benfica
12 Sep 96	Finalizado	Benfica	5 - 1	Ruch Chorzów

Estadísticas

GOLEADORES

AMARILLAS

Calado13

ROJAS

Hélder2

Jamir1

Plantilla del Benfica Temporada 1996/1997

		Edad	Altura	Peso
Portero
	Fernando Brassard	52	174	74	-	-	-
	M. Preud'homme	65	-	-	-	-	2
Defensa
	A. El-Hadrioui	52	179	70	-	-	-
13	Dimas	55	185	76	-	-	3
	Hélder	53	181	80	3	2	5
	Jorge Bermúdez	52	188	84	1	-	5
	Jorge Soares	52	187	84	2	-	4
	Mario Marinho	53	165	58	-	-	-
	Nélson Morais	50	-	-	-	-	-
	Pedro Henriques	49	-	-	1	1	7
	Ronaldo Guiaro	50	186	76	-	-	-
	T. El-Khalej	55	188	86	1	2	11
	Veríssimo	47	-	-	-	-	-
	Wagner	47	179	68	-	-	-
Centrocampista
30	Amaral	51	170	64	-	-	5
	B. Panduru	53	-	-	2	-	5
	Bruno Caires	48	182	80	2	-	4
	Calado	50	179	78	-	-	13
	Gustavo	55	177	77	2	-	1
	Hugo Leal	43	180	84	-	-	-
	I. Iliev	55	-	-	3	-	4
	Jamir	51	180	77	1	1	4
	João Pinto	52	171	68	7	3	5
	Mauro Gabriel Airez	55	-	-	-	-	-
	Paulão	54	184	-	-	-	-
	Tiago	48	173	58	-	-	4
	Valdir	52	180	70	3	-	2
	Valdo	60	-	-	5	-	3
Delantero
	Akwá	46	180	80	-	-	1
	Donizete	55	-	-	7	1	7
	Edgar	46	178	83	4	-	-
	Hassan Nader	58	183	78	1	-	-
	Helder	55	180	73	1	-	-
	Martin Pringle	53	188	76	3	-	-

Noticias del Benfica

Ver últimas noticias

Las amenazas surten efecto: Di María no volverá a Rosario Central en junio

BeSoccer - Martes, 30 Abril 2024

5 25.858

El argentino Di María, amenazado por el narcotráfico de Rosario, ha tomado la decisión de no volver a Central en junio. El 'Fideo', que ansiaba por volver a su casa, ha priorizado la salud y la seguridad de su familia. Su futuro es ahora mismo toda una incógnita, ya que acaba contrato con el Benfica este verano.

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		Porto	85
2		Sporting CP	72
3		Benfica	58
4		Sporting Braga	55
5		Vitória Guimarães	53
6		SC Salgueiros	52
7		Boavista	49
8		Marítimo	47
9		Estrela Amadora	47
10		Chaves	46
11		Farense	42
12		Vitória Setúbal	40
13		Os Belenenses	40
14		Leça FC	36
15		Rio Ave	35
16		Espinho	33
17		União de Leiria	30
18		Gil Vicente	19

	Champions League : Porto
	Previa de Champions : Sporting CP
	UEFA : Benfica, Sporting Braga, Vitória Guimarães
	Recopa : Boavista
	Descenso : Espinho, União de Leiria, Gil Vicente

RIVALES EN Liga Portuguesa

RIVALES EN Recopa de Europa

RIVALES EN Supercopa Portug.

RIVALES EN Taça de Portugal

USO DE MEMORIA

6,607,480 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.4430
Total Execution Time	0.4449

CADENA URL

/Benfica/1997

GET DATOS

$_GET['/Benfica/1997']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0062	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 = 1997 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.0019	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.0018	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.0018	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.0018	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.0018	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.0018	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.0024	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 = 22913
0.0023	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 = 25293
0.0023	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 = 10982
0.0024	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 = 72517
0.0048	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 = 1997 ORDER BY l.year DESC,cat.coefficient DESC
0.0054	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.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 = 10982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 25293 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 22913 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0236	(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 calendars1997 as c ON c.league_id = l.id WHERE (c.datateam1 = 466 or c.datateam2 = 466) AND l.year = 1997 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0178	(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 calendars1997 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 = 1997 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0171	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1997 as c ON c.league_id = l.id INNER JOIN events1997 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 = 1997)
0.0048	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 (1996,1997,1998) 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 (72705,72517,25293,22914,10982,10972,221) 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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 221 AND teamId = 466
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 10972 AND teamId = 466
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 22914 AND teamId = 466
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 25293 AND teamId = 466
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 10982 AND teamId = 466
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 72517 AND teamId = 466
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 72705 AND teamId = 466
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 FROM* `tables1997` 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 = 220 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0042	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 events1997 e ON e.player_id = p.id AND e.league_id = 220 WHERE rp.league_id = 220 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.0043	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 events1997 e ON e.player_id = p.id AND e.league_id = 220 WHERE rp.league_id = 220 AND rp.teamId = 466 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0054	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 events1997 e ON e.player_id = p.id AND e.league_id = 220 WHERE rp.league_id = 220 AND rp.teamId = 466 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0032	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 = 220 AND l.year= 1997 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0024	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=5057 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=5057
0.0028	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5057 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.0030	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5057 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0029	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5057 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5057 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0028	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 events1997 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5057 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

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

Estadísticas

Plantilla del Benfica Temporada 1996/1997

Noticias del Benfica

Benfica

Selecciona un equipo

Competiciones que juega

RIVALES EN Liga Portuguesa

RIVALES EN Recopa de Europa

RIVALES EN Supercopa Portug.

RIVALES EN Taça de Portugal