4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
29 Jul 23 MalacatecoMalacateco 2 - 0 XelajúXelajú 20
30 Jul 23 ComunicacionesComunicacio 1 - 1 XinabajulXinabajul 7
29 Jul 23 MunicipalMunicipal 0 - 1 GuastatoyaGuastatoya 6
30 Jul 23 ZacapaZacapa 1 - 0 MixcoMixco ...
13 Sep 23 CoatepequeCoatepeque 3 - 0 Cobán ImperialCobán 33
30 Jul 23 Antigua GFCAntigua 3 - 0 AchuapaAchuapa 3
Ver jornada
Jornada 2
07 Ago 23 XinabajulXinabajul 2 - 2 CoatepequeCoatepeque 3
06 Ago 23 XelajúXelajú 2 - 0 ComunicacionesComunicacio 7
05 Ago 23 Cobán ImperialCobán 1 - 3 MalacatecoMalacateco 2
06 Ago 23 MixcoMixco 0 - 1 Antigua GFCAntigua 2
06 Ago 23 AchuapaAchuapa 2 - 2 MunicipalMunicipal 2
06 Ago 23 GuastatoyaGuastatoya 0 - 1 ZacapaZacapa 5
Ver jornada
Jornada 3
13 Ago 23 MalacatecoMalacateco 1 - 0 CoatepequeCoatepeque 2
14 Ago 23 ComunicacionesComunicacio 2 - 0 Cobán ImperialCobán 18
12 Ago 23 MunicipalMunicipal 0 - 1 Antigua GFCAntigua 19
13 Ago 23 XelajúXelajú 1 - 1 XinabajulXinabajul 12
12 Ago 23 ZacapaZacapa 2 - 3 AchuapaAchuapa 23
13 Ago 23 GuastatoyaGuastatoya 2 - 1 MixcoMixco 3
Ver jornada
Jornada 4
20 Ago 23 MalacatecoMalacateco 3 - 1 XinabajulXinabajul 3
19 Ago 23 MunicipalMunicipal 3 - 1 MixcoMixco 1
19 Ago 23 Cobán ImperialCobán 1 - 0 XelajúXelajú 9
19 Ago 23 CoatepequeCoatepeque 1 - 1 ComunicacionesComunicacio 13
20 Ago 23 AchuapaAchuapa 1 - 3 GuastatoyaGuastatoya 9
20 Ago 23 Antigua GFCAntigua 1 - 0 ZacapaZacapa 5
Ver jornada
Jornada 5
26 Ago 23 XinabajulXinabajul 3 - 3 Cobán ImperialCobán 8
27 Ago 23 ComunicacionesComunicacio 1 - 1 MalacatecoMalacateco 9
26 Ago 23 XelajúXelajú 1 - 1 CoatepequeCoatepeque 36
27 Ago 23 ZacapaZacapa 0 - 1 MunicipalMunicipal 18
27 Ago 23 MixcoMixco 2 - 0 AchuapaAchuapa ...
27 Ago 23 GuastatoyaGuastatoya 2 - 2 Antigua GFCAntigua 5
Ver jornada
Jornada 6
14 Sep 23 XinabajulXinabajul 2 - 2 ComunicacionesComunicacio 28
04 Sep 23 XelajúXelajú 1 - 0 MalacatecoMalacateco 22
03 Sep 23 Cobán ImperialCobán 2 - 1 CoatepequeCoatepeque 6
03 Sep 23 MixcoMixco 1 - 0 ZacapaZacapa 3
20 Sep 23 AchuapaAchuapa 3 - 2 Antigua GFCAntigua 4
21 Sep 23 GuastatoyaGuastatoya 3 - 1 MunicipalMunicipal 31
Ver jornada
Jornada 7
10 Sep 23 MalacatecoMalacateco 0 - 0 Cobán ImperialCobán 1
21 Sep 23 ComunicacionesComunicacio 2 - 1 XelajúXelajú 26
27 Sep 23 MunicipalMunicipal 2 - 2 AchuapaAchuapa 37
10 Sep 23 ZacapaZacapa 2 - 1 GuastatoyaGuastatoya 4
10 Sep 23 CoatepequeCoatepeque 4 - 1 XinabajulXinabajul 1
05 Oct 23 Antigua GFCAntigua 2 - 2 MixcoMixco 61
Ver jornada
Jornada 8
18 Sep 23 XinabajulXinabajul 2 - 0 XelajúXelajú 6
17 Sep 23 Cobán ImperialCobán 2 - 1 ComunicacionesComunicacio 6
17 Sep 23 MixcoMixco 1 - 0 GuastatoyaGuastatoya 6
17 Sep 23 CoatepequeCoatepeque 0 - 2 MalacatecoMalacateco 3
17 Sep 23 AchuapaAchuapa 3 - 1 ZacapaZacapa 1
17 Sep 23 Antigua GFCAntigua 0 - 2 MunicipalMunicipal 4
Ver jornada
Jornada 9
25 Sep 23 XinabajulXinabajul 2 - 1 MalacatecoMalacateco 10
24 Sep 23 ComunicacionesComunicacio 5 - 0 CoatepequeCoatepeque 1
25 Sep 23 XelajúXelajú 1 - 0 Cobán ImperialCobán 22
27 Sep 23 ZacapaZacapa 3 - 1 Antigua GFCAntigua 19
24 Sep 23 MixcoMixco 0 - 3 MunicipalMunicipal 5
24 Sep 23 GuastatoyaGuastatoya 1 - 2 AchuapaAchuapa 6
Ver jornada
Jornada 10
01 Oct 23 MalacatecoMalacateco 2 - 3 ComunicacionesComunicacio 11
30 Sep 23 MunicipalMunicipal 4 - 2 ZacapaZacapa 13
01 Oct 23 Cobán ImperialCobán 2 - 0 XinabajulXinabajul ...
01 Oct 23 CoatepequeCoatepeque 0 - 0 XelajúXelajú 1
01 Oct 23 AchuapaAchuapa 2 - 0 MixcoMixco ...
01 Oct 23 Antigua GFCAntigua 1 - 0 GuastatoyaGuastatoya 5
Ver jornada
Jornada 11
05 Oct 23 MalacatecoMalacateco 1 - 1 MunicipalMunicipal 12
13 Nov 23 XinabajulXinabajul 0 - 0 MixcoMixco 3
15 Nov 23 ComunicacionesComunicacio 2 - 2 ZacapaZacapa 126
08 Oct 23 XelajúXelajú 2 - 1 GuastatoyaGuastatoya 7
19 Nov 23 Cobán ImperialCobán 1 - 1 AchuapaAchuapa 26
19 Nov 23 CoatepequeCoatepeque 0 - 0 Antigua GFCAntigua 12
Ver jornada
Jornada 12
18 Nov 23 MunicipalMunicipal 0 - 2 ComunicacionesComunicacio 49
01 Nov 23 ZacapaZacapa 3 - 1 Cobán ImperialCobán 6
01 Nov 23 MixcoMixco 3 - 0 CoatepequeCoatepeque 6
12 Nov 23 AchuapaAchuapa 1 - 0 XelajúXelajú 8
02 Nov 23 Antigua GFCAntigua 4 - 2 MalacatecoMalacateco 19
19 Nov 23 GuastatoyaGuastatoya 0 - 0 XinabajulXinabajul 29
Ver jornada
Jornada 13
19 Nov 23 MalacatecoMalacateco 3 - 0 MixcoMixco 4
03 Nov 23 XinabajulXinabajul 1 - 2 AchuapaAchuapa 33
21 Oct 23 ComunicacionesComunicacio 2 - 1 Antigua GFCAntigua 16
19 Nov 23 XelajúXelajú 1 - 0 ZacapaZacapa 36
21 Oct 23 Cobán ImperialCobán 2 - 2 MunicipalMunicipal 3
22 Oct 23 CoatepequeCoatepeque 0 - 1 GuastatoyaGuastatoya 3
Ver jornada
Jornada 14
28 Oct 23 MunicipalMunicipal 1 - 0 XelajúXelajú 4
29 Oct 23 ZacapaZacapa 0 - 1 XinabajulXinabajul ...
29 Oct 23 MixcoMixco 2 - 1 ComunicacionesComunicacio 20
29 Oct 23 AchuapaAchuapa 1 - 0 CoatepequeCoatepeque 1
28 Oct 23 Antigua GFCAntigua 2 - 2 Cobán ImperialCobán 12
29 Oct 23 GuastatoyaGuastatoya 4 - 0 MalacatecoMalacateco 4
Ver jornada
Jornada 15
06 Nov 23 MalacatecoMalacateco 3 - 2 AchuapaAchuapa 6
06 Nov 23 XinabajulXinabajul 0 - 2 MunicipalMunicipal 18
05 Nov 23 ComunicacionesComunicacio 2 - 1 GuastatoyaGuastatoya 3
05 Nov 23 XelajúXelajú 0 - 1 Antigua GFCAntigua 27
06 Nov 23 Cobán ImperialCobán 2 - 2 MixcoMixco 2
05 Nov 23 CoatepequeCoatepeque 0 - 1 ZacapaZacapa 2
Ver jornada
Jornada 16
26 Nov 23 MunicipalMunicipal 3 - 0 CoatepequeCoatepeque ...
26 Nov 23 ZacapaZacapa 4 - 0 MalacatecoMalacateco 3
26 Nov 23 MixcoMixco 0 - 0 XelajúXelajú 1
26 Nov 23 AchuapaAchuapa 2 - 0 ComunicacionesComunicacio 11
26 Nov 23 Antigua GFCAntigua 2 - 1 XinabajulXinabajul 3
26 Nov 23 GuastatoyaGuastatoya 1 - 0 Cobán ImperialCobán ...

Clasificación

Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 16 27 20 26
2 Malacateco Malacateco 16 24 24 24
3 Xelajú Xelajú 16 10 13 19
4 Cobán Imperial Cobán 16 19 25 18
5 Xinabajul Xinabajul 16 18 25 16
6 Coatepeque Coatepeque 16 12 24 11
7 Achuapa Achuapa 16 27 23 30
8 Municipal Municipal 16 27 17 28
9 Antigua GFC Antigua GFC 16 24 19 28
10 Guastatoya Guastatoya 16 21 16 23
11 Zacapa Zacapa 16 22 20 22
12 Mixco Mixco 16 15 20 19

  USO DE MEMORIA  
5,514,464 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1313
Total Execution Time  0.1333
  CADENA URL  
/apertura_guatemala2024/grupo1/calendario
  GET DATOS  
$_GET['/apertura_guatemala2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0020  SELECT type FROM routes WHERE alias = 'apertura_guatemala2024'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_guatemala' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=148 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 148 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  SELECT /*53 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 (1213613,1212290,1211427,1207700,1206232) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72135 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 72135 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 16:43:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 16:43:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 16:43:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 16:43:53' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0109  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72135 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72135 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0175  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72135 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72135 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0034  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 72135 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72135 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0029  SELECT *,(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