Publicidad 600x120.gif
Apertura Primera B Colombia 1998
1997/1998

Apertura Primera B Colombia 1998

  • Primera B
Información Histórica
						Colombia 1998


Copa Mustang 
============

Championship Final

First Leg [Dec 16, Estadio Pascual Guerrero, Cali, att: 35,000]
Cali        4-0 Caldas
  [Bonilla (3), Castillo]

Second Leg [Dec 20, Estadio Palogrande, Manizales]
Caldas       -  Cali  

Possible Playoff [Dec 22]


First Stage
===========

(consists of 36 rounds: 30 normal rounds plus 6 rounds in the 'Cuadrangalarones')

Final Table:

 1.Once Caldas            36 21  4/6  5  66-34  77  Qualified for Copa Libertadores
 2.Atl. Nacional          36 17  7/4  8  63-35  69
 3.Indep. Santa Fé        36 17  6/5  8  48-32  68
 4.Dep. Indep. Medellín   36 16  4/8  8  51-29  64
 5.Dep. Cali              36 15  6/4 11  60-49  61
 6.CD América Cali        36 11 10/5 10  54-39  58
 7.Atl. Junior            36 11  8/6 11  51-55  55
 8.Atl. Huila             36 13  4/7 12  54-47  54
 9.Millonarios            36 11  6/8 11  42-43  53
10.Dep. Tolima            36  9 11/2 14  42-51  51
11.Dep. Quindío           36 11  4/8 13  43-47  49
12.Dep. Tuluá             36 10  5/7 14  42-59  47
13.Envigado FC            36 11  4/5 16  40-50  46
14.Atl. Bucaramanga       36 10  4/8 14  37-54  46 
15.Un. Magdalena          36  7  6/3 20  40-72  36
16.Dep. Unicosta          36  8  1/4 23  42-79  30

Round 1 [Feb 1]
Millonarios 1-2 Santa Fe
  [M:Maturana 38 SF: Precaido 73, Garces 87]
America     2-2 Cali        [4-2 pen]
  [A:Cardona 21, Tellez 44 C: Bonilla 13, Pareja 37]
Tolima      1-1 Caldas      [4-2 pen]
  [T:Ciciliano 39 C: Salcedo 45]
Magdalena   2-2 Junior      [4-5 pen]
  [M:Herrera 9,31 J: Galeano 14, Pacheco 31] 
Quindio     1-1 Huila       [4-2 pen]
  [Q: Palacio 20, H: Ambuila 53]
Medellin    0-0 Envigado    [5-4 pen]
Unicosta    0-1 Bucaramanga
  [G Restrepo 62]
Tulua       0-1 Nacional
  [Grisales 36]
  
Round 2 [Feb 4]
Nacional    4-1 Magdalena
  [N:Comas, Makenzie, Morantes, Moreno M:Labastidas]
Caldas      3-0 Cali
  [Galvan 2, Congo]
Envigado    1-0 Tolima
  [Suarez]
Huila       1-0 Tulua
  [Ambuila]
Bucaramanga 2-1 Medellin
  [B Restrepo, Vasquez M: Whitingham]
America     0-0 Quindio     [5-3 pen]
Junior      2-2 Millonarios [3-2 pen]
  [J: Botero, Reyes M: Cruz, Masquera]
Santa Fe    2-0 Unicosta
  [Mendez,Cuesta]

Round 3 [Feb 8]
Caldas      1-0 America
  [Velasquez 90]
Tulua       1-1 Quindio     [1-3 pen]
  [T: Ampudia 49pen Q: Sandoval 60]
Unicosta    2-3 Junior
  [U:Cantillo 71, Calanche 87 J: Tilger 46,49 Pacheco 62pen]
Millonarios 1-1 Nacional    [3-5 pen]
  [M:Cruz 83 N: Grisales 62]
Tolima      2-0 Bucaramanga
  [Arrieta 9. Ortiz 88]
Magdalena   0-3 Huila   
  [own goal (H Gonzalez 7) Ambuila 15 Ararat 68]
