04 Abr 06	Finalizado	Milan	3 - 1	Olympique Lyonnais	1
29 Mar 06	Finalizado	Olympique Lyonnais	0 - 0	Milan	0
08 Mar 06	Finalizado	Olympique Lyonnais	4 - 0	PSV	0
21 Feb 06	Finalizado	PSV	0 - 1	Olympique Lyonnais	0
06 Dic 05	Finalizado	Olympique Lyonnais	2 - 1	Rosenborg BK	1
23 Nov 05	Finalizado	Real Madrid	1 - 1	Olympique Lyonnais	0
01 Nov 05	Finalizado	Olympiacos Piraeus	1 - 4	Olympique Lyonnais	0
19 Oct 05	Finalizado	Olympique Lyonnais	2 - 1	Olympiacos Piraeus	0
28 Sep 05	Finalizado	Rosenborg BK	0 - 1	Olympique Lyonnais	0
13 Sep 05	Finalizado	Olympique Lyonnais	3 - 0	Real Madrid	0

Ligue 1 »

13 May 06	Finalizado	Olympique Lyonnais	8 - 1	Le Mans
06 May 06	Finalizado	Lille	4 - 0	Olympique Lyonnais
29 Abr 06	Finalizado	Olympique Lyonnais	4 - 0	Saint-Étienne
23 Abr 06	Finalizado	Monaco	2 - 1	Olympique Lyonnais
15 Abr 06	Finalizado	PSG	0 - 1	Olympique Lyonnais
08 Abr 06	Finalizado	Olympique Lyonnais	2 - 1	Nice
01 Abr 06	Finalizado	Troyes	0 - 1	Olympique Lyonnais
25 Mar 06	Finalizado	Olympique Lyonnais	1 - 1	Toulouse
18 Mar 06	Finalizado	Sochaux	0 - 4	Olympique Lyonnais
11 Mar 06	Finalizado	Olympique Lyonnais	4 - 0	Metz
04 Mar 06	Finalizado	Ajaccio	1 - 3	Olympique Lyonnais
25 Feb 06	Finalizado	Olympique Lyonnais	1 - 4	Stade Rennais
17 Feb 06	Finalizado	Olympique Lyonnais	3 - 1	Nantes
11 Feb 06	Finalizado	Lens	1 - 1	Olympique Lyonnais
05 Feb 06	Finalizado	Olympique Lyonnais	0 - 0	Girondins Bordeaux
22 Ene 06	Finalizado	Olympique Lyonnais	1 - 1	Auxerre
14 Ene 06	Finalizado	Nancy	0 - 2	Olympique Lyonnais
11 Ene 06	Finalizado	Olympique Lyonnais	2 - 1	Olympique Marseille
04 Ene 06	Finalizado	Strasbourg	0 - 4	Olympique Lyonnais
16 Dic 05	Finalizado	Olympique Lyonnais	1 - 3	Lille
11 Dic 05	Finalizado	Saint-Étienne	0 - 0	Olympique Lyonnais
03 Dic 05	Finalizado	Olympique Lyonnais	2 - 0	PSG
26 Nov 05	Finalizado	Nice	1 - 1	Olympique Lyonnais
19 Nov 05	Finalizado	Olympique Lyonnais	2 - 1	Troyes
05 Nov 05	Finalizado	Toulouse	0 - 1	Olympique Lyonnais
29 Oct 05	Finalizado	Olympique Lyonnais	1 - 0	Sochaux
22 Oct 05	Finalizado	Metz	0 - 4	Olympique Lyonnais
16 Oct 05	Finalizado	Olympique Lyonnais	3 - 2	Ajaccio
02 Oct 05	Finalizado	Stade Rennais	1 - 3	Olympique Lyonnais
25 Sep 05	Finalizado	Nantes	0 - 1	Olympique Lyonnais
22 Sep 05	Finalizado	Olympique Lyonnais	1 - 1	Lens
17 Sep 05	Finalizado	Girondins Bordeaux	1 - 1	Olympique Lyonnais
10 Sep 05	Finalizado	Olympique Lyonnais	2 - 1	Monaco
28 Ago 05	Finalizado	Auxerre	0 - 2	Olympique Lyonnais
20 Ago 05	Finalizado	Olympique Lyonnais	1 - 0	Nancy
14 Ago 05	Finalizado	Olympique Marseille	1 - 1	Olympique Lyonnais
07 Ago 05	Finalizado	Olympique Lyonnais	1 - 0	Strasbourg
31 Jul 05	Finalizado	Le Mans	1 - 2	Olympique Lyonnais

Copa de Francia »

11 Abr 06	Finalizado	Olympique Lyonnais	1 - 2	Olympique Marseille
21 Mar 06	Finalizado	Olympique Lyonnais	1 - 0	Bastia
01 Feb 06	Finalizado	Ajaccio	1 - 2	Olympique Lyonnais
08 Ene 06	Finalizado	Grenoble	0 - 4	Olympique Lyonnais

Copa de la Liga »

25 Oct 05

Finalizado

Nantes

1 - 1

Olympique Lyonnais

Peace Cup »

24 Jul 05	Finalizado	Olympique Lyonnais	1 - 3	Tottenham Hotspur
20 Jul 05	Finalizado	Olympique Lyonnais	1 - 1	PSV
17 Jul 05	Finalizado	Olympique Lyonnais	2 - 1	Seongnam FC
15 Jul 05	Finalizado	Once Caldas	1 - 1	Olympique Lyonnais

Supercopa Francia »

27 Jul 05

Finalizado

Auxerre

1 - 4

Olympique Lyonnais

Estadísticas

GOLEADORES

Fred14

AMARILLAS

ROJAS

Plantilla del Olympique Lyonnais Temporada 2005/2006

		Edad	Altura	Peso
Portero
1	G. Coupet	51	181	80	-	-	2
30	R. Vercoutre	43	185	78	-	-	-
Defensa
12	A. Réveillère	44	180	76	-	-	3
5	C. Caçapa	47	184	77	2	-	2
3	Cris	46	183	77	3	-	3
	E. Abidal	44	186	75	-	-	1
	F. Clerc	41	187	77	-	-	1
23	Jérémy Berthod	39	180	75	1	-	3
	L. Diatta	48	183	76	-	1	2
	P. Muller	47	180	64	1	-	-
24	S. Monsoreau	43	186	80	-	-	2
Centrocampista
26	B. Pedretti	43	178	71	2	-	3
10	F. Malouda	43	181	73	6	-	6
18	H. Ben Arfa	37	178	65	-	-	-
6	J. Clement	39	174	61	-	-	2
	Juninho	49	179	74	9	-	5
7	M. Diarra	42	182	80	3	-	9
	Tiago	42	183	75	5	-	8
Delantero
	Fred	40	185	84	14	-	5
9	J. Carew	44	195	89	8	-	4
	K. Benzema	36	185	79	1	-	1
	P. Frau	44	175	73	5	-	1
14	S. Govou	44	175	70	5	-	3
22	S. Wiltord	49	175	76	12	-	-

Noticias del Olympique Lyonnais

Ver últimas noticias

0-2. El Villarreal cierra la Copa Emirates con nota tras ganar al Olympique de Lyon

BeSoccer - Domingo, 26 Julio 2015

0 1.617

El Villarreal cerró con victoria por dos goles a cero frente al Olympique de Lyon, su participación en la Copa Emirates en un partido en el que los castellonenses siguieron en la buena línea exhibida en el partido del pasado sábado frente al Wolfsburgo alemán.

Lucas Hernández despierta el interés del Lyon

Jaime Velasco - Martes, 21 Julio 2015

0 1.195

El jugador internacional Sub 19 francés podría volver a su país. El conjunto de la capital prefiere que siga en España.

La Premier vuelve a fijarse en Lacazette

Sergio Álvarez - Jueves, 09 Julio 2015

0 1.888

El Liverpool está muy interesado en el máximo goleador de la Ligue 1 y es una de las joyas más codiciadas del mercado, aunque el interés por él se había enfriado bastante en las últimas semanas.

La estrella del Lyon, Fekir, renueva su contrato

BeSoccer - Miércoles, 08 Julio 2015

0 378

El Olympique de Lyon no quiere dejar escapar a sus promesas. El último en ser renovado, Nabil Fekir, centrocampista que completó una espectacular temporada el pasado año y que anotó 15 goles en 39 encuentros.

Carew debuta en las grandes pantallas como mafioso

BeSoccer - Viernes, 26 Junio 2015

1 126

El ex jugador del Valencia se ha pasado al cine y en su debut, en una película noruega, ejercerá de mafioso.

Ver más noticias del equipo»

Competiciones que juega

Ligue 1

Pos	Equipos		Pts
1		Olympique Lyonnais	84
2		Girondins Bordeaux	69
3		Lille	62
4		Lens	60
5		Olympique Marseille	60
6		Auxerre	59
7		Stade Rennais	59
8		Nice	58
9		PSG	52
10		Monaco	52
11		Le Mans	52
12		Nancy	48
13		Saint-Étienne	47
14		Nantes	45
15		Sochaux	44
16		Toulouse	41
17		Troyes	39
18		Ajaccio	33
19		Strasbourg	29
20		Metz	29

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

RIVALES EN Supercopa Franci.

USO DE MEMORIA

6,924,128 bytes

BENCHMARKS

Loading Time Base Classes	0.0027
Controller Execution Time ( Home / Category )	0.8285
Total Execution Time	0.8312

CADENA URL

/Olympique-Lyonnais/2006

GET DATOS

$_GET['/Olympique-Lyonnais/2006']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0130	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 = 'Olympique-Lyonnais' AND l.year = 2006 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.0106	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0108	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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0120	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 = 53
0.0126	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 = 9608
0.0123	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 = 9615
0.0124	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 = 20484
0.0125	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 = 20542
0.0126	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 = 20553
0.0140	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 = 71981
0.0137	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 = 71983
0.0112	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1866 AND type_rel = 2
0.0247	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1866 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0108	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 (702,1988,2072,3302,3750) ORDER BY n.cover_points DESC, update_date DESC
0.0125	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 = '1866' AND l.year = 2006 ORDER BY l.year DESC,cat.coefficient DESC
0.0125	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 = '1866' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107	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 = 9608 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112	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 = 20484 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115	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 = 20542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0118	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 = 53 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112	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 = 20553 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	(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 calendars2006 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 2006 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0175	(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 calendars2006 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 = 1866 or c.datateam2 = 1866) AND l.year = 2006 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0169	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2006 as c ON c.league_id = l.id INNER JOIN events2006 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 = 1866 or c.datateam2 = 1866) AND l.year = 2006)
0.0194	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=1866 AND l.year in (2005,2006,2007) ORDER BY l.id DESC, l.year DESC ;
0.0117	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 (71983,24672,20543,20485,9622,54) 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.0170	SELECT count(id) as num_players from rel_players WHERE league_id = 54 AND teamId = 1866
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 9622 AND teamId = 1866
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 20485 AND teamId = 1866
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 20543 AND teamId = 1866
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 24672 AND teamId = 1866
0.0110	SELECT count(id) as num_players from rel_players WHERE league_id = 71983 AND teamId = 1866
0.0127	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2006` 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 = 53 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0197	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 events2006 e ON e.player_id = p.id AND e.league_id = 53 WHERE rp.league_id = 53 AND rp.teamId = 1866 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.0196	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 events2006 e ON e.player_id = p.id AND e.league_id = 53 WHERE rp.league_id = 53 AND rp.teamId = 1866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0191	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 events2006 e ON e.player_id = p.id AND e.league_id = 53 WHERE rp.league_id = 53 AND rp.teamId = 1866 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 = 1866 AND rp.league_id = 53 AND l.year= 2006 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0125	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=2621 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0108	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=2621
0.0123	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2621 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.0115	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2621 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0114	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2621 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0113	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2621 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0114	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 events2006 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=2621 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0107	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 = 53 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

Olympique Lyonnais

Información sobre Olympique Lyonnais

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del Olympique Lyonnais

Estadísticas

Plantilla del Olympique Lyonnais Temporada 2005/2006

Noticias del Olympique Lyonnais

Olympique Lyonnais

Selecciona un equipo

Competiciones que juega

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

RIVALES EN Supercopa Franci.