Información
  • Nombre del equipo Bahía
  • Nombre completo Esporte Clube Bahia
  • Nombre corto BAH
  • País Brasil
  • Ciudad Salvador, Bahia
  • Entrenador Rogério Ceni
  • URL del equipo en RF testing.resultados-futbol.com/Ec-Bahia
Otros Datos
  • Año de Fundación 1931
  • Patrocinador Canaã Alimentos
  • Patrocinador Secundario Promedica, Credcesta, Casa de Apostas
  • Marca de Ropa Esquadrão
Internet
Información sobre el estadio
  • Nombre del estadio Itaipava Arena Fonte Nova
  • Capacidad 56500
  • Dirección Avenida Octávio Mangabeira 41715-000 Salvador, Bahia
  • Teléfono +55 (75) 2102 9127
  • Fax +55 (71) 2203 1958
  • Año de construcción 2013
  • Tamaño 105x68
Itaipava Arena Fonte Nova
Histórico de participación
Liga Brasileña
Baiano 1
Copa Brasil
Copa do Nordeste Grupo 2
Serie B - Brasil
10 veces
Conmebol Sudamericana Grupo 2
8 veces
Copa Libertadores Grupo 0
4 veces
Copa Governador
4 veces
Serie C - Brasil Grupo 2
4 veces
Partidos Amistosos
3 veces
(2024, 2017, 2015)
Partidos del Bahía Ir al LIVESCORE
27 May 21  Finalizado Tarjeta RojaTarjeta RojaBahía
2 - 4
Montevideo City TorqueTarjeta Roja 127
19 May 21  Finalizado Independiente
1 - 0
Bahía 108
14 May 21  Finalizado Guabirá Santa Cruz
0 - 1
Bahía 161
05 May 21  Finalizado Bahía
2 - 2
Independiente 135
28 Abr 21  Finalizado Bahía
5 - 0
Guabirá Santa CruzTarjeta Roja 32
22 Abr 21  Finalizado Montevideo City Torque
1 - 1
Bahía 38
10 Dic 21  Finalizado Fortaleza EC
2 - 1
Bahía 100
05 Dic 21  Finalizado Tarjeta RojaBahía
2 - 0
FluminenseTarjeta Roja 105
02 Dic 21  Finalizado Bahía
2 - 3
Atl. Mineiro 568
29 Nov 21  Finalizado Atlético GO
2 - 1
BahíaTarjeta Roja 261
26 Nov 21  Finalizado Bahía
3 - 1
Grêmio 344
21 Nov 21  Finalizado Bahía
0 - 0
Cuiabá 140
19 Nov 21  Finalizado Sport Recife
1 - 0
Bahía 157
11 Nov 21  Finalizado Tarjeta RojaFlamengo
3 - 0
BahíaTarjeta RojaTarjeta Roja 122
07 Nov 21  Finalizado Bahía
1 - 0
São Paulo 42
31 Oct 21  Finalizado EC Juventude
0 - 0
Bahía 51
28 Oct 21  Finalizado Bahía
1 - 1
CearáTarjeta Roja 186
25 Oct 21  Finalizado Bahía
3 - 0
Chapecoense 43
17 Oct 21  Finalizado América Mineiro
0 - 0
Bahía 82
13 Oct 21  Finalizado Bahía
0 - 0
PalmeirasTarjeta Roja 194
10 Oct 21  Finalizado Athletico Paranaense
0 - 2
Bahía 140
06 Oct 21  Finalizado Corinthians
3 - 1
BahíaTarjeta Roja 209
26 Sep 21  Finalizado Internacional
2 - 0
Bahía 52
19 Sep 21  Finalizado Bahía
1 - 1
RB Bragantino 111
12 Sep 21  Finalizado Santos FC
0 - 0
Bahía 106
05 Sep 21  Finalizado Bahía
4 - 2
Fortaleza EC 135
31 Ago 21  Finalizado Fluminense
2 - 0
Bahía 209
22 Ago 21  Finalizado Grêmio
2 - 0
Bahía 65
15 Ago 21  Finalizado Bahía
1 - 2
Atlético GO 51
08 Ago 21  Finalizado Tarjeta RojaCuiabá
1 - 1
Bahía 48
01 Ago 21  Finalizado Bahía
0 - 1
Sport Recife 104
25 Jul 21  Finalizado Atl. Mineiro
3 - 0
Bahía 139
18 Jul 21  Finalizado Bahía
0 - 5
Flamengo 97
11 Jul 21  Finalizado São Paulo
1 - 0
Bahía 165
07 Jul 21  Finalizado Bahía
1 - 0
EC Juventude 206
04 Jul 21  Finalizado Chapecoense
0 - 2
Bahía 130
01 Jul 21  Finalizado Bahía
3 - 4
América Mineiro 292
28 Jun 21  Finalizado Palmeiras
3 - 2
Bahía 50
25 Jun 21  Finalizado Bahía
2 - 1
Athletico ParanaenseTarjeta RojaTarjeta Roja 167
20 Jun 21  Finalizado Bahía
0 - 0
Corinthians 60
17 Jun 21  Finalizado Ceará
1 - 2
Bahía 70
14 Jun 21  Finalizado Bahía
0 - 1
InternacionalTarjeta Roja 95
06 Jun 21  Finalizado RB Bragantino
3 - 3
Bahía 143
30 May 21  Finalizado Bahía
3 - 0
Santos FC 72
05 Ago 21  Finalizado Bahía
2 - 1
Atl. Mineiro 149
29 Jul 21  Finalizado Atl. Mineiro
2 - 0
Bahía 102
10 Jun 21  Finalizado Bahía
1 - 0
Vila Nova 70
01 Jun 21  Finalizado Vila Nova
0 - 1
Bahía 78
08 Abr 21  Finalizado Bahía
4 - 1
Manaus 10
10 Mar 21  Finalizado Campinense
1 - 7
Bahía 12
13 May 21  Finalizado Bahia de Feira
3 - 0
Bahía 1
09 May 21  Finalizado Bahía
1 - 0
Bahia de Feira 0
06 May 21  Finalizado Jacuipense
0 - 1
Bahía 2
18 Abr 21  Finalizado Bahía
1 - 0
Bahia de FeiraTarjeta Roja 2
04 Abr 21  Finalizado Bahía
2 - 1
Atlético AlagoinhasTarjeta Roja 0
21 Mar 21  Finalizado Fluminense de Feira
1 - 1
Bahía 0
17 Mar 21  Finalizado Bahía
0 - 0
Vitória 1
07 Mar 21  Finalizado Vitória da Conquista
0 - 0
Bahía 0
03 Mar 21  Finalizado Bahía
0 - 1
UNIRB 0
24 Feb 21  Finalizado Doce Mel
0 - 2
Bahía 3
21 Feb 21  Finalizado Bahía
1 - 2
SD Juazeirense 0
08 May 21  Finalizado Tarjeta RojaTarjeta RojaTarjeta RojaCeará
1 - 2
BahíaTarjeta RojaTarjeta Roja 0
01 May 21  Finalizado Tarjeta RojaBahía
0 - 1
CearáTarjeta Roja 1
25 Abr 21  Finalizado Fortaleza EC
0 - 0
Bahía 6
17 Abr 21  Finalizado Bahía
4 - 0
CRB 1
10 Abr 21  Finalizado Bahía
2 - 1
ABC 5
03 Abr 21  Finalizado Fortaleza EC
2 - 1
Bahía 0
28 Mar 21  Finalizado Bahía
5 - 0
AltosTarjeta Roja 0
24 Mar 21  Finalizado CSA
2 - 0
Bahía 15
20 Mar 21  Finalizado Bahía
4 - 0
Sport Recife 0
13 Mar 21  Finalizado Vitória
1 - 0
BahíaTarjeta Roja 0
06 Mar 21  Finalizado Bahía
1 - 1
Botafogo PB 2
28 Feb 21  Finalizado Salgueiro
2 - 3
Bahía 4

Plantilla del Bahía Temporada 2020/2021

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
21 35 br 188 81 - - 2
26 25 br 189 82 - - -
77 29 br 194 95 - - -
32 25 br 187 87 - - 2
Defensa
5 29 ar 193 78 - - 6
13 24 br 192 88 - - -
29 26 br 176 63 - 1 6
4 35 br 186 83 - - -
28 38 br 190 85 - - -
3 31 br 194 86 3 - 1
79 24 br 181 75 2 1 8
2 38 br 168 62 - - 4
11 32 py 168 74 - - -
42 26 br 177 69 - - 1
Centrocampista
8 28 br 173 65 1 - 6
17 30 ar 180 72 - - 1
35 25 br 178 75 - - 3
27 32 br 180 79 1 - 3
15 26 co 180 70 - - 1
19 32 ar 184 79 - - 6
34 24 br 181 73 - 1 4
50 26 br 184 66 - - -
45 24 br 180 75 1 - 7
16 23 br 178 - - - -
14 27 br 184 78 - - 1
10 36 br 180 73 4 - 2
22 26 br 184 81 - - 4
Delantero
9 34 br 178 70 15 - 7
23 38 co 181 72 6 - 2
88 32 br 182 74 - - -
49 21 br 188 85 - - -
37 27 br 180 70 1 - 1
18 25 br 168 64 3 - 2
57 23 br 177 75 - - 1
7 30 br 170 65 2 2 7
Noticias del Bahía
Ver últimas noticias

Moisés Roberto llega a Bahía en calidad de cedido

Moisés Roberto Barbosa jugará hasta final de temporada en el Bahía de Serie B Brasileña. El lateral llega procedente del Corinthians.

Tres goles en los últimos minutos dan el pase a Sport Recife

El Sport Recife avanzó hoy a los octavos de final de la Copa Sudamericana tras remontar la derrota sufrida en la ida ante el Bahía (1-0) con una contundente goleada en casa por 4-1 y tres anotaciones en los últimos minutos del partido.

El Sport Recife buscará remontar ante el Bahía

El Sport Recife intentará remontar en casa el resultado adverso cosechado contra el Bahía (1-0) en el encuentro de ida, disputado el pasado miércoles, de la segunda fase de la Copa Sudamericana.

Biancucchi da la victoria al Bahía frente al Sport Recife

Un gol del argentino Maxi Biancucchi le dio el triunfo hoy por 1-0 al Bahía frente al Sport Recife en el partido de ida de la segunda fase de la Copa Sudamericana.

El brasileño Bruno Paulista ficha por el Sporting tras naufragar el fichaje de Boateng

El Sporting de Lisboa escogió al joven medio brasileño Bruno Paulista como alternativa al frustrado fichaje del internacional ghanés Kevin-Prince Boateng, abortado el miércoles por un desacuerdo sobre el reparto de derechos de imagen.



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,944,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2722
Total Execution Time  0.2743
  CADENA URL  
/Ec-Bahia/2021
  GET DATOS  
$_GET['/Ec-Bahia/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0091  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 = 'Ec-Bahia' 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.0021  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=3910 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0035  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 = 61712
0.0032  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 = 62031
0.0029  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.0037  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 = 60881
0.0029  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 = 61339
0.0029  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 = 62140
0.0031  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 = 62539
0.0061  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 = '3910' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0056  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 = '3910' 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 = 62539 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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.0030  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.0022  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 = 62031 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  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 = 61339 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  (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 = 3910 or c.datateam2 = 3910) AND l.year = 2021 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0077  (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 = 3910 or c.datateam2 = 3910) AND l.year = 2021 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0067  (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 = 3910 or c.datateam2 = 3910) AND l.year = 2021)
0.0092  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=3910 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0027  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 (66515,66292,66241,66214,62031,61712) 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.0055  SELECT count(id) as num_players from rel_players WHERE league_id = 61712 AND teamId = 3910
0.0052  SELECT count(id) as num_players from rel_players WHERE league_id = 66292 AND teamId = 3910
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 62031 AND teamId = 3910
0.0067  SELECT count(id) as num_players from rel_players WHERE league_id = 66515 AND teamId = 3910
0.0051  SELECT count(id) as num_players from rel_players WHERE league_id = 66214 AND teamId = 3910
0.0047  SELECT count(id) as num_players from rel_players WHERE league_id = 66241 AND teamId = 3910
0.0038  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.0123  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 = 3910 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.0076  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 = 3910 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0047  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 = 3910 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 3910 AND rp.league_id = 61712 AND l.year= 2021 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0030  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=6432155 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=6432155
0.0037  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=6432155 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.0037  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=6432155 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0030  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=6432155 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0029   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=6432155 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
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 events2021 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6432155 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
0.0021  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