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

Ligue 1 1991

La temporada finalizó el Viernes, 24 Mayo 1991.
 
18 Ene 91
Finalizado
Olympique Lyonnais Olympique Lyonnais 1-0 Monaco Monaco más información Jugadas destacadas ...
43' Ali Bouafia Ali Bouafia 1-0
 
19 Ene 91
Finalizado
Nantes Nantes 0-0 Girondins Bordeaux Girondins Bordeaux más información ...
 
20 Ene 91
Finalizado
Lille Lille 1-0 Olympique Marseille Olympique Marseille más información Jugadas destacadas ...
35' Patrice Sauvaget Patrice Sauvaget 1-0
 
20 Ene 91
Finalizado
Auxerre Auxerre 0-1 PSG PSG más información Jugadas destacadas ...
0-1 37' Zlatko Vujović Zlatko Vujović
 
20 Ene 91
Finalizado
Montpellier Montpellier 0-0 Saint-Étienne Saint-Étienne más información ...
 
20 Ene 91
Finalizado
Caen Caen 0-1 Cannes Cannes más información Jugadas destacadas ...
0-1 28' Éric Guérit Éric Guérit
 
20 Ene 91
Finalizado
Metz Metz 2-1 Toulouse Toulouse más información Jugadas destacadas ...
35' Nicolas Huysman Nicolas Huysman 1-0
1-1 70' B. Acosta B. Acosta
80' A. Asanovic A. Asanovic 2-1
 
20 Ene 91
Finalizado
Stade Rennais Stade Rennais 1-1 Sochaux Sochaux más información Jugadas destacadas ...
13' François Omam Biyik François Omam Biyik 1-0
1-1 48' Lionel Prat Lionel Prat
 
20 Ene 91
Finalizado
Nice Nice 2-0 Stade Brestois Stade Brestois más información Jugadas destacadas ...
38' Fabrice Poullain Fabrice Poullain 1-0
45' R. Langers R. Langers 2-0
 
20 Ene 91
Finalizado
Sporting Toulon Var Sporting Toulon Var 2-0 Nancy Nancy más información Jugadas destacadas ...
33' Pineda Pineda 1-0
86' Pineda Pineda 2-0
Equipos Puntos J. G. E. P. F. C. Forma
1 Olympique Marseille Olympique 33 23 15 3 5 43 19
  • DERROTA
  • Auxerre 4
  • Olympique Marseill. 0
  • VICTORIA
  • Olympique Marseill. 3
  • Metz 0
  • EMPATE
  • Caen 0
  • Olympique Marseill. 0
  • VICTORIA
  • Olympique Marseill. 7
  • Olympique Lyonnais 0
  • DERROTA
  • Lille 1
  • Olympique Marseill. 0
2 Monaco Monaco 28 23 10 8 5 27 21
  • EMPATE
  • Stade Rennais 1
  • Monaco 1
  • EMPATE
  • Monaco 0
  • Auxerre 0
  • DERROTA
  • Montpellier 2
  • Monaco 1
  • VICTORIA
  • Monaco 2
  • Nantes 1
  • DERROTA
  • Olympique Lyonnais 1
  • Monaco 0
3 Auxerre Auxerre 27 23 10 7 6 32 22
  • VICTORIA
  • Auxerre 4
  • Olympique Marseill. 0
  • EMPATE
  • Monaco 0
  • Auxerre 0
  • DERROTA
  • Auxerre 0
  • Cannes 3
  • DERROTA
  • Saint-Étienne 2
  • Auxerre 1
  • DERROTA
  • Auxerre 0
  • PSG 1
4 Montpellier Montpellier 25 23 9 7 7 36 24
  • VICTORIA
  • Montpellier 2
  • Toulouse 0
  • EMPATE
  • Sochaux 0
  • Montpellier 0
  • VICTORIA
  • Montpellier 2
  • Monaco 1
  • DERROTA
  • PSG 2
  • Montpellier 0
  • EMPATE
  • Montpellier 0
  • Saint-Étienne 0
5 Metz Metz 25 23 9 7 7 31 30
  • DERROTA
  • Caen 4
  • Metz 1
  • DERROTA
  • Olympique Marseill. 3
  • Metz 0
  • VICTORIA
  • Metz 2
  • Nantes 0
  • EMPATE
  • Girondins Bordeaux 1
  • Metz 1
  • VICTORIA
  • Metz 2
  • Toulouse 1
6 Olympique Lyonnais Olympique 25 23 10 5 8 25 29
  • VICTORIA
  • Olympique Lyonnais 2
  • Nantes 0
  • DERROTA
  • Cannes 3
  • Olympique Lyonnais 2
  • VICTORIA
  • Olympique Lyonnais 4
  • Toulouse 1
  • DERROTA
  • Olympique Marseill. 7
  • Olympique Lyonnais 0
  • VICTORIA
  • Olympique Lyonnais 1
  • Monaco 0
7 PSG PSG 24 23 8 8 7 30 28
  • EMPATE
  • Stade Brestois 0
  • PSG 0
  • EMPATE
  • PSG 1
  • Stade Rennais 1
  • EMPATE
  • Sporting Toulon Va. 0
  • PSG 0
  • VICTORIA
  • PSG 2
  • Montpellier 0
  • VICTORIA
  • Auxerre 0
  • PSG 1
8 Cannes Cannes 24 23 8 8 7 19 18
  • EMPATE
  • Sporting Toulon Va. 0
  • Cannes 0
  • VICTORIA
  • Cannes 3
  • Olympique Lyonnais 2
  • VICTORIA
  • Auxerre 0
  • Cannes 3
  • VICTORIA
  • Cannes 2
  • Nice 1
  • VICTORIA
  • Caen 0
  • Cannes 1
9 Lille Lille 24 23 6 12 5 22 22
  • EMPATE
  • Nancy 1
  • Lille 1
  • EMPATE
  • Nantes 0
  • Lille 0
  • EMPATE
  • Lille 0
  • Girondins Bordeaux 0
  • EMPATE
  • Toulouse 2
  • Lille 2
  • VICTORIA
  • Lille 1
  • Olympique Marseill. 0
10 Caen Caen 22 23 7 8 8 23 21
  • VICTORIA
  • Caen 4
  • Metz 1
  • EMPATE
  • Girondins Bordeaux 1
  • Caen 1
  • EMPATE
  • Caen 0
  • Olympique Marseill. 0
  • DERROTA
  • Sochaux 1
  • Caen 0
  • DERROTA
  • Caen 0
  • Cannes 1
11 Nantes Nantes 22 23 6 10 7 23 26
  • DERROTA
  • Olympique Lyonnais 2
  • Nantes 0
  • EMPATE
  • Nantes 0
  • Lille 0
  • DERROTA
  • Metz 2
  • Nantes 0
  • DERROTA
  • Monaco 2
  • Nantes 1
  • EMPATE
  • Nantes 0
  • Girondins Bordeaux 0
12 Girondins Bordeaux Girondins 21 23 5 11 7 20 20
  • EMPATE
  • Nice 0
  • Girondins Bordeaux 0
  • EMPATE
  • Girondins Bordeaux 1
  • Caen 1
  • EMPATE
  • Lille 0
  • Girondins Bordeaux 0
  • EMPATE
  • Girondins Bordeaux 1
  • Metz 1
  • EMPATE
  • Nantes 0
  • Girondins Bordeaux 0
13 Saint-Étienne Saint-Étienne 21 23 8 5 10 26 28
  • DERROTA
  • Sochaux 2
  • Saint-Étienne 0
  • VICTORIA
  • Saint-Étienne 3
  • Sporting Toulon Va. 0
  • DERROTA
  • Nice 2
  • Saint-Étienne 0
  • VICTORIA
  • Saint-Étienne 2
  • Auxerre 1
  • EMPATE
  • Montpellier 0
  • Saint-Étienne 0
14 Sochaux Sochaux 21 23 6 9 8 17 19
  • VICTORIA
  • Sochaux 2
  • Saint-Étienne 0
  • EMPATE
  • Sochaux 0
  • Montpellier 0
  • DERROTA
  • Nancy 2
  • Sochaux 0
  • VICTORIA
  • Sochaux 1
  • Caen 0
  • EMPATE
  • Stade Rennais 1
  • Sochaux 1
15 Sporting Toulon Var Sporting Toulon 21 23 6 9 8 19 23
  • EMPATE
  • Sporting Toulon Va. 0
  • Cannes 0
  • DERROTA
  • Saint-Étienne 3
  • Sporting Toulon Va. 0
  • EMPATE
  • Sporting Toulon Va. 0
  • PSG 0
  • EMPATE
  • Stade Brestois 2
  • Sporting Toulon Va. 2
  • VICTORIA
  • Sporting Toulon Va. 2
  • Nancy 0
16 Nancy Nancy 21 23 7 7 9 25 39
  • EMPATE
  • Nancy 1
  • Lille 1
  • EMPATE
  • Stade Brestois 3
  • Nancy 3
  • VICTORIA
  • Nancy 2
  • Sochaux 0
  • EMPATE
  • Nancy 0
  • Stade Rennais 0
  • DERROTA
  • Sporting Toulon Va. 2
  • Nancy 0
17 Stade Brestois Stade Brestois 20 23 5 10 8 28 30
  • EMPATE
  • Stade Brestois 0
  • PSG 0
  • EMPATE
  • Stade Brestois 3
  • Nancy 3
  • DERROTA
  • Stade Rennais 3
  • Stade Brestois 0
  • EMPATE
  • Stade Brestois 2
  • Sporting Toulon Va. 2
  • DERROTA
  • Nice 2
  • Stade Brestois 0
18 Nice Nice 20 23 5 10 8 20 22
  • EMPATE
  • Nice 0
  • Girondins Bordeaux 0
  • VICTORIA
  • Toulouse 1
  • Nice 2
  • VICTORIA
  • Nice 2
  • Saint-Étienne 0
  • DERROTA
  • Cannes 2
  • Nice 1
  • VICTORIA
  • Nice 2
  • Stade Brestois 0
19 Stade Rennais Stade Rennais 19 23 5 9 9 17 30
  • EMPATE
  • Stade Rennais 1
  • Monaco 1
  • EMPATE
  • PSG 1
  • Stade Rennais 1
  • VICTORIA
  • Stade Rennais 3
  • Stade Brestois 0
  • EMPATE
  • Nancy 0
  • Stade Rennais 0
  • EMPATE
  • Stade Rennais 1
  • Sochaux 1
20 Toulouse Toulouse 17 23 4 9 10 18 30
  • DERROTA
  • Montpellier 2
  • Toulouse 0
  • DERROTA
  • Toulouse 1
  • Nice 2
  • DERROTA
  • Olympique Lyonnais 4
  • Toulouse 1
  • EMPATE
  • Toulouse 2
  • Lille 2
  • DERROTA
  • Metz 2
  • Toulouse 1
JUGADORES DESTACADOS
RK Nombre Goles Posición Equipo
1 J. Papin fr J. Papin 23 DEL Olympique Marseille Olympique Marseille
2 K. Kovacs hu K. Kovacs 16 DEL Auxerre Auxerre
3 Laurent Blanc fr Laurent Blanc 14 DEF Montpellier Montpellier
4 François Omam Biyik cm François Omam Biyik 14 DEL Stade Rennais Stade Rennais
5 E. Scifo be E. Scifo 14 MED Auxerre Auxerre
6 A. Asanovic hr A. Asanovic 13 MED Metz Metz
7 D. Xuereb fr D. Xuereb 12 DEL Montpellier Montpellier
8 Bernard Ferrer fr Bernard Ferrer 12 MED Stade Brestois Stade Brestois
9 Fabrice Divert fr Fabrice Divert 11 DEL Caen Caen
10 C. Cocard fr C. Cocard 11 DEL Auxerre Auxerre
11 George Weah lr George Weah 10 DEL Monaco Monaco
12 Zlatko Vujović hr Zlatko Vujović 10 DEL PSG PSG
13 S. Sušić ba S. Sušić 10 DEL PSG PSG
14 R. Tarasiewicz pl R. Tarasiewicz 10 MED Nancy Nancy
15 François Brisson fr François Brisson 10 DEL Lille Lille
16 Amara Simba fr Amara Simba 10 DEL Cannes Cannes
17 Fabrice Mège fr Fabrice Mège 10 MED Nice Nice
18 François Calderaro fr François Calderaro 10 DEL Metz Metz
19 Jules Bocandé sn Jules Bocandé 10 DEL Nice Nice
20 R. Díaz ar R. Díaz 9 DEL Monaco Monaco

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,033,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1000
Total Execution Time  0.1019
  CADENA URL  
/ligue_11991/grupo1/jornada23
  GET DATOS  
$_GET['/ligue_11991/grupo1/jornada23']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0018  SELECT type FROM routes WHERE alias = 'ligue_11991'
0.0040  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 = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  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 = 9760 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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:30:47' 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=2 AND last_update > '2024-05-09 03:30:47' 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=4 AND last_update > '2024-05-09 03:30:47' 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:30:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  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 = 1991 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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=9760 AND rel.round=23
0.0019  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA 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 = 9760 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 9760 AND esl.points > 0
0.0018  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-04-09" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 9760 ORDER BY creation_date DESC LIMIT 0, 10
0.0029  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-04-09" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 9760
0.0032  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 `calendars1991` 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` = 9760 AND c.`round` = 23 ORDER BY shedule ASC LIMIT 200
0.0057  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 events1991 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1991 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 9760 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 (3609,3610,3611,3612,3613,3614,3615,3616,3617,3618) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0019  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 `events1991` e INNER JOIN calendars1991 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 = 9760 ORDER BY total DESC LIMIT 40
0.0027  SELECT 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 `events1991` e INNER JOIN calendars1991 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 9760 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0049  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 `tables1991` 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 = 9760 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1991` 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 = 9760 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT distinct(shedule), round FROM `calendars1991` as c WHERE c.`league_id` = 9760 AND shedule >= '1991/01/01' AND shedule < '1991/02/01' ORDER BY shedule ASC
0.0021  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-05-09 00:00:00' AND c.`shedule` < '2024-05-13 23:59:59' AND l.id = 9760 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0025  SELECT data1, data2 FROM services_tags WHERE categoryId=16
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=16 AND year=1991