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

Liverpool

Entrenador: Jürgen Klopp

Información
  • Nombre del equipo Liverpool
  • Nombre completo Liverpool Football Club
  • Nombre corto LIV
  • País Inglaterra
  • Ciudad Liverpool
  • Entrenador Jürgen Klopp
  • URL del equipo en RF //m.resultados-futbol.com/Liverpool
Otros Datos
  • Año de Fundación 1892
  • Patrocinador Standard Chartered
  • Marca de Ropa Nike
  • Socios 38000
Internet
Información sobre el estadio
  • Nombre del estadio Anfield
  • Capacidad 54074
  • Dirección Anfield Road
  • Teléfono +44 (151) 263 2361
  • Fax +44 (151) 260 8813
  • Año de construcción 1884
  • Tamaño 101 x 68 metros
Anfield
Histórico de participación
Premier League
FA Cup
EFL Cup
Champions League Grupo 1
Community Shield
Europa League Grupo 0
Partidos Amistosos
15 veces
Championship
11 veces
Fase Previa Champions League Grupo 4
9 veces
Supercopa Europa
6 veces
Recopa de Europa
5 veces
Copa de Ferias
4 veces
Fase Previa Europa League Grupo 3
4 veces
International Champions Cup
4 veces
Copa Intercontinental
2 veces
(1985, 1982)
Mundial de Clubes
2 veces
(2020, 2006)
Trofeo Santiago Bernabéu
2 veces
(2003, 1990)
Copa Audi
1 vez
(2017)
Dubai Super Cup
1 vez
(2023)
Trofeo Premier League Asia
1 vez
(2017)
Trofeo Teresa Herrera
1 vez
(1989)
Partidos del Liverpool Ir al LIVESCORE
19 May 24  en 1 mes Liverpool
17:00
Wolves 10
11 May 24  en 1 mes Aston Villa
16:00
Liverpool 5
04 May 24  en 1 mes Liverpool
16:00
Tottenham Hotspur 2
27 Abr 24  en 28 días West Ham
13:30
Liverpool 1
24 Abr 24  en 26 días Everton
21:00
Liverpool 12
21 Abr 24  en 22 días Fulham
17:30
Liverpool 1
14 Abr 24  en 15 días Liverpool
15:00
Crystal Palace 1
07 Abr 24  en 8 días Manchester United
16:30
Liverpool 4
04 Abr 24  en 6 días Liverpool
20:30
Sheffield United 3
31 Mar 24  en 1 día Liverpool
15:00
Brighton & Hove Albion 22
10 Mar 24  Finalizado Liverpool
1 - 1
Manchester City 1611
02 Mar 24  Finalizado Nottingham Forest
0 - 1
Liverpool 1026
21 Feb 24  Finalizado Liverpool
4 - 1
Luton Town 1175
17 Feb 24  Finalizado Brentford
1 - 4
Liverpool 760
10 Feb 24  Finalizado Liverpool
3 - 1
Burnley 338
04 Feb 24  Finalizado Arsenal
3 - 1
LiverpoolTarjeta Roja 902
31 Ene 24  Finalizado Liverpool
4 - 1
Chelsea 593
21 Ene 24  Finalizado AFC Bournemouth
0 - 4
Liverpool 546
01 Ene 24  Finalizado Liverpool
4 - 2
Newcastle 1267
26 Dic 23  Finalizado Burnley
0 - 2
Liverpool 649
23 Dic 23  Finalizado Liverpool
1 - 1
Arsenal 639
17 Dic 23  Finalizado Liverpool
0 - 0
Manchester UnitedTarjeta Roja 918
09 Dic 23  Finalizado Tarjeta RojaCrystal Palace
1 - 2
Liverpool 1320
06 Dic 23  Finalizado Sheffield United
0 - 2
Liverpool 484
03 Dic 23  Finalizado Liverpool
4 - 3
Fulham 1274
18 Abr 24  en 20 días Atalanta
21:00
Liverpool 1
11 Abr 24  en 13 días Liverpool
21:00
Atalanta 6
14 Mar 24  Finalizado Liverpool
6 - 1
Sparta Praha 684
07 Mar 24  Finalizado Sparta Praha
1 - 5
Liverpool 580
14 Dic 23  Finalizado Union Saint-Gilloise
2 - 1
Liverpool 877
30 Nov 23  Finalizado Liverpool
4 - 0
LASK 174
17 Mar 24  Finalizado Tarjeta RojaManchester United
4 - 3
Liverpool 1164
28 Feb 24  Finalizado Liverpool
3 - 0
Southampton 586
28 Ene 24  Finalizado Liverpool
5 - 2
Norwich City 117
07 Ene 24  Finalizado Arsenal
0 - 2
Liverpool 833
25 Feb 24  Finalizado Chelsea
0 - 1
Liverpool 1059
24 Ene 24  Finalizado Fulham
1 - 1
Liverpool 399
10 Ene 24  Finalizado Liverpool
2 - 1
Fulham 549
20 Dic 23  Finalizado Liverpool
5 - 1
West Ham 243

Plantilla del Liverpool Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 37 es 190 78 - - -
1 31 br 193 91 - - 1
62 25 ie 188 71 - - -
93 20 pl 192 - - - -
Defensa
26 30 ss 178 64 1 - 2
66 25 gb 180 69 2 - 5
65 17 gb - - - - -
48 19 gb 169 - - - -
84 20 i1 181 71 1 - 1
5 24 fr 194 95 - 1 5
78 21 gb 190 80 - - 1
2 26 gb 188 77 - - 4
32 32 cm 195 90 - - 2
21 27 gr 179 77 - - -
23 gb 195 82 - - -
4 32 nl 193 92 2 1 1
Centrocampista
10 25 ar 176 72 3 1 5
42 19 gb 178 - - - -
17 23 gb 185 75 1 1 1
8 23 hu 187 76 3 - 1
19 20 gb 170 68 2 - 1
53 19 gb 183 - - - -
38 21 nl 190 75 - - -
43 19 es 185 73 - - -
6 32 es 174 71 - - -
98 16 gb - - - - -
3 31 jp 178 75 1 - 7
Delantero
50 18 ss 173 - - - -
18 24 nl 193 76 5 - -
9 24 uy 187 78 10 - 8
20 27 pt 178 70 9 1 3
76 18 gb 183 - - - 1
49 19 gb 173 65 - - -
67 18 wa - - - - -
7 27 co 180 65 6 - 2
11 31 eg 175 70 15 - 2
Noticias del Liverpool
Ver últimas noticias

Xabi Alonso se aleja del Liverpool... ¡y también del Bayern!

Nadie sabe dónde entrenará Xabi Alonso la próxima temporada. Por el momento, 'The Times' aseguró que el Liverpool no está convencido de que el español vaya a estar disponible este verano. Y el presidente de honor del Bayern de Múnich, Uli Hoeness, aseguró en la prensa alemana que es "prácticamente imposible" su llegada al banquillo bávaro.

"¿Mi hijo, al Madrid o al Atleti? No pierdan la esperanza"

Luis Manuel Díaz, el padre de Luis Díaz, concedió una entrevista a la cadena 'SER' en la que recordó los momentos en los que su hijo salió del Oporto rumbo al Liverpool. Los 'reds' presentaron una oferta mucho más clara que las que se filtraron que el Real Madrid y el Atlético tenían en borrador, pero que jamás llegaron. Aun así, el progenitor anima a los aficionados de la Liga Española a no perder la esperanza de verle en su campeonato.

"A Klopp le queremos regalar la Premier"

El internacional argentino Alexis Mac Allister atendió a 'ESPN' en Los Ángeles, en el marco del amistoso que medirá a la 'Albiceleste' frente a Costa Rica, y se refirió a la ausencia de Messi así como a el adiós de Klopp a final de temporada. El jugador del Liverpool aseguró que quieren regalarle la Premier al técnico alemán.

Fernando Torres, Gerrard y un sueño perfecto para Eriksson

Las leyendas del Liverpool vencieron a las del Ajax por 4-2, en un partido marcado por la vuelta de jugadores de la talla de Fernando Torres y Steven Steven Gerrard y por el reconocimiento a Sven-Goran Erikson, que cumplió su última voluntad al dirigir a los 'reds'.

Eriksson cumplió su sueño y dirigió al Liverpool con ovación incluida de Anfield

A sus 76 años, Sven-Goran Eriksson cumplió el sueño que perseguía desde niño y dirigió al Liverpool por un día. El ex entrenador, al que le diagnosticaron un cáncer de páncreas, fue recibido con honores por todo Anfield Road.



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,749,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6651
Total Execution Time  0.6670
  CADENA URL  
/Liverpool
  GET DATOS  
$_GET['/Liverpool']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0105  SELECT type FROM routes WHERE alias = 'liverpool'
0.0136  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 = 'Liverpool' AND l.year = 2024 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=3845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=3845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=3845 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=3845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=3845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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=3845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111  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=3845 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0107  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3845 AND type_rel = 2
0.0218  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 3845 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0112  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 (1308438,1308337,1307758,1307746,1307925) ORDER BY n.cover_points DESC, update_date DESC
0.0284  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 = '3845' ORDER BY l.year DESC,cat.coefficient DESC
0.0163  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 = '3845' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0177  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 = '3845' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0120  (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 = 3845 or c.datateam2 = 3845) 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.0115  (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 = 3845 or c.datateam2 = 3845) 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.0112  (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 = 3845 or c.datateam2 = 3845) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0127  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=3845 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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,74791,72728,72258,71849,70757,70393,68979) 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.0117  SELECT count(id) as num_players from rel_players WHERE league_id = 71849 AND teamId = 3845
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 70393 AND teamId = 3845
0.0118  SELECT count(id) as num_players from rel_players WHERE league_id = 74791 AND teamId = 3845
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 3845
0.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 3845
0.0105  SELECT count(id) as num_players from rel_players WHERE league_id = 68979 AND teamId = 3845
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 70757 AND teamId = 3845
0.0106  SELECT count(id) as num_players from rel_players WHERE league_id = 75586 AND teamId = 3845
0.0119  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 = '3845' 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 = '3845' 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 = '3845' 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 = '3845' and rp.type = 4
0.0129  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 = 3845 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 71849 WHERE rp.league_id = 71849 AND rp.teamId = 3845 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0115  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 = 3845 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118  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 = 3845 AND rp.league_id = 71849 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0110  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=6578395 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=6578395
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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578395 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.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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578395 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578395 and (e.action = 3 or e.action = 4) 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578395 AND (e.action = 22) 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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6578395 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC