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

Apertura Colombia 2009

La temporada finalizó el Domingo, 17 Mayo 2009.
Resultados
« Jornada Anterior
Jornada 18
 
 
17 May 09
01:20 Finalizado 		Deportes Tolima Deportes Tolima 1-0 Junior Junior más información Jugadas destacadas 2
73' W. Medina 1-0
 
17 May 09
22:30 Finalizado 		At. Nacional At. Nacional 1-1 Deportivo Pereira Deportivo Pereira más información Jugadas destacadas ...
0-1 8' E. Giménez
12' S. Galván Rey 1-1
 
17 May 09
22:30 Finalizado 		Deportivo Pasto Deportivo Pasto 3-0 Envigado Envigado más información Jugadas destacadas ...
23' H. Centurión 1-0
81' F. Villamíl 2-0
85' H. Centurión 3-0
 
17 May 09
22:30 Finalizado 		Millonarios Millonarios 3-1 América de Cali América de Cali más información Jugadas destacadas ...
3' C. Valencia 1-0
1-1 38' Ramos
67' G. Bedoya 2-1
71' J. Torres
 
17 May 09
22:30 Finalizado 		Deportivo Cali Deportivo Cali 2-2 Santa Fe Santa Fe más información Jugadas destacadas ...
21' A. Carrillo 1-0
1-1 25' Julio Gutiérrez
37' P. Batalla 2-1
2-2 51' L. Seijas
83' J. Ramos
 
17 May 09
22:30 Finalizado 		Real Cartagena Real Cartagena 6-3 Boyacá Chicó Boyacá Chicó más información Jugadas destacadas ...
9' E. Chamorro 1-0
1-1 15' E. Móvil
20' H. Patiño 2-1
21' E. Jiménez 3-1
3-2 33' O. Madera
52' M. Arroyo 4-2
57' E. Jiménez 5-2
76' O. Madera
78' E. Jiménez 6-2
6-3 86' C. Monsalvo
 
17 May 09
22:30 Finalizado 		Once Caldas Once Caldas 1-0 Independiente Medellín Independiente Medellín más información Jugadas destacadas ...
56' A. Henríquez 1-0
90' A. Henríquez
 
17 May 09
22:30 Finalizado 		Cúcuta Deportivo Cúcuta Deportivo 0-0 La Equidad La Equidad más información Jugadas destacadas ...
90' P. Portocarrero
 
17 May 09
22:30 Finalizado 		Deportes Quindío Deportes Quindío 0-2 Atlético Huila Atlético Huila más información Jugadas destacadas ...
0-1 14' J. Angulo
0-2 90' F. Pacheco
90' D. Arango
Clasificación
« Jornada Anterior
Jornada 18
 
Equipos Puntos J. G. E. P. F. C. Forma
1 La Equidad La Equidad 32 18 9 5 4 23 17
  • EMPATE
  • Junior 1
  • La Equidad 1
  • VICTORIA
  • La Equidad 2
  • Deportes Quindío 1
  • DERROTA
  • Deportes Tolima 1
  • La Equidad 0
  • EMPATE
  • La Equidad 1
  • Millonarios 1
  • EMPATE
  • Cúcuta Deportivo 0
  • La Equidad 0
2 Deportes Tolima Deportes Tolima 32 18 10 2 6 21 16
  • VICTORIA
  • Deportes Tolima 1
  • Independiente Mede. 0
  • DERROTA
  • Deportivo Pereira 2
  • Deportes Tolima 0
  • VICTORIA
  • Deportes Tolima 1
  • La Equidad 0
  • DERROTA
  • América de Cali 3
  • Deportes Tolima 1
  • VICTORIA
  • Deportes Tolima 1
  • Junior 0
3 Junior Junior 31 18 9 4 5 30 18
  • EMPATE
  • Junior 1
  • La Equidad 1
  • DERROTA
  • América de Cali 3
  • Junior 0
  • VICTORIA
  • Junior 4
  • Atlético Huila 0
  • VICTORIA
  • Junior 4
  • Deportes Quindío 1
  • DERROTA
  • Deportes Tolima 1
  • Junior 0
4 Cúcuta Deportivo Cúcuta 31 18 9 4 5 16 14
  • VICTORIA
  • Cúcuta Deportivo 2
  • Santa Fe 1
  • DERROTA
  • Envigado 1
  • Cúcuta Deportivo 0
  • VICTORIA
  • Cúcuta Deportivo 1
  • Independiente Mede. 0
  • VICTORIA
  • Deportivo Pereira 0
  • Cúcuta Deportivo 1
  • EMPATE
  • Cúcuta Deportivo 0
  • La Equidad 0
5 Boyacá Chicó Boyacá Chicó 30 18 8 6 4 24 22
  • VICTORIA
  • Boyacá Chicó 4
  • Cúcuta Deportivo 0
  • VICTORIA
  • Boyacá Chicó 1
  • Once Caldas 0
  • VICTORIA
  • Deportivo Pasto 0
  • Boyacá Chicó 1
  • EMPATE
  • Boyacá Chicó 1
  • Deportivo Cali 1
  • DERROTA
  • Real Cartagena 6
  • Boyacá Chicó 3
6 Envigado Envigado 29 18 8 5 5 22 24
  • VICTORIA
  • Millonarios 0
  • Envigado 1
  • VICTORIA
  • Envigado 1
  • Cúcuta Deportivo 0
  • EMPATE
  • At. Nacional 1
  • Envigado 1
  • EMPATE
  • Envigado 1
  • Once Caldas 1
  • DERROTA
  • Deportivo Pasto 3
  • Envigado 0
7 Once Caldas Once Caldas 28 18 7 7 4 23 14
  • VICTORIA
  • Once Caldas 3
  • Real Cartagena 0
  • DERROTA
  • Boyacá Chicó 1
  • Once Caldas 0
  • VICTORIA
  • Once Caldas 3
  • Santa Fe 0
  • EMPATE
  • Envigado 1
  • Once Caldas 1
  • VICTORIA
  • Once Caldas 1
  • Independiente Mede. 0
8 Deportivo Cali Deportivo Cali 26 18 7 5 6 22 20
  • DERROTA
  • Deportivo Pasto 1
  • Deportivo Cali 0
  • DERROTA
  • Atlético Huila 1
  • Deportivo Cali 0
  • VICTORIA
  • Deportivo Cali 2
  • Real Cartagena 1
  • EMPATE
  • Boyacá Chicó 1
  • Deportivo Cali 1
  • EMPATE
  • Deportivo Cali 2
  • Santa Fe 2
9 Deportes Quindío Deportes 25 18 7 4 7 23 23
  • DERROTA
  • Deportes Quindío 0
  • Deportivo Pereira 2
  • DERROTA
  • La Equidad 2
  • Deportes Quindío 1
  • VICTORIA
  • Deportes Quindío 2
  • América de Cali 0
  • DERROTA
  • Junior 4
  • Deportes Quindío 1
  • DERROTA
  • Deportes Quindío 0
  • Atlético Huila 2
10 Real Cartagena Real Cartagena 25 18 7 4 7 23 24
  • DERROTA
  • Once Caldas 3
  • Real Cartagena 0
  • VICTORIA
  • Real Cartagena 2
  • Deportivo Pasto 1
  • DERROTA
  • Deportivo Cali 2
  • Real Cartagena 1
  • DERROTA
  • Atlético Huila 3
  • Real Cartagena 1
  • VICTORIA
  • Real Cartagena 6
  • Boyacá Chicó 3
11 América de Cali América Cali 24 18 7 3 8 24 21
  • DERROTA
  • América de Cali 2
  • Atlético Huila 3
  • VICTORIA
  • América de Cali 3
  • Junior 0
  • DERROTA
  • Deportes Quindío 2
  • América de Cali 0
  • VICTORIA
  • América de Cali 3
  • Deportes Tolima 1
  • DERROTA
  • Millonarios 3
  • América de Cali 1
12 Deportivo Pereira Deportivo 24 18 7 3 8 26 25
  • VICTORIA
  • Deportes Quindío 0
  • Deportivo Pereira 2
  • VICTORIA
  • Deportivo Pereira 2
  • Deportes Tolima 0
  • VICTORIA
  • Millonarios 2
  • Deportivo Pereira 3
  • DERROTA
  • Deportivo Pereira 0
  • Cúcuta Deportivo 1
  • EMPATE
  • At. Nacional 1
  • Deportivo Pereira 1
13 Atlético Huila Atlético Huila 24 18 7 3 8 21 26
  • VICTORIA
  • América de Cali 2
  • Atlético Huila 3
  • VICTORIA
  • Atlético Huila 1
  • Deportivo Cali 0
  • DERROTA
  • Junior 4
  • Atlético Huila 0
  • VICTORIA
  • Atlético Huila 3
  • Real Cartagena 1
  • VICTORIA
  • Deportes Quindío 0
  • Atlético Huila 2
14 Santa Fe Santa Fe 21 18 5 6 7 20 25
  • DERROTA
  • Cúcuta Deportivo 2
  • Santa Fe 1
  • EMPATE
  • Santa Fe 1
  • At. Nacional 1
  • DERROTA
  • Once Caldas 3
  • Santa Fe 0
  • VICTORIA
  • Santa Fe 1
  • Deportivo Pasto 0
  • EMPATE
  • Deportivo Cali 2
  • Santa Fe 2
15 Millonarios Millonarios 17 18 3 8 7 16 20
  • DERROTA
  • Millonarios 0
  • Envigado 1
  • EMPATE
  • Independiente Mede. 1
  • Millonarios 1
  • DERROTA
  • Millonarios 2
  • Deportivo Pereira 3
  • EMPATE
  • La Equidad 1
  • Millonarios 1
  • VICTORIA
  • Millonarios 3
  • América de Cali 1
16 Deportivo Pasto Deportivo Pasto 17 18 4 5 9 12 17
  • VICTORIA
  • Deportivo Pasto 1
  • Deportivo Cali 0
  • DERROTA
  • Real Cartagena 2
  • Deportivo Pasto 1
  • DERROTA
  • Deportivo Pasto 0
  • Boyacá Chicó 1
  • DERROTA
  • Santa Fe 1
  • Deportivo Pasto 0
  • VICTORIA
  • Deportivo Pasto 3
  • Envigado 0
17 At. Nacional At. Nacional 16 18 3 7 8 16 25
  • DERROTA
  • Real Cartagena 1
  • At. Nacional 0
  • EMPATE
  • Santa Fe 1
  • At. Nacional 1
  • EMPATE
  • At. Nacional 1
  • Envigado 1
  • VICTORIA
  • Independiente Mede. 1
  • At. Nacional 2
  • EMPATE
  • At. Nacional 1
  • Deportivo Pereira 1
18 Independiente Medellín Independiente 11 18 2 5 11 18 29
  • DERROTA
  • Deportes Tolima 1
  • Independiente Mede. 0
  • EMPATE
  • Independiente Mede. 1
  • Millonarios 1
  • DERROTA
  • Cúcuta Deportivo 1
  • Independiente Mede. 0
  • DERROTA
  • Independiente Mede. 1
  • At. Nacional 2
  • DERROTA
  • Once Caldas 1
  • Independiente Mede. 0
JUGADORES DESTACADOS

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.

TOP colaboradores para esta liga
Sebastian
Sebastian
62 pts
JOSE LUIS FLOREZ
JOSE LUIS FLOREZ
5 pts
camilo lazaro
camilo lazaro
3 pts
Más colaboradores en esta liga (9)
¿Quieres ser colaborador? haz click aquí

  USO DE MEMORIA  
6,236,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3092
Total Execution Time  0.3116
  CADENA URL  
/apertura_colombia2009
  GET DATOS  
$_GET['/apertura_colombia2009']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0112  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.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 03:51:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 03:51:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 03:51:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 03:51:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  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=1007 AND rel.round=18
0.0108  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 = 1007 AND esl.points > 0
0.0106  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-03-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 1007 ORDER BY creation_date DESC LIMIT 0, 10
0.0120  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-03-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 1007
0.0168  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 `calendars2009` 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` = 1007 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0149  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 events2009 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2009 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 1007 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 (50002,50003,50004,50005,50006,50007,50008,50009,50010) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0110  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 `events2009` e INNER JOIN calendars2009 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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 1007 ORDER BY total DESC LIMIT 40
0.0218  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 `tables2009` 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 = 1007 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2009` 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 = 1007 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107  SELECT distinct(shedule), round FROM `calendars2009` as c WHERE c.`league_id` = 1007 AND shedule >= '2009/05/01' AND shedule < '2009/06/01' ORDER BY shedule ASC
0.0106  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-04-26 00:00:00' AND c.`shedule` < '2024-04-30 23:59:59' AND l.id = 1007 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0109  SELECT data1, data2 FROM services_tags WHERE categoryId=42
0.0109  SELECT group_code, extraName from `leagues` WHERE categoryId=42 AND year=2009