21 Feb 13	Finalizado	Olympique Lyonnais	1 - 1	Tottenham Hotspur	8
14 Feb 13	Finalizado	Tottenham Hotspur	2 - 1	Olympique Lyonnais	17
06 Dic 12	Finalizado	Olympique Lyonnais	2 - 0	Ironi Kiryat Shmona	1
22 Nov 12	Finalizado	Sparta Praha	1 - 1	Olympique Lyonnais	4
08 Nov 12	Finalizado	Athletic	2 - 3	Olympique Lyonnais	54
25 Oct 12	Finalizado	Olympique Lyonnais	2 - 1	Athletic	99
04 Oct 12	Finalizado	Ironi Kiryat Shmona	3 - 4	Olympique Lyonnais	2
20 Sep 12	Finalizado	Olympique Lyonnais	2 - 1	Sparta Praha	1

Ligue 1 »

26 May 13	Finalizado	Olympique Lyonnais	2 - 0	Stade Rennais	3
19 May 13	Finalizado	Nice	1 - 1	Olympique Lyonnais	6
12 May 13	Finalizado	Olympique Lyonnais	0 - 1	PSG	3
05 May 13	Finalizado	Nancy	0 - 3	Olympique Lyonnais	1
28 Abr 13	Finalizado	Olympique Lyonnais	1 - 1	Saint-Étienne	5
19 Abr 13	Finalizado	Montpellier	1 - 2	Olympique Lyonnais	5
14 Abr 13	Finalizado	Olympique Lyonnais	3 - 1	Toulouse	1
07 Abr 13	Finalizado	Stade de Reims	1 - 0	Olympique Lyonnais	3
31 Mar 13	Finalizado	Olympique Lyonnais	1 - 2	Sochaux	1
16 Mar 13	Finalizado	Bastia	4 - 1	Olympique Lyonnais	4
10 Mar 13	Finalizado	Olympique Lyonnais	0 - 0	Olympique Marseille	5
03 Mar 13	Finalizado	Stade Brestois	1 - 1	Olympique Lyonnais	2
24 Feb 13	Finalizado	Olympique Lyonnais	3 - 1	Lorient	1
17 Feb 13	Finalizado	Girondins Bordeaux	0 - 4	Olympique Lyonnais	3
10 Feb 13	Finalizado	Olympique Lyonnais	1 - 3	Lille	4
03 Feb 13	Finalizado	Ajaccio	3 - 1	Olympique Lyonnais	7
25 Ene 13	Finalizado	Valenciennes	0 - 2	Olympique Lyonnais	7
18 Ene 13	Finalizado	Olympique Lyonnais	0 - 0	Evian Thonon Gaillard	7
12 Ene 13	Finalizado	Troyes	1 - 2	Olympique Lyonnais	6
22 Dic 12	Finalizado	Olympique Lyonnais	3 - 0	Nice	2
16 Dic 12	Finalizado	PSG	1 - 0	Olympique Lyonnais	6
12 Dic 12	Finalizado	Olympique Lyonnais	1 - 1	Nancy	1
09 Dic 12	Finalizado	Saint-Étienne	0 - 1	Olympique Lyonnais	1
01 Dic 12	Finalizado	Olympique Lyonnais	1 - 0	Montpellier	2
28 Nov 12	Finalizado	Olympique Marseille	1 - 4	Olympique Lyonnais	9
25 Nov 12	Finalizado	Toulouse	3 - 0	Olympique Lyonnais	0
18 Nov 12	Finalizado	Olympique Lyonnais	3 - 0	Stade de Reims	1
11 Nov 12	Finalizado	Sochaux	1 - 1	Olympique Lyonnais	1
04 Nov 12	Finalizado	Olympique Lyonnais	5 - 2	Bastia	3
21 Oct 12	Finalizado	Olympique Lyonnais	1 - 0	Stade Brestois	2
07 Oct 12	Finalizado	Lorient	1 - 1	Olympique Lyonnais	1
30 Sep 12	Finalizado	Olympique Lyonnais	0 - 2	Girondins Bordeaux	1
23 Sep 12	Finalizado	Lille	1 - 1	Olympique Lyonnais	2
16 Sep 12	Finalizado	Olympique Lyonnais	2 - 0	Ajaccio	2
01 Sep 12	Finalizado	Olympique Lyonnais	3 - 2	Valenciennes	3
24 Ago 12	Finalizado	Evian Thonon Gaillard	1 - 1	Olympique Lyonnais	10
18 Ago 12	Finalizado	Olympique Lyonnais	4 - 1	Troyes	6
11 Ago 12	Finalizado	Stade Rennais	0 - 1	Olympique Lyonnais	2

Copa de Francia »

06 Ene 13

Finalizado

Épinal

3 - 3

Olympique Lyonnais

Copa de la Liga »

31 Oct 12

Finalizado

Nice

3 - 1

Olympique Lyonnais Tarjeta Roja

Partidos Amistosos »

04 Ago 12	Finalizado	Porto	0 - 0	Olympique Lyonnais	0
25 Jul 12	Finalizado	CF Montréal	1 - 2	Olympique Lyonnais	1
20 Jul 12	Finalizado	Olympique Lyonnais	1 - 1	Real Sociedad	2

Supercopa Francia »

28 Jul 12

Finalizado

Montpellier

2 - 2

Olympique Lyonnais

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

M. Dabo1

Plantilla del Olympique Lyonnais Temporada 2012/2013

		Edad	Altura	Peso
Portero
16	Anthony Lopes	33	184	81	-	-	-
1	Hugo Lloris	37	188	73	-	-	-
34	J. Frick	31	192	88	-	-	-
40	M. Gorgelin	33	187	83	-	-	-
30	R. Vercoutre	43	185	78	-	-	2
Defensa
20	A. Cissokho	36	187	75	-	-	-
13	A. Réveillère	44	180	76	1	-	2
3	Cris	46	183	77	-	-	-
5	Dejan Lovren	34	188	86	1	3	5
20	F. Monzón	37	179	75	-	-	-
24	Jérémy Pied	35	173	69	-	-	2
4	Koné	35	188	80	1	-	5
15	M. Bisevac	40	185	81	-	1	3
14	M. Dabo	37	176	65	-	1	3
2	Mehdi Zeffane	31	176	63	-	-	-
11	Michel Bastos	40	178	74	5	-	-
23	Samuel Umtiti	30	182	75	1	-	5
	T. Fontaine	32	184	87	-	-	-
Centrocampista
28	A. Mvuemba	39	172	67	2	-	-
7	C. Grenier	33	186	72	7	-	5
28	E. Reale	32	175	69	1	-	4
33	F. Bahlouli	29	181	78	-	-	-
6	G. Fofana	32	182	74	2	-	9
12	Jordan Ferri	32	173	70	-	-	-
21	M. Gonalons	35	187	76	3	1	12
22	S. Koné	31	185	73	-	-	-
17	S. Malbranque	44	168	73	2	-	5
25	Y. Benzia	29	178	71	-	-	4
8	Y. Gourcuff	37	185	79	3	-	4
33	Z. Labidi	29	178	71	-	-	-
Delantero
10	A. Lacazette	32	175	73	3	-	-
26	A. Martial	28	181	76	-	-	1
27	A. Pléa	31	181	72	-	-	-
18	B. Gomis	38	184	77	16	-	1
33	C. N'jie	30	175	68	-	-	-
19	J. Briand	38	181	84	1	-	2
9	L. López	41	174	74	11	-	2
31	R. Ghezzal	31	182	70	1	-	2

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		PSG	83
2		Olympique Marseille	71
3		Olympique Lyonnais	67
4		Nice	64
5		Saint-Étienne	63
6		Lille	62
7		Girondins Bordeaux	55
8		Lorient	53
9		Montpellier	52
10		Toulouse	51
11		Valenciennes	48
12		Bastia	47
13		Stade Rennais	46
14		Stade de Reims	43
15		Ajaccio	42
16		Sochaux	41
17		Evian Thonon Gaillard	40
18		Nancy	38
19		Troyes	37
20		Stade Brestois	29

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Europa League

RIVALES EN Ligue 1

RIVALES EN Supercopa Franci.

USO DE MEMORIA

7,009,000 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2615
Total Execution Time	0.2635

CADENA URL

/Olympique-Lyonnais/2013

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (55)

0.0018	SELECT type FROM routes WHERE alias = 'olympique-lyonnais'
0.0058	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 = 2013 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.0020	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.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=1866 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=1866 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=1866 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=1866 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=1866 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=1866 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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.0027	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 = 1910
0.0028	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 = 2157
0.0027	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 = 2257
0.0027	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 = 20491
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 = 20535
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 = 2110
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1866 AND type_rel = 2
0.0070	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.0022	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.0050	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 = 2013 ORDER BY l.year DESC,cat.coefficient DESC
0.0050	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.0026	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 = 20491 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 20535 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 2257 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 = 1910 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 = 2110 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	(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 calendars2013 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 2013 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0038	(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 calendars2013 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 = 2013 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0049	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2013 as c ON c.league_id = l.id INNER JOIN events2013 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 = 2013)
0.0051	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 (2012,2013,2014) ORDER BY l.id DESC, l.year DESC ;
0.0020	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,20536,20491,2840,2432,2399,2110,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.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 2432 AND teamId = 1866
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 1446 AND teamId = 1866
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 2840 AND teamId = 1866
0.0057	SELECT count(id) as num_players from rel_players WHERE league_id = 20491 AND teamId = 1866
0.0044	SELECT count(id) as num_players from rel_players WHERE league_id = 20536 AND teamId = 1866
0.0041	SELECT count(id) as num_players from rel_players WHERE league_id = 42844 AND teamId = 1866
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 2110 AND teamId = 1866
0.0053	SELECT count(id) as num_players from rel_players WHERE league_id = 2399 AND teamId = 1866
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2013` 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 = 1910 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0026	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.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1866' and rp.type = 4
0.0027	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.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1866' and rp.type = 4
0.0048	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 events2013 e ON e.player_id = p.id AND e.league_id = 1910 WHERE rp.league_id = 1910 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.0038	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 events2013 e ON e.player_id = p.id AND e.league_id = 1910 WHERE rp.league_id = 1910 AND rp.teamId = 1866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 events2013 e ON e.player_id = p.id AND e.league_id = 1910 WHERE rp.league_id = 1910 AND rp.teamId = 1866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 1910 AND l.year= 2013 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0039	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=39128 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=39128
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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39128 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.0028	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39128 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0026	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39128 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0028	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39128 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0037	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 events2013 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=39128 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

Estadísticas

Plantilla del Olympique Lyonnais Temporada 2012/2013

Noticias del Olympique Lyonnais

Olympique Lyonnais

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Europa League

RIVALES EN Ligue 1

RIVALES EN Supercopa Franci.