4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atl. San Luis

Atl. San Luis

Entrenador: Gustavo Leal

TEMPORADA 2023/2024
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 América América 17 30 12 35
2 Toluca Toluca 16 38 22 32
3 Cruz Azul Cruz Azul 16 22 14 30
4 Monterrey Monterrey 16 27 17 29
5 Tigres UANL Tigres UANL 16 30 22 28
6 Pachuca Pachuca 16 33 26 28
7 Chivas Guadalajara Chivas 16 23 17 28
8 Pumas UNAM Pumas UNAM 17 27 22 27
9 Necaxa Necaxa 16 28 24 27
10 Querétaro Querétaro 17 22 21 24
11 León León 16 22 24 23
12 FC Juárez FC Juárez 16 18 25 15
13 Santos Laguna Santos 16 15 25 15
14 Mazatlán Mazatlán 16 20 31 15
15 Tijuana Tijuana 16 20 26 14
16 Atlas Guadalajara Atlas 16 21 30 14
17 Atl. San Luis Atl. Luis 16 22 35 13
18 Puebla Puebla 17 18 43 5
TEMPORADA 2022/2023
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Monterrey Monterrey 17 35 14 40
2 América América 17 36 21 34
3 Chivas Guadalajara Chivas 17 28 18 34
4 Toluca Toluca 17 34 19 32
5 Pachuca Pachuca 17 32 24 31
6 León León 17 23 13 30
7 Tigres UANL Tigres UANL 17 20 17 25
8 Cruz Azul Cruz Azul 17 21 22 24
9 Atlas Guadalajara Atlas 17 27 22 21
10 Querétaro Querétaro 17 16 21 20
11 Puebla Puebla 17 26 32 20
12 Atl. San Luis Atl. Luis 17 16 21 19
13 Santos Laguna Santos 17 23 37 19
14 Pumas UNAM Pumas UNAM 17 24 32 18
15 Tijuana Tijuana 17 19 29 16
16 FC Juárez FC Juárez 17 17 25 15
17 Necaxa Necaxa 17 16 24 14
18 Mazatlán Mazatlán 17 19 41 7
TEMPORADA 2021/2022
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Pachuca Pachuca 17 30 15 38
2 Tigres UANL Tigres UANL 17 30 20 33
3 Atlas Guadalajara Atlas 17 21 15 27
4 América América 17 24 17 26
5 Puebla Puebla 17 25 19 26
6 Chivas Guadalajara Chivas 17 25 21 26
7 Monterrey Monterrey 17 21 17 26
8 Cruz Azul Cruz Azul 17 20 17 25
9 Necaxa Necaxa 17 21 21 23
10 Atl. San Luis Atl. Luis 17 21 22 23
11 Pumas UNAM Pumas UNAM 17 24 21 22
12 Mazatlán Mazatlán 17 20 24 21
13 León León 17 17 22 21
14 Santos Laguna Santos 17 25 25 20
15 Toluca Toluca 17 21 36 19
16 Querétaro Querétaro 17 18 21 17
17 Tijuana Tijuana 17 14 26 17
18 FC Juárez FC Juárez 17 10 28 11
TEMPORADA 2020/2021
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 17 26 11 41
2 América América 17 26 14 38
3 Puebla Puebla 17 25 14 28
4 Monterrey Monterrey 17 22 13 28
5 Santos Laguna Santos 17 18 13 26
6 León León 17 25 23 26
7 Atlas Guadalajara Atlas 17 20 15 25
8 Pachuca Pachuca 17 20 19 23
9 Chivas Guadalajara Chivas 17 21 21 23
10 Tigres UANL Tigres UANL 17 19 20 23
11 Toluca Toluca 17 26 24 22
12 Querétaro Querétaro 17 19 25 21
13 Mazatlán Mazatlán 17 19 26 21
14 Tijuana Tijuana 17 19 21 20
15 Pumas UNAM Pumas UNAM 17 10 12 18
16 FC Juárez FC Juárez 17 13 29 15
17 Atl. San Luis Atl. Luis 17 20 33 12
18 Necaxa Necaxa 17 14 29 11
TEMPORADA 2019/2020
LIGA MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Cruz Azul Cruz Azul 10 24 14 22
2 León León 10 23 14 21
3 Santos Laguna Santos 10 14 14 17
4 América América 10 11 11 17
5 Chivas Guadalajara Chivas 10 13 11 16
6 Pumas UNAM Pumas UNAM 10 20 19 15
7 Tigres UANL Tigres UANL 10 13 10 14
8 FC Juárez FC Juárez 10 20 18 14
9 CA Morelia CA Morelia 10 17 16 14
10 Puebla Puebla 10 7 7 14
11 Pachuca Pachuca 10 11 12 14
12 Querétaro Querétaro 10 13 15 14
13 Atl. San Luis Atl. Luis 10 11 15 13
14 Necaxa Necaxa 10 17 16 11
15 Toluca Toluca 10 16 18 10
16 Tijuana Tijuana 10 10 16 9
17 Atlas Guadalajara Atlas 10 10 17 9
18 Monterrey Monterrey 10 10 17 5
TEMPORADA 2018/2019
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Atl. San Luis Atl. Luis 14 22 11 28
2 Mineros de Zacatecas Mineros 14 17 9 25
3 Zacatepec Zacatepec 14 22 18 22
4 Cimarrones de Sonora Cimarrones 14 12 17 22
5 Dorados Dorados 14 21 19 20
6 Venados FC Venados FC 14 12 13 20
7 Alebrijes de Oaxaca Alebrijes 14 12 14 19
8 Celaya Celaya 14 14 16 18
9 Atlante FC Atlante FC 14 26 21 17
10 Leones Negros Leones 14 19 18 17
11 Correcaminos UAT Correcaminos 14 15 16 17
12 UAEM Potros UAEM Potros 14 13 17 17
13 Cafetaleros Cafetaleros 14 23 25 15
14 FC Juárez FC Juárez 14 12 16 15
15 Tampico Madero Tampico 14 16 26 11
TEMPORADA 2017/2018
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Mineros de Zacatecas Mineros 15 24 17 28
2 Dorados Dorados 15 20 13 26
3 Leones Negros Leones 15 21 18 25
4 Zacatepec Zacatepec 15 17 19 24
5 Alebrijes de Oaxaca Alebrijes 15 25 17 23
6 Atlante FC Atlante FC 15 16 12 23
7 Celaya Celaya 15 17 14 23
8 Cafetaleros Cafetaleros 15 24 21 22
9 Tampico Madero Tampico 15 14 11 22
10 Atl. San Luis Atl. Luis 15 18 22 20
11 Venados FC Venados FC 15 15 17 19
12 Correcaminos UAT Correcaminos 15 15 20 18
13 FC Juárez FC Juárez 15 12 16 15
14 Murciélagos Murciélagos 15 12 21 15
15 Cimarrones de Sonora Cimarrones 15 16 22 14
16 UAEM Potros UAEM Potros 15 11 17 11
TEMPORADA 2015/2016
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Leones Negros Leones 15 22 15 29
2 Necaxa Necaxa 15 21 12 28
3 Cafetaleros Cafetaleros 15 14 8 27
4 Celaya Celaya 15 20 13 26
5 Atlante FC Atlante FC 15 22 12 25
6 Mineros de Zacatecas Mineros 15 17 13 22
7 Correcaminos UAT Correcaminos 15 13 17 22
8 Alebrijes de Oaxaca Alebrijes 15 19 19 21
9 Venados FC Venados FC 15 17 14 20
10 FC Juárez FC Juárez 15 13 12 20
11 Deportivo Tepic Deportivo 15 20 19 19
12 Lobos BUAP Lobos BUAP 15 17 22 18
13 Murciélagos Murciélagos 15 18 30 16
14 Zacatepec Zacatepec 15 15 23 13
15 Atl. San Luis Atl. Luis 15 11 20 11
16 Cimarrones de Sonora Cimarrones 15 12 22 10
TEMPORADA 2014/2015
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Atl. San Luis Atl. Luis 13 20 10 24
2 Dorados Dorados 13 23 15 23
3 Lobos BUAP Lobos BUAP 13 20 11 22
4 Venados FC Venados FC 13 21 16 22
5 Necaxa Necaxa 13 15 14 21
6 Correcaminos UAT Correcaminos 13 18 15 20
7 Alebrijes de Oaxaca Alebrijes 13 18 16 20
8 Deportivo Tepic Deportivo 13 16 19 18
9 Mineros de Zacatecas Mineros 13 16 19 18
10 Irapuato Irapuato 13 12 16 16
11 Altamira Altamira 13 11 18 14
12 Atlante FC Atlante FC 13 12 19 13
13 Zacatepec Zacatepec 13 10 13 12
14 Celaya Celaya 13 14 25 10
TEMPORADA 2013/2014
ASCENSO MX - CLAUSURA
Equipo PJ GF GC Puntos
1 Correcaminos UAT Correcaminos 14 22 13 29
2 Tecos Tecos 14 23 15 24
3 Necaxa Necaxa 14 19 15 22
4 Leones Negros Leones 14 17 13 22
5 Alebrijes de Oaxaca Alebrijes 14 22 19 21
6 Delfines Delfines 14 20 17 20
7 Dorados Dorados 14 19 17 19
8 Lobos BUAP Lobos BUAP 14 17 19 19
9 Venados FC Venados FC 14 21 21 18
10 Cruz Azul Cruz Azul 14 17 17 18
11 Zacatepec Zacatepec 14 17 26 16
12 Atl. San Luis Atl. Luis 14 18 22 15
13 Ballenas Galeana Ballenas 14 17 22 15
14 Celaya Celaya 14 12 18 14
15 Altamira Altamira 14 11 18 12

  USO DE MEMORIA  
6,682,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4769
Total Execution Time  0.4782
  CADENA URL  
/historico/San-Luis
  GET DATOS  
$_GET['/historico/San-Luis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9133 AND type_rel = 2
0.0132  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9133 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  SELECT /*35 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 (51817,57844,811417,179362,177946) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '9133' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = '9133' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9133' and rp.type = 4
0.0130  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 = '9133' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0152  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 = 74881 WHERE rp.league_id = 74881 AND rp.teamId = 9133 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.0150  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 = 74881 WHERE rp.league_id = 74881 AND rp.teamId = 9133 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144  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 = 74881 WHERE rp.league_id = 74881 AND rp.teamId = 9133 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 = 9133 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 67724 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.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 `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 = 70544 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.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 `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
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 `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 = 66176 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 `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 = 56984 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 = 60360 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 = 49953 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
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 `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 = 51325 AND t.round = 10 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 = 44040 AND t.round = 15 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 `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 = 48497 AND t.round = 15 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 `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 = 38667 AND t.round = 15 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 `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 = 15285 AND t.round = 15 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 `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 = 20081 AND t.round = 15 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 = 3944 AND t.round = 13 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 `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 = 9009 AND t.round = 13 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 `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 = 45192 AND t.round = 15 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 `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 = 12850 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC