4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
09 Ene 11 IztapaIztapa 3 - 0 Puerto San JoséPuerto ...
09 Ene 11 AchuapaAchuapa 6 - 0 PeténPetén ...
09 Ene 11 Nueva ConcepciónNueva 3 - 2 CD San PedroPedro ...
09 Ene 11 MixcoMixco 1 - 0 La GomeraLa Gomera ...
09 Ene 11 María LindaMaría 1 - 2 CoatepequeCoatepeque ...
09 Ene 11 Cobán ImperialCobán 3 - 3 GuastatoyaGuastatoya ...
09 Ene 11 ZacapaZacapa 2 - 1 JalapaJalapa ...
09 Ene 11 TeculutánTeculután 0 - 2 Deportivo PetapaDeportivo ...
09 Ene 11 Aurora FCAurora FC 0 - 0 Juventud EscuintlecaJuventud ...
09 Ene 11 CarcháCarchá 4 - 0 SacachispasSacachispas ...
Jornada 2
16 Ene 11 Deportivo PetapaDeportivo 4 - 1 ZacapaZacapa ...
16 Ene 11 CD San PedroPedro 1 - 0 IztapaIztapa ...
16 Ene 11 La GomeraLa Gomera 0 - 0 Nueva ConcepciónNueva ...
16 Ene 11 Juventud EscuintlecaJuventud 3 - 1 María LindaMaría ...
16 Ene 11 CoatepequeCoatepeque 2 - 1 MixcoMixco ...
16 Ene 11 Puerto San JoséPuerto 1 - 1 Aurora FCAurora FC ...
16 Ene 11 SacachispasSacachispas 2 - 4 TeculutánTeculután ...
16 Ene 11 JalapaJalapa 1 - 2 Cobán ImperialCobán ...
16 Ene 11 PeténPetén 2 - 3 CarcháCarchá ...
16 Ene 11 GuastatoyaGuastatoya 2 - 0 AchuapaAchuapa ...
Jornada 3
23 Ene 11 SacachispasSacachispas 3 - 2 PeténPetén ...
23 Ene 11 CarcháCarchá 1 - 0 GuastatoyaGuastatoya ...
23 Ene 11 AchuapaAchuapa 3 - 1 JalapaJalapa ...
23 Ene 11 CD San PedroPedro 3 - 0 La GomeraLa Gomera ...
23 Ene 11 Cobán ImperialCobán 0 - 2 Deportivo PetapaDeportivo ...
23 Ene 11 TeculutánTeculután 1 - 2 ZacapaZacapa ...
23 Ene 11 Nueva ConcepciónNueva 0 - 0 CoatepequeCoatepeque ...
23 Ene 11 María LindaMaría 2 - 1 Puerto San JoséPuerto ...
23 Ene 11 MixcoMixco 4 - 1 Juventud EscuintlecaJuventud ...
22 Ene 11 IztapaIztapa 1 - 0 Aurora FCAurora FC ...
Jornada 4
30 Ene 11 Deportivo PetapaDeportivo 0 - 2 AchuapaAchuapa ...
30 Ene 11 La GomeraLa Gomera 2 - 0 IztapaIztapa ...
30 Ene 11 Juventud EscuintlecaJuventud 0 - 0 Nueva ConcepciónNueva ...
30 Ene 11 CoatepequeCoatepeque 2 - 0 CD San PedroPedro ...
30 Ene 11 Aurora FCAurora FC 2 - 1 María LindaMaría ...
30 Ene 11 ZacapaZacapa 0 - 1 Cobán ImperialCobán ...
30 Ene 11 Puerto San JoséPuerto 1 - 1 MixcoMixco ...
30 Ene 11 TeculutánTeculután 2 - 1 PeténPetén ...
30 Ene 11 JalapaJalapa 0 - 0 CarcháCarchá ...
30 Ene 11 GuastatoyaGuastatoya 3 - 0 SacachispasSacachispas ...
Jornada 5
07 Feb 11 CD San PedroPedro 4 - 1 Juventud EscuintlecaJuventud ...
06 Feb 11 La GomeraLa Gomera 1 - 2 CoatepequeCoatepeque ...
06 Feb 11 PeténPetén 3 - 1 GuastatoyaGuastatoya ...
06 Feb 11 Nueva ConcepciónNueva 3 - 2 Puerto San JoséPuerto ...
06 Feb 11 MixcoMixco 0 - 0 Aurora FCAurora FC ...
06 Feb 11 SacachispasSacachispas 4 - 2 JalapaJalapa ...
06 Feb 11 CarcháCarchá 2 - 1 Deportivo PetapaDeportivo ...
06 Feb 11 AchuapaAchuapa 1 - 2 ZacapaZacapa ...
06 Feb 11 IztapaIztapa 0 - 0 María LindaMaría ...
05 Feb 11 TeculutánTeculután 1 - 2 Cobán ImperialCobán ...
Jornada 6
13 Feb 11 Deportivo PetapaDeportivo 2 - 1 SacachispasSacachispas ...
13 Feb 11 Juventud EscuintlecaJuventud 1 - 0 La GomeraLa Gomera ...
13 Feb 11 CoatepequeCoatepeque 3 - 2 IztapaIztapa ...
13 Feb 11 Aurora FCAurora FC 0 - 0 Nueva ConcepciónNueva ...
13 Feb 11 ZacapaZacapa 2 - 1 CarcháCarchá ...
13 Feb 11 JalapaJalapa 0 - 0 PeténPetén ...
13 Feb 11 Puerto San JoséPuerto 2 - 0 CD San PedroPedro ...
13 Feb 11 María LindaMaría 3 - 2 MixcoMixco ...
13 Feb 11 Cobán ImperialCobán 0 - 0 AchuapaAchuapa ...
13 Feb 11 GuastatoyaGuastatoya 1 - 0 TeculutánTeculután ...
Jornada 7
20 Feb 11 SacachispasSacachispas 0 - 0 ZacapaZacapa ...
20 Feb 11 CD San PedroPedro 2 - 0 Aurora FCAurora FC ...
20 Feb 11 IztapaIztapa 1 - 0 MixcoMixco ...
20 Feb 11 PeténPetén 2 - 1 Deportivo PetapaDeportivo ...
20 Feb 11 La GomeraLa Gomera 3 - 2 Puerto San JoséPuerto ...
20 Feb 11 CoatepequeCoatepeque 3 - 2 Juventud EscuintlecaJuventud ...
20 Feb 11 CarcháCarchá 1 - 1 Cobán ImperialCobán ...
20 Feb 11 TeculutánTeculután 2 - 3 AchuapaAchuapa ...
20 Feb 11 Nueva ConcepciónNueva 1 - 0 María LindaMaría ...
20 Feb 11 GuastatoyaGuastatoya 0 - 0 JalapaJalapa ...
Jornada 8
24 Feb 11 MixcoMixco 3 - 0 Nueva ConcepciónNueva ...
24 Feb 11 Cobán ImperialCobán 5 - 1 SacachispasSacachispas ...
24 Feb 11 Deportivo PetapaDeportivo 2 - 2 GuastatoyaGuastatoya ...
23 Feb 11 AchuapaAchuapa 3 - 2 CarcháCarchá ...
23 Feb 11 ZacapaZacapa 3 - 2 PeténPetén ...
23 Feb 11 Puerto San JoséPuerto 3 - 2 CoatepequeCoatepeque ...
23 Feb 11 María LindaMaría 2 - 1 CD San PedroPedro ...
23 Feb 11 Aurora FCAurora FC 0 - 0 La GomeraLa Gomera ...
23 Feb 11 IztapaIztapa 1 - 0 Juventud EscuintlecaJuventud ...
23 Feb 11 TeculutánTeculután 3 - 1 JalapaJalapa ...
Jornada 9
27 Feb 11 SacachispasSacachispas 2 - 6 AchuapaAchuapa ...
27 Feb 11 CD San PedroPedro 1 - 0 MixcoMixco ...
27 Feb 11 PeténPetén 2 - 1 Cobán ImperialCobán ...
27 Feb 11 La GomeraLa Gomera 4 - 1 María LindaMaría ...
27 Feb 11 Juventud EscuintlecaJuventud 1 - 1 Puerto San JoséPuerto ...
27 Feb 11 CoatepequeCoatepeque 1 - 0 Aurora FCAurora FC ...
27 Feb 11 CarcháCarchá 1 - 0 TeculutánTeculután ...
27 Feb 11 JalapaJalapa 0 - 0 Deportivo PetapaDeportivo ...
27 Feb 11 Nueva ConcepciónNueva 3 - 1 IztapaIztapa ...
27 Feb 11 GuastatoyaGuastatoya 1 - 0 ZacapaZacapa ...
Jornada 10
06 Mar 11 SacachispasSacachispas 3 - 0 CarcháCarchá ...
06 Mar 11 CD San PedroPedro 1 - 0 Nueva ConcepciónNueva ...
06 Mar 11 Deportivo PetapaDeportivo 6 - 0 TeculutánTeculután ...
06 Mar 11 PeténPetén 2 - 1 AchuapaAchuapa ...
06 Mar 11 La GomeraLa Gomera 0 - 3 MixcoMixco ...
06 Mar 11 CoatepequeCoatepeque 1 - 1 María LindaMaría ...
06 Mar 11 Juventud EscuintlecaJuventud 1 - 0 Aurora FCAurora FC ...
06 Mar 11 JalapaJalapa 3 - 1 ZacapaZacapa ...
06 Mar 11 GuastatoyaGuastatoya 1 - 0 Cobán ImperialCobán ...
06 Mar 11 Puerto San JoséPuerto 2 - 1 IztapaIztapa ...
Jornada 11
13 Mar 11 CarcháCarchá 4 - 1 PeténPetén ...
13 Mar 11 Aurora FCAurora FC 1 - 0 Puerto San JoséPuerto ...
13 Mar 11 ZacapaZacapa 1 - 0 Deportivo PetapaDeportivo ...
13 Mar 11 TeculutánTeculután 0 - 1 SacachispasSacachispas ...
13 Mar 11 Nueva ConcepciónNueva 0 - 1 La GomeraLa Gomera ...
13 Mar 11 MixcoMixco 3 - 2 CoatepequeCoatepeque ...
13 Mar 11 María LindaMaría 1 - 5 Juventud EscuintlecaJuventud ...
13 Mar 11 Cobán ImperialCobán 3 - 0 JalapaJalapa ...
12 Mar 11 IztapaIztapa 1 - 1 CD San PedroPedro ...
13 Mar 11 AchuapaAchuapa 1 - 0 GuastatoyaGuastatoya ...
Jornada 12
20 Mar 11 ZacapaZacapa 3 - 1 TeculutánTeculután ...
20 Mar 11 Deportivo PetapaDeportivo 1 - 2 Cobán ImperialCobán ...
20 Mar 11 JalapaJalapa 1 - 3 AchuapaAchuapa ...
20 Mar 11 La GomeraLa Gomera 2 - 0 CD San PedroPedro ...
20 Mar 11 Juventud EscuintlecaJuventud 3 - 2 MixcoMixco ...
20 Mar 11 CoatepequeCoatepeque 3 - 0 Nueva ConcepciónNueva ...
20 Mar 11 Puerto San JoséPuerto 2 - 1 María LindaMaría ...
20 Mar 11 Aurora FCAurora FC 0 - 0 IztapaIztapa ...
20 Mar 11 GuastatoyaGuastatoya 0 - 1 CarcháCarchá ...
19 Mar 11 PeténPetén 1 - 0 SacachispasSacachispas ...
Jornada 13
27 Mar 11 SacachispasSacachispas 1 - 0 GuastatoyaGuastatoya ...
27 Mar 11 CarcháCarchá 3 - 1 JalapaJalapa ...
27 Mar 11 CD San PedroPedro 3 - 1 CoatepequeCoatepeque ...
27 Mar 11 AchuapaAchuapa 3 - 1 Deportivo PetapaDeportivo ...
27 Mar 11 PeténPetén 1 - 1 TeculutánTeculután ...
27 Mar 11 Nueva ConcepciónNueva 1 - 0 Juventud EscuintlecaJuventud ...
27 Mar 11 MixcoMixco 3 - 2 Puerto San JoséPuerto ...
27 Mar 11 Cobán ImperialCobán 2 - 1 ZacapaZacapa ...
27 Mar 11 María LindaMaría 1 - 1 Aurora FCAurora FC ...
26 Mar 11 IztapaIztapa 1 - 0 La GomeraLa Gomera ...
Jornada 14
03 Abr 11 Deportivo PetapaDeportivo 2 - 0 CarcháCarchá ...
03 Abr 11 CoatepequeCoatepeque 4 - 1 La GomeraLa Gomera ...
03 Abr 11 Juventud EscuintlecaJuventud 2 - 2 CD San PedroPedro ...
03 Abr 11 Aurora FCAurora FC 1 - 1 MixcoMixco ...
03 Abr 11 Puerto San JoséPuerto 3 - 1 Nueva ConcepciónNueva ...
03 Abr 11 ZacapaZacapa 4 - 4 AchuapaAchuapa ...
03 Abr 11 María LindaMaría 3 - 1 IztapaIztapa ...
03 Abr 11 GuastatoyaGuastatoya 1 - 1 PeténPetén ...
03 Abr 11 JalapaJalapa 1 - 1 SacachispasSacachispas ...
03 Abr 11 Cobán ImperialCobán 2 - 1 TeculutánTeculután ...
Jornada 15
12 Abr 11 MixcoMixco 2 - 1 María LindaMaría ...
10 Abr 11 CarcháCarchá 2 - 0 ZacapaZacapa ...
10 Abr 11 SacachispasSacachispas 1 - 1 Deportivo PetapaDeportivo ...
10 Abr 11 CD San PedroPedro 4 - 0 Puerto San JoséPuerto ...
10 Abr 11 La GomeraLa Gomera 1 - 0 Juventud EscuintlecaJuventud ...
10 Abr 11 PeténPetén 5 - 1 JalapaJalapa ...
10 Abr 11 TeculutánTeculután 2 - 3 GuastatoyaGuastatoya ...
10 Abr 11 Nueva ConcepciónNueva 1 - 0 Aurora FCAurora FC ...
09 Abr 11 IztapaIztapa 2 - 1 CoatepequeCoatepeque ...
10 Abr 11 AchuapaAchuapa 2 - 0 Cobán ImperialCobán ...
Jornada 16
17 Abr 11 Deportivo PetapaDeportivo 3 - 1 PeténPetén ...
17 Abr 11 AchuapaAchuapa 2 - 0 TeculutánTeculután ...
17 Abr 11 Aurora FCAurora FC 0 - 0 CD San PedroPedro ...
17 Abr 11 ZacapaZacapa 5 - 4 SacachispasSacachispas ...
17 Abr 11 Juventud EscuintlecaJuventud 2 - 0 CoatepequeCoatepeque ...
17 Abr 11 JalapaJalapa 3 - 2 GuastatoyaGuastatoya ...
17 Abr 11 MixcoMixco 2 - 1 IztapaIztapa ...
17 Abr 11 Puerto San JoséPuerto 0 - 1 La GomeraLa Gomera ...
17 Abr 11 María LindaMaría 1 - 0 Nueva ConcepciónNueva ...
17 Abr 11 Cobán ImperialCobán 1 - 3 CarcháCarchá ...
Jornada 17
21 Abr 11 CD San PedroPedro 1 - 0 María LindaMaría ...
21 Abr 11 JalapaJalapa 3 - 1 TeculutánTeculután ...
21 Abr 11 Juventud EscuintlecaJuventud 0 - 1 IztapaIztapa ...
21 Abr 11 GuastatoyaGuastatoya 0 - 1 Deportivo PetapaDeportivo ...
20 Abr 11 SacachispasSacachispas 1 - 0 Cobán ImperialCobán ...
20 Abr 11 PeténPetén 1 - 2 ZacapaZacapa ...
20 Abr 11 CarcháCarchá 2 - 1 AchuapaAchuapa ...
20 Abr 11 Nueva ConcepciónNueva 2 - 0 MixcoMixco ...
20 Abr 11 La GomeraLa Gomera 1 - 0 Aurora FCAurora FC ...
20 Abr 11 CoatepequeCoatepeque 2 - 0 Puerto San JoséPuerto ...
Jornada 18
01 May 11 MixcoMixco 3 - 1 CD San PedroPedro ...
01 May 11 María LindaMaría 1 - 0 La GomeraLa Gomera ...
01 May 11 IztapaIztapa 1 - 1 Nueva ConcepciónNueva ...
01 May 11 Aurora FCAurora FC 1 - 0 CoatepequeCoatepeque ...
01 May 11 Puerto San JoséPuerto 1 - 2 Juventud EscuintlecaJuventud ...
01 May 11 AchuapaAchuapa 0 - 3 SacachispasSacachispas ...
01 May 11 Cobán ImperialCobán 5 - 1 PeténPetén ...
01 May 11 Deportivo PetapaDeportivo 6 - 2 JalapaJalapa ...
01 May 11 TeculutánTeculután 0 - 4 CarcháCarchá ...
01 May 11 ZacapaZacapa 2 - 0 GuastatoyaGuastatoya ...

Clasificación

Equipo PJ GF GC Puntos
1 Coatepeque Coatepeque 18 31 23 32
2 Mixco Mixco 18 31 22 30
3 CD San Pedro Pedro 18 27 19 30
4 La Gomera La Gomera 18 17 19 26
5 Nueva Concepción Nueva 18 16 18 26
6 Juventud Escuintleca Juventud 18 24 23 25
7 Iztapa Iztapa 18 18 19 25
8 María Linda María Linda 18 21 29 21
9 Aurora FC Aurora FC 18 7 11 18
10 Puerto San José Puerto José 18 23 32 18
11 Carchá Carchá 18 34 18 38
12 Achuapa Achuapa 18 41 24 35
13 Zacapa Zacapa 18 31 29 32
14 Deportivo Petapa Deportivo 18 35 20 30
15 Cobán Imperial Cobán 18 30 22 30
16 Sacachispas Sacachispas 18 28 36 24
17 Guastatoya Guastatoya 18 20 21 22
18 Petén Petén 18 28 38 21
19 Jalapa Jalapa 18 21 39 14
20 Teculután Teculután 18 19 40 10

  USO DE MEMORIA  
6,223,368 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3782
Total Execution Time  0.3803
  CADENA URL  
/primera_division_clausura_guatemala2011/grupo1/calendario
  GET DATOS  
$_GET['/primera_division_clausura_guatemala2011/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'primera_division_clausura_guatemala2011'
0.0257  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_clausura_guatemala' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0137  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=235 ORDER BY l.group_code ASC
0.0128  SELECT id,name,alias,stepParent FROM categories WHERE parentId=235 ORDER BY order_id ASC
0.0130  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 236 GROUP BY l.categoryId
0.0132  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=236 GROUP BY l.year ORDER BY l.year DESC
0.0134  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 = 14688 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  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 calendars2011 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 14688 ORDER BY round ASC
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:17:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 07:17:31' 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-28 07:17:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 07:17:31' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0135  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_division_clausura_guatemala' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0129  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 events2011 e ON e.player_id = p.id AND e.league_id = 14688 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14688 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.0133  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 events2011 e ON e.player_id = p.id AND e.league_id = 14688 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14688 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0131  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 events2011 e ON e.player_id = p.id AND e.league_id = 14688 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 14688 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0159  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2011` 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 = 14688 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC