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

Cotzumalguapa

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA GUATEMALA - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Juventud	18	33	27	36
2	Suchitepeque	18	34	17	32
3	Iztapa	18	29	21	32
4	Marquense	18	36	15	31
5	Pedro	18	29	25	25
6	Democracia	18	26	28	25
7	Quiché	18	27	31	22
8	Nueva	18	23	24	21
9	Cotzumalguap	18	24	25	18
10	Sololá	18	16	64	13
11	Universidad	18	38	17	35
12	Aurora FC	18	30	21	31
13	Juventud	18	27	25	31
14	Sacachispas	18	21	14	30
15	Mictlán	18	32	20	26
16	Benito	18	22	21	26
17	Deportivo	18	25	22	25
18	Heredia	17	19	18	24
19	Cuilapa FC	18	17	35	15
20	Deportivo	17	10	48	8

TEMPORADA 2022/2023

LIGA GUATEMALA - CLAUSURA
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

TEMPORADA 2021/2022

LIGA GUATEMALA - CLAUSURA
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

TEMPORADA 2020/2021

LIGA GUATEMALA - CLAUSURA
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

TEMPORADA 2019/2020

LIGA GUATEMALA - CLAUSURA
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

TEMPORADA 2018/2019

PRIMERA GUATEMALA - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Chimaltenang	16	21	13	27
2	Marquense	16	18	12	26
3	Quiché	16	22	14	25
4	Cotzumalguap	16	22	16	25
5	Pedro	16	22	20	23
6	Deportivo	16	21	27	21
7	Nueva	16	19	27	19
8	Sololá	16	18	25	18
9	Suchitepeque	16	21	30	16
10	Rosario FC	0	0	0	0
11	Achuapa	18	21	15	27
12	Sansare	18	20	19	26
13	Mixco	18	13	14	26
14	Comunicacion	18	20	17	25
15	Deportivo	18	19	16	25
16	Sacachispas	18	13	14	25
17	Aurora FC	18	15	12	24
18	Carchá	18	14	23	23
19	Universidad	18	17	19	20
20	Mictlán	18	14	17	17

TEMPORADA 2017/2018

PRIMERA GUATEMALA - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Nueva	18	29	19	29
2	Sololá	18	27	20	29
3	Iztapa	18	21	17	28
4	Dep.	18	27	18	27
5	Cotzumalguap	18	18	16	27
6	Deportivo	18	25	26	24
7	Rosario FC	18	18	25	24
8	Chimaltenang	18	14	20	23
9	Escuintla	18	20	28	22
10	Barillas	18	19	29	20
11	Universidad	18	30	20	34
12	Carchá	18	28	19	34
13	Sacachispas	18	21	21	28
14	Sansare	18	20	14	27
15	Aurora FC	18	26	27	27
16	Mixco	18	22	26	24
17	Mictlán	18	19	17	20
18	Quirigua	18	22	29	20
19	Deportivo	18	17	28	18
20	Comunicacion	18	15	19	17

TEMPORADA 2016/2017

PRIMERA GUATEMALA - CLAUSURA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Deportivo	1	1	1	1
2	Iztapa	1	1	1	1
3	Cotzumalguap	1	0	0	1
4	Siquinalá	1	0	0	1

TEMPORADA 2015/2016

PRIMERA GUATEMALA - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Carchá	18	35	19	35
2	Deportivo	18	31	16	33
3	Deportivo	18	25	21	31
4	Aurora FC	18	22	20	30
5	Huehueteco	16	20	11	28
6	Halcones	16	25	23	28
7	Nueva	16	32	23	26
8	Sayaxché	18	21	35	25
9	Dep.	16	23	17	24
10	Heredia	16	23	21	24
11	Iztapa	16	22	20	24
12	Sacachispas	18	17	16	24
13	Barillas	16	10	20	21
14	Quirigua	18	25	29	20
15	Cotzumalguap	16	26	25	19
16	Cabrones	18	28	32	19
17	Comunicacion	18	20	27	18
18	Mixco	18	19	28	18
19	Puerto José	16	12	33	9

TEMPORADA 2000/2001

LIGA GUATEMALA - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Comunicacion	22	53	21	50
2	Municipal	22	43	19	42
3	Cobán	22	53	26	37
4	Marquense	22	27	32	36
5	Xelajú	22	35	30	33
6	Antigua GFC	22	30	29	29
7	Cotzumalguap	22	31	41	29
8	Zacapa	22	25	33	26
9	Aurora FC	22	27	39	23
10	Universidad	22	24	35	20
11	Achuapa	22	22	45	19
12	Carchá	22	15	35	17

Competiciones que juega

Primera Guatemala - Apertura

Pos	Equipos		Pts
1		Universidad San Carlos	35
2		Juventud Pinulteca	34
3		San Benito CF	34
4		Iztapa	32
5		Democracia FC.	29
6		Deportivo Barberena	28
7		Suchitepequez	28
8		Aurora FC	28
9		Marquense	27
10		Quiché	25
11		Sacachispas	24
12		CD San Pedro	22
13		Juventud Copalera	22
14		Cotzumalguapa	21
15		Deportivo Fraijanes	18
16		Mictlán	17
17		Cuilapa FC	16
18		Heredia	14
19		Nueva Concepción	13
20		Sololá	11

	Series Finales : Universidad San Carlos, Juventud Pinulteca
	Playoffs : San Benito CF, Iztapa, Democracia FC., Deportivo Barberena

RIVALES EN Primera Guatemal.

USO DE MEMORIA

6,022,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1596
Total Execution Time	0.1610

CADENA URL

/historico/Santa-Lucia-Cotzumalguapa

GET DATOS

$_GET['/historico/Santa-Lucia-Cotzumalguapa']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0038	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 72351
0.0026	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75115
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=80469 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=235 AND type_rel = 3
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 235 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024	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 (1103323,1098276,1085992,1033637,702901) ORDER BY n.cover_points DESC, update_date DESC
0.0031	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '80469' ORDER BY l.year DESC,cat.coefficient DESC
0.0028	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '80469' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75115 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72351 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=80469 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75115,72351,70794,67999) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 70794 AND teamId = 80469
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 67999 AND teamId = 80469
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72351 AND teamId = 80469
0.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 75115 AND teamId = 80469
0.0027	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 18 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0024	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '80469' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '80469' and rp.type = 4
0.0021	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '80469' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72351 WHERE rp.league_id = 72351 AND rp.teamId = 80469 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72351 WHERE rp.league_id = 72351 AND rp.teamId = 80469 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id 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 = 72351 WHERE rp.league_id = 72351 AND rp.teamId = 80469 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0045	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 80469 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0032	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 = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 75115 AND t.round = 18 ORDER BY team.conference ASC,t.position 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* `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 = 67999 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.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* `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.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* `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.0027	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.0030	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.0025	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.0027	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.0026	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.0029	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 = 44214 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 48574 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 42369 AND t.round = 18 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* `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 = 38877 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 33420 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 37582 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 38630 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044	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 = 19454 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 20268 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables2001` 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 = 27545 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


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

Resultados de Fútbol

Cotzumalguapa

Cotzumalguapa

Selecciona un equipo

Competiciones que juega

Primera Guatemala - Apertura

RIVALES EN Primera Guatemal.

RIVALES EN Primera Guatemal.