10 Dic 13	Finalizado	Benfica	2 - 1	PSG	37
27 Nov 13	Finalizado	Anderlecht	2 - 3	Benfica	31
05 Nov 13	Finalizado	Olympiacos Piraeus	1 - 0	Benfica	13
23 Oct 13	Finalizado	Benfica	1 - 1	Olympiacos Piraeus	15
02 Oct 13	Finalizado	PSG	3 - 0	Benfica	13
17 Sep 13	Finalizado	Benfica	2 - 0	Anderlecht	7

Europa League »

14 May 14	Finalizado	Sevilla	0 - 0	Benfica	2260
01 May 14	Finalizado	Juventus	0 - 0	Benfica	540
24 Abr 14	Finalizado	Benfica	2 - 1	Juventus	570
10 Abr 14	Finalizado	Benfica	2 - 0	AZ Alkmaar	42
03 Abr 14	Finalizado	AZ Alkmaar	0 - 1	Benfica	55
20 Mar 14	Finalizado	Benfica	2 - 2	Tottenham Hotspur	116
13 Mar 14	Finalizado	Tottenham Hotspur	1 - 3	Benfica	79
27 Feb 14	Finalizado	Benfica	3 - 0	PAOK	10
20 Feb 14	Finalizado	PAOK	0 - 1	Benfica	15

Liga Portuguesa »

10 May 14	Finalizado	Porto	2 - 1	Benfica	21
04 May 14	Finalizado	Benfica	1 - 1	Vitória Setúbal	10
20 Abr 14	Finalizado	Benfica	2 - 0	Olhanense	44
13 Abr 14	Finalizado	Arouca	0 - 2	Benfica	23
07 Abr 14	Finalizado	Benfica	4 - 0	Rio Ave	44
30 Mar 14	Finalizado	Sporting Braga	0 - 1	Benfica	13
23 Mar 14	Finalizado	Benfica	3 - 0	Académica	19
17 Mar 14	Finalizado	Nacional	2 - 4	Benfica	58
09 Mar 14	Finalizado	Benfica	2 - 0	Estoril	6
02 Mar 14	Finalizado	Os Belenenses	0 - 1	Benfica	6
24 Feb 14	Finalizado	Benfica	1 - 0	Vitória Guimarães	25
16 Feb 14	Finalizado	Paços de Ferreira	0 - 2	Benfica	6
11 Feb 14	Finalizado	Benfica	2 - 0	Sporting CP	63
01 Feb 14	Finalizado	Gil Vicente	1 - 1	Benfica	9
19 Ene 14	Finalizado	Benfica	2 - 0	Marítimo	6
12 Ene 14	Finalizado	Benfica	2 - 0	Porto	21
20 Dic 13	Finalizado	Vitória Setúbal	0 - 2	Benfica	5
15 Dic 13	Finalizado	Olhanense	2 - 3	Benfica	2
06 Dic 13	Finalizado	Benfica	2 - 2	Arouca	2
01 Dic 13	Finalizado	Rio Ave	1 - 3	Benfica	4
23 Nov 13	Finalizado	Benfica	1 - 0	Sporting Braga	6
01 Nov 13	Finalizado	Académica	0 - 3	Benfica	3
27 Oct 13	Finalizado	Benfica	2 - 0	Nacional	1
06 Oct 13	Finalizado	Estoril	1 - 2	Benfica	1
28 Sep 13	Finalizado	Benfica	1 - 1	Os Belenenses	2
22 Sep 13	Finalizado	Vitória Guimarães	0 - 1	Benfica	3
14 Sep 13	Finalizado	Benfica	3 - 1	Paços de Ferreira	2
31 Ago 13	Finalizado	Sporting CP	1 - 1	Benfica	2
25 Ago 13	Finalizado	Benfica	2 - 1	Gil Vicente	4
18 Ago 13	Finalizado	Marítimo	2 - 1	Benfica	1

Taça de Portugal »

18 May 14	Finalizado	Benfica	1 - 0	Rio Ave	0
16 Abr 14	Finalizado	Benfica	3 - 1	Porto	13
26 Mar 14	Finalizado	Porto	1 - 0	Benfica	21
05 Feb 14	Finalizado	Penafiel	0 - 1	Benfica	4
04 Ene 14	Finalizado	Benfica	5 - 0	Gil Vicente	3
09 Nov 13	Finalizado	Benfica	4 - 3	Sporting CP	1
19 Oct 13	Finalizado	Cinfães	0 - 1	Benfica	0

Partidos Amistosos »

09 Ago 13	Finalizado	Napoli	2 - 1	Benfica	6
03 Ago 13	Finalizado	Benfica	0 - 0	São Paulo	2
31 Jul 13	Finalizado	Elche	1 - 3	Benfica	21
26 Jul 13	Finalizado	Benfica	2 - 1	Levante	2
16 Jul 13	Finalizado	Sion	2 - 3	Benfica	3

Copa de la Liga Portugal »

	07 May 14	Finalizado	Rio Ave	0 - 2	Benfica			0
	27 Abr 14	Finalizado	Porto	0 - 0	Benfica			1

Fases Previas Copa de la Liga »

25 Ene 14	Finalizado	Benfica	1 - 0	Gil Vicente
15 Ene 14	Finalizado	Benfica	2 - 0	Leixões
30 Dic 13	Finalizado	Nacional	0 - 1	Benfica

Copa Emirates »

	03 Ago 14	Finalizado	Benfica	1 - 3	Valencia			0
	02 Ago 14	Finalizado	Arsenal	5 - 1	Benfica			0

Estadísticas

GOLEADORES

Lima14

AMARILLAS

ROJAS

Plantilla del Benfica Temporada 2013/2014

		Edad	Altura	Peso
Portero
1	Artur Moraes	43	193	93	-	-	2
	Bruno	39	195	88	-	-	-
52	Bruno Varela	29	191	86	-	-	-
41	Jan Oblak	31	188	87	-	-	1
13	Paulo Lopes	45	184	76	-	-	-
Defensa
34	A. Almeida	33	186	75	-	-	3
12	B. Cortéz	37	179	74	-	-	-
24	E. Garay	37	189	90	6	-	3
16	G. Siqueira	37	184	76	1	1	7
33	Jardel	38	192	86	-	-	2
25	João Cancelo	29	182	74	-	-	-
4	Luisão	43	193	92	1	-	3
14	M. Pereira	39	173	73	-	1	9
3	S. Vitoria	37	195	86	-	-	-
28	Sílvio	36	176	72	-	-	-
92	Victor Lindelöf	29	187	80	-	-	-
Centrocampista
30	André Gomes	30	188	83	1	-	-
94	Bernardo Silva	29	173	64	-	-	-
17	C. Martins	41	173	70	-	-	-
35	Enzo Pérez	38	177	71	4	-	7
10	F. Djuričić	32	181	73	-	-	1
5	L. Fejsa	35	185	80	-	-	6
20	N. Gaitán	36	174	68	4	-	7
21	N. Matić	35	194	82	2	-	6
6	Ruben Amorin	39	178	73	-	-	3
77	Rúben Pinto	32	183	72	-	-	-
Delantero
18	E. Salvio	33	173	78	-	-	-
67	Hélder Costa	30	179	73	-	-	-
90	Ivan Cavaleiro	30	175	72	-	-	-
23	J. Urretaviscaya	34	172	66	-	-	-
50	L. Markovic	30	175	65	5	-	2
11	Lima	40	178	78	14	-	1
8	M. Sulejmani	35	179	68	1	-	-
7	O. Cardozo	40	193	91	7	-	-
15	O. John	31	179	75	-	-	-
9	R. Funes Mori	33	186	81	-	-	1
19	Rodrigo Moreno	33	182	77	11	-	2
83	Rui Fonte	34	180	73	-	-	-

Noticias del Benfica

Ver últimas noticias

Sidnei está muy cerca del Deportivo

BeSoccer - Jueves, 02 Julio 2015

0 213

Víctor Sánchez del Amo, entrenador del Deportivo, ha confirmado hoy que el fichaje del central brasileño Sidnei Rechel está "muy próximo" a concretarse.

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	74
2		Sporting CP	67
3		Porto	61
4		Estoril	54
5		Nacional	45
6		Marítimo	41
7		Vitória Setúbal	39
8		Sporting Braga	37
9		Académica	37
10		Vitória Guimarães	35
11		Rio Ave	32
12		Arouca	31
13		Gil Vicente	31
14		Os Belenenses	28
15		Olhanense	24
16		Paços de Ferreira	24

	Champions League : Benfica, Sporting CP
	Previa de Champions : Porto
	Europa League : Estoril, Nacional, Rio Ave
	Playoff Descenso : Olhanense
	Descenso : Paços de Ferreira

RIVALES EN Champions League

RIVALES EN Europa League

RIVALES EN Liga Portuguesa

RIVALES EN Copa de la Liga.

RIVALES EN Fases Previas Co.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,258,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.9859
Total Execution Time	0.9879

CADENA URL

/Benfica/2014

GET DATOS

$_GET['/Benfica/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (60)

0.0128	SELECT type FROM routes WHERE alias = 'benfica'
0.0272	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 = 2014 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.0134	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.0134	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.0134	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.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.0127	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.0127	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.0127	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.0126	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.0137	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 = 2503
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 = 2827
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 = 2471
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 = 2532
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 = 3666
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 = 20510
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 = 2399
0.0133	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 = 24607
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=466 AND type_rel = 2
0.0163	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.0128	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 (286,372,1185,1301,1344) ORDER BY n.cover_points DESC, update_date DESC
0.0146	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 = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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.0125	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 = 2827 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 = 2503 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 = 3666 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 = 20510 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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 = 2532 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	(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 calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 466 or c.datateam2 = 466) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0139	(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 calendars2014 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 = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0145	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 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 = 2014)
0.0163	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 (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (24607,20515,20501,20492,4232,3850,3804,3797,2471) 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.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 3797 AND teamId = 466
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 4232 AND teamId = 466
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 2471 AND teamId = 466
0.0141	SELECT count(id) as num_players from rel_players WHERE league_id = 20492 AND teamId = 466
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 20501 AND teamId = 466
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 20515 AND teamId = 466
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 3850 AND teamId = 466
0.0163	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 466
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 24607 AND teamId = 466
0.0132	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 2503 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0132	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 = '466' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '466' and rp.type = 4
0.0142	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 = '466' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0129	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '466' and rp.type = 4
0.0188	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 events2014 e ON e.player_id = p.id AND e.league_id = 2503 WHERE rp.league_id = 2503 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.0141	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 events2014 e ON e.player_id = p.id AND e.league_id = 2503 WHERE rp.league_id = 2503 AND rp.teamId = 466 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 events2014 e ON e.player_id = p.id AND e.league_id = 2503 WHERE rp.league_id = 2503 AND rp.teamId = 466 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 2503 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0130	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=52769 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0128	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=52769
0.0132	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52769 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.0132	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52769 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0132	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52769 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52769 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0131	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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52769 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0126	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 = 2503 ORDER BY nameShow LIMIT 100


	¿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