09 Dic 14	Finalizado	Benfica	0 - 0	B. Leverkusen	116
26 Nov 14	Finalizado	Zenit	1 - 0	Benfica	844
04 Nov 14	Finalizado	Benfica	1 - 0	Monaco	269
22 Oct 14	Finalizado	Monaco	0 - 0	Benfica	132
01 Oct 14	Finalizado	B. Leverkusen	3 - 1	Benfica	49
16 Sep 14	Finalizado	Benfica	0 - 2	Zenit	101

Liga Portuguesa »

23 May 15	Finalizado	Benfica	4 - 1	Marítimo	20
17 May 15	Finalizado	Vitória Guimarães	0 - 0	Benfica	36
09 May 15	Finalizado	Benfica	4 - 0	Penafiel	32
02 May 15	Finalizado	Gil Vicente	0 - 5	Benfica	21
26 Abr 15	Finalizado	Benfica	0 - 0	Porto	165
18 Abr 15	Finalizado	Os Belenenses	0 - 2	Benfica	21
11 Abr 15	Finalizado	Benfica	5 - 1	Académica	43
04 Abr 15	Finalizado	Benfica	3 - 1	Nacional	50
21 Mar 15	Finalizado	Rio Ave	2 - 1	Benfica	67
14 Mar 15	Finalizado	Benfica	2 - 0	Sporting Braga	38
08 Mar 15	Finalizado	Arouca	1 - 3	Benfica	145
28 Feb 15	Finalizado	Benfica	6 - 0	Estoril	60
21 Feb 15	Finalizado	Moreirense	1 - 3	Benfica	128
15 Feb 15	Finalizado	Benfica	3 - 0	Vitória Setúbal	28
08 Feb 15	Finalizado	Sporting CP	1 - 1	Benfica	99
31 Ene 15	Finalizado	Benfica	3 - 0	Boavista	29
26 Ene 15	Finalizado	Paços de Ferreira	1 - 0	Benfica	315
18 Ene 15	Finalizado	Marítimo	0 - 4	Benfica	26
10 Ene 15	Finalizado	Benfica	3 - 0	Vitória Guimarães	27
04 Ene 15	Finalizado	Penafiel	0 - 3	Benfica	69
21 Dic 14	Finalizado	Benfica	1 - 0	Gil Vicente	29
14 Dic 14	Finalizado	Porto	0 - 2	Benfica	84
06 Dic 14	Finalizado	Benfica	3 - 0	Os Belenenses	20
30 Nov 14	Finalizado	Académica	0 - 2	Benfica	20
09 Nov 14	Finalizado	Nacional	1 - 2	Benfica	16
31 Oct 14	Finalizado	Benfica	1 - 0	Rio Ave	52
26 Oct 14	Finalizado	Sporting Braga	2 - 1	Benfica	20
05 Oct 14	Finalizado	Benfica	4 - 0	Arouca	17
27 Sep 14	Finalizado	Estoril	2 - 3	Benfica	18
21 Sep 14	Finalizado	Benfica	3 - 1	Moreirense	11
12 Sep 14	Finalizado	Vitória Setúbal	0 - 5	Benfica	41
31 Ago 14	Finalizado	Benfica	1 - 1	Sporting CP	11
24 Ago 14	Finalizado	Boavista	0 - 1	Benfica	7
17 Ago 14	Finalizado	Benfica	2 - 0	Paços de Ferreira	12

Taça de Portugal »

18 Dic 14	Finalizado	Benfica	1 - 2	Sporting Braga	42
22 Nov 14	Finalizado	Benfica	4 - 1	Moreirense	1
18 Oct 14	Finalizado	SC Covilha	2 - 3	Benfica	1

Partidos Amistosos »

02 Ago 14	Finalizado	Arsenal	5 - 1	Benfica	22
31 Jul 14	Finalizado	Benfica	0 - 2	Athletic	19
~~30 Jul 14~~	Aplazado	Sunderland	-	Benfica	11
26 Jul 14	Finalizado	Benfica	0 - 1	Ajax	4
~~13 Jul 14~~	Aplazado	Shakhtar Donetsk	-	Benfica	7

Copa de la Liga Portugal »

29 May 15	Finalizado	Marítimo	1 - 2	Benfica	0
11 Feb 15	Finalizado	Benfica	3 - 0	Vitória Setúbal	0
21 Ene 15	Finalizado	Moreirense	0 - 2	Benfica	98
14 Ene 15	Finalizado	Benfica	4 - 0	Arouca	28
30 Dic 14	Finalizado	Benfica	1 - 0	Nacional	155

Supercopa Portugal »

10 Ago 14

Finalizado

Benfica

0 - 0

Rio Ave

Estadísticas

GOLEADORES

Jonas20

Lima19

AMARILLAS

ROJAS

Luisão1

A. Talisca1

Plantilla del Benfica Temporada 2014/2015

		Edad	Altura	Peso
Portero
1	Artur Moraes	43	193	93	-	-	-
12	Bruno Varela	29	191	86	-	-	-
20	Júlio César	44	186	79	-	-	4
13	Paulo Lopes	45	184	76	-	-	-
Defensa
34	A. Almeida	33	186	75	-	-	7
37	Cesar	31	190	88	-	-	2
19	Eliseu	40	177	75	4	-	7
33	Jardel	38	192	86	4	-	3
2	Lisandro López	34	187	80	-	-	-
23	Loris Benito	32	186	80	-	-	-
4	Luisão	43	193	92	4	1	1
14	M. Pereira	39	173	73	5	-	11
	P. Dawidowicz	28	189	80	-	-	-
28	Sílvio	36	176	72	-	-	-
	Victor Lindelöf	29	187	80	-	-	-
Centrocampista
7	A. Samaris	34	189	80	-	-	12
30	A. Talisca	30	190	80	9	1	8
24	B. Cristante	29	186	82	-	-	-
27	H. Mukhtar	29	173	72	-	-	-
	João Teixeira	30	178	70	-	-	-
5	L. Fejsa	35	185	80	1	-	2
10	N. Gaitán	36	174	68	4	-	6
21	Pizzi	34	177	65	2	-	1
6	Ruben Amorin	39	178	73	-	-	1
Delantero
9	Derley	36	183	71	1	-	-
18	E. Salvio	33	173	78	9	-	4
78	Gonçalo Guedes	27	179	73	-	-	1
25	J. Rodríguez	30	178	77	-	-	-
17	Jonas	40	181	75	20	-	4
11	Lima	40	178	78	19	-	-
8	M. Sulejmani	35	179	68	-	-	-
15	O. John	31	179	75	3	-	-
	V. Andrade	28	177	60	-	-	-

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	85
2		Porto	82
3		Sporting CP	76
4		Sporting Braga	58
5		Vitória Guimarães	55
6		Os Belenenses	48
7		Nacional	47
8		Paços de Ferreira	47
9		Marítimo	44
10		Rio Ave	43
11		Moreirense	43
12		Estoril	40
13		Boavista	34
14		Académica	29
15		Vitória Setúbal	29
16		Arouca	28
17		Gil Vicente	23
18		Penafiel	22

RIVALES EN Champions League

RIVALES EN Liga Portuguesa

RIVALES EN Supercopa Portug.

RIVALES EN Fases Previas Co.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,061,984 bytes

BENCHMARKS

Loading Time Base Classes	0.0028
Controller Execution Time ( Home / Category )	0.2843
Total Execution Time	0.2871

CADENA URL

/Benfica/2015

GET DATOS

$_GET['/Benfica/2015']

POST DATOS

No hay datos POST existentes

CONSULTAS (53)

0.0019	SELECT type FROM routes WHERE alias = 'benfica'
0.0137	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 = 2015 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.0024	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.0025	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.0023	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.0023	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.0022	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 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 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 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 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.0040	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 = 4232
0.0041	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 = 5260
0.0035	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 = 8472
0.0032	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 = 9519
0.0030	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 = 3850
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=466 AND type_rel = 2
0.0090	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.0020	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.0073	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 = 2015 ORDER BY l.year DESC,cat.coefficient DESC
0.0050	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 = 4232 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 = 3797 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 = 3850 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 5260 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 9519 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	(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 calendars2015 as c ON c.league_id = l.id WHERE (c.datateam1 = 466 or c.datateam2 = 466) AND l.year = 2015 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0032	(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 calendars2015 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 = 2015 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0032	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2015 as c ON c.league_id = l.id INNER JOIN events2015 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 = 2015)
0.0045	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 (2014,2015,2016) 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 (24607,20510,20309,20031,17735,16245,15394,15031,15028,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.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 15394 AND teamId = 466
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 20031 AND teamId = 466
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 2471 AND teamId = 466
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 17735 AND teamId = 466
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 20309 AND teamId = 466
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 20510 AND teamId = 466
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 15031 AND teamId = 466
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 15028 AND teamId = 466
0.0173	SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 466
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 24607 AND teamId = 466
0.0038	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 3797 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0123	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 events2015 e ON e.player_id = p.id AND e.league_id = 3797 WHERE rp.league_id = 3797 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.0050	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 events2015 e ON e.player_id = p.id AND e.league_id = 3797 WHERE rp.league_id = 3797 AND rp.teamId = 466 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0038	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 events2015 e ON e.player_id = p.id AND e.league_id = 3797 WHERE rp.league_id = 3797 AND rp.teamId = 466 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0046	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 = 3797 AND l.year= 2015 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0027	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=69726 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=69726
0.0041	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69726 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.0054	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69726 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0044	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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69726 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69726 AND (e.action = 22) 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 events2015 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=69726 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

Estadísticas

Plantilla del Benfica Temporada 2014/2015

Noticias del Benfica

Benfica

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Liga Portuguesa

RIVALES EN Supercopa Portug.

RIVALES EN Fases Previas Co.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal