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

Resultados de Fútbol

Boyacá Chicó

Entrenador: Jhon Jaime

Temporada 2020/2021

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

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

Competiciones que juega

Apertura Colombia

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

	Series Finales : At. Nacional, Santa Fe, Millonarios, Deportivo Cali, Deportes Tolima, La Equidad, Junior, América de Cali

RIVALES EN Copa Colombia

RIVALES EN Apertura Colombi.

RIVALES EN Clausura Primera.

USO DE MEMORIA

6,926,184 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7006
Total Execution Time	0.7019

CADENA URL

/historico/Boyaca-Chico/2021

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (54)

0.0125	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 = 2021 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.0105	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.0105	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.0106	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.0106	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.0105	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.0111	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 = 60836
0.0112	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 = 63326
0.0112	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 = 65683
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=535 AND type_rel = 2
0.0107	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.0109	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.0118	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' ORDER BY l.year DESC,cat.coefficient DESC
0.0114	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 = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0113	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.0108	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 = 61682 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107	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 = 60836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106	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 = 65683 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0106	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 = 63326 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115	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 (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0107	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 (70569,70473,67801,66316,66315,66308,60836,60074) 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.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 60836 AND teamId = 535
0.0112	SELECT count(id) as num_players from rel_players WHERE league_id = 66308 AND teamId = 535
0.0110	SELECT count(id) as num_players from rel_players WHERE league_id = 66315 AND teamId = 535
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 60074 AND teamId = 535
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 66316 AND teamId = 535
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 67801 AND teamId = 535
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 70473 AND teamId = 535
0.0109	SELECT count(id) as num_players from rel_players WHERE league_id = 70569 AND teamId = 535
0.0110	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108	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.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '535' and rp.type = 4
0.0107	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.0122	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 events2021 e ON e.player_id = p.id AND e.league_id = 60836 WHERE rp.league_id = 60836 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.0119	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 events2021 e ON e.player_id = p.id AND e.league_id = 60836 WHERE rp.league_id = 60836 AND rp.teamId = 535 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114	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 events2021 e ON e.player_id = p.id AND e.league_id = 60836 WHERE rp.league_id = 60836 AND rp.teamId = 535 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0118	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 <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0109	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.0109	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 = 53475 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.0109	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.0109	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.0111	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.0111	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.0109	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.0108	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.0109	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.0110	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.0110	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.0110	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.0109	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.0111	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.0112	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.0110	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.0111	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


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Boyacá Chicó

Boyacá Chicó

Selecciona un equipo

Competiciones que juega

Apertura Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Colombi.

RIVALES EN Clausura Primera.

RIVALES EN Clausura Primera.