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

Wealdstone

Entrenador: Sam Cox

Temporada 2021/2022

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

Enviar Datos
Información
Otros Datos
  • Año de Fundación 1899
Internet

Información sobre el estadio

  • Nombre del estadio St. George's Stadium
  • Capacidad 2387
  • Dirección Grosvenor Vale
St. George's Stadium

Partidos del Wealdstone

Ir al LIVESCORE
Partidos Amistosos Partidos Amistosos »
14 Ago 21  Finalizado Wealdstone Wealdstone
3 - 1
 Hungerford Town Hungerford Town 0
07 Ago 21  Finalizado Dorking Wanderers Dorking Wanderers
1 - 2
 Wealdstone Wealdstone 0
31 Jul 21  Finalizado Wealdstone Wealdstone
1 - 1
 Colchester United Colchester United 0
27 Jul 21  Finalizado Chesham United Chesham United
1 - 4
 Wealdstone Wealdstone 0
24 Jul 21  Finalizado Bedford Town Bedford Town
2 - 2
 Wealdstone Wealdstone 0
20 Jul 21  Finalizado St Albans Saints St Albans Saints
1 - 1
 Wealdstone Wealdstone 0
17 Jul 21  Aplazado Rayners Lane Rayners Lane
-
 Wealdstone Wealdstone 0
FA Trophy FA Trophy »
18 Dic 21  Finalizado Needham Market Needham Market
2 - 1
 Wealdstone Wealdstone 0
National League National League »
15 May 22  Finalizado Aldershot Town Aldershot Town
1 - 3
 Wealdstone Wealdstone 1
07 May 22  Finalizado Wealdstone Wealdstone
2 - 1
 Kings Lynn Town Kings Lynn Town 0
02 May 22  Finalizado Yeovil Town Yeovil Town
0 - 0
 Wealdstone WealdstoneTarjeta Roja 1
30 Abr 22  Finalizado Wealdstone Wealdstone
1 - 2
 Dagenham & Redbridge Dagenham & Redbridge 0
23 Abr 22  Finalizado Altrincham Altrincham
4 - 2
 Wealdstone Wealdstone 0
18 Abr 22  Finalizado Wealdstone Wealdstone
2 - 0
 Boreham Wood Boreham WoodTarjeta Roja 0
15 Abr 22  Finalizado Southend United Southend United
0 - 1
 Wealdstone Wealdstone 0
09 Abr 22  Finalizado Wealdstone Wealdstone
1 - 2
 Chesterfield Chesterfield 0
05 Abr 22  Finalizado Wealdstone Wealdstone
0 - 0
 Maidenhead United Maidenhead United 0
02 Abr 22  Finalizado FC Halifax Town FC Halifax Town
2 - 0
 Wealdstone Wealdstone 0
26 Mar 22  Finalizado Wealdstone Wealdstone
1 - 1
 Bromley Bromley 0
19 Mar 22  Finalizado Stockport County Stockport County
4 - 2
 Wealdstone Wealdstone 0
12 Mar 22  Finalizado Wealdstone Wealdstone
3 - 2
 Weymouth Weymouth 0
08 Mar 22  Finalizado Maidenhead United Maidenhead United
0 - 2
 Wealdstone Wealdstone 2
05 Mar 22  Finalizado Eastleigh Eastleigh
4 - 1
 Wealdstone Wealdstone 0
26 Feb 22  Finalizado Wealdstone Wealdstone
1 - 1
 Torquay United Torquay United 0
22 Feb 22  Finalizado Solihull Moors Tarjeta RojaSolihull Moors
2 - 1
 Wealdstone Wealdstone 2
19 Feb 22  Finalizado Wealdstone Tarjeta RojaWealdstone
1 - 2
 Wrexham AFC Wrexham AFC 1
12 Feb 22  Finalizado Barnet Barnet
1 - 3
 Wealdstone Wealdstone 0
08 Feb 22  Finalizado Wealdstone Wealdstone
2 - 1
 Yeovil Town Yeovil Town 1
29 Ene 22  Finalizado Grimsby Town Grimsby Town
2 - 1
 Wealdstone Wealdstone 0
25 Ene 22  Finalizado Wealdstone Wealdstone
0 - 0
 Notts County Notts County 1
22 Ene 22  Finalizado Woking Woking
2 - 0
 Wealdstone WealdstoneTarjeta Roja 0
15 Ene 22  Finalizado Wealdstone Wealdstone
2 - 1
 Dover Athletic Dover Athletic 0
11 Ene 22  Finalizado Boreham Wood Boreham Wood
1 - 0
 Wealdstone Wealdstone 1
11 Dic 21  Finalizado Wealdstone Wealdstone
0 - 1
 FC Halifax Town FC Halifax Town 1
04 Dic 21  Finalizado Bromley Bromley
3 - 2
 Wealdstone WealdstoneTarjeta Roja 0
27 Nov 21  Finalizado Wealdstone Wealdstone
1 - 4
 Stockport County Stockport County 0
23 Nov 21  Finalizado Dover Athletic Dover Athletic
2 - 3
 Wealdstone Wealdstone 0
20 Nov 21  Finalizado Wrexham AFC Wrexham AFC
0 - 0
 Wealdstone Wealdstone 0
13 Nov 21  Finalizado Wealdstone Wealdstone
1 - 0
 Barnet Barnet 3
26 Oct 21  Finalizado Wealdstone Wealdstone
1 - 0
 Grimsby Town Grimsby Town 5
23 Oct 21  Finalizado Weymouth Weymouth
1 - 1
 Wealdstone Wealdstone 0
09 Oct 21  Finalizado Wealdstone Wealdstone
1 - 2
 Eastleigh Eastleigh 0
05 Oct 21  Finalizado Wealdstone Wealdstone
0 - 0
 Solihull Moors Solihull Moors 0
02 Oct 21  Finalizado Torquay United Torquay United
5 - 0
 Wealdstone Wealdstone 0
25 Sep 21  Finalizado Kings Lynn Town Kings Lynn Town
0 - 1
 Wealdstone WealdstoneTarjeta RojaTarjeta Roja 0
18 Sep 21  Finalizado Wealdstone Wealdstone
2 - 2
 Aldershot Town Aldershot Town 0
14 Sep 21  Finalizado Notts County Notts County
3 - 2
 Wealdstone Wealdstone 1
11 Sep 21  Finalizado Wealdstone Wealdstone
1 - 0
 Altrincham AltrinchamTarjeta Roja 0
04 Sep 21  Finalizado Dagenham & Redbridge Dagenham & Redbridge
2 - 2
 Wealdstone Wealdstone 0
30 Ago 21  Finalizado Wealdstone Wealdstone
0 - 0
 Southend United Southend United 5
28 Ago 21  Finalizado Chesterfield Chesterfield
2 - 0
 Wealdstone Wealdstone 8
21 Ago 21  Finalizado Wealdstone Wealdstone
1 - 2
 Woking Woking 0

Plantilla del Wealdstone Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
13 21 gb - - - - -
1 22 gb 198 78 - 1 6
21 34 gb - - - - -
21 26 gb 190 85 - - -
23 gb 188 84 - - -
Defensa
12 26 gb 172 67 - - 2
21 21 gb 180 70 - - -
19 23 gb 169 - 1 - 1
5 26 gb 187 79 1 - 2
14 22 ss 190 - 3 - 5
3 31 gb 182 78 - - -
11 25 sl 184 75 - - 3
15 19 gb - - - - -
34 31 gb - - 1 - 1
2 30 gb - - 4 1 10
25 27 gb 188 66 1 - -
23 24 gb 183 75 2 - 4
6 35 gb 182 76 1 - 5
26 22 gb 178 70 2 - 3
27 cd 180 73 3 1 3
17 25 hr 188 76 1 - 5
28 gb 193 64 3 - 6
Centrocampista
4 24 gd 180 - 1 - 7
18 33 ms 178 74 - 1 5
22 20 gb 168 - 2 - 2
24 27 gb 175 73 2 - 9
7 23 gb 182 - - - -
- gb - - - - -
22 31 i1 188 77 - - -
8 26 gb - - 1 - 2
21 22 gb - - - - -
20 34 gb 180 69 1 - 5
7 28 gy 178 82 2 - 7
29 19 gb - - - - -
19 22 gb 171 65 - - -
Delantero
27 gb 179 - - - -
11 26 gb 178 69 3 - -
25 gb - - - - -
22 22 gb 186 - - 1 -
16 27 gb 180 - 4 1 -
22 22 gb 186 70 - - -
9 27 gb 185 80 16 - 7
10 28 ag 175 80 6 - 2

Noticias de National League

Ver últimas noticias

De Gea se entrena con un Quinta y quiere volver a jugar

BeSoccer - Martes, 30 Abril 2024
2 1.456

David de Gea publicó un vídeo en sus redes sociales en el que aparece entrenando con el Altrincham FC, un equipo de la Quinta División de Inglaterra. En paralelo, el diario 'Marca' asegura que tiene la intención de volver a jugar pronto. Ya ha pasado casi un año desde que dejó el Manchester United, cuyos reservas se ejercitan justamente en el complejo en el que él se mostró ante sus seguidores en Instagram.

El Wrexham insiste en Bale: "Iba en serio"

BeSoccer - Miércoles, 03 Mayo 2023
0 2.297

Rob McElhenney, copropietario del Wrexham, insistió en que la oferta a Gareth Bale para jugar en la League Two iba en serio, aunque espera que la vuelva a rechazar.

Bale rechaza al Wrexham

BeSoccer - Sábado, 29 Abril 2023
0 1.348

Gareth Bale decidió retirarse del fútbol profesional y así seguirá siendo. El ex jugador del Real Madrid negó en la ceremonia de los FEVO Sport Industry Awards la opción de competir con el Wrexham de Rob McElhenney la próxima temporada en League Two.

¿El último baile de Bale, con Deadpool?

BeSoccer - Miércoles, 26 Abril 2023
0 2.416

El Wrexham, equipo que copreside el actor Ryan Reynolds, sueña con tener a Gareth Bale en su vuelta al fútbol profesional, a la League Two.

Campeón y a Cuarta: el Wrexham de 'Deadpool' vuelve al fútbol profesional 15 años después

BeSoccer - Sábado, 22 Abril 2023
0 3.516

El Wrexham, equipo galés que milita en el sistema de ligas del fútbol inglés, celebró este sábado su ascenso a la League Two y, por tanto, al fútbol profesional tras imponerse al Boreham Wood por 3-1. El club es propiedad de Ryan Reynolds, actor conocido, entre otros papeles, por darle vida a 'Deadpool', y de Rob McElhenney.

Ver más noticias del equipo»



  USO DE MEMORIA  
6,417,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1799
Total Execution Time  0.1818
  CADENA URL  
/wealdstone/2022
  GET DATOS  
$_GET['/wealdstone/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0031  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 = 'wealdstone' AND l.year = 2022 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.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=11173 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=11173 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=11173 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=11173 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=11173 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 63246
0.0023  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 = 63347
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 = 63973
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11173 AND type_rel = 2
0.0026  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 = '11173' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '11173' 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 = 63246 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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 = 63347 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 = 63973 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  (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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 11173 or c.datateam2 = 11173) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0029  (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 calendars2022 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 = 11173 or c.datateam2 = 11173) AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0023  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 = 11173 or c.datateam2 = 11173) AND l.year = 2022)
0.0024  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=11173 AND l.year in (2021,2022,2023) 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 (68334,68333,68217,67320) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 68217 AND teamId = 11173
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 68334 AND teamId = 11173
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 68333 AND teamId = 11173
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 11173
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2022` 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 = 63246 AND t.round = 46 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0038  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 events2022 e ON e.player_id = p.id AND e.league_id = 63246 WHERE rp.league_id = 63246 AND rp.teamId = 11173 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.0032  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 events2022 e ON e.player_id = p.id AND e.league_id = 63246 WHERE rp.league_id = 63246 AND rp.teamId = 11173 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 events2022 e ON e.player_id = p.id AND e.league_id = 63246 WHERE rp.league_id = 63246 AND rp.teamId = 11173 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 11173 AND rp.league_id = 63246 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025  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=6449451 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6449451
0.0031  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6449451 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.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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6449451 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024  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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6449451 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0024   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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6449451 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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6449451 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC