4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Clausura Primera B Colombia 2005
2004/2005

Clausura Primera B Colombia 2005

  • Primera B
Información Histórica
						Colombia 2005

Copa Mustang II (Clausura)
--------------------------

Table:

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

Round 1 [Jul 10]
Pasto       2-1 Tolima
  [Sergio Novoa 28, Carmelo Valencia 86; Leonardo Mina Polo 40]
Quindío     0-0 Santa Fe
Cartagena   3-0 Once Caldas
  [Luis Omar Valencia 23, Jamerson Rentería 60, 74]
América     1-0 Nacional
  [José Moreno 78]
Junior      2-1 Magdalena
  [Emerson Acuña 4, Santiago Silvera 50; Luis Fernández 92]
Medellín    0-1 Cali
  [Hernando Patiño 42]
Pereira     1-0 Bucaramanga
  [Gerson González 45]
Millonarios 2-1 Envigado
  [Gabriel Fernández 54, Wilson Carpintero 87; Cristian González 4]
Huila       3-0 Chicó FC
  [David Quiróz 33, Jorge Díaz 60, Nelson Gómez 91]

Round 2 
[Jul 16]
Cali        4-1 Junior
  [Alvaro Domínguez 2, Habyson Escobar 58, 62, Ricardo Ciciliano 87;
   Emerson Acuña 11]
[Jul 17]
Tolima      2-0 Huila
  [Belmer Aguilar 34, Leonardo Mina Polo 60]
Chicó FC    0-2 Millonarios
  [Gabriel Héctor Fernández 38, Martín García 85]
Envigado    2-1 Pereira
  [Oscar Restrepo 1, Hermes Orejuela 65; Hernán Cardona 92]
Bucaramanga 4-0 Medellín
  [Edward Jiménez 38, 75, Vicente Preciado 55,Julián Téllez 90]
Magdalena   1-3 América
  [Erwin Carrillo 16; Óscar Villareal 10, Giovanni Arrechea 77,
   Rubén Bustos 83]
Nacional    1-1 Cartagena
  [Víctor Aristizábal 92pen; Jamerson Rentería 70]
Once Caldas 1-0 Quindío
  [Rubén Darío Velásquez 28]
Santa Fe    2-0 Pasto
  [Víctor Cortés 18, Luis Yáñez 47]

Round 3
[Jul 23]
Millonarios 2-0 Huila
  [Martín García 59, Gabriel Fernández 68]
[Jul 24]
Tolima      2-1 Santa Fe
  [Leonardo Mina Polo 3, Bélmer Aguilar 76; Léider Preciado 43]
Pasto       0-0 Once Caldas
Quindío     1-1 Nacional
  [John Valencia 61; Víctor Aristizábal 53]
Cartagena   2-1 Magdalena
  [Jamerson Rentería 63, Pedro Ortega 74; Oswaldo Mackenzie 50]
Junior      0-0 Bucaramanga
Medellín    1-1 Envigado
  [Jackson Martínez 62; Oscar Restrepo 35pen]
Pereira     2-0 Chicó FC
  [Néstor Salazar 10, Carlos Salazar 92]
[Jul 27]
América     2-0 Cali
  [Jorge Banguero 38, José Moreno 75]

Round 4
[Jul 30]
Once Caldas 0-0 Santa Fe
[Jul 31]
Millonarios 2-0 Tolima
  [Wilson Carpintero 58, 87]
Envigado    3-0 Junior
  [Orlando Ballesteros 67, Camilo Giraldo 71, Sergio Guzmán 87]
Chicó       2-1 Medellín
  [Anuar Guerrero 10, Wason Rentería 45; Diego Alvarez 29] 
Bucaramanga 0-2 América
  [Harrison Otálvaro 17, José Moreno 88]
Cali        2-2 Cartagena
  [Hugo Rodallega 11, 87; Jamerson Rentería 66, Frank Pacheco 71]
Magdalena   0-1 Quindío
  [Carlos Hidalgo 90]
Nacional    1-0 Pasto
  [Luciano Vera 8]
Huila       1-2 Pereira
  [Mauricio Giraldo 87; Néstor Salazar 69, Jorge López Caballero 89]