Medellin    1-1 Santa Fe    [2-4 pen]
  [M:Valencia 78 SF:Precaido 90]
Cali        4-2 Envigado
  [C:Bonilla 25pen 6pen, 84 Yepez 43 E: Benitez 13, Suarez 44pen]

Round 4 [Feb 15]
Huila       3-0 Millonarios
  [Aponza 40pen, Ambuila 67,74]
Quindio     0-0 Magdalena   [4-5 pen]
Bucaramanga 1-3 Cali
  [B: Galarcio 16 C: Bonilla 19pen, Escobar 45, Marrero 57pen]
Nacional    6-0 Unicosta
  [Comas 2,7 Osorio 55 Morantes 63 Castro 73, Grisales 74]
Junior      1-1 Medellin    [2-4 pen]
  [J: Villar 85 M: Hernandez 90]
America     1-1 Tulua       [3-1 pen]
  [A: Perez 37 T: Salazar 22]
Envigado    3-1 Caldas
  [E: Cardenas 14 , Da Silva 53,78 C: Congo 4]
Santa Fe    1-1 Tolima      [3-4 pen]
  [SF: Precaido 46 T: Torres 19]

Round 5 [Feb 18,19]
Millonarios 1-1 Quindio     [3-4 pen]
  [M:Usuriaga 23 Q:Palacio 50]
Unicosta    0-2 Huila
  [Ararat 74, 88]
Magdalena   1-1 Tulua       [6-5 pen]
  [M:Otero 22pen T: Braidy 10]
Cali        4-1 Santa Fe
  [C:Bonilla 19pen, Ojeda 57,59 Escobar 62 SF: Gutierrez 80]
Medellin    0-0 Nacional    [2-4 pen]
Caldas      3-0 Bucaramanga
  [Galvan 45, Valentierra 74pen, Congo 76]
Tolima      2-2 Junior      [7-6 pen]
  [T:Berrio 60, A Moreno 78 J: Pacheco 88, Tilger 89]
Envigado    0-2 America
  [Norberto Hurtado 69, Oviedo 89]

Round 6 [Feb 22]
Santa Fe    0-0 Caldas      [4-2 pen]
Quindio     4-2 Unicosta
  [Q:Palacio 39, Gomez 41, 66 Oliveiros 88 U: Cantillo 32,37]
Bucaramanga 2-2 Envigado    [4-2 pen]
  [B:Guiran 6, G Restrepo 55pen E: Da Silva 25,90]
America     2-0 Magdalena
  [Moreno 18pen, Cardona 27]
Tulua       0-0 Millonarios [4-2 pen]
Huila       1-2 Medellin
  [H:Ambuila 21 M: Guzman 61, Valencia 63]
Nacional    1-0 Tolima 
  [Comas 20]
Junior      1-4 Cali        [Mar 6]
  [J:Miranda 70; C: Walter Escobar 25, Victor Bonilla 61, 'Pelusa' Perez 71, Giovanni Cordoba 82]

Round 7 [Mar 1]
Millonarios 0-0 Magdalena   [2-3 pen]
Envigado    3-1 Santa Fe
  [E: Suarez 6,31pen Arriaga 84 SF: Precaido 21]
Bucaramanga 1-1 America     [8-9 pen]
  [B: Caquete 30 A: Perez 85]
Tolima      1-0 Huila
  [Berrio 12]
Unicosta    2-0 Tulua       
  [Rendon 51 pen, Cantillo 89]
Caldas      1-0 Junior   
  [Salcedo 46]
Medellin    2-0 Quindio    
  [Whitingham 18pen Hernandez 48]
Cali        2-2 Nacional    [1-3 pen]
  [C:Bonilla 46, Betancurt 72 N: Grisales 25, Comas 86]

Round 8 [Mar 15]
Santa Fe    4-0 Bucaramanga
  [Precaido 10,84 Lopez 55, Villamizar 79]
Junior      0-0 Envigado    [3-4 pen]
Nacional    2-2 Caldas      [6-5 pen]
  [N:Morantes 59,65 C: Valentierra 11pen, Salcedo 46]
