4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2010
Temporada Siguiente »
Liga MX - Apertura 2010
2009/2010

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 2010

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

Clasificación

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

  USO DE MEMORIA  
6,159,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0037
Controller Execution Time ( Home / Category )  0.2351
Total Execution Time  0.2389
  CADENA URL  
/apertura_mexico2010/grupo1/calendario
  GET DATOS  
$_GET['/apertura_mexico2010/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0123  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0174  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.0022  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.0049  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 calendars2010 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1207 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 11:59:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 11:59:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0046  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 11:59:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 11:59:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0183  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 events2010 e ON e.player_id = p.id AND e.league_id = 1207 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1207 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.0173  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 events2010 e ON e.player_id = p.id AND e.league_id = 1207 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1207 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 events2010 e ON e.player_id = p.id AND e.league_id = 1207 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1207 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0051  SELECT *,(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