Publicidad 600x120.gif
Clausura Primera B Colombia 2001
2000/2001

Clausura Primera B Colombia 2001

  • Primera B
Información Histórica
						
Colombia 2001


Torneo Mustang II  (Aug 5-Nov 11)

Final Table:

 1.Once Caldas        22 12  7  3  36-16  43  Copa Libertadores 2002
 2.CD Millonarios     22 11  4  7  37-31  37
 3.Atlético Nacional  22 10  7  5  30-18  37
 4.Deportivo Cali     22 10  6  6  34-25  36
 5.América            22 10  5  7  31-23  35
 6.Deportivo Pasto    22  9  8  5  21-27  35
 7.Envigado FC        22  9  6  7  37-36  33
 8.Deportes Tolima    22  8  8  6  28-24  32
 9.Independ Santa Fe  22  9  2 11  29-29  29
10.CD Indep Medellín  22  8  5  9  24-23  29
11.Deportes Pereira   22  7  5 10  19-31  26
12.Atlético Júnior    22  6  7  9  27-29  25
13.Corporación Tuluá  22  5  8  9  23-28  23
14.Real Cartagena     22  4  9  9  20-31  21
15.Atlético Huila     22  5  5 12  20-36  20
16.Atl Bucaramanga    22  4  6 12  17-26  18

Round 1  
[Aug 5]
Santa Fe     3-1  Cali
  [Jaramillo 41, 61, Núñez 64; Córdoba 25]
América      0-1  Millonarios
  [Jair Ramírez 45]
Tolima       2-0  Pasto
  [Saams 26, Arrieta 68]
Once Caldas  4-1  Envigado
  [Valentierra 32pen, 66pen, Gallo 77, 84; Estrada 79]
Bucaramanga  0-0  Pereira
Nacional     1-1  Cartagena
  [Salazar 57; Guzmán 52og]
Tuluá        1-1  Huila
  [Díaz 15; Perea 77]
[Aug 29]
Junior	     0-0  Medellín

Round 2
[Aug 12]
Envigado     2-1  Junior
  [Cortés 5, 70; Ballesteros 73]
Millonarios  1-1  Tolima
  [Cruz 26; Ciciliano 52]
Cali	     2-1  América
  [Rivera 26, 51; Zapata 32]
Pereira      0-1  Once Caldas
  [Galván 6]
Cartagena    0-0  Bucaramanga
Pasto	     2-1  Tuluá
  [Rentería 46, Jaramillo 70; Hernández 49]
Huila	     3-2  Santa Fe
  [Hernández 20, Perea 74, 91; Núñez 71pen, 84]
[Sep 6]
Medellín     4-3  Nacional
  [Serna 10, 20, 82, Vásquez 63; Restrepo 22, Velásquez 51, Salazar 88]

Round 3
[Aug 18]
Once Caldas  3-0  Cartagena
  [Galván 4, Zapata 64og, Gallo 72]
[Aug 19]
Santa Fe     2-1  Tuluá
  [Molina 35, 41; Londoño 2]
Tolima	     1-3  Cali
  [Vidal 50; Bonilla 35, Patiño 47, Córdoba 94]
Pasto	     2-1  Millonarios
  [Charria 26, Matallana 58; Gutiérrez 66]
Junior	     3-1  Pereira
  [Rojano 22, Arriaga 30, Vilarete 80; Castillo 82pen]
Medellín     1-1  Envigado
  [Jaramillo 93; Cortés 18]
Bucaramanga  0-1  Nacional
  [O.Restrepo 24]
América      1-1  Huila
  [Castillo 39; Córdoba 19]

Round 4 [Aug 22]
Santa Fe     2-0  América
  [Díaz 74, Molina 93]
Tuluá	     1-3  Millonarios
  [Pereira 70; Castro 20, Rivera 42, Rentería 78]
Cali	     1-1  Pasto
  [Patiño 14; Jaramillo 18]
Huila	     0-2  Tolima
  [Rivas 17, 82]
Nacional     2-0  Envigado
  [Velásquez 16, Salazar 24]
Pereira      0-2  Medellín
  [Serna 87, 89]
Cartagena    1-1  Junior
  [Rodríguez 74; Arriaga 56]
Bucaramanga  1-3  Once Caldas
  [Segura 48; Valentierra 45, Galván 73, 94]

Round 5
[Aug 26]
Once Caldas  3-2  Nacional
  [Galván 78, 84, Díaz 40; Mosquera 53, Restrepo 88]
Junior       0-0  Bucaramanga
Envigado     4-0  Pereira
  [Aguilar 3, Giraldo 27, Moreno 53, 65]
Millonarios  1-4  Cali
  [Castro 80; Rivera 29, Murillo 40, García 52, Aristizábal 63]
Tolima       0-0  Santa Fe
Pasto        0-0  Huila
Medellín     3-1  Cartagena
  [Serna 45, 52, Cortés 84; Torres 12]
[Sep 6]
América      0-0  Tuluá

Round 6
[Sep 2]
Huila        0-2  Millonarios
  [Castro 87, Jiménez 89]
Santa Fe     0-1  Pasto
  [Charria 26]
Tuluá        3-2  Cali
  [Rogeiro 9, Sacramento 41, Barahona 93; Bonilla 63, Córdoba 82]
América      2-1  Tolima
  [Vargas 37, Ferreira 65; Banguero 68]
Nacional     0-0  Pereira
Bucaramanga  2-1  Medellín
  [Núñez 41, Rivas 57; Benítez 72]
Cartagena    1-1  Envigado
  [Torres 55pen; Hernández 58]
Once Caldas  2-0  Junior
  [Galván 31, Valentierra 58pen]

Round 7
[Sep 9]
Millonarios  3-1  Santa Fe
  [Castro 31, 60, 71; Molina 40]
Envigado     2-1  Bucaramanga
  [Moreno 47, Mosquera 57; Núñez 21]
Pasto        1-0  América
  [Jaramillo 62]
Junior       0-0  Nacional
Cali         0-1  Huila
  [García 77]
Tolima       2-2  Tuluá
  [Cardona 67, 69pen; Rodríguez 83, Díaz 93]
Pereira      2-1  Cartagena
  [Benalcázar 59, Cardona 81; Henry 18]
Medellín     1-1  Once Caldas
  [Serna 48; Díaz 57]

Round 8 [Sep 13]
Cali         1-0  Bucaramanga
  [Aristizábal 26]
Cartagena    2-2  Pasto
  [Hurtado 1, 51; Jaramillo 45, Rendón 86]
Nacional     2-0  Tolima
  [Agudelo 25, Salazar 57]
Tuluá        1-2  Júnior
  [Pereira 32; Ramírez 21, Marquinho 67]
Envigado     1-2  América
  [Giraldo 41; Romero 5, Vásquez 79]
Millonarios  1-1  Once Caldas
  [Rentería 47; Caicedo 10]
Pereira      1-0  Santa Fe
  [Benalcázar 16]
Huila        1-0  Medellín
  [García 56]

Round 9 [Sep 16]
Santa Fe     2-2  Millonarios
  [Preciado 21, 58pen; Castro 64pen, Rentería 82]
Pasto        1-1  Cali
  [Jaramillo 63; Murillo 11]
Medellín     2-0  Cartagena
  [Serna 5, Montoya 40]
América      4-2  Tuluá
  [Vásquez 5pen, 74, Zapata 81, Ferreira 88; E.Díaz 73, 87]
Junior       2-3  Tolima
  [Escobar 24, Zuleta 89; Ciciliano 21, 26, 33]
Huila        1-0  Nacional
  [Velandia 84pen]
Bucaramanga  0-1  Pereira
  [Castillo 48]
Once Caldas  5-1  Envigado
  [Díaz 32, 63, Gallo 50, Valentierra 87, Echeverry 90; Moreno 6]

Round 10 [Sep 19]
Nacional     1-0  Junior
  [Restrepo 39]          
Tolima       1-0  América
  [Ciciliano 91pen]
Tuluá        0-0  Once Caldas     
Envigado     2-0  Santa Fe
  [Leal 65pen, Gómez 86]
Millonarios  3-1  Bucaramanga
  [Cruz 5, Rentería 32, Castro 78pen; Rivas 23]
Pereira      1-2  Pasto
  [Moreno 58; Londoño 66, Charria 92]
Cali         1-0  Medellín
  [Hernández 87]
Cartagena    1-0  Huila
  [Hurtado 20]

Round 11 [Sep 23]
Cartagena    2-2  Nacional
  [Segura 8, 23; Restrepó 25, Salazar 55]
Huila        1-1  Cali
  [Velandia 85; Córdoba 49]
Medellín     3-2  Pereira
  [Alvarez 31, Martínez 44, Montoya 93pen; Moreno 30, Benalcázar 70]
Pasto        1-0  Millonarios
  [Rendón 13]
Bucaramanga  2-3  Envigado
  [Rivas 49, Casquete 61; Moreno 30, Mosquera 56, Agustinho 78]
Santa Fe     1-0  Tuluá
  [Preciado 51]
Once Caldas  4-0  Tolima
  [Valentierra 36, Galván 68, 89, García 72og]
América      2-4  Junior
  [Neira 55, 68; Pérez 21, Marquinho 27, Rojano 70, Arzuága 87]

Round 12
[Sep 29]
Millonarios  2-0  Medellín
  [Viáfara 47, Guerra 53]
Tuluá        1-0  Bucaramanga
  [Díaz 87]
[Sep 30]
Cali         2-1  Cartagena
  [Aristizábal 15pen, Rivera 48; Valencia 75]
Junior       1-1  Once Caldas
  [Ramírez 9; Valentierra 90pen]
Pereira      3-1  Huila
  [Chará 1, Castillo 67pen, Cardona 72; Velandia 81]
Tolima       3-1  Santa Fe
  [Saams 36, Cambindo 43, Cardona 75pen; Preciado 60]
Nacional     0-0  América
Envigado     3-4  Pasto
  [Agostinho 8, 58, Leal 92pen; Rendón 24, Charria 43, 60, Jaramillo 66]

Round 13 [Oct 3]
Cali         3-1  Nacional
  [Córdoba 4pen, Mina Polo 29, 88; Velásquez 64]
Bucaramanga  0-0  Tolima
Pasto        1-1  Tuluá
  [Rendón 47; Muñoz 57]
Santa Fe     1-0  Junior
  [Molina 91]
Huila        1-3  Millonarios
  [Velandia 8; Toro 21, Orrego 89, Castro 92]
Once Caldas  1-3  América
  [Soto 92; Vásquez 68, Ferreira 82, 85]
Cartagena    0-0  Pereira
Envigado     2-1  Medellín
  [Moreno 39, Agustinho 73; Alvarez 47]

Round 14
[Oct 5]
Nacional     2-0  Once Caldas
  [Agudelo 21, Salazar 46]
[Oct 11]
Millonarios  3-0  Cartagena
  [Castro 9, 62, Asprilla 17]
América      2-1  Santa Fe
  [Vásquez 34, 70; Preciado 58]
Tolima       5-0  Pasto
  [Rivas 21, Peña 42, Becerra 55, Castro 69, 87]
Pereira      0-3  Cali
  [Vallejo 22, Mina Polo 43, 78]
Envigado     2-0  Huila
  [Agostinho 39, Cortés 91]
Junior       2-1  Bucaramanga
  [Arzuaga 13, Zuleta 85; Rivas 60].
Tuluá        0-0  Medellín

