4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 León Sub 20 León 17 34 18 35
2 Pachuca Sub 20 Pachuca 17 30 17 33
3 América Sub 20 América 17 32 19 31
4 Tijuana Sub 20 Tijuana 17 25 19 31
5 Chivas Guadalajara Sub 20 Chivas 17 23 17 31
6 Toluca Sub 20 Toluca 17 25 19 29
7 Tigres UANL Sub 20 Tigres UANL 17 26 15 28
8 Santos Laguna Sub 20 Santos 17 23 25 28
9 Pumas UNAM Sub 20 Pumas UNAM 17 28 20 25
10 Atl. San Luis Sub 20 Atl. Luis 17 33 27 25
11 Necaxa Sub 20 Necaxa 17 25 25 23
12 Cruz Azul Sub 20 Cruz Azul 17 18 20 21
13 Mazatlán Sub 20 Mazatlán 17 20 28 20
14 Monterrey Sub 20 Monterrey 17 18 30 19
15 Atlas Guadalajara Sub 20 Atlas 17 13 21 15
16 FC Juárez Sub 20 Juárez 17 15 34 14
17 Puebla Sub 20 Puebla 17 18 41 9
18 Querétaro Sub 20 Querétaro 17 9 20 8
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Monterrey Sub 20 Monterrey 17 30 18 35
2 Pachuca Sub 20 Pachuca 17 37 22 34
3 América Sub 20 América 17 29 13 33
4 Tijuana Sub 20 Tijuana 17 26 16 31
5 Toluca Sub 20 Toluca 17 29 20 28
6 Atlas Guadalajara Sub 20 Atlas 17 25 19 28
7 FC Juárez Sub 20 Juárez 17 19 19 26
8 León Sub 20 León 17 26 29 26
9 Puebla Sub 20 Puebla 17 35 42 24
10 Tigres UANL Sub 20 Tigres UANL 17 27 20 23
11 Mazatlán Sub 20 Mazatlán 17 26 30 22
12 Atl. San Luis Sub 20 Atl. Luis 17 25 34 22
13 Santos Laguna Sub 20 Santos 17 27 24 20
14 Chivas Guadalajara Sub 20 Chivas 17 28 29 20
15 Necaxa Sub 20 Necaxa 17 19 26 16
16 Pumas UNAM Sub 20 Pumas UNAM 17 24 34 16
17 Cruz Azul Sub 20 Cruz Azul 17 11 27 15
18 Querétaro Sub 20 Querétaro 17 13 34 13
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Monterrey Sub 20 Monterrey 11 25 8 26
2 Santos Laguna Sub 20 Santos 10 19 10 19
3 Necaxa Sub 20 Necaxa 10 16 21 18
4 Toluca Sub 20 Toluca 10 13 8 15
5 Tijuana Sub 20 Tijuana 10 13 11 15
6 América Sub 20 América 10 15 9 14
7 Atlas Guadalajara Sub 20 Atlas 11 15 13 14
8 Atl. San Luis Sub 20 Atl. Luis 10 12 12 14
9 Chivas Guadalajara Sub 20 Chivas 10 9 8 13
10 Pachuca Sub 20 Pachuca 10 15 17 13
11 Cruz Azul Sub 20 Cruz Azul 10 13 16 13
12 León Sub 20 León 10 15 13 12
13 Morelia Sub 20 Morelia 10 8 12 11
14 Puebla Sub 20 Puebla 10 14 20 11
15 Tigres UANL Sub 20 Tigres UANL 10 8 13 10
16 Pumas UNAM Sub 20 Pumas UNAM 10 8 12 9
17 Querétaro Sub 20 Querétaro 10 11 16 9
18 FC Juárez Sub 20 Juárez 10 7 17 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Atlas Guadalajara Sub 20 Atlas 17 39 24 31
2 Pachuca Sub 20 Pachuca 17 32 20 29
3 Santos Laguna Sub 20 Santos 17 31 25 29
4 Monterrey Sub 20 Monterrey 17 29 25 27
5 Morelia Sub 20 Morelia 17 29 13 25
6 Toluca Sub 20 Toluca 17 29 19 25
7 Tigres UANL Sub 20 Tigres UANL 17 29 22 25
8 América Sub 20 América 17 19 15 25
9 Pumas UNAM Sub 20 Pumas UNAM 17 27 23 24
10 Cruz Azul Sub 20 Cruz Azul 17 17 18 24
11 Querétaro Sub 20 Querétaro 17 24 21 23
12 Necaxa Sub 20 Necaxa 17 22 21 22
13 Tijuana Sub 20 Tijuana 17 20 27 21
14 Chivas Guadalajara Sub 20 Chivas 17 26 32 19
15 Puebla Sub 20 Puebla 17 21 30 19
16 León Sub 20 León 17 18 26 17
17 Lobos BUAP Sub 20 Lobos BUAP 17 14 39 13
18 Veracruz Sub 20 Veracruz 17 7 33 13
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 América Sub 20 América 17 45 13 44
2 Chivas Guadalajara Sub 20 Chivas 17 28 16 37
3 Tigres UANL Sub 20 Tigres UANL 17 31 19 33
4 Pumas UNAM Sub 20 Pumas UNAM 17 30 20 33
5 Santos Laguna Sub 20 Santos 17 24 21 30
6 Puebla Sub 20 Puebla 17 36 32 25
7 Pachuca Sub 20 Pachuca 17 32 24 24
8 Cruz Azul Sub 20 Cruz Azul 17 20 21 24
9 Morelia Sub 20 Morelia 17 27 28 23
10 Atlas Guadalajara Sub 20 Atlas 17 26 28 23
11 Necaxa Sub 20 Necaxa 17 20 20 22
12 Tijuana Sub 20 Tijuana 17 20 21 22
13 Monterrey Sub 20 Monterrey 17 24 31 20
14 Lobos BUAP Sub 20 Lobos BUAP 17 25 28 17
15 Toluca Sub 20 Toluca 17 15 22 15
16 Querétaro Sub 20 Querétaro 17 18 31 15
17 León Sub 20 León 17 16 35 14
18 Veracruz Sub 20 Veracruz 17 12 39 8
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Monterrey Sub 20 Monterrey 17 29 13 35
2 Tigres UANL Sub 20 Tigres UANL 17 33 22 29
3 Morelia Sub 20 Morelia 17 27 18 28
4 Puebla Sub 20 Puebla 17 22 20 28
5 América Sub 20 América 17 34 26 27
6 Veracruz Sub 20 Veracruz 17 26 30 27
7 Necaxa Sub 20 Necaxa 17 21 19 26
8 Chivas Guadalajara Sub 20 Chivas 17 22 19 25
9 Cruz Azul Sub 20 Cruz Azul 17 22 26 25
10 León Sub 20 León 17 25 33 24
11 Atlas Guadalajara Sub 20 Atlas 17 22 20 23
12 Pumas UNAM Sub 20 Pumas UNAM 17 26 22 22
13 Pachuca Sub 20 Pachuca 17 20 25 20
14 Toluca Sub 20 Toluca 17 16 23 20
15 Chiapas Sub 20 Chiapas 17 23 35 17
16 Querétaro Sub 20 Querétaro 17 20 23 16
17 Tijuana Sub 20 Tijuana 17 21 30 16
18 Santos Laguna Sub 20 Santos 17 19 24 15
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Pachuca Sub 20 Pachuca 17 33 17 36
2 América Sub 20 América 17 33 14 34
3 León Sub 20 León 17 35 24 31
4 Tijuana Sub 20 Tijuana 17 22 15 31
5 Tigres UANL Sub 20 Tigres UANL 17 28 21 30
6 Querétaro Sub 20 Querétaro 17 27 13 29
7 Atlas Guadalajara Sub 20 Atlas 17 22 19 27
8 Santos Laguna Sub 20 Santos 17 20 21 26
9 Chivas Guadalajara Sub 20 Chivas 17 22 15 25
10 Toluca Sub 20 Toluca 17 30 25 23
11 Pumas UNAM Sub 20 Pumas UNAM 17 25 31 22
12 Puebla Sub 20 Puebla 17 21 27 17
13 Dorados Sub 20 Dorados 17 20 29 17
14 Chiapas Sub 20 Chiapas 17 17 26 16
15 Veracruz Sub 20 Veracruz 17 21 32 16
16 Morelia Sub 20 Morelia 17 13 29 14
17 Monterrey Sub 20 Monterrey 17 11 28 12
18 Cruz Azul Sub 20 Cruz Azul 17 17 31 10
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 América Sub 20 América 17 26 15 35
2 Tigres UANL Sub 20 Tigres UANL 17 32 22 33
3 Chivas Guadalajara Sub 20 Chivas 17 32 26 27
4 Morelia Sub 20 Morelia 17 37 31 26
5 Santos Laguna Sub 20 Santos 17 29 25 26
6 Cruz Azul Sub 20 Cruz Azul 17 23 19 26
7 Pachuca Sub 20 Pachuca 17 32 29 26
8 León Sub 20 León 17 31 26 24
9 Atlas Guadalajara Sub 20 Atlas 17 29 30 24
10 Chiapas Sub 20 Chiapas 17 32 35 22
11 Toluca Sub 20 Toluca 17 18 21 22
12 Tijuana Sub 20 Tijuana 17 28 30 21
13 Veracruz Sub 20 Veracruz 17 27 34 20
14 Querétaro Sub 20 Querétaro 17 17 18 19
15 Monterrey Sub 20 Monterrey 17 17 25 18
16 Pumas UNAM Sub 20 Pumas UNAM 17 21 27 16
17 U. Guadalajara Sub 20 Guadalajara 17 19 25 15
18 Puebla Sub 20 Puebla 17 20 32 15
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Pachuca Sub 20 Pachuca 17 31 19 31
2 Puebla Sub 20 Puebla 17 28 20 31
3 León Sub 20 León 17 35 25 29
4 Pumas UNAM Sub 20 Pumas UNAM 17 26 23 29
5 Morelia Sub 20 Morelia 17 30 23 27
6 Santos Laguna Sub 20 Santos 17 28 25 27
7 Atlas Guadalajara Sub 20 Atlas 17 26 25 27
8 Cruz Azul Sub 20 Cruz Azul 17 23 29 27
9 Atlante Sub 20 Atlante 17 27 25 24
10 Tigres UANL Sub 20 Tigres UANL 17 20 23 24
11 Tijuana Sub 20 Tijuana 17 30 29 22
12 Chiapas Sub 20 Chiapas 17 33 30 21
13 Chivas Guadalajara Sub 20 Chivas 17 26 27 21
14 Monterrey Sub 20 Monterrey 17 28 28 20
15 América Sub 20 América 17 22 24 19
16 Querétaro Sub 20 Querétaro 17 10 19 14
17 Toluca Sub 20 Toluca 17 20 31 13
18 Veracruz Sub 20 Veracruz 17 21 39 13

  USO DE MEMORIA  
6,314,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4859
Total Execution Time  0.4877
  CADENA URL  
/liga_mexico_sub_20_clausura2022/grupo1/historico
  GET DATOS  
$_GET['/liga_mexico_sub_20_clausura2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0124  SELECT type FROM routes WHERE alias = 'liga_mexico_sub_20_clausura2022'
0.0252  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_mexico_sub_20_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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1550 AND type_rel = 3
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1550 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1141556,1140299,1118173,1108904,981412) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1550 ORDER BY order_id ASC
0.0127  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1550 GROUP BY l.categoryId
0.0125  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=1550 GROUP BY l.year ORDER BY l.year DESC
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 = 66244 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1550 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0128  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 `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 = 66244 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
0.0129  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 = 60790 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
0.0131  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 = 53466 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2019` 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 = 48588 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 `tables2018` 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 = 41890 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2017` 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 = 37585 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 `tables2016` 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 = 15833 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2015` 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 = 9274 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 `tables2014` 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 = 25074 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 21:51:54' 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-23 21:51:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 21:51:54' 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-23 21:51:54' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_mexico_sub_20_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.0176  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 = 66244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66244 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.0205  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 = 66244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66244 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0137  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 = 66244 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 66244 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  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 = 66244 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