Round 5 [Aug 3]
Tolima      3-1 Once Caldas
  [Víctor Bonilla 8, Óscar Briceño 26, Haider Arboleda 92;
   Arnulfo Valentierra 85]
Santa Fe    1-2 Nacional
  [Léider Preciado 83; Víctor Aristizábal 54, Leonardo Fabio Moreno 91]
Pasto       1-1 Magdalena
  [Fabián Arregocés 67og; Fabián Arregocés 87]
Quindío     1-1 Cali
  [Ómar Santacruz 70; Ricardo Ciciliano 72]
Cartagena   3-0 Bucaramanga
  [Luis Ómar Valencia 1, Carlos Preciado 37, Jámerson Rentería 49] 
América     1-0 Envigado
  [Giovanni Arrechea 54]
Junior      2-1 Chicó
  [Matías Espíndola 9og, Rafael Barraza 38; Gustavo Quijano 68]
Medellín    4-1 Huila
  [Sebastián Botero 20, Diego Álvarez 42, 63, Lewis Ochoa 85;
   Jair Arrechea 72]
Pereira     0-2 Millonarios
  [Martín García 40, Ricardo Pérez 45]
 
Round 6
[Aug 6]
Millonarios 1-0 Medellín
  [Ricardo Pérez 82]
[Aug 7]
Pereira     2-0 Tolima
  [Harnold Palacio 23, Carlos Salazar 78]
Huila       1-2 Junior
  [Wílmer Saldaña 44; Martín Arzuaga 46, Rafael Barrasa 55]
Chicó       1-0 América
  [Diego Salazar 89]
Envigado    1-1 Cartagena
  [Cristian González 4; Juan Domínguez 15]
Bucaramanga 2-0 Quindío
  [Felipe Rivas 4, Edwards Jiménez 16]
Cali        2-2 Pasto
  [Harold Herrera 70, Hugo Rodallega 88; Javier Araújo 16,
   Iván Restrepo 20]
Magdalena   1-1 Santa Fe
  [Oswaldo Mackenzie 39pen; Luis Yánes 59]
Nacional    2-1 Once Caldas
  [Aldo Ramírez 70, Óscar Echeverry 81; Elkin Soto 38]

Round 7
[Aug 13]
Tolima      1-1 Nacional
  [Emir González 34; Gerardo Bedoya 6]
[Aug 14]
Once Caldas 4-0 Magdalena
  [Dayro Moreno 2, Andrés Casañas 57, Ismael Espiga 79, 81]
Santa Fe    1-3 Cali
  [Luis Yánez 71; Ricardo Ciciliano 28pen, Breiner Belalcázar 46,
   Habynson Escobar 91]
Pasto       1-0 Bucaramanga
  [Jorge Agudelo 66]
Quindío     2-0 Envigado
  [Omar Santacruz 24, Carlos Hidalgo 26]
Cartagena   2-1 Chicó
  [Jamerson Rentería 18, Luis Omar Valencia 72; Anuar Guerrero 86]
América     2-1 Huila
  [Giovanni Arrechea 38, Jorge Banguero 84; Jorge Díaz 54pen]
Junior      4-3 Millonarios
  [Edgar Zapata 14, 17, Martín Arzuaga 56, Freddy Arrieta 84;
   Gabriel Fernández 30, 35, Jaime Bustamante 40]
Medellín    2-0 Pereira
  [Jaime Castrillón 40, 68]

Round 8
[Aug 20]
Cali        3-0 Once Caldas
  [Hugo Rodallega 26, 61, Blas Pérez 86]
[Aug 21]
Medellín    0-2 Tolima
  [Leonardo Mina Polo 46, 50]
Pereira     2-1 Junior
  [Néstor Salazar 50, Hernán Cardona 83; Martín Arzuaga 54]
Huila       2-2 Cartagena
  [Jorge Díaz 70, Léiner Gómez 75; Frank Pacheco 6,
   Ever Hernández 56]
Chicó       0-2 Quindío
  [Omar Santacruz 34, Carlos Gutiérrez 40]
Bucaramanga 3-0 Santa Fe
  [Emerson Chamorro 10, Jeferson Alvarez 15, Edwards Jiménez 84]
Magdalena   2-2 Nacional
  [José Betancurt 43, Rubiel Quintana 77; Héctor Hurtado 10,
   Marcelo Ramos 30]
Millonarios 0-1 América
  [Oscar Villareal 64]
Envigado    2-0 Pasto
  [Luis Moreno 35, Hermes Orejuela 62]

Round 9 [Aug 28]
Chicó       0-2 Pasto
  [Carmelo Valencia 9, 91]
Once Caldas 3-3 Pereira
  [Ismael Espiga 15, Dairo Moreno 16, Mauricio Casierra 71;
   Hernán Darío Cardona 59, Jersson González 69, Hugo Sánchez 79]
Santa Fe    1-0 Millonarios
  [Francisco Nájera 33]
Nacional    3-2 Medellín
  [Gerardo Bedoya 38, Víctor Aristizábal 66, Luciano Vera 70;
   Roberto Carlos Cortés 45, John Valencia 90]
Magdalena   1-2 Junior
  [Jefrey Díaz 37; Haider Palacios 34pen, Martín Arzuaga 47]
Bucaramanga 2-1 Cartagena
  [Felipe Rivas 25, 31; Luis Caldas 47]
Cali        1-2 América
  [Hugo Rodallega 74; José Moreno 16, 25]
Envigado    2-1 Quindío
  [Anderson Da Silva 54, Johny Ramírez 74; Iván Vélez 60]
Huila       2-1 Tolima
  [Jorge Díaz 16, 60; Leonardo Mina Polo 7]

Round 10
[Sep 10]
América     0-1 Pereira
  [Néstor Salazar 39]
 [Sep 11]
Tolima      1-1 Magdalena
  [Yulián Anchico 58; Orlando Fuentes 39pen]
Nacional    5-0 Cali
  [Víctor Aristizábal 8, 11, 43, 63, Gerardo Bedoya 32] Once Caldas 0-0 Bucaramanga
Santa Fe    0-0 Envigado
Pasto       1-1 Chicó
  [Sergio Novoa 87; Anuar Guerrero 17]
Quindío     0-1 Huila
  [Jorge Díaz 59]
Cartagena   3-1 Millonarios
  [Luis Omar Valencia 40, Jamerson Rentería 57, Carlos Preciado 71;
   Gabriel Fernández 44pen]
Junior      2-3 Medellín
  [Haider Palacio 61, 93; Roberto Carlos Cortés 39,
   Jaime Castrillón 70, 90]

Round 11
[Sep 17]
Bucaramanga 2-1 Nacional
  [Sherman Cardenas 7, Alex Orrego 84; Juan Carlos Mosquera 44] 
[Sep 18]
Junior      1-0 Tolima
  [Emerson Acuña 9]
Medellín    3-1 América
  [Juan Pablo Pino 25, Diego Alvarez 75, César Valoyes 84;
   Fabián Estay 30]
Pereira     1-0 Cartagena
  [Carlos Salazar 18]
Millonarios 1-0 Quindío
  [Sebastián Hernández 16]
Huila       0-4 Pasto
  [Carmelo Valencia 13, Diego Valdéz 51, Jorge Agudelo 54,
   Sergio Novoa 82]
Chicó       0-1 Santa Fe
  [Daniel Gamarra 73]
Envigado    1-2 Once Caldas
  [Jonathan Estrada 56; Ismael Espiga 5, Gamadiel García 68]
Cali        4-2 Magdalena
  [Hugo Rodallega 21, Blas Pérez 51, Giovanni García 59,
   Harold Herrera 91; Erwin Carrillo 23, Pablo Quandt 54]

Round 12
[Sep 24]
Cartagena   1-3 Medellín
  [Carlos Castillo 77; Juan Pablo Pino 45, Jaime Castrillón 64,
   Roberto Carlos Cortés 71]
[Sep 25]
Tolima      2-0 Cali
  [Víctor Bonilla 31, Bélmer Aguilar 57]
Magdalena   0-2 Bucaramanga
  [Edwards Jiménez 30, Alexis González 60]
Nacional    1-0 Envigado
  [Gerardo Bedoya 55]
Once Caldas 2-1 Chicó
  [Dairo Moreno 12, Gamadiel García 81; Helmer Caviche 5]
Santa Fe    1-0 Huila
  [Mario Alejandro Benítez 33]
Pasto       1-0 Millonarios
  [Sergio Novoa 22]
Quindío     3-2 Pereira
  [Jorge Parra 5, Carlos Hidalgo 51, Marcos Cardoso 58;
   Néstor Salazar 32, Hugo Sánchez 78]
América     4-1 Junior
  [José Moreno 38pen, 42, Adrián Ramos 39, 74; Javier Flórez 27]

Round 13
[Oct 1]
Millonarios 1-3 Santa Fe
  [Harry Castillo 92; Luis Yánez 42, Jairo Suárez 47,
   Nelson Oliveira 87pen]
[Oct 2]
Junior      0-0 Cartagena
Bucaramanga 1-1 Cali
  [Edwards Jiménez 23, Blas Pérez 10]
América     0-2 Tolima
  [Mayer Candelo 23, Víctor Bonilla 29]
Medellín    4-0 Quindío
  [Diego Álvarez 8, 26, 33, Rodrigo Riep 69]
Pereira     5-3 Pasto
  [Jorge López 1, Jersson González 45, 61, Néstor Salazar 50,
   Rafael Castillo 71; Mauricio Dinamarca 15, Jorge Agudelo 22,
   Carmelo Valencia 32]
Huila       3-3 Once Caldas
  [Freddy Torres 31, Jorge Díaz 56pen, Wilmer Saldaña 77;
   Elkin Soto 7, Dayro Moreno 23pen, Ismael Espiga 43]
Chicó       0-0 Nacional
Envigado    2-1 Magdalena
  [Orlando Ballesteros 4, Cristian González 73;
   Luis Fernández 82]

Round 14
[Oct 15]
Cartagena   2-1 América
  [Jamerson Rentería 74, Carlos Castillo 75; Duvier Riascos 59]
[Oct 16]
Tolima      1-0 Bucaramanga
  [Víctor Bonilla 73]
Cali        1-1 Envigado
  [Blas Pérez 18; Orlando Ballesteros 89]
Magdalena   2-2 Chicó
  [Orlando Fuentes 18pen, Luis Zuleta 38pen; John Mario Ramírez 15,
   Evert Palacio 72]
Nacional    1-2 Huila
  [Humberto Mendoza 87; Jorge Díaz 31, Carlos Álvarez 61]
Once Caldas 2-1 Millonarios
  [Miguel Rojas 38, Arnulfo Valentierra 89; Harry Castillo 46]
Santa Fe    4-2 Pereira
  [Mario Benítez 12, 50, Nelson Olveira 23, Daniel Gamarra 45;
   Rafael Castillo 56, 87]
Pasto       0-1 Medellín
  [Rodrigo Riep 69]
Quindío     3-1 Junior
  [Marcio Cruz 7, Jhon Valencia 49, Carlos Hidalgo 83;
   Santiago Silvera 10]

Round 15 [Oct 19]
Cartagena   2-1 Tolima
  [Pedro Ortega 50, Jámerson Rentería 80; Dúmar Rueda 69]
América     2-2 Quindío
  [Jairo Castillo 61, Óscar Villarreal 73; Jorge Parra 89,
   Carlos Gutiérrez 93pen]
Junior      1-0 Pasto
  [Haider Palacio 87]
Huila       0-0 Magdalena
Medellín    1-0 Santa Fe
  [Sebastián Riep 67]
Pereira     0-2 Once Caldas
  [Ismael Espiga 51, Dairo Moreno 87]
Millonarios 0-0 Nacional
Chicó       0-0 Cali
Envigado    2-2 Bucaramanga
  [Gustavo Dávila 39, Néstor Álvarez 71; Émerson Chamorro 2,
   Henry Hernández 85]

Round 16
[Oct 22]
Santa Fe    1-0 Junior
  [Luis Yánez 57]
[Oct 23]
Tolima      4-1 Envigado
  [Emir González 49, Leonardo Mina Polo 58, Víctor Bonilla 65, 92;
   Néstor Álvarez 77]
Bucaramanga 1-1 Chicó
  [John Rivas 93; Adelmo Vallecilla 83]
Cali        2-0 Huila
  [Alvaro Domínguez 47, Hugo Rodallega 69pen]
Magdalena   1-1 Millonarios
  [Luis Zuleta 50; Harry Castillo 7]
Nacional    0-0 Pereira
Once Caldas 3-0 Medellín
  [Arnulfo Valentierra 28, Juan David Restrepo 87, 90]
Pasto       2-0 América
  [Jorge Agudelo 43, 65]
Quindío     1-0 Cartagena
  [Efraín Cortés 57]

Round 17
[Oct 29]
América     2-2 Santa Fe
  [Ruben Bustos 3, Harrison Otalvaro 13; David Montoya 52,
   Daniel Gamarra 59]
[Oct 30]
Chicó       1-0 Envigado
  [Pedro Pino 35og]
Huila       0-3 Bucaramanga
  [Alex Orrego 24, Sherman Cárdenas 66, Felípe Rivas 86]
Junior      1-0 Once Caldas
  [Deibis Varone 90]
Medellín    1-1 Nacional
  [Heriberto Velandia 70; Víctor Aristizábal 61] 
Millonarios 1-2 Cali
  [Wilson Carpintero 51; Alvaro Domínguez 24, Ricardo Ciciliano 73]
Pereira     3-0 Magdalena
  [Gabriel Gómez 12, 76, Jimmi Velasco 61]
Quindío     1-0 Tolima
  [Jorge Perlaza 87]
[Oct 31]
Cartagena   1-0 Pasto
  [Pedro Ortega 42]

Round 18 [Nov 6]
Tolima      1-1 Chicó
  [Víctor Bonilla 4; Wilson Cano 89]
Envigado    1-1 Huila  
  [Orlando Ballesteros 43; Jorge Díaz 70] 
Bucaramanga 2-2 Millonarios
  [Edwards Jiménez 3, 94; Martín García 62, Sebastián Hernández 87]
Cali        3-0 Pereira 
  [Rafael Márquez 29og, Blas Pérez 45, Jábinson Escobar 90]
Magdalena   0-2 Medellín
  [Jair Benítez 65, Jackson Martínez 75] 
Once Caldas 1-0 América
  [Arnulfo Valentierra 39]
Nacional    0-1 Junior
  [Luis Cassiani 93]
Santa Fe    1-0 Cartagena 
  [David Montoya 11]
Pasto       1-0 Quindío
  [Mauricio Dinamarca 30]

Table:

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

Relegated: Unión Magdalena

Cuadrangulares

Final Tables:

Group A
 1.Deportivo Cali               6   3  2  1  10- 6  11  Qualified
 2.Atlético Junior              6   3  1  2   7- 8  10
 3.Once Caldas                  6   2  0  4   7- 9   6
 4.América                      6   1  3  2   8- 9   6

Group B
 1.Real Cartagena               6   3  1  2   9- 6  10  Qualified
 2.CD Independiente Medellín    6   3  1  2   9- 7  10
 3.Independiente Santa Fe       6   2  2  2   6- 8   8
 4.Deportes Pereira             6   2  0  4   8-11   6

Round 1
[Nov 12]
América     1-1 Junior
  [Jorge Bermúdez 28; Luis Cassiani 87]
[Nov 13]
Once Caldas 0-1 Cali
  [Ricardo Ciciliano 22]
Medellín    2-1 Pereira
  [Roberto Carlos Cortés 4, Andrés Rodríguez 80; Néstor Salazar 60]
Santa Fe    1-1 Cartagena
  [Nelson Olveira 49pen; Luis Omar Valencia 28]

Round 2
[Nov 16]
Junior      1-0 Once Caldas
  [Martín Arzuaga 25pen]
Pereira     1-0 Santa Fe
  [Carlos Salazar 32]
Cartagena   1-0 Medellín
  [Manuel Galarcio 7]
[Nov 17]
Cali        0-0 América

Round 3
[Nov 19]
Medellín    0-2 Santa Fe
  [Alexander Jaramillo 33og, Luis Yánez 52] 
[Nov 20] 
Once Caldas 2-1 América
  [Dayro Moreno 47; Fabián Estay 45, Andrés Casañas 66]
Pereira     1-0 Cartagena
  [Néstor Salazar 12]
Cali        2-0 Junior
  [Blas Pérez 6, 41]

Round 4 
[Nov 26]
Junior      3-2 Cali
  [Emerson Acuña 32, Haider Palacio 37, Nelson Rivas 69og;
   Álvaro Domínguez 65, Rolando de La Cruz 85]
[Nov 27]
América     3-2 Once Caldas
  [Jorge Bermúdez 17, Adrián Ramos 62, Giovanni Arrechea 70;
   Diego Arango 48, Dayro Moreno 90]
Cartagena   3-2 Pereira
  [Jamerson Rentería 5, 56, Éder Hernández 87; Arnold Palacios 25,
   Gerson González 44]
Santa Fe    1-1 Medellín
  [Luis Yanez 13; Rodrigo Riep 33]

Round 5 [Dec 4]
América     2-2 Cali
  [Giovanni Arrechea 9, José Moreno 80; Blas Pérez 22,
   Hugo Rodallega 64]
Once Caldas 2-0 Junior
  [Edgar Zapata 48og, Arnulfo Valentierra 72]
Santa Fe    2-1 Pereira
  [David Montoya 2, José Largacha 76; Hugo Sánchez 64]
Medellín    2-0 Cartagena
  [Lewis Ochoa 3, Jackson Martínez 46]

Round 6 [Dec 11]
Cali        3-1 Once Caldas
  [Alvaro Domínguez 17, Hugo Rodallega 29, Blas Pérez 46+;
   Dayro Moreno 5]
Junior      2-1 América
  [Martín Arzuaga 22, Emerson Acuña 46; Juan Carlos Quiñónez 88]
Pereira     2-4 Medellín
  [Jersson González 12, Néstor Salazar 66; Diego Álvarez 7,
   Heriberto Velandia 41, Jaír Benítez 83, Jackson Martínez 88]
Cartagena   4-0 Santa Fe
  [Francisco Nájera 47og, Frank Pacheco 54, Eder Hernández 80,
   Luis Ómar Valencia 91]

Final Tables:

Group A
 1.Deportivo Cali               6   3  2  1  10- 6  11  Qualified
 2.Atlético Junior              6   3  1  2   7- 8  10
 3.Once Caldas                  6   2  0  4   7- 9   6
 4.América                      6   1  3  2   8- 9   6

Group B
 1.Real Cartagena               6   3  1  2   9- 6  10  Qualified
 2.CD Independiente Medellín    6   3  1  2   9- 7  10
 3.Independiente Santa Fe       6   2  2  2   6- 8   8
 4.Deportes Pereira             6   2  0  4   8-11   6

Finalísima

First Leg [Dec 14]
Cartagena   0-2 Cali
  [Hugo Rodallega 51, 76]

Second Leg [Dec 18]
Cali        1-0 Cartagena
  [Jaime Riveros 14]

Deportivo Cali are Clausura 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,348,352 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.1034
Total Execution Time  0.1061
  CADENA URL  
/clausura_primera_b_colombia2005
  GET DATOS  
$_GET['/clausura_primera_b_colombia2005']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2005'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 197 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1078402,1077594,1077298,1076577,1027676) ORDER BY n.cover_points DESC, update_date DESC
0.0024  SELECT text_es as historical_text FROM leagues_text WHERE id=5388
0.0019  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 = 33864 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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.0018  SELECT type,rule FROM rules WHERE categoryId = 197 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-04-19 22:25:45' 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-04-19 22:25:45' 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-04-19 22:25:45' 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-04-19 22:25:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_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.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33864) 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.0018  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 (33864) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33864) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (33864) 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 (33864) 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 (33864) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events2005 e WHERE e.league_id IN (33864) AND (e.action IN (22) ) 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 (33864) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 33864 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 33864 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0025  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=33864 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 = 33864 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 = 33864 AND esl.points > 0
0.0021  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-20" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33864 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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-20" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33864
0.0020  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` = 33864 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 = 33864 ORDER BY total DESC LIMIT 40
0.0022  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 = 33864 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 = 33864 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 33864 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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-20 00:00:00' AND c.`shedule` < '2024-04-24 23:59:59' AND l.id = 33864 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=197
0.0024  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 197 AND l.year = 2005 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=197 AND year=2005