Clausura Colombia

La temporada finalizó el Jueves, 09 Noviembre 2023.
 
23 Sep 23
23:00 Finalizado
Boyacá Chicó Boyacá Chicó 0-1 Águilas Doradas Águilas Doradas más información Jugadas destacadas 344
86' E. Mosquera
88' D. Alfonzo
0-1 92' Sebastián Rodríguez
 
24 Sep 23
03:20 Finalizado
América de Cali América de Cali 4-1 At. Nacional At. Nacional más información Jugadas destacadas 734
24' C. Barrios 1-0
47' C. Barrios 2-0
77' Á. Angulo
2-1 78' Á. Angulo
88' V. Ibarbo 3-1
94' E. Cardona 4-1
 
25 Sep 23
01:10 Finalizado
Santa Fe Santa Fe 1-0 Deportivo Pereira Deportivo Pereira más información Jugadas destacadas 315
90' H. Rodallega 1-0
 
25 Sep 23
03:20 Finalizado
Junior Junior 0-1 Deportes Tolima Deportes Tolima más información Jugadas destacadas 337
0-1 15' E. Arango
51' Jhon Vélez
 
25 Sep 23
17:00 Finalizado
Envigado Envigado 1-2 Millonarios Millonarios más información Jugadas destacadas 412
33' B. Garcés 1-0
1-1 46' L. Vásquez
1-2 70' Beckham Castro
 
25 Sep 23
23:15 Finalizado
La Equidad La Equidad 2-0 Jaguares FC Jaguares FC más información Jugadas destacadas 153
25' C. Paez
37' D. Camacho 2-0
85' Y. Arboleda
 
26 Sep 23
01:25 Finalizado
Alianza FC Alianza FC 2-1 Once Caldas Once Caldas más información Jugadas destacadas 230
22' R. Colpa 1-0
46' E. Navarro 2-0
2-1 47' D. Moreno
26 Sep 23
03:35 Finalizado
Independiente Medellín Independiente Medellín 2-0 Atlético Bucaramanga Atlético Bucaramanga más información Jugadas destacadas 346
14' J. Varela 1-0
52' Edwuin Cetré 2-0
68' S. Jérez
 
27 Sep 23
01:15 Finalizado
Unión Magdalena Unión Magdalena 3-4 Deportivo Cali Deportivo Cali más información Jugadas destacadas 615
14' Ricardo Márquez 1-0
19' N. Gil 2-0
2-1 21' A. Parra
29' G. Torres 3-1
3-2 55' G. Ramírez
3-3 59' F. Castro
3-4 65' G. Ramírez
 
27 Sep 23
03:30 Finalizado
Deportivo Pasto Deportivo Pasto 1-0 Atlético Huila Atlético Huila más información Jugadas destacadas 478
24' J. Malagón 1-0
78' B. Díaz
Equipos Puntos J. G. E. P. F. C. Forma
1 Águilas Doradas Águilas Doradas 28 14 7 7 0 19 10
  • VICTORIA
  • Águilas Doradas 2
  • Unión Magdalena 1
  • EMPATE
  • Atlético Huila 1
  • Águilas Doradas 1
  • EMPATE
  • Águilas Doradas 2
  • América de Cali 2
  • VICTORIA
  • Boyacá Chicó 0
  • Águilas Doradas 1
  • EMPATE
  • Deportivo Pereira 0
  • Águilas Doradas 0
2 América de Cali América Cali 26 14 7 5 2 27 14
  • VICTORIA
  • América de Cali 3
  • Deportivo Cali 0
  • VICTORIA
  • Jaguares FC 0
  • América de Cali 1
  • VICTORIA
  • América de Cali 5
  • Boyacá Chicó 0
  • EMPATE
  • Águilas Doradas 2
  • América de Cali 2
  • VICTORIA
  • América de Cali 4
  • At. Nacional 1
3 Independiente Medellín Independiente 25 14 6 7 1 19 12
  • VICTORIA
  • Independiente Mede. 1
  • At. Nacional 0
  • EMPATE
  • Deportes Tolima 1
  • Independiente Mede. 1
  • EMPATE
  • Independiente Mede. 1
  • Millonarios 1
  • EMPATE
  • Deportivo Cali 2
  • Independiente Mede. 2
  • VICTORIA
  • Independiente Mede. 2
  • Atlético Bucaraman. 0
4 At. Nacional At. Nacional 24 14 7 3 4 21 13
  • DERROTA
  • Independiente Mede. 1
  • At. Nacional 0
  • VICTORIA
  • At. Nacional 5
  • La Equidad 0
  • EMPATE
  • Junior 1
  • At. Nacional 1
  • VICTORIA
  • At. Nacional 3
  • Santa Fe 0
  • DERROTA
  • América de Cali 4
  • At. Nacional 1
5 Millonarios Millonarios 22 14 6 4 4 14 13
  • DERROTA
  • Millonarios 2
  • Santa Fe 4
  • VICTORIA
  • Millonarios 3
  • Atlético Bucaraman. 0
  • EMPATE
  • Independiente Mede. 1
  • Millonarios 1
  • VICTORIA
  • Millonarios 2
  • Atlético Huila 1
  • VICTORIA
  • Envigado 1
  • Millonarios 2
6 Santa Fe Santa Fe 22 14 6 4 4 16 16
  • VICTORIA
  • Millonarios 2
  • Santa Fe 4
  • EMPATE
  • Boyacá Chicó 1
  • Santa Fe 1
  • DERROTA
  • Santa Fe 0
  • Alianza FC 1
  • DERROTA
  • At. Nacional 3
  • Santa Fe 0
  • VICTORIA
  • Santa Fe 1
  • Deportivo Pereira 0
7 Alianza FC Alianza FC 22 14 6 4 4 15 16
  • VICTORIA
  • Atlético Bucaraman. 0
  • Alianza FC 1
  • DERROTA
  • Alianza FC 1
  • Junior 5
  • VICTORIA
  • Santa Fe 0
  • Alianza FC 1
  • EMPATE
  • Jaguares FC 0
  • Alianza FC 0
  • VICTORIA
  • Alianza FC 2
  • Once Caldas 1
8 Deportivo Cali Deportivo Cali 20 14 5 5 4 19 18
  • VICTORIA
  • Deportivo Cali 1
  • Atlético Huila 0
  • EMPATE
  • La Equidad 1
  • Deportivo Cali 1
  • EMPATE
  • Deportivo Cali 2
  • Independiente Mede. 2
  • VICTORIA
  • Unión Magdalena 3
  • Deportivo Cali 4
  • VICTORIA
  • Deportivo Cali 2
  • Deportes Tolima 0
9 Deportivo Pasto Deportivo Pasto 20 14 5 5 4 12 13
  • VICTORIA
  • Deportivo Pasto 1
  • Jaguares FC 0
  • DERROTA
  • Deportivo Pereira 2
  • Deportivo Pasto 1
  • DERROTA
  • Deportivo Pasto 1
  • Deportes Tolima 2
  • VICTORIA
  • Atlético Bucaraman. 0
  • Deportivo Pasto 2
  • VICTORIA
  • Deportivo Pasto 1
  • Atlético Huila 0
10 Deportes Tolima Deportes Tolima 19 14 5 4 5 13 14
  • EMPATE
  • Deportes Tolima 1
  • Independiente Mede. 1
  • VICTORIA
  • Deportivo Pasto 1
  • Deportes Tolima 2
  • VICTORIA
  • Deportes Tolima 2
  • Envigado 0
  • VICTORIA
  • Junior 0
  • Deportes Tolima 1
  • DERROTA
  • Deportivo Cali 2
  • Deportes Tolima 0
11 Unión Magdalena Unión Magdalena 18 14 4 6 4 15 19
  • DERROTA
  • Junior 7
  • Unión Magdalena 1
  • DERROTA
  • Águilas Doradas 2
  • Unión Magdalena 1
  • EMPATE
  • Unión Magdalena 1
  • Once Caldas 1
  • VICTORIA
  • Deportivo Pereira 1
  • Unión Magdalena 2
  • DERROTA
  • Unión Magdalena 3
  • Deportivo Cali 4
12 Junior Junior 17 14 4 5 5 21 14
  • VICTORIA
  • Junior 7
  • Unión Magdalena 1
  • VICTORIA
  • Alianza FC 1
  • Junior 5
  • EMPATE
  • Junior 1
  • At. Nacional 1
  • DERROTA
  • Boyacá Chicó 2
  • Junior 1
  • DERROTA
  • Junior 0
  • Deportes Tolima 1
13 Atlético Huila Atlético Huila 16 14 4 4 6 12 11
  • VICTORIA
  • Atlético Huila 3
  • Deportes Tolima 0
  • DERROTA
  • Deportivo Cali 1
  • Atlético Huila 0
  • EMPATE
  • Atlético Huila 1
  • Águilas Doradas 1
  • DERROTA
  • Millonarios 2
  • Atlético Huila 1
  • DERROTA
  • Deportivo Pasto 1
  • Atlético Huila 0
14 Once Caldas Once Caldas 16 14 4 4 6 16 16
  • VICTORIA
  • Deportivo Pereira 1
  • Once Caldas 2
  • EMPATE
  • Once Caldas 0
  • Envigado 0
  • EMPATE
  • Unión Magdalena 1
  • Once Caldas 1
  • EMPATE
  • Once Caldas 1
  • La Equidad 1
  • DERROTA
  • Alianza FC 2
  • Once Caldas 1
15 Atlético Bucaramanga Atlético 16 14 4 4 6 12 15
  • DERROTA
  • Atlético Bucaraman. 0
  • Alianza FC 1
  • DERROTA
  • Millonarios 3
  • Atlético Bucaraman. 0
  • EMPATE
  • Atlético Bucaraman. 1
  • Deportivo Pereira 1
  • DERROTA
  • Atlético Bucaraman. 0
  • Deportivo Pasto 2
  • DERROTA
  • Independiente Mede. 2
  • Atlético Bucaraman. 0
16 La Equidad La Equidad 15 14 2 9 3 11 14
  • EMPATE
  • La Equidad 0
  • Boyacá Chicó 0
  • DERROTA
  • At. Nacional 5
  • La Equidad 0
  • EMPATE
  • La Equidad 1
  • Deportivo Cali 1
  • EMPATE
  • Once Caldas 1
  • La Equidad 1
  • VICTORIA
  • La Equidad 2
  • Jaguares FC 0
17 Boyacá Chicó Boyacá Chicó 14 14 2 8 4 10 17
  • EMPATE
  • La Equidad 0
  • Boyacá Chicó 0
  • EMPATE
  • Boyacá Chicó 1
  • Santa Fe 1
  • DERROTA
  • América de Cali 5
  • Boyacá Chicó 0
  • VICTORIA
  • Boyacá Chicó 2
  • Junior 1
  • DERROTA
  • Boyacá Chicó 0
  • Águilas Doradas 1
18 Deportivo Pereira Deportivo 13 14 3 4 7 12 17
  • VICTORIA
  • Deportivo Pereira 2
  • Deportivo Pasto 1
  • EMPATE
  • Atlético Bucaraman. 1
  • Deportivo Pereira 1
  • DERROTA
  • Deportivo Pereira 1
  • Unión Magdalena 2
  • DERROTA
  • Santa Fe 1
  • Deportivo Pereira 0
  • EMPATE
  • Deportivo Pereira 0
  • Águilas Doradas 0
19 Jaguares FC Jaguares FC 9 14 2 3 9 6 17
  • DERROTA
  • Deportivo Pasto 1
  • Jaguares FC 0
  • DERROTA
  • Jaguares FC 0
  • América de Cali 1
  • DERROTA
  • Envigado 1
  • Jaguares FC 0
  • EMPATE
  • Jaguares FC 0
  • Alianza FC 0
  • DERROTA
  • La Equidad 2
  • Jaguares FC 0
20 Envigado Envigado 8 14 1 5 8 8 19
  • EMPATE
  • Envigado 2
  • Águilas Doradas 2
  • EMPATE
  • Once Caldas 0
  • Envigado 0
  • VICTORIA
  • Envigado 1
  • Jaguares FC 0
  • DERROTA
  • Deportes Tolima 2
  • Envigado 0
  • DERROTA
  • Envigado 1
  • Millonarios 2
Siguiente Ronda : Águilas Doradas, América Cali, Independiente, At. Nacional, Millonarios, Santa Fe, Alianza FC, Deportivo Cali

La liga colombiana es llamada liga postobon por motivos de patrocinio.


la liga postobon esta conformada por 18 equipos los cuales juegan todos contra todos, los 8 primeros de este todos contra todos clasifican a los cuadrangulares y en los que la final la juegan los primeros de los dos cuadrangulares
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,744,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1949
Total Execution Time  0.1968
  CADENA URL  
/finalizacion_colombia/grupo1/jornada14
  GET DATOS  
$_GET['/finalizacion_colombia/grupo1/jornada14']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0051  SELECT type FROM routes WHERE alias = 'finalizacion_colombia'
0.0105  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'finalizacion_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0062  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=42 ORDER BY l.group_code ASC
0.0051  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 14:48:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0051  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 14:48:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0050  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 14:48:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0051  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 14:48:12' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0057  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'finalizacion_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0054  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=70934 AND rel.round=14
0.0051  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 70934 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0051  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 70934 AND esl.points > 0
0.0050  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 70934 ORDER BY creation_date DESC LIMIT 0, 10
0.0057  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 70934
0.0078  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2023` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 70934 AND c.`round` = 14 ORDER BY shedule ASC LIMIT 200
0.0074  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2023 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2023 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 70934 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (659630,659627,659624,659622,659629,659621,659625,659626,659628,659623) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0056  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2023` e INNER JOIN calendars2023 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 14 AND e.real_date IS NOT NULL AND e.league_id = 70934 ORDER BY total DESC LIMIT 40
0.0117  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 = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0055  SELECT *,(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 = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053  SELECT distinct(shedule), round FROM `calendars2023` as c WHERE c.`league_id` = 70934 AND shedule >= '2023/09/01' AND shedule < '2023/10/01' ORDER BY shedule ASC
0.0050  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 70934 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0053  SELECT data1, data2 FROM services_tags WHERE categoryId=50
0.0053  SELECT group_code, extraName from `leagues` WHERE categoryId=50 AND year=2023