Round 15 [Oct 14] 
Cali         3-1  Millonarios
  [Mina 19, 47, Mera 78; Castro 42]
Santa Fe     2-1  Once Caldas
  [Preciado 40, 48pen; Galván 30]
Medellín     2-0  Tolima
  [Serna 56, Cataño 61]
Pereira      3-2  Nacional
  [Castillo 46, Cardona 72, Benalcázar 92; Velásquez 81, Hurtado 83]
Cartagena    0-0  Envigado
Pasto        1-0  Junior
  [Vieira 25]
Huila        2-0  Tuluá
  [García 31, M.Rojas 71]
Bucaramanga  0-1  América
  [Vargas 87]

Round 16
[Oct 17]
Millonarios  3-0  Pereira
  [Rentería 28, 38, Castro 41]
Nacional     3-1  Santa Fe
  [Velásquez 38, Mosquera 76, Salazar 83; Herrera 43] 
Envigado     2-1  Cali
  [Trujillo 56, Giraldo 85; Mera 40]
Once Caldas  1-1  Bucaramanga
  [Valentierra 28pen; Flavién 32]
Junior       2-1  Medellín
  [Marquinho 59pen, Zambrano 66; Serna 74]
Tolima       0-0  Huila
Tuluá        3-1  Cartagena
  [Rodríguez 17, Díaz 25, Rogeiro 55; Ramos 22]
[Oct 18]
América      3-0 Pasto 
  [Vásquez 39, 65, Ferreira 73]

Round 17 [Oct 21] 
Millonarios  0-2 Nacional
  [Calle 26, Hurtado 53]
Pereira      2-1 Envigado 
  [Benalcázar 12, Moreno 61; Muñoz 74]
Cali         2-2 Tuluá
  [Córdoba 67, Salazar 81; Pereira 7, Tovar 84]
Cartagena    1-2 Tolima
  [Segura 32; Rodas 21, Becerra 70]
Huila        2-4 Junior
  [Guirán 67, García 88; Zambrano 10, 19, Arzuaga 62, Rojano 81]
Medellín     2-1 América
  [Montoya 82, Alvarez 88; Romero 76]
Pasto        0-0 Once Caldas
Bucaramanga  1-0 Santa Fe 
  [Flavién 51]

Round 18 [Oct 24]
Santa Fe     2-0  Pasto
  [Preciado 19, Moreno Murillo 55]
Envigado     6-3  Millonarios
  [Giraldo 40, Rivera 66og, Agustinho 80, Leal 83pen, Gomez 89, Mosquera 92;
   Pérez 33, Castro 75, Orrego 79]
Tolima       2-2  Cali
  [Cardona 13pen, 20pen; Mina Polo 33, 41]
Once Caldas  1-0  Medellín
  [Galván 24]
Junior       1-3  Cartagena
  [Marquinho 84pen; Hurtado 14, Henry 57, Segura 77]
Nacional     1-0  Bucaramanga
  [Agudelo 76]
América      3-1  Huila
  [Vásquez 49, 56, 76; García 90pen]
Tuluá        1-0  Pereira
  [Londoño 40]

Round 19  [Oct 28]
Pereira      1-0  Tolima
  [Moreno 5]
Cali         1-0  Junior
  [Aristizábal 17]
Envigado     0-0  Nacional
Medellín     1-0  Santa Fe
  [Serna 92]
Millonarios  1-0  Tuluá
  [Cruz 56]
Huila        0-1  Once Caldas
  [Marín 39]
Cartagena    0-0  America
Pasto        1-1  Bucaramanga
  [Orejuela 40; Rivas 35]

Round 20  [Nov 1]
America      1-0  Cali
  [Mafla 24]
Santa Fe     4-1  Huila
  [Serrano 9, Preciado 49, 52, 73; García 13pen]
Tolima       1-1  Millonarios
  [Buelvas 73; Castro 33]
Once Caldas  1-0  Cartagena
  [Galván 67]
Nacional     3-0  Pasto
  [Agudelo 49, Salazar 70, 75]
Tuluá        3-0  Envigado
  [Rogeiro 1, E.Díaz 40, Londoño 74pen]
Junior       1-1  Pereira
  [Salcedo 65; Castillo 50]
Bucaramanga  1-0  Medellín
  [Calle 31]

Round 21 [Nov 4]
Tuluá        0-0  Nacional
Envigado     0-0  Tolima
Millonarios  1-0  Junior
  [Moreno 61]
Pereira      1-1  América
  [C.Moreno 21; González 92]
Cali         0-0  Caldas
Cartagena    3-2  Santa Fe
  [Muñoz 62, López 76, R.Ramos 88; Jaramillo 70, Moreno 78]
Huila        3-5  Bucaramanga
  [Copete 26, García 28pen, Bolívar 32; Ambuila 10, Yepes 20,
   Flavién 36, Vásquez 78, Rojas 88]
Medellín     0-0  Pasto

Round 22 [Nov 11] 
Nacional     2-0  Medellín
  [Hurtado 1, Velásquez 20]
Pasto        1-0  Huila
  [Betancurt 64]
Bucaramanga  0-1  Cartagena
  [Muñoz 57]
Santa Fe     2-0  Cali
  [Preciado 43, 88]
Once Caldas  2-0  Pereira
  [Galván 39pen, Soto 72]
América      4-1  Millonarios
  [Rodríguez 20, Romero 22, Vásquez 81, Mina 89; Rentería 76]
Junior       3-3  Envigado
  [Marquinho 49pen, Arzuaga 54, Arriaga 74; Trujillo 61pen, Cortés 72, Muñoz 88]
Tolima       2-0  Tuluá
  [Cardona 4, Buelvas 66]
  
Final Table:

 1.Once Caldas        22 12  7  3  36-16  43  Copa Libertadores 2002
 2.CD Millonarios     22 11  4  7  37-31  37
 3.Atlético Nacional  22 10  7  5  30-18  37
 4.Deportivo Cali     22 10  6  6  34-25  36
 5.América            22 10  5  7  31-23  35
 6.Deportivo Pasto    22  9  8  5  21-27  35
 7.Envigado FC        22  9  6  7  37-36  33
 8.Deportes Tolima    22  8  8  6  28-24  32
 9.Independ Santa Fe  22  9  2 11  29-29  29
10.CD Indep Medellín  22  8  5  9  24-23  29
11.Deportes Pereira   22  7  5 10  19-31  26
12.Atlético Júnior    22  6  7  9  27-29  25
13.Corporación Tuluá  22  5  8  9  23-28  23
14.Real Cartagena     22  4  9  9  20-31  21
15.Atlético Huila     22  5  5 12  20-36  20
16.Atl Bucaramanga    22  4  6 12  17-26  18


Reclasificación:

 1.Once Caldas        44 23 12  9  71-43  81  Qualified
 2.Deportivo Cali     44 21 11 12  65-46  74  Qualified
 3.América            44 20  8 16  68-62  68  Qualified
 4.Deportes Tolima    44 19 11 14  62-52  68  Qualified
 5.CD Millonarios     44 19  8 17  66-54  65  Qualified
 6.Corporación Tuluá  44 17 14 13  53-47  65  Qualified
 7.Independ Santa Fe  44 18  9 17  57-52  63  Qualified
 8.CD Indep Medellín  44 17 12 15  64-48  63  Qualified
 - - - - - - - - - - - - - - - - - - - - - -
 9.Atlético Nacional  44 17 12 15  48-46  63
10.Envigado FC        44 16 13 15  63-66  61
11.Atlético Júnior    44 14 14 16  49-52  56
12.Deportivo Pasto    44 14 14 16  44-61  56
13.Deportes Pereira   44 15  8 21  45-65  53
14.Real Cartagena     44 11 13 20  43-59  46
15.Atlético Huila     44 11  9 24  48-76  42
16.Atl Bucaramanga    44  8 16 20  27-44  40

Topscorers:

Jorge Horacio Serna      Medellín      27
Carlos Alberto Castro    Millonarios   26
Sergio Alejandro Galván  Once Caldas   21
Julián Vásquez           América       20
Iván Velásquez           Nacional      20


Cuadrangulares Mustang  (Nov 18-Dec 12) 

Final Tables:

Group A
 1.América             6  2  4  0   8- 5  10
 2.Once Caldas         6  2  3  1  10-10   9
 3.Independ Santa Fe   6  1  5  0   6- 4   8
 4.CD Millonarios      6  0  2  4   3- 8   2

Group B
 1.CD Indep Medellín   6  3  2  1   9- 5  11
 2.Corporación Tuluá   6  3  1  2   5- 5  10
 3.Deportivo Cali      6  2  2  2   5- 5   8
 4.Deportes Tolima     6  1  1  4   5- 9   4

Round 1  [Nov 18]
Millonarios  0-0  Santa Fe
América      2-2  Once Caldas
  [Vásquez 2, Mafla 41; Zapata 22, Soto 65]
Tolima       1-0  Cali
  [Viveros 90]
Tuluá        1-0  Medellín
  [Rodríguez 38]

Round 2  [Nov 25]
Once Caldas  1-0  Millonarios
  [Galván 62]
Santa Fe     1-1  América
  [García 46; Díaz 64]
Cali         1-0  Tuluá
  [Córdoba 42]
Medellín     2-1  Tolima
  [Montoya 15, 58; Banguero 11]

Round 3  [Dec 2]
Millonarios  0-1  América
  [Vargas 43]
Once Caldas  0-2  Santa Fe
  [Serrano 35, Díaz 68]
Tuluá        2-0  Tolima
  [Rogerio 46, 81]
Cali         2-2  Medellín
  [Córdoba 12, Hernández 46; Cortés 5, Álvarez 66]

Round 4  [Dec 5]
Santa Fe     2-2  Once Caldas
  [Preciado 45, Serrano 72; Valentierra 16, Zapata 21]
América      2-0  Millonarios
  [Mafla 40, 81pen]
Tolima       1-1  Tuluá
  [Becerra 48; Rogeiro 90]
Medellín     0-0  Cali

Round 5  [Dec 9]
Millonarios  2-3  Once Caldas
  [Castro 30, Jaramillo 66; Padilla 56, 87pen, Marín 93]
América      0-0  Santa Fe
Tuluá        1-0  Cali
  [Rodríguez 29]
Tolima       1-2  Medellín
  [Becerra 27; Serna 62, H.Vásquez 83]

Round 6  [Dec 12]
Santa Fe     1-1  Millonarios
  [Preciado 56pen; Moreno 90]
Once Caldas  2-2  América
  [Padilla 16, Díaz 88; Ferreira 71, Vásquez 75]
Cali         2-1  Tolima
  [Córdoba 22, 30; Rodas 32]
Medellín     3-0  Tuluá
  [Calle 67, Montoya 72, Serna 91]

Final Tables:

Group A
 1.América             6  2  4  0   8- 5  10
 2.Once Caldas         6  2  3  1  10-10   9
 3.Independ Santa Fe   6  1  5  0   6- 4   8
 4.CD Millonarios      6  0  2  4   3- 8   2

Group B
 1.CD Indep Medellín   6  3  2  1   9- 5  11
 2.Corporación Tuluá   6  3  1  2   5- 5  10
 3.Deportivo Cali      6  2  2  2   5- 5   8
 4.Deportes Tolima     6  1  1  4   5- 9   4


Final

First Leg  [Dec 16]
Medellín     0-1  América
  [Julián Vásquez 66]

Second Leg  [Dec 19]
América      2-0  Medellín
  [Edison Mafla 34, Julián Vásquez 41]

NB: América are champions and qualify for Copa Libertadores 2002.

Topscorers:

Carlos Alberto Castro    Millonarios   29
Jorge Horacio Serna      Medellín      29
Julián Vásquez           América       24
Sergio Alejandro Galván  Once Caldas   23
Iván José Velásquez      Nacional      20


Relegation Table:

                   P  W Pts  
 1.América        88 45 154
 2.Once Caldas    88 38 141
 3.Tolima         88 40 138
 4.Santa Fe       88 39 137
 5.Deportivo Cali 88 37 135
 6.Millonarios    88 36 134
 7.Junior         88 33 126
 8.Nacional       88 34 123
 9.Envigado       88 31 119
10.Medellín       88 30 116
11.Tulúa          88 29 116
12.Pasto          88 27 106 
13.Pereira        88 27 101
14.Real Cartagena 88 24  97
15.Huila          88 25  95
---------------------------
16.Bucaramanga    88 20  88  Relegated

NB: Pereira took the record of the worst non-relegated team 
    (Atlético Bucaramanga) in 2000


Triangular de Promoción

As the first level will be extended to 18 teams, it will be played a
promotion championship in Cartagena between the three best-placed
professional clubs of the second level afiliated to Dimayor, to select
the 2 promoted teams to the first level.

[All matches in Cartagena, Pedro de Heredia stadium]

Dec 16:  Cúcuta       0-2  Magdalena
           [Zarate 60, Maturana 75]
Dec 18:  Bucaramanga  0-2  Magdalena
           [Buelvas 18, 55]
Dec 20:  Cúcuta       0-0  Bucaramanga     [3-5 pen]

Final Table:

 1.Unión Magdalena      2  2  0  0  4-0  6
 2.Atlético Bucaramanga 2  0  1  1  0-2  1  [5-3 pen]
 3.Cúcuta Deportivo     2  0  1  1  0-2  1  [3-5 pen]

NB: Magdalena and Bucaramanga were promoted for First Level 2002.

In 2002 two separate 18-team championships will be played, one from Feb-Jun
and one from Jul-Dec.






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,354,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1600
Total Execution Time  0.1619
  CADENA URL  
/clausura_primera_b_colombia2001
  GET DATOS  
$_GET['/clausura_primera_b_colombia2001']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0034  SELECT type FROM routes WHERE alias = 'clausura_primera_b_colombia2001'
0.0072  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 = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0037  SELECT text_es as historical_text FROM leagues_text WHERE id=5393
0.0035  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 = 33868 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 22:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 22:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 22:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 22:49:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0040  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 = 2001 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (33868) 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.0035  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 (33868) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0034  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (33868) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0034  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 (33868) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0035  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (33868) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0034  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 (33868) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0036  SELECT e.action, count(e.action) as total, e.player_id FROM events2001 e WHERE e.league_id IN (33868) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0035  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 (33868) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0034  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 = 33868 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0034  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 = 33868 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0038  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=33868 AND rel.round=22
0.0036  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 = 33868 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0036  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 = 33868 AND esl.points > 0
0.0036  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` = 33868 ORDER BY creation_date DESC LIMIT 0, 10
0.0039  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` = 33868
0.0037  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 `calendars2001` 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` = 33868 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0034  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 `events2001` e INNER JOIN calendars2001 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 33868 ORDER BY total DESC LIMIT 40
0.0036  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 `events2001` e INNER JOIN calendars2001 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 = 33868 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0038  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 `tables2001` 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 = 33868 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 33868 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038  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 = 33868 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0038  SELECT data1, data2 FROM services_tags WHERE categoryId=197
0.0038  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 197 AND l.year = 2001 ORDER BY l.group_code ASC
0.0038  SELECT group_code, extraName from `leagues` WHERE categoryId=197 AND year=2001