4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2020
 
Ascenso MX - Clausura 2020
2019/2020

torneo clausura ascenso mexico, torneo clausura ascenso mx, clausura ascenso mx, clausura ascenso mexico, ascenso clausura bbva mx, ascenso clausura bbva mexico, segunda mexico clausura, segunda divis

Ascenso MX - Clausura 2020

  • Mineros de Zacatecas
  • Correcaminos UAT
  • Celaya
  • Zacatepec
  • Leones Negros
  • Tampico Madero
  • Venados FC
  • Atlante FC
  • Cimarrones de Sonora
  • Alebrijes de Oaxaca
  • Dorados
  • Cafetaleros
  • Liga de Ascenso
Ver jornada
Jornada 1
24 Ene 20 Leones NegrosLeones 1 - 0 Alebrijes de OaxacaAlebrijes 29
25 Ene 20 Tampico MaderoTampico 0 - 2 Cimarrones de SonoraCimarrones 6
25 Ene 20 Venados FCVenados FC 2 - 1 ZacatepecZacatepec 3
26 Ene 20 CelayaCelaya 1 - 0 Atlante FCAtlante FC 6
26 Ene 20 CafetalerosCafetaleros 0 - 1 Mineros de ZacatecasMineros 10
26 Ene 20 DoradosDorados 0 - 3 Correcaminos UATCorrecamino 12
Ver jornada
Jornada 2
31 Ene 20 Alebrijes de OaxacaAlebrijes 3 - 0 Cimarrones de SonoraCimarrones 8
01 Feb 20 Mineros de ZacatecasMineros 4 - 0 Venados FCVenados FC 4
01 Feb 20 Atlante FCAtlante FC 2 - 1 DoradosDorados 15
02 Feb 20 Correcaminos UATCorrecamino 3 - 2 CafetalerosCafetaleros 24
02 Feb 20 ZacatepecZacatepec 3 - 1 CelayaCelaya 2
02 Feb 20 Leones NegrosLeones 0 - 2 Tampico MaderoTampico 7
Ver jornada
Jornada 3
07 Feb 20 Tampico MaderoTampico 2 - 1 Atlante FCAtlante FC 15
08 Feb 20 Mineros de ZacatecasMineros 4 - 0 Correcaminos UATCorrecamino 13
08 Feb 20 Venados FCVenados FC 1 - 0 CelayaCelaya 7
09 Feb 20 Alebrijes de OaxacaAlebrijes 1 - 1 DoradosDorados 10
09 Feb 20 CafetalerosCafetaleros 1 - 3 Leones NegrosLeones 7
09 Feb 20 Cimarrones de SonoraCimarrones 2 - 1 ZacatepecZacatepec 25
Ver jornada
Jornada 4
14 Feb 20 Correcaminos UATCorrecamino 1 - 0 Tampico MaderoTampico 60
15 Feb 20 Atlante FCAtlante FC 2 - 1 CafetalerosCafetaleros 29
16 Feb 20 DoradosDorados 1 - 1 Cimarrones de SonoraCimarrones 11
16 Feb 20 ZacatepecZacatepec 1 - 0 Alebrijes de OaxacaAlebrijes 12
16 Feb 20 CelayaCelaya 0 - 1 Mineros de ZacatecasMineros 12
16 Feb 20 Leones NegrosLeones 2 - 0 Venados FCVenados FC 4
Ver jornada
Jornada 5
21 Feb 20 Mineros de ZacatecasMineros 2 - 0 ZacatepecZacatepec 36
22 Feb 20 Correcaminos UATCorrecamino 6 - 2 Leones NegrosLeones 11
23 Feb 20 Venados FCVenados FC 4 - 3 DoradosDorados ...
23 Feb 20 CafetalerosCafetaleros 0 - 1 CelayaCelaya 16
23 Feb 20 Cimarrones de SonoraCimarrones 0 - 0 Atlante FCAtlante FC 10
24 Feb 20 Tampico MaderoTampico 1 - 1 Alebrijes de OaxacaAlebrijes 15
Ver jornada
Jornada 6
28 Feb 20 DoradosDorados 2 - 2 Mineros de ZacatecasMineros 17
29 Feb 20 Atlante FCAtlante FC 0 - 0 Venados FCVenados FC ...
29 Feb 20 Alebrijes de OaxacaAlebrijes 0 - 0 Correcaminos UATCorrecamino 32
01 Mar 20 ZacatepecZacatepec 2 - 1 CafetalerosCafetaleros 6
01 Mar 20 CelayaCelaya 1 - 1 Tampico MaderoTampico 5
01 Mar 20 Leones NegrosLeones 3 - 1 Cimarrones de SonoraCimarrones 5
Ver jornada
Jornada 7
06 Mar 20 Cimarrones de SonoraCimarrones 0 - 2 Correcaminos UATCorrecamino 28
07 Mar 20 ZacatepecZacatepec 3 - 3 DoradosDorados 8
07 Mar 20 Mineros de ZacatecasMineros 2 - 0 Atlante FCAtlante FC 6
08 Mar 20 CelayaCelaya 2 - 1 Leones NegrosLeones 9
08 Mar 20 CafetalerosCafetaleros 4 - 1 Alebrijes de OaxacaAlebrijes ...
09 Mar 20 Tampico MaderoTampico 1 - 0 Venados FCVenados FC 4
Ver jornada
Jornada 8
13 Mar 20 Alebrijes de OaxacaAlebrijes 0 - 1 Atlante FCAtlante FC 79
14 Mar 20 Venados FCVenados FC 1 - 0 CafetalerosCafetaleros 43
16 Mar 20 Cimarrones de SonoraCimarrones 0 - 1 CelayaCelaya 34
15 Mar 20 Correcaminos UATCorrecamino 1 - 2 ZacatepecZacatepec 35
15 Mar 20 DoradosDorados 2 - 2 Tampico MaderoTampico 29
15 Mar 20 Leones NegrosLeones 2 - 2 Mineros de ZacatecasMineros 16
Ver jornada
Jornada 9
20 Mar 20 ZacatepecZacatepec Apl Leones NegrosLeones ...
21 Mar 20 Mineros de ZacatecasMineros Apl Alebrijes de OaxacaAlebrijes ...
21 Mar 20 Venados FCVenados FC Apl Cimarrones de SonoraCimarrones ...
22 Mar 20 CelayaCelaya Apl DoradosDorados ...
22 Mar 20 CafetalerosCafetaleros Apl Tampico MaderoTampico ...
23 Mar 20 Atlante FCAtlante FC Apl Correcaminos UATCorrecamino ...
Ver jornada
Jornada 10
03 Abr 20 Atlante FCAtlante FC Apl ZacatepecZacatepec ...
04 Abr 20 Tampico MaderoTampico Apl Mineros de ZacatecasMineros ...
04 Abr 20 Cimarrones de SonoraCimarrones Apl CafetalerosCafetaleros ...
05 Abr 20 Correcaminos UATCorrecamino Apl CelayaCelaya ...
05 Abr 20 DoradosDorados Apl Leones NegrosLeones ...
06 Abr 20 Alebrijes de OaxacaAlebrijes Apl Venados FCVenados FC ...
Ver jornada
Jornada 11
10 Abr 20 Leones NegrosLeones Apl Atlante FCAtlante FC ...
11 Abr 20 Mineros de ZacatecasMineros Apl Cimarrones de SonoraCimarrones ...
11 Abr 20 Venados FCVenados FC Apl Correcaminos UATCorrecamino ...
12 Abr 20 CelayaCelaya Apl Alebrijes de OaxacaAlebrijes ...
12 Abr 20 ZacatepecZacatepec Apl Tampico MaderoTampico ...
12 Abr 20 CafetalerosCafetaleros Apl DoradosDorados ...

Clasificación

Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 8 18 4 22
2 Correcaminos UAT Correcaminos 8 16 10 18
3 Celaya Celaya 8 7 7 15
4 Zacatepec Zacatepec 8 13 12 14
5 Leones Negros Leones 8 14 14 14
6 Tampico Madero Tampico 8 9 8 13
7 Venados FC Venados FC 8 8 11 13
8 Atlante FC Atlante FC 8 6 7 12
9 Cimarrones de Sonora Cimarrones 8 6 11 9
10 Alebrijes de Oaxaca Alebrijes 8 6 9 6
11 Dorados Dorados 8 13 18 5
12 Cafetaleros Cafetaleros 8 9 14 3

  USO DE MEMORIA  
5,262,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.1226
Total Execution Time  0.1259
  CADENA URL  
/clausura_liga_de_ascenso2020/grupo1/calendario
  GET DATOS  
$_GET['/clausura_liga_de_ascenso2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (20)  
0.0020  SELECT type FROM routes WHERE alias = 'clausura_liga_de_ascenso2020'
0.0049  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_liga_de_ascenso' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=211 AND type_rel = 3
0.0038  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 211 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0030  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 (627892,856474,846417,841500,839257) ORDER BY n.cover_points DESC, update_date DESC
0.0033  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=210 ORDER BY l.group_code ASC
0.0022  SELECT id,name,alias,stepParent FROM categories WHERE parentId=210 ORDER BY order_id ASC
0.0027  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 211 GROUP BY l.categoryId
0.0027  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=211 GROUP BY l.year ORDER BY l.year DESC
0.0029  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 = 53478 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0039  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 53478 ORDER BY round ASC
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-29 08:09:07' 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-29 08:09:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-29 08:09:07' 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=3 AND last_update > '2024-04-29 08:09:07' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_liga_de_ascenso' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0139  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 events2020 e ON e.player_id = p.id AND e.league_id = 53478 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53478 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.0052  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 events2020 e ON e.player_id = p.id AND e.league_id = 53478 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53478 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 events2020 e ON e.player_id = p.id AND e.league_id = 53478 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 53478 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 53478 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC