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

Fortaleza

Entrenador: Sebastián Oliveros

Temporada 2023/2024

TEMPORADA 2023/2024

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

TEMPORADA 2022/2023

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

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

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 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

PRIMERA B COLOMBIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cúcuta	30	52	17	71
2	Unión	30	53	22	60
3	Deportivo	30	43	31	53
4	Real	30	40	34	47
5	Internaciona	30	40	41	44
6	Deportes	30	29	33	43
7	Real	30	40	38	41
8	Llaneros	30	33	33	39
9	Fortaleza	30	39	38	38
10	Barranquilla	30	36	45	35
11	Tigres FC	30	30	35	34
12	Universitari	30	36	46	33
13	Bogotá	30	30	49	31
14	Atlético	30	29	42	29
15	Orsomarso	30	20	31	28
16	Real	30	27	42	18

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

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

TEMPORADA 2014/2015

PRIMERA B COLOMBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Atlético	6	10	3	13
2	América	6	12	9	10
3	Real	6	7	12	7
4	Universitari	6	8	13	4
5	Fortaleza	6	14	7	15
6	Deportivo	6	12	5	13
7	Leones	6	5	10	4
8	Unión	6	5	14	3

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		Atlético Bucaramanga	38
2		Deportes Tolima	38
3		Deportivo Pereira	34
4		Santa Fe	34
5		La Equidad	33
6		Millonarios	31
7		Junior	29
8		Once Caldas	29
9		Independiente Medellín	29
10		América de Cali	25
11		Águilas Doradas	25
12		At. Nacional	24
13		Fortaleza	24
14		Jaguares FC	22
15		Deportivo Cali	21
16		Deportivo Pasto	19
17		Boyacá Chicó	18
18		Envigado	16
19		Alianza FC	16
20		Patriotas Boyacá	15

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

RIVALES EN Copa Colombia

RIVALES EN Apertura Colombi.

USO DE MEMORIA

6,417,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.1493
Total Execution Time	0.1507

CADENA URL

/historico/Fortaleza

GET DATOS

$_GET['/historico/Fortaleza']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0041	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=11327 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11327 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 (25588,40921,58170,64390,70408) ORDER BY n.cover_points DESC, update_date DESC
0.0034	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 = '11327' ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '11327' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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.0030	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=11327 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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,74955,74627,74557,71993,71731,70905,67320) 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 = 11327
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 70905 AND teamId = 11327
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71993 AND teamId = 11327
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 11327
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 74557 AND teamId = 11327
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 74627 AND teamId = 11327
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71731 AND teamId = 11327
0.0119	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 11327
0.0022	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 = '11327' 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 = '11327' 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 = '11327' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 11327 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.0028	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 = 11327 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 11327 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 11327 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 74955 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.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* `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 = 70905 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* `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 = 71993 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.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 = 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.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 = 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.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 = 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.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* `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.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.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 = 42552 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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.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 = 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.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.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* `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.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* `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 = 9458 AND t.round = 32 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 = 19573 AND t.round = 6 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
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* `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

Fortaleza

Fortaleza

Selecciona un equipo

Competiciones que juega

Apertura Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Colombi.