4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
Primera Guatemala - Apertura
2023/2024

Primera Guatemala - Apertura

  • Iztapa
  • Marquense
  • Democracia FC.
  • Sololá
  • Juventud Copalera
  • Suchitepequez
  • Nueva Concepción
  • Quiché
  • CD San Pedro
  • Cotzumalguapa
  • Universidad San Carlos
  • Juventud Pinulteca
  • San Benito CF
  • Sacachispas
  • Deportivo Barberena
  • Aurora FC
  • Deportivo Fraijanes
  • Mictlán
  • Heredia
  • Cuilapa FC

Primera Guatemala - Apertura

La temporada finalizó el Miércoles, 08 Noviembre 2023.
Resultados
« Jornada Anterior
Jornada 3
Jornada Siguiente »
 
13 Ago 23
04:00 Finalizado 		Marquense Marquense 1-0 CD San Pedro CD San Pedro más información ...
 
13 Ago 23
17:00 Finalizado 		Sololá Sololá 1-1 Nueva Concepción Nueva Concepción más información ...
 
13 Ago 23
19:00 Finalizado 		Suchitepequez Suchitepequez 1-0 Cotzumalguapa Cotzumalguapa más información ...
 
13 Ago 23
19:00 Finalizado 		Iztapa Iztapa 0-0 Quiché Quiché más información ...
 
13 Ago 23
19:00 Finalizado 		Cuilapa FC Cuilapa FC 0-1 Aurora FC Aurora FC más información ...
 
13 Ago 23
19:00 Finalizado 		Universidad San Carlos Universidad San Carlos 3-1 Deportivo Fraijanes Deportivo Fraijanes más información ...
 
13 Ago 23
19:20 Finalizado 		Juventud Copalera Juventud Copalera 1-1 Democracia FC. Democracia FC. más información ...
 
13 Ago 23
20:00 Finalizado 		San Benito CF San Benito CF 4-3 Heredia Heredia más información 1
 
13 Ago 23
20:00 Finalizado 		Deportivo Barberena Deportivo Barberena 1-1 Sacachispas Sacachispas más información ...
 
13 Ago 23
21:30 Finalizado 		Mictlán Mictlán 0-2 Juventud Pinulteca Juventud Pinulteca más información ...
Clasificación
« Jornada Anterior
Jornada 3
Jornada Siguiente »
Grupo A Puntos J. G. E. P. F. C. Forma
1 Iztapa Iztapa 7 3 2 1 0 4 1
  • VICTORIA
  • Marquense 0
  • Iztapa 1
  • VICTORIA
  • Iztapa 3
  • Suchitepequez 1
  • EMPATE
  • Iztapa 0
  • Quiché 0
2 Marquense Marquense 6 3 2 0 1 3 1
  • DERROTA
  • Marquense 0
  • Iztapa 1
  • VICTORIA
  • Cotzumalguapa 0
  • Marquense 2
  • VICTORIA
  • Marquense 1
  • CD San Pedro 0
3 Democracia FC. Democracia FC. 5 3 1 2 0 4 1
  • EMPATE
  • Democracia FC. 0
  • Nueva Concepción 0
  • VICTORIA
  • Quiché 0
  • Democracia FC. 3
  • EMPATE
  • Juventud Copalera 1
  • Democracia FC. 1
4 Sololá Sololá 5 3 1 2 0 3 1
  • VICTORIA
  • Sololá 2
  • Cotzumalguapa 0
  • EMPATE
  • CD San Pedro 0
  • Sololá 0
  • EMPATE
  • Sololá 1
  • Nueva Concepción 1
5 Juventud Copalera Juventud 5 3 1 2 0 4 3
  • VICTORIA
  • Juventud Copalera 2
  • CD San Pedro 1
  • EMPATE
  • Nueva Concepción 1
  • Juventud Copalera 1
  • EMPATE
  • Juventud Copalera 1
  • Democracia FC. 1
6 Suchitepequez Suchitepequez 4 3 1 1 1 4 5
  • EMPATE
  • Suchitepequez 2
  • Quiché 2
  • DERROTA
  • Iztapa 3
  • Suchitepequez 1
  • VICTORIA
  • Suchitepequez 1
  • Cotzumalguapa 0
7 Nueva Concepción Nueva 3 3 0 3 0 2 2
  • EMPATE
  • Democracia FC. 0
  • Nueva Concepción 0
  • EMPATE
  • Nueva Concepción 1
  • Juventud Copalera 1
  • EMPATE
  • Sololá 1
  • Nueva Concepción 1
8 Quiché Quiché 2 3 0 2 1 2 5
  • EMPATE
  • Suchitepequez 2
  • Quiché 2
  • DERROTA
  • Quiché 0
  • Democracia FC. 3
  • EMPATE
  • Iztapa 0
  • Quiché 0
9 CD San Pedro CD San Pedro 1 3 0 1 2 1 3
  • DERROTA
  • Juventud Copalera 2
  • CD San Pedro 1
  • EMPATE
  • CD San Pedro 0
  • Sololá 0
  • DERROTA
  • Marquense 1
  • CD San Pedro 0
10 Cotzumalguapa Cotzumalguapa 0 3 0 0 3 0 5
  • DERROTA
  • Sololá 2
  • Cotzumalguapa 0
  • DERROTA
  • Cotzumalguapa 0
  • Marquense 2
  • DERROTA
  • Suchitepequez 1
  • Cotzumalguapa 0
Grupo B Puntos J. G. E. P. F. C. Forma
1 Universidad San Carlos Universidad 9 3 3 0 0 5 1
  • VICTORIA
  • Universidad San Ca. 1
  • Aurora FC 0
  • VICTORIA
  • Heredia 0
  • Universidad San Ca. 1
  • VICTORIA
  • Universidad San Ca. 3
  • Deportivo Fraijane. 1
2 Juventud Pinulteca Juventud 6 3 2 0 1 6 4
  • VICTORIA
  • Deportivo Barberen. 2
  • Juventud Pinulteca 3
  • DERROTA
  • Juventud Pinulteca 1
  • Deportivo Fraijane. 2
  • VICTORIA
  • Mictlán 0
  • Juventud Pinulteca 2
3 San Benito CF San Benito CF 5 3 1 2 0 5 4
  • EMPATE
  • San Benito CF 0
  • Sacachispas 0
  • EMPATE
  • Aurora FC 1
  • San Benito CF 1
  • VICTORIA
  • San Benito CF 4
  • Heredia 3
4 Sacachispas Sacachispas 5 3 1 2 0 2 1
  • EMPATE
  • San Benito CF 0
  • Sacachispas 0
  • VICTORIA
  • Sacachispas 1
  • Cuilapa FC 0
  • EMPATE
  • Deportivo Barberen. 1
  • Sacachispas 1
5 Deportivo Barberena Deportivo 4 3 1 1 1 5 5
  • DERROTA
  • Deportivo Barberen. 2
  • Juventud Pinulteca 3
  • VICTORIA
  • Mictlán 1
  • Deportivo Barberen. 2
  • EMPATE
  • Deportivo Barberen. 1
  • Sacachispas 1
6 Aurora FC Aurora FC 4 3 1 1 1 2 2
  • DERROTA
  • Universidad San Ca. 1
  • Aurora FC 0
  • EMPATE
  • Aurora FC 1
  • San Benito CF 1
  • VICTORIA
  • Cuilapa FC 0
  • Aurora FC 1
7 Deportivo Fraijanes Deportivo 3 2 1 0 1 3 4
  • VICTORIA
  • Juventud Pinulteca 1
  • Deportivo Fraijane. 2
  • DERROTA
  • Universidad San Ca. 3
  • Deportivo Fraijane. 1
8 Mictlán Mictlán 3 3 1 0 2 2 4
  • VICTORIA
  • Cuilapa FC 0
  • Mictlán 1
  • DERROTA
  • Mictlán 1
  • Deportivo Barberen. 2
  • DERROTA
  • Mictlán 0
  • Juventud Pinulteca 2
9 Heredia Heredia 0 2 0 0 2 3 5
  • DERROTA
  • Heredia 0
  • Universidad San Ca. 1
  • DERROTA
  • San Benito CF 4
  • Heredia 3
10 Cuilapa FC Cuilapa FC 0 3 0 0 3 0 3
  • DERROTA
  • Cuilapa FC 0
  • Mictlán 1
  • DERROTA
  • Sacachispas 1
  • Cuilapa FC 0
  • DERROTA
  • Cuilapa FC 0
  • Aurora FC 1
Series Finales : Iztapa, Marquense, Universidad, Juventud
Playoffs : Democracia FC., Sololá, Juventud, Suchitepequez, San Benito CF, Sacachispas, Deportivo, Aurora FC

INFORMACIÓN

La Primera División de Ascenso o Primera División de Guatemala es la segunda de mayor importancia en el país, anteriormente llamada Liga Mayor "B", aquí han llegado a descender equipos campeones que han pasado por malos momentos tales como Cobán Imperial, Xelajú M.C., Suchitepequez, Aurora.

  USO DE MEMORIA  
5,394,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.2862
Total Execution Time  0.2894
  CADENA URL  
/primera_division_apertura_guatemala/grupo1/jornada3
  GET DATOS  
$_GET['/primera_division_apertura_guatemala/grupo1/jornada3']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-30 22:28:26' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-30 22:28:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-30 22:28:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-30 22:28:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0134  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=72351 AND rel.round=3
0.0149  SELECT c.isVideo, c.id,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,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72351 AND c.`round` = 3 ORDER BY shedule ASC LIMIT 200
0.0140  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 72351 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (428249,428250,428251,428252,428253,428254,428255,428256,428257,428258) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0136  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 3 AND e.real_date IS NOT NULL AND e.league_id = 72351 ORDER BY total DESC LIMIT 40
0.0135  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 = 72351 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0395  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 = 72351 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT data1, data2 FROM services_tags WHERE categoryId=235
0.0126  SELECT group_code, extraName from `leagues` WHERE categoryId=235 AND year=2024