4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
12 Jul 19 NecaxaNecaxa 1 - 3 Cruz AzulCruz Azul ...
13 Jul 19 UNAMUNAM 2 - 0 TijuanaTijuana ...
14 Jul 19 PueblaPuebla 0 - 3 TolucaToluca ...
15 Jul 19 MoreliaMorelia 0 - 1 MonterreyMonterrey ...
16 Jul 19 VeracruzVeracruz 2 - 2 QuerétaroQuerétaro ...
16 Jul 19 LeónLeón 1 - 1 FC JuárezFC Juárez 1
16 Jul 19 Tigres UANLTigres UANL 2 - 1 GuadalajaraGuadalajara 3
16 Jul 19 Atl. San LuisAtl. Luis 1 - 6 AtlasAtlas ...
16 Jul 19 Santos LagunaSantos 1 - 4 PachucaPachuca 3
Jornada 2
19 Jul 19 Cruz AzulCruz Azul 3 - 2 UNAMUNAM ...
19 Jul 19 QuerétaroQuerétaro 2 - 1 LeónLeón ...
20 Jul 19 FC JuárezFC Juárez 0 - 3 Santos LagunaSantos ...
20 Jul 19 AtlasAtlas 1 - 2 MonterreyMonterrey ...
23 Jul 19 AméricaAmérica 0 - 1 PueblaPuebla 2
23 Jul 19 TolucaToluca 4 - 2 MoreliaMorelia ...
23 Jul 19 GuadalajaraGuadalajara 2 - 1 Atl. San LuisAtl. Luis ...
23 Jul 19 PachucaPachuca 1 - 0 NecaxaNecaxa ...
23 Jul 19 TijuanaTijuana 1 - 1 VeracruzVeracruz ...
Jornada 3
26 Jul 19 NecaxaNecaxa 0 - 3 GuadalajaraGuadalajara ...
27 Jul 19 UNAMUNAM 1 - 2 QuerétaroQuerétaro 1
28 Jul 19 PueblaPuebla 0 - 2 PachucaPachuca 1
29 Jul 19 MoreliaMorelia 2 - 1 FC JuárezFC Juárez 1
30 Jul 19 VeracruzVeracruz 2 - 0 AtlasAtlas 1
30 Jul 19 LeónLeón 0 - 2 Cruz AzulCruz Azul 1
30 Jul 19 Atl. San LuisAtl. Luis 0 - 0 AméricaAmérica 1
30 Jul 19 Santos LagunaSantos 2 - 2 Tigres UANLTigres UANL ...
29 Jul 19 MonterreyMonterrey 4 - 0 TolucaToluca 1
Jornada 4
02 Ago 19 QuerétaroQuerétaro 1 - 0 Santos LagunaSantos ...
02 Ago 19 Cruz AzulCruz Azul 2 - 1 MoreliaMorelia ...
03 Ago 19 FC JuárezFC Juárez 0 - 0 Atl. San LuisAtl. Luis ...
06 Ago 19 AméricaAmérica 3 - 1 VeracruzVeracruz ...
05 Ago 19 TolucaToluca 1 - 1 LeónLeón ...
04 Ago 19 GuadalajaraGuadalajara 1 - 0 PueblaPuebla ...
06 Ago 19 PachucaPachuca 4 - 2 MonterreyMonterrey ...
06 Ago 19 Tigres UANLTigres UANL 0 - 0 UNAMUNAM ...
06 Ago 19 TijuanaTijuana 1 - 1 AtlasAtlas ...
Jornada 5
09 Ago 19 Cruz AzulCruz Azul 0 - 1 TolucaToluca ...
10 Ago 19 AtlasAtlas 1 - 1 AméricaAmérica ...
12 Ago 19 UNAMUNAM 1 - 2 PachucaPachuca ...
11 Ago 19 PueblaPuebla 3 - 1 FC JuárezFC Juárez ...
12 Ago 19 MoreliaMorelia 3 - 3 Tigres UANLTigres UANL ...
13 Ago 19 LeónLeón 2 - 1 GuadalajaraGuadalajara ...
13 Ago 19 Atl. San LuisAtl. Luis 2 - 1 VeracruzVeracruz ...
13 Ago 19 MonterreyMonterrey 6 - 1 QuerétaroQuerétaro ...
13 Ago 19 TijuanaTijuana 2 - 0 NecaxaNecaxa ...
Jornada 6
16 Ago 19 NecaxaNecaxa 0 - 0 UNAMUNAM 1
17 Ago 19 FC JuárezFC Juárez 0 - 6 AtlasAtlas ...
20 Ago 19 AméricaAmérica 3 - 1 MoreliaMorelia ...
18 Ago 19 VeracruzVeracruz 1 - 0 LeónLeón ...
20 Ago 19 GuadalajaraGuadalajara 0 - 1 TijuanaTijuana ...
20 Ago 19 PachucaPachuca 1 - 2 TolucaToluca ...
20 Ago 19 Tigres UANLTigres UANL 4 - 0 PueblaPuebla ...
20 Ago 19 Atl. San LuisAtl. Luis 2 - 1 Cruz AzulCruz Azul ...
20 Ago 19 Santos LagunaSantos 1 - 2 MonterreyMonterrey ...
Jornada 7
21 Ago 19 AtlasAtlas 2 - 0 NecaxaNecaxa ...
22 Ago 19 Cruz AzulCruz Azul 0 - 2 Tigres UANLTigres UANL ...
22 Ago 19 QuerétaroQuerétaro 1 - 2 PueblaPuebla ...
21 Ago 19 UNAMUNAM 0 - 0 VeracruzVeracruz ...
23 Ago 19 TolucaToluca 1 - 2 AméricaAmérica ...
22 Ago 19 MoreliaMorelia 2 - 0 Atl. San LuisAtl. Luis ...
23 Ago 19 LeónLeón 1 - 1 PachucaPachuca ...
23 Ago 19 MonterreyMonterrey 2 - 1 FC JuárezFC Juárez ...
23 Ago 19 TijuanaTijuana 4 - 2 Santos LagunaSantos 1
Jornada 8
27 Ago 19 AméricaAmérica 2 - 0 TijuanaTijuana ...
25 Ago 19 PueblaPuebla 0 - 0 UNAMUNAM ...
25 Ago 19 NecaxaNecaxa 0 - 2 MoreliaMorelia ...
27 Ago 19 VeracruzVeracruz 0 - 0 TolucaToluca ...
27 Ago 19 PachucaPachuca 3 - 1 Cruz AzulCruz Azul ...
27 Ago 19 Tigres UANLTigres UANL 3 - 2 MonterreyMonterrey ...
27 Ago 19 Atl. San LuisAtl. Luis 0 - 2 QuerétaroQuerétaro ...
27 Ago 19 GuadalajaraGuadalajara 1 - 0 FC JuárezFC Juárez ...
27 Ago 19 Santos LagunaSantos 0 - 0 AtlasAtlas ...
Jornada 9
06 Sep 19 Cruz AzulCruz Azul 3 - 3 GuadalajaraGuadalajara ...
06 Sep 19 QuerétaroQuerétaro 0 - 3 PachucaPachuca 1
10 Sep 19 FC JuárezFC Juárez 0 - 0 NecaxaNecaxa ...
07 Sep 19 AtlasAtlas 2 - 0 PueblaPuebla ...
07 Sep 19 UNAMUNAM 4 - 0 Santos LagunaSantos ...
10 Sep 19 TolucaToluca 0 - 0 Tigres UANLTigres UANL 3
09 Sep 19 MoreliaMorelia 2 - 1 LeónLeón ...
10 Sep 19 MonterreyMonterrey 4 - 1 AméricaAmérica ...
10 Sep 19 TijuanaTijuana 3 - 0 Atl. San LuisAtl. Luis ...
Jornada 10
13 Sep 19 QuerétaroQuerétaro 1 - 1 TijuanaTijuana ...
17 Sep 19 TolucaToluca 1 - 0 FC JuárezFC Juárez ...
15 Sep 19 PueblaPuebla 1 - 3 MoreliaMorelia ...
17 Sep 19 GuadalajaraGuadalajara 4 - 2 AméricaAmérica ...
17 Sep 19 PachucaPachuca 2 - 2 AtlasAtlas ...
17 Sep 19 LeónLeón 3 - 0 NecaxaNecaxa ...
15 Sep 19 Tigres UANLTigres UANL 4 - 0 Atl. San LuisAtl. Luis ...
13 Sep 19 MonterreyMonterrey 4 - 0 VeracruzVeracruz ...
17 Sep 19 Santos LagunaSantos 2 - 0 Cruz AzulCruz Azul ...
Jornada 11
19 Sep 19 TijuanaTijuana 4 - 1 MoreliaMorelia ...
20 Sep 19 FC JuárezFC Juárez 1 - 0 UNAMUNAM ...
19 Sep 19 NecaxaNecaxa 2 - 3 PueblaPuebla ...
19 Sep 19 AtlasAtlas 3 - 0 TolucaToluca ...
20 Sep 19 AméricaAmérica 0 - 0 LeónLeón ...
20 Sep 19 GuadalajaraGuadalajara 2 - 1 QuerétaroQuerétaro ...
20 Sep 19 VeracruzVeracruz 0 - 1 Santos LagunaSantos ...
20 Sep 19 PachucaPachuca 3 - 2 Tigres UANLTigres UANL ...
20 Sep 19 Atl. San LuisAtl. Luis 1 - 5 MonterreyMonterrey ...
Jornada 12
22 Sep 19 Cruz AzulCruz Azul 3 - 0 FC JuárezFC Juárez ...
22 Sep 19 PueblaPuebla 2 - 1 VeracruzVeracruz ...
24 Sep 19 TolucaToluca 1 - 2 GuadalajaraGuadalajara ...
22 Sep 19 QuerétaroQuerétaro 0 - 5 AméricaAmérica ...
23 Sep 19 UNAMUNAM 2 - 0 Atl. San LuisAtl. Luis ...
23 Sep 19 MoreliaMorelia 0 - 0 AtlasAtlas ...
24 Sep 19 LeónLeón 2 - 0 Santos LagunaSantos ...
24 Sep 19 Tigres UANLTigres UANL 2 - 0 TijuanaTijuana ...
24 Sep 19 MonterreyMonterrey 4 - 0 NecaxaNecaxa ...
Jornada 13
27 Sep 19 NecaxaNecaxa 0 - 1 QuerétaroQuerétaro ...
28 Sep 19 FC JuárezFC Juárez 1 - 2 Tigres UANLTigres UANL ...
28 Sep 19 AtlasAtlas 2 - 2 Cruz AzulCruz Azul ...
01 Oct 19 AméricaAmérica 2 - 1 PachucaPachuca ...
28 Sep 19 UNAMUNAM 1 - 1 MoreliaMorelia ...
01 Oct 19 VeracruzVeracruz 1 - 1 GuadalajaraGuadalajara ...
01 Oct 19 Santos LagunaSantos 0 - 0 PueblaPuebla ...
01 Oct 19 Atl. San LuisAtl. Luis 1 - 2 LeónLeón ...
01 Oct 19 TijuanaTijuana 2 - 1 TolucaToluca ...
Jornada 14
11 Oct 19 Cruz AzulCruz Azul 4 - 0 VeracruzVeracruz 1
11 Oct 19 QuerétaroQuerétaro 0 - 4 AtlasAtlas ...
12 Oct 19 AméricaAmérica 0 - 0 UNAMUNAM ...
14 Oct 19 TolucaToluca 3 - 1 Atl. San LuisAtl. Luis ...
13 Oct 19 GuadalajaraGuadalajara 2 - 3 Santos LagunaSantos ...
13 Oct 19 PueblaPuebla 1 - 1 TijuanaTijuana ...
15 Oct 19 PachucaPachuca 5 - 1 FC JuárezFC Juárez ...
15 Oct 19 Tigres UANLTigres UANL 4 - 0 NecaxaNecaxa ...
15 Oct 19 LeónLeón 1 - 3 MonterreyMonterrey ...
Jornada 15
18 Oct 19 NecaxaNecaxa 1 - 2 TolucaToluca ...
19 Oct 19 AtlasAtlas 1 - 1 GuadalajaraGuadalajara 1
19 Oct 19 UNAMUNAM 1 - 0 LeónLeón ...
19 Oct 19 MoreliaMorelia 2 - 0 QuerétaroQuerétaro ...
22 Oct 19 VeracruzVeracruz 0 - 2 Tigres UANLTigres UANL ...
22 Oct 19 Santos LagunaSantos 0 - 1 AméricaAmérica ...
22 Oct 19 Atl. San LuisAtl. Luis 0 - 0 PueblaPuebla ...
19 Oct 19 MonterreyMonterrey 2 - 0 Cruz AzulCruz Azul ...
22 Oct 19 TijuanaTijuana 2 - 0 PachucaPachuca ...
Jornada 16
24 Oct 19 TolucaToluca 2 - 1 UNAMUNAM ...
23 Oct 19 Cruz AzulCruz Azul 1 - 1 QuerétaroQuerétaro ...
24 Oct 19 AméricaAmérica 3 - 0 NecaxaNecaxa ...
25 Oct 19 GuadalajaraGuadalajara 2 - 0 MoreliaMorelia ...
24 Oct 19 PueblaPuebla 0 - 1 MonterreyMonterrey 1
25 Oct 19 PachucaPachuca 3 - 2 VeracruzVeracruz ...
25 Oct 19 Tigres UANLTigres UANL 1 - 0 LeónLeón ...
25 Oct 19 Santos LagunaSantos 1 - 1 Atl. San LuisAtl. Luis ...
25 Oct 19 FC JuárezFC Juárez 0 - 3 TijuanaTijuana ...
Jornada 17
26 Oct 19 UNAMUNAM 1 - 2 AtlasAtlas ...
27 Oct 19 PueblaPuebla 0 - 0 Cruz AzulCruz Azul 1
27 Oct 19 QuerétaroQuerétaro 0 - 0 TolucaToluca ...
28 Oct 19 NecaxaNecaxa 1 - 0 Santos LagunaSantos ...
28 Oct 19 MoreliaMorelia 3 - 3 PachucaPachuca ...
29 Oct 19 VeracruzVeracruz 3 - 1 FC JuárezFC Juárez ...
29 Oct 19 LeónLeón 2 - 0 TijuanaTijuana 1
29 Oct 19 Tigres UANLTigres UANL 2 - 1 AméricaAmérica 1
29 Oct 19 MonterreyMonterrey 3 - 1 GuadalajaraGuadalajara ...
Jornada 18
02 Nov 19 FC JuárezFC Juárez 0 - 0 QuerétaroQuerétaro ...
02 Nov 19 AtlasAtlas 1 - 4 Tigres UANLTigres UANL 1
04 Nov 19 AméricaAmérica 1 - 1 Cruz AzulCruz Azul ...
03 Nov 19 GuadalajaraGuadalajara 1 - 1 UNAMUNAM ...
05 Nov 19 VeracruzVeracruz 1 - 0 NecaxaNecaxa ...
05 Nov 19 LeónLeón 3 - 3 PueblaPuebla ...
05 Nov 19 Santos LagunaSantos 1 - 2 MoreliaMorelia ...
05 Nov 19 Atl. San LuisAtl. Luis 0 - 3 PachucaPachuca ...
05 Nov 19 TijuanaTijuana 0 - 3 MonterreyMonterrey ...
Jornada 19
08 Nov 19 Cruz AzulCruz Azul 2 - 2 TijuanaTijuana ...
08 Nov 19 QuerétaroQuerétaro 0 - 2 Tigres UANLTigres UANL ...
08 Nov 19 NecaxaNecaxa 1 - 1 Atl. San LuisAtl. Luis ...
09 Nov 19 FC JuárezFC Juárez 0 - 2 AméricaAmérica ...
08 Nov 19 AtlasAtlas 1 - 3 LeónLeón ...
12 Nov 19 TolucaToluca 2 - 0 Santos LagunaSantos ...
11 Nov 19 MoreliaMorelia 3 - 1 VeracruzVeracruz ...
12 Nov 19 PachucaPachuca 1 - 2 GuadalajaraGuadalajara ...
12 Nov 19 MonterreyMonterrey 2 - 1 UNAMUNAM ...

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Monterrey Monterrey 18 52 16 48
2 Tigres UANL Tigres UANL 18 41 14 43
3 Pachuca Pachuca 18 42 24 36
4 América América 18 29 17 32
5 Guadalajara Guadalajara 18 30 23 31
6 Toluca Toluca 18 24 20 31
7 Tijuana Tijuana 18 27 21 29
8 Atlas Atlas 18 35 20 28
9 Morelia Morelia 18 30 28 28
10 Cruz Azul Cruz Azul 18 28 25 24
11 León León 18 23 21 23
12 Puebla Puebla 18 16 25 21
13 Querétaro Querétaro 18 15 32 20
14 UNAM UNAM 18 18 16 19
15 Veracruz Veracruz 18 17 29 17
16 Santos Laguna Santos 18 17 28 16
17 Atl. San Luis Atl. Luis 18 11 38 11
18 FC Juárez FC Juárez 18 8 37 7
19 Necaxa Necaxa 18 6 35 6

  USO DE MEMORIA  
6,154,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1080
Total Execution Time  0.1099
  CADENA URL  
/liga_mx_femenil_apertura2020/grupo1/calendario
  GET DATOS  
$_GET['/liga_mx_femenil_apertura2020/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0018  SELECT type FROM routes WHERE alias = 'liga_mx_femenil_apertura2020'
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_mx_femenil_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2035 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 = 50220 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042  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 calendars2020 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 50220 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 07:13:29' 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=2 AND last_update > '2024-04-28 07:13:29' 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 07:13:29' 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 07:13:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_mx_femenil_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027  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 events2020 e ON e.player_id = p.id AND e.league_id = 50220 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50220 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.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50220 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50220 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50220 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50220 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(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 = 50220 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC