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

Clausura Primera B Colombia 2003

  • Primera B
Información Histórica
						Colombia 2003


Torneo Finalizacion 2003
------------------------

Table:

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

Round 1  [Jul 13]
Millonarios 0-1  Magdalena
  [Edwin Carrillo 49]
América     2-2  Tolima
  [Oscar Villarreal 4, Edier Londoño 7; Rogeiro Pereira 71, Arley Dinas 75]
Junior      2-0  Santa Fe
  [Orlando Ballesteros 31, Emerson Rentería 60]
Once Caldas 1-1  Quindío
  [Jeffrey Díaz 48; Víctor Giraldo 17]
Huila       1-2  Cali
  [Harol Romaña 60; Carlos Castillo 39, Leider Preciado 75]
Tuluá       0-1  Pereira
  [Francisco Franco 36]
Envigado    0-0  Medellín
Centauros   2-1  Pasto
  [Oswaldo Mackenzie 10, Wilson Cuero 32; Guillermo Rivera 77pen]
Nacional    0-0  Bucaramanga

Round 2  [Jul 24]
Santa Fe    1-1  Millonarios
  [John Mario Ramírez 33; Julián Téllez 51]
Medellín    0-0  América
Pereira     1-1  Junior
  [Cesar Martínez 17; Eudalio Arriaga 78pen]
Pasto       2-1  Huila
  [Dumar Rueda 30, Oscar Martínez 75; Iván Trujillo 40]
Tolima      1-1  Centauros
  [John Charria 91; Oswaldo Mackenzie 68]
Quindío     1-1  Envigado
  [Andrés Guapacha 81; Johny Ramírez 68pen]
Magdalena   1-0  Once Caldas
  [Carlos Vilarete 23]
Bucaramanga 2-0  Tuluá
  [Wilson Carpintero 66, 75]
Cali        1-0  Nacional
  [Carlos Castillo 27]

Round 3
[Jul 26]
Santa Fe    1-0  Pereira
  [Carlos Ortíz 49]
[Jul 27]
Junior      2-4  Bucaramanga
  [Martín Arzuaga 6, Haider Palacio 69; Rafael Castillo 21, Felipe Rivas 41, 43,
   Juan Carlos Quintero 88]
Tuluá       0-4  Cali
  [Jimmy Asprilla 20, Léider Preciado 34, Mayer Candelo 43pen, Carlos Castillo 45]
Nacional    3-0  Pasto
  [Javier Arizala 5, 25, Carmelo Valencia 90]
Huila       2-1  Tolima
  [Juan Carlos Escobar 32, Jairo Hurtado 55; Célimo Polo 29]
Centauros   1-0  Medellín
  [Nestor Salazar 51]
América     2-0  Quindío
  [Oscar Villareal 10, David Ferreira 17]
Envigado    0-0  Magdalena
Once Caldas 0-1  Millonarios
  [Leonardo Rojano 46]

Round 4
[Aug 2]
Once Caldas 0-0  Santa Fe
[Aug 3]
Cali        4-0  Junior
  [Léider Preciado 27, 48, 86, Carlos Castillo 43]
Bucaramanga 0-1  Pereira
  [Cristian Fajardo 68og]
Quindío     3-1  Centauros
  [Iván René Valenciano 16, 32, Nelson Gómez 69; Néstor Salazar 68]
Magdalena   0-2  América
  [José Moreno 5, David Ferreira 30]
Tolima      2-1  Nacional
  [Jorge Artigas 39, Henry Zambrano 63; Martín Echavarría 56]
Millonarios 2-0  Envigado
  [Julián Téllez 19, Edwin Rivas 69]
Pasto       2-1  Tuluá
  [Alexander Padilla 36, Pablo Jaramillo 80; Harold Rivera 3]
Medellín    3-0  Huila
  [Diego Alvarez 10, 12, David Montoya 49]

Round 5  [Aug 10]
Pereira     3-2  Cali
  [César Martínez 19, Hugo Sánchez 49, 72; Léider Preciado 22,
   Mayer Candelo 62]
América     0-3  Millonarios
  [Jorge López 49, 81, Leonardo Rojano 90]
Santa Fe    3-2  Bucaramanga
  [Francisco Delgado 13, Lucas Jaramillo 55, Carlos Ortíz 59;
   Néider Morantes 51, Wilson Carpintero 88]
Nacional    2-1  Medellín
  [Camilo Giraldo 60, Carmelo Valencia 87; David Montoya 70]
Junior      1-1  Pasto
  [Orlando Ballesteros 22; Leonardo Enciso 30]
Centauros   2-0  Magdalena
  [Néstor Salazar 4, Arley Betancurt 83]
Huila       0-0  Quindío
Tuluá       0-1  Tolima
  [Justiniano Peña 65]
Envigado    1-2  Once Caldas
  [John Freddy Correa 91; Sergio Galván 11, John Viáfara 62]

Round 6
[Aug 15]
Envigado    1-2  Santa Fe
  [Blas Pérez 44; Jader Rojas 39, Aldo Leao Ramírez 42]
[Aug 16]
Millonarios 2-0  Centauros
  [Jorge López 47, Andrés Pérez 65]
[Aug 17]
Cali        3-2  Bucaramanga
  [Léider Preciado 49, Gerardo Bedoya 64, Luis Rojas 85;
   Rafael Castillo 32, Wilson Carpintero 91]
Once Caldas 1-0  América
  [Arnulfo Valentierra 58pen]
Pasto       0-0  Pereira
Tolima      2-1  Junior
  [Jorge Artigas 14, Rogeiro Pereira 66; Jamerson Rentería 79]
Medellín    1-2  Tuluá
  [David Montoya 31; Eliécer Díaz 18, Hever Hinestroza 80]
Magdalena   3-1  Huila
  [Erwin Carrillo 3, Carlos Vilarete 45, Andrés Buelvas 71;
   Ramiro Madrid 66]
Quindío     1-0  Nacional
  [Jaques Carvalho 84]

Round 7  [Aug 24]
America     1-2  Envigado
  [Jersson González 84; Johnny Ramírez 35, Víctor Cortés 76]
Santa Fe    0-0  Cali
Huila       2-1  Millonarios
  [Angelmiro Escobar 77, Ramiro Madrid 93; Julián Téllez 21]
Pereira     0-0  Tolima
Centauros   0-1  Once Caldas
  [Arnulfo Valentierra 75]
Nacional    1-0  Magdalena
  [Edixon Perea 55]
Tuluá       1-0  Quindío
  [Marcio Cruz 35]
Bucaramanga 1-0  Pasto
  [Rafael Castillo 72]
Junior      1-0  Medellín
  [Lin Carlos Henry 37]

Round 8  [Aug 31]
América     0-0  Santa Fe
Envigado    3-1  Centauros
  [Julio Valencia 15, Victor Cortés 56, Juan Camilo Mejía 79;
   Wilson Segura 42]
Once Caldas 3-3  Huila
  [Sergio Galván 1, Rubén Velásquez 18, 38; Luis Guillermo Berrío 25,
   Germán Casas 33pen, Luis Pérez 35]
Millonarios 0-0  Nacional
Magdalena   3-0  Tuluá
  [Carlos Vilarete 40, Fernando Pérez 80, 84]
Quindío     1-1  Junior
  [Andrés Casañas 59; Martín Arzuaga 29]
Medellín    2-0  Pereira
  [Jorge Horacio Serna 18, David Montoya 57]
Tolima      4-1  Bucaramanga
  [Rogeiro Pereira 19, 35, 40, Jorge Artigas 61; Neider Morantes 87]
Pasto       1-1  Cali
  [Diego Valdez 58; Carlos Castillo 44]

Round 9  [Sep 14]
Pereira     1-1  Once Caldas
  [Carlos Castro 74pen; Sergio Galván 19]
Bucaramanga 0-2  Envigado
  [Camilo Mejía 56, Rafael Orrego 87]
Cali        0-0  América
Pasto       3-0  Centauros
  [Pablo Jaramillo 61, Luis Rivera 87, Gerardo Seoane 86]
Tolima      1-1  Huila
  [Rogeiro Pereira 78; Iván Trujillo 60]
Medellín    1-2  Nacional
  [Jorge Horacio Serna 43; Jorge Agudelo 1, Juan Ricaurte 81]
Quindío     2-2  Tuluá
  [Henry Vásquez 9, Jaques Carvalho 48; Eliecer Díaz 66,
   Faustino Asprilla 85]
Magdalena   3-1  Junior
  [Erwin Carrillo 21, Fernando Pérez 62, Carlos Vilarete 66;
   Haider Palacio 78pen]
Millonarios 2-1  Santa Fe
  [Jorge López 43, Luis Eduardo Zapata 58; Jader Rojas 76]

Round 10  [Sep 21]
Santa Fe    1-0  Pasto
  [Carlos Ortíz 15]
Cali        1-2  Tolima
  [Leider Preciado 57; Oscar Briceño 9, 57]
Bucaramanga 1-2  Medellín
  [Iván Garrido 69; Jamel Ramos 22, Jorge Horacio Serna 89]
Pereira     2-0  Quindío
  [Carlos Castro 21, Carlos Córdoba 81]
Junior      2-0  Magdalena
  [Martín Arzuaga 27, Orlando Ballesteros 58]
Tuluá       2-1  Millonarios
  [Marcio Cruz 13, 58; Julián Téllez 4]
Nacional    1-1  Once Caldas
  [Diego Toro 30; Arnulfo Valentierra 87]
Huila       2-0  Envigado
  [Ramiro Madrid 36, 82]
Centauros   1-3  América
  [Néstor Salazar 67; Jairo Castillo, Gabriel Antero 39,
   David Ferreira 57]

Round 11  [Sep 24]
Centauros   1-0  Santa Fe
  [Néstor Salazar 16]
América     1-1  Huila
  [Jersson González 28; Ramiro Madrid 32]
Envigado    1-2  Nacional
  [Francisco Primera 20; Iván Velásquez 61, 74]
Once Caldas 2-4  Tuluá
  [Jefrey Díaz 1, Arnulfo Valentierra 22; Marcio Cruz 43,
   Víctor Bonilla 46, 66, 67]
Millonarios 2-0  Junior
  [Andrés Pérez 35, Belmer Aguilar 58]
Magdalena   2-1  Pereira
  [Carlos Vilarete 4, Luis Zuleta 88; Hernán Darío Cardona 63]
Quindío     3-2  Bucaramanga
  [Jaques Carvalho 23, Nelson Gómez 52, Ferley Villamil 68;
   Felipe Benalcázar 5, Wilson Carpintero 66]
Medellín    2-0  Cali
  [William Vásquez 7, Jorge Horacio Serna 83]
Tolima      0-1  Pasto
  [Diego Cortés 24]

Round 12  [Sep 28]
Santa Fe    0-0  Tolima
Pasto       1-1  Medellín
  [John Viáfara 54; David Montoya 71]
Bucaramanga 0-1  Magdalena
  [Edwin Carrillo 12]
Cali        3-0  Quindío
  [Carlos Castillo 50, Leider Preciado 69, 74pen]
Pereira     2-0  Millonarios
  [Carlos Castro 12pen, 73]
Junior      4-2  Once Caldas
  [Orlando Ballesteros 16, 63, 91, Martín Arzuaga 39;
   Sergio Galván 7, Jefrey Díaz 10]
Tulúa       0-0  Envigado
Nacional    2-0  América
  [Freddy Grisales 34, 64]
Huila       2-1  Centauros
  [Vicente Preciado 6, Luis Guillermo Berrío 67; Wilson Segura 15]

Round 13  [Oct 5]
Huila       0-0  Santa Fe
Centauros   1-1  Nacional
  [Herly Alcázar 40; Edixon Perea 49]
América     1-1  Tuluá
  [Oscar Villareal 29; Víctor Bonilla 20]
Envigado    1-1  Junior
  [Blas Pérez 86; Haider Palacio 82]
Once Caldas 1-1  Pereira
  [Rubén Darío Velásquez 3; Hugo Sánchez 59]
Millonarios 2-1  Bucaramanga
  [Julián Téllez 18, Andrés Pérez 82; Wilson Carpintero 72]
Magdalena   3-0  Cali
  [Orlando Fuentes 43, Aníbal Pérez 81, 85]
Quindío     2-0  Pasto
  [Nelson Gómez 19, Hernán Darío Reynolds 57]
Medellín    1-0  Tolima
  [David Montoya 6pen]

Round 14   [Oct 8]
Santa Fe    1-2  Medellín
  [Jader Rojas 81; David Montoya 34, Roberto Carlos Cortés 86]
Tolima      2-1  Quindío
  [John Charria 48, Rogeiro Pereira 77; José María Passo 14og]
Pasto       2-1  Magdalena
  [Leonardo Enciso 3, Wilmer Díaz 67; Luis Zuleta 66]
Cali        3-0  Millonarios
  [Gerardo Bedoya 6, Carlos Castillo 44, Mayer Candelo 85pen]
Bucaramanga 3-2  Once Caldas
  [Neider Morantes 49, Carlos Sandoval 26, 54; Edgar Cataño 22,
   Julián Díaz 84]
Pereira     1-1  Envigado
  [Carlos Castro 31; Edison Aguilar 26]
Junior      1-2  América
  [Martín Arzuaga 73; Jairo Castillo 28, Mauricio Mendoza 84]
Tuluá       0-0  Centauros
Nacional    2-1  Huila
  [Héctor Hurtado 11, Robinson Muñoz 76pen; Ramiro Madrid 35]

Round 15  [Oct 12]
Nacional    1-1  Santa Fe
  [Freddy Grisales 13; Francisco Delgado 59]
Huila       3-2  Tuluá
  [Guillermo Berrío 36, Edú Aponzá 58, Ramiro Madrid 71;
   Víctor Bonilla 27, 34]
Centauros   1-2  Junior
  [Wilson Segura 12; Lin Carlos Henry 48, Roberto Peñaloza 71]
América     4-3  Pereira
  [Nondier Romero 11, Jean Ferrari 28, Jairo Castillo 30,
   David Ferreira 55; Carlos Castro 23, 77, Carlos Córdoba 72]
Envigado    1-1  Bucaramanga
  [Edison Aguilar 77; Rafael Castillo 12]
Once Caldas 2-3  Cali
  [Sergio Galván 16, Elkin Soto 47; Leider Preciado 65, 70,
   Jorge Díaz 83]
Millonarios 0-1  Pasto
  [Leonardo Enciso 17]
Magdalena   2-0  Tolima
  [Fernando Pérez 52, Elkin Amador 93]
Quindío     1-1  Medellín
  [Andrés Guapacha 67; William Vásquez 54]

Round 16  [Oct 19]
Medellín    1-0  Magdalena
  [Sergio Guzmán 70]
Tolima      3-0  Millonarios
  [Arley Dinas 14, Jorge Artigas 48, Henry Zambrano 90]
Pasto       1-0  Once Caldas
  [John Viáfara 48]
Santa Fe    0-0  Quindío
Cali        1-1  Envigado
  [Carlos Castillo 1; Camilo Mejía 85]
Bucaramanga 2-2  América
  [Wilson Galeano 55, Rodrigo Ruíz 91; Jairo Castillo 8, 80]
Pereira     1-1  Centauros
  [Carlos Castro 12; Herly Alcázar 61]
Junior      1-0  Huila
  [César Faucet 42]
Tuluá       0-1  Nacional
  [Róbinson Muñoz 56]

Round 17  [Oct 29]
Centauros   1-1  Bucaramanga
  [Wilson Segura 36; Farid Díaz 75]
Once Caldas 1-0  Tolima
  [Arnulfo Valentierra 68pen]
Nacional    4-2  Junior
  [Héctor Hurtado 10, Aquivaldo Mosquera 20, Róbinson Muñoz 45pen,
   Iván Velásquez 86; Luis Cassiani 11, Lin Carlos Henry 26]
Magdalena   0-2  Quindío
  [James López 35, Iván Valenciano 45]
Millonarios 3-1  Medellín
  [Julián Téllez 56, 74, 88; William Vásquez 76]
América     1-3  Cali
  [Jean Ferrari 84; Jorge Díaz 49, Mayer Candelo 81,
   Léider Preciado 90]
Huila       2-1  Pereira
  [Ramiro Madrid 51, Edú Aponzá 53; Hernán Darío Cardona 46]
