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

Unión Magdalena

Entrenador: Álvaro Hernández

Temporada 2023/2024

TEMPORADA 2023/2024

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

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

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

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 COLOMBIA
Equipo		PJ	GF	GC	Puntos
1	Nacional	20	30	17	35
2	América	20	29	26	35
3	Deportivo	20	34	25	34
4	Junior	20	16	9	33
5	Santa Fe	20	22	12	32
6	Deportes	20	24	16	32
7	Alianza FC	20	17	14	32
8	Cúcuta	20	28	28	32
9	Independient	20	32	26	31
10	Once Caldas	20	26	20	28
11	Millonarios	20	24	27	28
12	Atlético	20	23	23	25
13	Águilas	20	25	27	24
14	Deportivo	20	24	25	23
15	Patriotas	20	19	20	23
16	Envigado	20	23	28	23
17	La Equidad	20	19	24	20
18	Atlético	20	13	24	16
19	Jaguares FC	20	11	34	15
20	Unión	20	14	28	14

TEMPORADA 2017/2018

PRIMERA B COLOMBIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cúcuta	6	9	3	13
2	Internaciona	6	8	9	9
3	Llaneros	6	7	9	7
4	Real	6	7	10	6
5	Unión	6	13	4	16
6	Deportes	6	10	7	10
7	Deportivo	6	10	10	9
8	Real	6	1	13	0

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

PRIMERA B COLOMBIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Deportivo	32	58	28	70
2	América	32	48	24	60
3	Real	32	47	36	57
4	Leones	32	43	31	49
5	Universitari	32	37	35	49
6	Tigres FC	32	26	24	48
7	Deportes	32	36	33	44
8	Bogotá	32	37	39	44
9	Real	32	34	37	44
10	Cúcuta	32	35	31	42
11	Orsomarso	32	35	48	40
12	Barranquilla	32	31	37	35
13	Unión	32	30	39	35
14	Real	32	33	51	33
15	Llaneros	32	31	42	31
16	Atlético	32	19	45	25

TEMPORADA 2014/2015

PRIMERA B COLOMBIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atlético	32	55	17	71
2	Deportivo	32	54	36	60
3	América	32	61	37	56
4	Fortaleza	32	41	35	51
5	Real	32	46	43	50
6	Leones	32	33	36	50
7	Unión	32	37	28	48
8	Universitari	32	36	30	47
9	Deportes	32	43	36	45
10	Real	32	38	45	38
11	Bogotá	32	30	44	34
12	Tigres FC	32	38	56	33
13	Real	32	36	52	32
14	Barranquilla	32	23	37	31
15	Llaneros	32	33	51	30
16	Atlético	32	37	58	24

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

Competiciones que juega

Apertura Primera B Colombia

Pos	Equipos		Pts
1		Atlético Huila	33
2		Cúcuta Deportivo	25
3		Llaneros	23
4		Real Cartagena	23
5		Tigres FC	22
6		Unión Magdalena	22
7		Deportes Quindío	20
8		Orsomarso SC	19
9		Real Cundinamarca	16
10		Internacional de Palmira	16
11		Barranquilla	15
12		Boca Juniors de Cali	15
13		Leones	13
14		Bogotá	10
15		Real Santander	8
16		Atlético Fútbol Club	5

	Siguiente Ronda : Atlético Huila, Cúcuta Deportivo, Llaneros, Real Cartagena, Tigres FC, Unión Magdalena, Deportes Quindío, Orsomarso SC

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.

USO DE MEMORIA

6,428,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7385
Total Execution Time	0.7396

CADENA URL

/historico/Union-Magdalena

GET DATOS

$_GET['/historico/Union-Magdalena']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0140	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 = 'Union-Magdalena' AND l.year = 2024 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.0127	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=5938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=5938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=5938 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0259	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 = 74958
0.0148	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.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5938 AND type_rel = 2
0.0142	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5938 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127	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 (33183,113475,117318,119567,205713) ORDER BY n.cover_points DESC, update_date DESC
0.0164	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 = '5938' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0176	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 = '5938' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0138	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.0140	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 = 74958 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0183	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=5938 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0130	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,74958,70934,70737,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.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 70737 AND teamId = 5938
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 70934 AND teamId = 5938
0.0137	SELECT count(id) as num_players from rel_players WHERE league_id = 74958 AND teamId = 5938
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 75230 AND teamId = 5938
0.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 5938
0.0130	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74958 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141	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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 5938 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.0142	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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 5938 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144	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 = 74958 WHERE rp.league_id = 74958 AND rp.teamId = 5938 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147	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 = 5938 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0135	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 = 74958 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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.0131	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.0129	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 = 66314 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.0130	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 = 66290 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.0129	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.0128	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.0129	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.0130	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.0130	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 = 48381 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 48672 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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.0138	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 = 46940 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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.0146	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.0146	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 = 20265 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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.0131	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.0129	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.0131	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

Unión Magdalena

Unión Magdalena

Selecciona un equipo

Competiciones que juega

Apertura Primera B Colombia

RIVALES EN Copa Colombia

RIVALES EN Apertura Primera.