4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Second Level (Primera B)

In the First Phase of the tournament 15 teams play in two groups: North
and South.

In the Second Phase all the teams will play 2 rounds (28), all the teams
will start Second Phase with halved points of the First Phase.
Champion and Runners-up will promoted to Primera División,  15º will
relegated to Tercera División, 3º and 4º of Primera B will play
promotion-relegation play-off with 13º and 14º of Primera División.


First Phase

Tables:

Northern Zone:

 1.Everton                   14  8  4  2 19-11 28
 2.Magallanes                14  7  3  4 22-13 24
 3.Santiago Wanderers        14  7  3  4 23-15 24
 4.Deportes Arica            14  5  4  5 14-19 19
 5.Deportes Melipilla        14  5  3  6 20-17 18
 6.Deportes Ovalle           14  4  4  6  9-17 16
 7.Unión San Felipe          14  3  5  6 13-16 14
 8.Antofagasta               14  2  4  8 16-28 10

Southern Zone:

 1.Unión Española            12  7  3  2 26-14 24
 2.Deportes Colchagua        12  5  3  4 19-17 18
 3.Provincial Osorno         12  5  3  4 24-24 18
 4.Universidad de Concepción 12  4  5  3 24-21 17
 5.Fernández Vial            12  4  4  4 15- 9 16
 6.Ñublense                  12  3  3  6 19-21 12
 7.Deportes Linares          12  2  3  7  8-29  9

NB: Deportes Temuco withdrew because financial problems, they are entitled
    to play at the second level in 2000.

Round 1 
Northern Zone
(Feb 27)
Deportes Arica     2-0 Santiago Wanderers
(Feb 28)
Deportes Melipilla 1-1 Unión San Felipe
Deportes Ovalle    1-0 Magallanes
Everton            1-1 Antofagasta
Southern Zone
(Feb 26)
Unión Española     2-0 Fernández Vial
(Feb 27)
Deportes Colchagua 2-0 Deportes Linares
(Feb 28)
Provincial Osorno  4-5 Ñublense
bye: Universidad de Concepción

Round 2 
Northern Zone
(Mar 6)
Deportes Arica     1-0 Everton
(Mar 7)
Santiago Wanderers 3-0 Deportes Ovalle
Magallanes         2-0 Deportes Melipilla
Unión San Felipe   3-1 Antofagasta
Southern Zone
(Mar 5)
Unión Española     0-1 Universidad de Concepción
(Mar 7)
Fernández Vial     0-1 Deportes Colchagua
Deportes Linares   1-1 Provincial Osorno
Free: Ñublense

Round 3
Northern Zone
(Mar 13)
Dep. Ovalle        0-0 Dep. Arica
(Mar 14)
Antofagasta        0-1 Magallanes
Dep. Melipilla     2-2 Stgo. Wanderers
Everton            2-0 Unión San Felipe
Southern Zone
(Mar 13)
U. de Concepción   1-1 Ñublense
Dep. Colchagua     1-1 U.Española
(Mar 14)
Osorno             1-0 Fernandez Vial
Free: Deportes Linares

Round 4 
Northern Zone
(Mar 20)
Deportes Arica     2-0 Deportes Melipilla
Deportes Ovalle    0-1 Everton
(Mar 21)
Santiago Wanderers 3-2 Antofagasta
Magallanes         1-0 Unión San Felipe
Southern Zone
(Mar 19)
Unión Española     5-3 Provincial Osorno
(Mar 20)
Deportes Colchagua 3-3 Universidad de Concepción
(Mar 21)
Deportes Linares   1-0 Ñublense
Free: Fernández Vial

Round 5 (Mar 28)
Northern Zone
Unión San Felipe   2-3 Santiago Wanderers
Antofagasta        1-1 Deportes Arica
Deportes Melipilla 5-0 Deportes Ovalle
Everton            3-2 Magallanes
Southern Zone
Ñublense           1-1 Fernández Vial
Provincial Osorno  2-0 Deportes Colchagua
U. de Concepción   5-0 Deportes Linares
Free: Unión Española

Round 6
Northern Zone
(Apr 3)
Deportes Ovalle    3-1 Antofagasta  
Deportes Arica     2-3 Unión San Felipe
(Apr 4)
Santiago Wanderers 1-1 Magallanes
Deportes Melipilla 0-2 Everton   
Southern Zone
(Apr 1)
Unión Española     2-1 Ñublense
(Apr 4)
Fernández Vial     3-0 Deportes Linares
Provincial Osorno  0-0 Universidad de Concepción
Free: Deportes Colchagua

Round 7 (Apr 10,11)
Northern Zone
Antofagasta        3-2 Deportes Melipilla
Unión San Felipe   1-1 Deportes Ovalle
Everton            2-1 Santiago Wanderers
Magallanes         3-0 Deportes Arica
Southern Zone
U. de Concepción   1-1 Fernández Vial
Ñublense           1-2 Deportes Colchagua
Deportes Linares   1-3 Unión Española
Free: Provincial Osorno

Round 8 (Apr 18)
Northern Zone
U. San Felipe      0-1 Dep. Melipilla
Magallanes         2-0 Dep. Ovalle
Stgo. Wanderers    4-0 Dep. Arica  
Antofagasta        2-2 Everton
Southern Zone
Ñublense           4-2 Prov. Osorno
Dep. Linares       0-4 Dep. Colchagua 
Fernandez Vial     0-0 U. Española  
Free: Universidad de Concepción

Round 9 (Apr 24,25)
Northern Zone
Everton            1-1 Deportes Arica
Deportes Ovalle    0-1 Santiago Wanderers
Deportes Melipilla 2-2 Magallanes    
Antofagasta        2-1 Unión San Felipe  
Southern Zone
Deportes Colchagua 0-0 Fernández Vial
U. de Concepción   3-3 Unión Española
Provincial Osorno  1-1 Deportes Linares
Free: Ñublense

Round 10 
Northern Zone
(Apr 30) 
Dep. Arica        1-1 Dep. Ovalle 
(May 2)
Magallanes        3-0 Antofagasta
Stgo. Wanderers   1-0 Dep. Melipilla 
U. San Felipe     0-0 Everton       
Southern Zone
(Apr 30) 
U. Española       3-0 Dep. Colchagua  
(May 2)
Fernandez Vial    1-2 Prov. Osorno 
Ñublense          2-3 U. de Concepcion   
Free: Deportes Linares

Round 11
Northern Zone (May 9)
Antofagasta       1-3 Stgo. Wanderers 
Everton           1-2 Dep. Ovalle
U. San Felipe     1-1 Magallanes
Dep. Melipilla    3-0 Dep. Arica
Southern Zone
(May 8)  
U. de Concepcion  3-1 Dep. Colchagua 
(May 9)  
Prov. Osorno      2-3 U. Española    
Ñublense          1-1 Dep. Linares       
Free: Fernandez Vial   

Round 12
Northern Zone 
(May 15) 
Dep. Arica        2-1 Antofagasta
(May 16) 
Stgo. Wanderers   0-0 U. San Felipe  
Dep. Ovalle       0-1 Dep. Melipilla  
Magallanes        1-2 Everton
Southern Zone
(May 15) 
Dep. Colchagua    2-3 Prov. Osorno 
(May 16) 
Fernandez Vial    1-0 Ñublense
Dep. Linares      3-1 U. de Concepcion
Free: U. Española

Round 13 (May 23)
Northern Zone
Antofagasta       0-0 Dep. Ovalle
U. San Felipe     1-0 Dep. Arica
Magallanes        2-1 Stgo. Wanderers
Everton           1-0 Dep. Melipilla 
Southern Zone
Ñublense          2-0 U. Española 
Dep. Linares      0-4 Fernandez Vial
U. de Concepcion  2-3 Prov. Osorno
Free: Dep. Colchagua

Round 14 
Northern Zone
(May 28) 
Dep. Arica        2-1 Magallanes
Dep. Ovalle       1-0 U. San Felipe
(May 30) 
Dep. Melipilla    3-1 Antofagasta  
Stgo. Wanderers   0-1 Everton    
Southern Zone
(May 29) 
U. Española       4-0 Dep. Linares    
Dep. Colchagua    3-1 Ñublense
(May 30) 
Fernandez Vial    4-1 U. de Concepcion
Free: Prov. Osorno

Tables:

[between square brackets bonus points obtained for 2nd phase]

Northern Zone:

 1.Everton                   14  8  4  2 19-11 28  [14]
 2.Magallanes                14  7  3  4 22-13 24  [12]
 3.Santiago Wanderers        14  7  3  4 23-15 24  [12]
 4.Deportes Arica            14  5  4  5 14-19 19  [10]
 5.Deportes Melipilla        14  5  3  6 20-17 18  [ 9]
 6.Deportes Ovalle           14  4  4  6  9-17 16  [ 8]
 7.Unión San Felipe          14  3  5  6 13-16 14  [ 7]
 8.Antofagasta               14  2  4  8 16-28 10  [ 5]

Southern Zone:

 1.Unión Española            12  7  3  2 26-14 24  [14]
 2.Deportes Colchagua        12  5  3  4 19-17 18  [10]
 3.Provincial Osorno         12  5  3  4 24-24 18  [10]
 4.Universidad de Concepción 12  4  5  3 24-21 17  [10]
 5.Fernández Vial            12  4  4  4 15- 9 16  [ 9]
 6.Ñublense                  12  3  3  6 19-21 12  [ 7]
 7.Deportes Linares          12  2  3  7  8-29  9  [ 5]

NB: Deportes Temuco withdrew because financial problems, they are entitled
    to play at the second level in 2000.

Second Phase

Table:

[between square brackets bonus points from first phase]

 1.Unión Española            28 16  8  4 56-26 70  [14]  Promoted
 2.Santiago Wanderers        28 16  8  4 48-22 68  [12]  Promoted
-------------------------------------------------------
 3.Everton                   28 16  6  6 40-26 68  [14]  Promotion Playoff
 4.Provincial Osorno         28 14  4 10 45-36 56  [10]  Promotion Playoff
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Deportes Ovalle           28 12  7  9 43-32 51  [ 8]
 6.Deportes Arica            28 11  6 11 35-41 49  [10]
 7.Antofagasta               28 12  9  9 36-34 48  [ 5]
 8.Deportes Melipilla        28 10  8 10 45-36 47  [ 9]
 9.Universidad de Concepción 28 10  5 13 42-43 45  [10]
10.Fernández Vial            28  8 10 10 28-38 43  [ 9]
11.Magallanes                28  8  6 14 30-45 42  [12]
12.Ñublense                  28  8  5 15 28-46 36  [ 7]
13.Deportes Linares          28  7  9 12 35-42 35  [ 5]
14.Unión San Felipe          28  6  9 13 31-47 34  [ 7]
-------------------------------------------------------
15.Deportes Colchagua        28  4  6 18 27-55 28  [10]  Relegated

Round 1
(Jun 2)
Dep. Ovalle       2-0 Magallanes
Dep. Arica        0-1 Antofagasta
U. de Concepcion  5-1 Dep. Colchagua
(Jun 3)
Everton           1-0 U. San Felipe
Ñublense          0-2 Prov. Osorno
Dep. Linares      2-2 Fernandez Vial 
Dep. Melipilla    0-0 Stgo. Wanderers 
bye: U. Española
 
Round 2
(Jun 5)
U. Española       4-0 Ñublense
(Jun 6)
Stgo. Wanderers   0-1 Everton
Antofagasta       2-1 U. de Concepcion
U. San Felipe     1-1 Dep. Arica
Magallanes        1-1 Dep. Melipilla
Dep. Colchagua    1-0 Prov. Osorno
Fernandez Vial    1-1 Dep. Ovalle
bye: Dep. Linares

Round 3
(Jun 12)
U. de Concepcion  2-0 U. San Felipe
Dep. Arica        0-2 Stgo. Wanderers
(Jun 13)
Prov. Osorno      2-1 Antofagasta
Dep. Melipilla    1-1 Fernandez Vial
Dep. Linares      1-0 U. Española
Ñublense          2-2 Dep. Colchagua
Everton           1-0 Magallanes
bye: Dep. Ovalle

Round 4
(Jun 19)
U. Española       2-2 Dep. Ovalle
Dep. Linares      1-1 Ñublense
Fernandez Vial    1-1 Everton
U. San Felipe     3-2 Prov. Osorno
Antofagasta       2-0 Dep. Colchagua
Stgo. Wanderers   2-0 U. de Concepcion
(Jun 20)
Magallanes        0-1 Dep. Arica
bye: Dep. Melipilla

Round 5 (Jun 26-27)
Ñublense          2-1 Antofagasta
Dep. Colchagua    4-1 U. San Felipe
Prov. Osorno      2-1 Stgo. Wanderers
U. de Concepcion  3-0 Magallanes 
Dep. Arica        3-1 Fernández Vial
Dep. Melipilla    4-0 U. Española
Dep. Ovalle       2-0 Dep. Linares
bye: Everton 

Round 6 (Jul 3-4)
U. Española       1-2 Everton
Dep. Ovalle       1-0 Ñublense        
Dep. Linares      2-1 Dep. Melipilla 
Fernandez Vial    1-0 U. de Concepcion
Magallanes        1-0 Prov. Osorno
Stgo. Wanderers   2-1 Dep. Colchagua 
U. San Felipe     2-2 Antofagasta
bye: Dep. Arica 

Round 7 (Jul 10-11)
Ñublense          0-2 U. San Felipe
Antofagasta       1-1 Stgo. Wanderers 
Dep. Colchagua    2-3 Magallanes
Prov. Osorno      1-1 Fdez. Vial
Dep. Arica        1-1 U. Española
Everton           1-0 Dep. Linares
Dep. Melipilla    3-0 Dep. Ovalle
bye: U. de Concepcion 

Round 8 (Jul 17-18)
Dep. Ovalle       3-1 Everton
Dep. Linares      0-0 Dep. Arica
Magallanes        1-1 Antofagasta
Fernandez Vial    1-0 Dep. Colchagua
U. Española       2-0 U. de Concepcion
Stgo. Wanderers   3-0 U. San Felipe
Dep. Melipilla    2-1 Ñublense
bye: Prov. Osorno
 
Round 9 (Jul 24-25)
Dep. Arica        2-0 Dep. Ovalle
Ñublense          1-0 Stgo. Wanderers
U. de Concepcion  1-1 Dep. Linares
Antofagasta       1-0 Fernandez Vial
Prov. Osorno      3-2 U. Española
U. San Felipe     1-3 Magallanes
Everton           1-0 Dep. Melipilla
bye: Dep. Colchagua

Round 10 (Jul 31-Aug 1)
Dep. Ovalle       1-1 U. de Concepcion
Dep. Melipilla    3-2 Dep. Arica
Magallanes        0-1 Stgo. Wanderers
Everton           1-0 Ñublense
Dep. Linares      2-3 Prov. Osorno
U. Española       2-1 Dep. Colchagua
Fernandez Vial    2-1 U. San Felipe
bye: Antofagasta

Round 11 (Aug 7-8)
U. de Concepcion  1-1 Dep. Melipilla
Dep. Colchagua    3-1 Dep. Linares
Ñublense          4-0 Magallanes
Prov. Osorno      1-0 Dep. Ovalle
Dep. Arica        1-1 Everton
Antofagasta       1-2 U. Española
Stgo. Wanderers   4-0 Fernandez Vial
bye: U. San Felipe

Round 12 (Aug 14-15)
U. Española       2-1 U. San Felipe   
Dep. Ovalle       4-1 Dep. Colchagua
Dep. Arica        1-0 Ñublense
Fernandez Vial    2-1 Magallanes
Dep. Linares      5-1 Antofagasta
Dep. Melipilla    1-0 Prov. Osorno 
Everton           1-0 U. de Concepcion
bye: Stgo. Wanderers            
  
Round 13 (Aug 21-22)
Stgo. Wanderers   1-1 U. Española
Prov. Osorno      2-0 Everton
Ñublense          1-1 Fernandez Vial
U. San Felipe     2-3 Dep. Linares
Antofagasta       1-0 Dep. Ovalle
Dep. Colchagua    1-0 Dep. Melipilla
U. de Concepcion  5-2 Dep. Arica
bye: Magallanes

Round 14 (Aug 28-29)
U. Española       2-1 Magallanes
Dep. Arica        3-2 Prov. Osorno 
Dep. Linares      1-1 Stgo. Wanderers
Dep. Ovalle       1-0 U. San Felipe
Dep. Melipilla    0-1 Antofagasta
U. de Concepcion  1-2 Ñublense
Everton           3-0 Dep. Colchagua   
bye: Fernandez Vial

Round 15
(Sep 4-5)
U. San Felipe     0-0 Dep. Melipilla
Fdez. Vial        0-3 U. Española
Antofagasta       1-0 Everton
Dep. Colchagua    0-2 Dep. Arica
Magallanes        2-1 Dep. Linares
Prov. Osorno      2-1 U. de Concepcion
(Sep 21)
Stgo. Wanderers   2-1 Dep. Ovalle
bye: Ñublense

Round 16
(Sep 12) 
Antofagasta       0-0 Dep. Arica
Fdez. Vial        4-0 Dep. Linares
Prov. Osorno      2-3 Ñublense
Stgo. Wanderers   2-2 Dep. Melipilla
(Sep 29)
Dep. Colchagua    0-2 U. de Concepcion
(Oct 12)
Magallanes        1-1 Dep. Ovalle
U. San Felipe     1-0 Everton
bye: U. Española 

Round 17 (Sep 17-19)
Ñublense          0-4 U. Española
Dep. Ovalle       2-0 Fdez. Vial 
Dep. Melipilla    5-0 Magallanes
Everton           1-4 Stgo. Wanderers  
Dep. Arica        2-0 U. San Felipe  
U. de Concepcion  2-1 Antofagasta
Prov. Osorno      2-2 Dep. Colchagua
bye: Dep. Linares

Round 18 (Sep 24-26)
Dep. Colchagua    1-1 Ñublense
Antofagasta       1-1 Prov. Osorno
U. San Felipe     1-1 U. de Concepcion
Stgo. Wanderers   0-2 Dep. Arica
Magallanes        1-2 Everton
Fernandez Vial    1-1 Dep. Melipilla
U. Española       3-0 Dep. Linares
bye: Dep. Ovalle
  
Round 19 (Oct 2-3) 
Prov. Osorno      2-0 U. San Felipe
U. de Concepcion  1-4 Stgo. Wanderers
Everton           0-0 Fernandez Vial 
Ñublense          1-0 Dep. Linares
Dep. Ovalle       0-1 U. Española
Dep. Colchagua    0-2 Antofagasta
Dep. Arica        2-0 Magallanes
bye: Dep. Melipilla

Round 20 (Oct 9-10)
U. San Felipe     1-0 Dep. Colchagua
U. Española       1-0 Dep. Melipilla
Stgo. Wanderers   2-0 Prov. Osorno
Dep. Linares      3-4 Dep. Ovalle
Magallanes        4-1 U. de Concepcion
Fernandez Vial    2-1 Dep. Arica
Antofagasta       2-1 Ñublense
bye: Everton

Round 21 (Oct 16-17) 
Dep. Colchagua    1-2 Stgo. Wanderers
Prov. Osorno      1-0 Magallanes
Dep. Melipilla    1-1 Dep. Linares 
Everton           1-1 U. Española
Ñublense          2-1 Dep. Ovalle
U. de Concepcion  1-0 Fdez. Vial 
Antofagasta       1-1 U. San Felipe   
bye: Dep. Arica 

Round 22 (Oct 23-24)
Stgo. Wanderers   2-1 Antofagasta
Dep. Linares      1-0 Everton
U. San Felipe     3-1 Ñublense
Magallanes        0-0 Dep. Colchagua
U. Española       4-1 Dep. Arica
Prov. Osorno      0-0 Fdez. Vial
Dep. Ovalle       2-1 Dep. Melipilla
bye: U. de Concepcion

Round 23 (Oct 30-31)
Everton           1-1 Dep. Ovalle
Dep. Colchagua    1-2 Fdez. Vial   
Ñublense          1-4 Dep. Melipilla     
Dep. Arica        1-0 Dep. Linares
U. San Felipe     2-2 Stgo. Wanderers 
Antofagasta       2-1 Magallanes       
U. de Concepcion  1-1 U. Española   
bye: Prov. Osorno    

Round 24 (Nov 6-7) 
U. Española       2-1 Prov. Osorno
Dep. Ovalle       4-0 Dep. Arica
Dep. Linares      3-2 U. de Concepcion
Stgo. Wanderers   1-0 Ñublense 
Magallanes        3-2 U. San Felipe
Dep. Melipilla    1-5 Everton
Fdez. Vial        2-3 Antofagasta
bye: Dep. Colchagua

Round 25 (Nov 13-14)
Dep. Colchagua    0-0 U. Española
Prov. Osorno      2-1 Dep. Linares
Dep. Arica        1-3 Dep. Melipilla
U. San Felipe     0-0 Fdez. Vial
Stgo. Wanderers   4-0 Magallanes
Ñublense          0-3 Everton 
U. de Concepcion  2-0 Dep. Ovalle
bye: Antofagasta

Round 26 (Nov 20-21)
Everton           4-2 Dep. Arica
Dep. Ovalle       1-2 Prov. Osorno
Dep. Linares      3-0 Dep. Colchagua
Fdez. Vial        0-1 Stgo. Wanderers  
U. Española       2-0 Antofagasta
Magallanes        4-1 Ñublense
Dep. Melipilla    4-2 U. de Concepcion
bye: U. San Felipe

Round 27 (Nov 28-29)
Dep. Colchagua    0-3 Dep. Ovalle
U. San Felipe     2-6 U. Española
Antofagasta       1-1 Dep. Linares
Magallanes        2-1 Fernandez Vial
U. de Concepcion  1-2 Everton
Ñublense          0-0 Dep. Arica
Prov. Osorno      2-1 Dep. Melipilla
bye: Stgo. Wanderers

Round 28 (Dec 4-5)
Dep. Arica        1-2 U. de Concepcion
U. Española       1-1 Stgo. Wanderers
Everton           3-2 Prov. Osorno
Dep. Linares      1-1 U. San Felipe
Dep. Ovalle       4-2 Antofagasta 
Dep. Melipilla    4-2 Dep. Colchagua
Fernandez Vial    2-1 Ñublense
bye: Magallanes

Round 29 (Dec 8-9)
Magallanes        1-1 U. Española  
Stgo. Wanderers   2-1 Dep. Linares
Dep. Colchagua    2-2 Everton
Ñublense          2-0 U. de Concepcion
Prov. Osorno      4-0 Dep. Arica
Antofagasta       3-0 Dep. Melipilla
U. San Felipe     1-1 Dep. Ovalle
bye: Fernandez Vial

Round 30 (Dec 16)
U. de Concepcion  3-2 Prov. Osorno
Dep. Arica        3-1 Dep. Colchagua
Dep. Ovalle       1-1 Stgo. Wanderers
Everton           1-0 Antofagasta 
Dep. Melipilla    1-2 U. San Felipe
U. Española       5-0 Fdez. Vial
Dep. Linares      0-0 Magallanes
bye: Ñublense

Table:

[between square brackets bonus points from first phase]

 1.Unión Española            28 16  8  4 56-26 70  [14]  Promoted
 2.Santiago Wanderers        28 16  8  4 48-22 68  [12]  Promoted
-------------------------------------------------------
 3.Everton                   28 16  6  6 40-26 68  [14]  Promotion Playoff
 4.Provincial Osorno         28 14  4 10 45-36 56  [10]  Promotion Playoff
- - - - - - - - - - - - - - - - - - - - - - - - - - - -
 5.Deportes Ovalle           28 12  7  9 43-32 51  [ 8]
 6.Deportes Arica            28 11  6 11 35-41 49  [10]
 7.Antofagasta               28 12  9  9 36-34 48  [ 5]
 8.Deportes Melipilla        28 10  8 10 45-36 47  [ 9]
 9.Universidad de Concepción 28 10  5 13 42-43 45  [10]
10.Fernández Vial            28  8 10 10 28-38 43  [ 9]
11.Magallanes                28  8  6 14 30-45 42  [12]
12.Ñublense                  28  8  5 15 28-46 36  [ 7]
13.Deportes Linares          28  7  9 12 35-42 35  [ 5]
14.Unión San Felipe          28  6  9 13 31-47 34  [ 7]
-------------------------------------------------------
15.Deportes Colchagua        28  4  6 18 27-55 28  [10]  Relegated

Topscorers:
Marco Olea        Chile           Prov. Osorno                    22
Ricardo Queraltó  Chile           U. Española                     21
Julio Gutiérrez   Chile           U. Española                     20
Andrés Roldán     Chile           U. de Concepción                18
Leonardo Salazar  Chile           Dep. Colchagua                  18

Promoted from 3rd division: Dep. Talcahuano



Author: Juan Pablo Andrés
(jpandres@tutopia.com)
Last updated: 27 Jan 2000

(C) Copyright Juan Pablo Andrés and RSSSF 1999/2000

INFORMACIÓN

La Primera B del fútbol chileno u oficialmente a partir del 2009, Campeonato Nacional de Primera B del Fútbol Profesional Chileno, corresponde a la segunda categoría del fútbol profesional en Chile, por debajo de la Primera División. Es organizada por la Asociación Nacional de Fútbol Profesional (ANFP), perteneciente a la Federación de Fútbol de Chile y corresponde a una de las 3 categorías profesionales del Fútbol en Chile. Fue fundada en 1952 como continuadora del torneo DIVHA (División de Honor Amateur) y como vía deportiva para equipos regionales que buscan un lugar en la Primera División. Han participado en ella un total de 74 instituciones a lo largo de sus 61 temporadas Actualmente 14 equipos conforman esta categoría. En este certamen se otorgan 2 ascensos directos y 2 promociones a Primera División, por contraparte el equipo peor ubicado desciende a Segunda División

  USO DE MEMORIA  
4,318,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1039
Total Execution Time  0.1058
  CADENA URL  
/primera_b_apertura_fase_1_chile1999
  GET DATOS  
$_GET['/primera_b_apertura_fase_1_chile1999']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0018  SELECT type FROM routes WHERE alias = 'primera_b_apertura_fase_1_chile1999'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_apertura_fase_1_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=290 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 290 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (350868,244378,241993,143444,97344) ORDER BY n.cover_points DESC, update_date DESC
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=2404
0.0019  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 = 30650 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=1847 ORDER BY l.group_code ASC
0.0021  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='2017' WHERE c.parentId=1847 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT type,rule FROM rules WHERE categoryId = 290 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 07:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 07:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 07:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 07:03:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'primera_b_apertura_fase_1_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1999 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30650) 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.0019  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 (30650) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30650) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (30650) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30650) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (30650) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1999 e WHERE e.league_id IN (30650) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  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 (30650) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30650 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 30650 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=30650 AND rel.round=14
0.0022  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 = 30650 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0021  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 = 30650 AND esl.points > 0
0.0022  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-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30650 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30650
0.0022  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 `calendars1999` 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` = 30650 AND c.`round` = 14 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1999` e INNER JOIN calendars1999 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 = 14 AND e.real_date IS NOT NULL AND e.league_id = 30650 ORDER BY total DESC LIMIT 40
0.0023  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 `events1999` e INNER JOIN calendars1999 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 = 30650 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables1999` 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 = 30650 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1999` 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 = 30650 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 30650 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=290
0.0024  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 290 AND l.year = 1999 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=290 AND year=1999