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

  USO DE MEMORIA  
6,165,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.5021
Total Execution Time  0.5054
  CADENA URL  
/liga_mexico_sub_17_clausura2021/grupo1/historico
  GET DATOS  
$_GET['/liga_mexico_sub_17_clausura2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0125  SELECT type FROM routes WHERE alias = 'liga_mexico_sub_17_clausura2021'
0.0263  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_17_clausura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1553 AND type_rel = 3
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1553 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (816274,766075,613374) ORDER BY n.cover_points DESC, update_date DESC
0.0127  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1553 ORDER BY order_id ASC
0.0126  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1553 GROUP BY l.categoryId
0.0127  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=1553 GROUP BY l.year ORDER BY l.year DESC
0.0128  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 = 60791 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 1553 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0135  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 = 60791 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.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 `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 = 53467 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.0139  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 = 48589 AND t.round = 17 ORDER BY team.conference 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 `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 = 41858 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134  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 = 37584 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 15834 AND t.round = 17 ORDER BY team.conference 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 `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 = 9275 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 25078 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-27 18:17:52' 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=2 AND last_update > '2024-04-27 18:17:52' 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-27 18:17:52' 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=3 AND last_update > '2024-04-27 18:17:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  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_17_clausura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0179  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 events2021 e ON e.player_id = p.id AND e.league_id = 60791 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60791 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.0370  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 events2021 e ON e.player_id = p.id AND e.league_id = 60791 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60791 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 events2021 e ON e.player_id = p.id AND e.league_id = 60791 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60791 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0139  SELECT *,(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 = 60791 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