Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Lazio

Entrenador: Igor Tudor

Temporada 2004/2005

Información sobre Lazio

Enviar Datos

Información

Nombre del equipo Lazio
Nombre completo Società Sportiva Lazio
Nombre corto LAZ
País Italia
Ciudad Roma, Italia
Entrenador Igor Tudor
URL del equipo en RF //m.resultados-futbol.com/Lazio

Otros Datos

Año de Fundación 1900
Marca de Ropa Macron

Internet

Sitio Web www.sslazio.it/
Twitter principal @officialsslazio

Información sobre el estadio

Nombre del estadio Stadio Olimpico
Capacidad 82656
Dirección Viale dei Gladiatori, 2 / Via del Foro Italico
Teléfono +39 (06) 976 071
Fax +39 (06) 904 00022
Año de construcción 1952
Tamaño 105 x 68 metros

Histórico de participación

Coppa Italia

84 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1989, 1989, 1988, 1987, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1981, 1980, 1980, 1979, 1979, 1978, 1977, 1976, 1976, 1975, 1974, 1974, 1973, 1972, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1958, 1943, 1942, 1941, 1940, 1939, 1938, 1937)

Serie A

83 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1985, 1984, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1971, 1970, 1967, 1966, 1965, 1964, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1946, 1943, 1942, 1941, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929)

Europa League Grupo 6

29 veces

(2023, 2022, 2022, 2020, 2019, 2019, 2018, 2018, 2016, 2016, 2014, 2014, 2013, 2013, 2012, 2012, 2010, 2010, 2005, 2005, 2003, 1998, 1997, 1996, 1995, 1994, 1978, 1976, 1974)

Partidos Amistosos

14 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Champions League Grupo 5

12 veces

(2024, 2024, 2021, 2021, 2008, 2004, 2002, 2001, 2001, 2000, 2000, 2000)

Serie B

12 veces

(1988, 1987, 1986, 1983, 1982, 1981, 1972, 1969, 1968, 1963, 1962, 1927)

Supercopa de Italia

9 veces

(2024, 2020, 2018, 2016, 2014, 2010, 2005, 2001, 1999)

Fase Previa Champions League Grupo 4

4 veces

(2016, 2008, 2004, 2002)

Fase Previa Europa League Grupo 4

3 veces

(2013, 2012, 2010)

Serie B - Play Offs Permanencia

1 vez

(1987)

Partidos del Lazio

Ir al LIVESCORE

Europa League »

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	48	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	49	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

Monza y Lazio firmaron las tablas (2-2) en la jornada 35 de la Serie A. Milan Djuric rascó la igualdad en el añadido para frenar el asalto del cuadro 'biancocelesti' a la sexta plaza con dirección la Europa League.

Afellay suena para la Lazio

BeSoccer - Viernes, 03 Julio 2015

0 296

El mediapunta holandés está libre tras desvincularse del Barcelona y podría haberse ofrecido al equipo romano, que jugará la Champions League la próxima temporada.

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.

El serbio Sinisa Mihajlovic, nuevo entrenador del A.C Milan

BeSoccer - Lunes, 22 Junio 2015

0 98

El serbio Sinisa Mihajlovic, ex técnico del Sampdoria italiano, entrenará al A.C Milán durante la próxima temporada, informó la sociedad milanesa en un comunicado.

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,825,936 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.9665
Total Execution Time	0.9686

CADENA URL

/Lazio/2005

GET DATOS

$_GET['/Lazio/2005']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0189	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.0147	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.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=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.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 = 34
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 = 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.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 = 20563
0.0149	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.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1526 AND type_rel = 2
0.0178	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.0159	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 (1313916,404,851,1157,1418) 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.0165	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.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 = 10979 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 = 34 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 = 20563 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153	(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.0158	(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.0156	(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.0189	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.0154	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.0197	SELECT count(id) as num_players from rel_players WHERE league_id = 35 AND teamId = 1526
0.0232	SELECT count(id) as num_players from rel_players WHERE league_id = 9634 AND teamId = 1526
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 10989 AND teamId = 1526
0.0161	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.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 40734 AND teamId = 1526
0.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 11987 AND teamId = 1526
0.0161	SELECT count(id) as num_players from rel_players WHERE league_id = 72581 AND teamId = 1526
0.0159	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.0258	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.0221	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.0209	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.0155	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.0155	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.0146	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=2161
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 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.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 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.0160	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.0160	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.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 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.0153	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

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.