Información
  • Nombre del equipo Atl. Mineiro
  • Nombre completo Clube Atlético Mineiro
  • Nombre corto ATM
  • País Brasil
  • Ciudad Belo Horizonte, Minas Gerais
  • Entrenador Gabriel Milito
  • URL del equipo en RF testing.resultados-futbol.com/Atletico-Mineiro
Otros Datos
  • Año de Fundación 1908
  • Presupuesto 1234568
  • Patrocinador BMG
  • Marca de Ropa Topper
  • Lugar de entrenamiento Cidade do Galo
  • Socios 1000
Internet
Información sobre el estadio
  • Nombre del estadio Estádio Raimundo Sampaio
  • Capacidad 23018
  • Dirección Avenida Olegário Maciel 1516, Bairro de Lourdes 30180-111 Belo Horizonte, Minas Gerais
  • Teléfono +55 (31) 3290 1313
  • Fax +55 (31) 3290 1300
  • Año de construcción 2012
  • Tamaño 105x70 metros
Estádio Raimundo Sampaio
Histórico de participación
Liga Brasileña
Mineiro 1 Grupo 0
Copa Brasil
Copa Libertadores Grupo 7
Conmebol Sudamericana
9 veces
Partidos Amistosos
4 veces
Fase Previa Copa Libertadores Grupo 3
4 veces
Copa Sul-Minas-Rio
3 veces
(2017, 2017, 2016)
Trofeo Ramón de Carranza
2 veces
(1992, 1991)
Copa Mercosur
2 veces
(2000, 2000)
Mundial de Clubes
1 vez
(2014)
Recopa Sudamericana
1 vez
(2014)
Serie B - Brasil
1 vez
(2006)
Supercopa de Brasil
1 vez
(2022)
Trofeo Costa del Sol
1 vez
(1981)
Partidos del Atl. Mineiro Ir al LIVESCORE
29 Sep 21  Finalizado Atl. Mineiro
1 - 1
Palmeiras 424
22 Sep 21  Finalizado Palmeiras
0 - 0
Atl. Mineiro 547
19 Ago 21  Finalizado Atl. Mineiro
3 - 0
River Plate 439
12 Ago 21  Finalizado River Plate
0 - 1
Atl. MineiroTarjeta Roja 396
21 Jul 21  Finalizado Atl. Mineiro
0 - 0
Boca Juniors 601
14 Jul 21  Finalizado Boca Juniors
0 - 0
Atl. Mineiro 446
26 May 21  Finalizado Atl. Mineiro
4 - 0
La Guaira 53
20 May 21  Finalizado Cerro Porteño
0 - 1
Atl. Mineiro 170
14 May 21  Finalizado Tarjeta RojaAmérica de Cali
1 - 3
Atl. Mineiro 167
05 May 21  Finalizado Atl. Mineiro
4 - 0
Cerro Porteño 151
28 Abr 21  Finalizado Tarjeta RojaAtl. Mineiro
2 - 1
América de Cali 275
22 Abr 21  Finalizado La Guaira
1 - 1
Atl. Mineiro 122
10 Dic 21  Finalizado Grêmio
4 - 3
Atl. Mineiro 363
05 Dic 21  Finalizado Atl. Mineiro
4 - 3
RB Bragantino 126
02 Dic 21  Finalizado Bahía
2 - 3
Atl. Mineiro 568
28 Nov 21  Finalizado Atl. Mineiro
2 - 1
Fluminense 110
24 Nov 21  Finalizado Palmeiras
2 - 2
Atl. Mineiro 312
20 Nov 21  Finalizado Atl. Mineiro
2 - 0
EC Juventude 328
16 Nov 21  Finalizado Athletico Paranaense
0 - 1
Atl. Mineiro 104
10 Nov 21  Finalizado Atl. Mineiro
3 - 0
Corinthians 171
07 Nov 21  Finalizado Atl. Mineiro
1 - 0
América Mineiro 56
04 Nov 21  Finalizado Atl. Mineiro
2 - 1
Grêmio 346
31 Oct 21  Finalizado Flamengo
1 - 0
Atl. Mineiro 243
24 Oct 21  Finalizado Atl. Mineiro
2 - 1
Cuiabá 52
17 Oct 21  Finalizado Atlético GO
2 - 1
Atl. Mineiro 199
14 Oct 21  Finalizado Atl. Mineiro
3 - 1
Santos FC 387
09 Oct 21  Finalizado Atl. Mineiro
3 - 1
Ceará 39
07 Oct 21  Finalizado Chapecoense
2 - 2
Atl. Mineiro 336
03 Oct 21  Finalizado Atl. Mineiro
1 - 0
Internacional 102
26 Sep 21  Finalizado São Paulo
0 - 0
Atl. Mineiro 112
19 Sep 21  Finalizado Atl. Mineiro
3 - 0
Sport Recife 84
12 Sep 21  Finalizado Fortaleza EC
0 - 2
Atl. Mineiro 99
30 Ago 21  Finalizado RB Bragantino
1 - 1
Atl. Mineiro 328
24 Ago 21  Finalizado Fluminense
1 - 1
Atl. Mineiro 410
15 Ago 21  Finalizado Atl. Mineiro
2 - 0
PalmeirasTarjeta Roja 84
08 Ago 21  Finalizado EC Juventude
1 - 2
Atl. Mineiro 54
01 Ago 21  Finalizado Tarjeta RojaAtl. Mineiro
2 - 0
Athletico Paranaense 80
25 Jul 21  Finalizado Atl. Mineiro
3 - 0
Bahía 139
18 Jul 21  Finalizado Corinthians
1 - 2
Atl. Mineiro 131
11 Jul 21  Finalizado América Mineiro
0 - 1
Atl. Mineiro 98
08 Jul 21  Finalizado Atl. Mineiro
2 - 1
Flamengo 126
04 Jul 21  Finalizado Cuiabá
0 - 1
Atl. Mineiro 82
02 Jul 21  Finalizado Atl. Mineiro
4 - 1
Atlético GO 134
28 Jun 21  Finalizado Santos FC
2 - 0
Atl. MineiroTarjeta Roja 45
25 Jun 21  Finalizado Ceará
2 - 1
Atl. Mineiro 285
22 Jun 21  Finalizado Atl. Mineiro
1 - 1
Chapecoense 98
17 Jun 21  Finalizado Internacional
0 - 1
Atl. Mineiro 92
13 Jun 21  Finalizado Atl. Mineiro
1 - 0
São Paulo 49
07 Jun 21  Finalizado Sport Recife
0 - 1
Atl. Mineiro 65
30 May 21  Finalizado Atl. Mineiro
1 - 2
Fortaleza EC 114
16 Dic 21  Finalizado Athletico Paranaense
1 - 2
Atl. Mineiro 509
12 Dic 21  Finalizado Atl. Mineiro
4 - 0
Athletico Paranaense 105
28 Oct 21  Finalizado Fortaleza EC
1 - 2
Atl. Mineiro 199
21 Oct 21  Finalizado Atl. Mineiro
4 - 0
Fortaleza EC 97
16 Sep 21  Finalizado Atl. Mineiro
1 - 0
Fluminense 231
27 Ago 21  Finalizado Fluminense
1 - 2
Atl. Mineiro 299
05 Ago 21  Finalizado Bahía
2 - 1
Atl. Mineiro 149
29 Jul 21  Finalizado Atl. Mineiro
2 - 0
Bahía 102
11 Jun 21  Finalizado Atl. Mineiro
2 - 1
Remo 42
03 Jun 21  Finalizado Remo
0 - 2
Atl. Mineiro 80
22 May 21  Finalizado Atl. Mineiro
0 - 0
América Mineiro 21
16 May 21  Finalizado América Mineiro
0 - 0
Atl. MineiroTarjeta Roja 0
08 May 21  Finalizado Atl. Mineiro
1 - 1
Tombense 2
01 May 21  Finalizado Tombense
0 - 3
Atl. MineiroTarjeta Roja 0
25 Abr 21  Finalizado Athletic Club
0 - 1
Atl. Mineiro 5
18 Abr 21  Finalizado Atl. Mineiro
2 - 1
Boa EC 4
11 Abr 21  Finalizado Tarjeta RojaCruzeiro
1 - 0
Atl. MineiroTarjeta Roja 6
07 Abr 21  Finalizado Atl. Mineiro
1 - 0
Pouso Alegre 5
04 Abr 21  Finalizado Atl. Mineiro
3 - 1
América Mineiro 2
01 Abr 21  Finalizado Caldense
2 - 1
Atl. Mineiro 13
19 Mar 21  Finalizado Atl. Mineiro
3 - 0
Coimbra Esporte Clube 2
13 Mar 21  Finalizado Tarjeta RojaPatrocinense
1 - 3
Atl. Mineiro 1
08 Mar 21  Finalizado Atl. Mineiro
4 - 0
Uberlândia 0
05 Mar 21  Finalizado Tombense
1 - 2
Atl. Mineiro 15
28 Feb 21  Finalizado Atl. Mineiro
3 - 0
URT 0

Plantilla del Atl. Mineiro Temporada 2020/2021

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
22 33 br 192 86 - - -
31 25 br 191 83 - - 1
32 34 br 192 86 - - -
Defensa
6 32 br 177 69 1 - 3
13 26 br 176 70 1 - 7
2 25 br 173 66 - - 2
16 28 br 190 78 - - 3
3 31 py 185 83 1 - 5
25 37 br 177 69 - - 5
45 23 br 183 82 - - -
40 26 br 183 79 3 - 7
4 39 br 192 84 - - 1
46 20 br 182 79 - - -
44 22 br 178 65 - - -
Centrocampista
21 25 ec 174 72 - - -
29 27 br 172 69 - 1 7
27 23 br 173 66 - - -
20 30 br 174 70 1 - 1
8 29 br 178 70 2 - 5
15 26 ar 171 64 7 - 4
26 34 ar 182 78 5 - 4
40 28 br 177 73 2 - 2
41 21 br 178 75 1 - 1
37 31 br 175 67 1 - 4
Delantero
30 22 co 179 72 2 - 2
19 35 es 186 86 4 - 2
18 32 br 173 65 2 - 3
10 34 cl 174 77 4 1 2
48 24 br 169 64 - - -
7 37 br 180 95 19 - 3
17 27 ve 168 60 5 - 1
11 34 br 174 69 5 - 2
33 19 br 176 66 - - -
Noticias del Atl. Mineiro
Ver últimas noticias

Corinthians perdona y el Atlético Mineiro es líder en solitario

El Corinthians empató hoy 1-1 con el Coritiba en la décimo quinta jornada de la liga y permitió al Atlético Mineiro convertirse en líder solitario del Campeonato Brasileño.

Atlético Mineiro sigue líder en Brasil

El argentino Lucas Pratto firmó hoy la victoria del Atlético Mineiro (1-0) frente al modesto Figueirense en la décimo quinta jornada de liga y el equipo de Belo Horizonte mantuvo así el liderato del Campeonato Brasileño.

El Atlético Mineiro es el nuevo líder en Brasil

El equipo blanquinegro aprovechó el tropiezo del Sport Recife y le alcanza en la cima de la tabla al ganar 1-3 al Internacional.

El Sport defiende el liderato e su invicto en la liga brasileña ante el Avaí

El Sport de Recife, único invicto del torneo, volverá a defender este domingo su liderato en la visita al Avaí de Florianópolis, en un partido correspondiente de la undécima jornada del Campeonato Brasileño de fútbol.

El Sao Paulo asume provisionalmente el liderato de la liga brasileña

El Sao Paulo venció hoy 0 a 1 al Chapecoense en la séptima jornada del Campeonato Brasileño y asumió provisionalmente el liderato, a la espera de lo que haga mañana el Atlético Paranaense.



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,941,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7283
Total Execution Time  0.7302
  CADENA URL  
/Atletico-Mineiro/2021
  GET DATOS  
$_GET['/Atletico-Mineiro/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (44)  
0.0350  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 = 'Atletico-Mineiro' AND l.year = 2021 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=3881 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=3881 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=3881 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=3881 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=3881 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109  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=3881 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=3881 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113  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 = 62029
0.0113  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 = 62809
0.0110  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 = 61677
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 = 60666
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 = 62407
0.0123  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 = '3881' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0121  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 = '3881' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 61712 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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 = 61677 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 = 62809 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 = 60666 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  (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 calendars2021 as c ON c.league_id = l.id WHERE (c.datateam1 = 3881 or c.datateam2 = 3881) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0121  (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 calendars2021 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 = 3881 or c.datateam2 = 3881) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0119  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2021 as c ON c.league_id = l.id INNER JOIN events2021 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 = 3881 or c.datateam2 = 3881) AND l.year = 2021)
0.0136  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=3881 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0112  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 (67706,67019,66515,66230,66173,62807,53476) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 66173 AND teamId = 3881
0.0121  SELECT count(id) as num_players from rel_players WHERE league_id = 67706 AND teamId = 3881
0.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 53476 AND teamId = 3881
0.0183  SELECT count(id) as num_players from rel_players WHERE league_id = 66515 AND teamId = 3881
0.0111  SELECT count(id) as num_players from rel_players WHERE league_id = 66230 AND teamId = 3881
0.0113  SELECT count(id) as num_players from rel_players WHERE league_id = 67019 AND teamId = 3881
0.0505  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 3881
0.0114  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` 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 = 61712 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0143  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 events2021 e ON e.player_id = p.id AND e.league_id = 61712 WHERE rp.league_id = 61712 AND rp.teamId = 3881 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.0137  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 events2021 e ON e.player_id = p.id AND e.league_id = 61712 WHERE rp.league_id = 61712 AND rp.teamId = 3881 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137  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 events2021 e ON e.player_id = p.id AND e.league_id = 61712 WHERE rp.league_id = 61712 AND rp.teamId = 3881 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0113  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 = 3881 AND rp.league_id = 61712 AND l.year= 2021 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=6432153 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=6432153
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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6432153 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.0115  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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6432153 and (e.action = 4 or e.action = 5) 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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6432153 and (e.action = 3 or e.action = 4) 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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6432153 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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6432153 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0106  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 61712 ORDER BY nameShow LIMIT 100