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 2004
2003/2004

Clausura Primera B Colombia 2004

  • Primera B
Información Histórica
						Colombia 2004


Clausura 2004
-------------

Table:

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

Round 1 [Aug 1]
Junior      4-0  Chicó
  [Wilson Carpintero 31, Leiner Rolong 42, Juan Carlos Quintero 84,
   Martín Arzuaga 87]
Quindío     0-2  América
  [Leonardo Fabio Moreno 16, 21]
Santa Fe    3-1  Pasto
  [Léider Preciado 23, 38, Aldo Ramírez 65; Martín Perezlindo 40]
Huila       1-0  Nacional
  [Oscar Morera 39]
Once Caldas 1-2  Pereira
  [Luis Omar valencia 74; Edison Fonseca 78, Luis Cifuentes 87]
Tuluá       1-0  Millonarios
  [Marcio Cruz 46]
Bucaramanga 2-1  Magdalena
  [Edier Londoño 14, Henry Hernández 74; Erwin Maturana 22]
Cali        1-0  Envigado 
  [Iván Trujillo 77]
Medellín    0-1  Tolima
  [Ricardo Siciliano 38]

Round 2
[Aug 6]
América     3-0  Cali
  [Jersson González 6pen, Mauricio Romero 75, Leonardo Fabio Moreno 80]
[Aug 7]
Envigado    0-1  Bucaramanga
  [Luis Pérez 13]
Millonarios awd  Medellín                           [awarded 0-3; originally 1-1]
  [Andrés Sarmiento 24; Lewis Ochoa 28]
[Aug 8]
Magdalena   1-0  Tulúa
  [Carlos Olaya 80]
Tolima      1-0  Once Caldas
  [Henry Zambrano 59] 
Pereira     0-0  Huila
Nacional    0-1  Santa Fe
  [Aldo Ramírez 66]
Pasto       1-1  Junior
  [Martín Perezlindo 47; José Amaya 45]
Chicó       2-2  Quindío
  [Watson Rentería 8, Adelmo Vallecilla 49; Hugo Rodallega 15,
   Mauricio Molina 85]

Round 3
[Aug 11]
Once Caldas 4-0  Millonarios
  [Samuel Vanegas 14, Luis Ómar Valencia 31, Jefrey Díaz 39,
   Herly Alcázar 66]
Tuluá       0-3  Envigado
  [Oscar Restrepo 21, 25, Néstor Álvarez 70]
Quindío     1-0  Pasto
  [Mauricio Molina 74]
Junior      2-0  Nacional
  [Haider Palacio 39, Orlando Ballesteros 90]
Bucaramanga 2-1  Cali
  [Henry Hernández 52, Alexánder Orrego 82; Tressor Moreno 64]
Medellín    5-1  Magdalena
  [Néider Morantes 1, Diego Álvarez 3, 47, Ricardo Calle 56pen,
   César Baloyes 75; Roberto Polo 5]
Huila       1-4  Tolima
  [Germán Casas 31pen; Ricardo Ciciliano 45, Iván Velásquez 53, 69,
   John Charria 85]
[Aug 12]
Santa Fe    2-0  Pereira
  [Léider Preciado 40, William Vásquez 89]
América     3-1  Chicó
  [Carlos Molina 33, 51, Víctor Bonilla 46; Francisco Serrano 26]
 
Round 4 
[Aug 15]
Magdalena   1-2  Once Caldas
  [John Montaño 12; Jefrey Díaz 16, Herly Alcázar 80]
Cali        0-0  Tuluá 
Envigado    1-1  Medellín
  [Sergio Guzmán 93; Diego Alvarez 69]
Millonarios 0-3  Huila
  [Armando Carrillo 60, 62, 88]
Pereira     0-0  Júnior
Nacional    2-2  Quindío
  [Edixon Perea 20, 54; Leonel Alvarez 43, Hugo Rodallega 69]
Pasto       0-0  Chicó 
Tolima      2-1  Santa Fe
  [Ricardo Ciciliano 63, Iván Velásquez 65; Leider Preciado 25]
[Sep 29]
América     1-0  Bucaramanga  
  [Nestor Salazar 92]

Round 5
[Aug 22]
Chicó       1-2  Nacional
  [Luis Rojas 48; Edixon Perea 23, Oswaldo Mackenzie 87]
Medellín    2-0  Cali
  [Diego Álvarez 26, Jaime Castrillón 73]
Quindío     3-0  Pereira
  [Hugo Rodallega 22, Sebastián Hernández 34, Juan Gilberto Núñez 73]
Junior      1-2  Tolima
  [Wilson Carpintero 20; Oscar Briceño 12, Julián Anchico 59]
Huila       2-0  Magdalena
  [Armando Carrillo 82, César González 87]
Once Caldas 2-2  Envigado
  [John Viáfara 4, 67; Sergio Guzmán 11, Juan Fernando Leal 47]
Tuluá       1-2  Bucaramanga
  [Lionard Pajoy 50; Jámerson Rentería 36, Edier Londoño 37]
Santa Fe    4-1  Millonarios
  [Léider Preciado 36, 63, 82, Aldo Ramírez 86; Nicolás García 24]
[Sep 4]
América     0-0  Pasto

Round 6  [Aug 29]
Tulúa       1-2  América
  [Martín Carrillo 6; Leonardo Moreno 4, 54]
Bucaramanga 0-0  Medellín
Cali        2-0  Once Caldas
  [Erwin Carrillo 63, Hernando Patiño 89]
Envigado    2-1  Huila
  [Juan Fernando Leal 33, Oscar Restrepo 82; Armando Carrillo 11]
Magdalena   0-1  Santa Fe
  [Leiden Preciado 40]
Millonarios 0-1  Junior
  [Iván López 82og]
Tolima      3-0  Quindío
  [Oscar Passo 1, Iván Velásquez 50, John Charria 85]
Pereira     0-1  Chicó
  [Nilson Pérez 60]
Nacional    1-0  Pasto
  [Aquivaldo Mosquera 5]
 
Round 7
[Sep 1]
Quindío     2-1  Millonarios
  [Hugo Rodallega 11, Mauricio Molina 18; José Moreno 55]
Junior      3-0  Magdalena
  [Martín Arzuaga 33, Wilson Carpintero 75, Leonardo Rojano 80]
[Sep 8]
América     4-1  Nacional
  [Aquivaldo Mosquera 24og, Andrés González 40, Leo Moreno 79,
   Pablo Armero 88; Carlos Díaz 23]
Pasto       1-0  Pereira
  [Henry Vásquez 51]
Chicó       1-1  Tolima
  [Francisco Serrano 14; Iván Velásquez 81]
Santa Fe    1-2  Envigado
  [Aldo Ramírez 89; Néstor Alvarez 20, Andrés Casañas 25]
Huila       2-2  Cali
  [Germán Casas 56, César González 58; Milton Rodríguez 21, 53]
Once Caldas 3-1  Bucaramanga
  [Rubén Velásquez 17, Jonathan Fabbro 52, Herly Alcázar 91;
   Eddier Londoño 19]
Medellín    3-0  Tuluá
  [Néider Morantes 44, Diego Álvarez 65, Jaime Castrillón 81]
 
Round 8  [Sep 12]
Medellín    1-0  América
  [Neider Morantes 80]
Tuluá       1-1  Once Caldas
  [Martín Carrillo 43; Roller Cambindo 95]
Bucaramanga 3-1  Huila
  [Iván Garrido 11, Henry Hernández 66, Jámerson Rentería 86; Oscar Morera 24]
Cali        1-0  Santa Fe
  [Milton Rodríguez 77]
Envigado    2-2  Junior
  [Néstor Alvarez 8, Jonathan Estrada 82; Orlando Ballesteros 54, 60]
Magdalena   2-0  Quindío
  [Alberto Godoy 34, Alexander Valoy 55]
Millonarios 2-2  Chicó
  [Carlos Adonay Acevedo 6, José Moreno 71pen; Anuar Guerrero 25,
   Silvino Caicedo 92]
Tolima      0-0  Pasto
Pereira     1-4  Nacional
  [Guillermo Berrío 37; Héctor Hurtado 20, Cristian Marrugo 62,
   Edixon Perea 62, Hugo Morales 78]
 
Round 9  [Sep 15]
Chicó       0-2  Bucaramanga
  [Henry Hernández 65, 93]
Pasto       1-0  Tuluá
  [Wilmer Díaz 83]
Nacional    2-1  Medellín
  [Carlos Díaz 29, Hugo Morales 78; Camilo Giraldo 67]
Pereira     0-2  Once Caldas
  [Dairo Moreno 67, Elkin Soto 87]
Tolima      3-2  Huila
  [Iván Velásquez 31, 39, Ricardo Ciciliano 45; César González 34,
   Luis Andrade 51]
Millonarios 1-1  Santa Fe
  [José Moreno 91; Léider Preciado 51]
Magdalena   1-2  Junior
  [Pablo Quandt 8; Martín Arzuaga 67, Juan Carlos Quintero 72]
Envigado    3-0  Quindío
  [Oscar Restrepo 7, Freddy Guarín 15, Belmer Aguilar 22]
Cali        0-1  América
  [Roberto Carlos Cortés 52og]
 
Round 10  [Sep 19]
América     2-1  Pereira
  [Edwin Valencia 69, Néstor Salazar 76; Yimi Velasco 74]
Nacional    2-0  Tolima
  [Felipe Rivas 12, Édixon Perea 49]
Pasto       0-0  Millonarios
Chicó       1-0  Magdalena
  [Luis Yanes 91]
Quindío     1-1  Envigado
  [Hugo Rodallega 85; Óscar Restrepo 29]
Junior      0-3  Cali
  [Roberto Palacios 38, Milton Rodríguez 51, Jorge López 88]
Santa Fe    1-1  Bucaramanga
  [Carlos Vilarete 3; Jamerson Rentaría 81]
Huila       1-0  Tuluá
  [Diego Moreno 82]
Once Caldas 0-0  Medellín
 
Round 11  [Sep 22]
Once Caldas 3-0  América
  [Rubén Velásquez 22, Dairo Moreno 26, Jefrey Díaz 90]
Medellín    1-0  Huila
  [Diego Alvarez 16]
Tuluá       3-1  Santa Fe
  [Hinestroza 48, Leonardo Mina Polo 65, Mayer Candelo 69; Léider Preciado 40pen]
Bucaramanga 0-1  Junior
  [Haider Palacio 24]
Cali        3-0  Quindío
  [Roberto Palacios 8, Milton Rodríguez 69, 77]
Envigado    1-0  Chicó
  [Néstor Alvarez 60]
Magdalena   1-0  Pasto
  [Alberto Godoy 40]
Millonarios 1-1  Nacional
  [José Moreno 14, Aquivaldo Mosquera 70]
Tolima      0-1  Pereira
  [Hernando Cardona 66]
 
Round 12
[Sep 25]
América     3-3  Tolima
  [Edwin Valencia 51, Andrés Felipe González 71, Leonardo Moreno 86;
   John Charria 10, 24, Iván Velásquez 73]
[Sep 26]
Pereira     0-2  Millonarios
  [Leonardo Santamaría 8, Omar Guerra 52]
Nacional    0-0  Magdalena
Pasto       1-1  Envigado
  [Estéban González 41; Oscar Restrepo 47]
Chicó       1-2  Cali
  [Mauricio Gómez 4; José Mera 78, Carlos Pavón 86]
Quindío     2-0  Bucaramanga
  [Hugo Rodallega 40, 72]
Junior      0-2  Tuluá
  [Leonardo Mina Polo 33, Guillermo Rivera 87]
Santa Fe    2-1  Medellín
  [Léider Preciado 2, Mario González 87; Jaime Castrillón 15]
Huila       3-0  Once Caldas
  [Edwin Carrillo 36, 90, Germán Casas 48]

Round 13  [Oct 3]
Huila       0-1  América
  [Leonardo Fabio Moreno 79]
Once Caldas 1-1  Santa Fe
  [Herly Alcázar 88; Leider Preciado 46]
Medellín    2-2  Junior
  [Néider Morantes 23, Diego Álvarez 87; Macnelly Torres 12,
   Walter Ribonetto 78]
Tuluá       1-0  Quindío
  [Marcio Cruz 67]
Bucaramanga 0-0  Chicó
Cali        2-0  Pasto
  [Milton Rodríguez 82, Roberto Carlos Cortés 87]
Envigado    2-1  Nacional
  [Víctor Cortés 12, Andrés Casañas 39; Édixon Perea 80]
Magdalena   1-0  Pereira
  [John Montaño 35]
Millonarios 2-1  Tolima
  [Jesús Di Filippe 16, José Moreno 47; Gerardo Vallejo 39]
 
Round 14
[Oct 15]
América     1-0  Millonarios
  [Andrés Sarmiento 57og]
[Oct 16]
Chicó       1-2  Tuluá
  [Luis Yánez 87; Fabio Zúñiga 24, Martín Carrillo 74]
[Oct 17]
Tolima      1-0  Magdalena
  [Ricardo Siciliano 32]
Santa Fe    2-1  Huila
  [Leider Preciado 36, 69pen; Santiago Silvera 57]
Nacional    3-1  Cali
  [Oscar Echeverri 9, Carlos Alvarez 52, Héctor Hurtado 91;
   Milton Rodríguez 15]
Pereira     1-0  Envigado
  [Hernán Darío Cardona 47]
Quindío     1-0  Medellín
  [Hugo Rodallega 75]
Junior      1-4  Once Caldas
  [Cristian Racero 13; Herly Alcázar 40, 45, 49, Jonathan Fabbro 75]
Pasto       1-1  Bucaramanga
  [Carlos Hidalgo 30; Henry Hernández 56]

Round 15 [Oct 24]
Santa Fe    0-2  América
  [David Ferreira 70, Leonardo Moreno 78]
Huila       1-1  Junior
  [Pedro Pino 18; Wilson Carpintero 73]
Once Caldas 6-1  Quindío
  [Herly Alcázar 6, 59, Elkin Soto 42, Javier Araújo 76,
   Diego Cortés 85og, Róller Cambindo 88; Hugo Rodallega 20]
Medellín    1-0  Chicó
  [Diego Alvarez 25]
Tuluá       0-0  Pasto
Bucaramanga 1-0  Nacional
  [Edier Londoño 18]
Cali        2-0  Pereira
  [Milton Rodríguez 56, Roberto Palacios 88]
Envigado    1-2  Tolima
  [Nestor Alvarez 6; Iván Velásquez 26, 51]
Magdalena   1-0  Millonarios
  [Danny Quedambú 28]

Round 16  [Oct 27]
América     3-0  Magdalena
  [Néstor Salazar 31, Jorge Banguero 80, Mauricio Romero 85]
Millonarios 3-0  Envigado
  [Ómar Andrés Rodríguez 8, Carlos Gutiérrez 16, Bonner Mosquera 79]
Tolima      2-1  Cali
  [Oscar Briceño 6, Ricardo Ciciliano 53; Mílton Rodríguez 14]
Pereira     1-2  Bucaramanga
  [Harnold Palacios 88; Edier Londoño 53, Henry Hernández 86]
Nacional    2-0  Tuluá
  [Aquivaldo Mosquera 14, Oscar Echeverry 81]
Pasto       1-2  Medellín
  [Carlos Hidalgo 18; Diego Alvarez 11, César Valoyes 62]
Chicó       1-0  Once Caldas
  [Roller Cambindo 35og]
Quindío     2-0  Huila
  [Hugo Rodallega 57, 73]
Junior      2-0  Santa Fe
  [Orlando Ballesteros 13, Omar Pérez 50]

Round 17  [Oct 31]
Junior      2-2  América
  [Walter Ribonetto 88, Juan Carlos Quintero 93; Leonardo Moreno 10,
   Edwin Valencia 75]
Santa Fe    2-3  Quindío
  [Rider O'Neil 17, Carlos Ortíz 36; Diego Cortés 21,
   Edú Aponzá 45, Mauricio Molina 85]
Huila       0-1  Chicó
  [Wason Rentería 53]
Once Caldas 1-0  Pasto
  [Jonathan Fabbro 52pen]
Medellín    0-1  Nacional
  [Héctor Hurtado 67]
Tuluá       1-1  Pereira
  [Emir González 77; Guillermo Berrío 75]
Bucaramanga 3-1  Tolima
  [Edier Londoño 33, Iván Garrido 48, Marcos Cardoso 50;
   Ricardo Ciciliano 90]
Cali        2-0  Millonarios
  [Milton Rodríguez 13, Carlos Pavón 27]
Envigado    4-0  Magdalena
  [César Hernández 6, Óscar Restrepo 49, Andrés Casañas 66,
   Freddy Guarín 76]

Round 18  [Nov 7]
América     2-1  Envigado
  [Leonardo Moreno 30, Víctor Bonilla 66; Andrés Casañas 17]
Magdalena   1-1  Cali
  [John Montaño 44; Erwin Carrillo 47]
Millonarios 1-2  Bucaramanga
  [Omar Andrés Rodríguez 41; Pedro Cabrales 22, Jamerson Rentería 50]
Tolima      0-1  Tuluá
  [Julián Anchico 56]
Pereira     1-1  Medellín
  [Hernán Darío Cardona 25; Jackson Martínez 71]
Pasto       3-2  Huila
  [Óscar Darío Martínez 15, 24, Diego Toro 71;Dídier Montealegre 54,
   Armando Carrillo 84]
Nacional    2-0  Once Caldas
  [Edgar Cataño 17og, Carlos Alvarez 21]
Chicó       2-2  Santa Fe
  [Wason Rentería 68, 83; Jorge Vidal 54, Léider Preciado 79]
Quindío     1-1  Junior
  [Carlos González 85; Omar Pérez 15]

Table:

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

NB: Top 8 after 18 rounds qualify to the Cuadrangulares (second stage)

Cuadrangulares

Tables:

Group A
 1.Atlético Nacional           6   3  2  1   6- 3  11
 2.América                     6   2  2  2  10- 8   8
 3.Deportes Tolima             6   2  1  3   9- 9   7
 4.Once Caldas                 6   2  1  3   5-10   7

Group B
 1.Atlético Junior             6   4  1  1  11- 5  13
 2.Deportivo Cali              6   2  2  2   6- 6   8
 3.CD Independiente Medellín   6   2  2  2   9-10   8
 4.Atlético Bucaramanga        6   1  1  4   5-10   4

Round 1  [Nov 21]
Nacional    0-0  Once Caldas
América     2-3  Tolima
  [David Ferreira 6, Nestor Salazar 18; Camilo Ramírez 10,
   Iván Velásquez 58, Ricardo Siciliano 89]
Junior      3-0  Cali
  [Macnelly Torres 26, Haider Palacio 47pen, Orlando Ballesteros 70]
Bucaramanga 0-0  Medellín

Round 2  [Nov 24]
Once Caldas 1-4  América
  [Antonio De Nigris 26; Víctor Bonilla 48+, 62, Néstor Salazar 47,
   Leonardo Moreno 92]
Tolima      1-2  Nacional
  [Iván Velásquez 53; Héctor Hurtado 90, Humberto Mendoza 65]
Cali        2-0  Bucaramanga
  [Roberto Palacios 9, Milton Rodríguez 79]
Medellín    3-2  Junior
  [Ricardo Calle 48pen, Neider Morantes 57, Jackson Martínez 70;
   Martín Arzuaga 65, Heriberto Velandia 62og]

Round 3  [Nov 28]
Once Caldas 1-0  Tolima
  [Dairo Moreno 77]
Nacional    0-0  América
Cali        1-1  Medellín
  [Hernando Patiño 14; Jaime Castrillón 28]
Junior      2-1  Bucaramanga
  [Orlando Ballesteros 67, Emerson Acuña 86; Marcos Cardozo 42]

Round 4
[Nov 14]
Tolima      4-1  Once Caldas
  [Oscar Briceño 8, 11, Dumar Rueda 44, John Harold Viáfara 60;
   Jonathan Fabbro 32]
[Dec 5]
América     2-1  Nacional
  [Andrés González 46, Leonardo Moreno 63; Carlos Alvarez 82pen]
Medellín    0-2  Cali
  [Carlos Pavón 88, Milton Rodríguez 92]
Bucaramanga 0-1  Junior
  [Omar Pérez 61]

Round 5
[Nov 12]
América     1-2  Once Caldas
  [Leonardo Moreno 15; Elkin Soto 40, Edgar Cataño 45]
[Dec 8]
Nacional    2-0  Tolima
  [Humberto Mendoza 30, Hugo Morales 76]
Bucaramanga 1-0  Cali
  [Jamerson Rentería 87]
Junior      2-0  Medellín
  [Martín Arzuaga 46, Emerson Acuña 83]

Round 6
[Nov 18]
Once Caldas 0-1  Nacional
  [Mauricio Serna 35]
[Dec 12]
Tolima      1-1  América
  [John Charria 82; Leonardo Fabio Moreno 67]
Cali        1-1  Junior
  [Alvaro Domínguez 84; Leiner Rolong 89]
Medellín    5-3  Bucaramanga
  [Jaír Benítez 15, Jackson Martínez 34, 43, Diego Álvarez 52,
   Lewis Ochoa 75; Jamell Ramos 37og, Jhann Carlos López 65og,
   Emerson Chamorro 80]

Tables:

Group A
 1.Atlético Nacional           6   3  2  1   6- 3  11
 2.América                     6   2  2  2  10- 8   8
 3.Deportes Tolima             6   2  1  3   9- 9   7
 4.Once Caldas                 6   2  1  3   5-10   7

Group B
 1.Atlético Junior             6   4  1  1  11- 5  13
 2.Deportivo Cali              6   2  2  2   6- 6   8
 3.CD Independiente Medellín   6   2  2  2   9-10   8
 4.Atlético Bucaramanga        6   1  1  4   5-10   4

Championship Final

First Leg  [Dec 15]
Junior      3-0  Nacional
  [Leonardo Rojano 17, Hayder Palacio 74, Roberto Peñaloza 80]

Second Leg [Dec 19]
Nacional    5-2  Junior                             [4-5 pen]
  [Edixon Perea 19, Aquivaldo Mosquera 24, 59, Carlos Díaz 63,
   Héctor Hurtado 68; Martín Arzuaga 39, Walter Ribonetto 88]

Junior are Finalización 2004 champions.

Relegation Table:
                 2002     2003     2004     Total
               Pd W  Pt Pd W  Pt Pd W  Pt  Pd  W Pts  Avg
 1.Cali        44 25 86 36 18 62 36 19 64 116 62 212 1.828 
 2.América     44 18 67 36 14 53 36 25 79 116 56 199 1.716 
 3.Nacional    44 18 70 36 15 52 36 19 63 116 52 185 1.595 
 4.Caldas      44 16 64 36 14 53 36 17 59 116 47 176 1.517 
 5.Medellin    44 13 56 36 15 53 36 16 58 116 44 167 1.440 
 6.Bucaramanga 44 18 66 36 10 42 36 15 55 116 43 163 1.405 
 7.Pasto       44 20 70 36 12 47 36 11 44 116 43 161 1.388 
 8.Tolima      44 12 51 36 13 49 36 16 59 116 40 159 1.371 
 9.Junior      44 11 47 36 15 52 36 15 58 116 41 157 1.353 
10.Santa Fe    44 18 70 36 10 42 36 11 45 116 39 157 1.353 
11.Pereira     44 15 58 36 13 51 36 10 39 116 38 148 1.276 
12.Magdalena   44 18 66 36 16 54 36  7 27 116 41 147 1.267 
13.Millonarios 44 11 46 36 16 57 36 10 39 116 37 142 1.224 
14.Quindío     44 15 58 36  9 38 36 10 40 116 34 136 1.172 
15.Huila       44 11 47 36 12 50 36  9 34 116 32 131 1.129 
16.Envigado    44 13 51 36  9 40 36  9 40 116 31 131 1.129 
17.Chicó       44 13 49 36  6 32 36 11 45 116 30 126 1.086 
18.Tuluá       44 13 49 36  6 32 36 11 41 116 30 122 1.051  Relegated 




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,343,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.6119
Total Execution Time  0.6139
  CADENA URL  
/clausura_primera_b_colombia2004
  GET DATOS  
$_GET['/clausura_primera_b_colombia2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0128  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2004'
0.0257  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 = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197 AND type_rel = 3
0.0131  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.0127  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.0132  SELECT text_es as historical_text FROM leagues_text WHERE id=5390
0.0129  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 = 33865 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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.0132  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2024' WHERE c.parentId=196 GROUP BY c.id ORDER BY c.order_id ASC
0.0126  SELECT type,rule FROM rules WHERE categoryId = 197 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 06:24:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 06:24:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 06:24:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 06:24:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0141  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 = 2004 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0132  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (33865) 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.0130  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 (33865) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0129  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (33865) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0129  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 (33865) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0135  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (33865) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0135  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 (33865) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0138  SELECT e.action, count(e.action) as total, e.player_id FROM events2004 e WHERE e.league_id IN (33865) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0133  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 (33865) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0133  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 = 33865 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0128  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 = 33865 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0138  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=33865 AND rel.round=18
0.0133  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 = 33865 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0129  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 = 33865 AND esl.points > 0
0.0127  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` = 33865 ORDER BY creation_date DESC LIMIT 0, 10
0.0131  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` = 33865
0.0126  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 `calendars2004` 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` = 33865 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0125  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 `events2004` e INNER JOIN calendars2004 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 = 33865 ORDER BY total DESC LIMIT 40
0.0127  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 `events2004` e INNER JOIN calendars2004 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 = 33865 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0131  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 `tables2004` 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 = 33865 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2004` 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 = 33865 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 33865 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0131  SELECT data1, data2 FROM services_tags WHERE categoryId=197
0.0131  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 197 AND l.year = 2004 ORDER BY l.group_code ASC
0.0131  SELECT group_code, extraName from `leagues` WHERE categoryId=197 AND year=2004