Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Boyacá Chicó

Entrenador: Jhon Jaime

Temporada 2023/2024

TEMPORADA 2023/2024

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

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

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

TEMPORADA 2020/2021

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

TEMPORADA 2019/2020

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

TEMPORADA 2018/2019

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

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 PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Barranquilla	16	21	10	33
2	Deportivo	16	23	13	30
3	Deportes	16	28	19	30
4	Leones	16	20	15	30
5	Cúcuta	16	30	20	27
6	Llaneros	16	26	23	25
7	Real	16	20	20	24
8	Orsomarso	16	16	14	23
9	Boyacá	16	16	15	23
10	Unión	16	20	22	20
11	Atlético	16	13	25	18
12	Bogotá	16	10	19	14
13	Real	16	14	28	14
14	Real	16	21	25	14
15	Fortaleza	16	14	19	12
16	Universitari	16	13	18	12

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

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

TEMPORADA 2013/2014

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

Competiciones que juega

Apertura Colombia

Pos	Equipos		Pts
1		Deportes Tolima	38
2		Atlético Bucaramanga	35
3		Santa Fe	34
4		La Equidad	33
5		Deportivo Pereira	31
6		Millonarios	28
7		Junior	28
8		Once Caldas	28
9		Independiente Medellín	26
10		América de Cali	24
11		At. Nacional	24
12		Águilas Doradas	24
13		Fortaleza	23
14		Deportivo Cali	20
15		Jaguares FC	19
16		Boyacá Chicó	18
17		Envigado	16
18		Deportivo Pasto	16
19		Alianza FC	16
20		Patriotas Boyacá	15

	Siguiente Ronda : Deportes Tolima, Atlético Bucaramanga, Santa Fe, La Equidad, Deportivo Pereira, Millonarios, Junior, Once Caldas

RIVALES EN Apertura Colombi.

USO DE MEMORIA

6,486,592 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1151
Total Execution Time	0.1164

CADENA URL

/historico/Boyaca-Chico

GET DATOS

$_GET['/historico/Boyaca-Chico']

POST DATOS

No hay datos POST existentes

CONSULTAS (32)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=535 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 535 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (2779,3016,14159,19589,38638) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '535' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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=535 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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 (74955,71742,70934,70900) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74955 AND teamId = 535
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 70934 AND teamId = 535
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71742 AND teamId = 535
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 70900 AND teamId = 535
0.0034	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 = 74955 WHERE rp.league_id = 74955 AND rp.teamId = 535 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.0032	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 = 74955 WHERE rp.league_id = 74955 AND rp.teamId = 535 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 = 74955 WHERE rp.league_id = 74955 AND rp.teamId = 535 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 535 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 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.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 = 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.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* `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 = 60836 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.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* `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 = 63326 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.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* `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 = 48673 AND t.round = 15 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 = 48674 AND t.round = 15 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.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* `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.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* `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 = 37761 AND t.round = 16 ORDER BY team.conference 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* `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 = 38802 AND t.round = 16 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.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* `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.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* `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* `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.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* `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
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* `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 = 3899 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Boyacá Chicó

Boyacá Chicó

Selecciona un equipo

Competiciones que juega

Apertura Colombia

RIVALES EN Apertura Colombi.