Información
  • Nombre del equipo Monaco
  • Nombre completo AS Monaco Football Club
  • Nombre corto MON
  • País Mónaco
  • Ciudad Principado de Mónaco
  • Entrenador Adi Hütter
  • URL del equipo en RF testing.resultados-futbol.com/Monaco
Otros Datos
  • Año de Fundación 1919
  • Patrocinador FedCom
  • Marca de Ropa Nike
Internet
Información sobre el estadio
  • Nombre del estadio Louis II
  • Capacidad 18521
  • Dirección 7, avenue des Castelans
  • Teléfono +377 9205 7473
  • Fax +377 9205 2454
  • Año de construcción 1985
  • Tamaño 105 x 68 metros
Louis II
Histórico de participación
Ligue 1
Copa de Francia
Copa de la Liga
Champions League Grupo 1
Europa League Grupo 8
15 veces
Partidos Amistosos
14 veces
Fase Previa Champions League Grupo 4
11 veces
Supercopa Francia
8 veces
Recopa de Europa
6 veces
Copa Emirates
2 veces
(2024, 2014)
Ligue 2
2 veces
(2013, 2012)
Trofeo Costa del Sol
1 vez
(1964)
Trofeo Teresa Herrera
1 vez
(1964)
Partidos del Monaco Ir al LIVESCORE
11 Dic 18  Finalizado Monaco
0 - 2
B. Dortmund 112
28 Nov 18  Finalizado Tarjeta RojaAtlético
2 - 0
Monaco 619
06 Nov 18  Finalizado Monaco
0 - 4
Club Brugge 520
24 Oct 18  Finalizado Club Brugge
1 - 1
Monaco 389
03 Oct 18  Finalizado B. Dortmund
3 - 0
Monaco 236
18 Sep 18  Finalizado Monaco
1 - 2
Atlético 1253
24 May 19  Finalizado Nice
2 - 0
Monaco 49
18 May 19  Finalizado Monaco
2 - 0
Amiens SC 52
11 May 19  Finalizado Nîmes
1 - 0
Monaco 63
05 May 19  Finalizado Monaco
2 - 3
Saint-Étienne 59
01 May 19  Finalizado Stade Rennais
2 - 2
Monaco 317
21 Abr 19  Finalizado PSG
3 - 1
Monaco 206
13 Abr 19  Finalizado Monaco
0 - 0
Stade de Reims 82
06 Abr 19  Finalizado Guingamp
1 - 1
Monaco 51
31 Mar 19  Finalizado Monaco
0 - 1
Caen 47
15 Mar 19  Finalizado Lille
0 - 1
Monaco 150
09 Mar 19  Finalizado Monaco
1 - 1
Girondins Bordeaux 73
02 Mar 19  Finalizado Angers SCO
2 - 2
Monaco 86
24 Feb 19  Finalizado Monaco
2 - 0
Olympique Lyonnais 264
16 Feb 19  Finalizado Monaco
1 - 0
Nantes 100
10 Feb 19  Finalizado Montpellier
2 - 2
MonacoTarjeta Roja 93
02 Feb 19  Finalizado Monaco
2 - 1
Toulouse 99
26 Ene 19  Finalizado Dijon FCO
2 - 0
MonacoTarjeta Roja 148
19 Ene 19  Finalizado Tarjeta RojaMonaco
1 - 5
StrasbourgTarjeta Roja 119
16 Ene 19  Finalizado Monaco
1 - 1
NiceTarjeta Roja 153
13 Ene 19  Finalizado Olympique Marseille
1 - 1
Monaco 171
22 Dic 18  Finalizado Monaco
0 - 2
Guingamp 49
16 Dic 18  Finalizado Olympique Lyonnais
3 - 0
MonacoTarjeta Roja 77
04 Dic 18  Finalizado Tarjeta RojaAmiens SC
0 - 2
Monaco 178
01 Dic 18  Finalizado Monaco
1 - 2
Montpellier 94
24 Nov 18  Finalizado Caen
0 - 1
Monaco 53
11 Nov 18  Finalizado Monaco
0 - 4
PSG 202
03 Nov 18  Finalizado Tarjeta RojaStade de Reims
1 - 0
Monaco 92
27 Oct 18  Finalizado Monaco
2 - 2
Dijon FCO 205
20 Oct 18  Finalizado Tarjeta RojaStrasbourg
2 - 1
Monaco 126
07 Oct 18  Finalizado Tarjeta RojaMonaco
1 - 2
Stade Rennais 197
28 Sep 18  Finalizado Saint-Étienne
2 - 0
Monaco 259
25 Sep 18  Finalizado Monaco
0 - 1
Angers SCO 677
21 Sep 18  Finalizado Monaco
1 - 1
Nîmes 384
15 Sep 18  Finalizado Toulouse
1 - 1
Monaco 187
02 Sep 18  Finalizado Monaco
2 - 3
Olympique Marseille 116
26 Ago 18  Finalizado Girondins Bordeaux
2 - 1
Monaco 302
18 Ago 18  Finalizado Monaco
0 - 0
Lille 483
11 Ago 18  Finalizado Nantes
1 - 3
Monaco 395
22 Ene 19  Finalizado Monaco
1 - 3
Metz 270
06 Ene 19  Finalizado Tarjeta RojaCanet Roussillon
0 - 1
Monaco 17
29 Ene 19  Finalizado Guingamp
2 - 2
MonacoTarjeta Roja 220
09 Ene 19  Finalizado Monaco
1 - 1
Stade Rennais 249
19 Dic 18  Finalizado Monaco
1 - 0
Lorient 97
28 Jul 18  Finalizado Hamburger SV
3 - 1
Monaco 13
25 Jul 18  Finalizado VfL Bochum
2 - 2
Monaco 24
21 Jul 18  Finalizado Paderborn
3 - 2
Monaco 41
14 Jul 18  Finalizado Cercle Brugge
2 - 3
Monaco 31
08 Jul 18  Finalizado Ruch Chorzów
0 - 3
Monaco 1
07 Jul 18  Finalizado Wisla Kraków
1 - 1
Monaco 39
04 Ago 18  Finalizado PSG
4 - 0
Monaco 375

Plantilla del Monaco Temporada 2018/2019

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
16 40 ch 193 83 - - 2
1 39 hr 191 86 - - 1
40 24 fr 184 73 - - -
30 28 sn 192 80 - - -
Defensa
24 39 it 190 78 - 1 1
32 23 fr 194 73 1 - 4
39 27 de 185 74 1 - 3
19 31 fr 183 71 - - 5
2 27 sn 182 70 - - 7
41 23 fr 187 83 - - -
26 ao 179 58 - - -
37 23 gb 188 72 - - -
21 26 fr 181 65 - - 1
5 31 br 184 77 - 1 10
25 36 pl 190 80 1 - 10
27 41 br 198 89 - 2 -
18 25 fr 177 76 - - 1
Centrocampista
17 27 ru 178 69 3 1 7
15 35 pt 175 72 - - 6
44 36 es 177 69 1 - 2
42 22 fr 178 70 - - -
4 30 ci 186 81 - - 2
6 28 fr 184 76 - - 2
43 23 fr 192 80 - - -
31 25 fr 180 75 - - 1
12 35 fr 179 73 - - -
Delantero
14 29 cm 172 75 - - -
29 28 pt 170 72 4 - 1
22 25 es 183 74 - - 1
33 23 za 185 70 - - -
34 24 fr 181 70 - - 1
20 34 be 187 80 - - 1
23 23 it 189 80 1 - 1
9 38 co 177 73 15 - 10
7 28 pt 174 68 2 - 1
36 23 ma 175 65 - - 1
10 34 me 183 79 2 - 1
11 29 br 190 80 2 - 3
13 22 fr 185 72 - - -
35 23 fr 186 79 - - -
Noticias del Monaco
Ver últimas noticias

El Mónaco se frota las manos esperando el próximo gol de Martial

El francés sigue acertado de cara a portería, este fin de semana ante el Watford, volvió a marcar gol y está a un tanto de llegar a los 25 tantos.

En Colombia colocan a Falcao en el Chelsea

El delantero del Mónaco Radamel Falcao García firmó el contrato para jugar la próxima temporada bajo la dirección del portugués Jose Mourinho en el Chelsea, aseguró hoy el programa deportivo colombiano Gol Caracol.

Guido Carrillo dice que 'el Mónaco es un equipo prestigioso y un grande de Francia'

El delantero argentino Guido Carrillo, recientemente vendido al Mónaco, dijo hoy que su nuevo equipo es "prestigioso y un grande" de la liga francesa de fútbol.

El agente de Abdennour confirma el interés del Barça por él

También le quieren Milán, Inter, Juventus y Liverpool y el Manchester United se ha unido a la carrera por el central.

El exjugador Fernando Morientes, nuevo entrenador del Fuenlabrada de 2ªB

El exfutbolista internacional Fernando Morientes es el nuevo entrenador del Club de Fútbol Fuenlabrada de Segunda División 'B' para las próximas dos temporadas y será presentado el 29 de junio en el Estadio Fernando Torres de la ciudad madrileña, informó el Fuenlabrada.



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,880,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6393
Total Execution Time  0.6413
  CADENA URL  
/Monaco/2019
  GET DATOS  
$_GET['/Monaco/2019']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0134  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 = 'Monaco' AND l.year = 2019 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=1713 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=1713 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=1713 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=1713 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=1713 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=1713 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=1713 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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 = 43549
0.0111  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 = 44982
0.0111  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 = 47499
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 = 44442
0.0111  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 = 43532
0.0118  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 = '1713' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0119  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 = '1713' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 44982 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0113  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 = 47499 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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 = 44442 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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 = 43549 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106  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 = 43532 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  (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 calendars2019 as c ON c.league_id = l.id WHERE (c.datateam1 = 1713 or c.datateam2 = 1713) AND l.year = 2019 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0117  (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 calendars2019 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 = 1713 or c.datateam2 = 1713) AND l.year = 2019 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0114  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2019 as c ON c.league_id = l.id INNER JOIN events2019 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 = 1713 or c.datateam2 = 1713) AND l.year = 2019)
0.0117  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=1713 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0107  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 (51675,50213,49849,49506,44982,43532) 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.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 49849 AND teamId = 1713
0.0107  SELECT count(id) as num_players from rel_players WHERE league_id = 44982 AND teamId = 1713
0.0122  SELECT count(id) as num_players from rel_players WHERE league_id = 51675 AND teamId = 1713
0.0114  SELECT count(id) as num_players from rel_players WHERE league_id = 50213 AND teamId = 1713
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 43532 AND teamId = 1713
0.0265  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 1713
0.0111  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0125  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 events2019 e ON e.player_id = p.id AND e.league_id = 43549 WHERE rp.league_id = 43549 AND rp.teamId = 1713 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.0122  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 events2019 e ON e.player_id = p.id AND e.league_id = 43549 WHERE rp.league_id = 43549 AND rp.teamId = 1713 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120  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 events2019 e ON e.player_id = p.id AND e.league_id = 43549 WHERE rp.league_id = 43549 AND rp.teamId = 1713 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0112  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 = 1713 AND rp.league_id = 43549 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0112  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=6185444 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0105  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6185444
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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185444 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185444 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0111  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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185444 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0112   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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185444 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 events2019 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6185444 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC