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

Internacional de Palmira

Entrenador: Jorge Peralta

Temporada 2016/2017

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

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Jaguares FC	18	27	18	34
2	Deportivo	18	28	15	33
3	Deportes	18	28	17	33
4	Deportivo	18	26	15	33
5	Unión	18	32	20	32
6	Cúcuta	18	21	15	32
7	Atlético	18	23	19	31
8	América	18	25	17	30
9	Real	18	20	18	30
10	Internaciona	18	21	19	25
11	Real	18	16	18	25
12	Llaneros	18	25	25	22
13	Universitari	18	17	29	19
14	Real	18	17	24	18
15	Tigres FC	18	11	20	13
16	Atlético	18	18	35	13
17	Bogotá	18	17	29	11
18	Barranquilla	18	11	30	11

TEMPORADA 2012/2013

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	América	18	21	9	33
2	Deportivo	18	27	23	32
3	Real	18	40	29	31
4	Internaciona	18	26	20	29
5	Atlético	18	19	15	28
6	Fortaleza	18	22	19	28
7	Uniautónoma	18	24	25	27
8	Jaguares FC	18	18	19	26
9	Deportivo	18	20	18	24
10	Real	18	22	20	22
11	Llaneros	18	17	19	22
12	Atlético	18	26	26	21
13	Real	18	22	27	21
14	Bogotá	18	15	20	21
15	Unión	18	19	24	19
16	Tigres FC	18	16	24	18
17	Universitari	18	21	34	18
18	Barranquilla	18	24	28	17

TEMPORADA 2011/2012

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Deportivo	18	37	14	43
2	Alianza FC	18	35	18	34
3	América	18	31	18	34
4	Deportivo	18	25	19	31
5	Universitari	18	20	21	30
6	Internaciona	18	27	25	29
7	Uniautónoma	18	23	20	27
8	Atlético	18	22	24	27
9	Real	18	15	12	25
10	Sucre FC	18	19	22	25
11	Bogotá	18	22	30	23
12	Unión	18	19	20	21
13	Atlético	18	22	25	19
14	Fortaleza	18	14	18	19
15	Tigres FC	18	12	18	16
16	Real	18	22	31	16
17	Barranquilla	18	22	37	15
18	Llaneros	18	11	26	13

TEMPORADA 2010/2011

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Deportivo	18	32	15	34
2	Centauros	18	28	25	31
3	Alianza FC	18	24	16	29
4	Bogotá	18	26	21	29
5	Deportivo	18	33	23	28
6	Uniautónoma	18	33	24	28
7	Tigres FC	18	21	15	28
8	Academia	18	27	24	28
9	Real	18	23	19	27
10	Fortaleza	18	20	18	26
11	Atlético	18	16	18	23
12	Real	18	22	27	23
13	Unión	18	18	22	20
14	Internaciona	18	22	27	20
15	Patriotas	18	21	25	18
16	Pacífico	18	14	28	15
17	Barranquilla	18	12	28	14
18	Atlético	18	15	32	12

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

TEMPORADA 2008/2009

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Águilas	18	28	22	33
2	Atlético	18	37	21	32
3	Bogotá	18	28	17	28
4	Real	18	21	21	26
5	Patriotas	18	23	24	24
6	Barranquilla	18	20	21	23
7	Real	18	14	28	20
8	Sucre FC	18	17	29	19
9	Atlético	18	21	26	17
10	Centauros	18	27	17	31
11	La Sabana	18	30	21	30
12	Unión	18	34	19	29
13	Deportivo	18	22	21	28
14	Fortaleza	18	20	22	27
15	Tigres FC	18	18	16	26
16	Academia	18	27	25	25
17	Internaciona	18	21	22	23
18	Alianza FC	18	7	43	4

TEMPORADA 2007/2008

CLAUSURA PRIMERA B COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Academia	18	24	16	32
2	Deportivo	18	23	18	31
3	Unión	18	19	14	28
4	Real	18	19	17	28
5	Tigres FC	18	15	18	27
6	Águilas	18	12	11	25
7	Internaciona	18	22	21	21
8	Real	18	15	20	19
9	Centauros	18	13	25	11
10	Atlético	18	19	21	28
11	Barranquilla	18	28	21	27
12	Real	18	25	22	26
13	Patriotas	18	18	19	25
14	Bogotá	18	24	23	24
15	Sucre FC	18	24	24	24
16	Fortaleza	18	14	19	22
17	La Sabana	18	17	19	21
18	Alianza FC	18	17	20	18

Competiciones que juega

Apertura Colombia

Pos	Equipos		Pts
1		At. Nacional	49
2		Independiente Medellín	42
3		Deportivo Pasto	35
4		Millonarios	33
5		Jaguares FC	31
6		Deportivo Cali	30
7		América de Cali	29
8		Atlético Bucaramanga	29
9		Santa Fe	28
10		Alianza FC	27
11		Patriotas Boyacá	24
12		Junior	23
13		La Equidad	23
14		Águilas Doradas	21
15		Atlético Huila	21
16		Once Caldas	21
17		Deportes Tolima	20
18		Tigres FC	19
19		Envigado	18
20		Internacional de Palmira	18

	Series Finales : At. Nacional, Independiente Medellín, Deportivo Pasto, Millonarios, Jaguares FC, Deportivo Cali, América de Cali, Atlético Bucaramanga

RIVALES EN Copa Colombia

RIVALES EN Apertura Colombi.

RIVALES EN Clausura Colombi.

USO DE MEMORIA

6,583,440 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1695
Total Execution Time	0.1707

CADENA URL

/historico/Cortulua/2017

GET DATOS

$_GET['/historico/Cortulua/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0032	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 = 'Cortulua' AND l.year = 2017 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.0019	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=4374 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=4374 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=4374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=4374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 37731
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 = 38746
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 = 38022
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4374 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4374 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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,3130,5673,6854) 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 = '4374' AND l.year = 2017 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 = '4374' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 38022 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 37731 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 38746 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0042	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=4374 AND l.year in (2016,2017,2018) 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 (46940,42555,38746,37731,30385) 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.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 37731 AND teamId = 4374
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 38746 AND teamId = 4374
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 46940 AND teamId = 4374
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 30385 AND teamId = 4374
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 42555 AND teamId = 4374
0.0034	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0056	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 events2017 e ON e.player_id = p.id AND e.league_id = 37731 WHERE rp.league_id = 37731 AND rp.teamId = 4374 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.0055	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 events2017 e ON e.player_id = p.id AND e.league_id = 37731 WHERE rp.league_id = 37731 AND rp.teamId = 4374 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 events2017 e ON e.player_id = p.id AND e.league_id = 37731 WHERE rp.league_id = 37731 AND rp.teamId = 4374 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 = 4374 AND l.year <= 2017 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* `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.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* `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.0029	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* `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.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* `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.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* `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.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* `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 = 3477 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 = 3209 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* `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 = 2415 AND t.round = 18 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* `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 = 2622 AND t.round = 18 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* `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 = 1569 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* `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 = 1662 AND t.round = 18 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* `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 = 1391 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 = 1392 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* `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.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* `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
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* `tables2009` 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 = 13585 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* `tables2009` 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 = 13588 AND t.round = 18 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* `tables2008` 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 = 13579 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* `tables2008` 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 = 13582 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Internacional de Palmira

Internacional de Palmira

Selecciona un equipo

Competiciones que juega

Apertura Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Colombi.

RIVALES EN Clausura Colombi.