24 Feb 11	Finalizado	Sporting CP	2 - 2	Rangers FC	12
17 Feb 11	Finalizado	Rangers FC	1 - 1	Sporting CP	3
16 Dic 10	Finalizado	Levski Sofia	1 - 0	Sporting CP	4
01 Dic 10	Finalizado	Sporting CP	1 - 0	Lille	4
04 Nov 10	Finalizado	KAA Gent	3 - 1	Sporting CP	6
21 Oct 10	Finalizado	Sporting CP	5 - 1	KAA Gent	2
30 Sep 10	Finalizado	Sporting CP	5 - 0	Levski Sofia	3
16 Sep 10	Finalizado	Lille	1 - 2	Sporting CP	6

Liga Portuguesa »

14 May 11	Finalizado	Sporting Braga	0 - 1	Sporting CP	2
08 May 11	Finalizado	Sporting CP	0 - 1	Vitória Setúbal	3
30 Abr 11	Finalizado	Sporting CP	2 - 1	Portimonense	1
17 Abr 11	Finalizado	Porto	3 - 2	Sporting CP	6
09 Abr 11	Finalizado	Sporting CP	2 - 0	Académica	2
03 Abr 11	Finalizado	Vitória Guimarães	1 - 1	Sporting CP	7
19 Mar 11	Finalizado	Sporting CP	0 - 0	União de Leiria	1
12 Mar 11	Finalizado	Rio Ave	0 - 0	Sporting CP	0
06 Mar 11	Finalizado	Sporting CP	1 - 0	Beira Mar SC	0
27 Feb 11	Finalizado	Nacional	1 - 0	Sporting CP	0
21 Feb 11	Finalizado	Sporting CP	0 - 2	Benfica	15
12 Feb 11	Finalizado	Olhanense	2 - 2	Sporting CP	1
04 Feb 11	Finalizado	Sporting CP	3 - 3	Naval	3
24 Ene 11	Finalizado	Marítimo	0 - 3	Sporting CP	3
15 Ene 11	Finalizado	Sporting CP	2 - 3	Paços de Ferreira	2
08 Ene 11	Finalizado	Sporting CP	2 - 1	Sporting Braga	7
20 Dic 10	Finalizado	Vitória Setúbal	0 - 3	Sporting CP	5
05 Dic 10	Finalizado	Portimonense	1 - 3	Sporting CP	1
27 Nov 10	Finalizado	Sporting CP	1 - 1	Porto	8
13 Nov 10	Finalizado	Académica	1 - 2	Sporting CP	2
08 Nov 10	Finalizado	Sporting CP	2 - 3	Vitória Guimarães	0
31 Oct 10	Finalizado	União de Leiria	1 - 2	Sporting CP	2
24 Oct 10	Finalizado	Sporting CP	1 - 0	Rio Ave	1
04 Oct 10	Finalizado	Beira Mar SC	1 - 1	Sporting CP	1
26 Sep 10	Finalizado	Sporting CP	1 - 1	Nacional	2
19 Sep 10	Finalizado	Benfica	2 - 0	Sporting CP	6
11 Sep 10	Finalizado	Sporting CP	0 - 0	Olhanense	1
30 Ago 10	Finalizado	Naval	1 - 3	Sporting CP	3
22 Ago 10	Finalizado	Sporting CP	1 - 0	Marítimo	2
14 Ago 10	Finalizado	Paços de Ferreira	1 - 0	Sporting CP	2

Taça de Portugal »

11 Dic 10	Finalizado	Vitória Setúbal	2 - 1	Sporting CP
21 Nov 10	Finalizado	Sporting CP	1 - 0	Paços de Ferreira
16 Oct 10	Finalizado	Estoril	1 - 2	Sporting CP

Partidos Amistosos »

25 Jul 10	Finalizado	Sporting CP	2 - 1	Tottenham Hotspur	1
23 Jul 10	Finalizado	Sporting CP	2 - 0	Manchester City	4
18 Jul 10	Finalizado	Sporting CP	2 - 0	Olympique Lyonnais	3
14 Jul 10	Finalizado	PSG	4 - 2	Sporting CP	2

Fase Previa Europa League »

26 Ago 10	Finalizado	Brøndby IF	0 - 3	Sporting CP
19 Ago 10	Finalizado	Sporting CP	0 - 2	Brøndby IF
05 Ago 10	Finalizado	Sporting CP	2 - 1	Nordsjaelland
29 Jul 10	Finalizado	Nordsjaelland	0 - 1	Sporting CP

Copa de la Liga Portugal »

02 Mar 11

Finalizado

Benfica

2 - 1

Sporting CP

Fases Previas Copa de la Liga »

29 Ene 11	Finalizado	Estoril	2 - 1	Sporting CP
20 Ene 11	Finalizado	Sporting CP	4 - 0	Penafiel
03 Ene 11	Finalizado	Sporting CP	2 - 0	Naval

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Maniche1

Plantilla del Sporting CP Temporada 2010/2011

		Edad	Altura	Peso
Portero
1	Rui Patrício	36	190	84	-	-	4
30	T. Hildebrand	45	185	79	-	-	-
16	Tiago	49	180	78	-	-	-
Defensa
4	Â. Polga	45	182	79	-	-	4
78	Abel	45	178	75	2	-	2
41	Cédric Soares	32	171	79	-	-	-
3	D. Carriço	35	182	79	-	-	6
5	Evaldo	42	184	80	-	-	5
47	João Pereira	40	172	64	2	1	6
18	L. Grimi	39	175	70	-	-	2
2	M. Torsiglieri	36	190	86	-	-	3
44	Nuno André Coelho	38	192	82	-	-	-
Centrocampista
21	A. Zapater	38	180	80	2	-	4
26	André Santos	35	180	78	2	1	8
80	Cristiano	40	174	67	-	-	-
15	J. Valdés	43	175	70	5	-	5
14	M. Fernández	37	178	72	5	-	4
7	M. Izmailov	41	172	71	-	-	-
8	Maniche	46	173	72	1	1	5
6	Pedro Mendes	45	177	77	-	-	3
49	W. Carvalho	32	187	83	-	-	-
43	Zezinho	31	176	73	-	-	-
Delantero
9	C. Saleiro	38	185	76	1	-	6
33	Diogo Salomão	35	174	66	2	-	-
23	Hélder Postiga	41	182	79	6	-	8
31	Liédson	46	175	63	5	-	3
77	S. Vukcevic	38	179	77	2	-	4
	Wilson Eduardo	33	179	72	5	-	2
20	Y. Djaló	37	171	60	6	-	4

Noticias del Sporting CP

Ver últimas noticias

El futuro de Teo Gutiérrez pasa por Portugal

Sergio Álvarez - Viernes, 03 Julio 2015

0 586

La prensa lusa está convencida de que el jugador del River Plate jugará en el Sporting de Lisboa.

Martunis, tras sobrevivir al tsunami de 2004, ficha por el Sporting de Lisboa

Manuel Gutiérrez - Viernes, 03 Julio 2015

1 549

El talento indonesio, que sobrevivió al desastre de 2004, llega al Sporting de Lisboa y sigue de esta manera los pasos de Cristiano Ronaldo.

Macron revela las nuevas equipaciones del Sporting de Lisboa

BeSoccer - Jueves, 02 Julio 2015

0 198

El club portugués vestirá en la 2015-16 unos uniformes de lo más sobrios y elegantes.

Conceição, despedido por insultar al presidente

BeSoccer - Miércoles, 01 Julio 2015

0 160

El Sporting de Braga portugués anunció la rescisión del contrato de Sérgio Conceição por despido procedente, después de haberle abierto un proceso disciplinario por insultar y amenazar con agredir al presidente.

Cédric Soares, al Southampton por 6'5 millones de euros

BeSoccer - Viernes, 19 Junio 2015

0 257

El Sporting de Lisboa cerró con el Southampton inglés el traspaso del lateral derecho Cédric, internacional con Portugal y titular habitual en el equipo durante las últimas temporadas, a cambio de 6,5 millones de euros.

Ver más noticias del equipo»

Competiciones que juega

Liga Portuguesa

Pos	Equipos		Pts
1		Porto	84
2		Benfica	63
3		Sporting CP	48
4		Sporting Braga	46
5		Vitória Guimarães	43
6		Nacional	42
7		Paços de Ferreira	41
8		Rio Ave	38
9		Marítimo	35
10		União de Leiria	35
11		Olhanense	34
12		Vitória Setúbal	34
13		Beira Mar SC	33
14		Académica	30
15		Portimonense	25
16		Naval	23

	Champions League : Porto
	Previa de Champions : Benfica
	Europa League : Sporting CP, Sporting Braga, Vitória Guimarães, Nacional
	Descenso : Portimonense, Naval

RIVALES EN Europa League

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Portuguesa

RIVALES EN Fases Previas Co.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal

USO DE MEMORIA

7,145,568 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.2500
Total Execution Time	0.2518

CADENA URL

/Sporting-Lisbon/2011

GET DATOS

$_GET['/Sporting-Lisbon/2011']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0072	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 = 'Sporting-Lisbon' AND l.year = 2011 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=4098 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=4098 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=4098 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=4098 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=4098 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=4098 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=4098 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=4098 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=4098 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=4098 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 1235
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 = 1248
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 = 20494
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 = 42044
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 = 42898
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 = 20503
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 = 20525
0.0063	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 = '4098' AND l.year = 2011 ORDER BY l.year DESC,cat.coefficient DESC
0.0065	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 = '4098' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 1235 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 42044 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 = 1108 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 = 20525 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 = 20503 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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 = 20494 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	(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 calendars2011 as c ON c.league_id = l.id WHERE (c.datateam1 = 4098 or c.datateam2 = 4098) AND l.year = 2011 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0030	(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 calendars2011 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 = 4098 or c.datateam2 = 4098) AND l.year = 2011 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0035	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2011 as c ON c.league_id = l.id INNER JOIN events2011 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 = 4098 or c.datateam2 = 4098) AND l.year = 2011)
0.0042	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=4098 AND l.year in (2010,2011,2012) 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 (72572,42902,42852,20527,20525,20495,1500,1349,1323) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 1349 AND teamId = 4098
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 1500 AND teamId = 4098
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 20495 AND teamId = 4098
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 42852 AND teamId = 4098
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 42902 AND teamId = 4098
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 20525 AND teamId = 4098
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 20527 AND teamId = 4098
0.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 1323 AND teamId = 4098
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 72572 AND teamId = 4098
0.0033	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2011` 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 = 1108 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 events2011 e ON e.player_id = p.id AND e.league_id = 1108 WHERE rp.league_id = 1108 AND rp.teamId = 4098 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.0073	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 events2011 e ON e.player_id = p.id AND e.league_id = 1108 WHERE rp.league_id = 1108 AND rp.teamId = 4098 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0073	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 events2011 e ON e.player_id = p.id AND e.league_id = 1108 WHERE rp.league_id = 1108 AND rp.teamId = 4098 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042	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 = 4098 AND rp.league_id = 1108 AND l.year= 2011 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0032	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=25074 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=25074
0.0049	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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=25074 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.0038	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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=25074 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0039	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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=25074 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0031	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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=25074 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 events2011 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=25074 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

Sporting CP

Información sobre Sporting CP

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Sporting CP

Estadísticas

Plantilla del Sporting CP Temporada 2010/2011

Noticias del Sporting CP

Sporting CP

Selecciona un equipo

Competiciones que juega

RIVALES EN Europa League

RIVALES EN Fase Previa Euro.

RIVALES EN Liga Portuguesa

RIVALES EN Fases Previas Co.

RIVALES EN Copa de la Liga.

RIVALES EN Taça de Portugal