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 Palmeiras

Enviar Datos
Información
  • Nombre del equipo Palmeiras
  • Nombre completo Sociedade Esportiva Palmeiras
  • Nombre corto PAL
  • País Brasil
  • Ciudad São Paulo, São Paulo
  • Entrenador Abel Ferreira
  • URL del equipo en RF //m.resultados-futbol.com/Palmeiras
Otros Datos
  • Año de Fundación 1914
  • Patrocinador Crefisa
  • Patrocinador Secundario FAM
  • Marca de Ropa Puma
  • Socios 104000
Internet

Información sobre el estadio

  • Nombre del estadio Allianz Parque (Palestra Itália)
  • Capacidad 43713
  • Dirección Rua Turiaçu 1840, Perdizes 05005-000 São Paulo, São Paulo
  • Teléfono +55 (11) 3874 6500
  • Fax +55 (11) 3864 9267
  • Año de construcción 2014
  • Tamaño 105 x 68 metros
Allianz Parque (Palestra Itália)

Histórico de participación

Liga Brasileña
91 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2002, 2001, 2000, 2000, 1999, 1998, 1997, 1997, 1997, 1996, 1996, 1995, 1995, 1994, 1994, 1994, 1994, 1993, 1993, 1993, 1992, 1991, 1990, 1990, 1990, 1989, 1989, 1988, 1988, 1987, 1987, 1986, 1986, 1986, 1985, 1985, 1984, 1984, 1983, 1983, 1983, 1981, 1980, 1980, 1980, 1979, 1979, 1978, 1978, 1978, 1978, 1977, 1977, 1977, 1976, 1976, 1976, 1975, 1975, 1975, 1974, 1974, 1973, 1973, 1973, 1972, 1972, 1972, 1971, 1971, 1971)
Copa Libertadores Grupo 6
44 veces
(2024, 2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2013, 2013, 2009, 2009, 2006, 2006, 2005, 2005, 2001, 2001, 2000, 2000, 1999, 1999, 1995, 1995, 1994, 1994, 1979, 1974, 1973, 1973, 1971, 1971, 1968, 1968, 1968, 1961)
Paulista A1
40 veces
(2024, 2024, 2023, 2023, 2022, 2022, 2021, 2021, 2020, 2020, 2019, 2019, 2018, 2018, 2017, 2017, 2016, 2016, 2015, 2015, 2014, 2014, 2013, 2013, 2012, 2012, 2011, 2011, 2010, 2009, 2009, 2008, 2008, 2007, 2006, 2005, 2004, 2004, 2003, 2003)
Copa Brasil
29 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2008, 2007, 2004, 2003, 2002, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992)
Copa Mercosur Grupo 5
7 veces
(2001, 2000, 2000, 1999, 1999, 1998, 1998)
Trofeo Ramón de Carranza
6 veces
(1994, 1982, 1977, 1976, 1975, 1970)
Partidos Amistosos
5 veces
(2020, 2019, 2017, 2016, 2015)
Conmebol Sudamericana
5 veces
(2012, 2011, 2010, 2008, 2003)
Serie B - Brasil
4 veces
(2013, 2003, 2003, 2003)
Fase Previa Copa Libertadores
3 veces
(2009, 2006, 2005)
Supercopa de Brasil
3 veces
(2024, 2023, 2021)
Mundial de Clubes
2 veces
(2022, 2021)
Torneo Rio - Rio-São Paulo Grupo 0
2 veces
(2000, 2000)
Recopa Sudamericana
2 veces
(2022, 2021)
Trofeo Ciudad de Zaragoza
1 vez
(1972)
Copa Antel
1 vez
(2016)
Copa Intercontinental
1 vez
(2000)
Trofeo Naranja
1 vez
(1998)
Trofeo Santiago Bernabéu
1 vez
(1995)

Partidos del Palmeiras

Ir al LIVESCORE
Mundial de Clubes Mundial de Clubes »
12 Feb 22  Finalizado Chelsea
2 - 1
 PalmeirasTarjeta Roja 477
08 Feb 22  Finalizado Palmeiras
2 - 0
 Al-AhlyTarjeta Roja 330
Copa Libertadores Copa Libertadores »
07 Sep 22  Finalizado Tarjeta RojaPalmeiras
2 - 2
 Athletico Paranaense 818
31 Ago 22  Finalizado Tarjeta RojaAthletico Paranaense
1 - 0
 Palmeiras 799
11 Ago 22  Finalizado Tarjeta RojaTarjeta RojaPalmeiras
0 - 0
 Atl. MineiroTarjeta Roja 993
04 Ago 22  Finalizado Atl. Mineiro
2 - 2
 Palmeiras 903
07 Jul 22  Finalizado Palmeiras
5 - 0
 Cerro Porteño 510
30 Jun 22  Finalizado Cerro Porteño
0 - 3
 Palmeiras 813
25 May 22  Finalizado Palmeiras
4 - 1
 Deportivo Táchira 183
19 May 22  Finalizado Palmeiras
1 - 0
 CS Emelec 797
04 May 22  Finalizado Tarjeta RojaIndependiente Petrolero
0 - 5
 Palmeiras 497
28 Abr 22  Finalizado CS Emelec
1 - 3
 Palmeiras 89
13 Abr 22  Finalizado Palmeiras
8 - 1
 Independiente Petrolero 350
07 Abr 22  Finalizado Deportivo Táchira
0 - 4
 PalmeirasTarjeta Roja 97
Liga Brasileña Liga Brasileña »
13 Nov 22  Finalizado Internacional
3 - 0
 Palmeiras 184
10 Nov 22  Finalizado Palmeiras
2 - 1
 América Mineiro 378
06 Nov 22  Finalizado Cuiabá
1 - 1
 Palmeiras 382
03 Nov 22  Finalizado Palmeiras
4 - 0
 Fortaleza EC 332
26 Oct 22  Finalizado Tarjeta RojaAthletico Paranaense
1 - 3
 Palmeiras 460
23 Oct 22  Finalizado Palmeiras
3 - 0
 Avaí 247
16 Oct 22  Finalizado Palmeiras
0 - 0
 São PauloTarjeta RojaTarjeta Roja 513
10 Oct 22  Finalizado Atlético GO
1 - 1
 Palmeiras 1077
07 Oct 22  Finalizado Palmeiras
4 - 0
 Coritiba 87
04 Oct 22  Finalizado Botafogo
1 - 3
 PalmeirasTarjeta Roja 572
29 Sep 22  Finalizado Atl. Mineiro
0 - 1
 Palmeiras 437
18 Sep 22  Finalizado Tarjeta RojaPalmeiras
1 - 0
 Santos FC 248
11 Sep 22  Finalizado Palmeiras
2 - 1
 EC Juventude 262
04 Sep 22  Finalizado RB Bragantino
2 - 2
 Palmeiras 249
28 Ago 22  Finalizado Fluminense
1 - 1
 Palmeiras 264
21 Ago 22  Finalizado Palmeiras
1 - 1
 Flamengo 246
14 Ago 22  Finalizado Corinthians
0 - 1
 Palmeiras 267
07 Ago 22  Finalizado Palmeiras
3 - 0
 Goiás EC 149
30 Jul 22  Finalizado Tarjeta RojaCeará
1 - 2
 Palmeiras 236
24 Jul 22  Finalizado Palmeiras
2 - 1
 Internacional 355
22 Jul 22  Finalizado América Mineiro
0 - 1
 Palmeiras 535
19 Jul 22  Finalizado Palmeiras
1 - 0
 Cuiabá 651
10 Jul 22  Finalizado Fortaleza EC
0 - 0
 Palmeiras 511
03 Jul 22  Finalizado Tarjeta RojaPalmeiras
0 - 2
 Athletico Paranaense 452
26 Jun 22  Finalizado Avaí
2 - 2
 Palmeiras 567
21 Jun 22  Finalizado São Paulo
1 - 2
 Palmeiras 1567
16 Jun 22  Finalizado Palmeiras
4 - 2
 Atlético GOTarjeta Roja 594
12 Jun 22  Finalizado Tarjeta RojaCoritiba
0 - 2
 Palmeiras 122
10 Jun 22  Finalizado Palmeiras
4 - 0
 Botafogo 368
05 Jun 22  Finalizado Palmeiras
0 - 0
 Atl. Mineiro 279
29 May 22  Finalizado Santos FC
0 - 1
 Palmeiras 392
22 May 22  Finalizado EC Juventude
0 - 3
 Palmeiras 82
14 May 22  Finalizado Palmeiras
2 - 0
 RB Bragantino 217
08 May 22  Finalizado Palmeiras
1 - 1
 Fluminense 187
24 Abr 22  Finalizado Palmeiras
3 - 0
 Corinthians 87
21 Abr 22  Finalizado Flamengo
0 - 0
 Palmeiras 213
16 Abr 22  Finalizado Goiás EC
1 - 1
 Palmeiras 268
10 Abr 22  Finalizado Palmeiras
2 - 3
 CearáTarjeta Roja 449
Copa Brasil Copa Brasil »
15 Jul 22  Finalizado Palmeiras
2 - 1
 São Paulo 579
24 Jun 22  Finalizado São Paulo
1 - 0
 Palmeiras 1019
12 May 22  Finalizado SD Juazeirense
1 - 2
 Palmeiras 214
01 May 22  Finalizado Palmeiras
2 - 1
 SD Juazeirense 99
Paulista A1 Paulista A1 »
03 Abr 22  Finalizado Palmeiras
4 - 0
 São PauloTarjeta Roja 90
31 Mar 22  Finalizado São Paulo
3 - 1
 Palmeiras 180
26 Mar 22  Finalizado Palmeiras
2 - 1
 RB Bragantino 76
24 Mar 22  Finalizado Palmeiras
2 - 0
 Ituano 46
20 Mar 22  Finalizado RB Bragantino
1 - 1
 PalmeirasTarjeta Roja 32
18 Mar 22  Finalizado Palmeiras
2 - 1
 Corinthians 86
13 Mar 22  Finalizado Palmeiras
1 - 0
 Santos FCTarjeta Roja 31
11 Mar 22  Finalizado Tarjeta RojaSão Paulo
0 - 1
 Palmeiras 173
06 Mar 22  Finalizado Palmeiras
2 - 0
 GuaraníTarjeta Roja 28
27 Feb 22  Finalizado Inter de Limeira
0 - 0
 Palmeiras 28
19 Feb 22  Finalizado Palmeiras
1 - 0
 Santo André 18
16 Feb 22  Finalizado Ferroviária
0 - 2
 Palmeiras 16
01 Feb 22  Finalizado Palmeiras
1 - 0
 Água Santa 84
29 Ene 22  Finalizado São Bernardo FC
1 - 1
 Palmeiras 49
27 Ene 22  Finalizado Palmeiras
3 - 0
 Ponte Preta 29
23 Ene 22  Finalizado Tarjeta RojaNovorizontino
0 - 2
 Palmeiras 8

Plantilla del Palmeiras Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
31 21 br 190 87 - - -
42 37 br 189 80 - - -
1 30 br 195 84 - - -
21 36 br 189 89 - - -
Defensa
4 27 cl 186 74 - - -
15 30 py 185 85 9 - 9
32 22 br 175 68 - - 1
22 25 uy 184 81 - - 5
6 28 br 184 70 - - 1
13 30 br 186 79 - - 2
2 35 br 176 77 - - 4
12 31 br 178 68 3 - 2
26 27 br 188 84 5 - 7
45 21 br 182 78 - - -
36 21 br 183 74 1 - 1
Centrocampista
28 22 br 177 64 1 1 5
20 26 co 180 72 1 - 4
35 22 br 178 75 - - 1
25 23 br 176 75 1 1 3
14 30 br 177 65 7 - 3
30 28 br 187 75 - - -
40 21 br 178 73 - - -
23 28 br 176 73 3 - 1
8 30 br 175 71 3 1 12
Delantero
19 28 br 178 71 1 - 2
27 27 br 175 72 - - -
7 32 br 166 63 7 - 2
16 17 br 173 66 3 - 1
17 20 br 182 74 - - -
18 23 ar 190 74 2 - 3
9 28 uy 176 70 2 - -
29 24 br 183 80 - - -
10 28 br 167 65 12 - 3
11 25 br 175 65 1 - 2

Noticias del Palmeiras

Ver últimas noticias

El brasileño Bruno César, ex Corinthians y Palmeiras, ficha por el Estoril

BeSoccer - Viernes, 31 Julio 2015
0 329

El medio zurdo Bruno César, que jugó en el Corinthians y Palmeiras de Brasil, fichó por el Estoril luso, un pequeño club de la primera división, procedente del Al-Ahli saudí, informaron hoy los medios portugueses.

Lucas Barrios rechaza el rol de estrella

BeSoccer - Jueves, 16 Julio 2015
0 298

El internacional paraguayo Lucas Barrios fue presentado hoy por el Palmeiras y descartó llegar al club brasileño con el papel de estrella.

Lucas Barrios recala en el Palmeiras

Jaime Velasco - Martes, 14 Julio 2015
0 234

El futbolista paraguayo se ha convertido en nuevo refuerzo del conjunto brasileño procedente de Francia.

Jonathan Cristaldo protagoniza el pase del año estando en el suelo

Manuel Gutiérrez - Miércoles, 01 Julio 2015
0 312

Jonathan Cristaldo, delantero del Palmeiras, fue el protagonista de la acción. Cayó al suelo y, sin levantarse, conectó con su compañero Víctor Ramos de una forma espectacular.

El Palmeiras oficializa a Marcelo Oliveira como su nuevo técnico

BeSoccer - Lunes, 22 Junio 2015
0 90

El Palmeiras brasileño oficializó hoy la contratación de Marcelo Oliveira, campeón en las dos últimas temporadas con el Cruzeiro, como su nuevo técnico en sustitución de Oswaldo de Oliveira, separado por el bajo rendimiento del equipo en el inicio de la liga.

Ver más noticias del equipo»



  USO DE MEMORIA  
7,098,936 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7717
Total Execution Time  0.7736
  CADENA URL  
/palmeiras/2022
  GET DATOS  
$_GET['/palmeiras/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (46)  
0.0150  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 = 'palmeiras' 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.0125  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=11584 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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 = 67000
0.0132  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 = 67706
0.0132  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 = 66057
0.0130  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 = 66067
0.0132  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 = 67018
0.0142  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 = '11584' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 66173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 67706 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125  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 = 66058 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126  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 = 67018 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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 = 66057 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  (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 = 11584 or c.datateam2 = 11584) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0147  (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 = 11584 or c.datateam2 = 11584) AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0138  (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 = 11584 or c.datateam2 = 11584) AND l.year = 2022)
0.0156  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=11584 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (72456,71160,71069,70714,70597,66058,66057) 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.0143  SELECT count(id) as num_players from rel_players WHERE league_id = 70714 AND teamId = 11584
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 66058 AND teamId = 11584
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 72456 AND teamId = 11584
0.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 66057 AND teamId = 11584
0.0156  SELECT count(id) as num_players from rel_players WHERE league_id = 71069 AND teamId = 11584
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 70597 AND teamId = 11584
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 71160 AND teamId = 11584
0.0132  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 = 66173 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = 66173 WHERE rp.league_id = 66173 AND rp.teamId = 11584 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.0151  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 = 66173 WHERE rp.league_id = 66173 AND rp.teamId = 11584 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0142  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 = 66173 WHERE rp.league_id = 66173 AND rp.teamId = 11584 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 11584 AND rp.league_id = 66173 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0134  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=6496327 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6496327
0.0137  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=6496327 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.0134  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=6496327 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0133  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=6496327 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0133   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=6496327 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0135  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=6496327 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0130  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 = 66173 ORDER BY nameShow LIMIT 100