02 Dic 04	Finalizado	Aigaleo FC Athens	2 - 2	Lazio
25 Nov 04	Finalizado	Lazio	2 - 2	Partizan Belgrade
04 Nov 04	Finalizado	Middlesbrough	2 - 0	Lazio
21 Oct 04	Finalizado	Lazio	1 - 1	Villarreal
30 Sep 04	Finalizado	Lazio	3 - 0	Metalurh Donetsk
16 Sep 04	Finalizado	Metalurh Donetsk	0 - 3	Lazio

Serie A »

29 May 05	Finalizado	Palermo FC	3 - 3	Lazio
22 May 05	Finalizado	Lazio	1 - 1	Fiorentina
15 May 05	Finalizado	Roma	0 - 0	Lazio
08 May 05	Finalizado	Lazio	0 - 1	Udinese
01 May 05	Finalizado	Lecce	5 - 3	Lazio
24 Abr 05	Finalizado	Lazio	0 - 1	Juventus
20 Abr 05	Finalizado	Cagliari	1 - 1	Lazio
17 Abr 05	Finalizado	Bologna	1 - 2	Lazio
10 Abr 05	Finalizado	Lazio	3 - 1	Livorno
19 Mar 05	Finalizado	Siena	1 - 0	Lazio
12 Mar 05	Finalizado	Lazio	1 - 1	Inter
06 Mar 05	Finalizado	ACR Messina	1 - 0	Lazio
27 Feb 05	Finalizado	Lazio	2 - 0	Parma
20 Feb 05	Finalizado	Chievo	0 - 1	Lazio
12 Feb 05	Finalizado	Lazio	2 - 1	Atalanta
06 Feb 05	Finalizado	Milan	2 - 1	Lazio
02 Feb 05	Finalizado	Lazio	0 - 0	Brescia
30 Ene 05	Finalizado	Reggina	2 - 1	Lazio
23 Ene 05	Finalizado	Lazio	1 - 2	Sampdoria
16 Ene 05	Finalizado	Lazio	1 - 3	Palermo FC
09 Ene 05	Finalizado	Fiorentina	2 - 3	Lazio
06 Ene 05	Finalizado	Lazio	3 - 1	Roma
19 Dic 04	Finalizado	Udinese	3 - 0	Lazio
11 Dic 04	Finalizado	Lazio	3 - 3	Lecce
05 Dic 04	Finalizado	Juventus	2 - 1	Lazio
28 Nov 04	Finalizado	Lazio	2 - 3	Cagliari
14 Nov 04	Finalizado	Lazio	2 - 1	Bologna
10 Nov 04	Finalizado	Livorno	1 - 0	Lazio
07 Nov 04	Finalizado	Lazio	1 - 1	Siena
30 Oct 04	Finalizado	Inter	1 - 1	Lazio
27 Oct 04	Finalizado	Lazio	2 - 0	ACR Messina
24 Oct 04	Finalizado	Parma	3 - 1	Lazio
17 Oct 04	Finalizado	Lazio	0 - 1	Chievo
03 Oct 04	Finalizado	Atalanta	1 - 1	Lazio
26 Sep 04	Finalizado	Lazio	1 - 2	Milan
22 Sep 04	Finalizado	Brescia	0 - 2	Lazio
19 Sep 04	Finalizado	Lazio	1 - 1	Reggina
12 Sep 04	Finalizado	Sampdoria	0 - 1	Lazio

Coppa Italia »

	13 Ene 05	Finalizado	Lazio	3 - 2	Cagliari			0
	21 Nov 04	Finalizado	Cagliari	2 - 1	Lazio			0

Supercopa de Italia »

21 Ago 04

Finalizado

Milan

3 - 0

Lazio

Trofeo Ramón de Carranza »

	15 Ago 04	Finalizado	Cádiz	1 - 0	Lazio			0
	14 Ago 04	Finalizado	Valencia	3 - 0	Lazio			0

Estadísticas

GOLEADORES

AMARILLAS

O. Dabo12

ROJAS

César2

O. Dabo1

Plantilla del Lazio Temporada 2004/2005

		Edad	Altura	Peso
Portero
1	A. Peruzzi	54	180	83	-	1	-
47	Alessio De Angelis	39	-	-	-	-	-
15	Fabrizio Casazza	53	179	81	-	-	-
33	M. Sereni	49	187	86	-	-	1
Defensa
37	Angeletti	38	180	75	-	-	-
25	Anthony Seric	45	181	73	-	-	4
42	Fabio Zaccardi	37	-	-	-	-	-
24	Fernando Couto	54	184	81	3	2	6
3	L. Talamonti	42	183	77	1	-	4
8	L. Zauri	46	178	75	-	-	3
28	M. Lequi	42	191	83	-	-	-
22	M. Oddo	47	182	76	4	-	7
4	Óscar López	43	180	81	-	-	1
23	Paolo Negro	52	183	71	-	-	-
5	S. Siviglia	51	183	70	2	1	5
43	Simone Sannibale	38	185	77	-	-	-
Centrocampista
7	A. Filippini	50	172	70	2	-	7
10	César	49	180	71	3	2	4
13	Dino Baggio	52	188	72	-	-	-
26	E. González	45	188	83	-	-	1
20	F. Liverani	47	175	73	1	-	2
14	Filippini	50	170	64	-	-	8
16	G. Giannichedda	49	178	76	-	1	9
30	M. Mea Vitali	43	179	77	-	-	-
17	Manfredini	48	180	73	1	-	1
6	O. Dabo	47	185	83	1	1	12
Delantero
44	C. De Sousa	38	182	74	1	-	1
41	Delgado	37	180	79	-	-	-
29	Fabio Bazzani	47	185	77	5	-	9
19	G. Pandev	40	184	75	3	-	2
9	P. Di Canio	55	178	70	6	1	3
11	Roberto Muzzi	52	178	70	3	-	2
21	S. Inzaghi	48	185	77	1	-	4
18	T. Rocchi	46	177	75	13	1	4

Noticias del Lazio

Ver últimas noticias

Esto es la Juve

Juanma Velasco - Martes, 23 Abril 2024

0 9.204

La Juventus metió la cabeza en la gran final de la Coppa Italia pese a caer por 2-1 en el Olímpico de Roma ante la Lazio. Un gol de Milik en el 83' fue suficiente para una 'Vecchia Signora' que, pese a estar desaparecida en la Ciudad Eterna, aprovechó la mejor ocasión que tuvo para colarse en la batalla por el título.

Así seguimos el directo del Lazio - Juventus

BeSoccer - Martes, 23 Abril 2024

1 5.733

Vive con nosotros todas las incidencias del Lazio-Juventus, partido correspondiente a la vuelta de semifinales de la Coppa Italia 2023-24 que se va a disputar en el Olímpico de Roma.

La Lazio activa la opción de compra de Guendouzi

BeSoccer - Sábado, 20 Abril 2024

0 291

Fabrizio Romano, periodista especializado en el mercado de fichajes, informa de que la Lazio ha activado la opción de compra de Mattéo Guendouzi para quedárselo procedente del Olympique de Marsella con un pago de 13 millones de euros más 5 en variables. El centrocampista francés se ha convertido en una pieza clave del equipo italiano, con el que hasta fue 'MVP' de la ida de los octavos de final de la Champions League contra el Bayern de Múnich.

Van Gaal se cansa de Ramos y piensa en De Vrij

Sergio Álvarez - Miércoles, 01 Julio 2015

0 824

El técnico del Manchester United sabe que la operación por el central de Camas es complicada y se habría fijado en su compatriota, que acaba de firmar una gran temporada en el Lazio.

Lucas Biglia enamora al Real Madrid

BeSoccer - Lunes, 29 Junio 2015

0 167

El Real Madrid estaría muy interesado en el argentino Lucas Biglia para reforzar su centro del campo y pagaría unos 22 millones de euros por el argentino.

Ver más noticias del equipo»

Competiciones que juega

Grupo 5

Serie A

Pos	Equipos		Pts
1		Juventus	86
2		Milan	79
3		Inter	72
4		Udinese	62
5		Sampdoria	61
6		Palermo FC	53
7		ACR Messina	48
8		Roma	45
9		Livorno	45
10		Lazio	44
11		Lecce	44
12		Cagliari	44
13		Reggina	44
14		Siena	43
15		Chievo	43
16		Fiorentina	42
17		Parma	42
18		Bologna	42
19		Brescia	41
20		Atalanta	35

	Champions League : Juventus, Milan
	Previa de Champions : Inter, Udinese
	UEFA : Sampdoria, Palermo FC, Roma
	Intertoto : Lazio
	Descenso : Bologna, Brescia, Atalanta

RIVALES EN Coppa Italia

RIVALES EN Europa League

RIVALES EN Serie A

RIVALES EN Supercopa de Ita.

Lazio
Milan

USO DE MEMORIA

6,880,704 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.8870
Total Execution Time	0.8889

CADENA URL

/Lazio/2005

GET DATOS

$_GET['/Lazio/2005']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0169	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 = 'Lazio' AND l.year = 2005 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=1526 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=1526 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=1526 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=1526 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=1526 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=1526 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=1526 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 10979
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 = 10989
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 = 14122
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 = 20563
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 = 72581
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1526 AND type_rel = 2
0.0172	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1526 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147	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 (1312313,1312243,1311769,851,1157) ORDER BY n.cover_points DESC, update_date DESC
0.0162	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 = '1526' AND l.year = 2005 ORDER BY l.year DESC,cat.coefficient DESC
0.0162	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 = '1526' 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 = 14122 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150	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 = 10979 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 34 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 = 20563 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	(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 calendars2005 as c ON c.league_id = l.id WHERE (c.datateam1 = 1526 or c.datateam2 = 1526) AND l.year = 2005 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0155	(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 calendars2005 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 = 1526 or c.datateam2 = 1526) AND l.year = 2005 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0153	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2005 as c ON c.league_id = l.id INNER JOIN events2005 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 = 1526 or c.datateam2 = 1526) AND l.year = 2005)
0.0160	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=1526 AND l.year in (2004,2005,2006) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72581,40734,20563,14131,11987,10989,9634,35) 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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 35 AND teamId = 1526
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 9634 AND teamId = 1526
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 10989 AND teamId = 1526
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 14131 AND teamId = 1526
0.0145	SELECT count(id) as num_players from rel_players WHERE league_id = 20563 AND teamId = 1526
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 40734 AND teamId = 1526
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 11987 AND teamId = 1526
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 72581 AND teamId = 1526
0.0151	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2005` 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 = 34 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0166	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 events2005 e ON e.player_id = p.id AND e.league_id = 34 WHERE rp.league_id = 34 AND rp.teamId = 1526 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 events2005 e ON e.player_id = p.id AND e.league_id = 34 WHERE rp.league_id = 34 AND rp.teamId = 1526 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0162	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 events2005 e ON e.player_id = p.id AND e.league_id = 34 WHERE rp.league_id = 34 AND rp.teamId = 1526 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 1526 AND rp.league_id = 34 AND l.year= 2005 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0153	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=2161 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=2161
0.0152	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 events2005 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2161 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.0151	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 events2005 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2161 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0152	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 events2005 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2161 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0150	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 events2005 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2161 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0150	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 events2005 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2161 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0146	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 = 34 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

Lazio

Información sobre Lazio

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Lazio

Estadísticas

Plantilla del Lazio Temporada 2004/2005

Noticias del Lazio

Lazio

Selecciona un equipo

Competiciones que juega

RIVALES EN Coppa Italia

RIVALES EN Europa League

RIVALES EN Serie A

RIVALES EN Supercopa de Ita.