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

Olympique Lyonnais

Entrenador: Pierre Sage

Temporada 2022/2023

Información sobre Olympique Lyonnais

Enviar Datos

Información

Nombre del equipo Olympique Lyonnais
Nombre completo Olympique Lyonnais
Nombre corto LYO
País Francia
Ciudad Lyon
Entrenador Pierre Sage
URL del equipo en RF //m.resultados-futbol.com/Olympique-Lyonnais

Otros Datos

Año de Fundación 1950
Patrocinador Hyundai
Marca de Ropa Adidas

Internet

Sitio Web www.olweb.fr
Correo electrónico Jeunes@olympiquelyonnais.com
Twitter principal @OL

Información sobre el estadio

Nombre del estadio Parc Olympique Lyonnais
Capacidad 59168
Dirección 350, avenue Jean Jaures 69007
Teléfono +33 (42) 629 6700
Fax +33 (42) 629 6700
Año de construcción 2016
Tamaño 105 x 68 metros

Histórico de participación

Ligue 1

66 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, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1952, 1946)

Champions League Grupo 7

28 veces

(2020, 2020, 2019, 2019, 2017, 2016, 2012, 2012, 2011, 2011, 2010, 2010, 2009, 2009, 2008, 2008, 2007, 2007, 2006, 2006, 2005, 2005, 2004, 2004, 2003, 2002, 2001, 2001)

Copa de la Liga

25 veces

(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)

Europa League Grupo 1

18 veces

(2022, 2022, 2018, 2018, 2017, 2014, 2014, 2013, 2013, 2003, 2002, 2000, 1999, 1998, 1996, 1992, 1976, 1975)

Partidos Amistosos

14 veces

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

Supercopa Francia

13 veces

(2017, 2016, 2013, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 1973, 1967)

Peace Cup Grupo 4

7 veces

(2010, 2008, 2008, 2006, 2006, 2004, 2004)

Fase Previa Champions League Grupo 3

6 veces

(2014, 2014, 2012, 2010, 2001, 2000)

Fase Previa Europa League Grupo 4

2 veces

(2015, 2015)

Partidos del Olympique Lyonnais

Ir al LIVESCORE

Ligue 1 »

03 Jun 23	Finalizado	Nice	3 - 1	Olympique Lyonnais	96
27 May 23	Finalizado	Olympique Lyonnais	3 - 0	Stade de Reims	37
19 May 23	Finalizado	Olympique Lyonnais	3 - 1	Monaco	159
14 May 23	Finalizado	Clermont	2 - 1	Olympique Lyonnais	136
07 May 23	Finalizado	Olympique Lyonnais	5 - 4	Montpellier	864
28 Abr 23	Finalizado	Strasbourg	1 - 2	Olympique Lyonnais	197
23 Abr 23	Finalizado	Olympique Lyonnais	1 - 2	Olympique Marseille	118
14 Abr 23	Finalizado	Toulouse	1 - 2	Olympique Lyonnais	455
09 Abr 23	Finalizado	Olympique Lyonnais	3 - 1	Stade Rennais	107
02 Abr 23	Finalizado	PSG	0 - 1	Olympique Lyonnais	503
17 Mar 23	Finalizado	Olympique Lyonnais	1 - 1	Nantes	310
10 Mar 23	Finalizado	Lille	3 - 3	Olympique Lyonnais	135
05 Mar 23	Finalizado	Olympique Lyonnais	0 - 0	Lorient	356
25 Feb 23	Finalizado	Angers SCO	1 - 3	Olympique Lyonnais	132
17 Feb 23	Finalizado	Auxerre	2 - 1	Olympique Lyonnais	346
12 Feb 23	Finalizado	Olympique Lyonnais	2 - 1	Lens	302
04 Feb 23	Finalizado	Troyes	1 - 3	Olympique Lyonnais	89
01 Feb 23	Finalizado	Olympique Lyonnais	0 - 0	Stade Brestois	444
29 Ene 23	Finalizado	Ajaccio	0 - 2	Olympique Lyonnais	131
14 Ene 23	Finalizado	Olympique Lyonnais	1 - 2	Strasbourg	548
11 Ene 23	Finalizado	Nantes	0 - 0	Olympique Lyonnais	288
01 Ene 23	Finalizado	Olympique Lyonnais	0 - 1	Clermont	386
28 Dic 22	Finalizado	Stade Brestois	2 - 4	Olympique Lyonnais	163
11 Nov 22	Finalizado	Olympique Lyonnais	1 - 1	Nice	694
06 Nov 22	Finalizado	Olympique Marseille	1 - 0	Olympique Lyonnais	211
30 Oct 22	Finalizado	Olympique Lyonnais	1 - 0	Lille	140
22 Oct 22	Finalizado	Montpellier	1 - 2	Olympique Lyonnais	134
16 Oct 22	Finalizado	Stade Rennais	3 - 2	Olympique Lyonnais	60
07 Oct 22	Finalizado	Olympique Lyonnais	1 - 1	Toulouse	540
02 Oct 22	Finalizado	Lens	1 - 0	Olympique Lyonnais	469
18 Sep 22	Finalizado	Olympique Lyonnais	0 - 1	PSG	377
11 Sep 22	Finalizado	Monaco	2 - 1	Olympique Lyonnais	236
07 Sep 22	Finalizado	Lorient	3 - 1	Olympique Lyonnais	228
03 Sep 22	Finalizado	Olympique Lyonnais	5 - 0	Angers SCO	70
31 Ago 22	Finalizado	Olympique Lyonnais	2 - 1	Auxerre	140
28 Ago 22	Finalizado	Stade de Reims	1 - 1	Olympique Lyonnais	360
19 Ago 22	Finalizado	Olympique Lyonnais	4 - 1	Troyes	234
05 Ago 22	Finalizado	Olympique Lyonnais	2 - 1	Ajaccio	323

Copa de Francia »

05 Abr 23	Finalizado	Nantes	1 - 0	Olympique Lyonnais	330
28 Feb 23	Finalizado	Olympique Lyonnais	2 - 1	Grenoble	133
08 Feb 23	Finalizado	Olympique Lyonnais	2 - 2	Lille	357
21 Ene 23	Finalizado	Chambéry	0 - 3	Olympique Lyonnais	23
07 Ene 23	Finalizado	Olympique Lyonnais	2 - 1	Metz	109

Dubai Super Cup »

	11 Dic 22	Finalizado	Liverpool	1 - 3	Olympique Lyonnais			256
	08 Dic 22	Finalizado	Arsenal	3 - 0	Olympique Lyonnais			310

Partidos Amistosos »

22 Dic 22	Finalizado	Olympique Lyonnais	1 - 2	AC Monza	149
17 Dic 22	Finalizado	Olympique Lyonnais	1 - 1	Sochaux	336
01 Dic 22	Finalizado	Olympique Lyonnais	5 - 3	OH Leuven	75
30 Jul 22	Finalizado	Inter	2 - 2	Olympique Lyonnais	80
24 Jul 22	Finalizado	Feyenoord	0 - 2	Olympique Lyonnais	38
23 Jul 22	Finalizado	Willem II	5 - 0	Olympique Lyonnais	25
16 Jul 22	Finalizado	Anderlecht	3 - 0	Olympique Lyonnais	45
16 Jul 22	Finalizado	Anderlecht	2 - 3	Olympique Lyonnais	9
12 Jul 22	Finalizado	Olympique Lyonnais	3 - 0	Dynamo Kyiv	9
12 Jul 22	Finalizado	Dynamo Kyiv	3 - 1	Olympique Lyonnais	0
09 Jul 22	Finalizado	Bourg-Péronnas	2 - 4	Olympique Lyonnais	11

Estadísticas

GOLEADORES

AMARILLAS

ROJAS

Plantilla del Olympique Lyonnais Temporada 2022/2023

		Edad	Altura	Peso
Portero
1	Anthony Lopes	33	184	81	-	1	2
40	K. Bonnevie	22	191	76	-	-	-
	M. Patouillet	20	188	-	-	-	-
35	Rémy Riou	36	191	81	-	-	-
Defensa
15	A. Laâziri	20	177	-	-	-	-
4	C. Lukeba	21	184	73	2	1	9
5	Dejan Lovren	34	188	86	1	-	2
12	Henrique	30	173	71	-	-	-
17	J. Boateng	35	192	90	-	-	-
29	M. Sarr	18	194	70	-	-	-
27	Malo Gusto	20	178	76	-	-	1
3	N. Tagliafico	31	172	65	1	-	5
2	S. Diomandé	23	184	74	-	1	2
20	Saël Kumbedi	19	175	74	-	-	8
Centrocampista
88	C. Tolisso	29	181	78	1	-	3
8	H. Aouar	25	175	70	1	-	2
24	J. Lepenant	21	176	68	1	-	4
6	M. Caqueret	24	174	63	4	-	2
38	M. El Arouch	20	166	56	-	-	-
18	Rayan Cherki	20	177	70	4	-	3
23	Thiago Mendes	32	177	73	1	-	3
Delantero
10	A. Lacazette	32	175	73	27	-	3
7	Amin Sarr	23	188	83	1	-	-
26	B. Barcola	21	182	70	5	-	3
33	D. Dib	21	172	-	-	-	-
47	Jeffinho	24	176	-	1	-	1
9	M. Dembélé	27	187	74	3	-	1
36	Sekou Lega	21	192	-	-	-	-

Noticias del Olympique Lyonnais

Ver últimas noticias

Palmarés de la Ligue 1: el histórico de campeones de la Liga Francesa

BeSoccer Pro - Lunes, 29 Abril 2024

0 1.846

La Ligue 1 ha sido dominada durante la década anterior y lo que va de la actual por el Paris Saint-Germain, que esgrime unas finanzas que han sido valedoras de la presencia de algunos de los mayores ganadores del presente e incluso de la historia gala. Leo Messi, Kylian Mbappé... Son muchos los protagonistas que han sellado un gobierno impregnado en el palmarés de la categoría, donde tan solo el Saint-Étienne, a nivel histórico, discute a los del Parque de los Príncipes. BeSoccer Pro recoge a todos sus campeones.

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	85
2		Lens	84
3		Olympique Marseille	73
4		Stade Rennais	68
5		Lille	67
6		Monaco	65
7		Olympique Lyonnais	62
8		Clermont	59
9		Nice	58
10		Lorient	55
11		Stade de Reims	51
12		Montpellier	50
13		Toulouse	48
14		Stade Brestois	44
15		Strasbourg	40
16		Nantes	36
17		Auxerre	35
18		Ajaccio	26
19		Troyes	24
20		Angers SCO	18

	Campeón : PSG
	Champions League : Lens
	Previa de Champions : Olympique Marseille
	Europa League : Stade Rennais, Toulouse
	Conference League : Lille
	: Monaco, Olympique Lyonnais, Clermont, Nice, Lorient, Stade de Reims, Montpellier, Stade Brestois, Strasbourg, Nantes
	Descenso : Auxerre, Ajaccio, Troyes, Angers SCO

RIVALES EN Copa de Francia

RIVALES EN Ligue 1

USO DE MEMORIA

6,378,616 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1810
Total Execution Time	0.1830

CADENA URL

/Olympique-Lyonnais/2023

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (33)

0.0043	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 = 2023 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.0018	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.0018	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.0018	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.0018	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.0018	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.0026	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 = 70757
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1866 AND type_rel = 2
0.0052	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.0020	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 (1263611,702,1988,2072,3302) ORDER BY n.cover_points DESC, update_date DESC
0.0042	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 = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0043	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.0023	(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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0032	(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 calendars2023 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 = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0026	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 = 2023)
0.0032	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 (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (74470,72046,71432,70757,66138) 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.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 72046 AND teamId = 1866
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 66138 AND teamId = 1866
0.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 1866
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 70757 AND teamId = 1866
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1866
0.0043	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 events2023 e ON e.player_id = p.id AND e.league_id = 67675 WHERE rp.league_id = 67675 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.0040	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 events2023 e ON e.player_id = p.id AND e.league_id = 67675 WHERE rp.league_id = 67675 AND rp.teamId = 1866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 events2023 e ON e.player_id = p.id AND e.league_id = 67675 WHERE rp.league_id = 67675 AND rp.teamId = 1866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 67675 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0022	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=6515025 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6515025
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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515025 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.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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515025 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515025 and (e.action = 3 or e.action = 4) 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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515025 AND (e.action = 22) 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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515025 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

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 2022/2023

Noticias del Olympique Lyonnais

Olympique Lyonnais

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa de Francia

RIVALES EN Ligue 1