19 Ago 20	Finalizado	Olympique Lyonnais	0 - 3	Bayern München	911
15 Ago 20	Finalizado	Manchester City	1 - 3	Olympique Lyonnais	1471
07 Ago 20	Finalizado	Juventus	2 - 1	Olympique Lyonnais	374
26 Feb 20	Finalizado	Olympique Lyonnais	1 - 0	Juventus	444
10 Dic 19	Finalizado	Olympique Lyonnais	2 - 2	RB Leipzig	196
27 Nov 19	Finalizado	Zenit	2 - 0	Olympique Lyonnais	337
05 Nov 19	Finalizado	Olympique Lyonnais	3 - 1	Benfica	67
23 Oct 19	Finalizado	Benfica	2 - 1	Olympique Lyonnais	155
02 Oct 19	Finalizado	RB Leipzig	0 - 2	Olympique Lyonnais	103
17 Sep 19	Finalizado	Olympique Lyonnais	1 - 1	Zenit	326

Ligue 1 »

~~23 May 20~~	Aplazado	Olympique Lyonnais	-	Stade Brestois	0
~~16 May 20~~	Aplazado	Angers SCO	-	Olympique Lyonnais	0
~~09 May 20~~	Aplazado	Olympique Lyonnais	-	Montpellier	0
~~02 May 20~~	Aplazado	Dijon FCO	-	Olympique Lyonnais	0
~~26 Abr 20~~	Aplazado	Olympique Lyonnais	-	Monaco	0
~~22 Abr 20~~	Aplazado	Olympique Lyonnais	-	Nîmes	0
~~19 Abr 20~~	Aplazado	Olympique Lyonnais	-	Olympique Marseille	0
~~11 Abr 20~~	Aplazado	Nantes	-	Olympique Lyonnais	0
~~21 Mar 20~~	Aplazado	Stade Rennais	-	Olympique Lyonnais	0
~~13 Mar 20~~	Aplazado	Olympique Lyonnais	-	Stade de Reims	17
08 Mar 20	Finalizado	Lille	1 - 0	Olympique Lyonnais	74
01 Mar 20	Finalizado	Olympique Lyonnais	2 - 0	Saint-Étienne	33
21 Feb 20	Finalizado	Metz	0 - 2	Olympique Lyonnais	78
16 Feb 20	Finalizado	Olympique Lyonnais	1 - 1	Strasbourg	50
09 Feb 20	Finalizado	PSG	4 - 2	Olympique Lyonnais	69
05 Feb 20	Finalizado	Olympique Lyonnais	0 - 0	Amiens SC	178
02 Feb 20	Finalizado	Nice	2 - 1	Olympique Lyonnais	38
26 Ene 20	Finalizado	Olympique Lyonnais	3 - 0	Toulouse	21
11 Ene 20	Finalizado	Girondins Bordeaux	1 - 2	Olympique Lyonnais	55
21 Dic 19	Finalizado	Stade de Reims	1 - 1	Olympique Lyonnais	25
15 Dic 19	Finalizado	Olympique Lyonnais	0 - 1	Stade Rennais	70
06 Dic 19	Finalizado	Nîmes	0 - 4	Olympique Lyonnais	60
03 Dic 19	Finalizado	Olympique Lyonnais	0 - 1	Lille	284
30 Nov 19	Finalizado	Strasbourg	1 - 2	Olympique Lyonnais	31
23 Nov 19	Finalizado	Olympique Lyonnais	2 - 1	Nice	17
10 Nov 19	Finalizado	Olympique Marseille	2 - 1	Olympique Lyonnais	48
02 Nov 19	Finalizado	Toulouse	2 - 3	Olympique Lyonnais	36
26 Oct 19	Finalizado	Olympique Lyonnais	2 - 0	Metz	25
19 Oct 19	Finalizado	Olympique Lyonnais	0 - 0	Dijon FCO	59
06 Oct 19	Finalizado	Saint-Étienne	1 - 0	Olympique Lyonnais	87
28 Sep 19	Finalizado	Olympique Lyonnais	0 - 1	Nantes	39
25 Sep 19	Finalizado	Stade Brestois	2 - 2	Olympique Lyonnais	30
22 Sep 19	Finalizado	Olympique Lyonnais	0 - 1	PSG	163
13 Sep 19	Finalizado	Amiens SC	2 - 2	Olympique Lyonnais	61
31 Ago 19	Finalizado	Olympique Lyonnais	1 - 1	Girondins Bordeaux	45
27 Ago 19	Finalizado	Montpellier	1 - 0	Olympique Lyonnais	333
16 Ago 19	Finalizado	Olympique Lyonnais	6 - 0	Angers SCO	65
09 Ago 19	Finalizado	Monaco	0 - 3	Olympique Lyonnais	207

Copa de Francia »

04 Mar 20	Finalizado	Olympique Lyonnais	1 - 5	PSG	70
12 Feb 20	Finalizado	Olympique Lyonnais	1 - 0	Olympique Marseille	88
30 Ene 20	Finalizado	Nice	1 - 2	Olympique Lyonnais	106
18 Ene 20	Finalizado	Nantes	3 - 4	Olympique Lyonnais	20
04 Ene 20	Finalizado	Bourg-Péronnas	0 - 7	Olympique Lyonnais	25

Copa de la Liga »

31 Jul 20	Finalizado	PSG	0 - 0	Olympique Lyonnais	350
21 Ene 20	Finalizado	Olympique Lyonnais	2 - 2	Lille	69
08 Ene 20	Finalizado	Olympique Lyonnais	3 - 1	Stade Brestois	76
18 Dic 19	Finalizado	Olympique Lyonnais	4 - 1	Toulouse	12

Partidos Amistosos »

03 Ago 19	Finalizado	AFC Bournemouth	3 - 0	Olympique Lyonnais	29
31 Jul 19	Finalizado	Liverpool	3 - 1	Olympique Lyonnais	17
20 Jul 19	Finalizado	Olympique Lyonnais	3 - 4	Genoa	12
13 Jul 19	Finalizado	Olympique Lyonnais	1 - 2	Servette	18

Copa Emirates »

28 Jul 19

Finalizado

Arsenal

1 - 2

Olympique Lyonnais

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Marçal2

Thiago Mendes1

Y. Koné1

Plantilla del Olympique Lyonnais Temporada 2019/2020

		Edad	Altura	Peso
Portero
16	A. Racioppi	25	189	80	-	-	-
1	Anthony Lopes	33	184	81	-	-	1
30	C. Tătăruşanu	38	198	89	-	-	-
Defensa
3	J. Andersen	27	192	90	1	-	3
5	J. Denayer	28	184	70	-	-	-
23	Kenny Tete	28	180	70	-	-	1
14	Léo Dubois	29	178	64	-	-	3
2	M. Yanga-Mbiwa	34	184	80	-	-	-
20	Marçal	35	178	78	-	2	1
6	Marcelo	36	191	85	-	-	4
31	Melvin Bard	23	173	65	-	-	-
26	Oumar Solet	24	192	81	-	-	-
33	Pierre Kalulu	23	182	69	-	-	-
4	Rafael	33	172	80	-	-	3
28	Y. Koné	28	174	76	-	1	1
Centrocampista
39	B. Guimarães	26	182	74	-	-	1
	Camilo Reijers	25	176	80	-	-	-
8	H. Aouar	25	175	70	3	-	3
17	J. Reine-Adélaïde	26	184	75	3	-	3
22	Jean Lucas	25	181	78	1	-	3
29	Lucas Tousart	26	184	83	2	-	5
25	M. Caqueret	24	174	63	-	-	2
18	Rayan Cherki	20	177	70	-	-	-
44	T. Thomas	22	183	70	-	-	-
12	Thiago Mendes	32	177	73	-	1	4
Delantero
19	Amine Gouiri	24	181	72	-	-	-
35	B. Fofana	25	182	71	-	-	-
10	B. Traoré	28	181	72	1	-	6
9	M. Dembélé	27	187	74	16	-	3
7	Martin Terrier	27	184	71	1	-	-
27	Maxwel Cornet	27	179	86	4	-	1
11	Memphis	30	178	78	9	-	-
21	Toko Ekambi	31	182	70	2	-	2

Noticias del Olympique Lyonnais

Ver últimas noticias

PSG y Lyon totalizan el 77% de las pérdidas de la Ligue 1

BeSoccer - Jueves, 25 Abril 2024

0 637

Según el documento de la Dirección Nacional de Control de Gestión (DNCG), el PSG perdió 109 millones de euros en el curso 2022-23 y redujo sus pérdidas respecto a la campaña anterior. El cuadro parisino y el Lyon totalizan el 77% de las pérdidas de la Ligue 1.

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	68
2		Olympique Lyonnais	40
3		Stade Rennais	50
4		Olympique Marseille	56
5		Lille	49
6		Girondins Bordeaux	37
7		Stade de Reims	41
8		Nice	41
9		Montpellier	40
10		Monaco	40
11		Strasbourg	38
12		Stade Brestois	34
13		Nantes	37
14		Angers SCO	39
15		Metz	34
16		Dijon FCO	30
17		Nîmes	27
18		Saint-Étienne	30
19		Amiens SC	23
20		Toulouse	13

	Champions League : PSG, Olympique Lyonnais, Stade Rennais
	Europa League : Olympique Marseille, Lille
	Descenso : Amiens SC, Toulouse

RIVALES EN Champions League

RIVALES EN Copa de Francia

RIVALES EN Copa de la Liga

RIVALES EN Ligue 1

USO DE MEMORIA

6,974,536 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8440
Total Execution Time	0.8460

CADENA URL

/Olympique-Lyonnais/2020

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0170	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 = 2020 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.0126	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.0126	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.0126	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.0126	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.0128	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.0129	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.0129	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.0128	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 = 49849
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 = 51189
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 = 53485
0.0131	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 = 51675
0.0131	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 = 50213
0.0131	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 = 50663
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1866 AND type_rel = 2
0.0155	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.0127	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 (1312580,702,1988,2072,3302) ORDER BY n.cover_points DESC, update_date DESC
0.0139	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 = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0139	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.0126	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 = 53485 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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 = 51675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	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 = 50213 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 49849 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 calendars2020 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 2020 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0136	(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 calendars2020 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 = 2020 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0133	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2020 as c ON c.league_id = l.id INNER JOIN events2020 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 = 2020)
0.0148	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 (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (60328,56825,56547,53485,50663,50213,43268) 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.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 56825 AND teamId = 1866
0.0174	SELECT count(id) as num_players from rel_players WHERE league_id = 53485 AND teamId = 1866
0.0175	SELECT count(id) as num_players from rel_players WHERE league_id = 60328 AND teamId = 1866
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 50213 AND teamId = 1866
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 43268 AND teamId = 1866
0.0356	SELECT count(id) as num_players from rel_players WHERE league_id = 56547 AND teamId = 1866
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 50663 AND teamId = 1866
0.0136	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2020` 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 = 49849 AND t.round = 28 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0194	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 events2020 e ON e.player_id = p.id AND e.league_id = 49849 WHERE rp.league_id = 49849 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.0211	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 events2020 e ON e.player_id = p.id AND e.league_id = 49849 WHERE rp.league_id = 49849 AND rp.teamId = 1866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0201	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 events2020 e ON e.player_id = p.id AND e.league_id = 49849 WHERE rp.league_id = 49849 AND rp.teamId = 1866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 = 49849 AND l.year= 2020 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0134	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=6280072 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6280072
0.0134	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280072 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.0136	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280072 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0139	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280072 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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280072 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0157	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 events2020 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6280072 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 2019/2020

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