4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
30 Jul 11 NecaxaNecaxa 1 - 0 Mérida BMérida B ...
30 Jul 11 Correcaminos UATCorrecamino 3 - 3 LeónLeón ...
30 Jul 11 Leones NegrosLeones 1 - 1 CelayaCelaya ...
30 Jul 11 Lobos BUAPLobos BUAP 1 - 0 Cruz AzulCruz Azul ...
30 Jul 11 Pumas MorelosPumas 2 - 0 VeracruzVeracruz ...
31 Jul 11 IrapuatoIrapuato 2 - 3 La PiedadLa Piedad ...
31 Jul 11 IndiosIndios 1 - 0 DoradosDorados ...
31 Jul 11 Toros NezaToros Neza 3 - 0 AltamiraAltamira ...
Ver jornada
Jornada 2
06 Ago 11 AltamiraAltamira 0 - 0 Lobos BUAPLobos BUAP ...
06 Ago 11 VeracruzVeracruz 0 - 2 IrapuatoIrapuato ...
07 Ago 11 Mérida BMérida B 1 - 1 IndiosIndios ...
07 Ago 11 LeónLeón 2 - 0 NecaxaNecaxa ...
07 Ago 11 DoradosDorados 2 - 2 Toros NezaToros Neza ...
07 Ago 11 CelayaCelaya 0 - 1 Pumas MorelosPumas ...
07 Ago 11 Cruz AzulCruz Azul 2 - 2 Leones NegrosLeones ...
07 Ago 11 La PiedadLa Piedad 2 - 1 Correcaminos UATCorrecamino ...
Ver jornada
Jornada 3
13 Ago 11 Correcaminos UATCorrecamino 1 - 1 NecaxaNecaxa ...
13 Ago 11 Leones NegrosLeones 0 - 3 AltamiraAltamira ...
13 Ago 11 Pumas MorelosPumas 1 - 0 Cruz AzulCruz Azul ...
14 Ago 11 IrapuatoIrapuato 3 - 1 CelayaCelaya ...
14 Ago 11 IndiosIndios 0 - 1 LeónLeón ...
14 Ago 11 Toros NezaToros Neza 2 - 1 Mérida BMérida B ...
14 Ago 11 Lobos BUAPLobos BUAP 0 - 1 DoradosDorados ...
14 Ago 11 La PiedadLa Piedad 2 - 0 VeracruzVeracruz ...
Ver jornada
Jornada 4
20 Ago 11 AltamiraAltamira 3 - 1 Pumas MorelosPumas ...
20 Ago 11 NecaxaNecaxa 3 - 2 IndiosIndios ...
20 Ago 11 VeracruzVeracruz 1 - 0 Correcaminos UATCorrecamino ...
21 Ago 11 Mérida BMérida B 0 - 0 Lobos BUAPLobos BUAP ...
21 Ago 11 DoradosDorados 3 - 3 Leones NegrosLeones ...
21 Ago 11 LeónLeón 2 - 2 Toros NezaToros Neza ...
21 Ago 11 CelayaCelaya 2 - 1 La PiedadLa Piedad ...
21 Ago 11 Cruz AzulCruz Azul 1 - 0 IrapuatoIrapuato ...
Ver jornada
Jornada 5
27 Ago 11 Correcaminos UATCorrecamino 2 - 0 IndiosIndios ...
27 Ago 11 Leones NegrosLeones 2 - 1 Mérida BMérida B ...
27 Ago 11 VeracruzVeracruz 1 - 1 CelayaCelaya ...
27 Ago 11 Pumas MorelosPumas 1 - 1 DoradosDorados ...
28 Ago 11 IrapuatoIrapuato 6 - 1 AltamiraAltamira ...
28 Ago 11 Toros NezaToros Neza 1 - 0 NecaxaNecaxa ...
28 Ago 11 Lobos BUAPLobos BUAP 1 - 2 LeónLeón ...
28 Ago 11 La PiedadLa Piedad 1 - 0 Cruz AzulCruz Azul ...
Ver jornada
Jornada 6
10 Sep 11 AltamiraAltamira 1 - 0 La PiedadLa Piedad ...
10 Sep 11 NecaxaNecaxa 1 - 1 Lobos BUAPLobos BUAP ...
10 Sep 11 Cruz AzulCruz Azul 1 - 1 VeracruzVeracruz ...
11 Sep 11 Mérida BMérida B 0 - 0 Pumas MorelosPumas ...
11 Sep 11 DoradosDorados 2 - 1 IrapuatoIrapuato ...
11 Sep 11 LeónLeón 1 - 1 Leones NegrosLeones ...
11 Sep 11 IndiosIndios 0 - 2 Toros NezaToros Neza ...
11 Sep 11 CelayaCelaya 3 - 4 Correcaminos UATCorrecamino ...
Ver jornada
Jornada 7
17 Sep 11 Correcaminos UATCorrecamino 4 - 0 Toros NezaToros Neza ...
17 Sep 11 Leones NegrosLeones 0 - 1 NecaxaNecaxa ...
17 Sep 11 VeracruzVeracruz 1 - 0 AltamiraAltamira ...
17 Sep 11 Pumas MorelosPumas 2 - 1 LeónLeón ...
18 Sep 11 IrapuatoIrapuato 1 - 0 Mérida BMérida B ...
18 Sep 11 CelayaCelaya 1 - 1 Cruz AzulCruz Azul ...
18 Sep 11 Lobos BUAPLobos BUAP 1 - 6 IndiosIndios ...
18 Sep 11 La PiedadLa Piedad 4 - 3 DoradosDorados ...
Ver jornada
Jornada 8
24 Sep 11 AltamiraAltamira 0 - 1 CelayaCelaya ...
24 Sep 11 NecaxaNecaxa 1 - 0 Pumas MorelosPumas ...
25 Sep 11 Mérida BMérida B 2 - 3 La PiedadLa Piedad ...
25 Sep 11 LeónLeón 1 - 1 IrapuatoIrapuato ...
25 Sep 11 DoradosDorados 1 - 2 VeracruzVeracruz ...
25 Sep 11 IndiosIndios 0 - 1 Leones NegrosLeones ...
25 Sep 11 Toros NezaToros Neza 2 - 2 Lobos BUAPLobos BUAP ...
25 Sep 11 Cruz AzulCruz Azul 2 - 2 Correcaminos UATCorrecamino ...
Ver jornada
Jornada 9
01 Oct 11 Correcaminos UATCorrecamino 2 - 1 Lobos BUAPLobos BUAP ...
01 Oct 11 Leones NegrosLeones 1 - 0 Toros NezaToros Neza ...
01 Oct 11 VeracruzVeracruz 3 - 0 Mérida BMérida B ...
02 Oct 11 IrapuatoIrapuato 0 - 1 NecaxaNecaxa ...
02 Oct 11 CelayaCelaya 1 - 0 DoradosDorados ...
02 Oct 11 Cruz AzulCruz Azul 1 - 2 AltamiraAltamira ...
02 Oct 11 La PiedadLa Piedad 0 - 0 LeónLeón ...
02 Oct 11 Pumas MorelosPumas 2 - 2 IndiosIndios ...
Ver jornada
Jornada 10
06 Oct 11 Lobos BUAPLobos BUAP 1 - 0 Leones NegrosLeones ...
08 Oct 11 AltamiraAltamira 4 - 4 Correcaminos UATCorrecamino ...
08 Oct 11 NecaxaNecaxa 0 - 1 La PiedadLa Piedad ...
09 Oct 11 Mérida BMérida B 3 - 0 CelayaCelaya ...
09 Oct 11 LeónLeón 3 - 0 VeracruzVeracruz ...
09 Oct 11 DoradosDorados 1 - 1 Cruz AzulCruz Azul ...
09 Oct 11 IndiosIndios 1 - 2 IrapuatoIrapuato ...
09 Oct 11 Toros NezaToros Neza 1 - 1 Pumas MorelosPumas ...
Ver jornada
Jornada 11
15 Oct 11 AltamiraAltamira 2 - 0 DoradosDorados ...
15 Oct 11 Correcaminos UATCorrecamino 2 - 2 Leones NegrosLeones ...
15 Oct 11 VeracruzVeracruz 1 - 1 NecaxaNecaxa ...
15 Oct 11 Pumas MorelosPumas 2 - 2 Lobos BUAPLobos BUAP ...
16 Oct 11 IrapuatoIrapuato 4 - 3 Toros NezaToros Neza ...
16 Oct 11 CelayaCelaya 1 - 1 LeónLeón ...
16 Oct 11 Cruz AzulCruz Azul 0 - 3 Mérida BMérida B ...
16 Oct 11 La PiedadLa Piedad 3 - 1 IndiosIndios ...
Ver jornada
Jornada 12
22 Oct 11 NecaxaNecaxa 1 - 1 CelayaCelaya ...
22 Oct 11 Leones NegrosLeones 0 - 0 Pumas MorelosPumas ...
23 Oct 11 Mérida BMérida B 0 - 0 AltamiraAltamira ...
23 Oct 11 LeónLeón 1 - 1 Cruz AzulCruz Azul ...
23 Oct 11 DoradosDorados 1 - 4 Correcaminos UATCorrecamino ...
23 Oct 11 IndiosIndios 2 - 0 VeracruzVeracruz ...
23 Oct 11 Toros NezaToros Neza 2 - 1 La PiedadLa Piedad ...
23 Oct 11 Lobos BUAPLobos BUAP 1 - 0 IrapuatoIrapuato ...
Ver jornada
Jornada 13
29 Oct 11 AltamiraAltamira 1 - 1 LeónLeón ...
29 Oct 11 Correcaminos UATCorrecamino 2 - 0 Pumas MorelosPumas ...
29 Oct 11 VeracruzVeracruz 2 - 2 Toros NezaToros Neza ...
30 Oct 11 IrapuatoIrapuato 2 - 1 Leones NegrosLeones ...
30 Oct 11 CelayaCelaya 1 - 0 IndiosIndios 4
30 Oct 11 DoradosDorados 3 - 1 Mérida BMérida B ...
30 Oct 11 Cruz AzulCruz Azul 2 - 1 NecaxaNecaxa ...
30 Oct 11 La PiedadLa Piedad 0 - 2 Lobos BUAPLobos BUAP ...
Ver jornada
Jornada 14
05 Nov 11 NecaxaNecaxa 2 - 1 AltamiraAltamira ...
05 Nov 11 Correcaminos UATCorrecamino 2 - 1 Mérida BMérida B ...
05 Nov 11 Leones NegrosLeones 0 - 2 La PiedadLa Piedad ...
05 Nov 11 Lobos BUAPLobos BUAP 0 - 2 VeracruzVeracruz ...
05 Nov 11 Pumas MorelosPumas 1 - 0 IrapuatoIrapuato ...
06 Nov 11 IndiosIndios 2 - 1 Cruz AzulCruz Azul ...
06 Nov 11 LeónLeón 6 - 1 DoradosDorados ...
06 Nov 11 Toros NezaToros Neza 3 - 1 CelayaCelaya ...
Ver jornada
Jornada 15
19 Nov 11 AltamiraAltamira 4 - 2 IndiosIndios ...
19 Nov 11 VeracruzVeracruz 3 - 2 Leones NegrosLeones ...
20 Nov 11 Mérida BMérida B 2 - 1 LeónLeón ...
20 Nov 11 IrapuatoIrapuato 0 - 0 Correcaminos UATCorrecamino ...
20 Nov 11 DoradosDorados 1 - 1 NecaxaNecaxa ...
20 Nov 11 CelayaCelaya 0 - 0 Lobos BUAPLobos BUAP ...
20 Nov 11 La PiedadLa Piedad 3 - 1 Pumas MorelosPumas ...
20 Nov 11 Cruz AzulCruz Azul 1 - 2 Toros NezaToros Neza ...

Clasificación

Equipo PJ GF GC Puntos
1 La Piedad La Piedad 15 26 17 31
2 Correcaminos UAT Correcaminos 15 33 21 27
3 Toros Neza Toros Neza 15 27 22 26
4 León León 15 26 16 23
5 Irapuato Irapuato 15 24 17 23
6 Necaxa Necaxa 15 15 14 23
7 Altamira Altamira 15 22 22 22
8 Veracruz Veracruz 15 17 19 22
9 Pumas Morelos Pumas 15 15 16 21
10 Celaya Celaya 15 15 20 18
11 Lobos BUAP Lobos BUAP 15 13 18 18
12 Leones Negros Leones 15 16 22 15
13 Indios Indios 15 20 24 14
14 Dorados Dorados 15 20 30 14
15 Mérida B Mérida B 15 15 19 13
16 Cruz Azul Cruz Azul 15 14 21 12

  USO DE MEMORIA  
5,834,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4011
Total Execution Time  0.4029
  CADENA URL  
/apertura_liga_de_ascenso2012/grupo1/calendario
  GET DATOS  
$_GET['/apertura_liga_de_ascenso2012/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0126  SELECT type FROM routes WHERE alias = 'apertura_liga_de_ascenso2012'
0.0256  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_liga_de_ascenso' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=210 AND type_rel = 3
0.0133  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 210 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (920880,863232,861248,856474,839257) ORDER BY n.cover_points DESC, update_date DESC
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=210 ORDER BY order_id ASC
0.0127  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 = 1660 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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 calendars2012 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 1660 ORDER BY round ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-01 09:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-01 09:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-01 09:04:39' 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=3 AND last_update > '2024-05-01 09:04:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_liga_de_ascenso' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2012 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0450  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 events2012 e ON e.player_id = p.id AND e.league_id = 1660 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1660 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.0253  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 events2012 e ON e.player_id = p.id AND e.league_id = 1660 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1660 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0136  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 events2012 e ON e.player_id = p.id AND e.league_id = 1660 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 1660 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0140  SELECT *,(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 = 1660 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC