07 Mar 12	Finalizado	APOEL	1 - 0	Olympique Lyonnais	190
14 Feb 12	Finalizado	Olympique Lyonnais	1 - 0	APOEL	64
07 Dic 11	Finalizado	Dinamo Zagreb	1 - 7	Olympique Lyonnais	66
22 Nov 11	Finalizado	Olympique Lyonnais	0 - 0	Ajax	4
02 Nov 11	Finalizado	Olympique Lyonnais	0 - 2	Real Madrid	181
18 Oct 11	Finalizado	Real Madrid	4 - 0	Olympique Lyonnais	88
27 Sep 11	Finalizado	Olympique Lyonnais	2 - 0	Dinamo Zagreb	7
14 Sep 11	Finalizado	Ajax	0 - 0	Olympique Lyonnais	13

Ligue 1 »

20 May 12	Finalizado	Olympique Lyonnais	3 - 4	Nice	3
13 May 12	Finalizado	Ajaccio	1 - 1	Olympique Lyonnais	1
10 May 12	Finalizado	Evian Thonon Gaillard	1 - 3	Olympique Lyonnais	1
06 May 12	Finalizado	Olympique Lyonnais	1 - 1	Stade Brestois	1
02 May 12	Finalizado	Olympique Lyonnais	4 - 1	Valenciennes	0
22 Abr 12	Finalizado	Olympique Lyonnais	3 - 2	Lorient	1
18 Abr 12	Finalizado	Toulouse	3 - 0	Olympique Lyonnais	8
07 Abr 12	Finalizado	Olympique Lyonnais	2 - 1	Auxerre	2
01 Abr 12	Finalizado	Stade Rennais	1 - 1	Olympique Lyonnais	2
24 Mar 12	Finalizado	Olympique Lyonnais	2 - 1	Sochaux	2
17 Mar 12	Finalizado	Saint-Étienne	0 - 1	Olympique Lyonnais	5
10 Mar 12	Finalizado	Olympique Lyonnais	2 - 1	Lille	12
03 Mar 12	Finalizado	Nancy	2 - 0	Olympique Lyonnais	3
25 Feb 12	Finalizado	Olympique Lyonnais	4 - 4	PSG	45
19 Feb 12	Finalizado	Girondins Bordeaux	1 - 0	Olympique Lyonnais	1
11 Feb 12	Finalizado	Olympique Lyonnais	1 - 2	Caen	3
05 Feb 12	Finalizado	Olympique Marseille	2 - 2	Olympique Lyonnais	0
28 Ene 12	Finalizado	Olympique Lyonnais	3 - 1	Dijon FCO	4
14 Ene 12	Finalizado	Montpellier	1 - 0	Olympique Lyonnais	4
21 Dic 11	Finalizado	Valenciennes	1 - 0	Olympique Lyonnais	1
17 Dic 11	Finalizado	Olympique Lyonnais	2 - 1	Evian Thonon Gaillard	2
11 Dic 11	Finalizado	Lorient	0 - 1	Olympique Lyonnais	16
04 Dic 11	Finalizado	Olympique Lyonnais	3 - 2	Toulouse	6
27 Nov 11	Finalizado	Auxerre	0 - 3	Olympique Lyonnais	2
18 Nov 11	Finalizado	Olympique Lyonnais	1 - 2	Stade Rennais	4
06 Nov 11	Finalizado	Sochaux	2 - 1	Olympique Lyonnais	2
29 Oct 11	Finalizado	Olympique Lyonnais	2 - 0	Saint-Étienne	4
23 Oct 11	Finalizado	Lille	3 - 1	Olympique Lyonnais	14
15 Oct 11	Finalizado	Olympique Lyonnais	3 - 1	Nancy	3
02 Oct 11	Finalizado	PSG	2 - 0	Olympique Lyonnais	4
24 Sep 11	Finalizado	Olympique Lyonnais	3 - 1	Girondins Bordeaux	5
21 Sep 11	Finalizado	Caen	1 - 0	Olympique Lyonnais	3
18 Sep 11	Finalizado	Olympique Lyonnais	2 - 0	Olympique Marseille	0
10 Sep 11	Finalizado	Dijon FCO	1 - 2	Olympique Lyonnais	4
27 Ago 11	Finalizado	Olympique Lyonnais	2 - 1	Montpellier	4
20 Ago 11	Finalizado	Stade Brestois	1 - 1	Olympique Lyonnais	3
13 Ago 11	Finalizado	Olympique Lyonnais	1 - 1	Ajaccio	5
06 Ago 11	Finalizado	Nice	1 - 3	Olympique Lyonnais	15

Copa de Francia »

28 Abr 12	Finalizado	Olympique Lyonnais	1 - 0	QRM
10 Abr 12	Finalizado	Gazélec Ajaccio	0 - 4	Olympique Lyonnais
21 Mar 12	Finalizado	PSG	1 - 3	Olympique Lyonnais
08 Feb 12	Finalizado	Olympique Lyonnais	3 - 1	Girondins Bordeaux
22 Ene 12	Finalizado	Luçon	0 - 2	Olympique Lyonnais
08 Ene 12	Finalizado	Lyon-Duchère	1 - 3	Olympique Lyonnais

Copa de la Liga »

14 Abr 12	Finalizado	Olympique Lyonnais	0 - 1	Olympique Marseille
31 Ene 12	Finalizado	Lorient	2 - 4	Olympique Lyonnais
11 Ene 12	Finalizado	Olympique Lyonnais	2 - 1	Lille
26 Oct 11	Finalizado	Saint-Étienne	1 - 2	Olympique Lyonnais

Fase Previa Champions League »

	24 Ago 11	Finalizado	Rubin Kazán	1 - 1	Olympique Lyonnais			0
	16 Ago 11	Finalizado	Olympique Lyonnais	3 - 1	Rubin Kazán			0

Partidos Amistosos »

04 Ene 12	Finalizado	Bastia	0 - 2	Olympique Lyonnais	0
31 Jul 11	Finalizado	Porto	1 - 1	Olympique Lyonnais	0
27 Jul 11	Finalizado	Shakhtar Donetsk	1 - 1	Olympique Lyonnais	1

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

M. Dabo1

Plantilla del Olympique Lyonnais Temporada 2011/2012

		Edad	Altura	Peso
Portero
40	Anthony Lopes	33	184	81	-	-	-
1	Hugo Lloris	37	188	73	-	1	-
16	J. Frick	31	192	88	-	-	-
50	M. Valverde	40	185	78	-	-	-
30	R. Vercoutre	43	185	78	-	-	-
Defensa
20	A. Cissokho	36	187	75	-	-	5
13	A. Réveillère	44	180	76	-	-	4
3	Cris	46	183	77	2	-	2
5	Dejan Lovren	34	188	86	1	1	5
26	J. Mensah	41	178	79	-	-	-
24	Jérémy Pied	35	173	69	1	-	-
4	Koné	35	188	80	2	-	6
2	L. Gassama	34	180	74	-	-	2
14	M. Dabo	37	176	65	-	1	2
33	Mehdi Zeffane	31	176	63	-	-	-
11	Michel Bastos	40	178	74	6	-	2
23	Samuel Umtiti	30	182	75	-	-	2
12	T. Kolodziejczak	32	183	73	-	-	-
Centrocampista
33	Amos Youga	31	186	83	-	-	-
7	C. Grenier	33	186	72	-	1	3
23	E. Reale	32	175	69	-	-	-
10	Ederson	38	181	74	2	-	-
15	G. Fofana	32	182	74	-	-	3
33	Jordan Ferri	32	173	70	-	-	-
6	K. Källström	41	182	79	-	-	6
21	M. Gonalons	35	187	76	1	-	7
8	M. Pjanić	34	178	68	1	-	1
22	S. Koné	31	185	73	-	1	-
25	Y. Benzia	29	178	71	-	-	-
8	Y. Gourcuff	37	185	79	2	1	1
Delantero
17	A. Lacazette	32	175	73	5	-	6
27	A. Pléa	31	181	72	-	-	-
18	B. Gomis	38	184	77	14	-	2
15	H. Novillo	32	182	80	-	-	-
39	I. Belfodil	32	192	86	-	-	-
19	J. Briand	38	181	84	9	-	3
9	L. López	41	174	74	16	-	2

Noticias del Olympique Lyonnais

Ver últimas noticias

Horarios y partidos de la jornada 30 de Ligue 1 2023-24

BeSoccer - Martes, 16 Abril 2024

0 14.851

La Liga Francesa ya comienza a tomar forma y en su trigésima jornada de partidos, se transcriben ya algunos equipos que podrían ser los líderes de la tabla en esta campaña. Encuentra aquí las fechas y los horario de los partidos de Ligue 1.

El Lyon saca todo su orgullo en una victoria de videojuego

BeSoccer - Domingo, 14 Abril 2024

0 2.126

El Olympique de Lyon ganó por 4-3 al Stade Brestois, que ocupa la 2ª posición de la Ligue 1, en un partido en el que los 'gones' llegaron a estar 1-3 abajo y en el que un gol de penalti de Maitland-Niles en el minuto 106 decantó la balanza en su favor. La remontada estuvo lanzada por Lacazette y Tagliafico. Alexandre hasta acabó magullado por un duro choque con el portero rival tras el que hubo que dar entrada a los servicios médicos.

La locura de Lyon: 4 goles en 10 minutos

BeSoccer - Domingo, 14 Abril 2024

0 1.897

El Olympique de Lyon-Brest vivió 10 minutos de auténtica locura. En el tiempo compendido entre el 60 y el 70, los visitantes marcaron 3 goles seguidos para remontar y el OL recortó distancias.

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.

Ver más noticias del equipo»

Competiciones que juega

Ligue 1

Pos	Equipos		Pts
1		Montpellier	82
2		PSG	79
3		Lille	74
4		Olympique Lyonnais	64
5		Girondins Bordeaux	61
6		Stade Rennais	60
7		Saint-Étienne	57
8		Toulouse	56
9		Evian Thonon Gaillard	50
10		Olympique Marseille	48
11		Nancy	45
12		Valenciennes	43
13		Nice	42
14		Sochaux	42
15		Stade Brestois	41
16		Ajaccio	41
17		Lorient	39
18		Caen	38
19		Dijon FCO	36
20		Auxerre	34

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

USO DE MEMORIA

7,079,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0018
Controller Execution Time ( Home / Category )	0.8805
Total Execution Time	0.8823

CADENA URL

/Olympique-Lyonnais/2012

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0108	SELECT type FROM routes WHERE alias = 'olympique-lyonnais'
0.0237	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 = 2012 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.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.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.0111	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.0112	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.0114	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.0115	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.0113	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.0134	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 = 1327
0.0133	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 = 1438
0.0133	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 = 1446
0.0135	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 = 20490
0.0132	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 = 20536
0.0134	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 = 42844
0.0109	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1866 AND type_rel = 2
0.0266	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.0120	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 (1257869,1310982,1310972,1988,2072) ORDER BY n.cover_points DESC, update_date DESC
0.0184	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 = 2012 ORDER BY l.year DESC,cat.coefficient DESC
0.0207	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.0116	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 = 1438 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110	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 = 42844 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113	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 = 20490 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108	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 = 20536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 1327 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0111	(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 calendars2012 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 2012 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0121	(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 calendars2012 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 = 2012 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0137	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2012 as c ON c.league_id = l.id INNER JOIN events2012 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 = 2012)
0.0150	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 (2011,2012,2013) ORDER BY l.id DESC, l.year DESC ;
0.0113	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 (42844,20537,20491,2257,2110,1910,1906,1446) 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.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 1910 AND teamId = 1866
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 1446 AND teamId = 1866
0.0143	SELECT count(id) as num_players from rel_players WHERE league_id = 2257 AND teamId = 1866
0.0165	SELECT count(id) as num_players from rel_players WHERE league_id = 20491 AND teamId = 1866
0.0121	SELECT count(id) as num_players from rel_players WHERE league_id = 20537 AND teamId = 1866
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 42844 AND teamId = 1866
0.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 2110 AND teamId = 1866
0.0117	SELECT count(id) as num_players from rel_players WHERE league_id = 1906 AND teamId = 1866
0.0109	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 = '1866' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0106	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1866' and rp.type = 4
0.0114	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 = '1866' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0110	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1866' and rp.type = 4
0.0204	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 events2012 e ON e.player_id = p.id AND e.league_id = 1327 WHERE rp.league_id = 1327 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.0230	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 events2012 e ON e.player_id = p.id AND e.league_id = 1327 WHERE rp.league_id = 1327 AND rp.teamId = 1866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2012 e ON e.player_id = p.id AND e.league_id = 1327 WHERE rp.league_id = 1327 AND rp.teamId = 1866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157	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 = 1327 AND l.year= 2012 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0136	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=29065 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0114	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=29065
0.0153	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 events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=29065 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.0149	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 events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=29065 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0145	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 events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=29065 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0145	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 events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=29065 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0153	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 events2012 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=29065 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

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