4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Liga Premier Serie A 2024 G 2
2023/2024

Serie A de México, Liga Premier de Ascenso de México, Premier Mexico, Liga Mexico, Tercera Mexico, Serie A mexicana, premier mexicana, liga mexicana, tercera mexicana,liga premier

Liga Premier Serie A 2024 G 2

  • Racing Porto Palmeiras
  • Tampico Madero
  • Deportiva Venados
  • Petroleros de Salamanca
  • Irapuato
  • Aguacateros de Peribán
  • Inter Playa del Carmen
  • Escorpiones FC
  • Montañeses
  • Cafetaleros
  • Reboceros de la Piedad
  • Pioneros de Cancún
  • Lobos ULMX
  • Halcones de Zapopan
  • Sporting Canamy
  • San Juan de Aragón
  • Yalmakan
  • Inter de Querétaro
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Racing Porto Palmeiras Racing Porto 33 51 20 77
2 Tampico Madero Tampico 33 62 29 64
3 Deportiva Venados Deportiva 33 56 39 62
4 Petroleros de Salamanca Petroleros 33 36 22 56
5 Irapuato Irapuato 32 57 22 55
6 Aguacateros de Peribán Aguacateros 33 58 40 55
7 Inter Playa del Carmen Inter Playa 33 41 29 53
8 Escorpiones FC Escorpiones 33 38 32 52
9 Montañeses Montañeses 32 46 42 52
10 Cafetaleros Cafetaleros 33 44 39 47
11 Reboceros de la Piedad Reboceros 33 39 35 46
12 Pioneros de Cancún Pioneros 33 35 50 36
13 Lobos ULMX Lobos ULMX 33 33 48 36
14 Halcones de Zapopan Halcones 32 30 38 33
15 Sporting Canamy Sporting 33 42 59 28
16 San Juan de Aragón Juan Aragón 33 30 65 22
17 Yalmakan Yalmakan 16 20 34 14
18 Inter de Querétaro Inter 33 18 93 9
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 24 52 18 59
2 Inter Playa del Carmen Inter Playa 24 55 17 57
3 Irapuato Irapuato 24 58 21 56
4 Cafetaleros de Chiapas II Cafetaleros 24 63 24 51
5 Cafessa Jalisco Cafessa 24 40 22 50
6 Aguacateros CD Uruapan Aguacateros 24 43 38 44
7 Pioneros de Cancún Pioneros 24 37 33 42
8 Deportivo Dongu Deportivo 24 29 48 32
9 Zitacuaro Zitacuaro 24 26 37 30
10 Cuautla Cuautla 24 23 44 19
11 Azores de Hidalgo Azores 24 27 61 17
12 Cañoneros Marina Cañoneros 24 17 56 10
13 Ciervos Ciervos 24 12 63 10
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Aguacateros CD Uruapan Aguacateros 23 41 19 43
2 Atlético San Francisco Atlético 23 40 22 43
3 Mineros de Zacatecas II Mineros 23 59 30 39
4 La Paz La Paz 23 49 34 39
5 Cuautla Cuautla 23 35 22 39
6 Club Calor Club Calor 23 34 25 39
7 Deportivo Cafessa Deportivo 23 43 28 37
8 Chapulineros de Oaxaca Chapulineros 23 36 26 36
9 Real Canamy Tlayacapan Real Canamy 23 38 41 33
10 Zitacuaro Zitacuaro 23 22 29 29
11 Dorados Premier Dorados 23 27 33 28
12 Deportivo Dongu Deportivo 23 23 43 19
13 Ciervos Ciervos 23 21 59 16
14 Nuevo Chimalhuacán Nuevo 23 15 72 6

  USO DE MEMORIA  
5,356,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5075
Total Execution Time  0.5094
  CADENA URL  
/liga_premier_mexico2024/grupo2/historico
  GET DATOS  
$_GET['/liga_premier_mexico2024/grupo2/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0144  SELECT type FROM routes WHERE alias = 'liga_premier_mexico2024'
0.0290  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_premier_mexico' AND (l.group_code = 2 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=2 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2163 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2163 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  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 (947042,872027,869482,809171,801563) ORDER BY n.cover_points DESC, update_date DESC
0.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2163 ORDER BY order_id ASC
0.0145  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2163 GROUP BY l.categoryId
0.0146  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=2163 GROUP BY l.year ORDER BY l.year DESC
0.0147  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 = 73351 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 2163 AND group_code = 2 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0157  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 `tables2024` 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 = 73351 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables2021` 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 = 58754 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `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 = 51047 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 14:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 14:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 14:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 14:22:41' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0156  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_premier_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0377  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 events2024 e ON e.player_id = p.id AND e.league_id = 73351 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73351 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.0412  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 events2024 e ON e.player_id = p.id AND e.league_id = 73351 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73351 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0161  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 events2024 e ON e.player_id = p.id AND e.league_id = 73351 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73351 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0160  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 73351 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC