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

Partidos del Olympique Lyonnais

Ir al LIVESCORE
04 Jun 61  Finalizado Olympique Lyonnais Olympique Lyonnais
2 - 1
Limoges Limoges 0
31 May 61  Finalizado Olympique Lyonnais Olympique Lyonnais
2 - 1
Stade Français Stade Français 0
28 May 61  Finalizado Troyes Troyes
2 - 3
Olympique Lyonnais Olympique Lyonnais 0
20 May 61  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 3
Le Havre Le Havre 0
14 May 61  Finalizado Stade Rennais Stade Rennais
6 - 1
Olympique Lyonnais Olympique Lyonnais 0
30 Abr 61  Finalizado Lens Lens
0 - 1
Olympique Lyonnais Olympique Lyonnais 0
22 Abr 61  Finalizado Olympique Lyonnais Olympique Lyonnais
4 - 1
FC Rouen 1899 FC Rouen 1899 0
09 Abr 61  Finalizado Saint-Étienne Saint-Étienne
4 - 2
Olympique Lyonnais Olympique Lyonnais 0
19 Mar 61  Finalizado Olympique Lyonnais Olympique Lyonnais
0 - 1
Nancy Nancy 0
11 Mar 61  Finalizado CS Sedan CS Sedan
2 - 1
Olympique Lyonnais Olympique Lyonnais 0
26 Feb 61  Finalizado Nice Nice
2 - 2
Olympique Lyonnais Olympique Lyonnais 0
19 Feb 61  Finalizado Olympique Lyonnais Olympique Lyonnais
2 - 2
Nîmes Nîmes 0
05 Feb 61  Finalizado Olympique Lyonnais Olympique Lyonnais
0 - 2
Stade de Reims Stade de Reims 0
29 Ene 61  Finalizado Monaco Monaco
3 - 1
Olympique Lyonnais Olympique Lyonnais 0
22 Ene 61  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 1
Angers SCO Angers SCO 0
08 Ene 61  Finalizado Olympique Lyonnais Olympique Lyonnais
0 - 0
Valenciennes Valenciennes 0
01 Ene 61  Finalizado Toulouse Toulouse
2 - 0
Olympique Lyonnais Olympique Lyonnais 0
24 Dic 60  Finalizado Olympique Lyonnais Olympique Lyonnais
4 - 2
Racing Paris Racing Paris 0
18 Dic 60  Finalizado Grenoble Grenoble
2 - 2
Olympique Lyonnais Olympique Lyonnais 0
14 Dic 60  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 1
CS Sedan CS Sedan 0
04 Dic 60  Finalizado Olympique Lyonnais Olympique Lyonnais
5 - 2
Troyes Troyes 0
27 Nov 60  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 0
Toulouse Toulouse 0
20 Nov 60  Finalizado Le Havre Le Havre
3 - 2
Olympique Lyonnais Olympique Lyonnais 0
13 Nov 60  Finalizado Olympique Lyonnais Olympique Lyonnais
2 - 0
Monaco Monaco 0
11 Nov 60  Finalizado Stade Français Stade Français
3 - 1
Olympique Lyonnais Olympique Lyonnais 0
06 Nov 60  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 1
Grenoble Grenoble 0
01 Nov 60  Finalizado Nîmes Nîmes
3 - 0
Olympique Lyonnais Olympique Lyonnais 0
23 Oct 60  Finalizado Nancy Nancy
2 - 1
Olympique Lyonnais Olympique Lyonnais 0
16 Oct 60  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 2
Lens Lens 0
09 Oct 60  Finalizado Angers SCO Angers SCO
3 - 0
Olympique Lyonnais Olympique Lyonnais 0
02 Oct 60  Finalizado Olympique Lyonnais Olympique Lyonnais
2 - 2
Saint-Étienne Saint-Étienne 0
25 Sep 60  Finalizado Limoges Limoges
3 - 1
Olympique Lyonnais Olympique Lyonnais 0
18 Sep 60  Finalizado Valenciennes Valenciennes
1 - 2
Olympique Lyonnais Olympique Lyonnais 0
15 Sep 60  Finalizado Racing Paris Racing Paris
3 - 2
Olympique Lyonnais Olympique Lyonnais 0
10 Sep 60  Finalizado Olympique Lyonnais Olympique Lyonnais
4 - 3
Nice Nice 0
03 Sep 60  Finalizado FC Rouen 1899 FC Rouen 1899
0 - 1
Olympique Lyonnais Olympique Lyonnais 0
27 Ago 60  Finalizado Olympique Lyonnais Olympique Lyonnais
4 - 0
Stade Rennais Stade Rennais 0
20 Ago 60  Finalizado Stade de Reims Stade de Reims
2 - 0
Olympique Lyonnais Olympique Lyonnais 0
19 Oct 60  Finalizado Köln XI Köln XI
1 - 2
Olympique Lyonnais Olympique Lyonnais 0
12 Oct 60  Finalizado Olympique Lyonnais Olympique Lyonnais
1 - 3
Köln XI Köln XI 0

  USO DE MEMORIA  
5,213,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.0550
Total Execution Time  0.0564
  CADENA URL  
/partidos/Olympique-Lyonnais/1961
  GET DATOS  
$_GET['/partidos/Olympique-Lyonnais/1961']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (6)  
0.0041  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.0063  (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 calendars1961 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 1961 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0067  (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 calendars1961 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 = 1961 GROUP BY c.id) ORDER BY shedule DESC LIMIT 365
0.0050  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1961 as c ON c.league_id = l.id INNER JOIN events1961 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 = 1961)
0.0019  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 = 9790 AND l.year= 1961 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0019  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 = 9790 AND l.year= 1961 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1