4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
22 Jul 12 Toros NezaToros Neza 1 - 1 CafetalerosCafetaleros ...
22 Jul 12 CelayaCelaya 3 - 0 Reboceros de la PiedadReboceros ...
21 Jul 12 Pumas MorelosPumas 0 - 1 Leones NegrosLeones ...
21 Jul 12 TecosTecos 0 - 0 IrapuatoIrapuato ...
21 Jul 12 NecaxaNecaxa 3 - 1 Lobos BUAPLobos BUAP ...
21 Jul 12 Correcaminos UATCorrecamino 3 - 0 Cruz AzulCruz Azul ...
22 Jul 12 DoradosDorados 2 - 1 VeracruzVeracruz ...
Ver jornada
Jornada 2
29 Jul 12 VeracruzVeracruz 0 - 0 CelayaCelaya ...
29 Jul 12 CafetalerosCafetaleros 2 - 0 NecaxaNecaxa ...
29 Jul 12 Reboceros de la PiedadReboceros 1 - 1 TecosTecos ...
29 Jul 12 IrapuatoIrapuato 2 - 2 Pumas MorelosPumas ...
28 Jul 12 Leones NegrosLeones 0 - 1 Venados FCVenados FC ...
27 Jul 12 Lobos BUAPLobos BUAP 1 - 0 Correcaminos UATCorrecamino ...
29 Jul 12 Cruz AzulCruz Azul 1 - 2 DoradosDorados ...
Ver jornada
Jornada 3
05 Ago 12 Reboceros de la PiedadReboceros 2 - 0 VeracruzVeracruz ...
05 Ago 12 Toros NezaToros Neza 4 - 2 Leones NegrosLeones ...
04 Ago 12 Correcaminos UATCorrecamino 3 - 1 CafetalerosCafetaleros ...
04 Ago 12 TecosTecos 2 - 0 Pumas MorelosPumas ...
05 Ago 12 CelayaCelaya 2 - 2 Cruz AzulCruz Azul ...
05 Ago 12 DoradosDorados 2 - 2 Lobos BUAPLobos BUAP ...
05 Ago 12 Venados FCVenados FC 1 - 1 IrapuatoIrapuato ...
Ver jornada
Jornada 4
12 Ago 12 VeracruzVeracruz 2 - 1 TecosTecos ...
11 Ago 12 Pumas MorelosPumas 0 - 0 Venados FCVenados FC ...
11 Ago 12 Leones NegrosLeones 1 - 1 NecaxaNecaxa ...
10 Ago 12 Lobos BUAPLobos BUAP 3 - 0 CelayaCelaya ...
12 Ago 12 Cruz AzulCruz Azul 1 - 3 Reboceros de la PiedadReboceros ...
12 Ago 12 IrapuatoIrapuato 1 - 1 Toros NezaToros Neza ...
12 Ago 12 CafetalerosCafetaleros 0 - 1 DoradosDorados ...
Ver jornada
Jornada 5
19 Ago 12 Reboceros de la PiedadReboceros 1 - 0 Lobos BUAPLobos BUAP ...
19 Ago 12 Toros NezaToros Neza 1 - 0 Pumas MorelosPumas ...
19 Ago 12 VeracruzVeracruz 1 - 1 Cruz AzulCruz Azul ...
18 Ago 12 Correcaminos UATCorrecamino 3 - 1 Leones NegrosLeones ...
18 Ago 12 NecaxaNecaxa 6 - 4 IrapuatoIrapuato ...
18 Ago 12 TecosTecos 2 - 0 Venados FCVenados FC ...
19 Ago 12 CelayaCelaya 0 - 1 CafetalerosCafetaleros ...
Ver jornada
Jornada 6
26 Ago 12 Venados FCVenados FC 1 - 0 Toros NezaToros Neza ...
25 Ago 12 Pumas MorelosPumas 1 - 1 NecaxaNecaxa ...
25 Ago 12 CafetalerosCafetaleros 2 - 3 Reboceros de la PiedadReboceros ...
24 Ago 12 Lobos BUAPLobos BUAP 2 - 1 VeracruzVeracruz ...
26 Ago 12 Cruz AzulCruz Azul 0 - 0 TecosTecos ...
26 Ago 12 IrapuatoIrapuato 1 - 0 Correcaminos UATCorrecamino ...
25 Ago 12 Leones NegrosLeones 0 - 2 DoradosDorados ...
Ver jornada
Jornada 7
01 Sep 12 NecaxaNecaxa 3 - 1 Venados FCVenados FC ...
02 Sep 12 Cruz AzulCruz Azul 1 - 3 Lobos BUAPLobos BUAP ...
02 Sep 12 CelayaCelaya 1 - 1 Leones NegrosLeones ...
02 Sep 12 DoradosDorados 1 - 1 IrapuatoIrapuato ...
02 Sep 12 VeracruzVeracruz 2 - 2 CafetalerosCafetaleros ...
01 Sep 12 Correcaminos UATCorrecamino 4 - 0 Pumas MorelosPumas ...
01 Sep 12 TecosTecos 0 - 0 Toros NezaToros Neza ...
Ver jornada
Jornada 8
14 Sep 12 Pumas MorelosPumas 1 - 1 DoradosDorados ...
15 Sep 12 Leones NegrosLeones 2 - 1 Reboceros de la PiedadReboceros ...
16 Sep 12 Toros NezaToros Neza 3 - 3 NecaxaNecaxa ...
16 Sep 12 IrapuatoIrapuato 0 - 1 CelayaCelaya ...
16 Sep 12 Venados FCVenados FC 3 - 1 Correcaminos UATCorrecamino ...
15 Sep 12 CafetalerosCafetaleros 0 - 1 Cruz AzulCruz Azul ...
14 Sep 12 Lobos BUAPLobos BUAP 1 - 3 TecosTecos ...
Ver jornada
Jornada 9
22 Sep 12 TecosTecos 1 - 2 NecaxaNecaxa ...
23 Sep 12 CelayaCelaya 2 - 1 Pumas MorelosPumas ...
23 Sep 12 DoradosDorados 3 - 0 Venados FCVenados FC ...
23 Sep 12 VeracruzVeracruz 2 - 3 Leones NegrosLeones ...
21 Sep 12 Lobos BUAPLobos BUAP 2 - 0 CafetalerosCafetaleros ...
23 Sep 12 Reboceros de la PiedadReboceros 0 - 1 IrapuatoIrapuato ...
22 Sep 12 Correcaminos UATCorrecamino 0 - 1 Toros NezaToros Neza ...
Ver jornada
Jornada 10
29 Sep 12 Leones NegrosLeones 0 - 1 Cruz AzulCruz Azul ...
30 Sep 12 NecaxaNecaxa 2 - 1 Correcaminos UATCorrecamino ...
30 Sep 12 Toros NezaToros Neza 3 - 2 DoradosDorados ...
30 Sep 12 IrapuatoIrapuato 1 - 1 VeracruzVeracruz ...
29 Sep 12 CafetalerosCafetaleros 1 - 2 TecosTecos ...
30 Sep 12 Venados FCVenados FC 3 - 1 CelayaCelaya ...
29 Sep 12 Pumas MorelosPumas 0 - 0 Reboceros de la PiedadReboceros ...
Ver jornada
Jornada 11
07 Oct 12 Reboceros de la PiedadReboceros 1 - 1 Venados FCVenados FC ...
07 Oct 12 Cruz AzulCruz Azul 3 - 0 IrapuatoIrapuato ...
07 Oct 12 CelayaCelaya 1 - 2 Toros NezaToros Neza ...
07 Oct 12 DoradosDorados 1 - 1 NecaxaNecaxa ...
07 Oct 12 VeracruzVeracruz 1 - 0 Pumas MorelosPumas ...
06 Oct 12 TecosTecos 0 - 0 Correcaminos UATCorrecamino ...
05 Oct 12 Lobos BUAPLobos BUAP 2 - 1 Leones NegrosLeones ...
Ver jornada
Jornada 12
13 Oct 12 Pumas MorelosPumas 1 - 2 Cruz AzulCruz Azul ...
14 Oct 12 Toros NezaToros Neza 0 - 2 Reboceros de la PiedadReboceros ...
14 Oct 12 IrapuatoIrapuato 2 - 0 Lobos BUAPLobos BUAP ...
14 Oct 12 Venados FCVenados FC 1 - 0 VeracruzVeracruz ...
13 Oct 12 Leones NegrosLeones 0 - 2 CafetalerosCafetaleros ...
13 Oct 12 Correcaminos UATCorrecamino 2 - 1 DoradosDorados ...
13 Oct 12 NecaxaNecaxa 1 - 0 CelayaCelaya ...
Ver jornada
Jornada 13
21 Oct 12 Cruz AzulCruz Azul 0 - 0 Venados FCVenados FC ...
21 Oct 12 CelayaCelaya 1 - 1 Correcaminos UATCorrecamino ...
20 Oct 12 TecosTecos 2 - 1 DoradosDorados ...
21 Oct 12 VeracruzVeracruz 0 - 0 Toros NezaToros Neza ...
20 Oct 12 CafetalerosCafetaleros 2 - 1 IrapuatoIrapuato ...
19 Oct 12 Lobos BUAPLobos BUAP 2 - 0 Pumas MorelosPumas ...
20 Oct 12 Reboceros de la PiedadReboceros 1 - 4 NecaxaNecaxa ...
Ver jornada
Jornada 14
27 Oct 12 TecosTecos 2 - 1 Leones NegrosLeones ...
28 Oct 12 NecaxaNecaxa 1 - 0 VeracruzVeracruz ...
28 Oct 12 Correcaminos UATCorrecamino 1 - 1 Reboceros de la PiedadReboceros ...
27 Oct 12 Pumas MorelosPumas 2 - 0 CafetalerosCafetaleros ...
28 Oct 12 Venados FCVenados FC 0 - 0 Lobos BUAPLobos BUAP ...
28 Oct 12 DoradosDorados 4 - 3 CelayaCelaya ...
28 Oct 12 Toros NezaToros Neza 0 - 0 Cruz AzulCruz Azul ...
Ver jornada
Jornada 15
02 Nov 12 Leones NegrosLeones 1 - 1 IrapuatoIrapuato ...
02 Nov 12 Lobos BUAPLobos BUAP 1 - 3 Toros NezaToros Neza ...
03 Nov 12 CafetalerosCafetaleros 0 - 2 Venados FCVenados FC ...
04 Nov 12 VeracruzVeracruz 3 - 0 Correcaminos UATCorrecamino ...
04 Nov 12 CelayaCelaya 3 - 0 TecosTecos ...
04 Nov 12 Cruz AzulCruz Azul 1 - 2 NecaxaNecaxa ...
04 Nov 12 Reboceros de la PiedadReboceros 5 - 0 DoradosDorados ...

Clasificación

Equipo PJ GF GC Puntos
1 Necaxa Necaxa 14 30 18 31
2 Toros Neza Toros Neza 14 19 14 24
3 Tecos Tecos 14 16 12 23
4 Lobos BUAP Lobos BUAP 14 20 17 23
5 Venados FC Venados FC 14 14 12 23
6 Reboceros de la Piedad Reboceros 14 21 16 22
7 Dorados Dorados 14 23 22 22
8 Correcaminos UAT Correcaminos 14 19 16 18
9 Cruz Azul Cruz Azul 14 14 17 17
10 Celaya Celaya 14 18 19 16
11 Irapuato Irapuato 14 16 19 16
12 Veracruz Veracruz 14 14 16 14
13 Cafetaleros Cafetaleros 14 14 20 14
14 Leones Negros Leones 14 14 23 12
15 Pumas Morelos Pumas 14 8 19 8

  USO DE MEMORIA  
5,719,768 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3555
Total Execution Time  0.3577
  CADENA URL  
/apertura_liga_de_ascenso2013/grupo1/calendario
  GET DATOS  
$_GET['/apertura_liga_de_ascenso2013/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0124  SELECT type FROM routes WHERE alias = 'apertura_liga_de_ascenso2013'
0.0252  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 = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0132  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.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 (920880,863232,861248,856474,839257) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=210 ORDER BY order_id ASC
0.0126  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 = 45193 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136  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 = 45193 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-03 21:06:47' 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-03 21:06:47' 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-03 21:06:47' 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=3 AND last_update > '2024-05-03 21:06:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  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 = 2013 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
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 events2013 e ON e.player_id = p.id AND e.league_id = 45193 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 45193 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.0227  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 = 45193 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 45193 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 45193 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 45193 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  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 = 45193 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC