4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atlético Huila

Atlético Huila

Entrenador: Diego Corredor

Temporada 2023/2024
TEMPORADA 2023/2024
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Atlético Huila Atlético 12 21 4 33
2 Cúcuta Deportivo Cúcuta 13 18 11 25
3 Llaneros Llaneros 12 19 9 23
4 Tigres FC Tigres FC 13 18 10 22
5 Real Cartagena Real 12 15 8 20
6 Unión Magdalena Unión 12 20 16 19
7 Orsomarso SC Orsomarso 13 19 16 19
8 Deportes Quindío Deportes 12 15 13 17
9 Real Cundinamarca Real 13 19 19 16
10 Barranquilla Barranquilla 13 15 16 15
11 Boca Juniors de Cali Boca Juniors 13 11 16 15
12 Leones Leones 13 16 19 13
13 Internacional de Palmira Internaciona 13 13 17 13
14 Bogotá Bogotá 13 13 30 10
15 Real Santander Real 12 13 23 8
16 Atlético Fútbol Club Atlético 13 5 23 5
TEMPORADA 2022/2023
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 20 35 12 44
2 Independiente Medellín Independient 20 30 15 39
3 América de Cali América 20 35 19 37
4 Deportes Tolima Deportes 20 23 17 37
5 At. Nacional Nacional 20 33 21 33
6 Junior Junior 20 29 17 30
7 Millonarios Millonarios 20 21 20 30
8 Deportivo Cali Deportivo 20 25 25 28
9 Alianza FC Alianza FC 20 18 24 28
10 La Equidad La Equidad 20 19 20 26
11 Atlético Bucaramanga Atlético 20 20 22 26
12 Deportivo Pasto Deportivo 20 16 20 25
13 Santa Fe Santa Fe 20 21 29 24
14 Once Caldas Once Caldas 20 21 22 22
15 Unión Magdalena Unión 20 21 32 22
16 Atlético Huila Atlético 20 18 22 19
17 Deportivo Pereira Deportivo 20 19 28 19
18 Boyacá Chicó Boyacá 20 15 26 19
19 Jaguares FC Jaguares FC 20 7 21 14
20 Envigado Envigado 20 18 32 13
TEMPORADA 2021/2022
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 16 23 11 28
2 Deportes Quindío Deportes 16 24 16 28
3 Atlético Huila Atlético 16 32 22 25
4 Barranquilla Barranquilla 16 23 19 25
5 Llaneros Llaneros 16 18 14 25
6 Tigres FC Tigres FC 16 19 19 25
7 Boyacá Chicó Boyacá 16 16 10 24
8 Real Santander Real 16 18 15 24
9 Bogotá Bogotá 16 21 20 23
10 Atlético Fútbol Club Atlético 16 14 18 23
11 Cúcuta Deportivo Cúcuta 16 19 18 22
12 Leones Leones 16 22 24 19
13 Boca Juniors de Cali Boca Juniors 16 17 20 19
14 Real Cartagena Real 16 18 26 16
15 Real Cundinamarca Real 16 18 27 10
16 Orsomarso SC Orsomarso 16 7 30 7
TEMPORADA 2020/2021
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 32 13 42
2 Millonarios Millonarios 20 36 23 36
3 Deportes Tolima Deportes 20 25 13 36
4 Junior Junior 20 25 21 33
5 Deportivo Pereira Deportivo 20 24 21 33
6 Alianza FC Alianza FC 20 27 18 31
7 Deportivo Cali Deportivo 20 27 21 31
8 América de Cali América 20 25 19 29
9 Envigado Envigado 20 24 23 27
10 Atlético Bucaramanga Atlético 20 26 29 27
11 Jaguares FC Jaguares FC 20 23 26 27
12 Independiente Medellín Independient 20 14 15 26
13 Águilas Doradas Águilas 20 24 25 25
14 Santa Fe Santa Fe 20 21 22 25
15 La Equidad La Equidad 20 20 21 25
16 Deportes Quindío Deportes 20 18 24 22
17 Once Caldas Once Caldas 20 18 30 20
18 Patriotas Boyacá Patriotas 20 14 21 18
19 Deportivo Pasto Deportivo 20 13 28 16
20 Atlético Huila Atlético 20 12 35 10
TEMPORADA 2019/2020
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 0 0 0 0
2 Atlético Huila Atlético 0 0 0 0
3 Internacional de Palmira Internaciona 0 0 0 0
4 Atlético Fútbol Club Atlético 0 0 0 0
5 Barranquilla Barranquilla 0 0 0 0
6 Real Cundinamarca Real 0 0 0 0
7 Llaneros Llaneros 0 0 0 0
8 Tigres FC Tigres FC 0 0 0 0
9 Unión Magdalena Unión 0 0 0 0
10 Deportes Quindío Deportes 0 0 0 0
11 Orsomarso SC Orsomarso 0 0 0 0
12 Boca Juniors de Cali Boca Juniors 0 0 0 0
13 Real Cartagena Real 0 0 0 0
14 Real Santander Real 0 0 0 0
15 Bogotá Bogotá 0 0 0 0
16 Leones Leones 0 0 0 0
TEMPORADA 2018/2019
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 30 17 35
2 América de Cali América 20 29 26 35
3 Deportivo Cali Deportivo 20 34 25 34
4 Junior Junior 20 16 9 33
5 Santa Fe Santa Fe 20 22 12 32
6 Deportes Tolima Deportes 20 24 16 32
7 Alianza FC Alianza FC 20 17 14 32
8 Cúcuta Deportivo Cúcuta 20 28 28 32
9 Independiente Medellín Independient 20 32 26 31
10 Once Caldas Once Caldas 20 26 20 28
11 Millonarios Millonarios 20 24 27 28
12 Atlético Bucaramanga Atlético 20 23 23 25
13 Águilas Doradas Águilas 20 25 27 24
14 Deportivo Pasto Deportivo 20 24 25 23
15 Patriotas Boyacá Patriotas 20 19 20 23
16 Envigado Envigado 20 23 28 23
17 La Equidad La Equidad 20 19 24 20
18 Atlético Huila Atlético 20 13 24 16
19 Jaguares FC Jaguares FC 20 11 34 15
20 Unión Magdalena Unión 20 14 28 14
TEMPORADA 2017/2018
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 19 23 10 41
2 Independiente Medellín Independient 19 32 23 35
3 Deportes Tolima Deportes 19 22 14 33
4 Atlético Huila Atlético 19 20 12 30
5 Junior Junior 19 19 16 30
6 Deportivo Cali Deportivo 19 26 17 29
7 Patriotas Boyacá Patriotas 19 17 18 29
8 Once Caldas Once Caldas 19 26 26 27
9 Millonarios Millonarios 19 19 18 26
10 Envigado Envigado 19 19 19 26
11 La Equidad La Equidad 19 18 15 25
12 Santa Fe Santa Fe 19 20 19 25
13 Águilas Doradas Águilas 19 18 22 25
14 Jaguares FC Jaguares FC 19 16 23 25
15 Alianza FC Alianza FC 19 24 26 23
16 Atlético Bucaramanga Atlético 19 22 24 23
17 América de Cali América 19 22 31 22
18 Deportivo Pasto Deportivo 19 15 19 20
19 Boyacá Chicó Boyacá 19 16 32 16
20 Leones Leones 19 13 23 13
TEMPORADA 2016/2017
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Junior Junior 20 32 15 39
2 Santa Fe Santa Fe 20 21 10 39
3 At. Nacional Nacional 20 25 12 38
4 Millonarios Millonarios 20 26 14 36
5 Deportes Tolima Deportes 20 25 20 33
6 América de Cali América 20 19 15 31
7 La Equidad La Equidad 20 25 18 30
8 Jaguares FC Jaguares FC 20 25 21 28
9 Independiente Medellín Independient 20 23 20 27
10 Atlético Huila Atlético 20 21 23 27
11 Envigado Envigado 20 19 23 26
12 Tigres FC Tigres FC 20 13 19 26
13 Internacional de Palmira Internaciona 20 17 28 24
14 Deportivo Cali Deportivo 20 25 32 23
15 Deportivo Pasto Deportivo 20 25 29 21
16 Patriotas Boyacá Patriotas 20 19 25 21
17 Once Caldas Once Caldas 20 16 24 21
18 Alianza FC Alianza FC 20 16 28 19
19 Atlético Bucaramanga Atlético 20 18 24 18
20 Águilas Doradas Águilas 20 16 26 18
TEMPORADA 2015/2016
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 32 19 37
2 Deportivo Cali Deportivo 20 25 17 34
3 Deportes Tolima Deportes 20 25 16 33
4 Millonarios Millonarios 20 28 21 33
5 Santa Fe Santa Fe 20 22 15 33
6 Independiente Medellín Independient 20 31 26 33
7 Atlético Bucaramanga Atlético 20 24 19 32
8 Patriotas Boyacá Patriotas 20 23 19 32
9 Envigado Envigado 20 23 20 32
10 Alianza FC Alianza FC 20 22 17 30
11 Junior Junior 20 25 27 28
12 Águilas Doradas Águilas 20 23 28 26
13 Once Caldas Once Caldas 20 25 24 25
14 La Equidad La Equidad 20 24 27 23
15 Jaguares FC Jaguares FC 20 16 20 23
16 Atlético Huila Atlético 20 18 27 23
17 Fortaleza Fortaleza 20 20 28 20
18 Deportivo Pasto Deportivo 20 19 28 20
19 Internacional de Palmira Internaciona 20 22 34 14
20 Boyacá Chicó Boyacá 20 18 33 14
TEMPORADA 2014/2015
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 Atlético Huila Atlético 20 33 22 41
2 Envigado Envigado 20 21 13 36
3 Deportivo Cali Deportivo 20 36 24 35
4 Independiente Medellín Independient 20 31 22 35
5 Millonarios Millonarios 20 36 23 34
6 At. Nacional Nacional 20 33 24 34
7 Deportes Tolima Deportes 20 29 16 33
8 Junior Junior 20 27 16 33
9 Santa Fe Santa Fe 20 29 19 31
10 Águilas Doradas Águilas 20 23 16 30
11 Patriotas Boyacá Patriotas 20 17 18 27
12 La Equidad La Equidad 20 21 21 26
13 Once Caldas Once Caldas 20 29 32 23
14 Internacional de Palmira Internaciona 20 22 25 21
15 Jaguares FC Jaguares FC 20 21 32 21
16 Alianza FC Alianza FC 20 17 22 20
17 Boyacá Chicó Boyacá 20 16 29 17
18 Cúcuta Deportivo Cúcuta 20 16 33 15
19 Uniautónoma Uniautónoma 20 13 30 15
20 Deportivo Pasto Deportivo 20 11 44 9
TEMPORADA 2013/2014
APERTURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 18 35 22 34
2 Millonarios Millonarios 18 27 15 33
3 Junior Junior 18 20 17 33
4 Santa Fe Santa Fe 18 24 16 30
5 Once Caldas Once Caldas 18 27 17 29
6 Envigado Envigado 18 27 24 28
7 Águilas Doradas Águilas 18 21 23 28
8 La Equidad La Equidad 18 17 17 27
9 Alianza FC Alianza FC 18 23 28 27
10 Boyacá Chicó Boyacá 18 19 16 25
11 Independiente Medellín Independient 18 26 30 21
12 Deportivo Pasto Deportivo 18 28 26 20
13 Atlético Huila Atlético 18 23 26 19
14 Deportivo Cali Deportivo 18 16 22 19
15 Patriotas Boyacá Patriotas 18 20 30 19
16 Fortaleza Fortaleza 18 22 26 17
17 Uniautónoma Uniautónoma 18 20 30 17
18 Deportes Tolima Deportes 18 18 28 17

  USO DE MEMORIA  
6,693,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3913
Total Execution Time  0.3925
  CADENA URL  
/historico/Atletico-Huila
  GET DATOS  
$_GET['/historico/Atletico-Huila']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=365 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 365 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 (1735,1874,6306,7795,8070) ORDER BY n.cover_points DESC, update_date DESC
0.0139  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 = '365' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0134  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=365 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75230,74958,71432,70934,70737) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 70737 AND teamId = 365
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 70934 AND teamId = 365
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 74958 AND teamId = 365
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 365
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 365
0.0127  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 = '365' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '365' and rp.type = 4
0.0126  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 = '365' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 365 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.0140  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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 365 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136  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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 365 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 = 365 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 66308 AND t.round = 15 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 `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 = 60997 AND t.round = 15 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 = 53797 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.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 = 53812 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC