4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica
						Colombia 2005

Copa Mustang I (Apertura)
-------------------------

Table:

 1.Atlético Nacional           18  10  6  2  36-20  36  Qualified
 2.Independiente Santa Fe      18   7  7  4  20-16  28  Qualified
 3.CD Independiente Medellín   18   8  3  7  22-23  27  Qualified
 4.Envigado FC                 18   7  6  5  33-24  27  Qualified
 5.Deportivo Cali              18   7  6  5  24-18  27  Qualified
 6.Atlético Huila              18   7  6  5  16-12  27  Qualified
 7.Deportes Tolima             18   6  9  3  21-14  27  Qualified
 8.Once Caldas                 18   6  8  4  21-17  26  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 9.Deportivo Pasto             18   6  8  4  22-21  26
10.Atlético Junior             18   7  4  7  26-23  25
11.Real Cartagena              18   7  3  8  18-20  24
12.América                     18   6  6  6  24-26  24
13.Boyacá Chicó FC             18   6  4  8  18-19  22  [*]
14.CD Millonarios              18   4  9  5  25-33  21
15.Atlético Bucaramanga        18   5  5  8  14-18  20
16.Unión Magdalena             18   4  4 10  11-22  16
17.Deportes Quindío            18   4  4 10  14-32  16
18.Deportes Pereira            18   2  8  8  15-22  14

[*] Chicó FC moved from Bogotá to Tunja and were renamed Boyacá Chicó FC

Round 1
[Feb 12]
Envigado    4-1 Millonarios
  [Óscar Restrepo 9, Luis Tejada 34, Orlando Ballesteros 66,
   Hermes Orejuela 81; Gabriel Fernández 1]
Cali        0-1 Medellín
  [César Valoyes 80]
[Feb 13]
Nacional    2-1 América
  [Hugo Morales 22, Víctor Aristizábal 55; Carlos Díaz 31og]
Tolima      1-1 Pasto
  [Gonzalo Martínez 46pen; David Quirós 71]
Santa Fe    3-1 Quindío 
  [Carlos Ortíz 9, Léider Preciado 52, 63; Marcos Cardozo 39pen]
Once Caldas 1-0 Cartagena 
  [Néstor Alvarez 73]
Chicó FC    1-0 Huila
  [Nilson Pérez 91]
[Feb 23]
Bucaramanga 0-1 Pereira 
  [Carlos Castillo 62]
[Mar 9]
Magdalena   1-0 Junior 
  [Carlos Vilarete 59]

Round 2
[Feb 16]
Huila       0-0 Tolima
Millonarios 2-2 Chicó
  [Ómar Andrés Rodríguez 40, Gabriel Fernández 51; Nilson Pérez 6,
   Watson Rentería 82]
Pereira     1-1 Envigado
  [Belmer Aguilar 81; Freddy Guarín 46]
Medellín    0-1 Bucaramanga
  [Oscar Londoño 56]
Cartagena   1-3 Nacional
  [Carlos Preciado 65; Edixon Pera 27, 85, Aquivaldo Mosquera 58]
Quindío     0-1 Once Caldas
  [Jefrey Díaz 19]
Pasto       1-1 Santa Fe
  [Oscar Martínez 83; Léider Preciado 77]
[Feb 23]
Junior      3-3 Cali
  [Martín Arzuaga 9, 85, Háider Palacios 75; Milton Rodríguez 13, 15,
   Jaminson Olave 29]
[Mar 23]
América     2-1 Magdalena
  [Jorge Banguero 29, Edinson Chará 84; Carlos Vilarete 48]

Round 3
[Feb 19]
Nacional    3-0 Quindío
  [Víctor Aristizábal 60, Héctor Hurtado 64, José Amaya 88]
[Feb 20]
Santa Fe    0-2 Tolima
  [Gonzalo Martínez 75, John Charria 92]
Magdalena   0-1 Cartagena
  [Carlos Preciado 75]
Bucaramanga 0-2 Junior
  [Juan Carlos Quintero 16pen, Lin Carlos Henry 67pen]
Envigado    3-3 Medellín
  [Orlando Ballesteros 49, 68, Óscar Restrepo 60; Diego Álvarez 21,
   César Valoyes 65, David Montoya 79]
Chicó FC    2-1 Pereira
  [Nilson Pérez 40, Anuar Guerrero 70; Diego Cortés 74]
Huila       1-1 Millonarios
  [Iván Trujillo 24; Omar Andrés Rodríguez 26]
[Apr 20]
Once Caldas 1-1 Pasto
  [Elkin Soto 70; Santiago Silvera 66]
América     0-0 Cali
 
Round 4
[Feb 26]
Santa Fe    1-0 Once Caldas
  [Léider Preciado 83]
[Feb 27]
Tolima      3-3 Millonarios
  [Jáider Arboleda 55, Víctor Bonilla 70, 79; Alejandro Benítez 60,
   Ómar Guerra 77, José Moreno 81]
Pereira     0-0 Huila
Junior      3-2 Envigado
  [Leonardo Rojano 41, Édgar Zapata 48, Juan Carlos Quintero 49;
   Orlando Ballesteros 27, Luis Tejada 64]
América     1-2 Bucaramanga
  [Rubén Bustos 93; Carlos Salazar 50, Luis Pérez 62pen]
Cartagena   0-1 Cali
  [César Hernández 81]
Quindío     2-0 Magdalena
  [René Mendieta 33, Hugo Rodallega 81]
Pasto       1-1 Nacional
  [Hugo Arrieta 50; Víctor Aristizábal 43]
[Mar 27]
Medellín    1-0 Chicó FC
  [Diego Alvarez 67]

Round 5
[Mar 2]
Nacional    1-1 Santa Fe
  [Edixon Perea 50; Carlos Ortíz 18]
Magdalena   2-0 Pasto
  [Luis Zuleta 9, Leonel Zúñiga 54]
Cali        3-0 Quindío
  [Ricardo Ciciliano 75, Milton Rodríguez 79pen, Blas Pérez 89]
Bucaramanga 0-1 Cartagena
  [Julián Barahona 51]
Envigado    1-1 América
  [Oscar Restrepo 71; Claudio Elias 80]
Huila       1-0 Medellín
  [Iván Trujillo 57pen]
Millonarios 3-2 Pereira
  [Iván René Valenciano 18, Luis Zapata 51, José Moreno 83;
   Ricardo Páez 62, Jorge Agudelo 64]
[Mar 9]
Once Caldas 1-2 Tolima
  [Dairo Moreno 59; Víctor Bonilla 8, Emir González 89]
[Apr 13]
Chicó FC    2-0 Junior
  [Anuar Guerrero 4, Diego Salazar 79]

Round 6
[Mar 5]
Medellín    2-1 Millonarios
  [Jaime Castrillón 26, Jackson Martínez 40; Gabriel Fernández 65]
[Mar 6]
Tolima      2-0 Pereira
  [Gonzalo Martínez 30, Oscar Briceño 83]
Junior      1-0 Huila
  [Juan Carlos Quintero 34]
América     1-1 Chicó FC
  [Leonardo Mina Polo 74; César Hernández 61]
Cartagena   0-1 Envigado
  [Orlando Ballesteros 72]
Quindío     2-1 Bucaramanga
  [Carlos Hidalgo 52, Hugo Rodallega 65; Luis Iriarte 93]
Pasto       1-0 Cali
  [Sergio Novoa 72]
Santa Fe    0-0 Magdalena
Once Caldas 1-2 Nacional
  [Jonathan Fabbro 87; Edixon Perea 27, Hugo Morales 56]

Round 7 
[Mar 12]
Cali        1-1 Santa Fe
  [Milton Rodríguez 43pen; Juan Carlos Ramírez 83]
[Mar 13]
Nacional    1-3 Tolima
  [Camilo Zúñiga 87; Víctor Bonilla 7, Yulián Anchico 84,
   Oscar Passo 93]
Magdalena   1-1 Once Caldas
  [Orlando Fuentes 47; Alexis Henriquez 93]
Bucaramanga 2-0 Pasto
  [Armando Carrillo 61, 84]
Envigado    3-0 Quindío
  [Orlando Ballesteros 8, 53, Oscar Restrepo 32]
Chicó FC    1-2 Cartagena
  [Evert Palacios 85; Leonardo Enciso 26, Jefferson Torres 44]
Huila       3-0 América
  [Marcio Cruz 4, Nelson Gómez 49, Mauricio Giraldo 89]
Millonarios 0-0 Junior
Pereira     3-0 Medellín
  [Cesar Martínez 6, Orlando Rodríguez 15, Elkin Bedoya 80]

Round 8
[Mar 15]
Santa Fe    0-0 Bucaramanga
[Mar 16]
Tolima      0-0 Medellín
América     1-1 Millonarios
  [David Ferreira 81; Omar Rodríguez 60]
Cartagena   1-1 Huila
  [Nicolás Tagliani 80; Mauricio Giraldo 87]
Quindío     1-0 Chicó
  [Iván Vélez 82]
Pasto       2-1 Envigado
  [Sergio Novoa 28, Oscar Darío Martínez 69; Luis Tejada 5]
Once Caldas 1-1 Cali
  [Néstor Alvarez 69; Milton Rodríguez 88]
Nacional    2-0 Magdalena
  [Víctor Aristizábal 60, Edixon Perea 83]
[Apr 27]
Junior      2-0 Pereira
  [Omar Sebastián Pérez 22, 29]

Round 9
[Mar 19]
Millonarios 0-3 Santa Fe
  [Léider Preciado 37, Víctor Cortés 54, 70]
[Mar 20]
Pereira     2-2 Once Caldas
  [Ricardo Páez 31, César Martínez 72; Dayro Moreno 70, Herly Alcázar 79]
Medellín    0-4 Nacional
  [Edixon Perea 66, Víctor Aristizábal 84, 87, Camilo Zúñiga 90]
Junior      0-1 Magdalena
  [Carlos Vilarete 85]
Cali        2-0 América
  [Ricardo Ciciliano 18, Milton Rodríguez 64]
Cartagena   1-0 Bucaramanga
  [Manuel Galarcio 39]
Quindío     1-4 Envigado
  [Iván Vélez 34; Orlando Ballesteros 31, Luis Tejada 41, Oscar Restrepo 67,
   Hermes Orejuela 87]
Pasto       1-0 Chicó
  [Santiago Silvera 36]
Tolima      1-2 Huila
  [Célimo Polo 53; Hilario Cuenú 24og, Fabián Cuellar 52]

Round 10
[Apr 2]
Cali        3-3 Nacional
  [Milton Rodríguez 27, 48pen, Alvaro Domínguez 36;
   Edixon Perea 34, 59, 65]
Envigado    2-1 Santa Fe
  [Orlando Ballesteros 29, Oscar Restrepo 55pen; Víctor Cortés 51]
[Apr 3]
Magdalena   0-0 Tolima
Bucaramanga 1-1 Once Caldas
  [Oscar Londoño 34; Julián Díaz 63]
Chicó       3-4 Pasto
  [Anuar Guerrero 20, Watson Rentería 16, 34; Santiago Silvera 16, 65,
   Diego Valdés 61, Oscar Martínez 64]
Huila       2-0 Quindío
Millonarios 2-1 Cartagena
  [José Moreno 17pen, Gabriel Fernández 29; Nicolás Tagliani 10]
Pereira     1-2 América
  [Ricardo Páez 20; Néstor Salazar 58, 62]
Medellín    1-0 Junior
  [Diego Alvarez 67]
 
Round 11
[Mar 31]
Tolima      1-1 Junior
  [Víctor Bonilla 41; Emerson Acuña 64]
[Apr 6]
Quindío     3-3 Millonarios
  [Hugo Rodallega 16, 36pen, 85; José Moreno 29, 42pen,
   Facundo Argüello 91]
Pasto       3-1 Huila
  [Luis Eduardo Lora 4, Diego Valdés 7pen, 58; Iván Trujillo 19]
Santa Fe    1-0 Chicó
  [Juan Carlos Ramírez 26]
Once Caldas 2-2 Envigado
  [Dairo Moreno 47, Tressor Moreno 83; Luis Tejada 37, 63]
Nacional    3-2 Bucaramanga
  [Víctor Hugo Aristizábal 44, 47pen, 72; Armando Carrillo 12,
   Wbeimar Olivares 63]
Magdalena   2-0 Cali
  [Luis Zuleta 61, Carlos Vilarete 82]
América     3-2 Medellín
  [Jorge Banguero 2, 82, Leonardo Mina Polo 34; Diego Alvarez 32,
   Jackson Martínez 49]
Cartagena   1-1 Pereira
   [Manuel Galarcio 92; César Martínez 20]

Round 12
[Apr 9]
Envigado    2-4 Nacional
  [Óscar Restrepo 34, Luis Tejada 66; Edixon Perea 18, 57,
   Víctor Aristizábal 31, 40]
[Apr 10]
Cali        1-2 Tolima
  [Blas Pérez 1; Oscar Briceño 47, Jaider Arboleda 91]
Bucaramanga 2-1 Magdalena
  [Henry Hernández 34, Alex Orrego 55; Pablo Quandt 36]
Junior      5-3 América
  [Háider Palacio 10, Juan Carlos Quintero 32, Rodrigo Teixeira 58, 70,
   Martín Arzuaga 80; Giovanni Arrechea 8, 36, Edigson Chará 14]
Chicó       1-1 Once Caldas
  [Diego Salazar 85; Javier Araújo 76]
Huila       0-0 Santa Fe
Millonarios 2-2 Pasto
  [José Moreno 4, Facundo Argüello 77; Santiago Silvera 18,
   Sergio Novoa 50]
Pereira     1-1 Quindío
  [Jorge Agudelo 32; Hugo Rodallega 84]
Medellín    2-1 Cartagena
  [Diego Alvarez 21, 92; Carmelo Valencia 83]
 
Round 13
[Apr 16]
Nacional    2-0 Chicó
  [Hugo morales 60, Víctor Aristizábal 7]
[Apr 17]
Tolima      0-0 América
Cartagena   3-1 Junior
  [Manuel Galarcio 3, Leonardo Enciso 30, Carlos Preciado 92;
   Evert Salas 14]
Quindío     0-0 Medellín
Santa Fe    0-1 Millonarios
  [Gabriel Fernández 31]
Once Caldas 1-0 Huila
  [Elkin Soto 43]
Pasto       0-0 Pereira
Magdalena   1-3 Envigado
  [Carlos Vilarete 32; Johnatan Estrada 25, Orlando Ballesteros 40,
   Andrés Casañas 89]
Cali        2-0 Bucaramanga
  [Jámison Olave 4, César González 25]
 
Round 14
[Apr 23]
Millonarios 0-3 Once Caldas
  [Tressor Moreno 23, Elkin Soto 49, Javier Araujo 59]
América     2-1 Cartagena
  [David Ferreira 20, Andrés González 76; Leonardo Enciso 13]
[Apr 24]
Bucaramanga 0-0 Tolima
Envigado    0-0 Cali
Chicó       1-0 Magdalena
  [Wilmides Cotes 85]
Huila       0-0 Nacional
Pereira     0-1 Santa Fe
  [Luis Yanes 71]
Medellín    2-1 Pasto
  [Diego Alvarez 63, César Valoyes 80; Juan Fernando Rebolledo 82]
Junior      3-1 Quindío
  [Lin Carlos Henry 7, Omar Pérez 20, Rodrigo Texeira 50; Hugo Rodallega 41]
 
Round 15
[Apr 30]
Santa Fe    2-1 Medellín
  [Víctor Cortés 7, 90; David Montoya 64]
[May 1]
Tolima      1-2 Cartagena
  [Víctor Bonilla 70; Luis Omar Valencia 63, Eder Hernández 80]
Quindío     1-0 América
  [Iván Vélez 13]
Pasto       2-1 Junior
  [Sergio Novoa 53, Einer Viveros 68; Leonardo Rojano 76]
Once Caldas 1-0 Pereira
  [Elkin Soto 80]
Nacional    1-1 Millonarios
  [Humberto Mendoza 1; Rafael Robayo 81]
Magdalena   0-1 Huila
  [Duván Hernández 48]
Cali        1-0 Chicó
  [Álvaro Domínguez 87]
Bucaramanga 0-0 Envigado

Round 16 [May 7]
Envigado    2-0 Tolima
  [Sergio Guzmán 57, Orlando Ballesteros 81]
Chicó       2-0 Bucaramanga
  [Wason Libardo Rentería 18, 82]
Huila       2-0 Cali
  [Breiner Belalcazar 60, Fabián Cuellar 86]
Millonarios 1-0 Magdalena
  [José Moreno 92]
Pereira     1-1 Nacional
  [Ricardo Álvarez 45; Camilo Pérez 15]
Medellín    1-0 Once Caldas
  [Jair Benítez 66pen]
Junior      1-1 Santa Fe
  [Haider Palacio 39; Luis Yánez 51]
América     1-0 Pasto
  [Jerson González 18]
Cartagena   1-0 Quindío
  [Eder Hernández 91]

Round 17 [May 11]
Tolima      3-0 Quindío
  [Oscar Briceño 45, Víctor Bonilla 47, 67]
Pasto       1-1 Cartagena
  [Santiago Silvera 61; Carmelo Valencia 32]
Santa Fe    2-5 América
  [Mario Gómez 5, Mario González 51; Juan Quiñónez 4,
   Julián Viáfara 32pen, Yovany Arrechea 43, 58pen, Néstor Salazar 52]
Once Caldas 2-1 Junior
  [Dairo Moreno 15, 68; Martín Arzuaga 78]
Nacional    3-1 Medellín
  [Hugo Morales 4, Edixon Perea 6, Víctor Aristizábal 60;
   Carlos Rivera 45]
Magdalena   1-1 Pereira
  [Carlos Vilarete 40pen; Orlando Rodríguez 7]
Cali        4-2 Millonarios
  [Blas Pérez 8, Milton Rodríguez 73, 91, Freddy Hurtado 92;
   Gabriel Fernández 13, 43]
Bucaramanga 2-0 Huila
  [Hernán Sarmiento 50, Oscar Londoño 61]
Envigado    1-2 Chicó
  [Jonathan Estrada 41; Wason Rentería 70, 87]

Round 18 [May 15]
Chicó       0-0 Tolima
Huila       2-1 Envigado
  [Iván Trujillo 37, Wilmer Saldaña 90; Óscar Restrepo 83]
Millonarios 1-1 Bucaramanga
  [Gabriel Fernández 93; Henry Hernández 79]
Pereira     0-2 Cali
  [Milton Rodríguez 83pen, 85]
Medellín    5-0 Magdalena
  [Jackson Martínez 9, Camilo Giraldo 43, Jorge Serna 46,
   Mauricio Molina 64, Jaime Castrillón 67]
América     1-1 Once Caldas
  [Jerson González 40; Tressor Moreno 42]
Junior      2-0 Nacional
  [Rodrigo Teixeira 76, Jamerson Rentería 85]
Cartagena   0-2 Santa Fe
  [Víctor Cortés 19, Léider Preciado 78]
Quindío     1-1 Pasto
  [Carlos Hidalgo 19; Hugo Arrieta 75pen]

Table:

 1.Atlético Nacional           18  10  6  2  36-20  36  Qualified
 2.Independiente Santa Fe      18   7  7  4  20-16  28  Qualified
 3.CD Independiente Medellín   18   8  3  7  22-23  27  Qualified
 4.Envigado FC                 18   7  6  5  33-24  27  Qualified
 5.Deportivo Cali              18   7  6  5  24-18  27  Qualified
 6.Atlético Huila              18   7  6  5  16-12  27  Qualified
 7.Deportes Tolima             18   6  9  3  21-14  27  Qualified
 8.Once Caldas                 18   6  8  4  21-17  26  Qualified
 - - - - - - - - - - - - - - - - - - - - - - - - - - -
 9.Deportivo Pasto             18   6  8  4  22-21  26
10.Atlético Junior             18   7  4  7  26-23  25
11.Real Cartagena              18   7  3  8  18-20  24
12.América                     18   6  6  6  24-26  24
13.Boyacá Chicó FC             18   6  4  8  18-19  22  [*]
14.CD Millonarios              18   4  9  5  25-33  21
15.Atlético Bucaramanga        18   5  5  8  14-18  20
16.Unión Magdalena             18   4  4 10  11-22  16
17.Deportes Quindío            18   4  4 10  14-32  16
18.Deportes Pereira            18   2  8  8  15-22  14

[*] Chicó FC moved from Bogotá to Tunja and were renamed Boyacá Chicó FC

NB: top-8 after 18 rounds qualify for Cuadrangulares

Cuadrangulares

Tables:

Grupo A
 1.Atlético Nacional            6   4  2  0  11- 5  14  Qualified
 2.Deportes Tolima              6   4  1  1  13- 9  13
 3.CD Independiente Medellín    6   2  0  4  11-15   6
 4.Deportivo Cali               6   0  1  5   6-12   1

Grupo B
 1.Independiente Santa Fe       6   4  0  2   8- 5  12  Qualified
 2.Envigado FC                  6   3  2  1   9- 6  11
 3.Atlético Huila               6   1  3  2  10-12   6
 4.Once Caldas                  6   0  3  3   6-10   3

Round 1 [May 18]
Nacional    0-0 Cali
Tolima      3-1 Medellín
  [Víctor Bonilla 31, 71pen, John Charria 52; Ricardo Steer 85]
Santa Fe    4-2 Huila
  [Leider Preciado 10, 50, Carlos Ortiz 45, Nelson Flórez 85;
   Iván Trujillo 26, Marcio Cruz 58]
Envigado    2-1 Once Caldas
  [Orlando Ballesteros 52, Oscar Restrepo 87; Jáminson Hurtado 71]
 
Round 2 [May 22]
Cali        0-1 Tolima
  [Juan Carlos Escobar 50]
Medellín    1-2 Nacional
  [Jackson Martínez 31; Víctor Aristizábal 38pen, Edixon Perea 93]
Huila       2-2 Envigado
  [Cristian Rodríguez 60, Lionard Pajoy 71; Oscar Restrepo 33,
   Luis Tejada 87]
Once Caldas 0-1 Santa Fe
  [Léider Preciado 4]

Round 3
[May 25]
Cali        1-2 Medellín
  [Giovanni García 63; Mauricio Molina 38, Jaime Castrillón 87]
Huila       2-2 Once Caldas
  [Arrechea 25, Iván Trujillo 70; Herly Alcázar 6, 65]
Santa Fe    0-2 Envigado
  [Orlando Ballesteros 70, 79]
[May 26]
Nacional    4-1 Tolima
  [Víctor Aristizábal 48, Hugo Morales 52, Humberto Mendoza 61,
   Edixon Perea 87; Juan Carlos Escobar 24]

Round 4
[Jun 11]
Envigado    0-1 Santa Fe
  [Luis Yáñez 85]
[Jun 12]
Medellín    4-3 Cali
  [Diego Álvarez 38, César Baloyes 46, Mauricio Molina 70, 84pen;
   Milton Rodríguez 5, Ricardo Ciciliano 58, Edwin Carrillo 65]
Tolima      1-1 Nacional
  [Víctor Bonilla 77; Edixon Perea 24]
Once Caldas 2-2 Huila
  [Duván Hernández 28og, Herly Alcázar 82; Cristian González 52,
   Leonard Pajoy 63]

Round 5 [Jun 15]
Tolima      3-1 Cali
  [Oscar Briceño 13, 69, Víctor Bonilla 65; Milton Rodríguez 43]
Nacional    2-1 Medellín
  [Héctor Hurtado 8, Víctor Aristizábal 27; Mauricio Molina 10]
Envigado    2-1 Huila
  [Oscar Restrepo 18, 66; Wílmer Saldaña 56]
Santa Fe    2-0 Once Caldas
  [Léider Preciado 9, Carlos Ortiz 85]

Round 6 [Jun 19]
Cali        1-2 Nacional
  [Ricardo Siciliano 11; Oscar Echeverri 33, 82]
Medellín    2-4 Tolima
  [Diego Alvarez 24, 56; Víctor Bonilla 2, 59, Oscar Passo 67,
   Jaider Arboleda 73]
Huila       1-0 Santa Fe
  [Nélson Gómez 68]
Once Caldas 1-1 Envigado
  [Julián Díaz 69; Sergio Guzmán 91]

Tables:

Grupo A
 1.Atlético Nacional            6   4  2  0  11- 5  14  Qualified
 2.Deportes Tolima              6   4  1  1  13- 9  13
 3.CD Independiente Medellín    6   2  0  4  11-15   6
 4.Deportivo Cali               6   0  1  5   6-12   1

Grupo B
 1.Independiente Santa Fe       6   4  0  2   8- 5  12  Qualified
 2.Envigado FC                  6   3  2  1   9- 6  11
 3.Atlético Huila               6   1  3  2  10-12   6
 4.Once Caldas                  6   0  3  3   6-10   3

Finalísima

First Leg [Jun 22]
Santa Fe    0-0 Nacional

Second Leg [Jun 26]
Nacional    2-0 Santa Fe
  [Carlos Díaz 80, Oscar Echeverry 82]

Atlético Nacional are Apertura 2005 champions.



Authors: Frank Ballesteros (fballesteros@colombia.com) and Juan Pablo Andrés (jpandres@tutopia.com) 
Last updated: 1 Feb 2006

(C) Copyright Frank Ballesteros, Juan Pablo Andrés and RSSSF 2005/06
You are free to copy this document in whole or part provided that proper acknowledgement is given to the authors. All rights reserved.						

INFORMACIÓN

La Categoría Primera B, llamado oficialmente Torneo Postobón por motivos comerciales, es el torneo de segunda división de la División Mayor del Fútbol Colombiano (Dimayor), entidad dependiente de la Federación Colombiana de Fútbol. El torneo es de carácter profesional, comenzó a disputarse en 1991 y el primer torneo fue ganado por el Envigado Fútbol Club.

  USO DE MEMORIA  
4,344,128 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1084
Total Execution Time  0.1103
  CADENA URL  
/apertura_primera_b_colombia2005
  GET DATOS  
$_GET['/apertura_primera_b_colombia2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia2005'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 196 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1280990,1223665,1162446,1152331,1076557) ORDER BY n.cover_points DESC, update_date DESC
0.0025  SELECT text_es as historical_text FROM leagues_text WHERE id=5373
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 = 33848 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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=196 ORDER BY l.group_code ASC
0.0019  SELECT type,rule FROM rules WHERE categoryId = 196 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 12:21:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 12:21:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 12:21:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 12:21:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_primera_b_colombia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2005 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33848) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33848) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0022  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33848) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0022  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33848) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33848) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33848) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33848) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0021  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (33848) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33848 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33848 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 196 GROUP BY l.categoryId
0.0018  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=196 GROUP BY l.year ORDER BY l.year DESC
0.0027  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=33848 AND rel.round=18
0.0020  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 = 33848 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 33848 AND esl.points > 0
0.0019  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-25" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33848 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-03-25" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33848
0.0019  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 `calendars2005` 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` = 33848 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events2005` e INNER JOIN calendars2005 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 = 33848 ORDER BY total DESC LIMIT 40
0.0020  SELECT 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 `events2005` e INNER JOIN calendars2005 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.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 33848 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables2005` 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 = 33848 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2005` 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 = 33848 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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-24 00:00:00' AND c.`shedule` < '2024-04-28 23:59:59' AND l.id = 33848 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=196
0.0023  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 196 AND l.year = 2005 ORDER BY l.group_code ASC
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=196 AND year=2005