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.

Note: bonus points are given for wins in which the winners scored 4 or
      more goals;
      no points are given for 0-0 draws.

First Phase

Final Tables:

Group 1			 P  W +1  D -1  L  GF GA  PT
 1.ATACAMA		 8  4  0  3  1  1   6- 5  10  - Classified 
 2.ARICA		 8  3  1  3  1  2  10- 5   9  - Classified 
 3.Coquimbo Unido     	 8  3  0  2  0  3  14-11   8   
 4.Cobresal	     	 8  1  1  4  1  3  12-15   6   
 5.Antofagasta		 8  2  1  2  1  4  10-16   6    

Group 2			 P  W +1  D -1  L  GF GA  PT
 1.TRASANDINO		 8  5  2  1  0  2  20-11  13  - Classified 
 2.UNIÓN CALERA		 8  4  2  1  0  3  20-18  11  - Classified
 3.Unión San Felipe	 8  2  2  4  0  2  19-20  10   
 4.Santiago Wanderers	 8  2  0  2  0  4   7-10   6   
 5.Ovalle		 8  2  0  2  0  4  10-17   6   

Group 3			 P  W +1  D -1  L  GF GA  PT
 1.SANTIAGO MORNING	10  5  1  5  0  3  19- 9  16  - Classified 
 2.RANGERS		10  5  0  3  0  2  17-16  13  - Classified
 3.Talagante Ferro	10  4  2  2  0  4  18-13  12   
 4.San Antonio Unido	10  3  1  3  2  4  14-14   8   
 5.Aviación		10  1  0  5  2  4   6-11   5   
 6.Colchagua		10  1  0  4  2  5   8-19   4   

Group 4			 P  W +1  D -1  L  GF GA  PT
 1.LINARES		10  7  1  0  0  3  17-10  15  - Classified
 2.GREEN CROSS		10  3  1  4  1  3  13-10  10  - Classified
 3.Malleco Unido	10  4  0  3  1  3  11- 9  10   
 4.Huachipato		10  2  0  4  1  4  10-17   7   
 5.Iberia		10  1  0  6  2  3  10-12   6   
 6.Lota Schwager	10  2  0  5  3  3   9-12   6

Round 1
Group 1
Antofagasta		0-0 Arica
Coquimbo Unido		2-2 Cobresal
Atacama			bye
Group 2
Unión Calera		3-2 Trasandino 
Unión San Felipe	1-1 Santiago Wanderers 
Ovalle 			bye
Group 3
San Antonio Unido	0-0 Aviación
Colchagua		1-3 Rangers
Talagante Ferro		1-2 Santiago Morning
Group 4
Linares			2-1 Iberia 
Huachipato		1-2 Lota Schwager
Malleco Unido		1-0 Green Cross

Round 2
Group 1
Cobresal		0-0 Atacama
Antofagasta		4-3 Coquimbo Unido
Arica 			bye
Group 2
Trasandino		2-0 Santiago Wanderers
Unión Calera		4-0 Ovalle
Unión San Felipe	bye
Group 3
Aviación		1-1 Santiago Morning
Rangers			3-2 Talagante Ferro
San Antonio Unido	2-0 Colchagua
Group 4
Iberia			2-2 Green Cross
Lota Schwager		2-1 Malleco Unido
Linares			4-1 Huachipato

Round 3
Group 1
Coquimbo Unido		1-0 Arica
Atacama			1-1 Antofagasta
Cobresal		bye
Group 2
Ovalle			1-0 Trasandino
Unión San Felipe	6-3 Unión Calera
Santiago Wanderers	bye
Group 3
Colchagua		0-0 Aviación
Talagante Ferro		3-2 San Antonio Unido
Santiago Morning	1-1 Rangers
Group 4
Huachipato		1-1 Iberia
Malleco Unido		0-2 Linares
Green Cross		0-0 Lota Schwager

Round 4
Group 1
Arica			4-0 Cobresal
Coquimbo Unido		0-1 Atacama
Antofagasta		bye
Group 2
Unión Calera		1-0 Santiago Wanderers
Ovalle			2-2 Unión San Felipe
Trasandino		bye
Group 3
Aviación		1-2 Rangers
San Antonio Unido	1-2 Santiago Morning
Colchagua		0-4 Talagante Ferro
Group 4
Iberia			0-0 Lota Schwager
Linares			1-0 Green Cross
Huachipato		0-0 Malleco Unido

Round 5
Group 1
Atacama			1-0 Arica	
Cobresal		5-2 Antofagasta
Coquimbo Unido		bye
Group 2
Unión San Felipe	4-4 Trasandino
Santiago Wanderers	1-2 Ovalle
Unión Calera		bye
Group 3
Talagante Ferro		1-1 Aviación
Santiago Morning	3-1 Colchagua
Rangers			2-1 San Antonio Unido
Group 4
Malleco Unido		3-2 Iberia
Green Cross		4-2 Huachipato
Lota Schwager		0-3 Linares

Round 6
Group 1
Arica			2-0 Antofagasta	
Cobresal		2-2 Coquimbo Unido
Atacama			bye
Group 2
Trasandino		5-2 Unión Calera
Santiago Wanderers	1-1 Unión San Felipe
Ovalle			bye
Group 3
Aviación		2-2 San Antonio Unido
Rangers			2-2 Colchagua
Santiago Morning	1-1 Talagante Ferro
Group 4
Iberia			2-0 Linares
Lota Schwager		1-1 Huachipato
Green Cross		1-1 Malleco Unido

Round 7
Group 1
Atacama			1-0 Cobresal
Coquimbo Unido		3-1 Antofagasta
Arica			bye
Group 2
Santiago Wanderers	0-1 Trasandino
Ovalle			1-1 Unión Calera
Unión San Felipe	bye
Group 3
Santiago Morning	2-0 Aviación
Talagante Ferro		2-0 Rangers
Colchagua		0-0 San Antonio Unido
Group 4
Green Cross		2-0 Iberia
Malleco Unido		1-0 Lota Schwager
Huachipato		2-1 Linares

Round 8
Group 1
Arica			1-0 Coquimbo Unido
Antofagasta		0-1 Atacama	
Cobresal		bye
Group 2
Trasandino		4-1 Ovalle
Unión Calera		4-1 Unión San Felipe
Santiago Wanderers	bye
Group 3
Aviación		0-2 Colchagua
San Antonio Unido	2-0 Talagante Ferro
Rangers			2-2 Santiago Morning
Group 4
Iberia			1-1 Huachipato
Linares			1-0 Malleco Unido
Lota Schwager		2-2 Green Cross

Round 9
Group 1
Cobresal		2-2 Arica
Atacama			0-3 Coquimbo Unido
Antofagasta		bye
Group 2
Santiago Wanderers	3-2 Unión Calera
Unión San Felipe	4-3 Ovalle
Trasandino		bye
Group 3
Rangers			1-0 Aviación
Santiago Morning	4-0 San Antonio Unido
Talagante Ferro		4-1 Colchagua
Group 4
Lota Schwager		0-0 Iberia
Green Cross		2-0 Linares
Malleco Unido		3-0 Huachipato

Round 10
Group 1
Arica			1-1 Atacama
Antofagasta		2-1 Cobresal
Coquimbo Unido		bye
Group 2
Trasandino		2-0 Unión San Felipe
Ovalle			0-1 Santiago Wanderers
Unión Calera		bye
Group 3
Aviación		1-0 Talagante Ferro
Colchagua		1-1 Santiago Morning
San Antonio Unido	4-1 Rangers
Group 4
Iberia			1-1 Malleco Unido
Huachipato		1-0 Green Cross
Linares			3-2 Lota Schwager

Final Tables:

Group 1			 P  W +1  D -1  L  GF GA  PT
 1.ATACAMA		 8  4  0  3  1  1   6- 5  10  - Classified 
 2.ARICA		 8  3  1  3  1  2  10- 5   9  - Classified 
 3.Coquimbo Unido     	 8  3  0  2  0  3  14-11   8   
 4.Cobresal	     	 8  1  1  4  1  3  12-15   6   
 5.Antofagasta		 8  2  1  2  1  4  10-16   6    

Group 2			 P  W +1  D -1  L  GF GA  PT
 1.TRASANDINO		 8  5  2  1  0  2  20-11  13  - Classified 
 2.UNIÓN CALERA		 8  4  2  1  0  3  20-18  11  - Classified
 3.Unión San Felipe	 8  2  2  4  0  2  19-20  10   
 4.Santiago Wanderers	 8  2  0  2  0  4   7-10   6   
 5.Ovalle		 8  2  0  2  0  4  10-17   6   

Group 3			 P  W +1  D -1  L  GF GA  PT
 1.SANTIAGO MORNING	10  5  1  5  0  3  19- 9  16  - Classified 
 2.RANGERS		10  5  0  3  0  2  17-16  13  - Classified
 3.Talagante Ferro	10  4  2  2  0  4  18-13  12   
 4.San Antonio Unido	10  3  1  3  2  4  14-14   8   
 5.Aviación		10  1  0  5  2  4   6-11   5   
 6.Colchagua		10  1  0  4  2  5   8-19   4   

Group 4			 P  W +1  D -1  L  GF GA  PT
 1.LINARES		10  7  1  0  0  3  17-10  15  - Classified
 2.GREEN CROSS		10  3  1  4  1  3  13-10  10  - Classified
 3.Malleco Unido	10  4  0  3  1  3  11- 9  10   
 4.Huachipato		10  2  0  4  1  4  10-17   7   
 5.Iberia		10  1  0  6  2  3  10-12   6   
 6.Lota Schwager	10  2  0  5  3  3   9-12   6

Quarterfinals

Santiago Morning	2-2 Green Cross
Green Cross		1-3 Santiago Morning		 

Rangers			1-1 Linares
Linares			2-1 Rangers			(aet)	 

Trasandino		1-1 Atacama
Atacama			0-1 Trasandino

Arica			1-3 Unión Calera
Unión Calera		2-4 Arica			(aet)	 

Semifinals
Santiago Morning	3-1 Trasandino
Arica			3-0 Linares

Final
ARICA			1-0 Santiago Morning

Arica were the winners of Campeonato de Apertura “Copa Polla-Gol”

Note: Arica obtained 2 bonus points, and Santiago Morning, Trasandino 
      and Linares 1 bonus point for Campeonato Oficial 

Campeonato Oficial

Final Table:

 1.ARICA		42 20 12 10  66-54  2  54  (Arica) - Promoted      
 2.SANTIAGO MORNING	42 18 16  8  75-63  1  53  (Santiago) - Promoted      
 3.Aviación		42 20 12 10  68-42  0  52  (Santiago) - Withdrew     
 4.Atacama		42 20 11 11  66-45  0  51  (Copiapó) - Promoted         
 5.Rangers 		42 18 13 11  64-53  0  49  (Talca) - Promoted            
 6.Coquimbo Unido	42 19 11 12  52-44  0  49  (Coquimbo)            
 7.Antofagasta		42 18 12 12  68-62  0  48  (Antofagasta)  
 8.Linares		42 20  6 16  72-57  1  47  (Linares)  
 9.Trasandino		42 19  7 16  56-51  1  46  (Los Andes)  
10.Cobresal		42 15 13 14  80-60  0  43  (El Salvador)    
11.Huachipato		42 16 11 15  70-59  0  43  (Talcahuano) 
12.Unión Calera		42 14 14 14  67-60  0  42  (La Calera)      
13.Talagante Ferro 	42 14 14 14  43-39  0  42  (Talagante)   
14.Lota Schwager	42 15 12 15  49-52  0  42  (Coronel)    
15.Green Cross-Temuco	42 12 14 16  50-54  0  38  (Temuco)       
16.Santiago Wanderers	42 15  7 20  48-63  0  37  (Valparaíso)   
17.Iberia 		42 10 14 18  45-58  0  34  (Los Angeles)    
18.Ovalle	  	42 12 10 20  43-56  0  34  (Ovalle)    
19.Malleco Unido  	42 12  9 20  49-69  0  33  (Angol)   
20.San Antonio Unido	42  8 15 19  46-68  0  31  (San Antonio)   
21.Colchagua		42  7 17 18  40-78  0  31  (San Fernando)  
22.Unión San Felipe	42  8 14 20  45-75  0  30  (San Felipe)    

Note: Although Aviación (third place) were promoted, they decided to stop as a 
      professional club and withdrew from the league, so they were replaced 
      by Rangers (fifth place). 
      Due to this withdrawal, Unión San Felipe, who were supposed to be 
      relegated, remained in the division.

Round 1
Cobresal		4-0 Santiago Wanderers
Colchagua		1-1 Antofagasta
Lota Schwager		1-0 Green Cross
Talagante Ferro		1-1 Malleco Unido
Arica			2-0 Ovalle
Unión San Felipe	1-0 Trasandino
Coquimbo Unido		2-0 San Antonio Unido
Iberia			1-1 Santiago Morning
Aviación		3-0 Huachipato
Rangers			3-1 Linares
Unión Calera		1-0 Atacama

Round 2
Santiago Wanderers	0-3 Atacama
Linares			4-2 Unión Calera
Huachipato		1-1 Rangers
Santiago Morning	1-1 Aviación
San Antonio Unido	0-0 Iberia
Trasandino		2-0 Coquimbo Unido
Ovalle			0-1 Unión San Felipe
Malleco Unido		0-1 Arica	
Green Cross		2-1 Talagante Ferro
Antofagasta		3-0 Lota Schwager
Cobresal		4-0 Colchagua

Round 3
Colchagua		1-1 Santiago Wanderers
Lota Schwager		1-0 Cobresal	 
Talagante Ferro		0-0 Antofagasta
Arica			2-0 Green Cross
Unión San Felipe	0-0 Malleco Unido
Coquimbo Unido		1-2 Ovalle
Iberia			0-1 Trasandino
Aviación		3-1 San Antonio Unido
Rangers			1-2 Santiago Morning
Unión Calera		1-3 Huachipato
Atacama			2-0 Linares

Round 4
Santiago Wanderers	1-0 Linares
Huachipato		2-1 Atacama	 
Santiago Morning	1-1 Unión Calera
San Antonio Unido	1-2 Rangers
Trasandino		2-1 Aviación
Ovalle			1-0 Iberia
Malleco Unido		1-0 Coquimbo Unido
Green Cross		4-2 Unión San Felipe
Antofagasta		0-0 Arica	
Cobresal		1-1 Talagante Ferro
Colchagua		0-1 Lota Schwager

Round 5
Lota Schwager		0-0 Santiago Wanderers
Talagante Ferro		2-0 Colchagua	 
Arica			1-0 Cobresal
Unión San Felipe	2-2 Antofagasta
Coquimbo Unido		2-0 Green Cross
Iberia			1-3 Malleco Unido
Aviación		1-0 Ovalle
Rangers			1-0 Trasandino
Unión Calera		1-0 San Antonio Unido
Atacama			2-3 Santiago Morning
Linares			4-3 Huachipato		

Round 6	
Santiago Wanderers	0-1 Huachipato			 
Santiago Morning	2-1 Linares
San Antonio Unido	1-2 Atacama
Trasandino		0-0 Unión Calera
Ovalle			2-1 Rangers
Malleco Unido		0-2 Aviación
Green Cross		0-1 Iberia
Antofagasta		4-1 Coquimbo Unido
Cobresal		4-1 Unión San Felipe
Colchagua		1-1 Arica	
Lota Schwager		1-0 Talagante Ferro

Round 7
Talagante Ferro		0-1 Santiago Wanderers	 
Arica			0-0 Lota Schwager
Unión San Felipe	2-1 Colchagua
Coquimbo Unido		2-2 Cobresal
Iberia			0-0 Antofagasta
Aviación		2-0 Green Cross
Rangers			1-0 Malleco Unido
Unión Calera		0-1 Ovalle
Atacama			4-1 Trasandino
Linares			2-2 San Antonio Unido
Huachipato		2-2 Santiago Morning

Round 8
Santiago Wanderers	2-1 Santiago Morning	 
San Antonio Unido	0-4 Huachipato	
Trasandino		1-0 Linares
Ovalle			1-0 Atacama
Malleco Unido		3-2 Unión Calera
Green Cross		1-1 Rangers
Antofagasta		2-1 Aviación
Cobresal		4-1 Iberia
Colchagua		1-1 Coquimbo Unido
Lota Schwager		0-0 Unión San Felipe
Talagante Ferro		1-0 Arica	

Round 9
Arica			1-1 Santiago Wanderers	 
Unión San Felipe	2-1 Talagante Ferro
Coquimbo Unido		4-0 Lota Schwager
Iberia			4-0 Colchagua
Aviación		1-0 Cobresal
Rangers			1-1 Antofagasta
Unión Calera		2-2 Green Cross
Atacama			2-1 Malleco Unido
Linares			2-1 Ovalle
Huachipato		3-1 Trasandino
Santiago Morning	4-2 San Antonio Unido

Round 10
Santiago Wanderers	3-1 San Antonio Unido	 
Trasandino		2-1 Santiago Morning
Ovalle			1-1 Huachipato	
Malleco Unido		1-2 Linares
Green Cross		3-1 Atacama
Antofagasta		3-2 Unión Calera
Cobresal		1-1 Rangers
Colchagua		1-4 Aviación
Lota Schwager		3-0 Iberia
Talagante Ferro		0-0 Coquimbo Unido
Arica			2-2 Unión San Felipe

Round 11
Unión San Felipe	1-0 Santiago Wanderers	 
Coquimbo Unido		2-1 Arica	
Iberia			2-1 Talagante Ferro
Aviación		2-0 Lota Schwager
Rangers			1-1 Colchagua
Unión Calera		3-1 Cobresal
Atacama			3-1 Antofagasta
Linares			1-1 Green Cross
Huachipato		2-2 Malleco Unido
Santiago Morning	3-2 Ovalle
San Antonio Unido	0-1 Trasandino

Round 12
Santiago Wanderers	2-0 Trasandino
Ovalle			1-2 San Antonio Unido	 
Malleco Unido		0-1 Santiago Morning
Green Cross		2-0 Huachipato	
Antofagasta		2-1 Linares
Cobresal		4-0 Atacama
Colchagua		1-0 Unión Calera
Lota Schwager		1-2 Rangers
Talagante Ferro		2-1 Aviación
Arica			3-2 Iberia
Unión San Felipe	1-2 Coquimbo Unido

Round 13
Coquimbo Unido		1-0 Santiago Wanderers
Iberia			1-1 Unión San Felipe
Aviación		6-2 Arica	
Rangers			0-2 Talagante Ferro
Unión Calera		2-1 Lota Schwager	
Atacama			0-0 Colchagua
Linares			2-2 Cobresal
Huachipato		3-0 Antofagasta
Santiago Morning	2-0 Green Cross
San Antonio Unido	3-0 Malleco Unido
Trasandino		1-0 Ovalle

Round 14
Santiago Wanderers	2-1 Ovalle
Malleco Unido		1-2 Trasandino
Green Cross		4-1 San Antonio Unido
Antofagasta		2-1 Santiago Morning
Cobresal		4-0 Huachipato	
Colchagua		1-4 Linares
Lota Schwager		0-0 Atacama
Talagante Ferro		2-1 Unión Calera
Arica			1-0 Rangers
Unión San Felipe	1-1 Aviación
Coquimbo Unido		1-0 Iberia

Round 15
Iberia			1-0 Santiago Wanderers
Aviación		3-0 Coquimbo Unido
Rangers			1-0 Unión San Felipe
Unión Calera		2-2 Arica	
Atacama			1-1 Talagante Ferro
Linares			1-2 Lota Schwager	
Huachipato		0-1 Colchagua
Santiago Morning	2-0 Cobresal
San Antonio Unido	1-0 Antofagasta
Trasandino		3-0 Green Cross
Ovalle			1-2 Malleco Unido

Round 16
Santiago Wanderers	3-2 Malleco Unido
Green Cross		2-2 Ovalle
Antofagasta		0-1 Trasandino
Cobresal		2-2 San Antonio Unido
Colchagua		2-1 Santiago Morning
Lota Schwager		1-2 Huachipato	
Talagante Ferro		1-0 Linares
Arica			1-1 Atacama
Unión San Felipe	2-2 Unión Calera
Coquimbo Unido		3-0 Rangers
Iberia			0-0 Aviación

Round 17
Aviación		3-2 Santiago Wanderers
Rangers			2-2 Iberia	 
Unión Calera		1-1 Coquimbo Unido
Atacama			1-0 Unión San Felipe
Linares			2-0 Arica	
Huachipato		1-1 Talagante Ferro
Santiago Morning	4-2 Lota Schwager
San Antonio Unido	2-2 Colchagua	
Trasandino		2-0 Cobresal
Ovalle			1-3 Antofagasta
Malleco Unido		2-1 Green Cross

Round 18
Santiago Wanderers	1-1 Green Cross
Antofagasta		3-3 Malleco Unido
Cobresal		5-1 Ovalle
Colchagua		1-1 Trasandino
Lota Schwager		2-2 San Antonio Unido
Talagante Ferro		0-1 Santiago Morning
Arica			2-1 Huachipato	
Unión San Felipe	2-1 Linares
Coquimbo Unido		2-1 Atacama
Iberia			1-1 Unión Calera
Aviación		1-2 Rangers

Round 19
Rangers			1-0 Santiago Wanderers
Unión Calera		0-1 Aviación
Atacama			4-1 Iberia
Linares			2-0 Coquimbo Unido
Huachipato		4-0 Unión San Felipe
Santiago Morning	1-1 Arica	
San Antonio Unido	1-2 Talagante Ferro
Trasandino		1-0 Lota Schwager
Ovalle			0-1 Colchagua
Malleco Unido		3-2 Cobresal
Green Cross		1-1 Antofagasta

Round 20
Santiago Wanderers	1-0 Antofagasta
Cobresal		4-2 Green Cross	 
Colchagua		2-0 Malleco Unido
Lota Schwager		1-0 Ovalle
Talagante Ferro		0-0 Trasandino
Arica			3-2 San Antonio Unido
Unión San Felipe	3-3 Santiago Morning
Coquimbo Unido		2-3 Huachipato	
Iberia			1-1 Linares	
Aviación		0-0 Atacama
Rangers			2-0 Unión Calera

Round 21
Unión Calera		3-2 Santiago Wanderers
Atacama			2-1 Rangers	 
Linares			1-0 Aviación
Huachipato		2-1 Iberia
Santiago Morning	1-0 Coquimbo Unido
San Antonio Unido	1-0 Unión San Felipe
Trasandino		1-2 Arica	
Ovalle			1-3 Talagante Ferro
Malleco Unido		1-2 Lota Schwager
Green Cross		3-0 Colchagua
Antofagasta		3-0 Cobresal

Round 22
Santiago Wanderers	1-2 Cobresal
Antofagasta		2-1 Colchagua	 
Green Cross		2-0 Lota Schwager
Malleco Unido		0-1 Talagante Ferro
Ovalle			2-1 Arica	
Trasandino		2-0 Unión San Felipe
San Antonio Unido	0-1 Coquimbo Unido	
Santiago Morning	5-5 Iberia
Huachipato		4-1 Aviación
Linares			3-0 Rangers
Atacama			3-0 Unión Calera

Round 23	
Atacama			2-0 Santiago Wanderers	 
Unión Calera		1-1 Linares
Rangers			1-1 Huachipato	
Aviación		1-1 Santiago Morning
Iberia			0-0 San Antonio Unido
Coquimbo Unido		1-0 Trasandino
Unión San Felipe	0-0 Ovalle
Arica			1-0 Malleco Unido
Talagante Ferro		0-0 Green Cross
Lota Schwager		3-0 Antofagasta
Colchagua		2-1 Cobresal

Round 24
Santiago Wanderers	2-2 Colchagua	 
Cobresal		3-2 Lota Schwager
Antofagasta		2-1 Talagante Ferro
Green Cross		0-0 Arica	
Malleco Unido		2-1 Unión San Felipe	
Ovalle			1-0 Coquimbo Unido
Trasandino		1-2 Iberia
San Antonio Unido	1-2 Aviación
Santiago Morning	1-1 Rangers
Huachipato		5-1 Unión Calera
Linares			3-1 Atacama

Round 25
Linares			2-0 Santiago Wanderers	 
Atacama			1-0 Huachipato	
Unión Calera		4-0 Santiago Morning	
Rangers			2-3 San Antonio Unido
Aviación		2-1 Trasandino
Iberia			0-0 Ovalle
Coquimbo Unido		1-1 Malleco Unido
Unión San Felipe	1-1 Green Cross
Arica			3-1 Antofagasta
Talagante Ferro		1-0 Cobresal
Lota Schwager		2-1 Colchagua

Round 26
Santiago Wanderers	1-0 Lota Schwager	 
Colchagua		0-0 Talagante Ferro
Cobresal		2-3 Arica		
Antofagasta		2-1 Unión San Felipe
Green Cross		1-2 Coquimbo Unido
Malleco Unido		3-1 Iberia
Ovalle			0-2 Aviación
Trasandino		2-2 Rangers
San Antonio Unido	0-0 Unión Calera
Santiago Morning	1-1 Atacama
Huachipato		2-1 Linares

Round 27
Huachipato		0-2 Santiago Wanderers	 
Linares			2-2 Santiago Morning
Atacama			3-0 San Antonio Unido
Unión Calera		4-0 Trasandino
Rangers			3-2 Ovalle	
Aviación		6-0 Malleco Unido
Iberia			0-1 Green Cross
Coquimbo Unido		2-1 Antofagasta
Unión San Felipe	2-2 Cobresal
Arica			7-1 Colchagua
Talagante Ferro		0-1 Lota Schwager

Round 28
Santiago Wanderers	1-0 Talagante Ferro		 
Lota Schwager		3-1 Arica	
Colchagua		2-1 Unión San Felipe
Cobresal		2-1 Coquimbo Unido
Antofagasta		1-0 Iberia
Green Cross		0-0 Aviación
Malleco Unido		0-1 Rangers
Ovalle			0-0 Unión Calera
Trasandino		0-1 Atacama
San Antonio Unido	0-1 Linares
Santiago Morning	0-0 Huachipato	

Round 29
Santiago Morning	4-3 Santiago Wanderers
Huachipato		2-0 San Antonio Unido	 
Linares			3-1 Trasandino
Atacama			3-1 Ovalle
Unión Calera		1-2 Malleco Unido
Rangers			1-1 Green Cross
Aviación		2-2 Antofagasta
Iberia			1-0 Cobresal
Coquimbo Unido		1-1 Colchagua	
Unión San Felipe	1-1 Lota Schwager
Arica			1-1 Talagante Ferro

Round 30
Santiago Wanderers	0-0 Arica	
Talagante Ferro		3-0 Unión San Felipe
Lota Schwager		0-0 Coquimbo Unido
Colchagua		2-2 Iberia
Cobresal		1-1 Aviación
Antofagasta		3-2 Rangers
Green Cross		0-2 Unión Calera
Malleco Unido		2-2 Atacama
Ovalle			1-0 Linares
Trasandino		4-2 Huachipato	
San Antonio Unido	2-2 Santiago Morning

Round 31
San Antonio Unido	4-3 Santiago Wanderers
Santiago Morning	2-2 Trasandino
Huachipato		1-2 Ovalle	
Linares			2-0 Malleco Unido
Atacama			2-1 Green Cross
Unión Calera		4-2 Antofagasta
Rangers			1-1 Cobresal
Aviación		1-1 Colchagua	
Iberia			1-1 Lota Schwager
Coquimbo Unido		3-1 Talagante Ferro	
Unión San Felipe	1-3 Arica	

Round 32
Santiago Wanderers	1-0 Unión San Felipe
Arica			3-2 Coquimbo Unido
Talagante Ferro		1-0 Iberia
Lota Schwager		1-1 Aviación
Colchagua		1-2 Rangers
Cobresal		4-1 Unión Calera
Antofagasta		0-4 Atacama
Green Cross		3-1 Linares
Malleco Unido		1-1 Huachipato	
Ovalle			0-1 Santiago Morning
Trasandino		2-1 San Antonio Unido

Round 33
Trasandino		5-1 Santiago Wanderers
San Antonio Unido	0-0 Ovalle
Santiago Morning	2-1 Malleco Unido
Huachipato		3-1 Green Cross
Linares			3-1 Antofagasta	
Atacama			0-0 Cobresal
Unión Calera		2-0 Colchagua
Rangers			3-0 Lota Schwager
Aviación		1-0 Talagante Ferro
Iberia			2-1 Arica	
Coquimbo Unido		1-0 Unión San Felipe

Round 34
Santiago Wanderers	2-2 Coquimbo Unido
Unión San Felipe	3-3 Iberia		 
Arica			2-1 Aviación
Talagante Ferro		0-2 Rangers
Lota Schwager		1-2 Unión Calera
Colchagua		1-1 Atacama
Cobresal		3-1 Linares
Antofagasta		2-1 Huachipato		
Green Cross		2-1 Santiago Morning
Malleco Unido		0-0 San Antonio Unido
Ovalle			3-1 Trasandino

Round 35
Ovalle			4-2 Santiago Wanderers
Trasandino		3-1 Malleco Unido
San Antonio Unido	0-0 Green Cross
Santiago Morning	3-2 Antofagasta
Huachipato		1-1 Cobresal
Linares			5-0 Colchagua
Atacama			1-1 Lota Schwager	
Unión Calera		0-0 Talagante Ferro
Rangers			3-1 Arica	
Aviación		2-1 Unión San Felipe
Iberia			0-1 Coquimbo Unido

Round 36
Santiago Wanderers	2-1 Iberia
Coquimbo Unido		2-0 Aviación	 
Unión San Felipe	1-4 Rangers	
Arica			2-1 Unión Calera
Talagante Ferro		0-1 Atacama
Lota Schwager		4-5 Linares	
Colchagua		1-1 Huachipato	
Cobresal		1-2 Santiago Morning
Antofagasta		1-1 San Antonio Unido
Green Cross		3-0 Trasandino
Malleco Unido		0-0 Ovalle

Round 37
Malleco Unido		2-1 Santiago Wanderers
Ovalle			1-0 Green Cross
Trasandino		0-0 Antofagasta
San Antonio Unido	2-1 Cobresal
Santiago Morning	3-1 Colchagua
Huachipato		2-3 Lota Schwager
Linares			1-0 Talagante Ferro	
Atacama			2-1 Arica	
Unión Calera		7-2 Unión San Felipe	
Rangers			3-0 Coquimbo Unido
Aviación		2-1 Iberia

Round 38
Santiago Wanderers	1-0 Aviación
Iberia			2-1 Rangers	 
Coquimbo Unido		1-1 Unión Calera
Unión San Felipe	1-0 Atacama	
Arica			2-0 Linares
Talagante Ferro		4-2 Huachipato	
Lota Schwager		2-0 Santiago Morning
Colchagua		2-3 San Antonio Unido
Cobresal		2-1 Trasandino	
Antofagasta		1-0 Ovalle
Green Cross		1-4 Malleco Unido

Round 39
Green Cross		3-0 Santiago Wanderers
Malleco Unido		1-3 Antofagasta
Ovalle			1-1 Cobresal
Trasandino		3-0 Colchagua
San Antonio Unido	1-1 Lota Schwager
Santiago Morning	1-1 Talagante Ferro
Huachipato		4-0 Arica		
Linares			2-1 Unión San Felipe
Atacama			1-1 Coquimbo Unido
Unión Calera		2-1 Iberia
Rangers			1-1 Aviación

Round 40
Santiago Wanderers	2-0 Rangers
Aviación		1-1 Unión Calera	 
Iberia			1-0 Atacama	
Coquimbo Unido		1-0 Linares
Unión San Felipe	1-1 Huachipato	
Arica			4-1 Santiago Morning	
Talagante Ferro		2-2 San Antonio Unido
Lota Schwager		1-2 Trasandino
Colchagua		2-2 Ovalle
Cobresal		4-2 Malleco Unido
Antofagasta		4-1 Green Cross

Round 41
Antofagasta		2-0 Santiago Wanderers
Green Cross		0-0 Cobresal
Malleco Unido		1-0 Colchagua
Ovalle			1-1 Lota Schwager
Trasandino		2-2 Talagante Ferro
San Antonio Unido	0-0 Arica	
Santiago Morning	4-0 Unión San Felipe	
Huachipato		0-1 Coquimbo Unido
Linares			2-1 Iberia	
Atacama			3-1 Aviación
Unión Calera		1-1 Rangers

Round 42
Santiago Wanderers	1-2 Unión Calera
Rangers			6-4 Atacama	 
Aviación		3-1 Linares
Iberia			1-0 Huachipato		
Coquimbo Unido		1-1 Santiago Morning
Unión San Felipe	3-1 San Antonio Unido
Arica			2-1 Trasandino
Talagante Ferro		3-2 Ovalle
Lota Schwager		2-0 Malleco Unido	
Colchagua		0-0 Green Cross
Cobresal		5-5 Antofagasta

Final Table:

 1.ARICA		42 20 12 10  66-54  2  54  (Arica) - Promoted      
 2.SANTIAGO MORNING	42 18 16  8  75-63  1  53  (Santiago) - Promoted      
 3.Aviación		42 20 12 10  68-42  0  52  (Santiago) - Withdrew     
 4.Atacama		42 20 11 11  66-45  0  51  (Copiapó) - Promoted         
 5.Rangers 		42 18 13 11  64-53  0  49  (Talca) - Promoted            
 6.Coquimbo Unido	42 19 11 12  52-44  0  49  (Coquimbo)            
 7.Antofagasta		42 18 12 12  68-62  0  48  (Antofagasta)  
 8.Linares		42 20  6 16  72-57  1  47  (Linares)  
 9.Trasandino		42 19  7 16  56-51  1  46  (Los Andes)  
10.Cobresal		42 15 13 14  80-60  0  43  (El Salvador)    
11.Huachipato		42 16 11 15  70-59  0  43  (Talcahuano) 
12.Unión Calera		42 14 14 14  67-60  0  42  (La Calera)      
13.Talagante Ferro 	42 14 14 14  43-39  0  42  (Talagante)   
14.Lota Schwager	42 15 12 15  49-52  0  42  (Coronel)    
15.Green Cross-Temuco	42 12 14 16  50-54  0  38  (Temuco)       
16.Santiago Wanderers	42 15  7 20  48-63  0  37  (Valparaíso)   
17.Iberia 		42 10 14 18  45-58  0  34  (Los Angeles)    
18.Ovalle	  	42 12 10 20  43-56  0  34  (Ovalle)    
19.Malleco Unido  	42 12  9 20  49-69  0  33  (Angol)   
20.San Antonio Unido	42  8 15 19  46-68  0  31  (San Antonio)   
21.Colchagua		42  7 17 18  40-78  0  31  (San Fernando)  
22.Unión San Felipe	42  8 14 20  45-75  0  30  (San Felipe)    

Note: Although Aviación (third place) were promoted, they decided to stop as a 
      professional club and withdrew from the league, so they were replaced 
      by Rangers (fifth place). 
      Due to this withdrawal, Unión San Felipe, who were supposed to be 
      relegated, remained in the division.


Promotion/Relegation Liguilla

Participants:

Palestino		Eleventh place in First Division  
Iquique			Twelfth place in First Division  
Coquimbo Unido 		Sixth place in Second Division  
Antofagasta    		Seventh place in Second Division  

Round 1		
Palestino		1-1 Iquique
Antofagasta		1-1 Coquimbo Unido

Round 2
Palestino		1-0 Coquimbo Unido
Antofagasta		2-2 Iquique

Round 3
Iquique			4-3 Coquimbo Unido
Palestino		2-1 Antofagasta

Final Table:

 1.Palestino		 3  2  1  0   4- 2   5  Remain in First Division      
 2.Iquique		 3  1  2  0   7- 6   4  Remain in First Division      
 3.Antofagasta		 3  0  2  1   4- 5   2  Remain in Second Division
 4.Coquimbo Unido	 3  0  1  2   4- 6   1  Remain in Second Division 

Promoted : Arica (Arica), Santiago Morning (Santiago), Atacama (Copiapó)
           and Rangers (Talca)
Relegated: None



Author: Eduardo Espina
(ecem54 at chile.com)
Last updated: 15 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,330,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6467
Total Execution Time  0.6486
  CADENA URL  
/primera_b_apertura_fase_1_chile1981
  GET DATOS  
$_GET['/primera_b_apertura_fase_1_chile1981']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0144  SELECT type FROM routes WHERE alias = 'primera_b_apertura_fase_1_chile1981'
0.0293  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 = 1981 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0149  SELECT text_es as historical_text FROM leagues_text WHERE id=2414
0.0145  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 = 30660 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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.0148  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.0145  SELECT type,rule FROM rules WHERE categoryId = 290 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` 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:11:27' 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:11:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 10:11:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 10:11:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 1981 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1981 e WHERE e.league_id IN (30660) 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.0145  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 (30660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1981 e WHERE e.league_id IN (30660) 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 (30660) 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 events1981 e WHERE e.league_id IN (30660) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0151  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 (30660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0155  SELECT e.action, count(e.action) as total, e.player_id FROM events1981 e WHERE e.league_id IN (30660) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0151  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 (30660) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0149  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 = 30660 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0145  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 = 30660 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0149  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=30660 AND rel.round=42
0.0147  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 = 30660 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  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 = 30660 AND esl.points > 0
0.0146  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` = 30660 ORDER BY creation_date DESC LIMIT 0, 10
0.0150  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` = 30660
0.0146  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 `calendars1981` 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` = 30660 AND c.`round` = 42 ORDER BY shedule ASC LIMIT 200
0.0145  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 `events1981` e INNER JOIN calendars1981 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 = 42 AND e.real_date IS NOT NULL AND e.league_id = 30660 ORDER BY total DESC LIMIT 40
0.0146  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 `events1981` e INNER JOIN calendars1981 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 = 30660 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0146  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 `tables1981` 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 = 30660 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1981` 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 = 30660 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 30660 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0146  SELECT data1, data2 FROM services_tags WHERE categoryId=290
0.0146  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 290 AND l.year = 1981 ORDER BY l.group_code ASC
0.0146  SELECT group_code, extraName from `leagues` WHERE categoryId=290 AND year=1981