4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2022/2023
Equipo PJ GF GC Puntos
1 Chihuahua FC Chihuahua 10 21 10 25
2 Tecos Tecos 10 14 4 25
3 Tritones Vallarta Tritones 10 17 5 24
4 Los Cabos Los Cabos 10 14 8 18
5 Cimarrones II Cimarrones 10 16 11 18
6 UA Zacatecas Zacatecas 10 14 12 17
7 Coras de Nayarit Coras 10 9 13 13
8 Mineros de Fresnillo Mineros 10 7 16 10
9 Mexicali FC Mexicali FC 10 10 18 8
10 Halcones de Zapopan Halcones 10 6 17 6
11 Leones Negros II Leones 10 4 18 1
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Mazorqueros Mazorqueros 13 30 10 33
2 Tritones Vallarta Tritones 13 23 12 29
3 Durango Durango 13 32 11 27
4 Coras de Nayarit Coras 13 20 12 26
5 Saltillo FC Saltillo FC 13 24 18 25
6 Cimarrones II Cimarrones 13 19 15 19
7 Gavilanes FC Gavilanes 13 14 9 17
8 UA Zacatecas Zacatecas 13 22 20 16
9 Tecos Tecos 13 13 19 16
10 Leones Negros II Leones 13 13 22 13
11 Colima Colima 13 11 21 10
12 Mineros de Fresnillo Mineros 13 17 29 9
13 UA Tamaulipas Tamaulipas 13 10 29 8
14 Catedráticos Elite Catedrático 13 9 30 5
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Loros Universidad Loros 17 36 14 36
2 Necaxa Premier Necaxa 17 22 18 31
3 Tigres UANL Premier Tigres UANL 17 22 12 29
4 Durango Durango 17 23 19 27
5 Atlas Premier Atlas 17 23 23 26
6 Reynosa F.C. Reynosa F.C. 17 24 12 25
7 Tepatitlán FC Tepatitlán 17 25 19 25
8 Pacific Pacific 17 24 19 25
9 Guadalajara Premier Guadalajara 17 15 15 23
10 Monarcas Morelia Premier Monarcas 17 20 20 22
11 Tecos Tecos 17 16 17 22
12 Gavilanes FC Gavilanes 17 18 24 21
13 Santos Laguna Premier Santos 17 20 24 20
14 Club Leon Premier Club Leon P. 17 16 23 20
15 Deportivo Tepic JAP Deportivo 17 11 25 20
16 UA Chihuahua Chihuahua 17 16 30 16
17 Club Tijuana Premier Club Tijuana 17 25 30 15
18 Rayados de Monterrey Premie Rayados 17 14 26 13
19 Tuxtla FC Tuxtla FC 17 31 12 38
20 Irapuato Irapuato 17 32 23 32
21 Reboceros de la Piedad Reboceros 17 28 19 32
22 Pioneros de Cancún Pioneros 17 18 13 32
23 Inter Playa del Carmen Inter Playa 17 23 14 31
24 América Premier América 17 26 20 27
25 Puebla F.C. Premier Puebla F.C. 17 22 22 23
26 Real Zamora Real Zamora 17 21 21 23
27 Gallos Blancos de Querétaro Gallos 17 22 18 22
28 Cruz Azul Cruz Azul 17 20 19 20
29 Halcones de Morelos Halcones 17 15 18 20
30 Sporting Canamy Sporting 17 20 29 20
31 Tiburones Rojos de Veracruz Tiburones 17 16 17 19
32 Lobos BUAP Premier Lobos BUAP. 17 19 26 18
33 Toluca Premier Toluca 17 18 24 17
34 Cruz Azul Premier Cruz Azul P. 17 20 28 17
35 Pachuca Premier Pachuca 17 14 30 13
36 Pumas UNAM Premier Pumas UNAM. 17 21 33 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Guadalajara Premier Guadalajara 15 26 15 31
2 Tigres UANL Premier Tigres UANL 15 23 13 29
3 Mineros de Fresnillo Mineros 15 25 18 29
4 Santos Laguna Premier Santos 15 23 15 27
5 Rayados de Monterrey Premie Rayados 15 30 22 24
6 Murciélagos F.C. Murciélagos 15 21 20 21
7 Leones Negros II Leones 15 25 26 21
8 Reynosa F.C. Reynosa F.C. 15 22 21 20
9 UA Chihuahua Chihuahua 15 18 21 20
10 Mineros de Zacatecas II Mineros 15 23 18 18
11 Atlas Premier Atlas 15 18 21 18
12 Cimarrones II Cimarrones 15 22 26 18
13 Cuervos J.A.P. Cuervos 15 12 15 14
14 Club Tijuana Premier Club Tijuana 15 25 27 13
15 Durango Durango 15 10 19 13
16 Titanes de Saltillo Titanes 15 17 43 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Murciélagos F.C. Murciélagos 14 27 17 26
2 Reynosa F.C. Reynosa F.C. 14 21 15 25
3 Mineros de Zacatecas II Mineros 14 20 13 23
4 Rayados de Monterrey Premie Rayados 14 15 17 23
5 Santos Laguna Premier Santos 13 23 11 22
6 Ua Ciudad Juárez Ciudad 14 23 21 22
7 Club Tijuana Premier Club Tijuana 14 25 20 21
8 Cimarrones II Cimarrones 13 31 16 20
9 Tigres UANL Premier Tigres UANL 14 19 17 20
10 Santos de Soledad F.C. Santos 14 19 29 16
11 Durango Durango 14 20 25 15
12 Deportivo Tepic JAP Deportivo 14 12 21 13
13 UA Zacatecas Zacatecas 14 16 22 12
14 UA Chihuahua Chihuahua 14 17 27 12
15 Dorados Premier Dorados 14 16 33 12
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Reynosa F.C. Reynosa F.C. 12 23 10 26
2 Tampico Madero Tampico 12 22 14 24
3 Cimarrones de Sonora Cimarrones 12 19 9 23
4 Loros Universidad Loros 12 24 14 22
5 Gallos Blancos de Querétaro Gallos 12 22 16 18
6 UA Chihuahua Chihuahua 12 16 18 17
7 Tecos Tecos 12 15 17 15
8 Ua Ciudad Juárez Ciudad 12 11 16 14
9 Murciélagos Murciélagos 12 12 19 13
10 Deportivo Tepic JAP Deportivo 12 12 21 12
11 Santos de Soledad F.C. Santos 12 19 22 11
12 UA Zacatecas Zacatecas 12 12 20 10
13 Durango Durango 12 9 20 10
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Loros Universidad Loros 15 36 11 36
2 De los altos altos 15 20 9 32
3 Deportivo Tepic Deportivo 15 17 5 29
4 Unión de Curtidores Unión 15 30 14 27
5 Estudiantes Tecos II Estudiantes 15 16 16 25
6 Ua Ciudad Juárez Ciudad 15 23 24 22
7 Durango Durango 15 15 17 21
8 Cimarrones de Sonora Cimarrones 15 16 19 20
9 Murciélagos Murciélagos 15 18 21 19
10 Águilas Reales Águilas 15 10 19 17
11 Vaqueros Ameca Vaqueros 15 10 20 17
12 UA Tamaulipas Tamaulipas 15 18 21 16
13 UA Chihuahua Chihuahua 15 16 24 14
14 Cachorros Guadalajara Cachorros 15 12 20 13
15 Bravos Nuevo Laredo Bravos Nuevo 15 13 23 13
16 Reynosa F.C. Reynosa F.C. 15 13 20 12

  USO DE MEMORIA  
5,735,384 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1138
Total Execution Time  0.1157
  CADENA URL  
/premier_de_ascenso_clausura2023/grupo1/historico
  GET DATOS  
$_GET['/premier_de_ascenso_clausura2023/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0019  SELECT type FROM routes WHERE alias = 'premier_de_ascenso_clausura2023'
0.0057  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_de_ascenso_clausura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1551 AND type_rel = 3
0.0024  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1551 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0027  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 (1228767,1008128,861777,838317,834947) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = 68375 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1551 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68375 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 66329 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2018` 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 = 41348 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 37691 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2016` 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 = 20213 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2015` 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 = 9258 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` 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 = 16465 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 09:02:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 09:02:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 09:02:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 09:02:39' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_de_ascenso_clausura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0076  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 events2023 e ON e.player_id = p.id AND e.league_id = 68375 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68375 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.0133  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 events2023 e ON e.player_id = p.id AND e.league_id = 68375 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68375 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 events2023 e ON e.player_id = p.id AND e.league_id = 68375 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 68375 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0034  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` 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 = 68375 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC