4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Clausura Colombia

La temporada finalizó el Jueves, 09 Noviembre 2023.
 
30 Sep 23
01:00 Finalizado
Jaguares FC Jaguares FC 0-0 Junior Junior más información 429
 
30 Sep 23
03:10 Finalizado
Deportes Tolima Deportes Tolima 2-0 Boyacá Chicó Boyacá Chicó más información Jugadas destacadas 238
39' V. Perea
49' J. Hernández 1-0
90' F. Bone 2-0
 
30 Sep 23
23:00 Finalizado
Atlético Bucaramanga Atlético Bucaramanga 1-1 Santa Fe Santa Fe más información Jugadas destacadas 229
40' J. Cordoba 1-0
1-1 68' I. Scarpeta
 
01 Oct 23
01:10 Finalizado
At. Nacional At. Nacional 3-0 Envigado Envigado más información Jugadas destacadas 214
40' S. Velásquez 1-0
57' E. Ramírez 2-0
59' E. Ramírez 3-0
 
01 Oct 23
02:00 Finalizado
Águilas Doradas Águilas Doradas 3-0 Deportivo Pasto Deportivo Pasto más información Jugadas destacadas 225
61' D. Moreno
73' Jhon Salazar 1-0
79' M. Pérez 2-0
88' J. Cuenú 3-0
 
01 Oct 23
03:20 Finalizado
Deportivo Pereira Deportivo Pereira 2-4 América de Cali América de Cali más información Jugadas destacadas 386
0-1 23' J. Quiñones
34' D. Hernández 1-1
42' J. Súarez 2-1
2-2 47' Ramos
2-3 68' V. Ibarbo
2-4 74' C. Barrios
 
01 Oct 23
23:00 Finalizado
Once Caldas Once Caldas 2-2 Independiente Medellín Independiente Medellín más información Jugadas destacadas 251
59' J. Marulanda
61' D. Moreno 1-0
1-1 65' D. Torres
74' J. Cuesta 2-1
2-2 78' A. Plata
 
02 Oct 23
02:30 Finalizado
Deportivo Cali Deportivo Cali 1-0 Alianza FC Alianza FC más información Jugadas destacadas 334
8' G. Ramírez 1-0
 
03 Oct 23
03:10 Finalizado
Atlético Huila Atlético Huila 1-1 La Equidad La Equidad más información Jugadas destacadas 380
21' Marcus Vinicius 1-0
73' Carlos Lucumi
1-1 81' J. Castro
19 Oct 23
03:00 Finalizado
Millonarios Millonarios 1-1 Unión Magdalena Unión Magdalena más información Jugadas destacadas 421
67' Samuel Gallego 1-0
1-1 86' F. Cantillo
Equipos Puntos J. G. E. P. F. C. Forma
1 Águilas Doradas Águilas Doradas 31 15 8 7 0 22 10
  • EMPATE
  • Atlético Huila 1
  • Águilas Doradas 1
  • EMPATE
  • Águilas Doradas 2
  • América de Cali 2
  • VICTORIA
  • Boyacá Chicó 0
  • Águilas Doradas 1
  • VICTORIA
  • Águilas Doradas 3
  • Deportivo Pasto 0
  • EMPATE
  • Deportivo Pereira 0
  • Águilas Doradas 0
2 América de Cali América Cali 29 15 8 5 2 31 16
  • 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
  • VICTORIA
  • Deportivo Pereira 2
  • América de Cali 4
3 At. Nacional At. Nacional 27 15 8 3 4 24 13
  • 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
  • VICTORIA
  • At. Nacional 3
  • Envigado 0
4 Independiente Medellín Independiente 26 15 6 8 1 21 14
  • 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
  • EMPATE
  • Once Caldas 2
  • Independiente Mede. 2
5 Deportivo Cali Deportivo Cali 23 15 6 5 4 20 18
  • 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 1
  • Alianza FC 0
  • VICTORIA
  • Deportivo Cali 2
  • Deportes Tolima 0
6 Millonarios Millonarios 23 15 6 5 4 15 14
  • 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
  • EMPATE
  • Millonarios 1
  • Unión Magdalena 1
7 Santa Fe Santa Fe 23 15 6 5 4 17 17
  • 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
  • EMPATE
  • Atlético Bucaraman. 1
  • Santa Fe 1
8 Deportes Tolima Deportes Tolima 22 15 6 4 5 15 14
  • VICTORIA
  • Deportivo Pasto 1
  • Deportes Tolima 2
  • VICTORIA
  • Deportes Tolima 2
  • Envigado 0
  • VICTORIA
  • Junior 0
  • Deportes Tolima 1
  • VICTORIA
  • Deportes Tolima 2
  • Boyacá Chicó 0
  • DERROTA
  • Deportivo Cali 2
  • Deportes Tolima 0
9 Alianza FC Alianza FC 22 15 6 4 5 15 17
  • 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
  • DERROTA
  • Deportivo Cali 1
  • Alianza FC 0
10 Deportivo Pasto Deportivo Pasto 20 15 5 5 5 12 16
  • 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
  • DERROTA
  • Águilas Doradas 3
  • Deportivo Pasto 0
11 Unión Magdalena Unión Magdalena 19 15 4 7 4 16 20
  • 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
  • EMPATE
  • Millonarios 1
  • Unión Magdalena 1
12 Junior Junior 18 15 4 6 5 21 14
  • VICTORIA
  • Alianza FC 1
  • Junior 5
  • EMPATE
  • Junior 1
  • At. Nacional 1
  • DERROTA
  • Boyacá Chicó 2
  • Junior 1
  • DERROTA
  • Junior 0
  • Deportes Tolima 1
  • EMPATE
  • Jaguares FC 0
  • Junior 0
13 Atlético Huila Atlético Huila 17 15 4 5 6 13 12
  • 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
  • EMPATE
  • Atlético Huila 1
  • La Equidad 1
14 Once Caldas Once Caldas 17 15 4 5 6 18 18
  • 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
  • EMPATE
  • Once Caldas 2
  • Independiente Mede. 2
15 Atlético Bucaramanga Atlético 17 15 4 5 6 13 16
  • 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
  • EMPATE
  • Atlético Bucaraman. 1
  • Santa Fe 1
16 La Equidad La Equidad 16 15 2 10 3 12 15
  • 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
  • EMPATE
  • Atlético Huila 1
  • La Equidad 1
17 Boyacá Chicó Boyacá Chicó 14 15 2 8 5 10 19
  • 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
  • DERROTA
  • Deportes Tolima 2
  • Boyacá Chicó 0
18 Deportivo Pereira Deportivo 13 15 3 4 8 14 21
  • EMPATE
  • Atlético Bucaraman. 1
  • Deportivo Pereira 1
  • DERROTA
  • Deportivo Pereira 1
  • Unión Magdalena 2
  • DERROTA
  • Santa Fe 1
  • Deportivo Pereira 0
  • DERROTA
  • Deportivo Pereira 2
  • América de Cali 4
  • EMPATE
  • Deportivo Pereira 0
  • Águilas Doradas 0
19 Jaguares FC Jaguares FC 10 15 2 4 9 6 17
  • 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
  • EMPATE
  • Jaguares FC 0
  • Junior 0
20 Envigado Envigado 8 15 1 5 9 8 22
  • EMPATE
  • Once Caldas 0
  • Envigado 0
  • VICTORIA
  • Envigado 1
  • Jaguares FC 0
  • DERROTA
  • Deportes Tolima 2
  • Envigado 0
  • DERROTA
  • Envigado 1
  • Millonarios 2
  • DERROTA
  • At. Nacional 3
  • Envigado 0
Siguiente Ronda : Águilas Doradas, América Cali, At. Nacional, Independiente, Deportivo Cali, Millonarios, Santa Fe, Deportes Tolima

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,659,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1182
Total Execution Time  0.1204
  CADENA URL  
/finalizacion_colombia/grupo1/jornada15
  GET DATOS  
$_GET['/finalizacion_colombia/grupo1/jornada15']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT type FROM routes WHERE alias = 'finalizacion_colombia'
0.0043  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=50 AND type_rel = 3
0.0058  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 50 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  SELECT /*53 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 (1296063,1295037,1294903,1294541,1294367) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 70934 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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.0017  SELECT type,rule FROM rules WHERE categoryId = 50 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 21:49:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 21:49:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 21:49:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 21:49:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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.0021  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=15
0.0020  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.0018  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-27" 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.0025  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-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 70934
0.0036  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` = 15 ORDER BY shedule ASC LIMIT 200
0.0041  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 (659635,659632,659638,659639,659640,659637,659631,659636,659633,659634) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0023  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 = 15 AND e.real_date IS NOT NULL AND e.league_id = 70934 ORDER BY total DESC LIMIT 40
0.0050  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 = 14 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 *,(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 = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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.0018  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-28 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.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=50
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=50 AND year=2023