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

Arsenal

Entrenador: Mikel Arteta

Temporada 2023/2024

¿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 Arsenal

Enviar Datos
Información
  • Nombre del equipo Arsenal
  • Nombre completo Arsenal Football Club
  • Nombre corto ARS
  • País Inglaterra
  • Ciudad Londres
  • Entrenador Mikel Arteta
  • URL del equipo en RF //m.resultados-futbol.com/Arsenal
Otros Datos
  • Año de Fundación 1886
  • Patrocinador Emirates
  • Marca de Ropa Adidas
  • Socios 38788
Internet

Información sobre el estadio

  • Nombre del estadio Emirates Stadium
  • Capacidad 60355
  • Dirección Queensland Road
  • Teléfono +44 (207) 619 5003
  • Año de construcción 2006
  • Tamaño 105x68
Emirates Stadium

Histórico de participación

Premier League
108 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, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1913, 1912, 1911, 1910, 1909, 1908, 1907, 1906, 1905)
FA Cup
77 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, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1980, 1979, 1978, 1977, 1975, 1973, 1972, 1971, 1969, 1963, 1957, 1956, 1953, 1952, 1951, 1950, 1938, 1936, 1935, 1934, 1932, 1930, 1929, 1928, 1927, 1926, 1922, 1911, 1907, 1906, 1905, 1904, 1903, 1902, 1901)
EFL Cup
51 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, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1981, 1980, 1978, 1977, 1973, 1972, 1969, 1968)
Champions League Grupo 0
40 veces
(2024, 2024, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2013, 2012, 2012, 2011, 2011, 2010, 2010, 2009, 2009, 2008, 2008, 2007, 2007, 2006, 2006, 2005, 2005, 2004, 2004, 2003, 2003, 2002, 2002, 2001, 2001, 2001, 2000, 1999, 1972)
Community Shield
24 veces
(2024, 2021, 2018, 2016, 2015, 2006, 2005, 2004, 2003, 2000, 1999, 1994, 1992, 1990, 1980, 1954, 1949, 1939, 1937, 1936, 1935, 1934, 1932, 1931)
Partidos Amistosos
16 veces
(2025, 2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010)
Europa League Grupo 0
16 veces
(2023, 2023, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2000, 1998, 1997, 1983, 1982, 1979)
Copa Emirates
14 veces
(2024, 2023, 2020, 2018, 2017, 2016, 2015, 2014, 2013, 2011, 2010, 2009, 2008, 2007)
Championship
13 veces
(1915, 1914, 1904, 1903, 1902, 1901, 1900, 1899, 1898, 1897, 1896, 1895, 1894)
Fase Previa Champions League Grupo 4
8 veces
(2015, 2014, 2012, 2010, 2009, 2008, 2007, 1992)
Copa de Ferias
3 veces
(1971, 1970, 1964)
International Champions Cup
3 veces
(2020, 2019, 2018)
Recopa de Europa
3 veces
(1995, 1994, 1980)
MLS All-Star
2 veces
(2023, 2016)
Trofeo Joan Gamper
1 vez
(2020)
Dubai Super Cup
1 vez
(2023)
FA Trophy
1 vez
(2018)
Trofeo Premier League Asia
1 vez
(2015)
Soccer Champions Tour
1 vez
(2024)
Supercopa Europa
1 vez
(1995)
Trofeo Naranja
1 vez
(2010)

Partidos del Arsenal

Ir al LIVESCORE
Champions League Champions League »
17 Abr 24  Finalizado Bayern München
1 - 0
 Arsenal 1964
09 Abr 24  Finalizado Arsenal
2 - 2
 Bayern München 1396
12 Mar 24  Finalizado Arsenal
1 - 0
 Porto 1764
21 Feb 24  Finalizado Porto
1 - 0
 Arsenal 1546
Premier League Premier League »
19 May 24  en 24 días Arsenal
17:00
 Everton 12
12 May 24  en 17 días Manchester United
17:30
 Arsenal 8
04 May 24  en 9 días Arsenal
13:30
 AFC Bournemouth 2
28 Abr 24  en 3 días Tottenham Hotspur
15:00
 Arsenal 8
23 Abr 24  Finalizado Arsenal
5 - 0
 Chelsea 1046
20 Abr 24  Finalizado Wolves
0 - 2
 Arsenal 714
14 Abr 24  Finalizado Arsenal
0 - 2
 Aston Villa 947
06 Abr 24  Finalizado Brighton & Hove Albion
0 - 3
 Arsenal 540
03 Abr 24  Finalizado Arsenal
2 - 0
 Luton Town 582
31 Mar 24  Finalizado Manchester City
0 - 0
 Arsenal 1377
09 Mar 24  Finalizado Arsenal
2 - 1
 Brentford 1095
04 Mar 24  Finalizado Sheffield United
0 - 6
 Arsenal 684
24 Feb 24  Finalizado Arsenal
4 - 1
 Newcastle 578
17 Feb 24  Finalizado Burnley
0 - 5
 Arsenal 235
11 Feb 24  Finalizado West Ham
0 - 6
 Arsenal 604
04 Feb 24  Finalizado Arsenal
3 - 1
 LiverpoolTarjeta Roja 902
30 Ene 24  Finalizado Nottingham Forest
1 - 2
 Arsenal 595
20 Ene 24  Finalizado Arsenal
5 - 0
 Crystal Palace 343
31 Dic 23  Finalizado Fulham
2 - 1
 Arsenal 855
28 Dic 23  Finalizado Arsenal
0 - 2
 West Ham 1463
FA Cup FA Cup »
07 Ene 24  Finalizado Arsenal
0 - 2
 Liverpool 833

Plantilla del Arsenal Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 25 gb 190 73 - - -
22 28 es 183 80 - - 1
31 22 ee 193 - - - -
Defensa
4 26 gb 186 78 4 - 8
17 32 pt 171 79 - - -
6 26 br 190 78 3 - 4
15 24 pl 189 75 1 - 1
73 20 wa 180 - - - -
12 22 nl 179 77 - - 1
35 27 ua 175 61 1 - 2
76 19 gb 183 - - - -
18 25 jp 188 70 1 1 2
2 23 fr 192 85 2 - 4
Centrocampista
41 25 gb 188 80 6 - 4
63 17 gb 176 - - - -
21 23 pt 170 58 1 1 -
20 32 it 178 65 - - 1
29 24 de 193 82 11 - 9
59 17 gb 178 - - - -
40 20 pt 178 - - - -
25 31 eg 179 70 - - -
8 25 no 178 68 8 - 2
10 23 gb 182 68 - - -
5 30 gh 185 77 - - -
Delantero
7 22 gb 178 65 14 - 3
14 24 gb 175 70 5 - 3
9 27 br 175 67 4 - 6
19 29 be 172 61 10 - 2
11 22 br 178 75 6 - 1
24 24 gb 175 71 - - 1

Noticias del Arsenal

Ver últimas noticias

La ruta del campeón

Fran Berrocal - Miércoles, 24 Abril 2024
2 13.507

La Premier League se acerca a su meta con la lucha por la gloria al rojo vivo. El Arsenal mantiene una renta de 3 puntos sobre el Liverpool, que se pegó el tortazo en el derbi de Merseyside ante el Everton. Un 2-0 en contra que confirma la mala dinámica del equipo de Jürgen Klopp tras el fracaso en la Europa League. Y el Manchester City al acecho, que depende de sí mismo para ganar el título. Los 'sky blues' visitarán al Brighton & Hove Albion este jueves (21:00) en el primero de los 2 partidos pendientes por disputar con 4 unidades de desventaja.

La 2ª manita en 'era Premier' que el Chelsea encaja del Arsenal... y de Arteta

David Caravaca - Miércoles, 24 Abril 2024
0 2.311

El Arsenal pasó por encima del Chelsea en su partido de la jornada 29 de la Premier League. Los 'blues' no caían con tanto estrépito, encajando cinco goles, desde el 29 de octubre de 2011, cuando Mikel Arteta, actual entrenador de los 'gunners', jugaba para Arsène Wenger. Por aquel entonces, los azules estaban comandados por André Villas-Boas, cuyo plan se vio roto por un 'hat trick' de Robin van Persie.

El Arsenal hace trizas al Chelsea

David Caravaca - Martes, 23 Abril 2024
0 9.439

El Arsenal derrotó al Chelsea por 5-0 en la jornada 29 de la Premier League. Los de Mikel Arteta pasaron por encima de los de Mauricio Pochettino en un partido en el que la única propuesta de los 'blues' para tratar de contrarrestar el dominio 'gunner' residió en una batería de contragolpes durante la primera mitad. Sin Cole Palmer, el cuadro de Stamford Bridge no tuvo otro argumento en el Emirates Stadium, telón de fondo de una fiesta. Para mayor crueldad hacia los azules, Kai Havertz, autor del gol de su Champions League de 2021, firmó un doblete. Lo celebró.

Nico Jackson le clavó los tacos en el tobillo a Tomiyasu... y no vio ni amarilla

BeSoccer - Martes, 23 Abril 2024
0 6.742

En los primeros compases del derbi de Londres entre el Arsenal y el Chelsea, Nico Jackson se salvó de la tarjeta roja directa tras clavarle los tacos a Takehiro Tomiyasu en el tobillo durante un lance del juego en el que el delantero iba sin mala intención, pero iba. El colegiado solventó la jugada con falta en favor de los 'gunners', pero nada más, lo que resultó llamativo para la afición local habiendo VAR.

Así seguimos el directo del Arsenal - Chelsea

David Caravaca - Martes, 23 Abril 2024
3 14.051

Vive con nosotros el relato en directo de todo lo que ocurra durante el partido de la jornada 29 en la Premier League entre el Arsenal y el Chelsea.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,915,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1912
Total Execution Time  0.1931
  CADENA URL  
/arsenal
  GET DATOS  
$_GET['/arsenal']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0018  SELECT type FROM routes WHERE alias = 'arsenal'
0.0040  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 = 71953
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 = 72030
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=263 AND type_rel = 2
0.0046  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 263 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  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 (1312403,1312345,1312310,1312300,1312238) ORDER BY n.cover_points DESC, update_date DESC
0.0044  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 = '263' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 71953 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 = 71849 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  (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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 263 or c.datateam2 = 263) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 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 calendars2024 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 = 263 or c.datateam2 = 263) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0022  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 263 or c.datateam2 = 263) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0039  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=263 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75586,74790,72728,72258,72030,71953,71849,71690,71580,70757,70409) 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.0042  SELECT count(id) as num_players from rel_players WHERE league_id = 71849 AND teamId = 263
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 74790 AND teamId = 263
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 70409 AND teamId = 263
0.0038  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 263
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 263
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 71953 AND teamId = 263
0.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 71690 AND teamId = 263
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 70757 AND teamId = 263
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75586 AND teamId = 263
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71580 AND teamId = 263
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 72030 AND teamId = 263
0.0024  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 71849 AND t.round = 35 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0040  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 = '263' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '263' and rp.type = 4
0.0029  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 = '263' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0018  SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '263' and rp.type = 4
0.0048  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 events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 263 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 263 AND (e.action = 4 or e.action = 5) 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 events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 263 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037  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 = 263 AND rp.league_id = 71849 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0028  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=6578394 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6578394
0.0028  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578394 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.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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578394 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0023  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578394 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0025   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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578394 AND (e.action = 22) 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578394 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC