4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Itabuna
TEMPORADA 2023/2024
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 Manauara Manauara 2 4 1 6
2 Porto Velho Porto Velho 2 3 1 6
3 Princesa Solimões Princesa 2 2 0 4
4 Manaus Manaus 2 1 0 4
5 Trem DC Trem DC 2 1 2 1
6 Rio Branco Acre Branco Acre 2 1 3 1
7 Humaitá Humaitá 2 0 2 0
8 São Raimundo RR São 2 0 3 0
9 Maranhão Maranhão 2 3 1 6
10 Moto Club MA Moto Club 2 4 3 4
11 Tocantinópolis Tocantinópo 2 3 2 4
12 Altos Altos 2 2 2 3
13 Ríver Ríver 2 2 2 3
14 Aguia de Maraba Aguia Maraba 2 2 3 1
15 Fluminense PI Fluminense 2 2 3 1
16 Cametá Cametá 2 0 2 0
17 Treze Treze 2 6 3 6
18 América RN América RN 2 4 1 4
19 Iguatu Iguatu 2 2 0 4
20 Maracanã Maracanã 2 3 2 4
21 Potiguar Mossoró Potiguar 2 3 3 3
22 Sousa Sousa 2 0 2 1
23 Santa Cruz RN Santa Cruz 2 3 6 0
24 Atlético Cearense Atlético 2 1 5 0
25 ASA Arapiraquense Arapiraquens 2 4 2 6
26 Itabaiana Itabaiana 2 4 2 4
27 Retro FC Retro FC 2 1 0 4
28 Jacuipense Jacuipense 2 1 1 2
29 Sergipe Sergipe 2 3 4 1
30 SD Juazeirense Juazeirense 2 1 2 1
31 Petrolina Petrolina 2 0 1 1
32 CSE CSE 2 1 3 1
33 Iporá Iporá 2 4 2 4
34 Capital Capital 2 2 0 4
35 CRAC CRAC 2 2 1 4
36 Brasiliense Brasiliense 2 1 1 3
37 Mixto Mixto 2 2 2 2
38 União Rondonópolis União 2 2 2 2
39 Anápolis Anápolis 2 1 2 1
40 Real Brasília Real 2 0 4 0
41 Nova Iguaçu Nova Iguaçu 2 5 1 4
42 Itabuna Itabuna 2 3 2 4
43 Democrata SL Democrata 2 2 1 4
44 Serra FC Serra FC 2 1 4 3
45 Portuguesa RJ Portuguesa 2 1 1 2
46 Real Noroeste Real 2 1 1 2
47 Ipatinga FC Ipatinga FC 2 2 3 1
48 Audax Rio Audax Rio 2 0 2 0
49 Inter de Limeira Inter 2 4 0 6
50 Água Santa Água Santa 2 4 1 6
51 Pouso Alegre Pouso Alegre 2 3 1 3
52 Maringá Maringá 2 3 3 3
53 Santo André Santo André 2 1 2 1
54 Patrocinense Patrocinense 2 0 2 1
55 Costa Rica Costa Rica 2 0 3 1
56 São José São José 2 0 3 1
57 Cianorte Cianorte 2 2 1 4
58 Concórdia Concórdia 1 2 0 3
59 Cascavel FC Cascavel FC 2 3 3 3
60 Barra FC Barra FC 1 1 1 1
61 Novo Hamburgo Novo 1 1 1 1
62 Hercílio Luz Hercílio 1 0 0 1
63 EC Avenida EC Avenida 1 1 2 0
64 Brasil de Pelotas Brasil 1 0 2 0
TEMPORADA 2007/2008
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 4 13 7 9
2 Luverdense Luverdense 4 11 8 9
3 Fast Clube Fast Clube 4 2 11 0
4 Holanda EC Holanda EC 6 11 8 12
5 Remo Remo 6 12 5 11
6 Cristal CA Cristal CA 6 5 5 8
7 Progresso Progresso 6 3 13 3
8 Aguia de Maraba Aguia Maraba 6 13 10 10
9 Paysandu Paysandu 6 7 5 9
10 Bacabal Bacabal 6 8 7 8
11 Palmas FR Palmas FR 6 6 12 6
12 Sampaio Correa Sampaio 6 8 2 12
13 Picos SE Picos SE 6 3 1 10
14 Barras Barras 6 2 6 5
15 Horizonte Horizonte 6 5 9 4
16 Campinense Campinense 6 11 6 11
17 Santa Cruz Santa Cruz 6 7 6 8
18 Potiguar Mossoró Potiguar 6 9 10 7
19 Central SC Central SC 6 1 6 6
20 Salgueiro Salgueiro 6 10 5 12
21 Icasa Icasa 6 7 4 11
22 Santa Cruz RN Santa Cruz 6 5 8 7
23 Treze Treze 6 3 8 2
24 ASA Arapiraquense Arapiraquens 6 14 6 13
25 Confiança Confiança 6 12 10 12
26 Atlético Alagoinhas Atlético 6 6 8 7
27 Petrolina Petrolina 6 6 14 3
28 Vitória da Conquista Vitória 6 12 7 13
29 Sergipe Sergipe 6 9 9 10
30 Itabuna Itabuna 6 8 7 9
31 CSA CSA 6 4 10 3
32 Atlético GO Atlético 6 15 5 14
33 Mixto Mixto 6 11 8 9
34 Operário MS Operário 6 3 5 7
35 Águia Negra Águia Negra 6 4 15 1
36 Real Brasília Real 6 8 8 9
37 Itumbiara Itumbiara 6 6 4 8
38 Anápolis Anápolis 6 7 11 8
39 Legião Legião 6 12 10 7
40 América Mineiro América 6 7 3 11
41 Duque de Caxias Duque Caxias 6 8 8 8
42 Paulista Paulista 6 6 6 8
43 Serra FC Serra FC 6 7 11 6
44 Guaratinguetá Guaratinguet 6 7 3 13
45 Boavista SC Boavista SC 6 13 4 10
46 Macaé Esporte Macaé 6 6 4 9
47 Linhares Linhares 6 3 18 1
48 Boa EC Boa EC 6 11 4 14
49 Noroeste Noroeste 6 9 9 8
50 Tupi Tupi 6 6 9 7
51 Mirassol Mirassol 6 7 11 4
52 Ituano Ituano 6 10 8 10
53 Guaraní Guaraní 6 5 4 10
54 Madureira RJ Madureira 6 8 9 7
55 Linense CA Linense CA 6 5 7 7
56 Toledo EC Toledo EC 6 8 6 9
57 Marcílio Dias Marcílio 6 6 4 9
58 Inter Santa Maria Inter Santa 6 7 5 8
59 Engenheiro Beltrão Engenheiro 6 3 9 6
60 Brasil de Pelotas Brasil 6 4 4 11
61 Caxias do Sul Caxias 6 8 4 8
62 J. Malucelli Malucelli 6 4 4 7
63 Metropolitano Metropolitan 6 4 8 4
TEMPORADA 1978/1979
LIGA BRASILEÑA GRUPO 3
Equipo PJ GF GC Puntos
1 Gama Gama 9 14 9 17
2 Mixto Mixto 9 14 10 16
3 Comercial MS Comercial 8 14 10 14
4 Operário MT Operário 9 12 11 14
5 Atlético GO Atlético 9 17 14 13
6 Itumbiara Itumbiara 9 11 11 13
7 Itabuna Itabuna 9 10 8 12
8 Fluminense de Feira Fluminense 9 5 6 12
9 Brasília Brasília 9 11 17 10
10 Guará Guará 8 2 14 2
TEMPORADA 1977/1978
LIGA BRASILEÑA GRUPO 14
Equipo PJ GF GC Puntos
1 Volta Redonda Volta 5 8 4 12
2 CRB CRB 5 5 2 10
3 CSA CSA 5 8 6 8
4 Itabuna Itabuna 5 6 3 7
5 Confiança Confiança 5 5 9 6
6 Sergipe Sergipe 5 2 10 0

  USO DE MEMORIA  
6,567,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0016
Controller Execution Time ( Home / Category )  0.5417
Total Execution Time  0.5433
  CADENA URL  
/historico/Itabuna-Esporte-Clube
  GET DATOS  
$_GET['/historico/Itabuna-Esporte-Clube']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0155  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 = 'Itabuna-Esporte-Clube' 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.0145  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=62883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=62883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=62883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=62883 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0326  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 = 74833
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62883 AND type_rel = 2
0.0154  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 = '62883' ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '62883' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0147  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 = '62883' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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=62883 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (75630,75215,74833,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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 75630 AND teamId = 62883
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 75215 AND teamId = 62883
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 74833 AND teamId = 62883
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 62883
0.0146  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 = '62883' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '62883' and rp.type = 4
0.0148  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 = '62883' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 62883 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.0170  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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 62883 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0169  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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 62883 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 62883 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2008` 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 = 12980 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1979` 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 = 25699 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 25730 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 25786 AND t.round = 5 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC