4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver jornada
Jornada 1
09 Ene 22 Venados FCVenados FC 1 - 0 Atlante FCAtlante FC 74
06 Ene 22 Alebrijes de OaxacaAlebrijes 2 - 0 CancúnCancún 65
14 Feb 22 Cimarrones de SonoraCimarrones 2 - 3 Leones NegrosLeones 116
07 Ene 22 CelayaCelaya 1 - 1 Tepatitlán FCTepatitlán 131
07 Ene 22 Pumas TabascoPumas 0 - 1 Raya2 ExpansiónRaya2 146
10 Ene 22 Correcaminos UATCorrecamino 1 - 2 DoradosDorados 120
08 Ene 22 CD TapatíoTapatío 2 - 0 Mineros de ZacatecasMineros 74
10 Ene 22 Tlaxcala FCTlaxcala 0 - 4 CA MoreliaCA Morelia 73
Ver jornada
Jornada 2
12 Ene 22 Raya2 ExpansiónRaya2 1 - 0 Cimarrones de SonoraCimarrones 191
12 Ene 22 CancúnCancún 2 - 0 CelayaCelaya 197
12 Ene 22 Tampico MaderoTampico 1 - 1 Alebrijes de OaxacaAlebrijes 195
13 Ene 22 Mineros de ZacatecasMineros 1 - 2 CA MoreliaCA Morelia 129
13 Ene 22 Atlante FCAtlante FC 1 - 1 Tlaxcala FCTlaxcala 148
13 Ene 22 DoradosDorados 0 - 2 CD TapatíoTapatío 113
14 Ene 22 Tepatitlán FCTepatitlán 1 - 1 Correcaminos UATCorrecamino 88
16 Ene 22 Leones NegrosLeones 3 - 1 Pumas TabascoPumas 22
Ver jornada
Jornada 3
19 Ene 22 CancúnCancún 1 - 2 DoradosDorados 32
19 Ene 22 Tlaxcala FCTlaxcala 1 - 0 Cimarrones de SonoraCimarrones 97
19 Ene 22 Correcaminos UATCorrecamino 0 - 0 Mineros de ZacatecasMineros 88
20 Ene 22 CelayaCelaya 1 - 1 Atlante FCAtlante FC 106
20 Ene 22 Pumas TabascoPumas 2 - 0 Tampico MaderoTampico 102
20 Ene 22 Alebrijes de OaxacaAlebrijes 1 - 1 Leones NegrosLeones 57
21 Ene 22 CD TapatíoTapatío 1 - 0 Venados FCVenados FC 220
24 Ene 22 CA MoreliaCA Morelia 1 - 0 Raya2 ExpansiónRaya2 28
Ver jornada
Jornada 4
26 Ene 22 Tepatitlán FCTepatitlán 1 - 1 Tlaxcala FCTlaxcala 78
26 Ene 22 Venados FCVenados FC 2 - 2 Pumas TabascoPumas 48
26 Ene 22 Mineros de ZacatecasMineros 1 - 0 CancúnCancún 224
27 Ene 22 Raya2 ExpansiónRaya2 2 - 0 Alebrijes de OaxacaAlebrijes 45
27 Ene 22 Tampico MaderoTampico 1 - 1 DoradosDorados 50
27 Ene 22 Cimarrones de SonoraCimarrones 3 - 0 CA MoreliaCA Morelia 140
27 Ene 22 Leones NegrosLeones 0 - 3 Correcaminos UATCorrecamino 73
28 Ene 22 Atlante FCAtlante FC 0 - 0 CD TapatíoTapatío 83
Ver jornada
Jornada 5
29 Ene 22 Tlaxcala FCTlaxcala 1 - 0 Venados FCVenados FC 69
29 Ene 22 Mineros de ZacatecasMineros 1 - 0 Tepatitlán FCTepatitlán 51
30 Ene 22 Alebrijes de OaxacaAlebrijes 1 - 1 CA MoreliaCA Morelia 76
30 Ene 22 Correcaminos UATCorrecamino 0 - 2 Cimarrones de SonoraCimarrones 58
30 Ene 22 CelayaCelaya 2 - 1 Raya2 ExpansiónRaya2 115
30 Ene 22 CD TapatíoTapatío 2 - 1 Tampico MaderoTampico 50
31 Ene 22 CancúnCancún 1 - 2 Atlante FCAtlante FC 97
31 Ene 22 DoradosDorados 0 - 1 Leones NegrosLeones 136
Ver jornada
Jornada 6
02 Feb 22 Tepatitlán FCTepatitlán 1 - 2 Alebrijes de OaxacaAlebrijes 53
02 Feb 22 Pumas TabascoPumas 0 - 1 CelayaCelaya 120
02 Feb 22 Venados FCVenados FC 2 - 2 Correcaminos UATCorrecamino 85
03 Feb 22 Raya2 ExpansiónRaya2 0 - 1 Atlante FCAtlante FC 64
03 Feb 22 Tampico MaderoTampico 1 - 2 CancúnCancún 77
03 Feb 22 Cimarrones de SonoraCimarrones 2 - 0 DoradosDorados 84
04 Feb 22 CA MoreliaCA Morelia 1 - 2 CD TapatíoTapatío 91
05 Feb 22 Leones NegrosLeones 2 - 3 Mineros de ZacatecasMineros 62
Ver jornada
Jornada 7
09 Feb 22 CancúnCancún 2 - 1 Tepatitlán FCTepatitlán 117
09 Feb 22 Correcaminos UATCorrecamino 1 - 1 CA MoreliaCA Morelia 277
09 Feb 22 DoradosDorados 4 - 1 Pumas TabascoPumas 137
10 Feb 22 Alebrijes de OaxacaAlebrijes 1 - 0 Venados FCVenados FC 172
10 Feb 22 CelayaCelaya 0 - 0 Leones NegrosLeones 189
10 Feb 22 Mineros de ZacatecasMineros 1 - 0 Raya2 ExpansiónRaya2 89
11 Feb 22 CD TapatíoTapatío 1 - 1 Tlaxcala FCTlaxcala 63
11 Feb 22 Atlante FCAtlante FC 1 - 0 Tampico MaderoTampico 128
Ver jornada
Jornada 8
16 Feb 22 Tlaxcala FCTlaxcala 0 - 1 CelayaCelaya 57
16 Feb 22 Venados FCVenados FC 2 - 1 Tampico MaderoTampico 84
17 Feb 22 Cimarrones de SonoraCimarrones 0 - 1 Alebrijes de OaxacaAlebrijes 129
17 Feb 22 Tepatitlán FCTepatitlán 2 - 0 DoradosDorados 78
17 Feb 22 Pumas TabascoPumas 2 - 1 CD TapatíoTapatío 60
16 Feb 22 Raya2 ExpansiónRaya2 3 - 3 Correcaminos UATCorrecamino 86
18 Feb 22 Leones NegrosLeones 3 - 1 Atlante FCAtlante FC 103
19 Feb 22 CA MoreliaCA Morelia 4 - 1 CancúnCancún 137
Ver jornada
Jornada 9
23 Feb 22 Mineros de ZacatecasMineros 4 - 2 Alebrijes de OaxacaAlebrijes 21
23 Feb 22 CelayaCelaya 1 - 1 Correcaminos UATCorrecamino 142
23 Feb 22 Tampico MaderoTampico 3 - 1 Tepatitlán FCTepatitlán 122
24 Feb 22 Leones NegrosLeones 0 - 1 Venados FCVenados FC 102
24 Feb 22 CancúnCancún 0 - 0 Raya2 ExpansiónRaya2 59
24 Feb 22 DoradosDorados 2 - 0 Tlaxcala FCTlaxcala 48
25 Feb 22 Atlante FCAtlante FC 0 - 0 Pumas TabascoPumas 87
27 Feb 22 CD TapatíoTapatío 0 - 0 Cimarrones de SonoraCimarrones 11
Ver jornada
Jornada 10
02 Mar 22 Alebrijes de OaxacaAlebrijes 1 - 0 CelayaCelaya 31
02 Mar 22 Correcaminos UATCorrecamino 0 - 1 CancúnCancún 49
03 Mar 22 Tepatitlán FCTepatitlán 1 - 0 CD TapatíoTapatío 45
03 Mar 22 Pumas TabascoPumas 0 - 5 Mineros de ZacatecasMineros 39
03 Mar 22 Raya2 ExpansiónRaya2 3 - 3 Venados FCVenados FC 50
04 Mar 22 CA MoreliaCA Morelia 2 - 0 DoradosDorados 146
04 Mar 22 Cimarrones de SonoraCimarrones 1 - 0 Tampico MaderoTampico 160
20 Mar 22 Tlaxcala FCTlaxcala 1 - 2 Leones NegrosLeones 7
Ver jornada
Jornada 11
09 Mar 22 CelayaCelaya 2 - 2 CA MoreliaCA Morelia 89
09 Mar 22 Tampico MaderoTampico 0 - 0 Raya2 ExpansiónRaya2 46
09 Mar 22 Venados FCVenados FC 1 - 0 CancúnCancún 46
10 Mar 22 Leones NegrosLeones 2 - 1 Tepatitlán FCTepatitlán 68
10 Mar 22 Pumas TabascoPumas 0 - 0 Tlaxcala FCTlaxcala 59
10 Mar 22 DoradosDorados 0 - 1 Mineros de ZacatecasMineros 115
11 Mar 22 CD TapatíoTapatío 1 - 0 Correcaminos UATCorrecamino 21
14 Mar 22 Atlante FCAtlante FC 1 - 1 Cimarrones de SonoraCimarrones 25
Ver jornada
Jornada 12
16 Mar 22 Mineros de ZacatecasMineros 0 - 0 Venados FCVenados FC 74
16 Mar 22 CancúnCancún 1 - 0 CD TapatíoTapatío 45
10 Abr 22 Raya2 ExpansiónRaya2 0 - 1 DoradosDorados 25
17 Mar 22 Alebrijes de OaxacaAlebrijes 2 - 1 Tlaxcala FCTlaxcala 17
17 Mar 22 Correcaminos UATCorrecamino 2 - 0 Atlante FCAtlante FC 35
17 Mar 22 Cimarrones de SonoraCimarrones 3 - 2 CelayaCelaya 62
18 Mar 22 Tepatitlán FCTepatitlán 1 - 0 Pumas TabascoPumas 53
20 Mar 22 CA MoreliaCA Morelia 2 - 1 Tampico MaderoTampico 2
Ver jornada
Jornada 13
23 Mar 22 CD TapatíoTapatío 0 - 1 Alebrijes de OaxacaAlebrijes 66
23 Mar 22 Pumas TabascoPumas 2 - 2 Cimarrones de SonoraCimarrones 82
23 Mar 22 DoradosDorados 0 - 2 CelayaCelaya 239
24 Mar 22 Atlante FCAtlante FC 2 - 0 CA MoreliaCA Morelia 67
24 Mar 22 Venados FCVenados FC 0 - 0 Tepatitlán FCTepatitlán 67
24 Mar 22 Tampico MaderoTampico 1 - 0 Mineros de ZacatecasMineros 88
25 Mar 22 Tlaxcala FCTlaxcala 4 - 0 Correcaminos UATCorrecamino 26
24 Mar 22 Leones NegrosLeones 0 - 0 Raya2 ExpansiónRaya2 58
Ver jornada
Jornada 14
26 Mar 22 CancúnCancún 2 - 2 Pumas TabascoPumas 65
26 Mar 22 CelayaCelaya 5 - 0 CD TapatíoTapatío 119
27 Mar 22 Tepatitlán FCTepatitlán 2 - 1 Atlante FCAtlante FC 37
27 Mar 22 Alebrijes de OaxacaAlebrijes 5 - 1 DoradosDorados 55
27 Mar 22 Cimarrones de SonoraCimarrones 1 - 1 Venados FCVenados FC 96
27 Mar 22 CA MoreliaCA Morelia 0 - 1 Leones NegrosLeones 70
28 Mar 22 Mineros de ZacatecasMineros 3 - 4 Tlaxcala FCTlaxcala 163
28 Mar 22 Correcaminos UATCorrecamino 2 - 1 Tampico MaderoTampico 200
Ver jornada
Jornada 15
30 Mar 22 Atlante FCAtlante FC 1 - 0 Alebrijes de OaxacaAlebrijes 108
30 Mar 22 Venados FCVenados FC 2 - 1 DoradosDorados 87
30 Mar 22 Cimarrones de SonoraCimarrones 0 - 1 CancúnCancún 198
31 Mar 22 CelayaCelaya 2 - 1 Mineros de ZacatecasMineros 73
31 Mar 22 Pumas TabascoPumas 1 - 2 Correcaminos UATCorrecamino 66
31 Mar 22 Tlaxcala FCTlaxcala 2 - 1 Raya2 ExpansiónRaya2 144
01 Abr 22 Tepatitlán FCTepatitlán 2 - 1 CA MoreliaCA Morelia 239
02 Abr 22 Leones NegrosLeones 1 - 1 Tampico MaderoTampico 38
Ver jornada
Jornada 16
06 Abr 22 Alebrijes de OaxacaAlebrijes 0 - 0 Pumas TabascoPumas 131
08 Abr 22 Raya2 ExpansiónRaya2 0 - 2 Tepatitlán FCTepatitlán 213
06 Abr 22 DoradosDorados 2 - 1 Atlante FCAtlante FC 126
07 Abr 22 Mineros de ZacatecasMineros 1 - 1 Cimarrones de SonoraCimarrones 82
07 Abr 22 Tampico MaderoTampico 2 - 2 CelayaCelaya 59
07 Abr 22 CancúnCancún 1 - 0 Tlaxcala FCTlaxcala 124
08 Abr 22 CA MoreliaCA Morelia 2 - 2 Venados FCVenados FC 91
10 Abr 22 CD TapatíoTapatío 1 - 1 Leones NegrosLeones 48
Ver jornada
Jornada 17
13 Abr 22 Tlaxcala FCTlaxcala 1 - 0 Tampico MaderoTampico 62
13 Abr 22 Correcaminos UATCorrecamino 0 - 1 Alebrijes de OaxacaAlebrijes 92
13 Abr 22 Cimarrones de SonoraCimarrones 2 - 0 Tepatitlán FCTepatitlán 76
14 Abr 22 Leones NegrosLeones 1 - 0 CancúnCancún 89
14 Abr 22 Pumas TabascoPumas 0 - 1 CA MoreliaCA Morelia 24
14 Abr 22 CelayaCelaya 1 - 0 Venados FCVenados FC 99
15 Abr 22 Atlante FCAtlante FC 2 - 1 Mineros de ZacatecasMineros 36
16 Abr 22 CD TapatíoTapatío 1 - 2 Raya2 ExpansiónRaya2 51

Clasificación

Equipo PJ GF GC Puntos
1 Alebrijes de Oaxaca Alebrijes 16 21 13 34
2 Leones Negros Leones 16 21 16 33
3 Celaya Celaya 16 23 15 30
4 CA Morelia CA Morelia 16 24 19 27
5 Mineros de Zacatecas Mineros 16 23 18 27
6 Cancún Cancún 16 15 17 26
7 Atlante FC Atlante FC 16 15 15 25
8 Cimarrones de Sonora Cimarrones 16 20 14 24
9 CD Tapatío CD Tapatío 16 14 16 24
10 Venados FC Venados FC 16 17 16 23
11 Tepatitlán FC Tepatitlán 16 17 17 23
12 Tlaxcala FC Tlaxcala FC 16 18 19 23
13 Dorados Dorados 16 16 24 22
14 Correcaminos UAT Correcaminos 16 18 21 19
15 Raya2 Expansión Raya2 16 14 17 18
16 Pumas Tabasco Pumas 16 13 25 12
17 Tampico Madero Tampico 16 14 21 11

  USO DE MEMORIA  
5,994,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.4070
Total Execution Time  0.4093
  CADENA URL  
/liga_de_expansion_mx_clausura2022/grupo1/calendario
  GET DATOS  
$_GET['/liga_de_expansion_mx_clausura2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0144  SELECT type FROM routes WHERE alias = 'liga_de_expansion_mx_clausura2022'
0.0292  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2369 AND type_rel = 3
0.0146  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.0145  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2368 ORDER BY order_id ASC
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 = 66236 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153  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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66236 ORDER BY round ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 18:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 18:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 18:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 18:39:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0226  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 events2022 e ON e.player_id = p.id AND e.league_id = 66236 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66236 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.0244  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 events2022 e ON e.player_id = p.id AND e.league_id = 66236 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66236 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  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 events2022 e ON e.player_id = p.id AND e.league_id = 66236 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66236 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0156  SELECT *,(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 = 66236 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC