4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información Histórica 
						
Campeonato de Apertura.

First Phase

Final Tables:

Northern Group		
 1.COBRESAL		16 10  4  2  31-10  24  - Classified      
 2.UNIÓN CALERA		16  8  5  3  29-18  21  - Classified    
 3.SAN LUIS	 	16  8  4  4  32-18  20  - Classified  
 4.COQUIMBO UNIDO	16  7  4  5  19-17  18  - Classified  
 5.Ovalle		16  6  5  5   9-15  17    
 6.San Antonio Unido	16  4  5  7  15-21  13      
 7.La Serena		16  2  7  7  17-24  11   
 8.Santiago Morning     16  4  3  9  22-36  11   
 9.Colchagua		16  1  7  8  11-26   9      

Southern Group	
 1.LINARES		16  8  4  4  22-17  20  - Classified  
 2.IBERIA		16  9  2  5  20-17  20  - Classified  
 3.HUACHIPATO		16  7  5  4  28-17  19  - Classified  
 4.CONCEPCIÓN		16  7  5  4  18-14  19  - Classified      
 5.Green Cross-Temuco	16  7  4  5  28-22  18        
 6.Lota Schwager	16  5  7  4  23-21  17        
 7.Ñublense		16  6  3  7  20-27  15   
 8.Malleco Unido	16  4  3  9  15-23  11          
 9.Laja			16  1  3 12  10-26   5   

Round 1
Northern Group  
Cobresal		0-0 Ovalle
La Serena		0-1 San Luis
Unión Calera		1-0 Coquimbo Unido
Santiago Morning	0-1 San Antonio Unido
Colchagua		bye
Southern Group  
Green Cross		1-1 Concepción  
Laja        		1-2 Iberia
Huachipato		2-0 Malleco Unido
Lota Schwager		3-3 Ñublense
Linares			bye

Round 2
Northern Group  
San Antonio Unido	0-0 Colchagua
Coquimbo Unido		3-2 Santiago Morning
San Luis		1-2 Unión Calera
Cobresal		2-2 La Serena
Ovalle			bye
Southern Group  
Ñublense		0-1 Linares
Malleco Unido		0-0 Lota Schwager
Iberia			2-0 Huachipato
Green Cross		3-2 Laja
Concepción		bye

Round 3
Northern Group  
La Serena		3-0 Ovalle
Unión Calera		2-1 Cobresal
Santiago Morning	1-8 San Luis
Colchagua		0-1 Coquimbo Unido
San Antonio Unido	bye
Southern Group  
Laja			0-2 Concepción
Huachipato		3-0 Green Cross
Lota Schwager		2-1 Iberia
Linares			3-1 Malleco Unido
Ñublense		bye

Round 4
Northern Group  
Ovalle			0-0 San Antonio Unido
San Luis		2-0 Colchagua
Cobresal		2-0 Santiago Morning
La Serena		1-1 Unión Calera
Coquimbo Unido		bye
Southern Group  
Concepción		1-0 Ñublense
Iberia			1-0 Linares
Green Cross		2-1 Lota Schwager
Laja			0-0 Huachipato
Malleco Unido		bye

Round 5
Northern Group  
Unión Calera		1-0 Ovalle
Santiago Morning	3-3 La Serena
Colchagua		1-1 Cobresal
San Antonio Unido	0-0 Coquimbo Unido
San Luis		bye
Southern Group  
Huachipato		0-0 Concepción
Lota Schwager		2-1 Laja	
Linares			3-1 Green Cross
Ñublense		3-1 Malleco Unido
Iberia			bye

Round 6
Northern Group  
Ovalle			1-0 Coquimbo Unido
San Luis		2-0 San Antonio Unido
La Serena		0-0 Colchagua
Unión Calera		2-1 Santiago Morning
Cobresal		bye
Southern Group  
Huachipato		1-1 Lota Schwager
Concepción		3-1 Malleco Unido
Laja			1-1 Linares
Iberia			3-1 Ñublense
Green Cross		bye

Round 7
Northern Group 
Santiago Morning	2-3 Ovalle
Colchagua		1-1 Unión Calera
San Antonio Unido	1-2 Cobresal
Coquimbo Unido		2-1 San Luis
La Serena		bye
Southern Group  
Lota Schwager		2-2 Concepción
Linares			2-1 Huachipato
Ñublense		2-0 Green Cross
Malleco Unido		0-0 Iberia
Laja			bye

Round 8
Northern Group  
Ovalle			1-0 San Luis
Cobresal		2-0 Coquimbo Unido
La Serena		3-2 San Antonio Unido
Santiago Morning	3-1 Colchagua
Unión Calera		bye
Southern Group  
Concepción		3-2 Iberia
Green Cross		1-0 Malleco Unido
Laja			0-1 Ñublense
Lota Schwager		2-1 Linares
Huachipato		bye

Round 9
Northern Group  
Colchagua		0-0 Ovalle
San Antonio Unido	4-1 Unión Calera
Coquimbo Unido		2-0 La Serena
San Luis		1-1 Cobresal
Santiago Morning	bye
Southern Group  
Linares			3-0 Concepción
Ñublense		0-2 Huachipato
Malleco Unido		2-1 Laja	
Iberia			3-1 Green Cross
Lota Schwager		bye

Round 10
Northern Group  
Ovalle			1-0 Cobresal
San Luis		3-2 La Serena
Coquimbo Unido		1-1 Unión Calera
San Antonio Unido	2-0 Santiago Morning
Colchagua		bye
Southern Group  
Concepción		1-2 Green Cross
Iberia			1-0 Laja	
Malleco Unido		4-3 Huachipato
Ñublense		2-2 Lota Schwager
Linares			bye

Round 11
Northern Group  
Colchagua		3-1 San Antonio Unido
Santiago Morning	3-1 Coquimbo Unido
Unión Calera		2-2 San Luis
La Serena		1-2 Cobresal
Ovalle			bye
Southern Group  
Linares			2-0 Ñublense
Lota Schwager		2-0 Malleco Unido
Huachipato		1-0 Iberia
Laja			0-4 Green Cross
Concepción		bye

Round 12
Northern Group  
Ovalle			1-0 La Serena
Cobresal		1-0 Unión Calera
San Luis		2-0 Santiago Morning
Coquimbo Unido		4-1 Colchagua
San Antonio Unido	bye
Southern Group  
Concepción		2-0 Laja	
Green Cross		1-1 Huachipato
Iberia			2-1 Lota Schwager
Malleco Unido		1-2 Linares
Ñublense		bye

Round 13
Northern Group  
San Antonio Unido	0-0 Ovalle
Colchagua		2-2 San Luis
Santiago Morning	0-3 Cobresal
Unión Calera		4-0 La Serena
Coquimbo Unido		bye
Southern Group  
Ñublense		1-1 Concepción
Linares			0-0 Iberia
Lota Schwager		2-2 Green Cross
Huachipato		2-1 Laja
Malleco Unido		bye

Round 14
Northern Group  
Ovalle			0-3 Unión Calera
La Serena		1-2 Santiago Morning
Cobresal		4-1 Colchagua
Coquimbo Unido		2-0 San Antonio Unido
San Luis		bye
Southern Group  
Concepción		0-1 Huachipato
Laja			0-1 Lota Schwager
Green Cross		2-2 Linares
Malleco Unido		3-0 Ñublense
Iberia			bye

Round 15
Northern Group  
Coquimbo Unido		1-0 Ovalle
San Antonio Unido	1-2 San Luis
Colchagua		0-0 La Serena
Santiago Morning	2-2 Unión Calera
Cobresal		bye
Southern Group  
Lota Schwager		2-2 Huachipato
Malleco Unido		0-0 Concepción
Linares			1-1 Laja	
Ñublense		2-1 Iberia
Green Cross		bye

Round 16
Northern Group  
Ovalle			1-1 Santiago Morning
Unión Calera		4-0 Colchagua
Cobresal		4-0 San Antonio Unido
San Luis		1-1 Coquimbo Unido
La Serena		bye
Southern Group  
Concepción		1-0 Lota Schwager
Huachipato		5-0 Linares
Green Cross		3-0 Ñublense
Iberia			1-0 Malleco Unido
Laja			bye

Round 17
Northern Group  
San Luis		4-0 Ovalle
Coquimbo Unido		0-3 Cobresal
San Antonio Unido	0-0 La Serena
Colchagua		1-2 Santiago Morning
Unión Calera		bye
Southern Group 
Iberia			1-0 Concepción
Malleco Unido		1-0 Green Cross
Ñublense		1-0 Laja	
Linares			1-0 Lota Schwager
Huachipato		bye

Round 18
Northern Group
Ovalle			1-0 Colchagua
Unión Calera		2-3 San Antonio Unido
La Serena		1-1 Coquimbo Unido
Cobresal		3-0 San Luis
Santiago Morning	bye
Southern Group  
Concepción		1-0 Linares
Huachipato		3-4 Ñublense
Laja			2-1 Malleco Unido
Green Cross		4-0 Iberia
Lota Schwager		bye

Final Tables:

Northern Group		
 1.COBRESAL		16 10  4  2  31-10  24  - Classified      
 2.UNIÓN CALERA		16  8  5  3  29-18  21  - Classified    
 3.SAN LUIS	 	16  8  4  4  32-18  20  - Classified  
 4.COQUIMBO UNIDO	16  7  4  5  19-17  18  - Classified  
 5.Ovalle		16  6  5  5   9-15  17    
 6.San Antonio Unido	16  4  5  7  15-21  13      
 7.La Serena		16  2  7  7  17-24  11   
 8.Santiago Morning     16  4  3  9  22-36  11   
 9.Colchagua		16  1  7  8  11-26   9      

Southern Group	
 1.LINARES		16  8  4  4  22-17  20  - Classified  
 2.IBERIA		16  9  2  5  20-17  20  - Classified  
 3.HUACHIPATO		16  7  5  4  28-17  19  - Classified  
 4.CONCEPCIÓN		16  7  5  4  18-14  19  - Classified      
 5.Green Cross-Temuco	16  7  4  5  28-22  18        
 6.Lota Schwager	16  5  7  4  23-21  17        
 7.Ñublense		16  6  3  7  20-27  15   
 8.Malleco Unido	16  4  3  9  15-23  11          
 9.Laja			16  1  3 12  10-26   5   

Second Phase

Final Tables:

Group A		
 1.COBRESAL		 6  2  4  0  10- 4   8  - Classified  
 2.COQUIMBO UNIDO	 6  3  2  1   7- 5   8  - Classified    
 3.Iberia		 6  3  1  2  10- 7   7
 4.Linares		 6  0  1  5   2-13   1

Group B		
 1.HUACHIPATO		 6  3  2  1  11- 9   8  - Classified  
 2.SAN LUIS		 6  2  4  0   5- 3   8  - Classified  
 3.Unión Calera		 6  3  1  2  13-10   7
 4.Concepción		 6  0  1  5   1- 8   1   

Round 1
Group A
Coquimbo Unido   	2-1 Iberia
Linares			0-0 Cobresal
Group B
Unión Calera		6-3 Huachipato
Concepción		0-1 San Luis			 	 

Round 2
Group A
Cobresal		2-2 Coquimbo Unido
Iberia			2-0 Linares		 
Group B
San Luis		1-1 Unión Calera
Huachipato		1-0 Concepción			 	 

Round 3
Group A
Coquimbo Unido		2-0 Linares
Cobresal		2-1 Iberia		 
Group B
Unión Calera		1-0 Concepción
San Luis		1-1 Huachipato			 	 

Round 4
Group A
Iberia			2-0 Coquimbo Unido
Cobresal		5-0 Linares		 
Group B
Huachipato		3-2 Unión Calera
San Luis		0-0 Concepción			 	 

Round 5
Group A
Coquimbo Unido		0-0 Cobresal
Linares			2-3 Iberia		 
Group B
Unión Calera		1-2 San Luis
Concepción		0-3 Huachipato			 	 

Round 6
Group A
Linares			0-1 Coquimbo Unido
Iberia			1-1 Cobresal		 
Group B
Concepción		1-2 Unión Calera
Huachipato		0-0 San Luis			 	 

Final Tables:

Group A		
 1.COBRESAL		 6  2  4  0  10- 4   8  - Classified  
 2.COQUIMBO UNIDO	 6  3  2  1   7- 5   8  - Classified    
 3.Iberia		 6  3  1  2  10- 7   7
 4.Linares		 6  0  1  5   2-13   1

Group B		
 1.HUACHIPATO		 6  3  2  1  11- 9   8  - Classified  
 2.SAN LUIS		 6  2  4  0   5- 3   8  - Classified  
 3.Unión Calera		 6  3  1  2  13-10   7
 4.Concepción		 6  0  1  5   1- 8   1   

Final Phase

Round 1
Huachipato		2-1 Coquimbo Unido
Cobresal		1-1 San Luis

Round 2
Huachipato		2-2 San Luis
Cobresal		3-2 Coquimbo Unido

Round 3
Huachipato		2-1 Cobresal
San Luis		2-1 Coquimbo Unido

Final Table:

 1.HUACHIPATO		 3  2  1  0   6- 4   5  - Winners 
 2.San Luis		 3  1  2  0   5- 4   4
 3.Cobresal		 3  1  1  1   5- 5   3   
 4.Coquimbo Unido	 3  0  0  3   4- 7   0

Huachipato were the winners of Campeonato de Apertura  

Note: Huachipato obtained 2 bonus points, and San Luis, Cobresal and
      Coquimbo Unido 1 bonus point for Campeonato Oficial 
      Talcahuano with Huachipato and Temuco with Green Cross were promoted 
      after the Campeonato de Apertura as “good venues”.
      As Huachipato were promoted, their bonus points do not count for the 
      First Division Campeonato Oficial
	
Note: A short cup was played among some Second Division teams. It was played
      in five rounds and did not have any other intention than complete the
      annual calendar and get some money for clubs involved.

Final Tables:

Northern Group
 1.SANTIAGO MORNING	 5  3  1  1  11- 5   7  - Winners
 2.Colchagua		 5  2  3  0  11- 7   7  
 3.Ovalle		 5  1  1  3   5- 6   3
 4.La Serena		 5  1  0  4   3- 9   2
 5.San Antonio Unido	 5  0  2  3   5-12   2

Southern Group		
 1.LAJA			 5  4  1  0   7- 3   9  - Winners
 2.Concepción		 5  3  2  0   7- 3   8
 3.Lota Schwager	 5  2  0  3   6- 6   4
 4.Ñublense		 5  1  2  2   5- 6   4
 5.Malleco Unido	 5  1  2  2   2- 5   4

Round 1
Northern Group
La Serena		0-3 Colchagua
Santiago Morning	2-1 Ovalle
Southern Group
Laja			1-0 Malleco Unido
Concepción		3-2 Ñublense
Intergroup
San Antonio Unido	1-2 Lota Schwager

Round 2
Northern Group
Colchagua		2-2 Santiago Morning
Ovalle			0-0 San Antonio Unido
Southern Group
Ñublense		0-1 Laja	
Malleco Unido		0-3 Lota Schwager
Intergroup
Concepción		1-0 La Serena

Round 3
Northern Group
San Antonio Unido	3-3 Colchagua
Santiago Morning	1-0 La Serena
Southern Group 
Lota Schwager		0-1 Ñublense
Laja			1-1 Concepción
Intergroup
Ovalle			1-2 Malleco Unido

Round 4
Northern Group
La Serena		2-1 San Antonio Unido
Colchagua		1-0 Ovalle
Southern Group 
Concepción		2-0 Lota Schwager
Ñublense		0-0 Malleco Unido
Intergroup
Santiago Morning	1-2 Laja	

Round 5
Northern Group
Ovalle			3-1 La Serena
San Antonio Unido	0-5 Santiago Morning
Southern Group 
Malleco Unido		0-0 Concepción
Lota Schwager		1-2 Laja	
Intergroup
Ñublense		2-2 Colchagua

Final Tables:

Northern Group
 1.SANTIAGO MORNING	 5  3  1  1  11- 5   7  - Winners
 2.Colchagua		 5  2  3  0  11- 7   7  
 3.Ovalle		 5  1  1  3   5- 6   3
 4.La Serena		 5  1  0  4   3- 9   2
 5.San Antonio Unido	 5  0  2  3   5-12   2

Southern Group		
 1.LAJA			 5  4  1  0   7- 3   9  - Winners
 2.Concepción		 5  3  2  0   7- 3   8
 3.Lota Schwager	 5  2  0  3   6- 6   4
 4.Ñublense		 5  1  2  2   5- 6   4
 5.Malleco Unido	 5  1  2  2   2- 5   4

Note: Ñublense changed name to Ñuble Unido from Campeonato Oficial on.

Campeonato Oficial

First Phase

Final Tables:

Northern Group	
 1.Cobresal		22 17  5  0  48-10  1  40  (El Salvador)      
 2.San Luis		22 11  8  3  30-19  1  31  (Quillota)                    
 3.La Serena		22  8  8  6  32-31  0  24  (La Serena)         
 4.Unión Calera		22  8  7  7  31-28  0  23  (La Calera)                    
 5.Unión Santa Cruz	22  7  8  7  35-34  0  22  (Santa Cruz)                   
 6.Ovalle		22  8  6  8  23-20  0  22  (Ovalle)          
 7.Coquimbo Unido	22  7  6  9  33-28  1  21  (Coquimbo)    
 8.San Antonio Unido	22  8  5  9  25-30  0  21  (San Antonio)       
 9.Quintero Unido	22  7  5 10  22-34  0  19  (Quintero)    
10.General Velásquez	22  6  5 11  26-39  0  17  (San Vicente de Tagua Tagua)  
11.Colchagua		22  5  4 13  32-46  0  14  (San Fernando)                  
12.Santiago Morning	22  4  5 13  27-45  0  13  (Santiago)      

Southern Group	
 1.Laja  		22 12  6  4  38-26  0  30  (Laja)    
 2.Concepción		22 11  4  7  28-22  0  26  (Concepción) 
 3.Victoria		22  8  8  6  28-21  0  24  (Victoria)
 4.Malleco Unido	22  7 10  5  26-19  0  24  (Angol)     
 5.Lota Schwager	22 10  4  8  27-27  0  24  (Coronel)  
 6.Iberia		22  8  7  7  29-29  0  23  (Los Angeles)    
 7.Linares		22  6 10  6  36-35  0  22  (Linares)               
 8.Puerto Montt		22  6  9  7  28-29  0  21  (Puerto Montt)  
 9.Valdivia		22  6  9  7  26-29  0  21  (Valdivia)           
10.Ñuble Unido		22  7  4 11  25-30  0  18  (Chillán)
11.Curicó Unido		22  4  9  9  25-37  0  17  (Curicó) 
12.Osorno		22  2 10 10  20-32  0  14  (Osorno)

Round 1
Northern Group
Unión Santa Cruz	2-2 San Luis
Cobresal		6-0 Quintero Unido
La Serena		1-2 San Antonio Unido
General Velásquez	2-2 Coquimbo Unido
Ovalle			1-0 Santiago Morning
Unión Calera		3-1 Colchagua
Southern Group
Valdivia		1-1 Ñuble Unido
Concepción		1-2 Puerto Montt
Laja  			2-0 Victoria
Malleco Unido		1-0 Iberia
Osorno			2-1 Lota Schwager
Curicó Unido		0-0 Linares

Round 2
Northern Group
Unión Calera		2-1 Unión Santa Cruz
Colchagua		3-2 Ovalle
Santiago Morning	3-2 General Velásquez
Coquimbo Unido		2-0 La Serena
San Antonio Unido	0-2 Cobresal
Quintero Unido		1-3 San Luis
Southern Group
Curicó Unido		2-1 Valdivia
Linares			4-1 Osorno	
Lota Schwager		0-4 Malleco Unido
Iberia			2-1 Laja  
Victoria		0-0 Concepción
Puerto Montt		2-0 Ñuble Unido

Round 3
Northern Group
Unión Santa Cruz	1-0 Quintero Unido
San Luis		1-0 San Antonio Unido	 
Cobresal		3-0 Coquimbo Unido
La Serena		0-1 Santiago Morning
General Velásquez	3-2 Colchagua
Ovalle			2-0 Unión Calera
Southern Group
Valdivia		1-3 Puerto Montt
Ñuble Unido		1-0 Victoria
Concepción		2-0 Iberia
Laja  			2-1 Lota Schwager
Malleco Unido		1-1 Linares
Osorno			2-2 Curicó Unido

Round 4
Northern Group
Ovalle			1-1 Unión Santa Cruz
Unión Calera		4-0 General Velásquez	 
Colchagua		1-1 La Serena
Santiago Morning	0-1 Cobresal
Coquimbo Unido		1-2 San Luis
San Antonio Unido	0-0 Quintero Unido
Southern Group
Osorno			0-0 Valdivia
Curicó Unido		1-2 Malleco Unido
Linares			0-2 Laja  	
Lota Schwager		2-1 Concepción
Iberia			3-1 Ñuble Unido
Victoria		2-1 Puerto Montt

Round 5
Northern Group
Unión Santa Cruz	1-1 San Antonio Unido
Quintero Unido		2-0 Coquimbo Unido	 
San Luis		2-1 Santiago Morning
Cobresal		2-0 Colchagua
La Serena		1-1 Unión Calera
General Velásquez	1-0 Ovalle
Southern Group
Valdivia		1-0 Victoria
Puerto Montt		1-1 Iberia
Ñuble Unido		0-2 Lota Schwager
Concepción		2-0 Linares
Laja  			1-1 Curicó Unido		
Malleco Unido		2-1 Osorno

Round 6	
Northern Group
General Velásquez	1-1 Unión Santa Cruz			 
Ovalle			0-1 La Serena
Unión Calera		1-1 Cobresal
Colchagua		0-1 San Luis
Santiago Morning	0-1 Quintero Unido
Coquimbo Unido		4-2 San Antonio Unido
Southern Group
Malleco Unido		1-1 Valdivia
Osorno			0-1 Laja  
Curicó Unido		2-3 Concepción
Linares			1-1 Ñuble Unido	
Lota Schwager		3-0 Puerto Montt
Iberia			2-0 Victoria

Round 7
Northern Group
Unión Santa Cruz	1-0 Coquimbo Unido	 
San Antonio Unido	3-1 Santiago Morning
Quintero Unido		4-2 Colchagua
San Luis		2-2 Unión Calera
Cobresal		1-1 Ovalle
La Serena		2-1 General Velásquez
Southern Group
Valdivia		1-1 Iberia
Victoria		1-1 Lota Schwager
Puerto Montt		0-0 Linares
Ñuble Unido		0-1 Curicó Unido
Concepción		3-1 Osorno
Laja  			1-1 Malleco Unido

Round 8
Northern Group
La Serena		4-2 Unión Santa Cruz	 
General Velásquez	1-2 Cobresal	
Ovalle			0-2 San Luis
Unión Calera		0-0 Quintero Unido
Colchagua		0-1 San Antonio Unido
Santiago Morning	2-2 Coquimbo Unido
Southern Group
Laja  			3-2 Valdivia
Malleco Unido		1-1 Concepción
Osorno			2-1 Ñuble Unido
Curicó Unido		3-3 Puerto Montt
Linares			2-2 Victoria	
Lota Schwager		1-0 Iberia

Round 9
Northern Group
Unión Santa Cruz	4-1 Santiago Morning	 
Coquimbo Unido		0-0 Colchagua
San Antonio Unido	0-2 Unión Calera
Quintero Unido		0-2 Ovalle
San Luis		1-1 General Velásquez
Cobresal		2-1 La Serena
Southern Group
Valdivia		1-0 Lota Schwager
Iberia			5-3 Linares
Victoria		5-1 Curicó Unido
Puerto Montt		2-2 Osorno
Ñuble Unido		0-0 Malleco Unido
Concepción		0-1 Laja  

Round 10
Northern Group
Cobresal		1-1 Unión Santa Cruz	 
La Serena		1-1 San Luis
General Velásquez	3-0 Quintero Unido	
Ovalle			0-0 San Antonio Unido
Unión Calera		2-0 Coquimbo Unido
Colchagua		4-0 Santiago Morning
Southern Group
Concepción		1-3 Valdivia
Laja  			1-0 Ñuble Unido
Malleco Unido		3-0 Puerto Montt
Osorno			1-1 Victoria
Curicó Unido		0-0 Iberia
Linares			3-2 Lota Schwager

