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

Ligue 1 2019

La temporada finalizó el Viernes, 24 Mayo 2019.
01 Feb 19
20:45 Finalizado
Lille Lille 4-0 Nice Nice más información Jugadas destacadas Vídeos del Lille-Nice 87
7' Rafael Leão 1-0
37' Nicolas Pépé 2-0
75' J. Bamba 3-0
89' P. Lees Melou
90' L. Rémy 4-0
 
02 Feb 19
20:00 Finalizado
Angers SCO Angers SCO 1-0 Dijon FCO Dijon FCO más información Jugadas destacadas Vídeos del Angers SCO-Dijon FCO 35
27' S. Bahoken 1-0
02 Feb 19
20:00 Finalizado
Monaco Monaco 2-1 Toulouse Toulouse más información Jugadas destacadas Vídeos del Monaco-Toulouse 99
15' A. Golovin 1-0
1-1 20' C. Jullien
62' Cesc Fàbregas 2-1
 
02 Feb 19
20:00 Finalizado
Stade Rennais Stade Rennais 1-0 Amiens SC Amiens SC más información Jugadas destacadas Vídeos del Stade Rennais-Amiens SC 46
82' Mehdi Zeffane 1-0
 
02 Feb 19
21:00 Finalizado
Stade de Reims Stade de Reims 2-1 Olympique Marseille Olympique Marseille más información Jugadas destacadas Vídeos del Stade de Reims-Olympique Marseille 28
21' T. Dingomé 1-0
68' Suk Hyun-Jun 2-0
2-1 86' C. N'jie
03 Feb 19
15:00 Finalizado
Nîmes Nîmes 1-1 Montpellier Montpellier más información Jugadas destacadas Vídeos del Nîmes-Montpellier 58
2' Loïck Landre 1-0
1-1 73' A. Delort
03 Feb 19
21:00 Finalizado
Olympique Lyonnais Olympique Lyonnais 2-1 PSG PSG más información Jugadas destacadas Vídeos del Olympique Lyonnais-PSG 194
0-1 7' Á. Di María
33' M. Dembélé 1-1
49' Nabil Fekir 2-1
13 Feb 19
19:00 Finalizado
Saint-Étienne Saint-Étienne 2-1 Strasbourg Strasbourg más información Jugadas destacadas 144
4' R. Berić 1-0
26' L. Perrin 2-0
2-1 73' Nuno Da Costa
 
13 Feb 19
19:30 Finalizado
Caen Caen 0-1 Nantes Nantes más información Jugadas destacadas 210
34' A. Girotto
0-1 80' V. Rongier
 
20 Feb 19
19:00 Finalizado
Girondins Bordeaux Girondins Bordeaux 0-0 Guingamp Guingamp más información Vídeos del Girondins Bordeaux-Guingamp 233
Equipos Puntos J. G. E. P. F. C. Forma
1 PSG PSG 62 23 20 2 1 76 14
  • VICTORIA
  • PSG 9
  • Guingamp 0
  • VICTORIA
  • PSG 4
  • Stade Rennais 1
  • DERROTA
  • Olympique Lyonnais 2
  • PSG 1
  • VICTORIA
  • PSG 5
  • Montpellier 1
  • VICTORIA
  • Dijon FCO 0
  • PSG 4
2 Lille Lille 46 23 14 4 5 40 22
  • DERROTA
  • Lille 1
  • Toulouse 2
  • VICTORIA
  • Caen 1
  • Lille 3
  • VICTORIA
  • Lille 2
  • Amiens SC 1
  • VICTORIA
  • Olympique Marseill. 1
  • Lille 2
  • VICTORIA
  • Lille 4
  • Nice 0
3 Olympique Lyonnais Olympique 43 23 12 7 4 38 26
  • EMPATE
  • Olympique Lyonnais 1
  • Stade de Reims 1
  • EMPATE
  • Toulouse 2
  • Olympique Lyonnais 2
  • VICTORIA
  • Saint-Étienne 1
  • Olympique Lyonnais 2
  • VICTORIA
  • Amiens SC 0
  • Olympique Lyonnais 1
  • VICTORIA
  • Olympique Lyonnais 2
  • PSG 1
4 Saint-Étienne Saint-Étienne 40 23 11 7 5 35 27
  • VICTORIA
  • Guingamp 0
  • Saint-Étienne 1
  • VICTORIA
  • Saint-Étienne 2
  • Olympique Marseill. 1
  • DERROTA
  • Saint-Étienne 1
  • Olympique Lyonnais 2
  • EMPATE
  • Nantes 1
  • Saint-Étienne 1
  • VICTORIA
  • Saint-Étienne 2
  • Strasbourg 1
5 Montpellier Montpellier 36 23 9 9 5 30 22
  • EMPATE
  • Dijon FCO 1
  • Montpellier 1
  • EMPATE
  • Stade Rennais 0
  • Montpellier 0
  • VICTORIA
  • Montpellier 2
  • Caen 0
  • EMPATE
  • Nîmes 1
  • Montpellier 1
  • DERROTA
  • PSG 5
  • Montpellier 1
6 Strasbourg Strasbourg 35 23 9 8 6 39 27
  • VICTORIA
  • Strasbourg 2
  • Nice 0
  • VICTORIA
  • Toulouse 1
  • Strasbourg 2
  • VICTORIA
  • Monaco 1
  • Strasbourg 5
  • VICTORIA
  • Strasbourg 1
  • Girondins Bordeaux 0
  • DERROTA
  • Saint-Étienne 2
  • Strasbourg 1
7 Olympique Marseille Olympique 34 23 10 4 9 36 33
  • DERROTA
  • Saint-Étienne 2
  • Olympique Marseill. 1
  • VICTORIA
  • Caen 0
  • Olympique Marseill. 1
  • DERROTA
  • Olympique Marseill. 1
  • Lille 2
  • DERROTA
  • Stade de Reims 2
  • Olympique Marseill. 1
  • VICTORIA
  • Olympique Marseill. 1
  • Girondins Bordeaux 0
8 Stade de Reims Stade de Reims 34 23 8 10 5 20 21
  • EMPATE
  • Stade de Reims 2
  • Caen 2
  • EMPATE
  • Olympique Lyonnais 1
  • Stade de Reims 1
  • EMPATE
  • Stade de Reims 1
  • Nice 1
  • VICTORIA
  • Guingamp 0
  • Stade de Reims 1
  • VICTORIA
  • Stade de Reims 2
  • Olympique Marseill. 1
9 Nice Nice 34 23 9 7 7 18 23
  • VICTORIA
  • Nice 1
  • Girondins Bordeaux 0
  • EMPATE
  • Monaco 1
  • Nice 1
  • EMPATE
  • Stade de Reims 1
  • Nice 1
  • VICTORIA
  • Nice 2
  • Nîmes 0
  • DERROTA
  • Lille 4
  • Nice 0
10 Stade Rennais Stade Rennais 33 23 9 6 8 31 31
  • VICTORIA
  • Nantes 0
  • Stade Rennais 1
  • DERROTA
  • Guingamp 2
  • Stade Rennais 1
  • EMPATE
  • Stade Rennais 0
  • Montpellier 0
  • DERROTA
  • PSG 4
  • Stade Rennais 1
  • VICTORIA
  • Stade Rennais 1
  • Amiens SC 0
11 Nîmes Nîmes 30 23 8 6 9 31 33
  • VICTORIA
  • Nîmes 1
  • Nantes 0
  • DERROTA
  • Nîmes 0
  • Toulouse 1
  • VICTORIA
  • Nîmes 3
  • Angers SCO 1
  • DERROTA
  • Nice 2
  • Nîmes 0
  • EMPATE
  • Nîmes 1
  • Montpellier 1
12 Girondins Bordeaux Girondins 29 23 7 8 8 23 24
  • VICTORIA
  • Angers SCO 1
  • Girondins Bordeaux 2
  • VICTORIA
  • Girondins Bordeaux 1
  • Dijon FCO 0
  • DERROTA
  • Strasbourg 1
  • Girondins Bordeaux 0
  • DERROTA
  • Olympique Marseill. 1
  • Girondins Bordeaux 0
  • EMPATE
  • Girondins Bordeaux 0
  • Guingamp 0
13 Nantes Nantes 27 23 7 6 10 28 29
  • DERROTA
  • Nantes 0
  • Stade Rennais 1
  • DERROTA
  • Nîmes 1
  • Nantes 0
  • DERROTA
  • Angers SCO 1
  • Nantes 0
  • EMPATE
  • Nantes 1
  • Saint-Étienne 1
  • VICTORIA
  • Caen 0
  • Nantes 1
14 Angers SCO Angers SCO 27 23 6 9 8 24 27
  • DERROTA
  • Angers SCO 1
  • Girondins Bordeaux 2
  • VICTORIA
  • Angers SCO 1
  • Nantes 0
  • DERROTA
  • Nîmes 3
  • Angers SCO 1
  • EMPATE
  • Toulouse 0
  • Angers SCO 0
  • VICTORIA
  • Angers SCO 1
  • Dijon FCO 0
15 Toulouse Toulouse 26 23 6 8 9 22 33
  • DERROTA
  • Toulouse 1
  • Strasbourg 2
  • EMPATE
  • Toulouse 2
  • Olympique Lyonnais 2
  • VICTORIA
  • Nîmes 0
  • Toulouse 1
  • EMPATE
  • Toulouse 0
  • Angers SCO 0
  • DERROTA
  • Monaco 2
  • Toulouse 1
16 Dijon FCO Dijon FCO 20 23 5 5 13 19 38
  • EMPATE
  • Dijon FCO 1
  • Montpellier 1
  • DERROTA
  • Girondins Bordeaux 1
  • Dijon FCO 0
  • VICTORIA
  • Dijon FCO 2
  • Monaco 0
  • DERROTA
  • Angers SCO 1
  • Dijon FCO 0
  • DERROTA
  • Dijon FCO 0
  • PSG 4
17 Caen Caen 18 23 3 9 11 20 32
  • EMPATE
  • Stade de Reims 2
  • Caen 2
  • DERROTA
  • Caen 1
  • Lille 3
  • DERROTA
  • Caen 0
  • Olympique Marseill. 1
  • DERROTA
  • Montpellier 2
  • Caen 0
  • DERROTA
  • Caen 0
  • Nantes 1
18 Monaco Monaco 18 23 4 6 13 21 39
  • EMPATE
  • Olympique Marseill. 1
  • Monaco 1
  • EMPATE
  • Monaco 1
  • Nice 1
  • DERROTA
  • Monaco 1
  • Strasbourg 5
  • DERROTA
  • Dijon FCO 2
  • Monaco 0
  • VICTORIA
  • Monaco 2
  • Toulouse 1
19 Amiens SC Amiens SC 18 23 5 3 15 18 38
  • EMPATE
  • Amiens SC 0
  • Angers SCO 0
  • DERROTA
  • Amiens SC 0
  • PSG 3
  • DERROTA
  • Lille 2
  • Amiens SC 1
  • DERROTA
  • Amiens SC 0
  • Olympique Lyonnais 1
  • DERROTA
  • Stade Rennais 1
  • Amiens SC 0
20 Guingamp Guingamp 15 23 3 6 14 16 46
  • DERROTA
  • Guingamp 0
  • Saint-Étienne 1
  • VICTORIA
  • Guingamp 2
  • Stade Rennais 1
  • DERROTA
  • PSG 9
  • Guingamp 0
  • DERROTA
  • Guingamp 0
  • Stade de Reims 1
  • EMPATE
  • Girondins Bordeaux 0
  • Guingamp 0
Champions League : PSG, Lille, Olympique
Europa League : Saint-Étienne
Playoff Descenso : Monaco
Descenso : Amiens SC, Guingamp
RK Nombre Goles Posición Equipo
1 K. Mbappé fr K. Mbappé 33 DEL PSG PSG
2 Nicolas Pépé ci Nicolas Pépé 22 DEL Lille Lille
3 E. Cavani uy E. Cavani 18 DEL PSG PSG
4 F. Thauvin fr F. Thauvin 16 DEL Olympique Marseille Olympique Marseille
5 R. Falcao co R. Falcao 15 DEL Monaco Monaco
6 Neymar br Neymar 15 DEL PSG PSG
7 M. Dembélé fr M. Dembélé 15 DEL Olympique Lyonnais Olympique Lyonnais
8 A. Delort dz A. Delort 14 DEL Montpellier Montpellier
9 Wahbi Khazri tn Wahbi Khazri 13 DEL Saint-Étienne Saint-Étienne
10 J. Bamba ci J. Bamba 13 DEL Lille Lille
11 Á. Di María ar Á. Di María 12 DEL PSG PSG
12 E. Sala ar E. Sala 12 DEL Nantes Nantes
13 M. Gradel ci M. Gradel 11 DEL Toulouse Toulouse
14 M'baye Niang sn M'baye Niang 11 DEL Stade Rennais Stade Rennais
15 S. Bahoken cm S. Bahoken 11 DEL Angers SCO Angers SCO
16 G. Laborde fr G. Laborde 11 DEL Montpellier Montpellier
17 Memphis nl Memphis 10 DEL Olympique Lyonnais Olympique Lyonnais
18 F. Kamano gn F. Kamano 10 DEL Girondins Bordeaux Girondins Bordeaux
19 Remi Oudin fr Remi Oudin 10 MED Stade de Reims Stade de Reims
20 L. Mothiba za L. Mothiba 10 DEL Strasbourg Strasbourg

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,683,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.4147
Total Execution Time  0.4181
  CADENA URL  
/ligue_12019/grupo1/jornada23
  GET DATOS  
$_GET['/ligue_12019/grupo1/jornada23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0124  SELECT type FROM routes WHERE alias = 'ligue_12019'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_1' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0127  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 43549 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 15:34:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 15:34:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 15:34:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 15:34:28' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_1' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0128  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=43549 AND rel.round=23
0.0127  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 43549 AND esl.points > 0
0.0124  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 43549 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 43549
0.0134  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 `calendars2019` 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` = 43549 AND c.`round` = 23 ORDER BY shedule ASC LIMIT 200
0.0155  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 events2019 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2019 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 43549 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 (5382,5379,5383,5386,5385,5384,5388,5387,5381,5380) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0129  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 `events2019` e INNER JOIN calendars2019 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 = 23 AND e.real_date IS NOT NULL AND e.league_id = 43549 ORDER BY total DESC LIMIT 40
0.0137  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 `tables2019` 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 = 43549 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 43549 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  SELECT distinct(shedule), round FROM `calendars2019` as c WHERE c.`league_id` = 43549 AND shedule >= '2019/02/01' AND shedule < '2019/03/01' ORDER BY shedule ASC
0.0124  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 43549 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0138  SELECT data1, data2 FROM services_tags WHERE categoryId=16
0.0138  SELECT group_code, extraName from `leagues` WHERE categoryId=16 AND year=2019