Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Antigua GFC Antigua GFC 22 36 13 46
2 Comunicaciones Comunicacion 22 37 19 44
3 Municipal Municipal 22 30 15 39
4 Malacateco Malacateco 22 36 23 36
5 Cotzumalguapa Cotzumalguap 22 28 25 36
6 Xelajú Xelajú 22 18 23 30
7 Iztapa Iztapa 22 30 36 28
8 Sololá Sololá 22 21 32 25
9 Guastatoya Guastatoya 22 18 23 23
10 Cobán Imperial Cobán 22 22 31 20
11 Achuapa Achuapa 22 12 24 16
12 Nueva Concepción Nueva 22 12 36 16
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 16 25 10 32
2 Malacateco Malacateco 16 19 18 24
3 Xelajú Xelajú 16 17 22 21
4 Antigua GFC Antigua GFC 16 21 23 20
5 Iztapa Iztapa 16 24 28 19
6 Cotzumalguapa Cotzumalguap 16 12 17 16
7 Municipal Municipal 16 34 8 36
8 Cobán Imperial Cobán 16 19 13 26
9 Guastatoya Guastatoya 16 19 19 20
10 Achuapa Achuapa 16 17 21 19
11 Deportivo Sanarate Deportivo 16 19 33 14
12 Sacachispas Sacachispas 16 20 34 13
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Cobán Imperial Cobán 22 34 23 41
2 Municipal Municipal 22 32 23 40
3 Comunicaciones Comunicacion 22 33 21 39
4 Antigua GFC Antigua GFC 22 30 23 37
5 Deportivo Sanarate Deportivo 22 27 24 37
6 Guastatoya Guastatoya 22 29 22 35
7 Malacateco Malacateco 22 29 24 31
8 Iztapa Iztapa 22 28 26 31
9 Xelajú Xelajú 22 26 27 28
10 Cotzumalguapa Cotzumalguap 22 21 29 22
11 Mixco Mixco 22 18 41 16
12 Siquinalá Siquinalá 22 20 44 10
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Guastatoya Guastatoya 22 34 11 44
2 Xelajú Xelajú 22 28 17 40
3 Comunicaciones Comunicacion 22 28 16 38
4 Malacateco Malacateco 22 38 32 38
5 Cobán Imperial Cobán 22 28 20 36
6 Antigua GFC Antigua GFC 22 24 24 34
7 Siquinalá Siquinalá 22 31 32 30
8 Municipal Municipal 22 26 30 28
9 Iztapa Iztapa 22 23 28 25
10 Deportivo Sanarate Deportivo 22 21 35 19
11 Deportivo Petapa Deportivo 22 18 31 16
12 Dep. Chiantla Dep. 22 15 38 11
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Antigua GFC Antigua GFC 22 35 16 38
2 Deportivo Petapa Deportivo 22 35 19 38
3 Municipal Municipal 22 24 18 35
4 Xelajú Xelajú 22 30 27 35
5 Cobán Imperial Cobán 22 28 25 35
6 Guastatoya Guastatoya 22 33 21 34
7 Comunicaciones Comunicacion 22 28 20 34
8 Malacateco Malacateco 22 29 29 26
9 Deportivo Sanarate Deportivo 22 14 22 26
10 Suchitepequez Suchitepeque 22 24 43 22
11 Siquinalá Siquinalá 22 19 38 20
12 Marquense Marquense 22 18 39 20
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Municipal Municipal 22 36 19 44
2 Antigua GFC Antigua GFC 22 37 29 41
3 Comunicaciones Comunicacion 22 35 15 39
4 Malacateco Malacateco 22 29 23 36
5 Guastatoya Guastatoya 22 22 20 36
6 Cobán Imperial Cobán 22 26 19 34
7 Xelajú Xelajú 22 24 29 29
8 Marquense Marquense 22 25 30 26
9 Deportivo Petapa Deportivo 22 23 31 25
10 Suchitepequez Suchitepeque 22 28 41 24
11 Mictlán Mictlán 22 19 31 22
12 Carchá Carchá 22 16 33 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Xelajú Xelajú 22 22 17 41
2 Antigua GFC Antigua GFC 22 28 19 38
3 Comunicaciones Comunicacion 22 26 20 37
4 Guastatoya Guastatoya 22 33 23 34
5 Suchitepequez Suchitepeque 22 36 27 34
6 Deportivo Petapa Deportivo 22 29 31 33
7 Municipal Municipal 22 28 27 31
8 Marquense Marquense 22 22 28 29
9 Cobán Imperial Cobán 22 20 26 28
10 Mictlán Mictlán 22 24 28 26
11 Universidad San Carlos Universidad 22 31 36 18
12 Malacateco Malacateco 22 24 41 17
Ver
TEMPORADA 2014/2015
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
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 22 44 15 44
2 Municipal Municipal 22 34 15 41
3 Marquense Marquense 22 28 19 37
4 Heredia Heredia 22 34 25 35
5 Universidad San Carlos Universidad 22 27 33 35
6 Halcones Halcones 22 23 33 29
7 Malacateco Malacateco 22 21 25 28
8 Suchitepequez Suchitepeque 22 28 26 27
9 Xelajú Xelajú 22 36 35 27
10 Mictlán Mictlán 22 20 39 24
11 Coatepeque Coatepeque 22 21 33 19
12 Iztapa Iztapa 22 19 37 16
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 22 39 16 50
2 Municipal Municipal 22 46 23 41
3 Xelajú Xelajú 22 34 29 36
4 Heredia Heredia 22 33 24 35
5 Halcones Halcones 22 30 24 33
6 Malacateco Malacateco 22 26 25 28
7 Suchitepequez Suchitepeque 22 36 40 28
8 Marquense Marquense 22 24 27 26
9 Deportivo Petapa Deportivo 22 27 43 24
10 Mictlán Mictlán 22 22 40 22
11 Universidad San Carlos Universidad 22 33 39 21
12 Juventud Escuintleca Juventud 22 23 43 19
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Suchitepequez Suchitepeque 22 34 21 43
2 Xelajú Xelajú 22 30 23 38
3 Marquense Marquense 22 31 20 36
4 Comunicaciones Comunicacion 22 27 20 35
5 Heredia Heredia 22 35 30 35
6 Municipal Municipal 22 37 22 34
7 Halcones Halcones 22 36 31 31
8 Malacateco Malacateco 22 29 42 22
9 Zacapa Zacapa 22 27 43 21
10 Juv.Retalteca Juv.Retaltec 22 24 33 20
11 Mictlán Mictlán 22 23 39 20
12 Deportivo Petapa Deportivo 22 24 33 18
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Municipal Municipal 22 40 22 38
2 Marquense Marquense 22 32 27 33
3 Heredia Heredia 22 28 31 32
4 Comunicaciones Comunicacion 22 26 23 31
5 Mictlán Mictlán 22 15 18 31
6 Suchitepequez Suchitepeque 22 32 23 30
7 Juv.Retalteca Juv.Retaltec 22 28 25 30
8 Xelajú Xelajú 22 27 29 30
9 Xinabajul Xinabajul 22 22 29 27
10 Universidad San Carlos Universidad 22 28 36 27
11 Malacateco Malacateco 22 20 28 27
12 Halcones Halcones 22 22 29 23
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Xelajú Xelajú 22 33 24 39
2 Municipal Municipal 22 30 20 37
3 Marquense Marquense 22 31 27 37
4 Heredia Heredia 22 40 28 35
5 Juv.Retalteca Juv.Retaltec 22 35 25 35
6 Comunicaciones Comunicacion 22 30 22 32
7 Suchitepequez Suchitepeque 22 32 27 32
8 Xinabajul Xinabajul 22 22 30 28
9 Jalapa Jalapa 22 20 25 27
10 Zacapa Zacapa 22 24 45 26
11 Universidad San Carlos Universidad 22 18 27 18
12 Halcones Halcones 22 22 37 16
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Municipal Municipal 18 29 18 29
2 Comunicaciones Comunicacion 18 27 23 29
3 Zacapa Zacapa 18 21 17 28
4 Xelajú Xelajú 18 23 20 28
5 Marquense Marquense 18 22 27 24
6 Xinabajul Xinabajul 18 20 27 23
7 Heredia Heredia 18 23 24 21
8 Deportivo Petapa Deportivo 18 16 20 21
9 Suchitepequez Suchitepeque 18 31 29 20
10 Jalapa Jalapa 18 17 24 18
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Municipal Municipal 18 31 18 31
2 Jalapa Jalapa 18 32 26 28
3 Comunicaciones Comunicacion 18 27 18 27
4 Xelajú Xelajú 18 14 22 25
5 Suchitepequez Suchitepeque 18 32 27 24
6 Zacapa Zacapa 18 31 31 24
7 Marquense Marquense 18 21 27 24
8 Malacateco Malacateco 18 16 22 20
9 Heredia Heredia 18 22 26 19
10 Deportivo Petapa Deportivo 18 20 29 19
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 18 31 13 40
2 Xelajú Xelajú 18 35 16 32
3 Municipal Municipal 18 30 22 29
4 Jalapa Jalapa 18 26 23 27
5 Marquense Marquense 18 26 20 25
6 Zacapa Zacapa 18 19 32 24
7 Deportivo Petapa Deportivo 18 31 29 23
8 Heredia Heredia 18 24 36 19
9 Suchitepequez Suchitepeque 18 17 29 18
10 Mictlán Mictlán 18 12 31 14
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Municipal Municipal 18 35 14 38
2 Comunicaciones Comunicacion 18 37 27 35
3 Xelajú Xelajú 18 26 22 32
4 Marquense Marquense 18 28 18 28
5 Jalapa Jalapa 18 25 29 24
6 Suchitepequez Suchitepeque 18 25 32 23
7 Heredia Heredia 18 21 26 21
8 Antigua GFC Antigua GFC 18 21 29 18
9 Deportivo Petapa Deportivo 18 16 27 14
10 Cobán Imperial Cobán 18 18 28 12
Ver
TEMPORADA 2004/2005
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2003/2004
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 18 38 21 36
2 Municipal Municipal 18 36 24 34
3 Cobán Imperial Cobán 18 22 19 26
4 Xelajú Xelajú 18 25 26 24
5 Teculután Teculután 18 25 27 24
6 Jalapa Jalapa 18 36 35 23
7 Antigua GFC Antigua GFC 18 18 21 19
8 Zacapa Zacapa 18 27 33 19
9 Aurora FC Aurora FC 18 16 25 19
10 Marquense Marquense 18 23 35 19
Ver
TEMPORADA 2002/2003
Equipo PJ GF GC Puntos
1 Municipal Municipal 18 32 14 43
2 Comunicaciones Comunicacion 18 43 16 39
3 Cobán Imperial Cobán 18 28 21 23
4 Xelajú Xelajú 18 18 21 23
5 Marquense Marquense 18 21 28 23
6 Aurora FC Aurora FC 18 22 21 22
7 Zacapa Zacapa 18 22 31 22
8 Teculután Teculután 18 21 27 19
9 Antigua GFC Antigua GFC 18 20 34 17
10 Juv. Realteca Juv. 18 19 33 16
Ver
TEMPORADA 2001/2002
Equipo PJ GF GC Puntos
1 Municipal Municipal 22 49 18 48
2 Cobán Imperial Cobán 22 43 25 43
3 Comunicaciones Comunicacion 22 47 23 42
4 Marquense Marquense 22 30 29 34
5 Jalapa Jalapa 22 31 21 33
6 Zacapa Zacapa 22 31 35 29
7 Aurora FC Aurora FC 22 33 42 28
8 Xelajú Xelajú 22 27 27 27
9 Antigua GFC Antigua GFC 22 33 44 27
10 Teculután Teculután 22 22 30 26
11 Deportivo Petapa Deportivo 22 18 40 14
12 Universidad San Carlos Universidad 22 20 50 14
Ver
TEMPORADA 2000/2001
Equipo PJ GF GC Puntos
1 Comunicaciones Comunicacion 22 52 15 51
2 Municipal Municipal 22 45 23 39
3 Marquense Marquense 22 35 38 39
4 Xelajú Xelajú 22 26 20 36
5 Antigua GFC Antigua GFC 22 32 27 36
6 Zacapa Zacapa 22 35 29 32
7 Cobán Imperial Cobán 22 28 25 27
8 Universidad San Carlos Universidad 22 32 33 26
9 Carchá Carchá 22 14 28 22
10 Achuapa Achuapa 22 29 45 22
11 Aurora FC Aurora FC 22 24 31 20
12 Cotzumalguapa Cotzumalguap 22 28 66 11
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,805,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5239
Total Execution Time  0.5259
  CADENA URL  
/apertura_guatemala2022/grupo1/historico
  GET DATOS  
$_GET['/apertura_guatemala2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0105  SELECT type FROM routes WHERE alias = 'apertura_guatemala2022'
0.0214  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=148 ORDER BY order_id ASC
0.0106  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 = 63155 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 148 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0108  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.0108  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.0109  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.0109  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.0111  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.0111  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.0111  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.0112  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
0.0111  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 `tables2014` 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 = 2464 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2013` 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 = 2060 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2012` 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 = 1600 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `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 = 1213 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2010` 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 = 1026 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2009` 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 = 14667 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2008` 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 = 14670 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2007` 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 = 14673 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2006` 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 = 14676 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2005` 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 = 27579 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2004` 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 = 27617 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2003` 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 = 27615 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 `tables2002` 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 = 27611 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 13:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 13:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 13:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 13:24:56' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  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 = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0227  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 events2022 e ON e.player_id = p.id AND e.league_id = 63155 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63155 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.0306  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 events2022 e ON e.player_id = p.id AND e.league_id = 63155 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63155 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
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 events2022 e ON e.player_id = p.id AND e.league_id = 63155 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63155 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0122  SELECT *,(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