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

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

TEMPORADA 2011/2012

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

TEMPORADA 2010/2011

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

TEMPORADA 2009/2010

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

TEMPORADA 2008/2009

LIGA MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Atlante FC	17	22	16	27
2	Santos	17	22	20	22
3	Pachuca	17	25	25	21
4	Indios	17	18	26	19
5	Monterrey	17	18	26	19
6	Puebla	17	12	21	15
7	Pumas UNAM	17	22	13	26
8	Cruz Azul	17	29	23	26
9	Tecos	17	30	28	25
10	Chivas	17	23	23	25
11	CA Morelia	17	27	20	24
12	América	17	22	23	21
13	San Luis	17	24	20	29
14	Toluca	17	25	16	27
15	Tigres UANL	17	22	16	26
16	Atlas	17	23	27	22
17	Chiapas	17	20	34	18
18	Necaxa	17	17	24	17

TEMPORADA 2007/2008

LIGA MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Toluca	17	27	16	34
2	Pumas UNAM	17	32	19	24
3	Pachuca	17	26	23	24
4	Chiapas	17	22	28	18
5	Puebla	17	16	24	17
6	Tecos	17	24	38	17
7	Santos	17	40	22	38
8	Atlante FC	17	32	19	33
9	América	17	26	22	26
10	Veracruz	17	20	35	18
11	Monterrey	17	18	25	14
12	Atlas	17	23	33	12
13	Chivas	17	28	16	31
14	San Luis	17	31	30	29
15	Cruz Azul	17	27	22	25
16	CA Morelia	17	20	25	22
17	Necaxa	17	23	32	20
18	Tigres UANL	17	16	22	16

TEMPORADA 2006/2007

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

TEMPORADA 2005/2006

LIGA MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	América	17	34	22	38
2	Monterrey	17	32	20	35
3	Necaxa	17	35	31	31
4	Cruz Azul	17	34	20	30
5	Toluca	17	27	21	30
6	Pachuca	17	26	18	28
7	Tecos	17	27	28	24
8	Tigres UANL	17	30	25	22
9	Atlas	17	22	24	21
10	Chiapas	17	30	27	20
11	Santos	17	31	31	20
12	CA Morelia	17	27	29	20
13	Chivas	17	16	22	19
14	Dorados	17	20	31	18
15	San Luis	17	18	25	16
16	Pumas UNAM	17	17	34	16
17	Atlante FC	17	29	37	15
18	Veracruz	17	24	34	15

TEMPORADA 2004/2005

LIGA MX - APERTURA
Equipo		PJ	GF	GC	Puntos
1	Veracruz	17	27	25	35
2	Toluca	17	27	15	32
3	Pachuca	17	30	19	32
4	Atlas	17	34	24	31
5	Chivas	17	34	22	29
6	Monterrey	17	36	34	27
7	Atlante FC	17	27	33	24
8	Tigres UANL	17	37	27	23
9	Pumas UNAM	17	25	31	23
10	CA Morelia	17	29	30	22
11	Necaxa	17	27	26	21
12	Puebla	17	17	23	21
13	América	17	17	23	20
14	Santos	17	22	22	18
15	Chiapas	17	20	29	18
16	Cruz Azul	17	30	37	16
17	Dorados	17	25	32	16
18	Tecos	17	17	29	16

Competiciones que juega

Grupo 2

Liga MX - Clausura

Pos	Equipos		Pts
1		Cruz Azul	36
2		Toluca	32
3		Pumas UNAM	25
4		Santos Laguna	25
5		América	25
6		Pachuca	24
7		Tijuana	24
8		León	23
9		Chiapas	23
10		Monterrey	23
11		CA Morelia	21
12		Atlas Guadalajara	21
13		Querétaro	21
14		Tigres UANL	21
15		Chivas Guadalajara	21
16		Puebla	18
17		Atlante FC	18
18		Veracruz	16

RIVALES EN Copa México - Ap.

RIVALES EN Copa México - Cl.

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.

USO DE MEMORIA

6,910,856 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2259
Total Execution Time	0.2271

CADENA URL

/historico/Guadalajara/2014

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (60)

0.0053	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 = 2014 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.0020	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.0020	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.0021	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.0020	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.0020	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.0027	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 = 3431
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 = 2398
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 = 3462
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 = 20613
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1262 AND type_rel = 2
0.0046	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.0027	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 (607904,6211,2871,4661,5657) ORDER BY n.cover_points DESC, update_date DESC
0.0062	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' ORDER BY l.year DESC,cat.coefficient DESC
0.0034	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 = 2014 ORDER BY l.year DESC,cat.coefficient DESC
0.0039	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.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 = 20613 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 3462 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 = 3431 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 2398 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0040	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 (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (20613,14288,14058,12458,10822,9007,3804,3802) 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.0033	SELECT count(id) as num_players from rel_players WHERE league_id = 9007 AND teamId = 1262
0.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 3802 AND teamId = 1262
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 14058 AND teamId = 1262
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 14288 AND teamId = 1262
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 10822 AND teamId = 1262
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 20613 AND teamId = 1262
0.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 12458 AND teamId = 1262
0.0105	SELECT count(id) as num_players from rel_players WHERE league_id = 3804 AND teamId = 1262
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0049	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 = '1262' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1262' and rp.type = 4
0.0044	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 = '1262' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1262' and rp.type = 4
0.0046	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 events2014 e ON e.player_id = p.id AND e.league_id = 3431 WHERE rp.league_id = 3431 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.0044	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 events2014 e ON e.player_id = p.id AND e.league_id = 3431 WHERE rp.league_id = 3431 AND rp.teamId = 1262 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 events2014 e ON e.player_id = p.id AND e.league_id = 3431 WHERE rp.league_id = 3431 AND rp.teamId = 1262 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0057	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 <= 2014 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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* `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.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* `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
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* `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 = 1534 AND t.round = 17 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 = 1397 AND t.round = 17 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* `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 = 1208 AND t.round = 17 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* `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 = 1278 AND t.round = 17 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* `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 = 998 AND t.round = 17 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 = 1207 AND t.round = 17 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* `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 = 2568 AND t.round = 17 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* `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 = 14251 AND t.round = 17 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* `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 = 276 AND t.round = 17 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* `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 = 14252 AND t.round = 17 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 = 13416 AND t.round = 17 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 = 14253 AND t.round = 17 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 = 13417 AND t.round = 17 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 = 14254 AND t.round = 17 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* `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 = 13418 AND t.round = 17 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* `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 = 14255 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 3431 ORDER BY nameShow LIMIT 100


	¿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 - Clausura

RIVALES EN Copa México - Ap.

RIVALES EN Copa México - Cl.

RIVALES EN Liga MX - Clausu.

RIVALES EN Liga MX - Apertu.