4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
04 Ene 14 CA MoreliaCA Morelia 0 - 1 QuerétaroQuerétaro ...
04 Ene 14 Santos LagunaSantos 1 - 1 Chivas GuadalajaraChivas ...
05 Ene 14 AméricaAmérica 3 - 0 Tigres UANLTigres UANL ...
05 Ene 14 MonterreyMonterrey 0 - 0 Cruz AzulCruz Azul ...
05 Ene 14 PachucaPachuca 0 - 1 TolucaToluca ...
05 Ene 14 ChiapasChiapas 1 - 1 VeracruzVeracruz ...
05 Ene 14 Atlas GuadalajaraAtlas 0 - 0 TijuanaTijuana ...
05 Ene 14 Pumas UNAMPumas UNAM 2 - 2 PueblaPuebla ...
06 Ene 14 Atlante FCAtlante FC 1 - 1 LeónLeón ...
Ver jornada
Jornada 2
11 Ene 14 QuerétaroQuerétaro 1 - 0 Pumas UNAMPumas UNAM ...
11 Ene 14 TijuanaTijuana 1 - 0 AméricaAmérica ...
12 Ene 14 VeracruzVeracruz 2 - 1 Atlante FCAtlante FC ...
12 Ene 14 Cruz AzulCruz Azul 2 - 1 Santos LagunaSantos ...
12 Ene 14 Tigres UANLTigres UANL 0 - 0 PachucaPachuca ...
12 Ene 14 LeónLeón 3 - 1 Atlas GuadalajaraAtlas ...
12 Ene 14 PueblaPuebla 1 - 1 MonterreyMonterrey ...
12 Ene 14 TolucaToluca 2 - 2 CA MoreliaCA Morelia ...
13 Ene 14 Chivas GuadalajaraChivas 1 - 0 ChiapasChiapas ...
Ver jornada
Jornada 3
18 Ene 14 CA MoreliaCA Morelia 2 - 0 Tigres UANLTigres UANL ...
18 Ene 14 Santos LagunaSantos 0 - 0 PueblaPuebla ...
19 Ene 14 VeracruzVeracruz 1 - 1 Chivas GuadalajaraChivas ...
19 Ene 14 AméricaAmérica 1 - 0 LeónLeón ...
19 Ene 14 MonterreyMonterrey 3 - 1 QuerétaroQuerétaro ...
19 Ene 14 PachucaPachuca 2 - 1 TijuanaTijuana ...
19 Ene 14 ChiapasChiapas 0 - 1 Cruz AzulCruz Azul ...
19 Ene 14 Atlas GuadalajaraAtlas 0 - 1 Atlante FCAtlante FC ...
19 Ene 14 Pumas UNAMPumas UNAM 0 - 2 TolucaToluca ...
Ver jornada
Jornada 4
25 Ene 14 QuerétaroQuerétaro 0 - 0 Santos LagunaSantos ...
25 Ene 14 TijuanaTijuana 1 - 0 CA MoreliaCA Morelia ...
26 Ene 14 Cruz AzulCruz Azul 4 - 0 VeracruzVeracruz ...
26 Ene 14 Tigres UANLTigres UANL 1 - 2 Pumas UNAMPumas UNAM ...
26 Ene 14 LeónLeón 1 - 3 PachucaPachuca ...
26 Ene 14 Atlas GuadalajaraAtlas 1 - 2 AméricaAmérica ...
26 Ene 14 PueblaPuebla 2 - 3 ChiapasChiapas ...
26 Ene 14 TolucaToluca 2 - 0 MonterreyMonterrey ...
27 Ene 14 Atlante FCAtlante FC 1 - 1 Chivas GuadalajaraChivas ...
Ver jornada
Jornada 5
01 Feb 14 CA MoreliaCA Morelia 0 - 0 LeónLeón ...
02 Feb 14 Santos LagunaSantos 2 - 0 TolucaToluca ...
02 Feb 14 VeracruzVeracruz 0 - 1 PueblaPuebla ...
02 Feb 14 AméricaAmérica 1 - 0 Atlante FCAtlante FC ...
02 Feb 14 MonterreyMonterrey 0 - 0 Tigres UANLTigres UANL ...
02 Feb 14 PachucaPachuca 0 - 1 Atlas GuadalajaraAtlas ...
02 Feb 14 Chivas GuadalajaraChivas 0 - 2 Cruz AzulCruz Azul ...
02 Feb 14 ChiapasChiapas 1 - 0 QuerétaroQuerétaro ...
02 Feb 14 Pumas UNAMPumas UNAM 3 - 0 TijuanaTijuana ...
Ver jornada
Jornada 6
08 Feb 14 TijuanaTijuana 2 - 1 MonterreyMonterrey ...
09 Feb 14 AméricaAmérica 0 - 1 PachucaPachuca 1
09 Feb 14 Tigres UANLTigres UANL 1 - 1 Santos LagunaSantos ...
09 Feb 14 LeónLeón 1 - 2 Pumas UNAMPumas UNAM ...
09 Feb 14 Atlas GuadalajaraAtlas 1 - 1 CA MoreliaCA Morelia ...
09 Feb 14 PueblaPuebla 0 - 1 Chivas GuadalajaraChivas ...
09 Feb 14 TolucaToluca 2 - 0 ChiapasChiapas ...
10 Feb 14 QuerétaroQuerétaro 2 - 0 VeracruzVeracruz ...
10 Feb 14 Atlante FCAtlante FC 1 - 4 Cruz AzulCruz Azul ...
Ver jornada
Jornada 7
15 Feb 14 CA MoreliaCA Morelia 1 - 0 AméricaAmérica ...
15 Feb 14 Santos LagunaSantos 3 - 2 TijuanaTijuana ...
16 Feb 14 VeracruzVeracruz 0 - 3 TolucaToluca ...
16 Feb 14 Cruz AzulCruz Azul 1 - 0 PueblaPuebla ...
16 Feb 14 MonterreyMonterrey 0 - 2 LeónLeón ...
16 Feb 14 PachucaPachuca 0 - 1 Atlante FCAtlante FC ...
16 Feb 14 ChiapasChiapas 0 - 0 Tigres UANLTigres UANL ...
16 Feb 14 Pumas UNAMPumas UNAM 1 - 1 Atlas GuadalajaraAtlas ...
17 Feb 14 Chivas GuadalajaraChivas 2 - 1 QuerétaroQuerétaro ...
Ver jornada
Jornada 8
22 Feb 14 QuerétaroQuerétaro 1 - 3 Cruz AzulCruz Azul ...
22 Feb 14 TijuanaTijuana 0 - 3 ChiapasChiapas ...
23 Feb 14 AméricaAmérica 1 - 3 Pumas UNAMPumas UNAM ...
23 Feb 14 Tigres UANLTigres UANL 1 - 0 VeracruzVeracruz ...
23 Feb 14 PachucaPachuca 3 - 0 CA MoreliaCA Morelia ...
23 Feb 14 LeónLeón 4 - 2 Santos LagunaSantos ...
23 Feb 14 Atlas GuadalajaraAtlas 0 - 1 MonterreyMonterrey ...
23 Feb 14 TolucaToluca 1 - 0 Chivas GuadalajaraChivas ...
24 Feb 14 Atlante FCAtlante FC 0 - 0 PueblaPuebla ...
Ver jornada
Jornada 9
01 Mar 14 CA MoreliaCA Morelia 1 - 2 Atlante FCAtlante FC ...
01 Mar 14 Santos LagunaSantos 2 - 3 Atlas GuadalajaraAtlas ...
02 Mar 14 VeracruzVeracruz 1 - 1 TijuanaTijuana ...
02 Mar 14 Cruz AzulCruz Azul 1 - 0 TolucaToluca ...
02 Mar 14 MonterreyMonterrey 1 - 2 AméricaAmérica ...
02 Mar 14 ChiapasChiapas 0 - 3 LeónLeón ...
02 Mar 14 PueblaPuebla 1 - 0 QuerétaroQuerétaro ...
02 Mar 14 Pumas UNAMPumas UNAM 0 - 0 PachucaPachuca ...
03 Mar 14 Chivas GuadalajaraChivas 0 - 0 Tigres UANLTigres UANL ...
Ver jornada
Jornada 10
08 Mar 14 CA MoreliaCA Morelia 3 - 1 Pumas UNAMPumas UNAM ...
08 Mar 14 LeónLeón 0 - 1 VeracruzVeracruz ...
08 Mar 14 TolucaToluca 3 - 0 PueblaPuebla ...
08 Mar 14 TijuanaTijuana 2 - 0 Chivas GuadalajaraChivas ...
09 Mar 14 AméricaAmérica 2 - 4 Santos LagunaSantos ...
09 Mar 14 Tigres UANLTigres UANL 3 - 0 Cruz AzulCruz Azul ...
09 Mar 14 PachucaPachuca 2 - 0 MonterreyMonterrey ...
09 Mar 14 Atlas GuadalajaraAtlas 2 - 2 ChiapasChiapas ...
10 Mar 14 Atlante FCAtlante FC 4 - 2 QuerétaroQuerétaro ...
Ver jornada
Jornada 11
15 Mar 14 QuerétaroQuerétaro 0 - 2 TolucaToluca ...
16 Mar 14 VeracruzVeracruz 0 - 1 Atlas GuadalajaraAtlas ...
16 Mar 14 Cruz AzulCruz Azul 2 - 1 TijuanaTijuana ...
16 Mar 14 Santos LagunaSantos 3 - 1 PachucaPachuca ...
16 Mar 14 MonterreyMonterrey 0 - 1 CA MoreliaCA Morelia ...
16 Mar 14 ChiapasChiapas 2 - 2 AméricaAmérica ...
16 Mar 14 PueblaPuebla 0 - 1 Tigres UANLTigres UANL ...
16 Mar 14 Pumas UNAMPumas UNAM 5 - 0 Atlante FCAtlante FC ...
17 Mar 14 Chivas GuadalajaraChivas 1 - 0 LeónLeón ...
Ver jornada
Jornada 12
22 Mar 14 CA MoreliaCA Morelia 2 - 2 Santos LagunaSantos ...
22 Mar 14 TijuanaTijuana 3 - 1 PueblaPuebla ...
23 Mar 14 AméricaAmérica 0 - 0 VeracruzVeracruz ...
23 Mar 14 Tigres UANLTigres UANL 0 - 2 QuerétaroQuerétaro ...
23 Mar 14 PachucaPachuca 2 - 0 ChiapasChiapas ...
23 Mar 14 LeónLeón 0 - 0 Cruz AzulCruz Azul ...
23 Mar 14 Atlas GuadalajaraAtlas 1 - 1 Chivas GuadalajaraChivas ...
23 Mar 14 Pumas UNAMPumas UNAM 1 - 2 MonterreyMonterrey 1
24 Mar 14 Atlante FCAtlante FC 2 - 1 TolucaToluca ...
Ver jornada
Jornada 13
29 Mar 14 QuerétaroQuerétaro 2 - 1 TijuanaTijuana ...
29 Mar 14 Santos LagunaSantos 2 - 1 Pumas UNAMPumas UNAM ...
30 Mar 14 VeracruzVeracruz 3 - 1 PachucaPachuca ...
30 Mar 14 Cruz AzulCruz Azul 1 - 3 Atlas GuadalajaraAtlas ...
30 Mar 14 MonterreyMonterrey 3 - 2 Atlante FCAtlante FC ...
30 Mar 14 TolucaToluca 2 - 1 Tigres UANLTigres UANL ...
30 Mar 14 ChiapasChiapas 1 - 0 CA MoreliaCA Morelia ...
30 Mar 14 PueblaPuebla 1 - 1 LeónLeón ...
31 Mar 14 Chivas GuadalajaraChivas 0 - 4 AméricaAmérica 4
Ver jornada
Jornada 14
05 Abr 14 CA MoreliaCA Morelia 1 - 1 VeracruzVeracruz ...
05 Abr 14 TijuanaTijuana 3 - 1 TolucaToluca ...
06 Abr 14 AméricaAmérica 1 - 2 Cruz AzulCruz Azul ...
06 Abr 14 PachucaPachuca 1 - 3 Chivas GuadalajaraChivas ...
06 Abr 14 MonterreyMonterrey 2 - 2 Santos LagunaSantos ...
06 Abr 14 LeónLeón 1 - 1 QuerétaroQuerétaro ...
06 Abr 14 Atlas GuadalajaraAtlas 0 - 0 PueblaPuebla ...
06 Abr 14 Pumas UNAMPumas UNAM 2 - 1 ChiapasChiapas ...
07 Abr 14 Atlante FCAtlante FC 0 - 2 Tigres UANLTigres UANL ...
Ver jornada
Jornada 15
12 Abr 14 QuerétaroQuerétaro 1 - 0 Atlas GuadalajaraAtlas ...
13 Abr 14 VeracruzVeracruz 1 - 1 Pumas UNAMPumas UNAM ...
13 Abr 14 Cruz AzulCruz Azul 2 - 2 PachucaPachuca ...
13 Abr 14 Tigres UANLTigres UANL 1 - 1 TijuanaTijuana ...
13 Abr 14 ChiapasChiapas 1 - 1 MonterreyMonterrey ...
13 Abr 14 TolucaToluca 2 - 1 LeónLeón ...
13 Abr 14 PueblaPuebla 0 - 1 AméricaAmérica ...
14 Abr 14 Chivas GuadalajaraChivas 1 - 1 CA MoreliaCA Morelia ...
14 Abr 14 Santos LagunaSantos 4 - 3 Atlante FCAtlante FC ...
Ver jornada
Jornada 16
19 Abr 14 CA MoreliaCA Morelia 5 - 1 Cruz AzulCruz Azul ...
20 Abr 14 AméricaAmérica 0 - 0 QuerétaroQuerétaro ...
20 Abr 14 Santos LagunaSantos 2 - 3 ChiapasChiapas ...
20 Abr 14 PachucaPachuca 1 - 2 PueblaPuebla ...
20 Abr 14 MonterreyMonterrey 4 - 1 VeracruzVeracruz ...
20 Abr 14 LeónLeón 3 - 0 Tigres UANLTigres UANL ...
20 Abr 14 Atlas GuadalajaraAtlas 1 - 0 TolucaToluca ...
20 Abr 14 Pumas UNAMPumas UNAM 1 - 0 Chivas GuadalajaraChivas ...
21 Abr 14 Atlante FCAtlante FC 1 - 2 TijuanaTijuana ...
Ver jornada
Jornada 17
26 Abr 14 QuerétaroQuerétaro 3 - 4 PachucaPachuca ...
26 Abr 14 TijuanaTijuana 1 - 2 LeónLeón ...
27 Abr 14 VeracruzVeracruz 2 - 2 Santos LagunaSantos ...
27 Abr 14 Cruz AzulCruz Azul 2 - 1 Pumas UNAMPumas UNAM ...
27 Abr 14 Tigres UANLTigres UANL 2 - 1 Atlas GuadalajaraAtlas ...
27 Abr 14 ChiapasChiapas 5 - 2 Atlante FCAtlante FC ...
27 Abr 14 TolucaToluca 1 - 1 AméricaAmérica 2
27 Abr 14 PueblaPuebla 3 - 1 CA MoreliaCA Morelia ...
28 Abr 14 Chivas GuadalajaraChivas 0 - 1 MonterreyMonterrey ...

Clasificación

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

  USO DE MEMORIA  
6,167,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1393
Total Execution Time  0.1415
  CADENA URL  
/clausura_mexico2014/grupo1/calendario
  GET DATOS  
$_GET['/clausura_mexico2014/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0019  SELECT type FROM routes WHERE alias = 'clausura_mexico2014'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_mexico' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=68 ORDER BY l.group_code ASC
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=68 ORDER BY order_id ASC
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 = 3431 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2014 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 3431 ORDER BY round ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 20:21:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-03 20:21:03' 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-05-03 20:21:03' 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-05-03 20:21:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2014 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0157  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3431 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0194  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3431 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0053  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 3431 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049  SELECT *,(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