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

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Monaco

Enviar Datos
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 //m.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
65 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1976, 1975, 1974, 1972, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954)
Copa de Francia
34 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991)
Copa de la Liga
25 veces
(2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996)
Champions League Grupo 1
20 veces
(2019, 2018, 2017, 2017, 2015, 2015, 2005, 2005, 2004, 2004, 2001, 1998, 1998, 1994, 1994, 1989, 1983, 1979, 1964, 1962)
Europa League Grupo 8
15 veces
(2023, 2023, 2022, 2022, 2016, 2006, 2006, 2000, 1999, 1997, 1996, 1991, 1985, 1982, 1980)
Partidos Amistosos
14 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)
Fase Previa Champions League Grupo 4
11 veces
(2023, 2022, 2022, 2017, 2017, 2016, 2016, 2006, 2005, 1994, 1979)
Supercopa Francia
8 veces
(2019, 2018, 2001, 2000, 1998, 1985, 1961, 1960)
Recopa de Europa
6 veces
(1993, 1992, 1990, 1986, 1981, 1975)
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
Europa League Europa League »
23 Feb 23  Finalizado Monaco Monaco
2 - 3
 B. Leverkusen B. Leverkusen 869
16 Feb 23  Finalizado B. Leverkusen B. Leverkusen
2 - 3
 Monaco Monaco 273
03 Nov 22  Finalizado Monaco Monaco
4 - 1
 Crvena Zvezda Crvena Zvezda 114
27 Oct 22  Finalizado Ferencvárosi Ferencvárosi
1 - 1
 Monaco Monaco 203
13 Oct 22  Finalizado Trabzonspor Trabzonspor
4 - 0
 Monaco Monaco 369
06 Oct 22  Finalizado Monaco Monaco
3 - 1
 Trabzonspor TrabzonsporTarjeta Roja 110
15 Sep 22  Finalizado Monaco Monaco
0 - 1
 Ferencvárosi Ferencvárosi 488
08 Sep 22  Finalizado Crvena Zvezda Crvena Zvezda
0 - 1
 Monaco Monaco 203
Ligue 1 Ligue 1 »
03 Jun 23  Finalizado Monaco Monaco
1 - 2
 Toulouse Toulouse 182
27 May 23  Finalizado Stade Rennais Stade Rennais
2 - 0
 Monaco Monaco 125
19 May 23  Finalizado Olympique Lyonnais Olympique Lyonnais
3 - 1
 Monaco Monaco 159
14 May 23  Finalizado Monaco Monaco
0 - 0
 Lille Lille 107
07 May 23  Finalizado Angers SCO Angers SCO
1 - 2
 Monaco Monaco 88
30 Abr 23  Finalizado Monaco Monaco
0 - 4
 Montpellier Montpellier 276
22 Abr 23  Finalizado Lens Lens
3 - 0
 Monaco Monaco 278
16 Abr 23  Finalizado Monaco Monaco
3 - 1
 Lorient Lorient 57
09 Abr 23  Finalizado Nantes Nantes
2 - 2
 Monaco Monaco 159
02 Abr 23  Finalizado Monaco Tarjeta RojaMonaco
4 - 3
 Strasbourg Strasbourg 246
19 Mar 23  Finalizado Ajaccio Tarjeta RojaAjaccio
0 - 2
 Monaco Monaco 188
12 Mar 23  Finalizado Monaco Monaco
0 - 1
 Stade de Reims Stade de Reims 352
05 Mar 23  Finalizado Troyes Troyes
2 - 2
 Monaco Monaco 368
26 Feb 23  Finalizado Monaco Monaco
0 - 3
 Nice Nice 485
19 Feb 23  Finalizado Stade Brestois Stade Brestois
1 - 2
 Monaco Monaco 109
11 Feb 23  Finalizado Monaco Monaco
3 - 1
 PSG PSG 472
05 Feb 23  Finalizado Clermont Clermont
0 - 2
 Monaco Monaco 107
01 Feb 23  Finalizado Monaco Monaco
3 - 2
 Auxerre Auxerre 166
28 Ene 23  Finalizado Olympique Marseille Olympique Marseille
1 - 1
 Monaco Monaco 343
15 Ene 23  Finalizado Monaco Monaco
7 - 1
 Ajaccio Ajaccio 189
11 Ene 23  Finalizado Lorient Lorient
2 - 2
 Monaco Monaco 158
01 Ene 23  Finalizado Monaco Monaco
1 - 0
 Stade Brestois Stade Brestois 166
28 Dic 22  Finalizado Auxerre Auxerre
2 - 3
 Monaco Monaco 1287
13 Nov 22  Finalizado Monaco Monaco
2 - 3
 Olympique Marseille Olympique Marseille 546
06 Nov 22  Finalizado Toulouse Toulouse
0 - 2
 Monaco Monaco 89
30 Oct 22  Finalizado Monaco Monaco
2 - 0
 Angers SCO Angers SCO 293
23 Oct 22  Finalizado Lille Lille
4 - 3
 Monaco Monaco 292
16 Oct 22  Finalizado Monaco Tarjeta RojaMonaco
1 - 1
 Clermont Clermont 253
09 Oct 22  Finalizado Montpellier Montpellier
0 - 2
 Monaco Monaco 129
02 Oct 22  Finalizado Monaco Monaco
4 - 1
 Nantes Nantes 154
18 Sep 22  Finalizado Stade de Reims Stade de Reims
0 - 3
 Monaco MonacoTarjeta Roja 106
11 Sep 22  Finalizado Monaco Monaco
2 - 1
 Olympique Lyonnais Olympique Lyonnais 236
04 Sep 22  Finalizado Nice Nice
0 - 1
 Monaco Monaco 245
31 Ago 22  Finalizado Monaco Tarjeta RojaMonaco
2 - 4
 Troyes Troyes 548
28 Ago 22  Finalizado PSG PSG
1 - 1
 Monaco Monaco 719
20 Ago 22  Finalizado Monaco Tarjeta RojaMonaco
1 - 4
 Lens Lens 229
13 Ago 22  Finalizado Monaco Tarjeta RojaMonaco
1 - 1
 Stade Rennais Stade Rennais 570
06 Ago 22  Finalizado Strasbourg Strasbourg
1 - 2
 Monaco Monaco 237
Copa de Francia Copa de Francia »
07 Ene 23  Finalizado Monaco Monaco
2 - 2
 Rodez Rodez 134
Fase Previa Champions League Fase Previa Champions League »
09 Ago 22  Finalizado PSV PSV
3 - 2
 Monaco Monaco 727
02 Ago 22  Finalizado Monaco Monaco
1 - 1
 PSV PSV 870
Partidos Amistosos Partidos Amistosos »
23 Mar 23  Finalizado Monaco Monaco
1 - 1
 Spezia Spezia 1
21 Dic 22  Finalizado Leeds United Leeds United
2 - 4
 Monaco Monaco 47
17 Dic 22  Finalizado Fiorentina Fiorentina
1 - 1
 Monaco Monaco 176
16 Dic 22  Finalizado Empoli Empoli
0 - 1
 Monaco Monaco 140
07 Dic 22  Finalizado Sevilla Sevilla
1 - 1
 Monaco Monaco 253
02 Dic 22  Aplazado Monaco Monaco
-
 Cercle Brugge Cercle Brugge 232
22 Sep 22  Finalizado Monaco Monaco
2 - 3
 Genoa Genoa 1
27 Jul 22  Finalizado Southampton Southampton
3 - 1
 Monaco Monaco 38
23 Jul 22  Finalizado Porto Porto
2 - 1
 Monaco Monaco 73
16 Jul 22  Finalizado Inter Inter
2 - 2
 Monaco Monaco 144
09 Jul 22  Finalizado Portimonense Portimonense
0 - 2
 Monaco Monaco 18
06 Jul 22  Finalizado Monaco Monaco
2 - 2
 Austria Wien Austria Wien 25
29 Jun 22  Finalizado Monaco Monaco
1 - 1
 St. Gallen St. Gallen 30
25 Jun 22  Finalizado Monaco Monaco
1 - 0
 Cercle Brugge Cercle Brugge 4

Plantilla del Monaco Temporada 2022/2023

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
16 27 de 193 86 - - 1
18 fr - - - - -
30 28 fr 193 80 - - -
50 21 fr 194 82 - - -
Defensa
6 26 fr 190 86 3 - 3
34 21 fr 193 81 - - -
12 26 br 178 73 1 - 3
3 29 cl 193 83 3 1 6
14 24 sn 184 75 - - 3
23 25 fr 183 73 - - 3
26 31 fr 172 71 - - 3
41 20 fr 188 70 - - -
2 22 br 173 74 1 1 4
99 21 fr 189 65 - - -
Centrocampista
17 27 ru 178 69 8 - 5
44 19 ma 178 63 4 - 1
42 19 fr 173 - 1 - -
15 22 be 170 74 1 - 2
11 25 br 181 78 - - -
21 22 fr 183 63 - - 3
4 24 ml 173 67 - 1 6
20 fr 179 - - - -
19 25 fr 185 74 2 2 4
Delantero
36 27 ch 187 84 12 - 3
77 28 pt 170 72 - - -
31 31 de 179 74 3 - 1
27 25 sn 175 68 4 - 3
9 23 nl 181 65 3 - -
18 29 jp 172 67 1 - 2
10 33 fr 170 68 19 - 4

Noticias del Monaco

Ver últimas noticias

Palmarés de la Ligue 1: el histórico de campeones de la Liga Francesa

BeSoccer Pro - Lunes, 29 Abril 2024
0 1.851

La Ligue 1 ha sido dominada durante la década anterior y lo que va de la actual por el Paris Saint-Germain, que esgrime unas finanzas que han sido valedoras de la presencia de algunos de los mayores ganadores del presente e incluso de la historia gala. Leo Messi, Kylian Mbappé... Son muchos los protagonistas que han sellado un gobierno impregnado en el palmarés de la categoría, donde tan solo el Saint-Étienne, a nivel histórico, discute a los del Parque de los Príncipes. BeSoccer Pro recoge a todos sus campeones.

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

BeSoccer - Lunes, 13 Febrero 2017
0 5.266

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.

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

BeSoccer - Martes, 30 Junio 2015
0 282

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

BeSoccer - Domingo, 28 Junio 2015
0 231

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

BeSoccer - Lunes, 22 Junio 2015
0 386

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.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,722,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.2185
Total Execution Time  0.2218
  CADENA URL  
/Monaco/2023
  GET DATOS  
$_GET['/Monaco/2023']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0018  SELECT type FROM routes WHERE alias = 'monaco'
0.0037  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 = 2023 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.0019  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.0018  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.0018  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.0018  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.0018  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.0018  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.0019  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.0025  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 = 68864
0.0026  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 = 67751
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1713 AND type_rel = 2
0.0064  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1713 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (1263611,177137,506,792,940) ORDER BY n.cover_points DESC, update_date DESC
0.0052  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 = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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.0020  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 = 67751 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 = 70208 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 70409 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 67675 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  (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 calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 1713 or c.datateam2 = 1713) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0032  (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 calendars2023 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 = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0026  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 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 = 2023)
0.0036  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 (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74470,72046,72030,71432,70409,67751) 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.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 72046 AND teamId = 1713
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 1713
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 1713
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 67751 AND teamId = 1713
0.0116  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1713
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72030 AND teamId = 1713
0.0042  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 events2023 e ON e.player_id = p.id AND e.league_id = 67675 WHERE rp.league_id = 67675 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.0039  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 events2023 e ON e.player_id = p.id AND e.league_id = 67675 WHERE rp.league_id = 67675 AND rp.teamId = 1713 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043  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 events2023 e ON e.player_id = p.id AND e.league_id = 67675 WHERE rp.league_id = 67675 AND rp.teamId = 1713 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0053  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 = 67675 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0027  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=6515021 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0020  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6515021
0.0034  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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515021 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.0030  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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515021 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0027  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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515021 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0027   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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515021 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0026  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 events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6515021 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC