4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Liga MX - Apertura 2011
2010/2011

liga mx, liga mexico, primera division mexicana, liga mx apertura, primera division mexicana apertura, liga bbva mx, liga bbva mexico,liga mexicana,apertura mexico

Liga MX - Apertura 2011

  • Monterrey
  • Santos Laguna
  • Tigres UANL
  • Chivas Guadalajara
  • Necaxa
  • Tecos
  • América
  • San Luis
  • Pachuca
  • Toluca
  • Atlante FC
  • Atlas Guadalajara
  • Cruz Azul
  • Chiapas
  • Pumas UNAM
  • CA Morelia
  • Puebla
  • Querétaro
Jornada 1
25 Jul 10 CA MoreliaCA Morelia 1 - 0 Atlas GuadalajaraAtlas ...
25 Jul 10 Pumas UNAMPumas UNAM 2 - 1 TolucaToluca ...
25 Jul 10 Atlante FCAtlante FC 1 - 4 Santos LagunaSantos ...
25 Jul 10 San LuisSan Luis 1 - 1 MonterreyMonterrey ...
25 Jul 10 PachucaPachuca 3 - 0 AméricaAmérica ...
25 Jul 10 Chivas GuadalajaraChivas 0 - 0 PueblaPuebla ...
25 Jul 10 Tigres UANLTigres UANL 0 - 1 QuerétaroQuerétaro ...
25 Jul 10 ChiapasChiapas 1 - 1 NecaxaNecaxa ...
24 Jul 10 TecosTecos 0 - 3 Cruz AzulCruz Azul ...
Jornada 2
07 Oct 10 Chivas GuadalajaraChivas 0 - 1 CA MoreliaCA Morelia ...
01 Ago 10 AméricaAmérica 3 - 0 ChiapasChiapas ...
01 Ago 10 TolucaToluca 1 - 1 PachucaPachuca ...
01 Ago 10 PueblaPuebla 2 - 1 San LuisSan Luis ...
01 Ago 10 Santos LagunaSantos 4 - 0 Pumas UNAMPumas UNAM ...
01 Ago 10 MonterreyMonterrey 3 - 2 TecosTecos ...
01 Ago 10 Cruz AzulCruz Azul 2 - 0 Atlante FCAtlante FC ...
01 Ago 10 QuerétaroQuerétaro 2 - 1 Atlas GuadalajaraAtlas ...
31 Jul 10 NecaxaNecaxa 0 - 2 Tigres UANLTigres UANL ...
Jornada 3
09 Ago 10 TecosTecos 1 - 3 PueblaPuebla ...
08 Ago 10 CA MoreliaCA Morelia 6 - 0 QuerétaroQuerétaro ...
08 Ago 10 Pumas UNAMPumas UNAM 2 - 0 Cruz AzulCruz Azul ...
08 Ago 10 Atlante FCAtlante FC 1 - 2 MonterreyMonterrey ...
08 Ago 10 San LuisSan Luis 0 - 1 Chivas GuadalajaraChivas ...
08 Ago 10 Atlas GuadalajaraAtlas 0 - 1 NecaxaNecaxa ...
08 Ago 10 PachucaPachuca 0 - 3 Santos LagunaSantos ...
08 Ago 10 Tigres UANLTigres UANL 1 - 1 AméricaAmérica ...
08 Ago 10 ChiapasChiapas 1 - 1 TolucaToluca ...
Jornada 4
06 Sep 10 Chivas GuadalajaraChivas 3 - 0 TecosTecos ...
15 Ago 10 AméricaAmérica 1 - 1 Atlas GuadalajaraAtlas ...
15 Ago 10 TolucaToluca 1 - 1 Tigres UANLTigres UANL ...
15 Ago 10 PueblaPuebla 1 - 1 Atlante FCAtlante FC ...
15 Ago 10 San LuisSan Luis 1 - 0 CA MoreliaCA Morelia ...
15 Ago 10 Santos LagunaSantos 1 - 0 ChiapasChiapas ...
15 Ago 10 MonterreyMonterrey 5 - 2 Pumas UNAMPumas UNAM 1
15 Ago 10 Cruz AzulCruz Azul 4 - 1 PachucaPachuca ...
14 Ago 10 NecaxaNecaxa 1 - 1 QuerétaroQuerétaro ...
Jornada 5
22 Ago 10 QuerétaroQuerétaro 0 - 1 AméricaAmérica ...
22 Ago 10 Pumas UNAMPumas UNAM 4 - 1 PueblaPuebla ...
22 Ago 10 CA MoreliaCA Morelia 1 - 0 NecaxaNecaxa ...
22 Ago 10 Atlante FCAtlante FC 2 - 1 Chivas GuadalajaraChivas ...
22 Ago 10 Atlas GuadalajaraAtlas 0 - 1 TolucaToluca ...
22 Ago 10 Tigres UANLTigres UANL 1 - 0 Santos LagunaSantos ...
22 Ago 10 PachucaPachuca 2 - 2 MonterreyMonterrey ...
22 Ago 10 ChiapasChiapas 2 - 3 Cruz AzulCruz Azul ...
21 Ago 10 TecosTecos 3 - 2 San LuisSan Luis ...
Jornada 6
29 Ago 10 AméricaAmérica 1 - 1 NecaxaNecaxa ...
29 Ago 10 PueblaPuebla 3 - 1 PachucaPachuca ...
29 Ago 10 TolucaToluca 2 - 0 QuerétaroQuerétaro ...
29 Ago 10 San LuisSan Luis 2 - 1 Atlante FCAtlante FC ...
29 Ago 10 Chivas GuadalajaraChivas 0 - 0 Pumas UNAMPumas UNAM ...
29 Ago 10 Santos LagunaSantos 3 - 1 Atlas GuadalajaraAtlas ...
29 Ago 10 MonterreyMonterrey 1 - 1 ChiapasChiapas ...
29 Ago 10 Cruz AzulCruz Azul 3 - 2 Tigres UANLTigres UANL ...
28 Ago 10 TecosTecos 1 - 1 CA MoreliaCA Morelia ...
Jornada 7
12 Sep 10 Pumas UNAMPumas UNAM 0 - 1 San LuisSan Luis ...
12 Sep 10 CA MoreliaCA Morelia 0 - 2 AméricaAmérica ...
12 Sep 10 Atlante FCAtlante FC 0 - 1 TecosTecos ...
12 Sep 10 Atlas GuadalajaraAtlas 1 - 3 Cruz AzulCruz Azul ...
12 Sep 10 PachucaPachuca 1 - 1 Chivas GuadalajaraChivas ...
12 Sep 10 Tigres UANLTigres UANL 0 - 1 MonterreyMonterrey ...
12 Sep 10 ChiapasChiapas 4 - 0 PueblaPuebla ...
12 Sep 10 QuerétaroQuerétaro 5 - 2 Santos LagunaSantos ...
11 Sep 10 NecaxaNecaxa 1 - 1 TolucaToluca ...
Jornada 8
19 Sep 10 PueblaPuebla 1 - 3 Tigres UANLTigres UANL ...
19 Sep 10 TolucaToluca 2 - 1 AméricaAmérica ...
19 Sep 10 Atlante FCAtlante FC 2 - 0 CA MoreliaCA Morelia ...
19 Sep 10 San LuisSan Luis 1 - 0 PachucaPachuca ...
19 Sep 10 Chivas GuadalajaraChivas 0 - 3 ChiapasChiapas ...
19 Sep 10 Santos LagunaSantos 2 - 1 NecaxaNecaxa ...
19 Sep 10 MonterreyMonterrey 2 - 0 Atlas GuadalajaraAtlas ...
19 Sep 10 Cruz AzulCruz Azul 3 - 0 QuerétaroQuerétaro ...
18 Sep 10 TecosTecos 2 - 2 Pumas UNAMPumas UNAM ...
Jornada 9
27 Sep 10 AméricaAmérica 3 - 2 Santos LagunaSantos ...
26 Sep 10 Pumas UNAMPumas UNAM 2 - 2 Atlante FCAtlante FC ...
26 Sep 10 CA MoreliaCA Morelia 1 - 2 TolucaToluca ...
26 Sep 10 Tigres UANLTigres UANL 1 - 1 Chivas GuadalajaraChivas ...
26 Sep 10 Atlas GuadalajaraAtlas 1 - 0 PueblaPuebla ...
26 Sep 10 PachucaPachuca 3 - 1 TecosTecos ...
26 Sep 10 ChiapasChiapas 2 - 1 San LuisSan Luis ...
26 Sep 10 QuerétaroQuerétaro 0 - 0 MonterreyMonterrey ...
25 Sep 10 NecaxaNecaxa 2 - 1 Cruz AzulCruz Azul 2
Jornada 10
03 Oct 10 Cruz AzulCruz Azul 1 - 0 AméricaAmérica ...
03 Oct 10 Chivas GuadalajaraChivas 2 - 2 Atlas GuadalajaraAtlas ...
03 Oct 10 PueblaPuebla 2 - 0 QuerétaroQuerétaro ...
03 Oct 10 Pumas UNAMPumas UNAM 1 - 0 CA MoreliaCA Morelia ...
03 Oct 10 Atlante FCAtlante FC 1 - 3 PachucaPachuca ...
03 Oct 10 San LuisSan Luis 1 - 0 Tigres UANLTigres UANL ...
03 Oct 10 Santos LagunaSantos 2 - 0 TolucaToluca ...
03 Oct 10 MonterreyMonterrey 2 - 1 NecaxaNecaxa ...
02 Oct 10 TecosTecos 0 - 0 ChiapasChiapas ...
Jornada 11
10 Oct 10 AméricaAmérica 0 - 0 MonterreyMonterrey ...
10 Oct 10 CA MoreliaCA Morelia 0 - 0 Santos LagunaSantos ...
10 Oct 10 TolucaToluca 0 - 0 Cruz AzulCruz Azul ...
10 Oct 10 Atlas GuadalajaraAtlas 2 - 1 San LuisSan Luis ...
10 Oct 10 Tigres UANLTigres UANL 5 - 0 TecosTecos ...
10 Oct 10 PachucaPachuca 3 - 2 Pumas UNAMPumas UNAM ...
10 Oct 10 QuerétaroQuerétaro 2 - 2 Chivas GuadalajaraChivas ...
10 Oct 10 ChiapasChiapas 2 - 0 Atlante FCAtlante FC ...
09 Oct 10 NecaxaNecaxa 1 - 0 PueblaPuebla ...
Jornada 12
17 Oct 10 MonterreyMonterrey 2 - 0 TolucaToluca ...
17 Oct 10 PachucaPachuca 1 - 1 CA MoreliaCA Morelia ...
17 Oct 10 Chivas GuadalajaraChivas 1 - 0 NecaxaNecaxa ...
17 Oct 10 San LuisSan Luis 3 - 2 QuerétaroQuerétaro ...
17 Oct 10 Cruz AzulCruz Azul 3 - 0 Santos LagunaSantos ...
16 Oct 10 TecosTecos 2 - 1 Atlas GuadalajaraAtlas ...
17 Oct 10 Atlante FCAtlante FC 1 - 1 Tigres UANLTigres UANL ...
17 Oct 10 PueblaPuebla 2 - 2 AméricaAmérica ...
17 Oct 10 Pumas UNAMPumas UNAM 1 - 0 ChiapasChiapas ...
Jornada 13
23 Oct 10 NecaxaNecaxa 0 - 2 San LuisSan Luis ...
24 Oct 10 ChiapasChiapas 2 - 0 PachucaPachuca ...
24 Oct 10 QuerétaroQuerétaro 1 - 0 TecosTecos ...
24 Oct 10 Santos LagunaSantos 1 - 2 MonterreyMonterrey ...
24 Oct 10 Tigres UANLTigres UANL 2 - 0 Pumas UNAMPumas UNAM ...
24 Oct 10 Atlas GuadalajaraAtlas 3 - 1 Atlante FCAtlante FC ...
24 Oct 10 CA MoreliaCA Morelia 1 - 1 Cruz AzulCruz Azul ...
24 Oct 10 TolucaToluca 2 - 1 PueblaPuebla ...
25 Oct 10 AméricaAmérica 0 - 0 Chivas GuadalajaraChivas ...
Jornada 14
27 Oct 10 PachucaPachuca 2 - 3 Tigres UANLTigres UANL ...
27 Oct 10 Pumas UNAMPumas UNAM 1 - 1 Atlas GuadalajaraAtlas ...
28 Oct 10 TecosTecos 0 - 2 NecaxaNecaxa ...
28 Oct 10 ChiapasChiapas 0 - 0 CA MoreliaCA Morelia ...
28 Oct 10 PueblaPuebla 0 - 1 Santos LagunaSantos ...
28 Oct 10 Chivas GuadalajaraChivas 0 - 0 TolucaToluca ...
28 Oct 10 MonterreyMonterrey 2 - 4 Cruz AzulCruz Azul ...
28 Oct 10 Atlante FCAtlante FC 1 - 0 QuerétaroQuerétaro ...
29 Oct 10 San LuisSan Luis 1 - 2 AméricaAmérica ...
Jornada 15
31 Oct 10 Cruz AzulCruz Azul 1 - 0 PueblaPuebla ...
31 Oct 10 QuerétaroQuerétaro 2 - 1 Pumas UNAMPumas UNAM ...
31 Oct 10 Tigres UANLTigres UANL 0 - 0 ChiapasChiapas ...
31 Oct 10 Santos LagunaSantos 1 - 1 Chivas GuadalajaraChivas ...
31 Oct 10 Atlas GuadalajaraAtlas 1 - 2 PachucaPachuca ...
31 Oct 10 CA MoreliaCA Morelia 0 - 2 MonterreyMonterrey ...
31 Oct 10 TolucaToluca 1 - 2 San LuisSan Luis ...
01 Nov 10 AméricaAmérica 4 - 1 TecosTecos ...
01 Nov 10 NecaxaNecaxa 1 - 2 Atlante FCAtlante FC 1
Jornada 16
06 Nov 10 TecosTecos 4 - 2 TolucaToluca ...
07 Nov 10 ChiapasChiapas 2 - 1 Atlas GuadalajaraAtlas ...
07 Nov 10 San LuisSan Luis 1 - 1 Santos LagunaSantos ...
07 Nov 10 Tigres UANLTigres UANL 0 - 1 CA MoreliaCA Morelia ...
07 Nov 10 Chivas GuadalajaraChivas 0 - 0 Cruz AzulCruz Azul ...
07 Nov 10 PachucaPachuca 2 - 1 QuerétaroQuerétaro ...
07 Nov 10 Atlante FCAtlante FC 0 - 1 AméricaAmérica ...
07 Nov 10 PueblaPuebla 2 - 0 MonterreyMonterrey ...
07 Nov 10 Pumas UNAMPumas UNAM 2 - 0 NecaxaNecaxa ...
Jornada 17
13 Nov 10 NecaxaNecaxa 1 - 2 PachucaPachuca ...
14 Nov 10 Cruz AzulCruz Azul 1 - 0 San LuisSan Luis ...
14 Nov 10 QuerétaroQuerétaro 1 - 1 ChiapasChiapas ...
14 Nov 10 MonterreyMonterrey 2 - 3 Chivas GuadalajaraChivas ...
14 Nov 10 Santos LagunaSantos 1 - 0 TecosTecos ...
14 Nov 10 Atlas GuadalajaraAtlas 2 - 2 Tigres UANLTigres UANL ...
14 Nov 10 CA MoreliaCA Morelia 3 - 3 PueblaPuebla ...
14 Nov 10 TolucaToluca 1 - 1 Atlante FCAtlante FC ...
14 Nov 10 AméricaAmérica 0 - 1 Pumas UNAMPumas UNAM 1

Clasificación

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

  USO DE MEMORIA  
6,165,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.1601
Total Execution Time  0.1622
  CADENA URL  
/apertura_mexico2011/grupo1/calendario
  GET DATOS  
$_GET['/apertura_mexico2011/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_mexico2011'
0.0044  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  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 = 1208 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0044  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 calendars2011 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1208 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:47:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 07:47:44' 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=4 AND last_update > '2024-04-28 07:47:44' 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=3 AND last_update > '2024-04-28 07:47:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0028  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2011 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0231  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 events2011 e ON e.player_id = p.id AND e.league_id = 1208 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1208 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.0310  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 events2011 e ON e.player_id = p.id AND e.league_id = 1208 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1208 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 events2011 e ON e.player_id = p.id AND e.league_id = 1208 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1208 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 `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