11 Dic 13	Finalizado	Atlético	2 - 0	Porto	77
26 Nov 13	Finalizado	Porto	1 - 1	Austria Wien	12
06 Nov 13	Finalizado	Zenit	1 - 1	Porto	33
22 Oct 13	Finalizado	Porto	0 - 1	Zenit	16
01 Oct 13	Finalizado	Porto	1 - 2	Atlético	106
18 Sep 13	Finalizado	Austria Wien	0 - 1	Porto	13

Europa League »

10 Abr 14	Finalizado	Sevilla	4 - 1	Porto	1050
03 Abr 14	Finalizado	Porto	1 - 0	Sevilla	831
20 Mar 14	Finalizado	Napoli	2 - 2	Porto	83
13 Mar 14	Finalizado	Porto	1 - 0	Napoli	109
27 Feb 14	Finalizado	Eintracht Frankfurt	3 - 3	Porto	42
20 Feb 14	Finalizado	Porto	2 - 2	Eintracht Frankfurt	34

Liga Portuguesa »

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

Taça de Portugal »

16 Abr 14	Finalizado	Benfica	3 - 1	Porto	13
26 Mar 14	Finalizado	Porto	1 - 0	Benfica	21
05 Feb 14	Finalizado	Porto	2 - 1	Estoril	95
04 Ene 14	Finalizado	Porto	6 - 0	Atlético CP	0
10 Nov 13	Finalizado	Vitória Guimarães	0 - 2	Porto	0
19 Oct 13	Finalizado	Porto	1 - 0	Trofense	0

Partidos Amistosos »

04 Ago 13	Finalizado	Napoli	1 - 3	Porto	5
03 Ago 13	Finalizado	Galatasaray SK	1 - 0	Porto	6
28 Jul 13	Finalizado	Celta	0 - 1	Porto	42

Copa de la Liga Portugal »

27 Abr 14

Finalizado

Porto

0 - 0

Benfica

Fases Previas Copa de la Liga »

25 Ene 14	Finalizado	Porto	3 - 2	Marítimo
15 Ene 14	Finalizado	Porto	4 - 0	Penafiel
29 Dic 13	Finalizado	Sporting CP	0 - 0	Porto

Supercopa Portugal »

10 Ago 13

Finalizado

Porto

3 - 0

Vitória Guimarães

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Danilo1

Plantilla del Porto Temporada 2013/2014

		Edad	Altura	Peso
Portero
24	Fabiano	36	197	90	-	-	-
1	Helton	45	188	85	-	-	1
41	Kadú	29	190	80	-	-	-
Defensa
23	Abdoulaye Ba	33	197	79	-	1	6
26	Alex Sandro	33	181	80	-	-	13
13	D. Reyes	31	191	76	-	-	1
2	Danilo	32	184	73	3	1	8
22	E. Mangala	33	187	74	2	1	9
77	J. Kayembe	29	180	72	-	-	-
5	Jorge Fucile	39	177	73	-	-	1
4	Maicon	35	191	91	1	-	-
21	Ricardo Pereira	30	175	70	2	-	2
52	Víctor García	29	178	71	-	-	-
Centrocampista
20	Carlos Eduardo	34	184	76	4	-	2
25	Fernando	36	183	75	-	1	9
16	Héctor Herrera	34	180	70	3	-	3
10	J. Quintero	31	169	64	4	-	-
8	Josué	33	174	68	4	-	5
46	M. Agu	30	184	77	-	-	-
35	S. Defour	36	173	64	-	-	2
70	Tozé	31	174	66	-	-	-
Delantero
9	J. Martínez	37	184	75	20	-	2
28	Kelvin	30	175	69	-	-	-
19	Licá	35	181	71	3	-	2
11	N. Ghilas	34	183	85	1	-	-
7	R. Quaresma	40	175	67	4	-	6
17	S. Varela	39	180	75	5	-	3

Noticias del Porto

Ver últimas noticias

Gyökeres acerca 'in extremis' la Liga al Sporting

BeSoccer - Lunes, 29 Abril 2024

0 606

El jugador del Sporting de Portugal Viktor Göykeres acercó la Liga a su club al anotar un doblete que certificó el empate de los suyos en el Estádio Do Dragão ante el Oporto. Pese a la victoria del Benfica frente al Braga, los lisboetas mantienen una ventaja con respecto a las 'águilas' de 5 puntos con tan solo 9 por disputarse.

"En circunstancias normales, seremos campeones; en circunstancias anormales, también"

David Caravaca - Lunes, 29 Abril 2024

2 14.483

La mítica rueda de prensa que le dio a José Mourinho su apodo de 'The Special One' es tan solo uno de tantos capítulos inolvidables que ha protagonizado ante los medios. Sus inicios en la Liga de su país, posteriores a una estancia como segundo técnico del Estrela da Amadora, conocieron su arrojo cuando adelantó, en declaraciones a los medios de comunicación, que su Oporto sería campeón en 2003. Lo predijo dos veces: una, en enero de 2002. Otra, en febrero de 2003, con el curso ya iniciado.

André Villas-Boas vuelve al Oporto... ¡como presidente!

BeSoccer - Domingo, 28 Abril 2024

6 8.843

Muchos recordarán al André Villas-Boas entrenador. Pues bien, tras varios años de ausencia de los banquillos, el luso ha conseguido regresar al Oporto tras ganarle las elecciones presidenciales a Pinto da Costa, quien había ejercido el cargo durante 42 años. En su directiva le acompañará Andoni Zubizarrera.

El Atlético fichará a Jackson Martínez por 35 millones, según un diario luso

BeSoccer - Lunes, 22 Junio 2015

0 167

El Atlético de Madrid llegó a un acuerdo con el colombiano Jackson Martínez, del Oporto, para hacerse con sus servicios a cambio del pago de la cláusula de rescisión de 35 millones de euros, según informó hoy el luso "Diario de Notícias".

Simeone confía en mantener 'la estabilidad' de la plantilla y elogia a Óliver

BeSoccer - Lunes, 22 Junio 2015

0 128

El entrenador del Atlético de Madrid, el argentino Diego Pablo Simeone, aseguró este miércoles que espera mantener "la estabilidad" de la plantilla actual para la próxima temporada y elogió al joven centrocampista Óliver Torres, cedido la última temporada en el Oporto portugués.

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 Supercopa Portug.

RIVALES EN Fases Previas Co.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,019,120 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2372
Total Execution Time	0.2391

CADENA URL

/Fc-Porto/2014

GET DATOS

$_GET['/Fc-Porto/2014']

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0063	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 = 'Fc-Porto' 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.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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=1095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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 = 2823
0.0025	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.0025	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 = 20508
0.0025	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 = 2459
0.0025	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.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1095 AND type_rel = 2
0.0059	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1095 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (1313082,1313074,1312905,460,522) ORDER BY n.cover_points DESC, update_date DESC
0.0054	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 = '1095' AND l.year = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0071	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 = '1095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 2823 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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.0024	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 = 2459 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	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 = 20508 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 = 3666 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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.0031	(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 = 1095 or c.datateam2 = 1095) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0040	(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 = 1095 or c.datateam2 = 1095) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0031	(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 = 1095 or c.datateam2 = 1095) AND l.year = 2014)
0.0046	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=1095 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (72813,38331,20512,20501,20492,4237,4016,3804,3797,2471,2459) 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 = 3797 AND teamId = 1095
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 4237 AND teamId = 1095
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 2471 AND teamId = 1095
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 4016 AND teamId = 1095
0.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 20492 AND teamId = 1095
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 20501 AND teamId = 1095
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 20512 AND teamId = 1095
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 2459 AND teamId = 1095
0.0071	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 1095
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 72813 AND teamId = 1095
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 38331 AND teamId = 1095
0.0025	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.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 events2014 e ON e.player_id = p.id AND e.league_id = 2503 WHERE rp.league_id = 2503 AND rp.teamId = 1095 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 events2014 e ON e.player_id = p.id AND e.league_id = 2503 WHERE rp.league_id = 2503 AND rp.teamId = 1095 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 1095 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 1095 AND rp.league_id = 2503 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025	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=52755 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=52755
0.0027	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=52755 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.0027	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=52755 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	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=52755 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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52755 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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=52755 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Porto

Información sobre Porto

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Porto

Estadísticas

Plantilla del Porto Temporada 2013/2014

Noticias del Porto

Porto

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Europa 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