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

Apertura Colombia 2021

La temporada finalizó el Domingo, 18 Abril 2021.
 
17 Abr 21
02:40 Finalizado
Alianza FC Alianza FC 1-1 Envigado Envigado más información Jugadas destacadas 73
0-1 72' E. López
87' M. Palacios 1-1
 
18 Abr 21
22:30 Finalizado
Atlético Bucaramanga Atlético Bucaramanga 4-1 Águilas Doradas Águilas Doradas más información Jugadas destacadas 14
1' A. Quintana 1-0
53' A. Sarmiento 2-0
72' A. Quintana 3-0
3-1 81' J. Blanco
82' J. Zuluaga 4-1
 
18 Abr 21
22:30 Finalizado
Deportivo Pereira Deportivo Pereira 4-2 Deportivo Pasto Deportivo Pasto más información Jugadas destacadas 41
0-1 4' R. Vanegas
8' J. García 1-1
1-2 40' C. Hidalgo
52' B. Castrillón 2-2
62' J. Vásquez 3-2
66' F. Arizala 4-2
 
18 Abr 21
22:30 Finalizado
La Equidad La Equidad 1-2 Santa Fe Santa Fe más información Jugadas destacadas 25
22' H. Zapata 1-0
1-1 53' Jhon Arias
1-2 86' J. Caballero
 
18 Abr 21
22:30 Finalizado
At. Nacional At. Nacional 7-1 Patriotas Boyacá Patriotas Boyacá más información Jugadas destacadas 88
18' Jefferson Duque 1-0
21' J. Marulanda
45' Jefferson Duque 3-0
45' Á. Castro 4-0
46' Á. Castro 5-0
62' Jefferson Duque 6-0
72' Jefferson Duque 7-0
82' Neyder Moreno 8-0
 
18 Abr 21
22:30 Finalizado
Boyacá Chicó Boyacá Chicó 0-0 Jaguares FC Jaguares FC más información 90
18 Abr 21
22:30 Finalizado
América de Cali América de Cali 2-0 Deportes Tolima Deportes Tolima más información Jugadas destacadas 180
8' J. Quiñónes
81' D. Vergara 2-0
93' K. Andrade
 
18 Abr 21
22:30 Finalizado
Millonarios Millonarios 3-1 Deportivo Cali Deportivo Cali más información Jugadas destacadas 54
50' F. Uribe 1-0
73' David Silva 2-0
2-1 87' G. Rodriguez
91' C. Arango 3-1
 
18 Abr 21
23:30 Finalizado
Once Caldas Once Caldas 2-0 Independiente Medellín Independiente Medellín más información Jugadas destacadas 142
70' Mender García 1-0
72' J. Reina
87' A. Estacio 2-0
Equipos Puntos J. G. E. P. F. C. Forma
1 At. Nacional At. Nacional 34 18 10 4 4 37 15
  • EMPATE
  • Independiente Mede. 0
  • At. Nacional 0
  • DERROTA
  • Deportes Tolima 2
  • At. Nacional 1
  • VICTORIA
  • At. Nacional 3
  • Envigado 0
  • DERROTA
  • Deportivo Cali 1
  • At. Nacional 0
  • VICTORIA
  • At. Nacional 7
  • Patriotas Boyacá 1
2 Santa Fe Santa Fe 33 18 9 6 3 25 14
  • EMPATE
  • Junior 1
  • Santa Fe 1
  • EMPATE
  • Santa Fe 1
  • Deportivo Pereira 1
  • VICTORIA
  • Alianza FC 0
  • Santa Fe 3
  • DERROTA
  • Santa Fe 1
  • Millonarios 2
  • VICTORIA
  • La Equidad 1
  • Santa Fe 2
3 Millonarios Millonarios 33 18 10 3 5 25 18
  • VICTORIA
  • Millonarios 2
  • Atlético Bucaraman. 1
  • DERROTA
  • América de Cali 2
  • Millonarios 1
  • EMPATE
  • Millonarios 0
  • Deportes Tolima 0
  • VICTORIA
  • Santa Fe 1
  • Millonarios 2
  • VICTORIA
  • Millonarios 3
  • Deportivo Cali 1
4 Deportivo Cali Deportivo Cali 31 18 8 7 3 19 14
  • DERROTA
  • Atlético Bucaraman. 1
  • Deportivo Cali 0
  • EMPATE
  • Deportivo Cali 1
  • Deportivo Pasto 1
  • VICTORIA
  • La Equidad 2
  • Deportivo Cali 5
  • VICTORIA
  • Deportivo Cali 1
  • At. Nacional 0
  • DERROTA
  • Millonarios 3
  • Deportivo Cali 1
5 Deportes Tolima Deportes Tolima 30 18 8 6 4 22 14
  • EMPATE
  • Envigado 0
  • Deportes Tolima 0
  • VICTORIA
  • Deportes Tolima 2
  • At. Nacional 1
  • EMPATE
  • Millonarios 0
  • Deportes Tolima 0
  • EMPATE
  • Deportes Tolima 0
  • Atlético Bucaraman. 0
  • DERROTA
  • América de Cali 2
  • Deportes Tolima 0
6 La Equidad La Equidad 30 18 8 6 4 21 18
  • EMPATE
  • La Equidad 1
  • Alianza FC 1
  • EMPATE
  • Deportivo Pereira 0
  • La Equidad 0
  • DERROTA
  • La Equidad 2
  • Deportivo Cali 5
  • VICTORIA
  • América de Cali 0
  • La Equidad 1
  • DERROTA
  • La Equidad 1
  • Santa Fe 2
7 Junior Junior 29 18 8 5 5 21 13
  • VICTORIA
  • Deportes Tolima 0
  • Junior 1
  • EMPATE
  • Junior 1
  • Santa Fe 1
  • VICTORIA
  • Jaguares FC 0
  • Junior 2
  • EMPATE
  • Junior 0
  • Águilas Doradas 0
  • EMPATE
  • Deportivo Pasto 0
  • Junior 0
8 América de Cali América Cali 29 18 7 8 3 19 12
  • VICTORIA
  • Alianza FC 0
  • América de Cali 2
  • VICTORIA
  • América de Cali 2
  • Millonarios 1
  • DERROTA
  • América de Cali 0
  • La Equidad 1
  • EMPATE
  • Jaguares FC 0
  • América de Cali 0
  • VICTORIA
  • América de Cali 2
  • Deportes Tolima 0
9 Independiente Medellín Independiente 26 18 6 8 4 17 15
  • VICTORIA
  • América de Cali 1
  • Independiente Mede. 2
  • EMPATE
  • Independiente Mede. 0
  • At. Nacional 0
  • DERROTA
  • Deportivo Pereira 1
  • Independiente Mede. 0
  • EMPATE
  • Independiente Mede. 2
  • Alianza FC 2
  • DERROTA
  • Once Caldas 2
  • Independiente Mede. 0
10 Jaguares FC Jaguares FC 25 18 7 4 7 21 21
  • DERROTA
  • At. Nacional 3
  • Jaguares FC 1
  • DERROTA
  • Jaguares FC 0
  • Junior 2
  • VICTORIA
  • Once Caldas 1
  • Jaguares FC 2
  • EMPATE
  • Jaguares FC 0
  • América de Cali 0
  • EMPATE
  • Boyacá Chicó 0
  • Jaguares FC 0
11 Atlético Bucaramanga Atlético 24 18 6 6 6 20 16
  • DERROTA
  • Millonarios 2
  • Atlético Bucaraman. 1
  • EMPATE
  • Deportivo Pasto 1
  • Atlético Bucaraman. 1
  • DERROTA
  • Atlético Bucaraman. 0
  • Patriotas Boyacá 1
  • EMPATE
  • Deportes Tolima 0
  • Atlético Bucaraman. 0
  • VICTORIA
  • Atlético Bucaraman. 4
  • Águilas Doradas 1
12 Deportivo Pasto Deportivo Pasto 23 18 4 11 3 19 20
  • EMPATE
  • Deportivo Cali 1
  • Deportivo Pasto 1
  • EMPATE
  • Deportivo Pasto 1
  • Atlético Bucaraman. 1
  • EMPATE
  • Boyacá Chicó 0
  • Deportivo Pasto 0
  • EMPATE
  • Deportivo Pasto 0
  • Junior 0
  • DERROTA
  • Deportivo Pereira 4
  • Deportivo Pasto 2
13 Boyacá Chicó Boyacá Chicó 19 18 5 4 9 17 20
  • DERROTA
  • Once Caldas 4
  • Boyacá Chicó 2
  • VICTORIA
  • Boyacá Chicó 2
  • Alianza FC 0
  • EMPATE
  • Boyacá Chicó 0
  • Deportivo Pasto 0
  • VICTORIA
  • Águilas Doradas 0
  • Boyacá Chicó 3
  • EMPATE
  • Boyacá Chicó 0
  • Jaguares FC 0
14 Deportivo Pereira Deportivo 18 18 4 6 8 16 24
  • EMPATE
  • Deportivo Pereira 0
  • La Equidad 0
  • EMPATE
  • Santa Fe 1
  • Deportivo Pereira 1
  • VICTORIA
  • Deportivo Pereira 1
  • Independiente Mede. 0
  • VICTORIA
  • Envigado 0
  • Deportivo Pereira 1
  • VICTORIA
  • Deportivo Pereira 4
  • Deportivo Pasto 2
15 Once Caldas Once Caldas 17 18 3 8 7 20 23
  • VICTORIA
  • Once Caldas 4
  • Boyacá Chicó 2
  • EMPATE
  • Águilas Doradas 2
  • Once Caldas 2
  • DERROTA
  • Once Caldas 1
  • Jaguares FC 2
  • EMPATE
  • Patriotas Boyacá 1
  • Once Caldas 1
  • VICTORIA
  • Once Caldas 2
  • Independiente Mede. 0
16 Envigado Envigado 17 18 3 8 7 15 23
  • EMPATE
  • Envigado 0
  • Deportes Tolima 0
  • VICTORIA
  • Envigado 3
  • Patriotas Boyacá 0
  • DERROTA
  • At. Nacional 3
  • Envigado 0
  • DERROTA
  • Envigado 0
  • Deportivo Pereira 1
  • EMPATE
  • Alianza FC 1
  • Envigado 1
17 Patriotas Boyacá Patriotas 17 18 5 2 11 17 31
  • VICTORIA
  • Patriotas Boyacá 2
  • Águilas Doradas 1
  • DERROTA
  • Envigado 3
  • Patriotas Boyacá 0
  • VICTORIA
  • Atlético Bucaraman. 0
  • Patriotas Boyacá 1
  • EMPATE
  • Patriotas Boyacá 1
  • Once Caldas 1
  • DERROTA
  • At. Nacional 7
  • Patriotas Boyacá 1
18 Águilas Doradas Águilas Doradas 14 18 2 8 8 13 24
  • DERROTA
  • Patriotas Boyacá 2
  • Águilas Doradas 1
  • EMPATE
  • Águilas Doradas 2
  • Once Caldas 2
  • EMPATE
  • Junior 0
  • Águilas Doradas 0
  • DERROTA
  • Águilas Doradas 0
  • Boyacá Chicó 3
  • DERROTA
  • Atlético Bucaraman. 4
  • Águilas Doradas 1
19 Alianza FC Alianza FC 6 18 0 6 12 10 39
  • DERROTA
  • Alianza FC 0
  • América de Cali 2
  • DERROTA
  • Boyacá Chicó 2
  • Alianza FC 0
  • DERROTA
  • Alianza FC 0
  • Santa Fe 3
  • EMPATE
  • Independiente Mede. 2
  • Alianza FC 2
  • EMPATE
  • Alianza FC 1
  • Envigado 1
Series Finales : At. Nacional, Santa Fe, Millonarios, Deportivo Cali, Deportes Tolima, La Equidad, Junior, América Cali

INFORMACIÓN

Liga Profesional de Primera División de la República de Colombia.

Llamada localmente Liga Postobon, ya que la marca de bebidas Postobon patrocina este torneo.

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,619,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1287
Total Execution Time  0.1306
  CADENA URL  
/apertura_colombia2021/grupo1/jornada19/clasificacion
  GET DATOS  
$_GET['/apertura_colombia2021/grupo1/jornada19/clasificacion']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0038  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 = 60836 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0045  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.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 15:34:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 15:34:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 15:34:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 15:34:43' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 42 GROUP BY l.categoryId
0.0037  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=42 GROUP BY l.year ORDER BY l.year DESC
0.0037  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=60836 AND rel.round=19
0.0034  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` = 60836 ORDER BY creation_date DESC LIMIT 0, 10
0.0039  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` = 60836
0.0052  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 `calendars2021` 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` = 60836 AND c.`round` = 19 ORDER BY shedule ASC LIMIT 200
0.0057  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 events2021 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2021 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 60836 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 (225407,225408,225410,225411,225412,225413,225414,225415,225409) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0040  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 `events2021` e INNER JOIN calendars2021 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 = 19 AND e.real_date IS NOT NULL AND e.league_id = 60836 ORDER BY total DESC LIMIT 40
0.0081  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 = 60836 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  SELECT *,(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 = 60836 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  SELECT distinct(shedule), round FROM `calendars2021` as c WHERE c.`league_id` = 60836 AND shedule >= '2021/04/01' AND shedule < '2021/05/01' ORDER BY shedule ASC
0.0038  SELECT data1, data2 FROM services_tags WHERE categoryId=42
0.0038  SELECT group_code, extraName from `leagues` WHERE categoryId=42 AND year=2021