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

Chivas Guadalajara

Entrenador: Fernando Gago

Temporada 2021/2022

TEMPORADA 2021/2022

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Pachuca	17	30	15	38
2	Tigres UANL	17	30	20	33
3	Atlas	17	21	15	27
4	América	17	24	17	26
5	Puebla	17	25	19	26
6	Chivas	17	25	21	26
7	Monterrey	17	21	17	26
8	Cruz Azul	17	20	17	25
9	Necaxa	17	21	21	23
10	Atl. Luis	17	21	22	23
11	Pumas UNAM	17	24	21	22
12	Mazatlán	17	20	24	21
13	León	17	17	22	21
14	Santos	17	25	25	20
15	Toluca	17	21	36	19
16	Querétaro	17	18	21	17
17	Tijuana	17	14	26	17
18	FC Juárez	17	10	28	11

TEMPORADA 2020/2021

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Cruz Azul	17	26	11	41
2	América	17	26	14	38
3	Puebla	17	25	14	28
4	Monterrey	17	22	13	28
5	Santos	17	18	13	26
6	León	17	25	23	26
7	Atlas	17	20	15	25
8	Pachuca	17	20	19	23
9	Chivas	17	21	21	23
10	Tigres UANL	17	19	20	23
11	Toluca	17	26	24	22
12	Querétaro	17	19	25	21
13	Mazatlán	17	19	26	21
14	Tijuana	17	19	21	20
15	Pumas UNAM	17	10	12	18
16	FC Juárez	17	13	29	15
17	Atl. Luis	17	20	33	12
18	Necaxa	17	14	29	11

TEMPORADA 2019/2020

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Cruz Azul	10	24	14	22
2	León	10	23	14	21
3	Santos	10	14	14	17
4	América	10	11	11	17
5	Chivas	10	13	11	16
6	Pumas UNAM	10	20	19	15
7	Tigres UANL	10	13	10	14
8	FC Juárez	10	20	18	14
9	CA Morelia	10	17	16	14
10	Puebla	10	7	7	14
11	Pachuca	10	11	12	14
12	Querétaro	10	13	15	14
13	Atl. Luis	10	11	15	13
14	Necaxa	10	17	16	11
15	Toluca	10	16	18	10
16	Tijuana	10	10	16	9
17	Atlas	10	10	17	9
18	Monterrey	10	10	17	5

TEMPORADA 2018/2019

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	León	17	41	14	41
2	Tigres UANL	17	33	16	37
3	Monterrey	17	33	21	30
4	Cruz Azul	17	26	15	30
5	América	17	28	19	29
6	Necaxa	17	32	24	29
7	Pachuca	17	32	26	28
8	Tijuana	17	25	20	28
9	Toluca	17	28	23	25
10	Puebla	17	18	21	24
11	Santos	17	21	23	22
12	Lobos BUAP	17	17	34	20
13	Atlas	17	19	28	19
14	Chivas	17	16	21	18
15	Pumas UNAM	17	19	26	17
16	CA Morelia	17	20	31	13
17	Querétaro	17	11	30	11
18	Veracruz	17	7	34	0

TEMPORADA 2017/2018

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Toluca	17	24	13	36
2	América	17	24	14	29
3	Monterrey	17	30	21	29
4	Santos	17	29	20	29
5	Tigres UANL	17	23	16	28
6	Tijuana	17	18	12	25
7	Pumas UNAM	17	24	24	24
8	CA Morelia	17	22	24	24
9	Pachuca	17	29	27	23
10	Puebla	17	23	24	23
11	Necaxa	17	21	15	22
12	Cruz Azul	17	22	18	22
13	León	17	24	33	22
14	Querétaro	17	13	18	18
15	Atlas	17	17	26	18
16	Veracruz	17	12	25	18
17	Chivas	17	14	24	15
18	Lobos BUAP	17	18	33	9

TEMPORADA 2016/2017

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Tijuana	17	30	22	31
2	Monterrey	17	26	18	27
3	Chivas	17	21	18	27
4	Toluca	17	21	20	27
5	Santos	17	25	20	26
6	Atlas	17	24	20	26
7	Tigres UANL	17	26	12	25
8	CA Morelia	17	19	16	24
9	América	17	19	19	24
10	Pachuca	17	16	16	24
11	Cruz Azul	17	19	20	21
12	Necaxa	17	16	21	21
13	Veracruz	17	14	20	21
14	León	17	21	23	20
15	Querétaro	17	21	27	19
16	Chiapas	17	18	28	19
17	Pumas UNAM	17	21	30	18
18	Puebla	17	18	25	16

TEMPORADA 2015/2016

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Monterrey	17	38	23	37
2	Pachuca	17	31	16	30
3	León	17	29	19	30
4	América	17	34	22	29
5	Chivas	17	26	16	28
6	CA Morelia	17	25	24	28
7	Santos	17	22	20	27
8	Tigres UANL	17	29	19	24
9	Cruz Azul	17	25	24	22
10	Pumas UNAM	17	23	24	22
11	Toluca	17	20	21	22
12	Puebla	17	21	26	22
13	Querétaro	17	21	26	19
14	Tijuana	17	17	26	18
15	Atlas	17	18	26	14
16	Dorados	17	18	32	14
17	Veracruz	17	18	34	14
18	Chiapas	17	16	33	12

TEMPORADA 2014/2015

LIGA MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	América	17	28	18	31
2	Tigres UANL	17	25	17	31
3	Atlas	17	22	20	31
4	Toluca	17	24	18	29
5	Chiapas	17	24	20	28
6	Monterrey	17	23	20	27
7	Pachuca	17	20	18	25
8	Pumas UNAM	17	24	20	24
9	Santos	17	23	24	23
10	León	17	29	27	22
11	Tijuana	17	21	19	21
12	Querétaro	17	23	22	21
13	Cruz Azul	17	16	15	21
14	Leones	17	10	16	17
15	Puebla	17	15	21	16
16	Chivas	17	13	20	16
17	Veracruz	17	8	15	15
18	CA Morelia	17	16	34	10

TEMPORADA 2013/2014

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Cruz Azul	17	28	19	36
2	Toluca	17	25	14	32
3	Pumas UNAM	17	26	20	25
4	Santos	17	33	29	25
5	América	17	21	17	25
6	Pachuca	17	23	21	24
7	Tijuana	17	22	23	24
8	León	17	23	17	23
9	Chiapas	17	23	23	23
10	Monterrey	17	20	20	23
11	CA Morelia	17	21	20	21
12	Atlas	17	17	18	21
13	Querétaro	17	18	22	21
14	Tigres UANL	17	13	17	21
15	Chivas	17	13	18	21
16	Puebla	17	14	19	18
17	Atlante FC	17	22	34	18
18	Veracruz	17	14	25	16

TEMPORADA 2012/2013

LIGA MX - CLAUSURA
Equipo		PJ	GF	GC	Puntos
1	Tigres UANL	17	30	14	35
2	América	17	30	15	32
3	Atlas	17	20	13	32
4	CA Morelia	17	25	18	30
5	Cruz Azul	17	35	20	29
6	Santos	17	20	13	29
7	Pumas UNAM	17	19	14	29
8	Querétaro	17	18	20	24
9	Monterrey	17	22	22	23
10	Tijuana	17	19	21	21
11	Pachuca	17	18	25	20
12	Puebla	17	20	27	19
13	Toluca	17	14	21	18
14	Chiapas	17	21	32	17
15	León	17	14	18	16
16	San Luis	17	19	25	16
17	Chivas	17	15	24	16
18	Atlante FC	17	16	33	13

Competiciones que juega

Grupo 2

Liga MX - Apertura

Pos	Equipos		Pts
1		América	35
2		Atlas Guadalajara	29
3		León	29
4		Tigres UANL	28
5		Santos Laguna	24
6		Toluca	24
7		Puebla	24
8		Cruz Azul	23
9		Monterrey	22
10		Chivas Guadalajara	22
11		Pumas UNAM	21
12		Atl. San Luis	20
13		Mazatlán	20
14		Necaxa	20
15		Pachuca	18
16		FC Juárez	16
17		Querétaro	15
18		Tijuana	15

	Series Finales : América, Atlas Guadalajara, León, Tigres UANL
	Playoffs : Santos Laguna, Toluca, Puebla, Cruz Azul, Monterrey, Chivas Guadalajara, Pumas UNAM, Atl. San Luis

RIVALES EN Leagues Cup

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

RIVALES EN Etapas Finales A.

RIVALES EN Etapas Finales C.

USO DE MEMORIA

7,371,240 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.9571
Total Execution Time	0.9592

CADENA URL

/historico/Guadalajara/2022

GET DATOS

$_GET['/historico/Guadalajara/2022']

POST DATOS

No hay datos POST existentes

CONSULTAS (61)

0.0146	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Guadalajara' AND l.year = 2022 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0128	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1262 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0136	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 = 66176
0.0142	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 = 67466
0.0159	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 = 65761
0.0144	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 = 67344
0.0134	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 = 70661
0.0131	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 = 70802
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1262 AND type_rel = 2
0.0163	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1262 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130	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 (2871,4661,5657,5956,6211) ORDER BY n.cover_points DESC, update_date DESC
0.0136	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 = '1262' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0138	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 = '1262' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 67344 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 66176 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 63173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0126	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 = 65761 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127	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 = 67466 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140	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=1262 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0130	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 (71572,70928,70802,70544,69834,67829,67724,67320) 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.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 67724 AND teamId = 1262
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 70544 AND teamId = 1262
0.0160	SELECT count(id) as num_players from rel_players WHERE league_id = 71572 AND teamId = 1262
0.0164	SELECT count(id) as num_players from rel_players WHERE league_id = 69834 AND teamId = 1262
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 70928 AND teamId = 1262
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 67829 AND teamId = 1262
0.0229	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 1262
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 70802 AND teamId = 1262
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63173 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0140	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 events2022 e ON e.player_id = p.id AND e.league_id = 63173 WHERE rp.league_id = 63173 AND rp.teamId = 1262 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.0136	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 events2022 e ON e.player_id = p.id AND e.league_id = 63173 WHERE rp.league_id = 63173 AND rp.teamId = 1262 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 events2022 e ON e.player_id = p.id AND e.league_id = 63173 WHERE rp.league_id = 63173 AND rp.teamId = 1262 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139	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 = 1262 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130	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 = 63173 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 66176 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 56984 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 60360 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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 = 49953 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 51325 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.0151	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 = 43804 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 48493 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 38666 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 41853 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 33338 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 37583 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 15261 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 20080 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 9007 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 3802 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2398 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 3431 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2062 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2258 AND t.round = 17 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

Chivas Guadalajara

Chivas Guadalajara

Selecciona un equipo

Competiciones que juega

Liga MX - Apertura

RIVALES EN Leagues Cup

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

RIVALES EN Etapas Finales A.

RIVALES EN Etapas Finales C.