4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Malacateco

Malacateco

Entrenador: Gabriel Pereyra

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA GUATEMALA - CLAUSURA
Equipo PJ GF GC Puntos
1 Municipal Municipal 16 29 14 32
2 Antigua GFC Antigua GFC 16 25 12 32
3 Mixco Mixco 16 18 10 27
4 Cobán Imperial Cobán 16 29 22 27
5 Comunicaciones Comunicacion 16 16 17 23
6 Achuapa Achuapa 16 17 20 22
7 Xinabajul Xinabajul 16 19 19 21
8 Malacateco Malacateco 16 21 26 21
9 Xelajú Xelajú 16 14 15 20
10 Guastatoya Guastatoya 16 21 23 18
11 Zacapa Zacapa 16 12 25 11
12 Coatepeque Coatepeque 16 13 31 11
TEMPORADA 2022/2023
LIGA GUATEMALA - CLAUSURA
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 22 37 16 45
2 Municipal Municipal 22 44 21 43
3 Xelajú Xelajú 22 29 9 43
4 Xinabajul Xinabajul 22 27 29 31
5 Guastatoya Guastatoya 22 28 22 29
6 Mixco Mixco 22 23 22 29
7 Antigua GFC Antigua GFC 22 33 37 29
8 Achuapa Achuapa 22 24 44 26
9 Cobán Imperial Cobán 22 16 17 25
10 Iztapa Iztapa 22 30 49 20
11 Malacateco Malacateco 22 24 33 19
12 Cotzumalguapa Cotzumalguap 22 14 30 19
TEMPORADA 2021/2022
LIGA GUATEMALA - CLAUSURA
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 22 39 24 41
2 Municipal Municipal 22 34 18 40
3 Guastatoya Guastatoya 22 32 18 37
4 Malacateco Malacateco 22 29 22 35
5 Cobán Imperial Cobán 22 29 25 34
6 Antigua GFC Antigua GFC 22 33 22 33
7 Achuapa Achuapa 22 21 19 33
8 Cotzumalguapa Cotzumalguap 22 36 27 28
9 Iztapa Iztapa 22 30 31 28
10 Xelajú Xelajú 22 17 31 23
11 Sololá Sololá 22 21 44 18
12 Nueva Concepción Nueva 22 19 59 12
TEMPORADA 2020/2021
LIGA GUATEMALA - CLAUSURA GRUPO 1
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 16 28 12 34
2 Cotzumalguapa Cotzumalguap 16 13 13 24
3 Iztapa Iztapa 16 29 25 22
4 Xelajú Xelajú 16 14 15 17
5 Malacateco Malacateco 16 8 14 16
6 Antigua GFC Antigua GFC 16 15 26 13
7 Guastatoya Guastatoya 16 23 10 28
8 Municipal Municipal 16 24 11 27
9 Cobán Imperial Cobán 16 20 17 23
10 Deportivo Sanarate Deportivo 16 16 25 18
11 Sacachispas Sacachispas 16 15 26 18
12 Achuapa Achuapa 16 16 27 14
TEMPORADA 2019/2020
LIGA GUATEMALA - CLAUSURA
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 13 26 15 28
2 Municipal Municipal 13 17 12 23
3 Guastatoya Guastatoya 13 13 10 21
4 Iztapa Iztapa 13 19 18 20
5 Antigua GFC Antigua GFC 13 15 11 19
6 Siquinalá Siquinalá 13 17 17 16
7 Mixco Mixco 13 14 14 15
8 Cotzumalguapa Cotzumalguap 13 13 18 15
9 Xelajú Xelajú 13 12 15 13
10 Malacateco Malacateco 13 9 14 13
11 Deportivo Sanarate Deportivo 13 13 17 12
12 Cobán Imperial Cobán 13 8 15 10
TEMPORADA 2018/2019
LIGA GUATEMALA - CLAUSURA
Equipo PJ GF GC Puntos
1 Antigua GFC Antigua GFC 22 36 20 41
2 Cobán Imperial Cobán 22 35 25 40
3 Comunicaciones Comunicacion 22 32 14 39
4 Municipal Municipal 22 37 22 36
5 Malacateco Malacateco 22 24 20 36
6 Guastatoya Guastatoya 22 27 16 35
7 Dep. Chiantla Dep. 22 21 25 30
8 Xelajú Xelajú 22 27 25 29
9 Siquinalá Siquinalá 22 23 25 26
10 Iztapa Iztapa 22 21 28 25
11 Deportivo Sanarate Deportivo 22 22 38 23
12 Deportivo Petapa Deportivo 22 12 59 7
TEMPORADA 2017/2018
LIGA GUATEMALA - CLAUSURA
Equipo PJ GF GC Puntos
1 Deportivo Sanarate Deportivo 22 29 14 40
2 Cobán Imperial Cobán 22 32 21 39
3 Guastatoya Guastatoya 22 27 18 38
4 Antigua GFC Antigua GFC 22 42 34 37
5 Xelajú Xelajú 22 31 31 31
6 Siquinalá Siquinalá 22 20 22 31
7 Comunicaciones Comunicacion 22 22 26 29
8 Deportivo Petapa Deportivo 22 27 33 29
9 Municipal Municipal 22 34 28 28
10 Suchitepequez Suchitepeque 22 29 36 25
11 Malacateco Malacateco 22 25 32 25
12 Marquense Marquense 22 16 39 17
TEMPORADA 2016/2017
LIGA GUATEMALA - CLAUSURA GRUPO 1
Equipo PJ GF GC Puntos
1 Municipal Municipal 22 19 10 36
2 Deportivo Petapa Deportivo 22 27 24 34
3 Guastatoya Guastatoya 22 22 16 32
4 Comunicaciones Comunicacion 22 21 16 30
5 Suchitepequez Suchitepeque 22 24 28 30
6 Xelajú Xelajú 22 30 25 29
7 Cobán Imperial Cobán 22 17 15 29
8 Marquense Marquense 22 19 16 28
9 Malacateco Malacateco 22 17 20 28
10 Mictlán Mictlán 22 14 25 28
11 Antigua GFC Antigua GFC 22 28 30 27
12 Carchá Carchá 22 11 24 20
TEMPORADA 2015/2016
LIGA GUATEMALA - CLAUSURA GRUPO 2
Equipo PJ GF GC Puntos
1 Malacateco Malacateco 2 6 3 6
2 Heredia Heredia 2 3 6 0
TEMPORADA 2014/2015
LIGA GUATEMALA - APERTURA
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 22 34 15 43
2 Marquense Marquense 22 30 19 42
3 Municipal Municipal 22 37 19 39
4 Suchitepequez Suchitepeque 22 28 28 31
5 Deportivo Petapa Deportivo 22 35 32 30
6 Antigua GFC Antigua GFC 22 24 21 30
7 Xelajú Xelajú 22 29 29 30
8 Universidad San Carlos Universidad 22 25 28 26
9 Malacateco Malacateco 22 21 24 26
10 Guastatoya Guastatoya 22 20 31 25
11 Halcones Halcones 22 24 42 23
12 Coatepeque Coatepeque 22 15 34 17

  USO DE MEMORIA  
5,725,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1773
Total Execution Time  0.1792
  CADENA URL  
/historico/Malacateco
  GET DATOS  
$_GET['/historico/Malacateco']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0037  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 = 'Malacateco' 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.0018  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=5163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=5163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=5163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=5163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=5163 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 75891
0.0025  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 = 72135
0.0025  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 = 74696
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5163 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5163 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (5674,8033,13075,40674,62552) ORDER BY n.cover_points DESC, update_date DESC
0.0040  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 = '5163' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74696 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 75891 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0041  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 = 5163 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031  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 = 72135 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 75018 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 67999 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 70794 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 63155 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 66256 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 56993 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 61255 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 50153 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 51089 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 43975 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 48502 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 38782 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 41916 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 33330 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 37605 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 15499 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 20115 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 31225 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0547  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 `tables2015` 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 = 3893 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC