4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
10 Ene 24 Cimarrones de SonoraCimarrones 1 - 1 Leones NegrosLeones 76
10 Ene 24 CA La PazCA La Paz 1 - 1 CA MoreliaCA Morelia 123
11 Ene 24 Tlaxcala FCTlaxcala 1 - 0 CancúnCancún 132
11 Ene 24 CD TapatíoTapatío 0 - 2 Venados FCVenados FC 109
12 Ene 24 Tepatitlán FCTepatitlán 2 - 0 DoradosDorados 39
12 Ene 24 Mineros de ZacatecasMineros 3 - 0 Correcaminos UATCorrecamino 84
14 Ene 24 Atlante FCAtlante FC 2 - 1 CelayaCelaya 72
Ver jornada
Jornada 2
17 Ene 24 CancúnCancún 3 - 0 Alebrijes de OaxacaAlebrijes 65
02 Mar 24 Correcaminos UATCorrecamino 1 - 1 Tlaxcala FCTlaxcala 38
18 Ene 24 CelayaCelaya 4 - 2 CA La PazCA La Paz 23
18 Ene 24 DoradosDorados 1 - 1 Cimarrones de SonoraCimarrones 179
19 Ene 24 Tepatitlán FCTepatitlán 0 - 5 Venados FCVenados FC 103
19 Ene 24 Mineros de ZacatecasMineros 0 - 4 CD TapatíoTapatío 94
22 Ene 24 Leones NegrosLeones 0 - 0 Atlante FCAtlante FC 38
Ver jornada
Jornada 3
24 Ene 24 Alebrijes de OaxacaAlebrijes 2 - 2 Cimarrones de SonoraCimarrones 145
24 Ene 24 CA La PazCA La Paz 2 - 0 Tepatitlán FCTepatitlán 146
25 Ene 24 Tlaxcala FCTlaxcala 0 - 1 DoradosDorados 61
25 Ene 24 Venados FCVenados FC 1 - 1 Leones NegrosLeones 94
26 Ene 24 CancúnCancún 2 - 0 Atlante FCAtlante FC 62
26 Ene 24 CelayaCelaya 2 - 0 Correcaminos UATCorrecamino 107
29 Ene 24 CA MoreliaCA Morelia 1 - 2 Mineros de ZacatecasMineros 36
Ver jornada
Jornada 4
01 Feb 24 Atlante FCAtlante FC 1 - 2 Alebrijes de OaxacaAlebrijes 51
31 Ene 24 Cimarrones de SonoraCimarrones 1 - 2 Tlaxcala FCTlaxcala 53
01 Feb 24 DoradosDorados 2 - 3 Venados FCVenados FC 27
01 Feb 24 Correcaminos UATCorrecamino 3 - 1 CancúnCancún 84
02 Feb 24 CD TapatíoTapatío 0 - 2 CA La PazCA La Paz 105
02 Feb 24 Mineros de ZacatecasMineros 0 - 1 Leones NegrosLeones 172
04 Feb 24 Tepatitlán FCTepatitlán 2 - 1 CA MoreliaCA Morelia 27
Ver jornada
Jornada 5
07 Feb 24 Alebrijes de OaxacaAlebrijes 1 - 0 Correcaminos UATCorrecamino 76
07 Feb 24 CelayaCelaya 3 - 1 DoradosDorados 132
08 Feb 24 CA La PazCA La Paz 0 - 0 Atlante FCAtlante FC 103
08 Feb 24 Cimarrones de SonoraCimarrones 1 - 2 CD TapatíoTapatío 30
10 Feb 24 Leones NegrosLeones 2 - 0 CancúnCancún 35
09 Feb 24 CA MoreliaCA Morelia 3 - 1 Tlaxcala FCTlaxcala 69
05 Feb 24 Venados FCVenados FC 1 - 0 Mineros de ZacatecasMineros 99
Ver jornada
Jornada 6
14 Feb 24 CancúnCancún 1 - 1 CelayaCelaya 124
14 Feb 24 DoradosDorados 3 - 0 Correcaminos UATCorrecamino 35
15 Feb 24 Alebrijes de OaxacaAlebrijes 0 - 3 Leones NegrosLeones 30
18 Feb 24 Atlante FCAtlante FC 2 - 0 Cimarrones de SonoraCimarrones 3
16 Feb 24 Tepatitlán FCTepatitlán 1 - 1 Mineros de ZacatecasMineros 126
17 Feb 24 Tlaxcala FCTlaxcala 2 - 3 CA La PazCA La Paz 31
18 Feb 24 CD TapatíoTapatío 0 - 0 CA MoreliaCA Morelia 27
Ver jornada
Jornada 7
22 Feb 24 Cimarrones de SonoraCimarrones 4 - 0 Tepatitlán FCTepatitlán 12
21 Feb 24 Correcaminos UATCorrecamino 3 - 1 CA MoreliaCA Morelia 38
22 Feb 24 Tlaxcala FCTlaxcala 1 - 0 Venados FCVenados FC 43
23 Feb 24 CA La PazCA La Paz 1 - 0 DoradosDorados 118
23 Feb 24 Leones NegrosLeones 1 - 0 CD TapatíoTapatío 58
21 Feb 24 Mineros de ZacatecasMineros 0 - 2 CancúnCancún 37
26 Feb 24 CelayaCelaya 2 - 0 Alebrijes de OaxacaAlebrijes 22
Ver jornada
Jornada 8
28 Feb 24 Leones NegrosLeones 1 - 1 Correcaminos UATCorrecamino 104
28 Feb 24 Venados FCVenados FC 1 - 0 Atlante FCAtlante FC 60
29 Feb 24 Alebrijes de OaxacaAlebrijes 1 - 1 Mineros de ZacatecasMineros 36
06 Abr 24 DoradosDorados 1 - 3 CD TapatíoTapatío 147
01 Mar 24 Tepatitlán FCTepatitlán 0 - 2 CelayaCelaya 74
01 Mar 24 CA MoreliaCA Morelia 0 - 1 Cimarrones de SonoraCimarrones 141
03 Mar 24 CancúnCancún 2 - 2 CA La PazCA La Paz 20
Ver jornada
Jornada 9
06 Mar 24 Atlante FCAtlante FC 2 - 0 Tlaxcala FCTlaxcala 39
06 Mar 24 CelayaCelaya 0 - 2 Venados FCVenados FC 83
07 Mar 24 Correcaminos UATCorrecamino 2 - 0 Tepatitlán FCTepatitlán 38
07 Mar 24 DoradosDorados 2 - 1 CA MoreliaCA Morelia 58
08 Mar 24 Mineros de ZacatecasMineros 3 - 0 CA La PazCA La Paz 32
08 Mar 24 CD TapatíoTapatío 1 - 2 Alebrijes de OaxacaAlebrijes 48
11 Mar 24 Cimarrones de SonoraCimarrones 2 - 4 CancúnCancún 42
Ver jornada
Jornada 10
13 Mar 24 Tlaxcala FCTlaxcala 0 - 3 CD TapatíoTapatío 69
13 Mar 24 Venados FCVenados FC 2 - 1 Alebrijes de OaxacaAlebrijes 201
14 Mar 24 Tepatitlán FCTepatitlán 1 - 2 Atlante FCAtlante FC 93
14 Mar 24 Cimarrones de SonoraCimarrones 2 - 2 Mineros de ZacatecasMineros 92
15 Mar 24 CA MoreliaCA Morelia 0 - 1 CancúnCancún 118
15 Mar 24 Leones NegrosLeones 0 - 0 CelayaCelaya 226
18 Mar 24 CA La PazCA La Paz 1 - 1 Correcaminos UATCorrecamino 48
Ver jornada
Jornada 11
20 Mar 24 CancúnCancún 2 - 0 Tepatitlán FCTepatitlán 109
20 Mar 24 Atlante FCAtlante FC 3 - 1 Mineros de ZacatecasMineros 101
20 Mar 24 Alebrijes de OaxacaAlebrijes 1 - 1 Tlaxcala FCTlaxcala 202
21 Mar 24 CD TapatíoTapatío 2 - 2 Correcaminos UATCorrecamino 148
21 Mar 24 Venados FCVenados FC 0 - 0 Cimarrones de SonoraCimarrones 135
21 Mar 24 DoradosDorados 1 - 2 Leones NegrosLeones 146
22 Mar 24 CelayaCelaya 1 - 2 CA MoreliaCA Morelia 206
Ver jornada
Jornada 12
23 Mar 24 CA La PazCA La Paz 2 - 1 Alebrijes de OaxacaAlebrijes 106
23 Mar 24 Tepatitlán FCTepatitlán 0 - 4 CD TapatíoTapatío 20
24 Mar 24 Mineros de ZacatecasMineros 3 - 1 DoradosDorados 31
24 Mar 24 Correcaminos UATCorrecamino 2 - 1 Venados FCVenados FC 51
24 Mar 24 Tlaxcala FCTlaxcala 0 - 4 Leones NegrosLeones 39
24 Mar 24 Atlante FCAtlante FC 0 - 0 CA MoreliaCA Morelia 106
25 Mar 24 Cimarrones de SonoraCimarrones 0 - 1 CelayaCelaya 127
Ver jornada
Jornada 13
27 Mar 24 CancúnCancún 1 - 1 CD TapatíoTapatío 119
27 Mar 24 Alebrijes de OaxacaAlebrijes 1 - 0 Tepatitlán FCTepatitlán 140
28 Mar 24 Leones NegrosLeones 2 - 4 CA La PazCA La Paz 175
28 Mar 24 Correcaminos UATCorrecamino 0 - 2 Cimarrones de SonoraCimarrones 218
29 Mar 24 CA MoreliaCA Morelia 3 - 4 Venados FCVenados FC 267
29 Mar 24 DoradosDorados 0 - 3 Atlante FCAtlante FC 369
30 Mar 24 CelayaCelaya 1 - 1 Tlaxcala FCTlaxcala 54
Ver jornada
Jornada 14
03 Abr 24 CD TapatíoTapatío 0 - 0 Atlante FCAtlante FC 77
03 Abr 24 Cimarrones de SonoraCimarrones 2 - 1 CA La PazCA La Paz 48
03 Abr 24 DoradosDorados 1 - 3 Alebrijes de OaxacaAlebrijes 106
04 Abr 24 Mineros de ZacatecasMineros 2 - 2 CelayaCelaya 73
04 Abr 24 Venados FCVenados FC 2 - 0 CancúnCancún 87
05 Abr 24 CA MoreliaCA Morelia 0 - 2 Leones NegrosLeones 77
05 Abr 24 Tepatitlán FCTepatitlán 1 - 1 Tlaxcala FCTlaxcala 70
Ver jornada
Jornada 15
10 Abr 24 CancúnCancún 2 - 2 DoradosDorados 52
10 Abr 24 CA La PazCA La Paz 0 - 1 Venados FCVenados FC 154
11 Abr 24 Tlaxcala FCTlaxcala 0 - 2 Mineros de ZacatecasMineros 54
11 Abr 24 Leones NegrosLeones 3 - 2 Tepatitlán FCTepatitlán 95
12 Abr 24 Atlante FCAtlante FC 4 - 0 Correcaminos UATCorrecamino 119
12 Abr 24 CelayaCelaya 1 - 2 CD TapatíoTapatío 199
14 Abr 24 Alebrijes de OaxacaAlebrijes 3 - 3 CA MoreliaCA Morelia 8

Clasificación

Equipo PJ GF GC Puntos
1 Venados FC Venados FC 14 25 10 32
2 Leones Negros Leones 14 23 10 29
3 Atlante FC Atlante FC 14 19 8 25
4 CD Tapatío CD Tapatío 14 22 13 22
5 Celaya Celaya 14 21 15 22
6 Cancún Cancún 14 21 16 22
7 CA La Paz CA La Paz 14 21 19 22
8 Mineros de Zacatecas Mineros 14 20 19 19
9 Alebrijes de Oaxaca Alebrijes 14 18 22 19
10 Cimarrones de Sonora Cimarrones 14 19 18 17
11 Correcaminos UAT Correcaminos 14 15 23 16
12 Tlaxcala FC Tlaxcala FC 14 11 23 13
13 Dorados Dorados 14 16 27 11
14 CA Morelia CA Morelia 14 16 23 10
15 Tepatitlán FC Tepatitlán 14 9 30 8

  USO DE MEMORIA  
5,682,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0033
Controller Execution Time ( Home / Category )  0.1238
Total Execution Time  0.1272
  CADENA URL  
/liga_de_expansion_mx_clausura2024/grupo1/calendario
  GET DATOS  
$_GET['/liga_de_expansion_mx_clausura2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_de_expansion_mx_clausura2024'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_de_expansion_mx_clausura' AND (l.group_code = 1 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=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2369 AND type_rel = 3
0.0020  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=2368 ORDER BY l.group_code ASC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2368 ORDER BY order_id ASC
0.0020  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 = 74956 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 74956 ORDER BY round ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 09:16:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 09:16:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 09:16:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 09:16:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_de_expansion_mx_clausura' 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.0101  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 = 74956 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74956 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 74956 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74956 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  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 = 74956 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74956 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0032  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 = 74956 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC