4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Ligue 1 2023

La temporada finalizó el Sábado, 03 Junio 2023.
Resultados
« Jornada Anterior
Jornada 37
Jornada Siguiente »
27 May 23
21:00 Finalizado 		Angers SCO Angers SCO 2-1 Troyes Troyes más información Jugadas destacadas 63
0-1 13' X. Chavalerin X. Chavalerin
38' H. Abdelli H. Abdelli 1-1
90' L. Rao-Lisoa L. Rao-Lisoa 2-1
27 May 23
21:00 Finalizado 		Clermont Clermont 2-0 Lorient Lorient más información Jugadas destacadas 80
43' Ibrahima Koné Ibrahima Koné
44' S. Khaoui S. Khaoui 1-0
74' M. Caufriez M. Caufriez 2-0
27 May 23
21:00 Finalizado 		Lille Lille 2-1 Nantes Nantes más información Jugadas destacadas 148
0-1 17' Quentin Merlin Quentin Merlin
51' Jonathan David Jonathan David 1-1
88' Jonathan David Jonathan David 2-1
27 May 23
21:00 Finalizado 		Montpellier Montpellier 2-3 Nice Nice más información Jugadas destacadas 38
7' T. Savanier T. Savanier 1-0
17' T. Savanier T. Savanier 2-0
2-1 53' Ross Barkley Ross Barkley
2-2 67' G. Laborde G. Laborde
2-3 79' G. Laborde G. Laborde
27 May 23
21:00 Finalizado 		Olympique Lyonnais Olympique Lyonnais 3-0 Stade de Reims Stade de Reims más información Jugadas destacadas 37
2' E. Agbadou E. Agbadou
9' A. Lacazette A. Lacazette 2-0
54' E. Agbadou E. Agbadou
82' M. Caqueret M. Caqueret 3-0
27 May 23
21:00 Finalizado 		Olympique Marseille Olympique Marseille 1-2 Stade Brestois Stade Brestois más información Jugadas destacadas 191
0-1 57' H. Magnetti H. Magnetti
75' C. Mbemba C. Mbemba 1-1
1-2 81' M. Camara M. Camara
27 May 23
21:00 Finalizado 		Lens Lens 3-0 Ajaccio Ajaccio más información Jugadas destacadas 42
16' D. Machado D. Machado 1-0
22' A. Thomasson A. Thomasson 2-0
35' Loïs Openda Loïs Openda 3-0
27 May 23
21:00 Finalizado 		Strasbourg Strasbourg 1-1 PSG PSG más información Jugadas destacadas 408
0-1 59' L. Messi L. Messi
79' Kévin Gameiro Kévin Gameiro 1-1
27 May 23
21:00 Finalizado 		Stade Rennais Stade Rennais 2-0 Monaco Monaco más información Jugadas destacadas 125
52' Lovro Majer Lovro Majer 1-0
73' Amine Gouiri Amine Gouiri 2-0
27 May 23
21:00 Finalizado 		Toulouse Toulouse 1-1 Auxerre Auxerre más información Jugadas destacadas 127
0-1 24' R. Raveloson R. Raveloson
44' Z. Aboukhlal Z. Aboukhlal 1-1
Clasificación
« Jornada Anterior
Jornada 37
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 PSG PSG 85 37 27 4 6 87 37
  • DERROTA
  • PSG 1
  • Lorient 3
  • VICTORIA
  • Troyes 1
  • PSG 3
  • VICTORIA
  • PSG 5
  • Ajaccio 0
  • VICTORIA
  • Auxerre 1
  • PSG 2
  • EMPATE
  • Strasbourg 1
  • PSG 1
2 Lens Lens 81 37 24 9 4 65 28
  • VICTORIA
  • Toulouse 0
  • Lens 1
  • VICTORIA
  • Lens 2
  • Olympique Marseill. 1
  • VICTORIA
  • Lens 2
  • Stade de Reims 1
  • VICTORIA
  • Lorient 1
  • Lens 3
  • VICTORIA
  • Lens 3
  • Ajaccio 0
3 Olympique Marseille Olympique 73 37 22 7 8 67 39
  • VICTORIA
  • Olympique Marseill. 2
  • Auxerre 1
  • DERROTA
  • Lens 2
  • Olympique Marseill. 1
  • VICTORIA
  • Olympique Marseill. 3
  • Angers SCO 1
  • DERROTA
  • Lille 2
  • Olympique Marseill. 1
  • DERROTA
  • Olympique Marseill. 1
  • Stade Brestois 2
4 Lille Lille 66 37 19 9 9 64 43
  • VICTORIA
  • Lille 3
  • Ajaccio 0
  • DERROTA
  • Stade de Reims 1
  • Lille 0
  • EMPATE
  • Monaco 0
  • Lille 0
  • VICTORIA
  • Lille 2
  • Olympique Marseill. 1
  • VICTORIA
  • Lille 2
  • Nantes 1
5 Stade Rennais Stade Rennais 65 37 20 5 12 67 38
  • VICTORIA
  • Stade Rennais 4
  • Angers SCO 2
  • DERROTA
  • Nice 2
  • Stade Rennais 1
  • VICTORIA
  • Stade Rennais 4
  • Troyes 0
  • VICTORIA
  • Ajaccio 0
  • Stade Rennais 5
  • VICTORIA
  • Stade Rennais 2
  • Monaco 0
6 Monaco Monaco 65 37 19 8 10 69 56
  • DERROTA
  • Monaco 0
  • Montpellier 4
  • VICTORIA
  • Angers SCO 1
  • Monaco 2
  • EMPATE
  • Monaco 0
  • Lille 0
  • DERROTA
  • Olympique Lyonnais 3
  • Monaco 1
  • DERROTA
  • Stade Rennais 2
  • Monaco 0
7 Olympique Lyonnais Olympique 62 37 18 8 11 64 44
  • VICTORIA
  • Strasbourg 1
  • Olympique Lyonnais 2
  • VICTORIA
  • Olympique Lyonnais 5
  • Montpellier 4
  • DERROTA
  • Clermont 2
  • Olympique Lyonnais 1
  • VICTORIA
  • Olympique Lyonnais 3
  • Monaco 1
  • VICTORIA
  • Olympique Lyonnais 3
  • Stade de Reims 0
8 Clermont Clermont 56 37 16 8 13 42 47
  • VICTORIA
  • Clermont 1
  • Stade de Reims 0
  • EMPATE
  • Auxerre 1
  • Clermont 1
  • VICTORIA
  • Clermont 2
  • Olympique Lyonnais 1
  • DERROTA
  • Stade Brestois 2
  • Clermont 1
  • VICTORIA
  • Clermont 2
  • Lorient 0
9 Nice Nice 55 37 14 13 10 45 36
  • VICTORIA
  • Troyes 0
  • Nice 1
  • VICTORIA
  • Nice 2
  • Stade Rennais 1
  • DERROTA
  • Strasbourg 2
  • Nice 0
  • EMPATE
  • Nice 0
  • Toulouse 0
  • VICTORIA
  • Montpellier 2
  • Nice 3
10 Lorient Lorient 52 37 14 10 13 50 52
  • VICTORIA
  • PSG 1
  • Lorient 3
  • VICTORIA
  • Lorient 2
  • Stade Brestois 1
  • EMPATE
  • Montpellier 1
  • Lorient 1
  • DERROTA
  • Lorient 1
  • Lens 3
  • DERROTA
  • Clermont 2
  • Lorient 0
11 Stade de Reims Stade de Reims 51 37 12 15 10 44 42
  • DERROTA
  • Clermont 1
  • Stade de Reims 0
  • VICTORIA
  • Stade de Reims 1
  • Lille 0
  • DERROTA
  • Lens 2
  • Stade de Reims 1
  • EMPATE
  • Stade de Reims 2
  • Angers SCO 2
  • DERROTA
  • Olympique Lyonnais 3
  • Stade de Reims 0
12 Montpellier Montpellier 47 37 14 5 18 62 61
  • VICTORIA
  • Monaco 0
  • Montpellier 4
  • DERROTA
  • Olympique Lyonnais 5
  • Montpellier 4
  • EMPATE
  • Montpellier 1
  • Lorient 1
  • VICTORIA
  • Nantes 0
  • Montpellier 3
  • DERROTA
  • Montpellier 2
  • Nice 3
13 Toulouse Toulouse 45 37 12 9 16 49 56
  • DERROTA
  • Toulouse 0
  • Lens 1
  • EMPATE
  • Ajaccio 0
  • Toulouse 0
  • EMPATE
  • Toulouse 0
  • Nantes 0
  • EMPATE
  • Nice 0
  • Toulouse 0
  • EMPATE
  • Toulouse 1
  • Auxerre 1
14 Stade Brestois Stade Brestois 44 37 11 11 15 43 52
  • VICTORIA
  • Stade Brestois 2
  • Nantes 0
  • DERROTA
  • Lorient 2
  • Stade Brestois 1
  • VICTORIA
  • Stade Brestois 1
  • Auxerre 0
  • VICTORIA
  • Stade Brestois 2
  • Clermont 1
  • VICTORIA
  • Olympique Marseill. 1
  • Stade Brestois 2
15 Strasbourg Strasbourg 40 37 9 13 15 50 57
  • DERROTA
  • Strasbourg 1
  • Olympique Lyonnais 2
  • VICTORIA
  • Nantes 0
  • Strasbourg 2
  • VICTORIA
  • Strasbourg 2
  • Nice 0
  • EMPATE
  • Troyes 1
  • Strasbourg 1
  • EMPATE
  • Strasbourg 1
  • PSG 1
16 Auxerre Auxerre 35 37 8 11 18 34 60
  • DERROTA
  • Olympique Marseill. 2
  • Auxerre 1
  • EMPATE
  • Auxerre 1
  • Clermont 1
  • DERROTA
  • Stade Brestois 1
  • Auxerre 0
  • DERROTA
  • Auxerre 1
  • PSG 2
  • EMPATE
  • Toulouse 1
  • Auxerre 1
17 Nantes Nantes 33 37 6 15 16 36 55
  • DERROTA
  • Stade Brestois 2
  • Nantes 0
  • DERROTA
  • Nantes 0
  • Strasbourg 2
  • EMPATE
  • Toulouse 0
  • Nantes 0
  • DERROTA
  • Nantes 0
  • Montpellier 3
  • DERROTA
  • Lille 2
  • Nantes 1
18 Troyes Troyes 23 37 4 11 22 44 80
  • DERROTA
  • Troyes 0
  • Nice 1
  • DERROTA
  • Troyes 1
  • PSG 3
  • DERROTA
  • Stade Rennais 4
  • Troyes 0
  • EMPATE
  • Troyes 1
  • Strasbourg 1
  • DERROTA
  • Angers SCO 2
  • Troyes 1
19 Ajaccio Ajaccio 23 37 6 5 26 22 74
  • DERROTA
  • Lille 3
  • Ajaccio 0
  • EMPATE
  • Ajaccio 0
  • Toulouse 0
  • DERROTA
  • PSG 5
  • Ajaccio 0
  • DERROTA
  • Ajaccio 0
  • Stade Rennais 5
  • DERROTA
  • Lens 3
  • Ajaccio 0
20 Angers SCO Angers SCO 18 37 4 6 27 33 80
  • DERROTA
  • Stade Rennais 4
  • Angers SCO 2
  • DERROTA
  • Angers SCO 1
  • Monaco 2
  • DERROTA
  • Olympique Marseill. 3
  • Angers SCO 1
  • EMPATE
  • Stade de Reims 2
  • Angers SCO 2
  • VICTORIA
  • Angers SCO 2
  • Troyes 1
Campeón : PSG
Champions League : Lens
Previa de Champions : Olympique
Europa League : Lille, Toulouse
Conference League : Stade Rennais
: Monaco, Olympique, Clermont, Nice, Lorient, Stade de Reims, Montpellier, Stade Brestois, Strasbourg, Auxerre
Descenso : Nantes, Troyes, Ajaccio, Angers SCO
JUGADORES DESTACADOS
RK Nombre Goles Posición Equipo
1 K. Mbappé fr K. Mbappé 29 DEL PSG PSG
2 A. Lacazette fr A. Lacazette 27 DEL Olympique Lyonnais Olympique Lyonnais
3 Jonathan David ca Jonathan David 24 DEL Lille Lille
4 Loïs Openda be Loïs Openda 21 DEL Lens Lens
5 F. Balogun us F. Balogun 21 DEL Stade de Reims Stade de Reims
6 Habib Diallo sn Habib Diallo 20 DEL Strasbourg Strasbourg
7 W. Ben Yedder fr W. Ben Yedder 19 DEL Monaco Monaco
8 Elye Wahi fr Elye Wahi 19 DEL Montpellier Montpellier
9 Terem Moffi ng Terem Moffi 18 DEL Nice Nice
10 L. Messi ar L. Messi 16 DEL PSG PSG
11 G. Laborde fr G. Laborde 15 DEL Nice Nice
12 Amine Gouiri dz Amine Gouiri 15 DEL Stade Rennais Stade Rennais
13 Alexis Sánchez cl Alexis Sánchez 14 DEL Olympique Marseille Olympique Marseille
14 Neymar br Neymar 13 DEL PSG PSG
15 T. Savanier fr T. Savanier 12 MED Montpellier Montpellier
16 B. Embolo ch B. Embolo 12 DEL Monaco Monaco
17 Thijs Dallinga nl Thijs Dallinga 12 DEL Toulouse Toulouse
18 Mama Baldé gw Mama Baldé 11 DEL Troyes Troyes
19 Kévin Gameiro fr Kévin Gameiro 10 DEL Strasbourg Strasbourg
20 G. Kyei fr G. Kyei 10 DEL Clermont Clermont

INFORMACIÓN

La Ligue 1 u oficialmente, por motivos de patrocinio, Ligue 1 Orange es la máxima categoría del fútbol francés.


Está organizada por la Ligue de Football Professionnel


  USO DE MEMORIA  
6,719,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.0861
Total Execution Time  0.0882
  CADENA URL  
/ligue_12023/grupo1/jornada37
  GET DATOS  
$_GET['/ligue_12023/grupo1/jornada37']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0022  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=16 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 03:08:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 03:08:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 03:08:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 03:08:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=67675 AND rel.round=37
0.0023  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2023` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 67675 AND c.`round` = 37 ORDER BY shedule ASC LIMIT 200
0.0036  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2023 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2023 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 67675 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (26305,26314,26318,26321,26323,26325,26328,26330,26331,26332) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0054  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2023` e INNER JOIN calendars2023 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 37 AND e.real_date IS NOT NULL AND e.league_id = 67675 ORDER BY total DESC LIMIT 40
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 67675 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0049  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 67675 AND t.round = 37 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT distinct(shedule), round FROM `calendars2023` as c WHERE c.`league_id` = 67675 AND shedule >= '2023/05/01' AND shedule < '2023/06/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=16
0.0029  SELECT group_code, extraName from `leagues` WHERE categoryId=16 AND year=2023