Información Histórica
						

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: Roberto Lahsen
(rlahsen@entelchile.net),
Frank Ballesteros
f-balles@uniandes.edu.co)
and Mikael Jönsson
(mikaelj@mbox302.swipnet.se) 

Last updated: 25 Nov 1999

(C) Copyright Roberto Lahsen, Frank Ballesteros, Mikael Jönsson,
and RSSSF 1999
						

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,372,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5200
Total Execution Time  0.5219
  CADENA URL  
/apertura_colombia1998
  GET DATOS  
$_GET['/apertura_colombia1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0105  SELECT type FROM routes WHERE alias = 'apertura_colombia1998'
0.0217  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_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.0109  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=42 AND type_rel = 3
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 42 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108  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 (1308428,1308305,1308139,1308019,1307903) ORDER BY n.cover_points DESC, update_date DESC
0.0113  SELECT text_es as historical_text FROM leagues_text WHERE id=586
0.0111  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 = 28911 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0135  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=42 ORDER BY l.group_code ASC
0.0139  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=42 GROUP BY c.id ORDER BY c.order_id ASC
0.0109  SELECT type,rule FROM rules WHERE categoryId = 42 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 09:50:50' 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-29 09:50:50' 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=4 AND last_update > '2024-03-29 09:50:50' 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=3 AND last_update > '2024-03-29 09:50:50' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0121  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_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.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (28911) 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.0109  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 (28911) 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 (28911) 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 (28911) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (28911) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (28911) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (28911) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (28911) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0106  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 = 28911 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 = 28911 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0107  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=28911 AND rel.round=36
0.0106  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 = 28911 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0106  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 = 28911 AND esl.points > 0
0.0106  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 28911 ORDER BY creation_date DESC LIMIT 0, 10
0.0109  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 28911
0.0107  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` = 28911 AND c.`round` = 36 ORDER BY shedule ASC LIMIT 200
0.0104  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 = 28911 ORDER BY total DESC LIMIT 40
0.0107  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 = 28911 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0108  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 = 28911 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 28911 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 28911 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0108  SELECT data1, data2 FROM services_tags WHERE categoryId=42
0.0108  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 42 AND l.year = 1998 ORDER BY l.group_code ASC
0.0108  SELECT group_code, extraName from `leagues` WHERE categoryId=42 AND year=1998