Información
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
Parc Olympique Lyonnais
Histórico de participación
Ligue 1
Copa de Francia
Champions League Grupo 7
Copa de la Liga
Europa League Grupo 0
Partidos Amistosos
14 veces
Supercopa Francia
13 veces
Peace Cup Grupo 4
7 veces
Fase Previa Champions League Grupo 3
6 veces
Copa de Ferias
4 veces
Copa Emirates
4 veces
Recopa de Europa
4 veces
Fase Previa Europa League Grupo 3
2 veces
(2015, 2015)
International Champions Cup
2 veces
(2019, 2018)
Copa Intertoto Grupo 9
2 veces
(1998, 1998)
Dubai Super Cup
1 vez
(2023)
Trofeo Colombino
1 vez
(1968)
Partidos del Olympique Lyonnais Ir al LIVESCORE
07 Dic 99  Finalizado Werder Bremen
4 - 0
Olympique Lyonnais 0
25 Nov 99  Finalizado Olympique Lyonnais
3 - 0
Werder Bremen 0
04 Nov 99  Finalizado Celtic
0 - 1
Olympique Lyonnais 0
21 Oct 99  Finalizado Olympique Lyonnais
1 - 0
Celtic 0
30 Sep 99  Finalizado Olympique Lyonnais
5 - 1
HJK Helsinki 0
15 Sep 99  Finalizado HJK Helsinki
0 - 1
Olympique Lyonnais 0
13 May 00  Finalizado Montpellier
2 - 2
Olympique Lyonnais 0
04 May 00  Finalizado Olympique Lyonnais
2 - 1
Bastia 0
29 Abr 00  Finalizado Lens
4 - 3
Olympique Lyonnais 0
14 Abr 00  Finalizado Olympique Lyonnais
0 - 0
Saint-Étienne 0
08 Abr 00  Finalizado Le Havre
0 - 1
Olympique Lyonnais 0
26 Mar 00  Finalizado Olympique Lyonnais
2 - 0
CS Sedan 0
12 Mar 00  Finalizado Nancy
1 - 0
Olympique Lyonnais 0
26 Feb 00  Finalizado Tarjeta RojaOlympique Lyonnais
2 - 0
Olympique MarseilleTarjeta Roja 0
15 Feb 00  Finalizado Nantes
6 - 1
Olympique Lyonnais 0
06 Feb 00  Finalizado Tarjeta RojaOlympique Lyonnais
2 - 1
Monaco 0
02 Feb 00  Finalizado Strasbourg
4 - 2
Olympique Lyonnais 0
26 Ene 00  Finalizado Olympique Lyonnais
1 - 1
Girondins Bordeaux 0
15 Ene 00  Finalizado Tarjeta RojaAuxerre
2 - 0
Olympique Lyonnais 0
11 Ene 00  Finalizado PSG
2 - 2
Olympique Lyonnais 0
18 Dic 99  Finalizado Olympique Lyonnais
2 - 0
Metz 0
11 Dic 99  Finalizado Stade Rennais
1 - 2
Olympique Lyonnais 0
03 Dic 99  Finalizado Tarjeta RojaOlympique Lyonnais
1 - 3
Troyes 0
28 Nov 99  Finalizado Bastia
3 - 0
Olympique Lyonnais 0
20 Nov 99  Finalizado Olympique Lyonnais
1 - 0
Lens 0
10 Nov 99  Finalizado Saint-Étienne
1 - 1
Olympique Lyonnais 0
07 Nov 99  Finalizado Olympique Lyonnais
3 - 0
Le HavreTarjeta Roja 0
29 Oct 99  Finalizado CS Sedan
2 - 0
Olympique Lyonnais 0
24 Oct 99  Finalizado Olympique Lyonnais
2 - 1
Nancy 0
15 Oct 99  Finalizado Olympique Marseille
0 - 1
Olympique Lyonnais 0
12 Oct 99  Finalizado Olympique Lyonnais
2 - 0
Nantes 0
03 Oct 99  Finalizado Monaco
1 - 0
Olympique Lyonnais 0
25 Sep 99  Finalizado Olympique Lyonnais
0 - 0
Strasbourg 0
18 Sep 99  Finalizado Tarjeta RojaGirondins Bordeaux
1 - 3
Olympique Lyonnais 0
11 Sep 99  Finalizado Olympique Lyonnais
0 - 0
Auxerre 0
29 Ago 99  Finalizado Tarjeta RojaOlympique Lyonnais
1 - 0
PSGTarjeta RojaTarjeta Roja 0
20 Ago 99  Finalizado Tarjeta RojaMetz
0 - 1
Olympique Lyonnais 0
15 Ago 99  Finalizado Olympique Lyonnais
2 - 2
Stade Rennais 0
05 Ago 99  Finalizado Troyes
1 - 2
Olympique Lyonnais 0
31 Jul 99  Finalizado Olympique Lyonnais
1 - 2
Montpellier 0
19 Mar 00  Finalizado Tarjeta RojaOlympique Lyonnais
1 - 3
Monaco 0
05 Mar 00  Finalizado Red Star
1 - 2
Olympique LyonnaisTarjeta Roja 0
12 Feb 00  Finalizado Olympique Lyonnais
1 - 0
Troyes 0
22 Ene 00  Finalizado Tours
0 - 1
Olympique Lyonnais 0
19 Feb 00  Finalizado Olympique Lyonnais
0 - 1
BastiaTarjeta Roja 0
29 Ene 00  Finalizado Olympique Lyonnais
1 - 0
Girondins Bordeaux 0
08 Ene 00  Finalizado Olympique Lyonnais
3 - 1
Amiens SC 0

Plantilla del Olympique Lyonnais Temporada 1999/2000

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
30 57 fr 182 - - - -
1 51 fr 181 80 - - -
Defensa
46 fr 183 78 - - 5
4 50 fr 188 88 - - 14
13 56 fr 183 75 - - 3
44 fr 187 77 - - 1
5 51 pl 190 78 1 - 3
3 53 fr 183 73 2 - 9
12 51 fr 182 - 2 1 5
Centrocampista
15 54 fr 188 - 2 - 1
44 fr 178 73 - - -
44 fr 168 72 - - -
2 48 fr - - - - 2
48 fr 181 71 - 1 4
6 53 fr - - 1 1 10
45 fr - - - - -
8 53 fr 178 80 2 - 2
18 44 fr 168 73 3 - 2
10 50 fr 168 58 - - 4
Delantero
7 56 fr - - 2 - 5
20 46 ml 192 82 1 - -
44 fr - - - - -
44 fr 175 70 - - -
53 br 181 72 23 1 1
11 50 fr - - 6 - 3
Noticias del Olympique Lyonnais
Ver últimas noticias

0-2. El Villarreal cierra la Copa Emirates con nota tras ganar al Olympique de Lyon

El Villarreal cerró con victoria por dos goles a cero frente al Olympique de Lyon, su participación en la Copa Emirates en un partido en el que los castellonenses siguieron en la buena línea exhibida en el partido del pasado sábado frente al Wolfsburgo alemán.

Lucas Hernández despierta el interés del Lyon

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

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

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

El ex jugador del Valencia se ha pasado al cine y en su debut, en una película noruega, ejercerá de mafioso.



Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,733,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7301
Total Execution Time  0.7319
  CADENA URL  
/Olympique-Lyonnais/2000
  GET DATOS  
$_GET['/Olympique-Lyonnais/2000']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0105  SELECT type FROM routes WHERE alias = 'olympique-lyonnais'
0.0141  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 = 2000 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.0106  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.0106  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.0106  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.0106  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.0106  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.0106  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.0113  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 = 10974
0.0112  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 = 23476
0.0112  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 = 23473
0.0114  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 = 42335
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1866 AND type_rel = 2
0.0158  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.0109  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 (702,1988,2072,3302,3750) ORDER BY n.cover_points DESC, update_date DESC
0.0119  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 = 2000 ORDER BY l.year DESC,cat.coefficient DESC
0.0122  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.0109  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 42335 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23476 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0112  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 23473 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0123  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10974 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 197 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  (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 calendars2000 as c ON c.league_id = l.id WHERE (c.datateam1 = 1866 or c.datateam2 = 1866) AND l.year = 2000 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0189  (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 calendars2000 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 = 2000 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0153  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2000 as c ON c.league_id = l.id INNER JOIN events2000 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 = 2000)
0.0173  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 (1999,2000,2001) ORDER BY l.id DESC, l.year DESC ;
0.0116  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 (42335,23479,23475,10974,9677,198) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 198 AND teamId = 1866
0.0163  SELECT count(id) as num_players from rel_players WHERE league_id = 9677 AND teamId = 1866
0.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 10974 AND teamId = 1866
0.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 23479 AND teamId = 1866
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 23475 AND teamId = 1866
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 42335 AND teamId = 1866
0.0110  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2000` 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 = 197 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0109  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1866' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1866' and rp.type = 4
0.0109  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '1866' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0105  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1866' and rp.type = 4
0.0119  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 events2000 e ON e.player_id = p.id AND e.league_id = 197 WHERE rp.league_id = 197 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.0117  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 events2000 e ON e.player_id = p.id AND e.league_id = 197 WHERE rp.league_id = 197 AND rp.teamId = 1866 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 events2000 e ON e.player_id = p.id AND e.league_id = 197 WHERE rp.league_id = 197 AND rp.teamId = 1866 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117  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 = 197 AND l.year= 2000 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0115  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=5737 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0106  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=5737
0.0117  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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5737 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.0116  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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5737 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0116  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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5737 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0116   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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5737 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0113  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 events2000 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=5737 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0106  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 197 ORDER BY nameShow LIMIT 100