4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Chivas Guadalajara Sub 18
TEMPORADA 2023/2024
LIGA MX SUB 18 - APERTURA
Equipo PJ GF GC Puntos
1 Pumas UNAM Sub 18 Pumas UNAM 17 34 16 41
2 Monterrey Sub 18 Monterrey 17 35 24 33
3 Necaxa Sub 18 Necaxa 17 31 15 31
4 Tijuana Sub 18 Tijuana 17 28 29 31
5 Toluca Sub 18 Toluca 17 27 16 28
6 Tigres UANL Sub 18 Tigres UANL 17 33 25 26
7 América Sub 18 América 17 30 27 25
8 León Sub 18 León 17 28 30 23
9 Santos Laguna Sub 18 Santos 17 34 32 21
10 Pachuca Sub 18 Pachuca 17 25 23 21
11 Atl. San Luis Sub 18 Atl. Luis 17 18 24 21
12 Chivas Guadalajara Sub 18 Chivas 17 14 17 19
13 Atlas Guadalajara Sub 18 Atlas 17 25 28 18
14 Cruz Azul Sub 18 Cruz Azul 17 14 22 18
15 Puebla Sub 18 Puebla 17 22 33 17
16 Mazatlán FC Sub 18 Mazatlán 17 28 37 16
17 Querétaro Sub 18 Querétaro 17 16 32 16
18 FC Juárez Sub 18 Juárez 17 15 27 15
TEMPORADA 2022/2023
LIGA MX SUB 18 - CLAUSURA
Equipo PJ GF GC Puntos
1 Tigres UANL Sub 18 Tigres UANL 17 38 18 38
2 Monterrey Sub 18 Monterrey 17 23 16 36
3 Cruz Azul Sub 18 Cruz Azul 17 22 16 34
4 Atlas Guadalajara Sub 18 Atlas 17 27 20 31
5 Necaxa Sub 18 Necaxa 17 36 20 30
6 Toluca Sub 18 Toluca 17 19 15 29
7 América Sub 18 América 17 36 17 27
8 Chivas Guadalajara Sub 18 Chivas 17 30 22 25
9 Querétaro Sub 18 Querétaro 17 22 25 25
10 Puebla Sub 18 Puebla 17 13 20 22
11 Mazatlán FC Sub 18 Mazatlán 17 15 22 21
12 FC Juárez Sub 18 Juárez 17 20 34 19
13 Pachuca Sub 18 Pachuca 17 23 29 18
14 León Sub 18 León 17 25 33 17
15 Pumas UNAM Sub 18 Pumas UNAM 17 15 23 17
16 Santos Laguna Sub 18 Santos 17 24 35 15
17 Atl. San Luis Sub 18 Atl. Luis 17 22 34 15
18 Tijuana Sub 18 Tijuana 17 22 33 12
TEMPORADA 2021/2022
LIGA MX SUB 18 - CLAUSURA
Equipo PJ GF GC Puntos
1 América Sub 18 América 17 39 19 37
2 León Sub 18 León 17 28 23 34
3 Atlas Guadalajara Sub 18 Atlas 17 26 13 33
4 Santos Laguna Sub 18 Santos 17 34 18 32
5 Chivas Guadalajara Sub 18 Chivas 17 34 21 29
6 Tijuana Sub 18 Tijuana 17 31 26 29
7 Pachuca Sub 18 Pachuca 17 28 24 27
8 Pumas UNAM Sub 18 Pumas UNAM 17 25 21 27
9 Toluca Sub 18 Toluca 17 25 18 25
10 Cruz Azul Sub 18 Cruz Azul 17 21 22 24
11 Atl. San Luis Sub 18 Atl. Luis 17 24 24 23
12 Necaxa Sub 18 Necaxa 17 26 28 20
13 Monterrey Sub 18 Monterrey 17 27 36 18
14 Tigres UANL Sub 18 Tigres UANL 17 17 34 16
15 Mazatlán FC Sub 18 Mazatlán 17 20 33 15
16 Querétaro Sub 18 Querétaro 17 15 27 14
17 FC Juárez Sub 18 Juárez 17 19 34 11
18 Puebla Sub 18 Puebla 17 17 35 9

  USO DE MEMORIA  
5,243,592 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1034
Total Execution Time  0.1046
  CADENA URL  
/historico/Guadalajara-Sub18
  GET DATOS  
$_GET['/historico/Guadalajara-Sub18']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0027  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Guadalajara-Sub18' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=143626 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=143626 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=143626 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0046  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 75044
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=143626 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2495 AND type_rel = 3
0.0023  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '143626' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '143626' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '143626' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72216 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 75044 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=143626 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0024  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (75044,72216) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75044 AND teamId = 143626
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72216 AND teamId = 143626
0.0021  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 75044 AND t.round = 17 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '143626' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '143626' and rp.type = 4
0.0020  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '143626' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75044 WHERE rp.league_id = 75044 AND rp.teamId = 143626 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75044 WHERE rp.league_id = 75044 AND rp.teamId = 143626 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 75044 WHERE rp.league_id = 75044 AND rp.teamId = 143626 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 143626 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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 `tables2024` 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 = 75044 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.0022  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 `tables2024` 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 = 72216 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.0022  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 `tables2023` 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 = 68143 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.0027  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 `tables2023` 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 = 70833 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.0022  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 = 64074 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.0023  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 = 66517 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