Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Atlético Huila

Entrenador: Diego Corredor

Temporada 2023/2024

TEMPORADA 2023/2024

APERTURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Atlético	13	21	6	33
2	Cúcuta	14	19	11	28
3	Llaneros	14	23	13	26
4	Real	13	18	9	23
5	Tigres FC	14	18	10	23
6	Deportes	14	17	13	23
7	Unión	14	22	17	22
8	Orsomarso	13	19	16	19
9	Real	14	22	23	16
10	Internaciona	14	16	17	16
11	Leones	14	17	19	16
12	Barranquilla	13	15	16	15
13	Boca Juniors	14	11	17	15
14	Bogotá	14	13	30	11
15	Real	14	14	27	8
16	Atlético	14	5	26	5

TEMPORADA 2022/2023

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Águilas	20	35	12	44
2	Independient	20	30	15	39
3	América	20	35	19	37
4	Deportes	20	23	17	37
5	Nacional	20	33	21	33
6	Junior	20	29	17	30
7	Millonarios	20	21	20	30
8	Deportivo	20	25	25	28
9	Alianza FC	20	18	24	28
10	La Equidad	20	19	20	26
11	Atlético	20	20	22	26
12	Deportivo	20	16	20	25
13	Santa Fe	20	21	29	24
14	Once Caldas	20	21	22	22
15	Unión	20	21	32	22
16	Atlético	20	18	22	19
17	Deportivo	20	19	28	19
18	Boyacá	20	15	26	19
19	Jaguares FC	20	7	21	14
20	Envigado	20	18	32	13

TEMPORADA 2021/2022

APERTURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Leones	14	21	10	27
2	Fortaleza	14	26	17	25
3	Deportes	14	17	8	25
4	Real	14	19	16	25
5	Tigres FC	14	16	12	22
6	Boyacá	14	18	16	22
7	Llaneros	14	14	12	22
8	Bogotá	14	17	16	22
9	Real	14	15	12	21
10	Orsomarso	14	14	20	18
11	Atlético	14	10	14	14
12	Real	14	13	21	11
13	Barranquilla	14	13	23	10
14	Atlético	14	7	14	9
15	Boca Juniors	14	10	19	8

TEMPORADA 2020/2021

APERTURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Atlético	15	27	14	30
2	Unión	15	20	10	30
3	Deportes	15	16	11	25
4	Leones	15	19	15	25
5	Internaciona	15	16	12	23
6	Real	15	25	19	22
7	Fortaleza	15	26	22	22
8	Atlético	15	17	14	20
9	Real	15	21	23	20
10	Orsomarso	15	23	24	19
11	Tigres FC	15	10	12	17
12	Llaneros	15	11	17	15
13	Boca Juniors	15	12	19	15
14	Bogotá	15	17	34	15
15	Barranquilla	15	9	17	13
16	Real	15	14	20	11

TEMPORADA 2019/2020

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	0	0	0	0
2	Atlético	0	0	0	0
3	Internaciona	0	0	0	0
4	Atlético	0	0	0	0
5	Barranquilla	0	0	0	0
6	Real	0	0	0	0
7	Llaneros	0	0	0	0
8	Tigres FC	0	0	0	0
9	Unión	0	0	0	0
10	Deportes	0	0	0	0
11	Orsomarso	0	0	0	0
12	Boca Juniors	0	0	0	0
13	Real	0	0	0	0
14	Real	0	0	0	0
15	Bogotá	0	0	0	0
16	Leones	0	0	0	0

TEMPORADA 2018/2019

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	20	30	17	35
2	América	20	29	26	35
3	Deportivo	20	34	25	34
4	Junior	20	16	9	33
5	Santa Fe	20	22	12	32
6	Deportes	20	24	16	32
7	Alianza FC	20	17	14	32
8	Cúcuta	20	28	28	32
9	Independient	20	32	26	31
10	Once Caldas	20	26	20	28
11	Millonarios	20	24	27	28
12	Atlético	20	23	23	25
13	Águilas	20	25	27	24
14	Deportivo	20	24	25	23
15	Patriotas	20	19	20	23
16	Envigado	20	23	28	23
17	La Equidad	20	19	24	20
18	Atlético	20	13	24	16
19	Jaguares FC	20	11	34	15
20	Unión	20	14	28	14

TEMPORADA 2017/2018

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Deportes	19	34	22	39
2	Once Caldas	19	25	16	36
3	La Equidad	19	23	15	36
4	Atlético	19	25	20	35
5	Independient	19	29	19	34
6	Junior	19	32	17	32
7	Águilas	19	21	19	32
8	Santa Fe	19	27	13	31
9	Nacional	19	27	20	30
10	Deportivo	19	19	15	29
11	Millonarios	19	23	23	25
12	América	19	19	20	25
13	Envigado	19	20	28	20
14	Boyacá	19	19	28	20
15	Patriotas	19	17	26	20
16	Alianza FC	19	22	33	19
17	Atlético	19	13	22	18
18	Deportivo	19	11	21	15
19	Jaguares FC	19	13	29	14
20	Leones	19	15	28	9

TEMPORADA 2016/2017

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Junior	20	32	15	39
2	Santa Fe	20	21	10	39
3	Nacional	20	25	12	38
4	Millonarios	20	26	14	36
5	Deportes	20	25	20	33
6	América	20	19	15	31
7	La Equidad	20	25	18	30
8	Jaguares FC	20	25	21	28
9	Independient	20	23	20	27
10	Atlético	20	21	23	27
11	Envigado	20	19	23	26
12	Tigres FC	20	13	19	26
13	Internaciona	20	17	28	24
14	Deportivo	20	25	32	23
15	Deportivo	20	25	29	21
16	Patriotas	20	19	25	21
17	Once Caldas	20	16	24	21
18	Alianza FC	20	16	28	19
19	Atlético	20	18	24	18
20	Águilas	20	16	26	18

TEMPORADA 2015/2016

CLAUSURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	20	32	19	37
2	Deportivo	20	25	17	34
3	Deportes	20	25	16	33
4	Millonarios	20	28	21	33
5	Santa Fe	20	22	15	33
6	Independient	20	31	26	33
7	Atlético	20	24	19	32
8	Patriotas	20	23	19	32
9	Envigado	20	23	20	32
10	Alianza FC	20	22	17	30
11	Junior	20	25	27	28
12	Águilas	20	23	28	26
13	Once Caldas	20	25	24	25
14	La Equidad	20	24	27	23
15	Jaguares FC	20	16	20	23
16	Atlético	20	18	27	23
17	Fortaleza	20	20	28	20
18	Deportivo	20	19	28	20
19	Internaciona	20	22	34	14
20	Boyacá	20	18	33	14

TEMPORADA 2014/2015

APERTURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Atlético	20	33	22	41
2	Envigado	20	21	13	36
3	Deportivo	20	36	24	35
4	Independient	20	31	22	35
5	Millonarios	20	36	23	34
6	Nacional	20	33	24	34
7	Deportes	20	29	16	33
8	Junior	20	27	16	33
9	Santa Fe	20	29	19	31
10	Águilas	20	23	16	30
11	Patriotas	20	17	18	27
12	La Equidad	20	21	21	26
13	Once Caldas	20	29	32	23
14	Internaciona	20	22	25	21
15	Jaguares FC	20	21	32	21
16	Alianza FC	20	17	22	20
17	Boyacá	20	16	29	17
18	Cúcuta	20	16	33	15
19	Uniautónoma	20	13	30	15
20	Deportivo	20	11	44	9

TEMPORADA 2013/2014

APERTURA COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	18	35	22	34
2	Millonarios	18	27	15	33
3	Junior	18	20	17	33
4	Santa Fe	18	24	16	30
5	Once Caldas	18	27	17	29
6	Envigado	18	27	24	28
7	Águilas	18	21	23	28
8	La Equidad	18	17	17	27
9	Alianza FC	18	23	28	27
10	Boyacá	18	19	16	25
11	Independient	18	26	30	21
12	Deportivo	18	28	26	20
13	Atlético	18	23	26	19
14	Deportivo	18	16	22	19
15	Patriotas	18	20	30	19
16	Fortaleza	18	22	26	17
17	Uniautónoma	18	20	30	17
18	Deportes	18	18	28	17

Competiciones que juega

Apertura Primera B Colombia

Pos	Equipos		Pts
1		Atlético Huila	33
2		Cúcuta Deportivo	28
3		Llaneros	26
4		Real Cartagena	23
5		Tigres FC	23
6		Deportes Quindío	23
7		Unión Magdalena	22
8		Orsomarso SC	19
9		Real Cundinamarca	16
10		Internacional de Palmira	16
11		Leones	16
12		Barranquilla	15
13		Boca Juniors de Cali	15
14		Bogotá	11
15		Real Santander	8
16		Atlético Fútbol Club	5

	Siguiente Ronda : Atlético Huila, Cúcuta Deportivo, Llaneros, Real Cartagena, Tigres FC, Deportes Quindío, Unión Magdalena, Orsomarso SC

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.

USO DE MEMORIA

6,668,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1663
Total Execution Time	0.1675

CADENA URL

/historico/Atletico-Huila

GET DATOS

$_GET['/historico/Atletico-Huila']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0040	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 = 75230
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=365 AND type_rel = 2
0.0029	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.0025	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.0064	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.0023	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 = 75230 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	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 = 74958 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0076	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.0021	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.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 70737 AND teamId = 365
0.0100	SELECT count(id) as num_players from rel_players WHERE league_id = 70934 AND teamId = 365
0.0030	SELECT count(id) as num_players from rel_players WHERE league_id = 74958 AND teamId = 365
0.0035	SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 365
0.0048	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 365
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 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 = 74958 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '365' 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 = '365' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0046	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.0047	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.0029	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.0032	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.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 = 74958 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 70737 AND t.round = 20 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 = 70934 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 66315 AND t.round = 16 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 = 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.0024	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 = 63287 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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.0032	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.0021	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
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* `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 = 48381 AND t.round = 20 ORDER BY team.conference 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* `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 = 48672 AND t.round = 20 ORDER BY team.conference 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* `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 = 42448 AND t.round = 19 ORDER BY team.conference 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* `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 = 43561 AND t.round = 19 ORDER BY team.conference 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* `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 = 37731 AND t.round = 20 ORDER BY team.conference 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* `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 = 38746 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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 = 20228 AND t.round = 20 ORDER BY team.conference 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* `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 = 33328 AND t.round = 20 ORDER BY team.conference 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* `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 = 15429 AND t.round = 20 ORDER BY team.conference 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* `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 = 9440 AND t.round = 20 ORDER BY team.conference 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* `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 = 3373 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Atlético Huila

Atlético Huila

Selecciona un equipo

Competiciones que juega

Apertura Primera B Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.