Round 11
Northern Group
Unión Santa Cruz	5-2 Colchagua	 
Santiago Morning	2-4 Unión Calera	
Coquimbo Unido		0-1 Ovalle
San Antonio Unido	2-1 General Velásquez
Quintero Unido		1-1 La Serena
San Luis		0-1 Cobresal
Southern Group
Valdivia		2-1 Linares
Lota Schwager		1-0 Curicó Unido
Iberia			1-0 Osorno
Victoria		1-1 Malleco Unido
Puerto Montt		1-1 Laja  
Ñuble Unido		3-1 Concepción

Round 12
Northern Group
San Luis		1-1 Unión Santa Cruz
Quintero Unido		0-2 Cobresal	 
San Antonio Unido	2-3 La Serena
Coquimbo Unido		4-0 General Velásquez	
Santiago Morning	1-2 Ovalle
Colchagua		3-1 Unión Calera
Southern Group
Ñuble Unido		4-3 Valdivia
Puerto Montt		1-2 Concepción
Victoria		2-0 Laja  
Iberia			2-0 Malleco Unido
Lota Schwager		1-1 Osorno
Linares			1-1 Curicó Unido

Round 13
Northern Group
Unión Santa Cruz	1-0 Unión Calera
Ovalle			3-0 Colchagua
General Velásquez	2-1 Santiago Morning	
La Serena		3-2 Coquimbo Unido
Cobresal		2-0 San Antonio Unido	
San Luis		3-3 Quintero Unido
Southern Group
Valdivia		1-1 Curicó Unido
Osorno			1-1 Linares
Malleco Unido		0-0 Lota Schwager
Laja  			3-0 Iberia
Concepción		1-0 Victoria
Ñuble Unido		0-1 Puerto Montt

Round 14
Northern Group
Quintero Unido		1-0 Unión Santa Cruz
San Antonio Unido	1-1 San Luis
Coquimbo Unido		2-2 Cobresal
Santiago Morning	2-2 La Serena
Colchagua		3-1 General Velásquez	
Unión Calera		2-1 Ovalle
Southern Group
Puerto Montt		1-1 Valdivia
Victoria		2-0 Ñuble Unido
Iberia			1-2 Concepción
Lota Schwager		0-3 Laja  
Linares			4-2 Malleco Unido
Curicó Unido		1-0 Osorno

Round 15
Northern Group
Unión Santa Cruz	2-0 Ovalle
General Velásquez	2-1 Unión Calera
La Serena		2-1 Colchagua
Cobresal		3-1 Santiago Morning	
San Luis		1-0 Coquimbo Unido
Quintero Unido		0-1 San Antonio Unido	
Southern Group
Valdivia		1-1 Osorno
Malleco Unido		3-1 Curicó Unido
Laja  			3-3 Linares
Concepción		0-1 Lota Schwager
Ñuble Unido		3-1 Iberia
Puerto Montt		2-3 Victoria

Round 16
Northern Group
San Antonio Unido	1-1 Unión Santa Cruz
Coquimbo Unido		4-1 Quintero Unido
Santiago Morning	1-0 San Luis
Colchagua		0-2 Cobresal
Unión Calera		1-1 La Serena
Ovalle			0-0 General Velásquez	
Southern Group
Victoria		0-0 Valdivia
Iberia			1-1 Puerto Montt
Lota Schwager		2-1 Ñuble Unido
Linares			0-1 Concepción
Curicó Unido		3-1 Laja  
Osorno			0-2 Malleco Unido

Round 17
Northern Group
Unión Santa Cruz	1-2 General Velásquez
La Serena		0-0 Ovalle	 
Cobresal		2-0 Unión Calera
San Luis		3-1 Colchagua
Quintero Unido		2-0 Santiago Morning	
San Antonio Unido	0-3 Coquimbo Unido
Southern Group
Valdivia		1-0 Malleco Unido
Laja  			4-3 Osorno	
Concepción		2-1 Curicó Unido
Ñuble Unido		2-3 Linares
Puerto Montt		0-0 Lota Schwager
Victoria		4-1 Iberia

Round 18
Northern Group
Coquimbo Unido		1-1 Unión Santa Cruz
Santiago Morning	2-1 San Antonio Unido
Colchagua		0-0 Quintero Unido
Unión Calera		0-0 San Luis
Ovalle			1-1 Cobresal
General Velásquez	2-2 La Serena
Southern Group
Iberia			2-1 Valdivia	
Lota Schwager		2-1 Victoria
Linares			3-1 Puerto Montt
Curicó Unido		1-3 Ñuble Unido
Osorno			0-0 Concepción
Malleco Unido		2-2 Laja  

Round 19
Northern Group
Unión Santa Cruz	2-3 La Serena
Cobresal		4-0 General Velásquez
San Luis		2-1 Ovalle
Quintero Unido		2-1 Unión Calera
San Antonio Unido	3-1 Colchagua
Coquimbo Unido		1-1 Santiago Morning	
Southern Group
Valdivia		1-0 Laja  
Concepción		0-0 Malleco Unido
Ñuble Unido		1-0 Osorno
Puerto Montt		4-0 Curicó Unido
Victoria		2-1 Linares
Iberia			2-0 Lota Schwager

Round 20
Northern Group
Santiago Morning	1-2 Unión Santa Cruz
Colchagua		0-2 Coquimbo Unido	 
Unión Calera		2-1 San Antonio Unido
Ovalle			2-1 Quintero Unido
General Velásquez	0-1 San Luis
La Serena		0-2 Cobresal
Southern Group
Lota Schwager		3-1 Valdivia
Linares			1-1 Iberia	
Curicó Unido		0-0 Victoria	
Osorno			0-0 Puerto Montt
Malleco Unido		0-1 Ñuble Unido
Laja  			2-1 Concepción

Round 21
Northern Group
Unión Santa Cruz	1-5 Cobresal
San Luis		1-0 La Serena	 
Quintero Unido		1-0 General Velásquez
San Antonio Unido	2-1 Ovalle
Coquimbo Unido		3-0 Unión Calera
Santiago Morning	4-4 Colchagua
Southern Group
Valdivia		1-3 Concepción	
Ñuble Unido		2-2 Laja  
Puerto Montt		1-0 Malleco Unido
Victoria		2-1 Osorno
Iberia			2-2 Curicó Unido
Lota Schwager		2-3 Linares

Round 22
Northern Group
Colchagua		4-3 Unión Santa Cruz
Unión Calera		2-2 Santiago Morning	 
Ovalle			2-0 Coquimbo Unido
General Velásquez	1-2 San Antonio Unido
La Serena		3-2 Quintero Unido	
Cobresal		1-0 San Luis
Southern Group
Linares			1-1 Valdivia	
Curicó Unido		1-2 Lota Schwager
Osorno			1-1 Iberia
Malleco Unido		0-0 Victoria
Laja  			2-1 Puerto Montt
Concepción		1-0 Ñuble Unido

Final Tables:

Northern Group	
 1.Cobresal		22 17  5  0  48-10  1  40  (El Salvador)      
 2.San Luis		22 11  8  3  30-19  1  31  (Quillota)                    
 3.La Serena		22  8  8  6  32-31  0  24  (La Serena)         
 4.Unión Calera		22  8  7  7  31-28  0  23  (La Calera)                    
 5.Unión Santa Cruz	22  7  8  7  35-34  0  22  (Santa Cruz)                   
 6.Ovalle		22  8  6  8  23-20  0  22  (Ovalle)          
 7.Coquimbo Unido	22  7  6  9  33-28  1  21  (Coquimbo)    
 8.San Antonio Unido	22  8  5  9  25-30  0  21  (San Antonio)       
 9.Quintero Unido	22  7  5 10  22-34  0  19  (Quintero)    
10.General Velásquez	22  6  5 11  26-39  0  17  (San Vicente de Tagua Tagua)  
11.Colchagua		22  5  4 13  32-46  0  14  (San Fernando)                  
12.Santiago Morning	22  4  5 13  27-45  0  13  (Santiago)      

Southern Group	
 1.Laja  		22 12  6  4  38-26  0  30  (Laja)    
 2.Concepción		22 11  4  7  28-22  0  26  (Concepción) 
 3.Victoria		22  8  8  6  28-21  0  24  (Victoria)
 4.Malleco Unido	22  7 10  5  26-19  0  24  (Angol)     
 5.Lota Schwager	22 10  4  8  27-27  0  24  (Coronel)  
 6.Iberia		22  8  7  7  29-29  0  23  (Los Angeles)    
 7.Linares		22  6 10  6  36-35  0  22  (Linares)               
 8.Puerto Montt		22  6  9  7  28-29  0  21  (Puerto Montt)  
 9.Valdivia		22  6  9  7  26-29  0  21  (Valdivia)           
10.Ñuble Unido		22  7  4 11  25-30  0  18  (Chillán)
11.Curicó Unido		22  4  9  9  25-37  0  17  (Curicó) 
12.Osorno		22  2 10 10  20-32  0  14  (Osorno)

Second Phase

NB: the first six teams of a group played against the last six teams of the 
    other one.

Final Tables:

Group A      	
 1.Cobresal		11  6  4  1  19- 8  16  (El Salvador)      
 2.La Serena		11  7  2  2  22-15  16  (La Serena)         
 3.Osorno		11  5  4  2  12-11  14  (Osorno)
 4.Unión Calera		11  5  3  3  20-16  13  (La Calera)                    
 5.San Luis		11  6  1  4  23-13  13  (Quillota)                    
 6.Linares		11  5  2  4  20-15  12  (Linares)               
 7.Puerto Montt		11  5  2  4  17-18  12  (Puerto Montt)  
 8.Valdivia		11  3  3  5  14-19   9  (Valdivia)           
 9.Unión Santa Cruz	11  3  2  6  22-24   8  (Santa Cruz)                   
10.Curicó Unido		11  2  4  5  13-21   8  (Curicó) 
11.Ñuble Unido		11  2  2  7  12-21   6  (Chillán)
12.Ovalle		11  2  1  8   8-21   5  (Ovalle)          

Group B		
 1.Coquimbo Unido	11  7  3  1  25-10  17  (Coquimbo)    
 2.Malleco Unido	11  5  6  0  21-11  16  (Angol)     
 3.Lota Schwager	11  4  5  2  13-14  13  (Coronel)  
 4.General Velásquez	11  3  6  2  22-17  12  (San Vicente de Tagua Tagua)  
 5.Quintero Unido	11  4  4  3  18-13  12  (Quintero)    
 6.Laja  		11  3  6  2  17-12  12  (Laja)    
 7.Victoria		11  4  4  3  15-14  12  (Victoria)
 8.Concepción		11  3  4  4  15-17  10  (Concepción) 
 9.Colchagua		11  2  5  4  12-14   9  (San Fernando)                  
10.San Antonio Unido	11  2  3  6  11-24   7  (San Antonio)       
11.Santiago Morning	11  1  4  6  11-21   6  (Santiago)      
12.Iberia		11  1  4  6   7-20   6  (Los Angeles)  

Round 1
Group A
San Luis		4-0 Ñuble Unido
Cobresal		4-1 Osorno
La Serena		3-2 Curicó Unido
Valdivia		2-1 Ovalle
Puerto Montt		2-0 Linares
Unión Santa Cruz	4-2 Unión Calera
Group B
Laja  			0-0 Colchagua
Quintero Unido		2-2 General Velásquez
Victoria		0-1 Lota Schwager
Concepción		1-1 Coquimbo Unido
Iberia			0-0 San Antonio Unido
Santiago Morning	1-1 Malleco Unido

Round 2
Group A
Unión Santa Cruz	1-0 San Luis
Unión Calera		6-1 Puerto Montt
Linares			3-0 Valdivia
Ovalle      		1-2 La Serena
Curicó Unido		1-4 Cobresal
Osorno			2-1 Ñuble Unido
Group B
Santiago Morning	1-3 Laja  
Malleco Unido		2-0 Iberia	
San Antonio Unido	3-1 Concepción
Coquimbo Unido		4-0 Victoria
Lota Schwager		2-1 Quintero Unido
General Velásquez	0-0 Colchagua

Round 3
Group A
San Luis		2-0 Osorno
Ñuble Unido		1-1 Curicó Unido	 
Cobresal		1-0 Ovalle
La Serena		2-1 Linares
Valdivia		3-0 Unión Calera
Puerto Montt		4-2 Unión Santa Cruz
Group B
Laja  			2-2 General Velásquez
Colchagua		1-1 Lota Schwager
Quintero Unido		3-1 Coquimbo Unido
Victoria		3-0 San Antonio Unido
Concepción		2-2 Malleco Unido
Iberia			3-3 Santiago Morning

Round 4
Group A
Puerto Montt		1-0 San Luis
Unión Santa Cruz	1-1 Valdivia	 
Unión Calera		2-1 La Serena
Linares			0-0 Cobresal
Ovalle			2-1 Ñuble Unido
Curicó Unido		0-0 Osorno
Group B
Iberia			0-1 Laja  
Santiago Morning	2-4 Concepción
Malleco Unido		1-1 Victoria	
San Antonio Unido	1-3 Quintero Unido
Coquimbo Unido		2-0 Colchagua
Lota Schwager		2-2 General Velásquez

Round 5
Group A
San Luis		6-2 Curicó Unido
Osorno			1-0 Ovalle	 
Ñuble Unido		1-2 Linares
Cobresal		2-2 Unión Calera
La Serena		6-5 Unión Santa Cruz
Valdivia		2-2 Puerto Montt
Group B
Laja  			1-1 Lota Schwager
General Velásquez	1-3 Coquimbo Unido
Colchagua		2-3 San Antonio Unido
Quintero Unido		1-2 Malleco Unido
Victoria		1-0 Santiago Morning		
Concepción		0-1 Iberia

Round 6	
Group A
Valdivia		3-0 San Luis			 
Puerto Montt		1-1 La Serena
Unión Santa Cruz	0-0 Cobresal
Unión Calera		3-0 Ñuble Unido
Linares			0-0 Osorno
Ovalle			1-1 Curicó Unido
Group B
Concepción		2-1 Laja  
Iberia			0-1 Victoria
Santiago Morning	0-0 Quintero Unido
Malleco Unido		3-0 Colchagua	
San Antonio Unido	1-1 General Velásquez
Coquimbo Unido		5-1 Lota Schwager

Round 7
Group A
San Luis		3-0 Ovalle	 
Curicó Unido		1-2 Linares
Osorno			3-1 Unión Calera
Ñuble Unido		3-1 Unión Santa Cruz
Cobresal		1-0 Puerto Montt
La Serena		2-1 Valdivia
Group B
Laja  			0-0 Coquimbo Unido
Lota Schwager		1-1 San Antonio Unido
General Velásquez	1-1 Malleco Unido
Colchagua		1-1 Santiago Morning
Quintero Unido		4-0 Iberia
Victoria		1-1 Concepción

Round 8
Group A
La Serena		2-1 San Luis	 
Valdivia		0-4 Cobresal	
Puerto Montt		2-1 Ñuble Unido
Unión Santa Cruz	0-1 Osorno
Unión Calera		1-1 Curicó Unido
Linares			4-2 Ovalle
Group B
Victoria		3-3 Laja  
Concepción		1-1 Quintero Unido
Iberia			1-1 Colchagua
Santiago Morning	1-4 General Velásquez
Malleco Unido		2-1 Lota Schwager	
San Antonio Unido	1-3 Coquimbo Unido

Round 9
Group A
San Luis		3-2 Linares	 
Ovalle			0-1 Unión Calera
Curicó Unido		1-0 Unión Santa Cruz
Osorno			3-2 Puerto Montt
Ñuble Unido		3-0 Valdivia
Cobresal		1-0 La Serena
Group B
Laja  			5-0 San Antonio Unido
Coquimbo Unido		2-2 Malleco Unido
Lota Schwager		2-1 Santiago Morning
General Velásquez	6-1 Iberia
Colchagua		3-0 Concepción
Quintero Unido		1-1 Victoria

Round 10
Group A
Cobresal		1-3 San Luis	 
La Serena		3-0 Ñuble Unido
Valdivia		1-1 Osorno	
Puerto Montt		2-1 Curicó Unido
Unión Santa Cruz	5-0 Ovalle
Unión Calera		1-0 Linares
Group B
Quintero Unido		2-0 Laja  
Victoria		3-1 Colchagua
Concepción		3-1 General Velásquez
Iberia			0-0 Lota Schwager
Santiago Morning	0-2 Coquimbo Unido
Malleco Unido		4-1 San Antonio Unido

Round 11
Group A
San Luis		1-1 Unión Calera	 
Linares			6-3 Unión Santa Cruz	
Ovalle			1-0 Puerto Montt
Curicó Unido		2-1 Valdivia
Osorno			0-0 La Serena
Ñuble Unido		1-1 Cobresal
Group B
Laja  			1-1 Malleco Unido
San Antonio Unido	0-1 Santiago Morning
Coquimbo Unido		2-1 Iberia
Lota Schwager		1-0 Concepción
General Velásquez	2-1 Victoria
Colchagua		3-0 Quintero Unido

Final Tables:

Group A      	
 1.Cobresal		11  6  4  1  19- 8  16  (El Salvador)      
 2.La Serena		11  7  2  2  22-15  16  (La Serena)         
 3.Osorno		11  5  4  2  12-11  14  (Osorno)
 4.Unión Calera		11  5  3  3  20-16  13  (La Calera)                    
 5.San Luis		11  6  1  4  23-13  13  (Quillota)                    
 6.Linares		11  5  2  4  20-15  12  (Linares)               
 7.Puerto Montt		11  5  2  4  17-18  12  (Puerto Montt)  
 8.Valdivia		11  3  3  5  14-19   9  (Valdivia)           
 9.Unión Santa Cruz	11  3  2  6  22-24   8  (Santa Cruz)                   
10.Curicó Unido		11  2  4  5  13-21   8  (Curicó) 
11.Ñuble Unido		11  2  2  7  12-21   6  (Chillán)
12.Ovalle		11  2  1  8   8-21   5  (Ovalle)          

Group B		
 1.Coquimbo Unido	11  7  3  1  25-10  17  (Coquimbo)    
 2.Malleco Unido	11  5  6  0  21-11  16  (Angol)     
 3.Lota Schwager	11  4  5  2  13-14  13  (Coronel)  
 4.General Velásquez	11  3  6  2  22-17  12  (San Vicente de Tagua Tagua)  
 5.Quintero Unido	11  4  4  3  18-13  12  (Quintero)    
 6.Laja  		11  3  6  2  17-12  12  (Laja)    
 7.Victoria		11  4  4  3  15-14  12  (Victoria)
 8.Concepción		11  3  4  4  15-17  10  (Concepción) 
 9.Colchagua		11  2  5  4  12-14   9  (San Fernando)                  
10.San Antonio Unido	11  2  3  6  11-24   7  (San Antonio)       
11.Santiago Morning	11  1  4  6  11-21   6  (Santiago)      
12.Iberia		11  1  4  6   7-20   6  (Los Angeles)    

Aggregate Table:

 1.COBRESAL		33 23  9  1  67-18  1  56  (El Salvador) - Promoted and Champions    
 2.San Luis		33 17  9  7  53-32  1  44  (Quillota) - Promoted                   
 3.Laja  		33 15 12  6  55-38  0  42  (Laja) – To Promotion Group    
 4.Malleco Unido	33 12 16  5  47-30  0  40  (Angol) – To Promotion Group        
 5.La Serena		33 15 10  8  54-46  0  40  (La Serena) – To Promotion Group            
 6.Coquimbo Unido	33 14  9 10  58-38  1  38  (Coquimbo) – To Promotion Group        
 7.Lota Schwager	33 14  9 10  40-41  0  37  (Coronel)  
 8.Victoria		33 12 12  9  43-35  0  36  (Victoria)
 9.Unión Calera		33 13 10 10  51-44  0  36  (La Calera)                    
10.Concepción		33 14  8 11  43-39  0  36  (Concepción) 
11.Linares		33 11 12 10  56-50  0  34  (Linares)               
12.Puerto Montt		33 11 11 11  45-47  0  33  (Puerto Montt)  
13.Quintero Unido	33 11  9 13  40-47  0  31  (Quintero)    
14.Unión Santa Cruz	33 10 10 13  57-58  0  30  (Santa Cruz)                   
15.Valdivia		33  9 12 12  40-48  0  30  (Valdivia)            
16.General Velásquez	33  9 11 13  48-56  0  29  (San Vicente de Tagua Tagua)  
17.Iberia		33  9 11 13  36-49  0  29  (Los Angeles)    
18.Osorno		33  7 14 12  32-43  0  28  (Osorno)      
19.San Antonio Unido	33 10  8 15  36-54  0  28  (San Antonio) – To Relegation Group         
20.Ovalle		33 10  7 16  31-41  0  27  (Ovalle) – To Relegation Group             
21.Curicó Unido		33  6 13 14  38-58  0  25  (Curicó) – To Relegation Group    
22.Ñuble Unido		33  9  6 18  37-51  0  24  (Chillán) – To Relegation Group    
23.Colchagua		33  7  9 17  44-60  0  23  (San Fernando) - Relegated                  
24.Santiago Morning	33  5  9 19  38-66  0  19  (Santiago) - Relegated     

Promotion Group

Round 1
Coquimbo Unido		5-3 Malleco Unido
La Serena		8-3 Laja	 

Round 2
Coquimbo Unido		2-1 Laja
La Serena		3-2 Malleco Unido	 

Round 3
Malleco Unido		3-7 Laja
La Serena		2-2 Coquimbo Unido	 

Final Table:

 3.LA SERENA		 3  2  1  0  13- 7   5  - Promoted
 4.COQUIMBO UNIDO     	 3  2  1  0   9- 6   5  - Promoted
 5.Laja			 3  1  0  2  11-13   2     
 6.Malleco Unido	 3  0  0  3   8-15   0     

Relegation Group

Round 1
Curicó Unido		1-0 Ovalle	
Ñuble Unido		1-0 San Antonio Unido

Round 2
Curicó Unido		2-1 San Antonio Unido
Ovalle			3-1 Ñuble Unido	 

Round 3
San Antonio Unido	0-4 Ovalle	
Ñuble Unido		0-5 Curicó Unido

Final Table:

19.Curicó Unido		 3  3  0  0   8- 1   6  Remain in Second Division             
20.Ovalle		 3  2  0  1   7- 2   4  Remain in Second Division             
21.Ñuble Unido		 3  1  0  2   2- 8   2  Relegated   
22.San Antonio Unido	 3  0  0  3   1- 7   0  Relegated  

Promoted : Cobresal (El Salvador), San Luis (Quillota), La Serena (La Serena) and 
           Coquimbo Unido (Coquimbo).

Relegated: Ñuble Unido (Chillán), San Antonio Unido (San Antonio), Colchagua (San 
           Fernando) and Santiago Morning (Santiago)



Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 22 Jan 2006

(C) Copyright Eduardo Espina and RSSSF 2006

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,352,704 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  1.4476
Total Execution Time  1.4499
  CADENA URL  
/primera_b_apertura_fase_1_chile1983
  GET DATOS  
$_GET['/primera_b_apertura_fase_1_chile1983']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0147  SELECT type FROM routes WHERE alias = 'primera_b_apertura_fase_1_chile1983'
0.0301  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 = 1983 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=290 AND type_rel = 3
0.0155  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.0159  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.0295  SELECT text_es as historical_text FROM leagues_text WHERE id=2412
0.0147  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 = 30658 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 10:15:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 10:15:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 10:15:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 10:15:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0162  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 = 1983 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0150  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (30658) 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.0147  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 (30658) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0148  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (30658) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0149  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 (30658) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0152  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (30658) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0152  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30658) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT e.action, count(e.action) as total, e.player_id FROM events1983 e WHERE e.league_id IN (30658) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0150  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 (30658) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0151  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 = 30658 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0146  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 = 30658 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0152  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=30658 AND rel.round=16
0.0149  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 = 30658 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0151  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 = 30658 AND esl.points > 0
0.0153  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` = 30658 ORDER BY creation_date DESC LIMIT 0, 10
0.0169  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` = 30658
0.0155  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 `calendars1983` 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` = 30658 AND c.`round` = 16 ORDER BY shedule ASC LIMIT 200
0.0147  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 `events1983` e INNER JOIN calendars1983 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 = 16 AND e.real_date IS NOT NULL AND e.league_id = 30658 ORDER BY total DESC LIMIT 40
0.0154  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 `events1983` e INNER JOIN calendars1983 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 = 30658 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0157  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 `tables1983` 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 = 30658 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1983` 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 = 30658 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 30658 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0157  SELECT data1, data2 FROM services_tags WHERE categoryId=290
0.0157  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 290 AND l.year = 1983 ORDER BY l.group_code ASC
0.0157  SELECT group_code, extraName from `leagues` WHERE categoryId=290 AND year=1983