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

Mixco

Entrenador: Fabricio Benitez

Temporada 2023/2024

TEMPORADA 2023/2024

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

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

PRIMERA GUATEMALA - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Xinabajul	18	24	10	34
2	Pedro	18	25	13	34
3	Coatepecano	18	20	14	31
4	Marquense	18	17	11	29
5	Plataneros	18	19	18	27
6	Quiché	18	20	16	24
7	Suchitepeque	18	17	18	23
8	Escuintla	18	10	25	15
9	Puerto José	18	10	22	14
10	Amatitlán	18	11	26	14
11	Mixco	18	21	10	35
12	Mictlán	18	28	14	30
13	Sacachispas	18	18	15	27
14	Zacapa	18	14	17	25
15	Chimaltenang	18	13	18	25
16	Comunicacion	18	26	21	23
17	Juventud	18	19	18	23
18	Deportivo	18	17	21	23
19	Aurora FC	18	14	21	22
20	Agua Blanca	18	15	30	14

TEMPORADA 2020/2021

PRIMERA GUATEMALA - CLAUSURA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Quiché	8	9	6	16
2	Plataneros	8	13	12	11
3	Xinabajul	8	8	7	11
4	Marquense	8	10	11	11
5	Pedro	8	5	9	6
6	Nueva	8	10	7	15
7	Suchitepeque	8	10	7	12
8	Coatepecano	8	9	8	11
9	Sololá	8	6	6	9
10	Puerto José	8	3	10	5
11	Comunicacion	8	14	4	17
12	Chimaltenang	8	7	6	13
13	Aurora FC	8	8	6	12
14	Escuintla	8	9	7	10
15	Deportivo	8	5	20	3
16	Mictlán	8	11	6	16
17	Mixco	8	10	5	14
18	Zacapa	8	6	4	11
19	Carchá	8	7	16	7
20	Sayaxché	8	6	9	6

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 1
Equipo		PJ	GF	GC	Puntos
1	Iztapa	18	25	13	33
2	Nueva	18	21	21	30
3	Cotzumalguap	18	20	16	28
4	Dep.	18	19	15	28
5	Deportivo	18	26	23	27
6	Barillas	18	22	28	24
7	Siquinalá	18	25	24	23
8	Escuintla	18	23	28	23
9	Pedro	18	19	32	20
10	Rosario FC	18	25	25	19
11	Sacachispas	16	21	10	32
12	Deportivo	16	25	18	29
13	Aurora FC	16	21	15	27
14	Deportivo	16	21	11	23
15	Universidad	16	18	12	23
16	Comunicacion	16	25	26	22
17	Sayaxché	16	10	19	18
18	Quirigua	16	19	39	16
19	Mixco	16	10	20	11
20	Zacapa	0	0	0	0

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 2014/2015

PRIMERA GUATEMALA - CLAUSURA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Deportivo	18	37	18	34
2	Cobán	18	23	19	31
3	Mictlán	18	25	20	28
4	Sacachispas	18	21	21	27
5	Mixco	18	25	22	25
6	Heredia	18	30	27	24
7	Sayaxché	18	16	29	24
8	Quirigua	18	24	30	20
9	Zacapa	18	17	24	20
10	Carchá	18	19	27	18

Competiciones que juega

RIVALES EN Liga Guatemala -.

USO DE MEMORIA

6,086,008 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.1485
Total Execution Time	0.1499

CADENA URL

/historico/Mixco

GET DATOS

$_GET['/historico/Mixco']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0040	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 = 75891
0.0024	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 = 75018
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7462 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7462 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0028	SELECT /35 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 (653496,707172,717204,724288,798144) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '7462' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 72135 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 = 75891 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=7462 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (75891,72135) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 75891 AND teamId = 7462
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 72135 AND teamId = 7462
0.0019	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 = 75891 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '7462' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7462' and rp.type = 4
0.0020	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 = '7462' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028	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 = 75891 WHERE rp.league_id = 75891 AND rp.teamId = 7462 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.0024	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 = 75891 WHERE rp.league_id = 75891 AND rp.teamId = 7462 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 75891 WHERE rp.league_id = 75891 AND rp.teamId = 7462 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 7462 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72135 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.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* `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.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* `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.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* `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.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* `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 = 63659 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.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 = 66328 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.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 = 58962 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 61256 AND t.round = 10 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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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 = 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.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* `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.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* `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 = 4143 AND t.round = 18 ORDER BY team.conference 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* `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 = 9273 AND t.round = 18 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

Mixco

Mixco

Selecciona un equipo

Competiciones que juega

RIVALES EN Liga Guatemala -.

RIVALES EN Liga Guatemala -.