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 2018/2019

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

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

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

TEMPORADA 2012/2013

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

TEMPORADA 2011/2012

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

TEMPORADA 2010/2011

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

TEMPORADA 2009/2010

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

Competiciones que juega

Apertura Primera B Colombia

Pos	Equipos		Pts
1		Real Cartagena	29
2		Deportes Quindío	29
3		Deportivo Pereira	28
4		Barranquilla	26
5		Boyacá Chicó	25
6		Internacional de Palmira	24
7		Leones	24
8		Llaneros	23
9		Bogotá	22
10		Tigres FC	20
11		Fortaleza	19
12		Real Cundinamarca	14
13		Universitario Popayán	12
14		Real Santander	10
15		Atlético Fútbol Club	8
16		Orsomarso SC	7

	Series Finales : Real Cartagena, Deportes Quindío, Deportivo Pereira, Barranquilla, Boyacá Chicó , Internacional de Palmira, Leones, Llaneros

RIVALES EN Copa Colombia

RIVALES EN Primera B Colomb.

RIVALES EN Clausura Primera.

RIVALES EN Apertura Primera.

RIVALES EN Clausura Primera.

RIVALES EN Apertura Primera.

USO DE MEMORIA

6,936,992 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1883
Total Execution Time	0.1895

CADENA URL

/historico/Boyaca-Chico/2019

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (61)

0.0054	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 = 'Boyaca-Chico' AND l.year = 2019 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.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=535 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=535 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=535 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=535 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=535 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=535 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=535 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=535 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024	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 = 48782
0.0051	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 = 49695
0.0025	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 = 51604
0.0024	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 = 51808
0.0026	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 = 51973
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=535 AND type_rel = 2
0.0021	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.0022	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.0031	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 = '535' AND l.year = 2019 ORDER BY l.year DESC,cat.coefficient DESC
0.0033	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.0018	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 = 48782 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018	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 = 51973 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0018	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 = 51808 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 49695 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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 (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (60074,55386,53475,51973,51808,49695,48674,48673,43561) 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.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 53475 AND teamId = 535
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 43561 AND teamId = 535
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 48673 AND teamId = 535
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 48674 AND teamId = 535
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 60074 AND teamId = 535
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 55386 AND teamId = 535
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 51808 AND teamId = 535
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 51973 AND teamId = 535
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 49695 AND teamId = 535
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 = '535' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '535' and rp.type = 4
0.0022	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 = '535' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0040	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 events2019 e ON e.player_id = p.id AND e.league_id = 48673 WHERE rp.league_id = 48673 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.0038	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 events2019 e ON e.player_id = p.id AND e.league_id = 48673 WHERE rp.league_id = 48673 AND rp.teamId = 535 AND (e.action = 4 or e.action = 5) 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 events2019 e ON e.player_id = p.id AND e.league_id = 48673 WHERE rp.league_id = 48673 AND rp.teamId = 535 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 = 535 AND l.year <= 2019 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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.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 = 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.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.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 = 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.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.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* `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.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 = 3899 AND t.round = 18 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* `tables2013` 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 = 2414 AND t.round = 18 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* `tables2013` 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 = 2529 AND t.round = 18 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* `tables2012` 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 = 1563 AND t.round = 18 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* `tables2012` 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 = 1542 AND t.round = 18 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* `tables2011` 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 = 1390 AND t.round = 18 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* `tables2011` 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 = 1296 AND t.round = 18 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* `tables2010` 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 = 1009 AND t.round = 18 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* `tables2010` 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 = 1095 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 Primera B Colombia

RIVALES EN Copa Colombia

RIVALES EN Primera B Colomb.

RIVALES EN Clausura Primera.

RIVALES EN Apertura Primera.

RIVALES EN Clausura Primera.

RIVALES EN Apertura Primera.