4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Gualaceo
TEMPORADA 2023/2024
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Independiente Juniors Independient 7 14 5 14
2 Chacaritas Chacaritas 8 9 9 14
3 Cuniburo Cuniburo 8 10 11 12
4 Manta Manta 8 7 7 11
5 San Antonio San Antonio 7 3 5 11
6 Vargas Torres Vargas 7 7 6 10
7 Guayaquil City Guayaquil 8 11 6 9
8 Gualaceo Gualaceo 8 7 12 9
9 Leones del Norte Leones Norte 8 8 11 8
10 9 de Octubre Octubre 7 4 8 7
TEMPORADA 2022/2023
SERIE A - SEGUNDA ETAPA
Equipo PJ GF GC Puntos
1 Liga de Quito Liga Quito 15 21 4 36
2 Barcelona SC Barcelona 15 24 15 32
3 Aucas Aucas 15 22 15 25
4 Delfín Delfín 15 19 12 24
5 CD El Nacional Nacional 15 25 19 23
6 CS Emelec CS Emelec 15 14 8 22
7 Universidad Católica Universidad 15 15 12 22
8 Independiente del Valle Independient 15 18 15 21
9 Técnico Universitario Técnico 15 20 17 19
10 Mushuc Runa Mushuc Runa 15 14 19 19
11 Orense Orense 15 15 15 16
12 Deportivo Cuenca Deportivo 15 12 16 16
13 Libertad FC Libertad FC 15 12 18 15
14 Guayaquil City Guayaquil 15 5 18 10
15 Cumbayá Cumbayá 15 14 26 9
16 Gualaceo Gualaceo 15 9 30 7
TEMPORADA 2021/2022
SERIE A - SEGUNDA ETAPA
Equipo PJ GF GC Puntos
1 Aucas Aucas 15 28 9 33
2 Independiente del Valle Independient 15 20 16 29
3 Universidad Católica Universidad 15 22 12 27
4 Liga de Quito Liga Quito 15 23 17 26
5 CS Emelec CS Emelec 15 22 15 25
6 Deportivo Cuenca Deportivo 15 18 16 22
7 Técnico Universitario Técnico 15 20 20 22
8 Barcelona SC Barcelona 15 24 19 21
9 Delfín Delfín 15 17 19 19
10 Orense Orense 15 16 17 18
11 Cumbayá Cumbayá 15 15 16 18
12 Guayaquil City Guayaquil 15 15 17 17
13 Gualaceo Gualaceo 15 10 23 14
14 Mushuc Runa Mushuc Runa 15 12 22 12
15 Macará Macará 15 17 28 11
16 9 de Octubre Octubre 15 12 25 10
TEMPORADA 2020/2021
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Cumbayá Cumbayá 36 47 36 67
2 Gualaceo Gualaceo 36 46 31 60
3 CD El Nacional Nacional 36 49 36 59
4 Chacaritas Chacaritas 36 35 34 49
5 América Quito América 36 41 33 47
6 Búhos ULVR Búhos ULVR 36 41 53 47
7 Independiente Juniors Independient 36 45 46 43
8 Atlético Santo Domingo Atlético 36 37 44 42
9 Atlético Porteño Atlético 36 46 64 39
10 LDU de Portoviejo Portoviejo 36 42 52 37
TEMPORADA 2019/2020
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 9 de Octubre Octubre 18 27 16 33
2 Manta Manta 18 26 18 32
3 América Quito América 18 20 14 28
4 Atlético Porteño Atlético 18 15 15 26
5 Chacaritas Chacaritas 18 23 26 23
6 Gualaceo Gualaceo 18 21 21 22
7 Independiente Juniors Independient 18 18 24 20
8 Atlético Santo Domingo Atlético 18 12 19 20
9 Fuerza Amarilla Fuerza 18 14 19 18
10 Santa Rita Santa Rita 18 19 23 16
TEMPORADA 2018/2019
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Orense Orense 36 57 26 68
2 Independiente Juniors Independient 36 48 29 66
3 LDU de Portoviejo Portoviejo 36 49 23 59
4 Manta Manta 36 48 31 59
5 Santa Rita Santa Rita 36 39 22 59
6 Gualaceo Gualaceo 36 35 27 50
7 Atlético Porteño Atlético 36 35 36 42
8 Atlético Santo Domingo Atlético 36 32 41 41
9 LDU Loja LDU Loja 36 32 63 28
10 Clan Juvenil Clan Juvenil 36 12 89 0
TEMPORADA 2017/2018
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Mushuc Runa Mushuc Runa 44 66 39 80
2 América Quito América 44 68 40 74
3 Fuerza Amarilla Fuerza 44 50 42 74
4 CD Olmedo CD Olmedo 44 60 47 72
5 LDU de Portoviejo Portoviejo 44 55 46 71
6 Atlético Santo Domingo Atlético 44 50 55 58
7 Manta Manta 44 54 53 56
8 Santa Rita Santa Rita 44 42 58 52
9 LDU Loja LDU Loja 44 32 45 48
10 Orense Orense 44 45 61 43
11 Gualaceo Gualaceo 44 36 55 41
12 Clan Juvenil Clan Juvenil 44 44 61 38
TEMPORADA 2016/2017
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Técnico Universitario Técnico 44 69 45 79
2 Aucas Aucas 44 67 50 78
3 Santa Rita Santa Rita 44 47 35 70
4 CD Olmedo CD Olmedo 44 53 47 70
5 Mushuc Runa Mushuc Runa 44 47 47 63
6 LDU de Portoviejo Portoviejo 44 45 45 63
7 Gualaceo Gualaceo 44 51 50 62
8 LDU Loja LDU Loja 44 53 51 56
9 América Quito América 44 42 50 52
10 Manta Manta 44 48 62 47
11 Imbabura Imbabura 44 40 55 47
12 Colón FC Colón FC 44 32 57 33
TEMPORADA 2015/2016
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Macará Macará 44 75 30 84
2 Clan Juvenil Clan Juvenil 44 63 37 73
3 Gualaceo Gualaceo 44 61 45 73
4 Técnico Universitario Técnico 44 64 56 71
5 Manta Manta 44 56 50 67
6 Imbabura Imbabura 44 65 52 62
7 LDU de Portoviejo Portoviejo 44 42 51 57
8 LDU Loja LDU Loja 44 55 74 49
9 CD Olmedo CD Olmedo 44 51 55 47
10 Colón FC Colón FC 43 35 43 44
11 Espoli Espoli 44 43 64 43
12 Dep. Quito Dep. Quito 43 41 94 1
TEMPORADA 2014/2015
SERIE B - ECUADOR
Equipo PJ GF GC Puntos
1 Delfín Delfín 44 50 33 74
2 Fuerza Amarilla Fuerza 44 60 42 73
3 CD Olmedo CD Olmedo 44 70 57 67
4 Manta Manta 44 60 40 66
5 Imbabura Imbabura 44 58 51 64
6 Técnico Universitario Técnico 44 64 59 63
7 Gualaceo Gualaceo 44 56 55 60
8 Macará Macará 44 63 62 55
9 Espoli Espoli 44 51 73 52
10 LDU de Portoviejo Portoviejo 44 49 58 50
11 Deportivo Quevedo Deportivo 44 40 67 46
12 Deportivo Azogues Deportivo 44 41 65 42

  USO DE MEMORIA  
5,622,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5248
Total Execution Time  0.5260
  CADENA URL  
/historico/Gualaceo
  GET DATOS  
$_GET['/historico/Gualaceo']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0161  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 = 'Gualaceo' 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.0131  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=62698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=62698 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0265  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 = 75086
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=62698 AND type_rel = 2
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 = '62698' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '62698' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0139  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 = 75086 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=62698 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (75086,70989,70963,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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 70963 AND teamId = 62698
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 70989 AND teamId = 62698
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 75086 AND teamId = 62698
0.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 62698
0.0128  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 75086 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0134  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 = 75086 WHERE rp.league_id = 75086 AND rp.teamId = 62698 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.0140  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 = 75086 WHERE rp.league_id = 75086 AND rp.teamId = 62698 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 75086 WHERE rp.league_id = 75086 AND rp.teamId = 62698 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 62698 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133  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 `tables2024` 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 = 75086 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 `tables2023` 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 = 70963 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142  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 `tables2023` 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 = 70989 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 `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 = 66293 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 `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 = 66294 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `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 = 61763 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2020` 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 = 53561 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2019` 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 = 48802 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2018` 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 = 42966 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2017` 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 = 37756 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2016` 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 = 20298 AND t.round = 44 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 75086 ORDER BY nameShow LIMIT 100