4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Unión Magdalena

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 Huila Atlético 12 21 4 33
2 Llaneros Llaneros 12 19 9 23
3 Tigres FC Tigres FC 13 18 10 22
4 Cúcuta Deportivo Cúcuta 12 17 11 22
5 Real Cartagena Real 12 15 8 20
6 Unión Magdalena Unión 12 20 16 19
7 Orsomarso SC Orsomarso 13 19 16 19
8 Deportes Quindío Deportes 12 15 13 17
9 Real Cundinamarca Real 13 19 19 16
10 Barranquilla Barranquilla 13 15 16 15
11 Boca Juniors de Cali Boca Juniors 13 11 16 15
12 Internacional de Palmira Internaciona 12 13 16 13
13 Leones Leones 12 14 17 12
14 Bogotá Bogotá 12 11 28 9
15 Real Santander Real 12 13 23 8
16 Atlético Fútbol Club Atlético 13 5 23 5
TEMPORADA 2022/2023
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 20 35 12 44
2 Independiente Medellín Independient 20 30 15 39
3 América de Cali América 20 35 19 37
4 Deportes Tolima Deportes 20 23 17 37
5 At. Nacional Nacional 20 33 21 33
6 Junior Junior 20 29 17 30
7 Millonarios Millonarios 20 21 20 30
8 Deportivo Cali Deportivo 20 25 25 28
9 Alianza FC Alianza FC 20 18 24 28
10 La Equidad La Equidad 20 19 20 26
11 Atlético Bucaramanga Atlético 20 20 22 26
12 Deportivo Pasto Deportivo 20 16 20 25
13 Santa Fe Santa Fe 20 21 29 24
14 Once Caldas Once Caldas 20 21 22 22
15 Unión Magdalena Unión 20 21 32 22
16 Atlético Huila Atlético 20 18 22 19
17 Deportivo Pereira Deportivo 20 19 28 19
18 Boyacá Chicó Boyacá 20 15 26 19
19 Jaguares FC Jaguares FC 20 7 21 14
20 Envigado Envigado 20 18 32 13
TEMPORADA 2021/2022
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 Santa Fe Santa Fe 20 25 26 34
2 Águilas Doradas Águilas 20 23 15 33
3 Independiente Medellín Independient 20 30 25 33
4 Millonarios Millonarios 20 29 19 32
5 Deportivo Pereira Deportivo 20 26 21 32
6 Deportivo Pasto Deportivo 20 24 23 32
7 América de Cali América 20 21 11 31
8 Junior Junior 20 24 19 31
9 At. Nacional Nacional 20 31 25 30
10 Once Caldas Once Caldas 20 21 18 30
11 Atlético Bucaramanga Atlético 20 26 25 30
12 Unión Magdalena Unión 20 23 28 29
13 La Equidad La Equidad 20 28 27 28
14 Deportes Tolima Deportes 20 23 22 26
15 Envigado Envigado 20 22 22 26
16 Jaguares FC Jaguares FC 20 14 20 20
17 Alianza FC Alianza FC 20 24 32 17
18 Deportivo Cali Deportivo 20 22 35 16
19 Patriotas Boyacá Patriotas 20 21 28 15
20 Internacional de Palmira Internaciona 20 12 28 11
TEMPORADA 2020/2021
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Leones Leones 14 25 12 29
2 Bogotá Bogotá 14 18 9 28
3 Boyacá Chicó Boyacá 14 15 6 28
4 Fortaleza Fortaleza 14 24 10 26
5 Unión Magdalena Unión 14 24 17 25
6 Internacional de Palmira Internaciona 14 19 13 25
7 Llaneros Llaneros 14 20 15 23
8 Real Cartagena Real 14 17 14 20
9 Atlético Fútbol Club Atlético 14 17 20 19
10 Barranquilla Barranquilla 14 13 19 15
11 Orsomarso SC Orsomarso 14 14 22 15
12 Real Santander Real 14 15 24 10
13 Real Cundinamarca Real 14 13 23 8
14 Boca Juniors de Cali Boca Juniors 14 8 25 7
15 Tigres FC Tigres FC 14 6 19 6
TEMPORADA 2019/2020
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 0 0 0 0
2 Atlético Huila Atlético 0 0 0 0
3 Internacional de Palmira Internaciona 0 0 0 0
4 Atlético Fútbol Club Atlético 0 0 0 0
5 Barranquilla Barranquilla 0 0 0 0
6 Real Cundinamarca Real 0 0 0 0
7 Llaneros Llaneros 0 0 0 0
8 Tigres FC Tigres FC 0 0 0 0
9 Unión Magdalena Unión 0 0 0 0
10 Deportes Quindío Deportes 0 0 0 0
11 Orsomarso SC Orsomarso 0 0 0 0
12 Boca Juniors de Cali Boca Juniors 0 0 0 0
13 Real Cartagena Real 0 0 0 0
14 Real Santander Real 0 0 0 0
15 Bogotá Bogotá 0 0 0 0
16 Leones Leones 0 0 0 0
TEMPORADA 2018/2019
CLAUSURA COLOMBIA
Equipo PJ GF GC Puntos
1 At. Nacional Nacional 20 30 17 35
2 América de Cali América 20 29 26 35
3 Deportivo Cali Deportivo 20 34 25 34
4 Junior Junior 20 16 9 33
5 Santa Fe Santa Fe 20 22 12 32
6 Deportes Tolima Deportes 20 24 16 32
7 Alianza FC Alianza FC 20 17 14 32
8 Cúcuta Deportivo Cúcuta 20 28 28 32
9 Independiente Medellín Independient 20 32 26 31
10 Once Caldas Once Caldas 20 26 20 28
11 Millonarios Millonarios 20 24 27 28
12 Atlético Bucaramanga Atlético 20 23 23 25
13 Águilas Doradas Águilas 20 25 27 24
14 Deportivo Pasto Deportivo 20 24 25 23
15 Patriotas Boyacá Patriotas 20 19 20 23
16 Envigado Envigado 20 23 28 23
17 La Equidad La Equidad 20 19 24 20
18 Atlético Huila Atlético 20 13 24 16
19 Jaguares FC Jaguares FC 20 11 34 15
20 Unión Magdalena Unión 20 14 28 14
TEMPORADA 2017/2018
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Cúcuta Deportivo Cúcuta 30 52 17 71
2 Unión Magdalena Unión 30 53 22 60
3 Deportivo Pereira Deportivo 30 43 31 53
4 Real Cartagena Real 30 40 34 47
5 Internacional de Palmira Internaciona 30 40 41 44
6 Deportes Quindío Deportes 30 29 33 43
7 Real Cundinamarca Real 30 40 38 41
8 Llaneros Llaneros 30 33 33 39
9 Fortaleza Fortaleza 30 39 38 38
10 Barranquilla Barranquilla 30 36 45 35
11 Tigres FC Tigres FC 30 30 35 34
12 Universitario Popayán Universitari 30 36 46 33
13 Bogotá Bogotá 30 30 49 31
14 Atlético Fútbol Club Atlético 30 29 42 29
15 Orsomarso SC Orsomarso 30 20 31 28
16 Real Santander Real 30 27 42 18
TEMPORADA 2016/2017
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Barranquilla Barranquilla 16 21 10 33
2 Deportivo Pereira Deportivo 16 23 13 30
3 Deportes Quindío Deportes 16 28 19 30
4 Leones Leones 16 20 15 30
5 Cúcuta Deportivo Cúcuta 16 30 20 27
6 Llaneros Llaneros 16 26 23 25
7 Real Cartagena Real 16 20 20 24
8 Orsomarso SC Orsomarso 16 16 14 23
9 Boyacá Chicó Boyacá 16 16 15 23
10 Unión Magdalena Unión 16 20 22 20
11 Atlético Fútbol Club Atlético 16 13 25 18
12 Bogotá Bogotá 16 10 19 14
13 Real Cundinamarca Real 16 14 28 14
14 Real Santander Real 16 21 25 14
15 Fortaleza Fortaleza 16 14 19 12
16 Universitario Popayán Universitari 16 13 18 12
TEMPORADA 2015/2016
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 32 58 28 70
2 América de Cali América 32 48 24 60
3 Real Cartagena Real 32 47 36 57
4 Leones Leones 32 43 31 49
5 Universitario Popayán Universitari 32 37 35 49
6 Tigres FC Tigres FC 32 26 24 48
7 Deportes Quindío Deportes 32 36 33 44
8 Bogotá Bogotá 32 37 39 44
9 Real Cundinamarca Real 32 34 37 44
10 Cúcuta Deportivo Cúcuta 32 35 31 42
11 Orsomarso SC Orsomarso 32 35 48 40
12 Barranquilla Barranquilla 32 31 37 35
13 Unión Magdalena Unión 32 30 39 35
14 Real Santander Real 32 33 51 33
15 Llaneros Llaneros 32 31 42 31
16 Atlético Fútbol Club Atlético 32 19 45 25
TEMPORADA 2014/2015
PRIMERA B COLOMBIA GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 6 10 3 13
2 América de Cali América 6 12 9 10
3 Real Cartagena Real 6 7 12 7
4 Universitario Popayán Universitari 6 8 13 4
5 Fortaleza Fortaleza 6 14 7 15
6 Deportivo Pereira Deportivo 6 12 5 13
7 Leones Leones 6 5 10 4
8 Unión Magdalena Unión 6 5 14 3
TEMPORADA 2013/2014
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Jaguares FC Jaguares FC 18 27 18 34
2 Deportivo Pereira Deportivo 18 28 15 33
3 Deportes Quindío Deportes 18 28 17 33
4 Deportivo Rionegro Deportivo 18 26 15 33
5 Unión Magdalena Unión 18 32 20 32
6 Cúcuta Deportivo Cúcuta 18 21 15 32
7 Atlético Bucaramanga Atlético 18 23 19 31
8 América de Cali América 18 25 17 30
9 Real Cartagena Real 18 20 18 30
10 Internacional de Palmira Internaciona 18 21 19 25
11 Real Cundinamarca Real 18 16 18 25
12 Llaneros Llaneros 18 25 25 22
13 Universitario Popayán Universitari 18 17 29 19
14 Real Santander Real 18 17 24 18
15 Tigres FC Tigres FC 18 11 20 13
16 Atlético Fútbol Club Atlético 18 18 35 13
17 Bogotá Bogotá 18 17 29 11
18 Barranquilla Barranquilla 18 11 30 11

  USO DE MEMORIA  
6,474,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0017
Controller Execution Time ( Home / Category )  0.4136
Total Execution Time  0.4153
  CADENA URL  
/historico/Union-Magdalena
  GET DATOS  
$_GET['/historico/Union-Magdalena']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0178  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.0128  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 = '5938' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '5938' and rp.type = 4
0.0127  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 = '5938' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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.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 `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 = 13 ORDER BY team.conference ASC,t.position 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 `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.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 = 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.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 = 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.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 `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.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 `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.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 `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.0141  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.0147  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.0140  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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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.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 `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