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

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 2013

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

Clasificación

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

  USO DE MEMORIA  
6,158,744 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.3742
Total Execution Time  0.3763
  CADENA URL  
/apertura_mexico2013/grupo1/calendario
  GET DATOS  
$_GET['/apertura_mexico2013/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0199  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 68 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1304130,1303039,1297779,1295604,1295599) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=68 ORDER BY order_id ASC
0.0265  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 calendars2013 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 2062 ORDER BY round ASC
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:08:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 07:08:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0131  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 07:08:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 07:08:51' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0413  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 events2013 e ON e.player_id = p.id AND e.league_id = 2062 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2062 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.0332  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 events2013 e ON e.player_id = p.id AND e.league_id = 2062 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2062 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  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 events2013 e ON e.player_id = p.id AND e.league_id = 2062 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 2062 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  SELECT *,(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