Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

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

Resultados de Fútbol

« Temporada Anterior

Temporada 2024

2023/2024

Temporada Regular

Liga Guatemala - Clausura 2024

Liga Guatemala - Apertura

Liga Guatemala - Clausura

Liga Nacional

Ver

TEMPORADA 2023/2024

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

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	37	16	45
2	Municipal	22	44	21	43
3	Xelajú	22	29	9	43
4	Xinabajul	22	27	29	31
5	Guastatoya	22	28	22	29
6	Mixco	22	23	22	29
7	Antigua GFC	22	33	37	29
8	Achuapa	22	24	44	26
9	Cobán	22	16	17	25
10	Iztapa	22	30	49	20
11	Malacateco	22	24	33	19
12	Cotzumalguap	22	14	30	19

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	39	24	41
2	Municipal	22	34	18	40
3	Guastatoya	22	32	18	37
4	Malacateco	22	29	22	35
5	Cobán	22	29	25	34
6	Antigua GFC	22	33	22	33
7	Achuapa	22	21	19	33
8	Cotzumalguap	22	36	27	28
9	Iztapa	22	30	31	28
10	Xelajú	22	17	31	23
11	Sololá	22	21	44	18
12	Nueva	22	19	59	12

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	16	28	12	34
2	Cotzumalguap	16	13	13	24
3	Iztapa	16	29	25	22
4	Xelajú	16	14	15	17
5	Malacateco	16	8	14	16
6	Antigua GFC	16	15	26	13
7	Guastatoya	16	23	10	28
8	Municipal	16	24	11	27
9	Cobán	16	20	17	23
10	Deportivo	16	16	25	18
11	Sacachispas	16	15	26	18
12	Achuapa	16	16	27	14

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	13	26	15	28
2	Municipal	13	17	12	23
3	Guastatoya	13	13	10	21
4	Iztapa	13	19	18	20
5	Antigua GFC	13	15	11	19
6	Siquinalá	13	17	17	16
7	Mixco	13	14	14	15
8	Cotzumalguap	13	13	18	15
9	Xelajú	13	12	15	13
10	Malacateco	13	9	14	13
11	Deportivo	13	13	17	12
12	Cobán	13	8	15	10

Ver

TEMPORADA 2018/2019

Equipo		PJ	GF	GC	Puntos
1	Antigua GFC	22	36	20	41
2	Cobán	22	35	25	40
3	Comunicacion	22	32	14	39
4	Municipal	22	37	22	36
5	Malacateco	22	24	20	36
6	Guastatoya	22	27	16	35
7	Dep.	22	21	25	30
8	Xelajú	22	27	25	29
9	Siquinalá	22	23	25	26
10	Iztapa	22	21	28	25
11	Deportivo	22	22	38	23
12	Deportivo	22	12	59	7

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Deportivo	22	29	14	40
2	Cobán	22	32	21	39
3	Guastatoya	22	27	18	38
4	Antigua GFC	22	42	34	37
5	Xelajú	22	31	31	31
6	Siquinalá	22	20	22	31
7	Comunicacion	22	22	26	29
8	Deportivo	22	27	33	29
9	Municipal	22	34	28	28
10	Suchitepeque	22	29	36	25
11	Malacateco	22	25	32	25
12	Marquense	22	16	39	17

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Municipal	22	19	10	36
2	Deportivo	22	27	24	34
3	Guastatoya	22	22	16	32
4	Comunicacion	22	21	16	30
5	Suchitepeque	22	24	28	30
6	Xelajú	22	30	25	29
7	Cobán	22	17	15	29
8	Marquense	22	19	16	28
9	Malacateco	22	17	20	28
10	Mictlán	22	14	25	28
11	Antigua GFC	22	28	30	27
12	Carchá	22	11	24	20

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Suchitepeque	22	36	23	39
2	Municipal	22	29	21	36
3	Comunicacion	22	32	27	32
4	Malacateco	22	35	24	31
5	Antigua GFC	22	27	23	31
6	Marquense	22	30	29	31
7	Guastatoya	22	26	28	31
8	Mictlán	22	21	28	30
9	Universidad	22	32	29	29
10	Xelajú	22	19	25	24
11	Deportivo	22	33	40	23
12	Cobán	22	17	40	23

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	50	14	48
2	Municipal	22	31	16	42
3	Suchitepeque	22	33	30	38
4	Antigua GFC	22	25	19	35
5	Xelajú	22	28	24	31
6	Malacateco	22	29	37	29
7	Deportivo	22	24	31	28
8	Marquense	22	22	29	27
9	Universidad	22	19	24	26
10	Guastatoya	22	19	25	22
11	Halcones	22	24	34	20
12	Coatepeque	22	12	33	17

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	Heredia	22	50	33	36
2	Suchitepeque	22	26	20	36
3	Xelajú	22	33	21	34
4	Comunicacion	22	30	19	34
5	Coatepeque	22	32	37	34
6	Universidad	22	37	26	33
7	Municipal	22	22	19	31
8	Halcones	22	19	31	29
9	Mictlán	22	25	34	28
10	Marquense	22	25	35	26
11	Malacateco	22	24	33	25
12	Iztapa	22	24	39	15

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	30	14	44
2	Heredia	22	44	25	39
3	Malacateco	22	24	18	38
4	Suchitepeque	22	31	30	33
5	Halcones	22	29	28	33
6	Marquense	22	37	26	32
7	Universidad	22	28	32	30
8	Xelajú	22	26	31	30
9	Mictlán	22	23	30	29
10	Deportivo	22	21	31	24
11	Municipal	22	19	27	20
12	Juventud	22	18	38	20

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	39	23	42
2	Marquense	22	38	18	38
3	Xelajú	22	27	22	34
4	Municipal	22	30	24	31
5	Suchitepeque	22	33	31	31
6	Heredia	22	30	35	31
7	Deportivo	22	23	23	30
8	Mictlán	22	25	37	29
9	Malacateco	22	21	30	27
10	Halcones	22	32	26	25
11	Zacapa	22	27	37	25
12	Juv.Retaltec	22	20	39	17

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	Municipal	22	33	20	37
2	Heredia	22	32	19	37
3	Comunicacion	22	39	28	36
4	Malacateco	22	32	25	36
5	Mictlán	22	24	23	35
6	Halcones	22	35	36	33
7	Juv.Retaltec	22	25	21	30
8	Xelajú	22	25	34	30
9	Marquense	22	28	30	29
10	Universidad	22	22	23	26
11	Suchitepeque	22	21	28	23
12	Xinabajul	22	11	40	17

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	37	22	40
2	Xelajú	22	32	26	39
3	Suchitepeque	22	25	23	36
4	Municipal	22	25	19	32
5	Universidad	22	28	23	32
6	Halcones	22	30	25	31
7	Juv.Retaltec	22	20	21	31
8	Marquense	22	25	29	26
9	Jalapa	22	24	29	26
10	Heredia	22	26	34	24
11	Xinabajul	22	25	36	23
12	Zacapa	22	24	34	21

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	Municipal	18	26	13	32
2	Heredia	18	26	24	29
3	Jalapa	18	17	13	28
4	Suchitepeque	18	25	23	27
5	Xelajú	18	18	16	27
6	Comunicacion	18	25	22	23
7	Xinabajul	18	24	26	23
8	Marquense	18	15	22	19
9	Deportivo	18	22	30	16
10	Zacapa	18	14	23	16

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	18	36	18	35
2	Municipal	18	34	16	35
3	Deportivo	18	22	21	30
4	Xelajú	18	16	16	25
5	Suchitepeque	18	21	25	25
6	Marquense	18	24	19	24
7	Zacapa	18	23	27	21
8	Jalapa	18	17	22	21
9	Heredia	18	18	29	13
10	Malacateco	18	10	28	12

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	Municipal	18	43	21	32
2	Deportivo	18	31	23	31
3	Marquense	18	35	26	29
4	Xelajú	18	24	20	26
5	Heredia	18	26	28	25
6	Suchitepeque	18	21	25	23
7	Zacapa	18	25	35	21
8	Comunicacion	18	17	21	20
9	Jalapa	18	19	27	20
10	Mictlán	18	21	36	16

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Municipal	18	41	14	39
2	Marquense	18	33	23	33
3	Suchitepeque	18	21	21	28
4	Xelajú	18	24	21	27
5	Jalapa	18	16	21	26
6	Cobán	18	27	24	25
7	Heredia	18	19	24	21
8	Deportivo	18	19	23	19
9	Comunicacion	18	18	31	16
10	Antigua GFC	18	14	30	15

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Municipal	18	35	16	39
2	Suchitepeque	18	27	19	32
3	Xelajú	18	27	17	30
4	Comunicacion	18	29	20	30
5	Antigua GFC	18	20	23	25
6	Cobán	18	17	22	21
7	Heredia	18	27	32	20
8	Jalapa	18	18	26	18
9	Aurora FC	18	20	33	18
10	Marquense	18	18	30	14

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	Municipal	18	42	28	35
2	Cobán	18	25	23	31
3	Jalapa	18	38	30	29
4	Marquense	18	32	25	28
5	Aurora FC	18	27	29	24
6	Comunicacion	18	22	24	23
7	Antigua GFC	18	27	30	23
8	Xelajú	18	27	34	20
9	Zacapa	18	32	32	19
10	Teculután	18	28	45	15

Ver

TEMPORADA 2002/2003

Equipo		PJ	GF	GC	Puntos
1	Comunicacion	18	37	14	41
2	Cobán	18	26	18	30
3	Municipal	18	37	28	27
4	Antigua GFC	18	23	20	26
5	Aurora FC	18	24	24	26
6	Marquense	18	27	33	23
7	Zacapa	18	22	38	23
8	Teculután	18	20	25	21
9	Xelajú	18	21	20	19
10	Juv.	18	11	28	12

JUGADORES DESTACADOS

Nombre	Goles	Equipo
D. Casas	9	COB
M. Rotondi	9	MUN
E. Lemus	5	ACH
T. Pizarro	5	XIN
N. Mazzola	5	XIN
Ángel López	5	TOR
J. Morán	5	CHI
Edwin Bol	4	COB
J. Anangonó	4	COM
D. Bradley	4	ANT

Equipos de esta liga

USO DE MEMORIA

6,850,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1170
Total Execution Time	0.1190

CADENA URL

/clausura_guatemala2024/grupo1/historico

GET DATOS

$_GET['/clausura_guatemala2024/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=149 AND type_rel = 3
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 149 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (1257190,1251683,1248316,1246443,1234412) 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 = 75018 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 149 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.0048	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.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.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* `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.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* `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 = 8953 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* `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 = 3465 AND t.round = 22 ORDER BY team.conference 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* `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 = 2325 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* `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 = 1669 AND t.round = 22 ORDER BY team.conference 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* `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 = 1668 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 1027 AND t.round = 22 ORDER BY team.conference 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* `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 = 14668 AND t.round = 18 ORDER BY team.conference 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* `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 = 14671 AND t.round = 18 ORDER BY team.conference 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* `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 = 14674 AND t.round = 18 ORDER BY team.conference 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* `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 = 14677 AND t.round = 18 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* `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 = 27531 AND t.round = 18 ORDER BY team.conference 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* `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 = 27536 AND t.round = 18 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* `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 = 27539 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 07:00:30' 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-27 07:00:30' 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-27 07:00:30' 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=3 AND last_update > '2024-04-27 07:00:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0045	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 = 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

Nombre	Amarillas	Equipo
Mathius Gaitán	9	XIN
C. Alvarado	8	COA
Jonathan García	8	XIN
Thales	7	COB
O. Domínguez	7	GUA
S. Mena	7	COM
Rodrigo Marroquín	7	MIX
Y. Pérez	7	ACH
M. López	6	COB
Y. Carabalí	6	ZAC

Nombre	Rojas	Equipo
W. Godoy	3	TOR
W. Garcia	2	GUA
M. Gamboa	2	ANT
M. López	2	COB
O. Domínguez	2	GUA
L. Rosas	2	MIX
A. López	1	COM
W. Cardoza	1	CHI
D. Lom	1	MIX
Rodrigo Marroquín	1	MIX


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos