09 Mar 10	Finalizado	Arsenal	5 - 0	Porto	33
17 Feb 10	Finalizado	Porto	2 - 1	Arsenal	88
08 Dic 09	Finalizado	Atlético	0 - 3	Porto	27
25 Nov 09	Finalizado	Porto	0 - 1	Chelsea	3
03 Nov 09	Finalizado	APOEL	0 - 1	Porto	4
21 Oct 09	Finalizado	Porto	2 - 1	APOEL	0
30 Sep 09	Finalizado	Porto	2 - 0	Atlético	1
15 Sep 09	Finalizado	Chelsea	1 - 0	Porto	9

Liga Portuguesa »

08 May 10	Finalizado	União de Leiria	1 - 4	Porto	3
02 May 10	Finalizado	Porto	3 - 1	Benfica	20
24 Abr 10	Finalizado	Vitória Setúbal	2 - 5	Porto	8
18 Abr 10	Finalizado	Porto	3 - 0	Vitória Guimarães	8
10 Abr 10	Finalizado	Rio Ave	0 - 1	Porto	6
03 Abr 10	Finalizado	Porto	4 - 1	Marítimo	5
28 Mar 10	Finalizado	Os Belenenses	0 - 3	Porto	4
13 Mar 10	Finalizado	Académica	1 - 2	Porto	8
06 Mar 10	Finalizado	Porto	2 - 2	Olhanense	8
28 Feb 10	Finalizado	Sporting CP	3 - 0	Porto	10
21 Feb 10	Finalizado	Porto	5 - 1	Sporting Braga	8
13 Feb 10	Finalizado	Leixões	0 - 0	Porto	3
07 Feb 10	Finalizado	Porto	3 - 0	Naval	0
30 Ene 10	Finalizado	Nacional	0 - 4	Porto	5
16 Ene 10	Finalizado	Porto	1 - 1	Paços de Ferreira	3
10 Ene 10	Finalizado	Porto	3 - 2	União de Leiria	4
20 Dic 09	Finalizado	Benfica	1 - 0	Porto	38
13 Dic 09	Finalizado	Porto	2 - 0	Vitória Setúbal	4
04 Dic 09	Finalizado	Vitória Guimarães	1 - 4	Porto	0
29 Nov 09	Finalizado	Porto	2 - 1	Rio Ave	0
08 Nov 09	Finalizado	Marítimo	1 - 0	Porto	3
30 Oct 09	Finalizado	Porto	1 - 1	Os Belenenses	2
25 Oct 09	Finalizado	Porto	3 - 2	Académica	2
04 Oct 09	Finalizado	Olhanense	0 - 3	Porto	0
26 Sep 09	Finalizado	Porto	1 - 0	Sporting CP	0
19 Sep 09	Finalizado	Sporting Braga	1 - 0	Porto	0
12 Sep 09	Finalizado	Porto	4 - 1	Leixões	0
29 Ago 09	Finalizado	Naval	1 - 3	Porto	0
23 Ago 09	Finalizado	Porto	3 - 0	Nacional	0
16 Ago 09	Finalizado	Paços de Ferreira	1 - 1	Porto	0

Taça de Portugal »

16 May 10	Finalizado	Chaves	1 - 2	Porto
14 Abr 10	Finalizado	Porto	3 - 0	Rio Ave
24 Mar 10	Finalizado	Rio Ave	1 - 3	Porto
02 Feb 10	Finalizado	Porto	5 - 2	Sporting CP
20 Ene 10	Finalizado	Os Belenenses	2 - 2	Porto
02 Ene 10	Finalizado	UD Oliveirense	0 - 2	Porto
17 Oct 09	Finalizado	Porto	4 - 0	Sertanense

Peace Cup »

31 Jul 09	Finalizado	Aston Villa	2 - 1	Porto
29 Jul 09	Finalizado	Beşiktaş	0 - 0	Porto
27 Jul 09	Finalizado	Olympique Lyonnais	0 - 2	Porto

Copa de la Liga Portugal »

21 Mar 10	Finalizado	Benfica	3 - 0	Porto
10 Feb 10	Finalizado	Porto	1 - 0	Académica
24 Ene 10	Finalizado	Estoril	0 - 2	Porto
13 Ene 10	Finalizado	Académica	0 - 0	Porto
05 Ene 10	Finalizado	Porto	1 - 0	Leixões

Supercopa Portugal »

09 Ago 09

Finalizado

Paços de Ferreira

0 - 2

Porto

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Hulk1

Plantilla del Porto Temporada 2009/2010

		Edad	Altura	Peso
Portero
24	Beto	42	180	80	-	-	1
1	Helton	45	188	85	-	-	1
33	Nuno Espírito Santo	50	188	84	-	-	-
Defensa
15	Á. Pereira	38	180	78	1	-	8
2	B. Alves	42	189	80	5	-	10
21	C. Sapunaru	40	187	81	-	-	1
	D. Addy	34	180	73	-	-	-
13	Jorge Fucile	39	177	73	-	1	4
16	Maicon	35	191	91	1	-	1
22	Miguel Lopes	37	183	83	-	-	2
18	Nuno André Coelho	38	192	82	-	-	-
14	Rolando	38	189	77	3	-	2
Centrocampista
10	C. Rodríguez	38	178	79	4	-	1
8	D. Valeri	38	178	75	-	-	-
7	F. Belluschi	40	171	70	3	-	2
6	F. Guarín	37	183	77	4	-	2
25	Fernando	36	183	75	-	1	7
11	M. González	42	175	79	1	-	2
3	Raúl Meireles	41	179	69	2	-	8
28	Rúben Micael	37	176	70	2	-	4
	S. Prediger	37	183	82	-	-	-
	Sérgio Oliveira	31	181	72	-	-	-