Envigado    2-3  Pasto
  [Camilo Mejía 59, Duván Hernández 73; Leonardo Enciso 11, 85,
   Jorge Zapata 79]
Tuluá       1-1  Santa Fe
  [Alex Fernández 72; Mario González 6]

Round 18  [Nov 2]
Quindío     3-1  Millonarios
  [Iván Valenciano 5, Nelson Gómez 72, 81; Martín Pérez 34]
Cali        3-0  Centauros
  [Carlos Castillo 43, Jorge Díaz 47pen, Alvaro Domínguez 69]
Junior      1-0  Tuluá
  [Emerson Acuña 61]
  [After this match one galery of the stadium fall down with two
   persons dead and other 35 injured]
Santa Fe    3-0  Magdalena
  [Lucas Jaramillo 18, Jader Rojas 24, Iván López 65]
Pasto       1-2  América
  [Oscar Martínez 51; Luis Cifuentes 13, José Moreno 15]
Tolima      1-1  Envigado
  [Rogeiro Pereira 64; Edison Aguilar 52pen]
Bucaramanga 1-1  Huila
  [Hernán Sarmiento 72; Miguel Rojas 78]
Pereira     1-0  Nacional
  [Carlos Castro 79]
Medellín    1-0  Once Caldas
  [William Vásquez 40]

Table:

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


Cuadrangulares

Final Tables:

Group A
 1.Deportivo Cali               6   3  3  0  10- 6  12  Qualified
 2.CD Millonarios               6   3  1  2   9- 7  10
 3.Unión Magdalena              6   2  3  1   7- 6   9
 4.Deportivo Pasto              6   0  1  5   4-11   1

Group B
 1.Deportes Tolima              6   3  1  2   8- 7  10  [4 away goals]  Qualified
 2.Atlético Junior              6   3  1  2   8- 7  10  [1 away goal]
 3.Atlético Nacional            6   3  0  3   8- 8   9
 4.CD Independiente Medellín    6   2  0  4   8-10   6

Round 1  [Nov 9]
Millonarios 1-0  Magdalena
  [Carlos Ortíz 33]
Pasto       0-1  Cali
  [Léider Preciado 26]
Junior      3-2  Medellín
  [Léiner Rolong 2, Lin Carlos Henry 26pen, José Amaya 83;
   Jorge Horacio Serna 22, 55]
Nacional    1-2  Tolima
  [Edixon Perea 6; Arley Dinas 24, Rogeiro Pereira 93]

Round 2  [Nov 22,23]
Cali        1-1  Millonarios
Medellín    1-2  Nacional
Tolima      1-1  Junior
Magdalena   1-0  Pasto

Round 3
[Nov 26]
Magdalena   0-0  Cali
Millonarios 1-0  Pasto
  [Martín Perezlindo 58]
[Nov 27]
Tolima      1-0  Medellín
  [Rogeiro Pereira 4]
Nacional    1-0  Junior
  [José Amaya 74]

Round 4
[Nov 29]
Cali        2-2  Magdalena
  [Carlos Castillo 23, Mayer Candelo 53; Carlos Vilarete 69, 87pen]
Junior      1-0  Nacional
  [José Amaya 74]
Medellín    2-0  Tolima
  [Róbinson Muñoz 12, Roberto Carlos Cortés 76]
[Nov 30]
Pasto       1-3  Millonarios
  [Hárold Viáfara 15; Martín Perezlindo 9, 47, Luis Zapata 76]

Round 5 
[Dec 6]
Junior      3-2  Tolima
  [Orlando Ballesteros 67, 88, Marcos Cardozo 94pen;
   Henry Zambrano 77, 84]
Nacional    4-2  Medellín
  [Martín Echeverría 15, Iván Velásquez 57, Aquivaldo Mosquera 69,
   Juan Ricaurte 84; Jorge Horacio Serna 51, Diego Alvarez 75]
[Dec 7]
Millonarios 2-3  Cali
Pasto       2-2  Magdalena

Round 6 [Dec 14]
Cali        3-1  Pasto
  [Léider Preciado 39pen, Elkin Murillo 59, Alvaro Domínguez 83;
   Omar Luis Valencia 50]
Magdalena   2-1  Millonarios
  [José Herrera 30, Carlos Vilarete 52; Julián Téllez 62]
Tolima      2-0  Nacional
  [Ricardo Ciciliano 47, 92]
Medellín    1-0  Junior
  [Ricardo Steer 55]

Final Tables:

Group A
 1.Deportivo Cali               6   3  3  0  10- 6  12  Qualified
 2.CD Millonarios               6   3  1  2   9- 7  10
 3.Unión Magdalena              6   2  3  1   7- 6   9
 4.Deportivo Pasto              6   0  1  5   4-11   1

Group B
 1.Deportes Tolima              6   3  1  2   8- 7  10  [4 away goals]  Qualified
 2.Atlético Junior              6   3  1  2   8- 7  10  [1 away goal]
 3.Atlético Nacional            6   3  0  3   8- 8   9
 4.CD Independiente Medellín    6   2  0  4   8-10   6

Topscorer:

Leider Preciado    Cali         16
Carlos Castillo    Cali         10
Rogeiro Pereira    Tolima       10
Julián Téllez      Millonarios  10


Championship Final

First Leg  [Dec 17]
Tolima      2-0  Cali
  [Rogeiro Pereira 51, 83]

Second Leg [Dec 21]
Cali        3-1  Tolima
  [Jorge Díaz 15, Léider Preciado 20, Elkin Murillo 39;
   Gerardo Bedoya 34og]
  [Tolima won 2-4 on penalties]

Tolima are Finalización 2003 champions.


Aggregate Table:

 1.Deportivo Cali              36  18  8 10  61-40  62  Copa Libertadores
 2.CD Millonarios              36  16  9 11  44-35  57
 3.América                     36  14 14  8  54-46  56
 4.Unión Magdalena             36  16  6 14  42-40  54
 5.CD Independiente Medellín   36  15  8 13  49-38  53
 6.Atlético Junior             36  15  8 13  43-45  53
 7.Once Caldas                 36  14 11 11  46-41  53
 8.Atlético Nacional           36  15  7 14  40-34  52
 9.Deportes Pereira            36  13 11 12  42-44  50
10.Atlético Huila              36  12 14 10  45-47  50
11.Deportes Tolima             36  13 10 13  46-41  49
12.Deportivo Pasto             36  12 11 13  35-37  47
13.Centauros Villavicencio     36  11 13 12  39-48  46
14.Atlético Bucaramanga        36  10 12 14  45-50  42
15.Independiente Santa Fe      36  10 12 14  30-36  42
16.Envigado FC                 36   9 13 14  38-44  40
17.Deportes Quindío            36   9 11 16  34-48  38
18.Corporación Tuluá           36   6 14 16  31-50  32

NB: relegated: Centauros villavicencio (average over past seasons)



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,338,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6948
Total Execution Time  0.6967
  CADENA URL  
/clausura_primera_b_colombia2003
  GET DATOS  
$_GET['/clausura_primera_b_colombia2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0146  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2003'
0.0298  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=197 AND type_rel = 3
0.0146  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.0149  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.0147  SELECT text_es as historical_text FROM leagues_text WHERE id=5391
0.0145  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 = 33866 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 18:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 18:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 18:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 18:10:02' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0152  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 = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0147  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (33866) 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.0152  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 (33866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0156  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (33866) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (33866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (33866) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (33866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (33866) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (33866) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0154  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 = 33866 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0150  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 = 33866 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0152  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 197 GROUP BY l.categoryId
0.0147  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=197 GROUP BY l.year ORDER BY l.year DESC
0.0157  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=33866 AND rel.round=18
0.0156  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 = 33866 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0154  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 = 33866 AND esl.points > 0
0.0148  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` = 33866 ORDER BY creation_date DESC LIMIT 0, 10
0.0157  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` = 33866
0.0149  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 `calendars2003` 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` = 33866 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events2003` e INNER JOIN calendars2003 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 = 33866 ORDER BY total DESC LIMIT 40
0.0148  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 `events2003` e INNER JOIN calendars2003 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 = 33866 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0147  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 `tables2003` 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 = 33866 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` 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 = 33866 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 33866 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=197
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 197 AND l.year = 2003 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=197 AND year=2003