Huila       3-1 Cali
  [H: Molina 25, Ambuila 39, Sandoval 57 C: Escobar 28]
Quindio     2-1 Tolima
  [Q.Gomez 50, Hernandez 67 pen T:Cassiani 77]
Tulua       0-0 Medellin    [3-5 pen]
Magdalena   1-2 Unicosta
  [M:Otero 79pen U: Calanche 15,45]
America     3-0 Millonarios
  [Hurtado 41pen, Gonzalez 57, Telelz 67]

Round 9 [Mar 22]
Santa Fe    0-0 America     [1-3 pen]
Bucaramanga 1-0 Junior
  [Gomez 16]
Envigado    1-5 Nacional
  [E:Cortes 36 N: Comas 24, Mackenzie 59, Zambrano 65, Marulanda 71,Vasquez 85]
Caldas      2-1 Huila
  [C:Cardona 55, Congo 61 H: Sandoval 63pen]
Cali        3-1 Quindio
  [C: Bonilla 36pen,75,77pen Q: Hernandez 11]
Tolima      2-1 Tulua
  [Tol:own goal (Molina) 2, Becerra 69 Tul: Quinonez 85]
Medellin    3-1 Magdalena
  [M:Nunez 6,79 Valencia 66 U: Herrera 71]
Unicosta    1-3 Millonarios
  [U: Rendon 45pen M: Mosquera 10, Aponte 40pen, Usuriaga 77]

Round 10 [Mar 29]
Junior      2-1 Santa Fe 
  [J: Pacheco 41, Castro 88 SF: Angulo 43]
Nacional    1-0 Bucaramanga
  [Zambrano 77]
Huila       2-1 Envigado
  [H: Sandoval 48, Ambuila 67 E:Suarez 49]
Quindio     1-0 Caldas
  [Oliveros 70]
Tulua       1-1 Cali        [3-4 pen]
  [T: Molina 51pen C: Ojeda 70]
Magdalena   1-0 Tolima
  [Herrera 61]
Millonarios 3-3 Medellin    [4-2 pen]
  [M: Maturana 21,46 Quijano 78 M: Valencia 36,65, Ramirez 51]
America     6-0 Unicosta
  [Angulo 7,55 Hurtado 23, Perez 27, 53 Asprilla 65]

Round 11 [Apr 5]
Junior      2-1 America
  [J: Vilarete 65, 83 A: Moreno 41]
Santa Fe    2-1 Nacional
  [SF:Precaido 43,90 N:Munoz 80]
Bucaramanga 2-0 Huila
  [Flavien 12, Ballesteros 64]
Envigado    2-1 Quindio
  [E: Da Silva 38, Suarez 49pen Q: Marquinho 80]
Caldas      7-0 Tulua
  [Congo 3,40 Salcedo 9,47,51 Quienca 24,41]
Cali        2-1 Magdalena  
  [C: Yepez 28, Bonilla 83 U. Zamora 41]
Tolima      1-0 Millonarios
  [Becerra 66pen]
Medellin    5-0 Unicosta
  [Valencia 10, 75 Nunez 15, 51, 66]

Round 12 [Apr 8]
America     1-1 Medellin    [3-1 pen]
Magdalena   2-2 Caldas      [5-3 pen]
Millonarios 2-1 Cali 
Nacional    5-0 Junior
  [Zambrano 30, Cassiani 38, MacKenzie 45, Osorio 74, Comas 86]
Huila       2-2 Santa Fe    [3-1 pen]
Quindio     5-1 Bucaramanga
Tulua       2-1 Envigado
Unicosta    2-1 Tolima
  [U: Matallana 31, Suarez 35 T: Moreno 37]

Round 13 [Apr 12]
Bucaramanga 1-1 Tulua       [5-6 pen]
  [B: Ballesteros 83 T: Ampudia 8]
Caldas      1-1 Millonarios [5-3 pen]
  [C:Otero 9 M: Maturano 79]
Cali        2-1 Unicosta
  [C: Marrero 69pen, Escobar 74 U: Cantillo 24]
Envigado    1-2 Magdalena
Junior      2-0 Huila
  [Pacheco 23, Villar 78]
Nacional    3-1 America
  [N:Comas 34, Zambrano 50. Mackenzie 71 A: Angulo 81]
Santa Fe    2-0 Quindio    
  [Precaido 65,80]
Tolima      1-0 Medellin  
  [Matosas 42]

Round 14 [Apr 19]
Tulua       2-1 Santa Fe  
  [T: Zea 32, Sanclemente 62 SF: Cano 25]
Quindio     0-0 Junior      [2-4 pen]
Medellin    1-2 Cali
  [M: Valencia 50pen C: Marrero 15, 47 pen]
Millonarios 3-0 Envigado
  [Cruz 39, Ramirez 44, Maturana 84]
Huila       1-1 Nacional    [4-3 pen]
  [H: Comas 25pen N: Ambuila 65pen]
Magdalena   2-1 Bucaramanga
  [U:Herrera 68,74 B: Gomez 85]
Unicosta    1-2 Caldas 
  [U: Hernandez 90 C: Galvan 51, 86]
America     0-1 Tolima      [stopped Apr 19 due to bad light, finished Apr 20]
  [Moreno]

Round 15 [Apr 26]
Bucaramanga 2-2 Millonarios [3-4 pen]
  [B:Ballesteros 8,18 M: Daza 6, Ramirez 46]
Envigado    1-0 Unicosta
  [Catano 90]
Caldas      2-0 Medellin 
  [Congo 18, Cardona 47]
Junior      2-1 Tulua    
  [J: Villar 50, Tilger 75pen T: Carvajal 10]
Huila       3-1 America
  [H:Gomez 25, Ararat 47 A: Ramos 78]
Santa Fe    0-0 Magdalena   [3-5 pen]
Nacional    2-0 Quindio
  [Grisales  51, Mackenzie 78pen]
Cali        1-0 Tolima
  [Marrero 45]

Round 16 [May 3] [also round 1 Cuadrangalarones]
Santa Fe    2-1 Huila
  [S: Portocarrero 19, Cano 55 H: Ambuila 20]
Tulua       1-0 America
  [Quintana 67]
Cali        5-0 Quindio
  [Bonilla 23,90pen Candelo 56, Marrero 72, Diaz 84]
Tolima      0-0 Millonarios [4-3 pen]
Medellin    1-1 Caldas      [4-3 pen]
  [M:Valencia 90 C:Valentierra 14]
Envigado    0-0 Nacional    [4-5 pen]
Bucaramanga 2-0 Unicosta
  [Ballesteros 29, Casquete 56]
Junior      2-1 Magdalena
  [J: Vilarete 55, Tilger 58pen M: Trujillo 56]

Round 17 [May 8-10] [also round 2 Cuadrangalarones]
Millonarios 2-2 Santa Fe    [0-3 pen] [May 6]
  [M: Gustavo Quijano 32, Marcio Cruz 77  SF: Leider Precaido 58,71]
Huila       2-2 Tolima      [10-9 pen]
Unicosta    1-1 Junior      [5-4 pen]
Quindio     4-2 Tulua
Nacional    2-2 Medellin    [4-1 pen]
Magdalena   1-3 Bucaramanga
Caldas      0-0 Envigado    [4-3 pen]
America     3-1 Cali

Round 18 [May 13] [also round 3 Cuadrangalarones]
Quindio     1-0 America
Cali        1-3 Tulua
Nacional    3-1 Caldas
Envigado    0-3 Medellin
Huila       1-2 Millonarios
Santa Fe    3-0 Tolima
Unicosta    7-1 Magdalena
Bucaramanga 1-1 Junior      [2-4 pen]

Round 19 [May 17] [also round 4 Cuadrangalarones]
America     1-1 Quindio     [4-2 pen]
Tolima      0-1 Santa Fe 
Millonarios 2-2 Huila       [5-4 pen]
Junior      2-2 Bucaramanga [5-4 pen]
Caldas      1-0 Nacional
Magdalena   1-1 Unicosta    [4-3 pen]
Medellin    1-0 Envigado
Tulua       0-2 Cali

Round 20 [May 22-24] [also round 5 Cuadrangalarones]
America     1-1 Tulua       [5-4 pen]
Caldas      2-1 Medellin
Millonarios 2-1 Tolima
Unicosta    2-2 Bucaramanga [3-4 pen]
Nacional    2-2 Envigado    [1-3 pen]
Quindio     4-1 Cali
Magdalena   4-6 Junior 
Huila       2-1 Santa Fe 

Round 21 [May 28] [also round 6 Cuadrangalarones]
Envigado    0-1 Caldas  
  [Congo 69]
Medellin    2-0 Nacional  
  [Nunez 30, 48]
Tulua       2-1 Quindio 
  [T: Ampudia 7pen, J C Martinez 29 Q: Hernandez 64]
Tolima      2-2 Huila       [5-4 pen]
  [ T: Dinas 7, Berrio 90 H: Ararat 33pen, A Torres 85 pen]
Santa Fe    2-0 Millonarios
  [Cano 18,79]
Cali        0-0 America     [4-5 pen]
Junior      4-0 Unicosta  
  [Vilarete 11pen, Tilger 16, Pacheco 51pen, Castro 61]
Bucaramanga 0-0 Magdalena   [7-6 pen]

Round 22 [Jul 19-22]
Santa Fe    0-0 Millonarios [2-4 pen]
Junior      4-1 Magdalena
  [J:Carlos Vilarete 7,38 Victor Miranda 57, Victor Pacheco 86 
   UM: Luis Zuleta 25]
Nacional    3-0 Tulua      
  [John Jayler Moreno, Oswaldo MacKenzie, Henry Zamorano]
Caldas      5-2 Tolima
  [C: Oswaldo Otero, Fabio Hincapie, Alexander Lemus, Edwin Congo,    
   Christopher Moreno T:Freddy Torres, Areil Beltrano]
Huila       1-0 Quindio     
  [Julian Fernandez]
America     1-1 Cali        [3-4 pen]
  [A: Leonardo Moreno C: Jairo Ampudia]
Envigado    0-1 Medellin
  [Giovanni Hernandez 58]
Unicosta    0-2 Bucaramanga

Round 23 
Cali        2-3 Caldas
Tulua       3-0 Huila
Magdalena   2-1 Nacional
Millonarios 0-0 Junior      [4-2 pen]
Unicosta    0-0 Santa Fe    [1-3 pen]
Medellin    3-0 Bucaramanga
Quindio     0-0 America     [3-2 pen]
Tolima      2-0 Envigado    [played later]

Round 24 [Jul 29]
Nacional    4-1 Millonarios 
America     2-2 Caldas      [4-1 pen]
Junior      0-1 Unicosta 
Envigado    0-0 Cali        [4-5 pen]
Santa Fe    1-0 Medellin 
Huila       2-0 Magdalena 
Bucaramanga 1-1 Tolima      [2-4 pen]
Quindio     2-1 Tulua 

Round 25 [Aug 1,2]
Magdalena   2-0 Quindio  
Millonarios 0-0 Huila       [3-1 pen]
Cali        1-1 Bucaramanga [6-5 pen]
Caldas      2-0 Envigado
Unicosta    0-3 Nacional
Medellin    0-0 Junior      [4-5 pen]
Tulua       2-2 America     [4-2 pen]
Tolima      0-0 Santa Fe    [2-3 pen; played later]

Round 26 [Aug 9]
America     2-0 Envigado
Bucaramanga 0-1 Caldas   
Junior      1-2 Tolima
Nacional    1-0 Medellin    [played later]
Huila       3-1 Unicosta
Quindio     1-0 Millonarios [played later]
Santa Fe    2-0 Cali
Tulua       1-1 Magdalena   [4-1 pen]

Round 27 [Aug 16] 
Caldas      2-0 Santa Fe   
Cali        1-1 Junior      [5-3 pen]
Envigado    3-0 Bucaramanga 
Magdalena   1-2 America 
Medellin    3-0 Huila   
Millonarios 1-2 Tulua 
Tolima      2-2 Nacional    [3-2 pen]
Unicosta    4-2 Quindio   

Round 28 [Aug 23]
Nacional    1-0 Cali  
America     5-2 Bucaramanga
Tulua       2-0 Unicosta
Junior      3-2 Caldas    
Santa Fe    1-0 Envigado
Huila       1-1 Tolima      [3-4 pen]
Quindio     0-1 Medellin
Magdalena   0-1 Millonarios

Round 29 [Aug 30]
Millonarios 2-0 America  
Cali        4-2 Huila  
Medellin    5-1 Tulua
Caldas      1-1 Nacional    [3-2 pen]
Unicosta    7-2 Magdalena
Tolima      2-4 Quindio
Bucaramanga 0-3 Santa Fe
Envigado    4-2 Junior 

Round 30 [Sep 3]
Millonarios 2-0 Unicosta
America     1-2 Santa Fe
Magdalena   0-1 Medellin
Huila       1-2 Caldas    
Tulua       2-2 Tolima      [3-4 pen]
Nacional    1-2 Envigado
Quindio     0-2 Cali  
Junior      1-0 Bucaramanga

Round 31 [Sep 6]
Medellin    1-0 Millonarios
Cali        2-2 Tulua       [2-3 pen]
Tolima      2-0 Magdalena
Caldas      1-0 Quindio
Envigado    1-1 Huila       [4-3 pen]
Bucaramanga 1-0 Nacional   
Unicosta    2-1 America
Santa Fe    2-1 Junior     

Round 32 [Sep 10]
Huila       0-0 Bucaramanga [4-1 pen]
Quindio     1-1 Envigado    [2-3 pen]
Tulua       2-5 Caldas    
Magdalena   1-0 Cali  
Millonarios 4-1 Tolima
Unicosta    0-2 Medellin
America     1-1 Junior      [5-6 pen]
Nacional    1-0 Santa Fe

Round 33 [Sep 13]
Cali        0-2 Millonarios
Medellin    0-3 America
Caldas      2-1 Magdalena
Tolima      3-3 Unicosta    [4-2 pen]
Bucaramanga 1-1 Quindio     [4-2 pen]
Santa Fe    1-1 Huila       [4-2 pen]
Envigado    2-0 Tulua  
Junior      0-1 Nacional   

Round 34 [Sep 20]
America     2-0 Nacional
Unicosta    0-3 Cali
Tulua       1-0 Bucaramanga 
Millonarios 1-0 Caldas
Huila       4-0 Junior 
Quindio     2-0 Santa Fe
Magdalena   5-2 Envigado  
Medellin    1-0 Tolima

Round 35
Cali        1-1 Medellin    [9-8 pen]
Caldas      2-0 Unicosta  
Bucaramanga 2-0 Magdalena
Junior      1-1 Quindio     [3-2 pen]
Nacional    1-4 Huila   
Tolima      3-3 America     [5-4 pen]
Envigado    3-0 Millonarios
Santa Fe    2-0 Tulua

Round 36
Millonarios 1-2 Bucaramanga
America     3-1 Huila   
Quindio     1-1 Nacional    [3-4 pen]
Tulua       3-1 Junior
Unicosta    0-2 Envigado
Medellin    2-2 Caldas      [2-3 pen]
Tolima      0-1 Cali
Magdalena   2-3 Santa Fe

Final Table:

 1.Once Caldas            36 21  4/6  5  66-34  77  Qualified for Copa Libertadores
 2.Atl. Nacional          36 17  7/4  8  63-35  69
 3.Indep. Santa Fé        36 17  6/5  8  48-32  68
 4.Dep. Indep. Medellín   36 16  4/8  8  51-29  64
 5.Dep. Cali              36 15  6/4 11  60-49  61
 6.CD América Cali        36 11 10/5 10  54-39  58
 7.Atl. Junior            36 11  8/6 11  51-55  55
 8.Atl. Huila             36 13  4/7 12  54-47  54
 9.Millonarios            36 11  6/8 11  42-43  53
10.Dep. Tolima            36  9 11/2 14  42-51  51
11.Dep. Quindío           36 11  4/8 13  43-47  49
12.Dep. Tuluá             36 10  5/7 14  42-59  47
13.Envigado FC            36 11  4/5 16  40-50  46
14.Atl. Bucaramanga       36 10  4/8 14  37-54  46 
15.Un. Magdalena          36  7  6/3 20  40-72  36
16.Dep. Unicosta          36  8  1/4 23  42-79  30

As winners of the first stage, Once Caldas qualify for the Copa Libertadores 1999.

Cuadrangalarones [Rounds 16-21]

Group A
 1.Indep. Santa Fé         6  4  1/0  1  11- 5  14
 2.Millonarios             6  2  1/2  1   8- 8  10
 3.Atl. Huila              6  1  1/2  2  10-11   7
 4.Dep. Tolima             6  0  2/1  3   5-10   5

Group B
 1.Dep. Quindío            6  3  0/1  2  11-11  10
 2.Dep. Tuluá              6  3  0/1  2   9- 9  10
 3.CD América Cali         6  1  3/0  2   5- 5   9
 4.Dep. Cali               6  2  0/1  3  10-10   7

Group C
 1.Dep. Indep. Medellín    6  3  1/1  1  10- 5  12
 2.Once Caldas             6  3  1/1  1   6- 5  12
 3.Atl. Nacional           6  1  2/1  2   7- 8   8
 4.Envigado FC             6  0  1/2  3   2- 7   4

Group D
 1.Atl. Junior             6  3  2/1  0  16- 9  14
 2.Atl. Bucaramanga        6  2  2/2  0  10- 6  12
 3.Dep. Unicosta           6  1  1/2  2  11-11   7
 4.Un. Magdalena           6  0  1/1  4   8-19   3




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 cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
4,352,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5196
Total Execution Time  0.5216
  CADENA URL  
/apertura_primera_b_colombia1998
  GET DATOS  
$_GET['/apertura_primera_b_colombia1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0107  SELECT type FROM routes WHERE alias = 'apertura_primera_b_colombia1998'
0.0224  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0110  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=196 AND type_rel = 3
0.0117  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.0114  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.0109  SELECT text_es as historical_text FROM leagues_text WHERE id=5380
0.0108  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 = 33855 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0109  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.0114  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.0109  SELECT type,rule FROM rules WHERE categoryId = 196 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 10:49:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 10:49:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 10:49:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 10:49:09' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0117  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 = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (33855) 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.0106  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 (33855) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (33855) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (33855) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (33855) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (33855) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (33855) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (33855) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  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 = 33855 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 33855 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0110  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=33855 AND rel.round=36
0.0112  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 = 33855 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0116  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 = 33855 AND esl.points > 0
0.0114  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-02-27" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 33855 ORDER BY creation_date DESC LIMIT 0, 10
0.0135  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-02-27" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 33855
0.0120  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 `calendars1998` 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` = 33855 AND c.`round` = 36 ORDER BY shedule ASC LIMIT 200
0.0107  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 `events1998` e INNER JOIN calendars1998 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 = 36 AND e.real_date IS NOT NULL AND e.league_id = 33855 ORDER BY total DESC LIMIT 40
0.0112  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 `events1998` e INNER JOIN calendars1998 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 = 33855 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0111  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 `tables1998` 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 = 33855 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 33855 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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-03-28 00:00:00' AND c.`shedule` < '2024-04-01 23:59:59' AND l.id = 33855 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0111  SELECT data1, data2 FROM services_tags WHERE categoryId=196
0.0111  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 196 AND l.year = 1998 ORDER BY l.group_code ASC
0.0111  SELECT group_code, extraName from `leagues` WHERE categoryId=196 AND year=1998