20	T. Costa	39	186	74	1	-	3
Delantero
19	E. Farias	43	178	79	7	-	-
12	Hulk	37	180	95	5	1	3
29	Orlando Sá	35	188	86	-	-	-
9	R. Falcao	38	177	73	25	-	5
17	S. Varela	39	180	75	8	-	-

Noticias del Porto

Ver últimas noticias

El agente de Jackson Martínez confirma su fichaje por el Atlético de Madrid

BeSoccer - Miércoles, 24 Junio 2015

0 100

El agente de Jackson Martínez, el brasileño Luiz Henrique Pompeo, confirmó hoy que su fichaje por el Atlético de Madrid ya está cerrado después de que ambos clubes llegaran a un acuerdo.

Jackson Martínez confía en saber su futuro a lo largo de esta semana

BeSoccer - Lunes, 22 Junio 2015

0 183

El delantero colombiano Jackson Martínez se mostró confiado en conocer cuál será su futuro a lo largo de esta misma semana, mientras se encuentra disputando con su selección la Copa América.

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.

El presidente del Oporto revela que Jackson Martínez jugará en el Milán

BeSoccer - Lunes, 22 Junio 2015

0 328

El presidente del Oporto, Jorge Nuno Pinto da Costa, desveló que el delantero colombiano Jackson Martínez jugará el próximo año en el Milán, operación condicionada al pago de la cláusula de rescisión, de 35 millones de euros.

Ver más noticias del equipo»

Competiciones que juega

Liga Portuguesa

Pos	Equipos		Pts
1		Benfica	76
2		Sporting Braga	71
3		Porto	68
4		Sporting CP	48
5		Marítimo	41
6		Vitória Guimarães	41
7		Nacional	39
8		Naval	36
9		União de Leiria	35
10		Paços de Ferreira	35
11		Académica	33
12		Rio Ave	31
13		Olhanense	29
14		Vitória Setúbal	25
15		Os Belenenses	23
16		Leixões	21

	Champions League : Benfica
	Previa de Champions : Sporting Braga
	Europa League : Porto, Sporting CP, Marítimo
	Descenso : Os Belenenses, Leixões

RIVALES EN Champions League

RIVALES EN Liga Portuguesa

RIVALES EN Supercopa Portug.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,007,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	1.1421
Total Execution Time	1.1441

CADENA URL

/Fc-Porto/2010

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (60)

0.0144	SELECT type FROM routes WHERE alias = 'fc-porto'
0.0326	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 = 2010 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.0146	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.0145	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.0146	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.0145	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.0145	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.0145	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.0145	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.0145	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.0145	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.0145	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.0152	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 = 867
0.0152	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 = 893
0.0151	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 = 943
0.0151	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 = 20504
0.0150	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 = 20526
0.0151	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 = 12399
0.0153	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 = 71990
0.0158	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 = 71991
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1095 AND type_rel = 2
0.0256	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.0160	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 (313,460,522,531,590) ORDER BY n.cover_points DESC, update_date DESC
0.0367	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 = 2010 ORDER BY l.year DESC,cat.coefficient DESC
0.0187	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.0147	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 = 943 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 867 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145	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 = 12399 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145	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 = 20504 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152	(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 calendars2010 as c ON c.league_id = l.id WHERE (c.datateam1 = 1095 or c.datateam2 = 1095) AND l.year = 2010 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0156	(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 calendars2010 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 = 2010 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0162	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2010 as c ON c.league_id = l.id INNER JOIN events2010 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 = 2010)
0.0254	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 (2009,2010,2011) ORDER BY l.id DESC, l.year DESC ;
0.0156	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 (71991,44655,42898,20522,20496,12400,1257,1108,1098,943) 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.0199	SELECT count(id) as num_players from rel_players WHERE league_id = 1108 AND teamId = 1095
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 943 AND teamId = 1095
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 1257 AND teamId = 1095
0.0160	SELECT count(id) as num_players from rel_players WHERE league_id = 20496 AND teamId = 1095
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 42898 AND teamId = 1095
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 20522 AND teamId = 1095
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 44655 AND teamId = 1095
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 12400 AND teamId = 1095
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 71991 AND teamId = 1095
0.0168	SELECT count(id) as num_players from rel_players WHERE league_id = 1098 AND teamId = 1095
0.0148	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2010` 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 = 867 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0150	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 = '1095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1095' and rp.type = 4
0.0148	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 = '1095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0144	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1095' and rp.type = 4
0.0164	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 events2010 e ON e.player_id = p.id AND e.league_id = 867 WHERE rp.league_id = 867 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.0164	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 events2010 e ON e.player_id = p.id AND e.league_id = 867 WHERE rp.league_id = 867 AND rp.teamId = 1095 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 events2010 e ON e.player_id = p.id AND e.league_id = 867 WHERE rp.league_id = 867 AND rp.teamId = 1095 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 867 AND l.year= 2010 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0149	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=22363 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=22363
0.0161	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=22363 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.0164	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=22363 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0168	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=22363 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0169	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=22363 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0162	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 events2010 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=22363 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

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 2009/2010

Noticias del Porto

Porto

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Liga Portuguesa

RIVALES EN Supercopa Portug.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal