4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Liga MX - Apertura 2022
2021/2022

liga mx, liga mexico, primera division mexicana, liga mx apertura, primera division mexicana apertura, liga bbva mx, liga bbva mexico,liga mexicana,apertura mexico

Liga MX - Apertura 2022

  • América
  • Atlas Guadalajara
  • León
  • Tigres UANL
  • Santos Laguna
  • Toluca
  • Puebla
  • Cruz Azul
  • Monterrey
  • Chivas Guadalajara
  • Pumas UNAM
  • Atl. San Luis
  • Mazatlán
  • Necaxa
  • Pachuca
  • FC Juárez
  • Querétaro
  • Tijuana
Jornada 1
23 Jul 21 QuerétaroQuerétaro 0 - 0 AméricaAmérica 80
24 Jul 21 NecaxaNecaxa 0 - 3 Santos LagunaSantos 85
24 Jul 21 FC JuárezFC Juárez 1 - 3 TolucaToluca 132
24 Jul 21 PachucaPachuca 4 - 0 LeónLeón 56
25 Jul 21 Chivas GuadalajaraChivas 1 - 2 Atl. San LuisAtl. Luis 130
25 Jul 21 Pumas UNAMPumas UNAM 0 - 0 Atlas GuadalajaraAtlas 52
26 Jul 21 MonterreyMonterrey 1 - 1 PueblaPuebla 97
26 Jul 21 TijuanaTijuana 1 - 2 Tigres UANLTigres UANL 46
27 Jul 21 Cruz AzulCruz Azul 0 - 2 MazatlánMazatlán 220
Jornada 2
31 Jul 21 MazatlánMazatlán 2 - 1 PachucaPachuca 143
31 Jul 21 PueblaPuebla 0 - 2 Chivas GuadalajaraChivas 220
01 Ago 21 AméricaAmérica 2 - 1 NecaxaNecaxa 99
01 Ago 21 MonterreyMonterrey 2 - 0 Pumas UNAMPumas UNAM 62
01 Ago 21 Atlas GuadalajaraAtlas 2 - 0 FC JuárezFC Juárez 84
01 Ago 21 TolucaToluca 3 - 1 Tigres UANLTigres UANL 99
01 Ago 21 LeónLeón 2 - 1 TijuanaTijuana 49
02 Ago 21 Santos LagunaSantos 1 - 1 Cruz AzulCruz Azul 115
03 Ago 21 Atl. San LuisAtl. Luis 1 - 1 QuerétaroQuerétaro 91
Jornada 3
06 Ago 21 QuerétaroQuerétaro 0 - 1 LeónLeón 238
07 Ago 21 MazatlánMazatlán 1 - 1 MonterreyMonterrey 146
07 Ago 21 NecaxaNecaxa 1 - 2 Cruz AzulCruz Azul 127
07 Ago 21 TijuanaTijuana 0 - 2 TolucaToluca 132
08 Ago 21 AméricaAmérica 2 - 0 PueblaPuebla 104
08 Ago 21 Tigres UANLTigres UANL 1 - 1 Santos LagunaSantos 108
08 Ago 21 Pumas UNAMPumas UNAM 1 - 3 Atl. San LuisAtl. Luis 31
08 Ago 21 Chivas GuadalajaraChivas 2 - 2 FC JuárezFC Juárez 92
10 Ago 21 PachucaPachuca 0 - 1 Atlas GuadalajaraAtlas 131
Jornada 4
13 Ago 21 Atl. San LuisAtl. Luis 0 - 2 NecaxaNecaxa 117
14 Ago 21 PueblaPuebla 1 - 1 Tigres UANLTigres UANL 163
14 Ago 21 FC JuárezFC Juárez 1 - 1 TijuanaTijuana 111
15 Ago 21 LeónLeón 3 - 0 MazatlánMazatlán 80
15 Ago 21 MonterreyMonterrey 3 - 1 PachucaPachuca 173
15 Ago 21 Cruz AzulCruz Azul 4 - 0 TolucaToluca 129
15 Ago 21 Pumas UNAMPumas UNAM 0 - 0 QuerétaroQuerétaro 74
16 Ago 21 Santos LagunaSantos 0 - 0 Chivas GuadalajaraChivas 127
16 Ago 21 Atlas GuadalajaraAtlas 0 - 1 AméricaAmérica 99
Jornada 5
18 Ago 21 Tigres UANLTigres UANL 3 - 0 QuerétaroQuerétaro 74
18 Ago 21 TijuanaTijuana 1 - 1 PueblaPuebla 93
18 Ago 21 NecaxaNecaxa 3 - 0 Pumas UNAMPumas UNAM 86
18 Ago 21 TolucaToluca 2 - 2 MazatlánMazatlán 153
19 Ago 21 Cruz AzulCruz Azul 1 - 1 MonterreyMonterrey 279
19 Ago 21 Santos LagunaSantos 1 - 1 Atlas GuadalajaraAtlas 176
19 Ago 21 Chivas GuadalajaraChivas 0 - 3 LeónLeón 148
19 Ago 21 FC JuárezFC Juárez 1 - 2 AméricaAmérica 216
04 Nov 21 PachucaPachuca 0 - 0 Atl. San LuisAtl. Luis 258
Jornada 6
21 Ago 21 MazatlánMazatlán 0 - 3 Tigres UANLTigres UANL 230
22 Ago 21 LeónLeón 1 - 1 Santos LagunaSantos 202
22 Ago 21 Atl. San LuisAtl. Luis 0 - 0 Cruz AzulCruz Azul 190
22 Ago 21 MonterreyMonterrey 0 - 0 Chivas GuadalajaraChivas 101
22 Ago 21 Pumas UNAMPumas UNAM 2 - 0 PueblaPuebla 73
22 Ago 21 Atlas GuadalajaraAtlas 0 - 0 TolucaToluca 129
23 Ago 21 NecaxaNecaxa 1 - 0 FC JuárezFC Juárez 116
23 Ago 21 QuerétaroQuerétaro 0 - 2 PachucaPachuca 155
23 Ago 21 AméricaAmérica 2 - 0 TijuanaTijuana 284
Jornada 7
28 Ago 21 PueblaPuebla 1 - 0 QuerétaroQuerétaro 158
28 Ago 21 MazatlánMazatlán 2 - 2 Atl. San LuisAtl. Luis 163
28 Ago 21 TijuanaTijuana 2 - 2 MonterreyMonterrey 97
29 Ago 21 Tigres UANLTigres UANL 1 - 1 Atlas GuadalajaraAtlas 110
29 Ago 21 LeónLeón 1 - 1 AméricaAmérica 167
29 Ago 21 TolucaToluca 2 - 1 Pumas UNAMPumas UNAM 60
29 Ago 21 Chivas GuadalajaraChivas 2 - 1 NecaxaNecaxa 168
30 Ago 21 Santos LagunaSantos 2 - 0 FC JuárezFC Juárez 128
30 Ago 21 Cruz AzulCruz Azul 1 - 1 PachucaPachuca 369
Jornada 8
11 Sep 21 PueblaPuebla 2 - 2 Atl. San LuisAtl. Luis 247
11 Sep 21 TijuanaTijuana 2 - 1 Santos LagunaSantos 152
11 Sep 21 FC JuárezFC Juárez 2 - 1 Cruz AzulCruz Azul 149
12 Sep 21 Tigres UANLTigres UANL 2 - 2 LeónLeón 138
12 Sep 21 AméricaAmérica 2 - 0 MazatlánMazatlán 135
12 Sep 21 Atlas GuadalajaraAtlas 2 - 1 MonterreyMonterrey 186
13 Sep 21 QuerétaroQuerétaro 3 - 0 NecaxaNecaxa 132
13 Sep 21 Pumas UNAMPumas UNAM 0 - 0 Chivas GuadalajaraChivas 128
14 Sep 21 PachucaPachuca 1 - 2 TolucaToluca 295
Jornada 9
17 Sep 21 Atl. San LuisAtl. Luis 4 - 1 TijuanaTijuana 177
18 Sep 21 NecaxaNecaxa 0 - 3 Atlas GuadalajaraAtlas 224
19 Sep 21 MazatlánMazatlán 2 - 2 Pumas UNAMPumas UNAM 86
19 Sep 21 TolucaToluca 3 - 1 AméricaAmérica 142
19 Sep 21 Chivas GuadalajaraChivas 1 - 0 PachucaPachuca 109
19 Sep 21 LeónLeón 0 - 1 FC JuárezFC Juárez 233
20 Sep 21 MonterreyMonterrey 2 - 0 Tigres UANLTigres UANL 166
20 Sep 21 Cruz AzulCruz Azul 2 - 0 QuerétaroQuerétaro 76
20 Sep 21 Santos LagunaSantos 1 - 1 PueblaPuebla 139
Jornada 10
24 Sep 21 PachucaPachuca 1 - 0 NecaxaNecaxa 154
25 Sep 21 PueblaPuebla 1 - 1 Cruz AzulCruz Azul 191
09 Oct 21 FC JuárezFC Juárez 0 - 0 QuerétaroQuerétaro 193
25 Sep 21 TijuanaTijuana 0 - 0 MazatlánMazatlán 262
26 Sep 21 Tigres UANLTigres UANL 0 - 0 Pumas UNAMPumas UNAM 142
26 Sep 21 AméricaAmérica 0 - 0 Chivas GuadalajaraChivas 226
26 Sep 21 TolucaToluca 1 - 2 Atl. San LuisAtl. Luis 67
26 Sep 21 Atlas GuadalajaraAtlas 2 - 0 LeónLeón 159
27 Sep 21 Santos LagunaSantos 1 - 2 MonterreyMonterrey 154
Jornada 11
23 Sep 21 MonterreyMonterrey 2 - 0 TolucaToluca 140
29 Sep 21 Atlas GuadalajaraAtlas 0 - 1 PueblaPuebla 241
29 Sep 21 PachucaPachuca 1 - 1 AméricaAmérica 142
29 Sep 21 MazatlánMazatlán 3 - 1 FC JuárezFC Juárez 128
29 Sep 21 NecaxaNecaxa 3 - 0 TijuanaTijuana 148
30 Sep 21 QuerétaroQuerétaro 1 - 0 Chivas GuadalajaraChivas 225
30 Sep 21 Atl. San LuisAtl. Luis 0 - 3 Tigres UANLTigres UANL 126
04 Nov 21 Cruz AzulCruz Azul 0 - 1 LeónLeón 329
05 Nov 21 Pumas UNAMPumas UNAM 0 - 3 Santos LagunaSantos 114
Jornada 12
02 Oct 21 PueblaPuebla 1 - 2 PachucaPachuca 150
02 Oct 21 FC JuárezFC Juárez 3 - 1 MonterreyMonterrey 293
03 Oct 21 Chivas GuadalajaraChivas 0 - 1 Atlas GuadalajaraAtlas 130
04 Oct 21 AméricaAmérica 2 - 0 Pumas UNAMPumas UNAM 101
03 Oct 21 TolucaToluca 1 - 1 QuerétaroQuerétaro 40
03 Oct 21 LeónLeón 0 - 0 Atl. San LuisAtl. Luis 174
03 Oct 21 Santos LagunaSantos 1 - 0 MazatlánMazatlán 34
04 Oct 21 TijuanaTijuana 0 - 1 Cruz AzulCruz Azul 83
04 Oct 21 Tigres UANLTigres UANL 0 - 0 NecaxaNecaxa 146
Jornada 13
15 Oct 21 QuerétaroQuerétaro 1 - 1 TijuanaTijuana 180
16 Oct 21 NecaxaNecaxa 0 - 1 PueblaPuebla 99
16 Oct 21 MazatlánMazatlán 1 - 0 Atlas GuadalajaraAtlas 140
17 Oct 21 PachucaPachuca 1 - 1 Santos LagunaSantos 76
17 Oct 21 Atl. San LuisAtl. Luis 0 - 1 AméricaAmérica 253
17 Oct 21 Cruz AzulCruz Azul 1 - 1 Tigres UANLTigres UANL 95
17 Oct 21 Pumas UNAMPumas UNAM 1 - 0 FC JuárezFC Juárez 74
17 Oct 21 MonterreyMonterrey 0 - 1 LeónLeón 166
18 Oct 21 Chivas GuadalajaraChivas 2 - 0 TolucaToluca 98
Jornada 14
22 Sep 21 FC JuárezFC Juárez 1 - 0 Atl. San LuisAtl. Luis 182
20 Oct 21 PueblaPuebla 2 - 0 MazatlánMazatlán 129
20 Oct 21 AméricaAmérica 2 - 1 Santos LagunaSantos 208
20 Oct 21 Atlas GuadalajaraAtlas 0 - 0 Cruz AzulCruz Azul 208
20 Oct 21 QuerétaroQuerétaro 1 - 0 MonterreyMonterrey 200
21 Oct 21 TolucaToluca 1 - 1 NecaxaNecaxa 137
21 Oct 21 LeónLeón 1 - 2 Pumas UNAMPumas UNAM 254
21 Oct 21 Tigres UANLTigres UANL 3 - 0 PachucaPachuca 69
21 Oct 21 TijuanaTijuana 0 - 0 Chivas GuadalajaraChivas 164
Jornada 15
23 Oct 21 MazatlánMazatlán 2 - 1 QuerétaroQuerétaro 183
24 Oct 21 AméricaAmérica 1 - 0 Tigres UANLTigres UANL 235
24 Oct 21 Chivas GuadalajaraChivas 1 - 1 Cruz AzulCruz Azul 123
24 Oct 21 Pumas UNAMPumas UNAM 3 - 1 TijuanaTijuana 38
24 Oct 21 PueblaPuebla 0 - 1 LeónLeón 130
24 Oct 21 MonterreyMonterrey 0 - 1 NecaxaNecaxa 262
25 Oct 21 Santos LagunaSantos 2 - 2 TolucaToluca 92
25 Oct 21 Atl. San LuisAtl. Luis 2 - 6 Atlas GuadalajaraAtlas 93
25 Oct 21 PachucaPachuca 1 - 1 FC JuárezFC Juárez 175
Jornada 16
29 Oct 21 Atlas GuadalajaraAtlas 0 - 2 TijuanaTijuana 305
30 Oct 21 NecaxaNecaxa 2 - 1 MazatlánMazatlán 173
30 Oct 21 FC JuárezFC Juárez 0 - 2 PueblaPuebla 182
31 Oct 21 QuerétaroQuerétaro 2 - 3 Santos LagunaSantos 123
31 Oct 21 PachucaPachuca 1 - 1 Pumas UNAMPumas UNAM 64
31 Oct 21 Tigres UANLTigres UANL 2 - 1 Chivas GuadalajaraChivas 94
31 Oct 21 TolucaToluca 0 - 0 LeónLeón 85
01 Nov 21 Cruz AzulCruz Azul 2 - 1 AméricaAmérica 179
01 Nov 21 Atl. San LuisAtl. Luis 1 - 1 MonterreyMonterrey 88
Jornada 17
05 Nov 21 Atlas GuadalajaraAtlas 2 - 0 QuerétaroQuerétaro 191
06 Nov 21 PueblaPuebla 1 - 0 TolucaToluca 181
06 Nov 21 MazatlánMazatlán 0 - 1 Chivas GuadalajaraChivas 184
07 Nov 21 LeónLeón 3 - 0 NecaxaNecaxa 94
07 Nov 21 AméricaAmérica 0 - 0 MonterreyMonterrey 252
07 Nov 21 Tigres UANLTigres UANL 3 - 0 FC JuárezFC Juárez 125
07 Nov 21 TijuanaTijuana 3 - 2 PachucaPachuca 154
08 Nov 21 Pumas UNAMPumas UNAM 4 - 3 Cruz AzulCruz Azul 144
08 Nov 21 Santos LagunaSantos 0 - 0 Atl. San LuisAtl. Luis 157

Clasificación

Equipo PJ GF GC Puntos
1 América América 17 21 10 35
2 Atlas Guadalajara Atlas 17 21 10 29
3 León León 17 20 14 29
4 Tigres UANL Tigres UANL 17 26 14 28
5 Santos Laguna Santos 17 23 16 24
6 Toluca Toluca 17 22 22 24
7 Puebla Puebla 17 16 16 24
8 Cruz Azul Cruz Azul 17 21 17 23
9 Monterrey Monterrey 17 19 16 22
10 Chivas Guadalajara Chivas 17 13 13 22
11 Pumas UNAM Pumas UNAM 17 17 23 21
12 Atl. San Luis Atl. Luis 17 19 23 20
13 Mazatlán Mazatlán 17 18 24 20
14 Necaxa Necaxa 17 16 22 20
15 Pachuca Pachuca 17 19 21 18
16 FC Juárez FC Juárez 17 14 25 16
17 Querétaro Querétaro 17 11 19 15
18 Tijuana Tijuana 17 16 27 15

  USO DE MEMORIA  
6,135,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0037
Controller Execution Time ( Home / Category )  0.3262
Total Execution Time  0.3299
  CADENA URL  
/apertura_mexico2022/grupo1/calendario
  GET DATOS  
$_GET['/apertura_mexico2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0127  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 = 63173 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0256  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 = 63173 ORDER BY round ASC
0.0133  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 12:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 12:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 12:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 12:02:11' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0175  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 = 63173 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63173 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.0218  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 = 63173 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63173 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 = 63173 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63173 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0258  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 = 63173 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