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

Campeonato de Apertura.

Note: bonus points are given for wins by 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.IQUIQUE		 8  4  2  4  1  0  17- 8  14  - Classified    
 2.COBRELOA		 8  4  2  2  0  2  17- 8  12  - Classified    
 3.ARICA		 8  3  2  4  0  1  18-12  12  - Classified    
 4.Atacama		 8  2  1  2  1  4  13-19   6          
 5.La Serena		 8  1  0  0  0  7   8-26   2   

Group 2			 P  W +1  D -1  L  GF GA  PT
 1.UNIVERSIDAD DE CHILE	10  5  0  4  2  1  15- 7  12  - Classified    
 2.COLO COLO		10  5  2  1  1  4  15- 9  12  - Classified       
 3.UNIVERSIDAD CATÓLICA	10  5  1  2  1  3  17-17  12  - Classified    
 4.Unión Española	10  3  0  4  1  3  12-12   9  
 5.Audax Italiano	10  3  1  1  0  6  15-23   8  
 6.Palestino		10  2  0  2  1  6  11-17   5

Group 3			 P  W +1  D -1  L  GF GA  PT
 1.MAGALLANES		 8  6  2  0  0  2  19- 8  14  - Classified      
 2.O'HIGGINS		 8  3  2  4  0  1  16-12  12  - Classified    
 3.Naval   		 8  3  1  3  0  2  15-15  10       
 4.Rangers		 8  2  2  3  0  3  18-20   9     
 5.Santiago Morning	 8  0  0  2  0  6   9-22   2

Round 1
Group 1
Cobreloa		3-0 Atacama
Arica 			2-0 La Serena
Iquique			bye
Group 2
Unión Española		1-2 Universidad Católica 
Colo Colo		4-1 Audax Italiano
Universidad de Chile	2-1 Palestino
Group 3
Magallanes		1-0 Santiago Morning
Rangers			4-1 Naval 
O'Higgins		bye

Round 2
Group 1
La Serena		2-1 Cobreloa
Atacama			0-0 Iquique
Arica	      		bye
Group 2
Universidad Católica	1-2 Palestino
Audax Italiano		1-2 Universidad de Chile
Unión Española		1-0 Colo Colo
Group 3
Naval			2-1 Magallanes
Santiago Morning	2-4 O'Higgins
Rangers			bye

Round 3
Group 1
Iquique			2-1 La Serena
Cobreloa		4-1 Arica	
Atacama			bye
Group 2
Colo Colo		0-1 Universidad Católica
Universidad de Chile	2-0 Unión Española	
Palestino		1-2 Audax Italiano
Group 3
O'Higgins		1-1 Naval	
Magallanes		7-2 Rangers
Santiago Morning	bye

Round 4
Group 1
Arica			1-1 Iquique
La Serena		2-3 Atacama
Cobreloa		bye
Group 2
Universidad Católica	4-2 Audax Italiano
Unión Española		0-0 Palestino
Colo Colo		0-3 Universidad de Chile
Group 3
Rangers			1-1 O'Higgins
Naval			2-1 Santiago Morning
Magallanes		bye

Round 5
Group 1
Atacama			2-2 Arica	
Iquique			2-1 Cobreloa
La Serena		bye
Group 2
Audax Italiano		0-2 Unión Española	
Universidad de Chile	0-0 Universidad Católica
Palestino		0-2 Colo Colo
Group 3
Santiago Morning	0-6 Rangers
O'Higgins		0-1 Magallanes
Naval			bye

Round 6
Group 1
Atacama			1-2 Cobreloa
La Serena		2-6 Arica	
Iquique			bye
Group 2
Universidad Católica	2-2 Unión Española
Audax Italiano         	1-0 Colo Colo
Palestino		1-1 Universidad de Chile
Group 3
Santiago Morning	1-2 Magallanes
Naval			5-1 Rangers
O'Higgins		bye

Round 7
Group 1
Cobreloa		4-0 La Serena
Iquique			6-2 Atacama
Arica			bye
Group 2
Palestino		0-2 Universidad Católica
Universidad de Chile	3-1 Audax Italiano
Colo Colo		1-0 Unión Española
Group 3
Magallanes		4-1 Naval	
O'Higgins		4-2 Santiago Morning
Rangers			bye

Round 8
Group 1
La Serena		1-4 Iquique
Arica			1-1 Cobreloa
Atacama			bye
Group 2
Universidad Católica	0-5 Colo Colo
Unión Española		1-1 Universidad de Chile
Audax Italiano		1-2 Palestino
Group 3
Naval			2-2 O'Higgins
Rangers			0-2 Magallanes
Santiago Morning	bye

Round 9
Group 1
Iquique			1-1 Arica	
Atacama			4-0 La Serena
Cobreloa		bye
Group 2
Audax Italiano		4-3 Universidad Católica
Palestino		2-3 Unión Española
Universidad de Chile	0-0 Colo Colo
Group 3
O'Higgins		2-2 Rangers
Santiago Morning	1-1 Naval	
Magallanes		bye

Round 10
Group 1
Arica			4-1 Atacama
Cobreloa		1-1 Iquique
La Serena		bye
Group 2
Unión Española		2-2 Audax Italiano
Universidad Católica	2-1 Universidad de Chile
Colo Colo		3-2 Palestino
Group 3
Rangers			2-2 Santiago Morning
Magallanes		1-2 O'Higgins
Naval			bye

Final Tables:

Group 1			 P  W +1  D -1  L  GF GA  PT
 1.IQUIQUE		 8  4  2  4  1  0  17- 8  14  - Classified    
 2.COBRELOA		 8  4  2  2  0  2  17- 8  12  - Classified    
 3.ARICA		 8  3  2  4  0  1  18-12  12  - Classified    
 4.Atacama		 8  2  1  2  1  4  13-19   6          
 5.La Serena		 8  1  0  0  0  7   8-26   2   

Group 2			 P  W +1  D -1  L  GF GA  PT
 1.UNIVERSIDAD DE CHILE	10  5  0  4  2  1  15- 7  12  - Classified    
 2.COLO COLO		10  5  2  1  1  4  15- 9  12  - Classified       
 3.UNIVERSIDAD CATÓLICA	10  5  1  2  1  3  17-17  12  - Classified    
 4.Unión Española	10  3  0  4  1  3  12-12   9  
 5.Audax Italiano	10  3  1  1  0  6  15-23   8  
 6.Palestino		10  2  0  2  1  6  11-17   5

Group 3			 P  W +1  D -1  L  GF GA  PT
 1.MAGALLANES		 8  6  2  0  0  2  19- 8  14  - Classified      
 2.O'HIGGINS		 8  3  2  4  0  1  16-12  12  - Classified    
 3.Naval   		 8  3  1  3  0  2  15-15  10       
 4.Rangers		 8  2  2  3  0  3  18-20   9     
 5.Santiago Morning	 8  0  0  2  0  6   9-22   2

Second Phase

Cobreloa		5-1 Magallanes
Magallanes		1-2 Cobreloa

Universidad Católica	2-1 Iquique
Iquique			0-1 Universidad Católica		 

Colo Colo		4-1 Arica
Arica			1-2 Colo Colo

Universidad de Chile	1-1 O'Higgins
O'Higgins		0-1 Universidad de Chile

Third Phase

Round 1
Universidad Católica	2-0 Universidad de Chile		 
Cobreloa		0-1 Colo Colo

Round 2
Universidad Católica	1-1 Cobreloa		 
Colo Colo		3-1 Universidad de Chile

Round 3
Colo Colo		2-0 Universidad Católica		 
Cobreloa		0-1 Universidad de Chile

Final Table:
		 	 P  W +1  D -1  L  GF GA  PT

 1.COLO COLO	 	 3  3  0  0  0  0   6- 1   6  Winners         
 2.Universidad Católica	 3  1  0  1  0  1   3- 3   3       
 3.Universidad de Chile	 3  1  0  0  0  2   2- 5   2       
 4.Cobreloa		 3  0  0  1  0  2   1- 3   1  

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

Note: Colo Colo obtained 2 bonus points, and Universidad Católica,
      Universidad de Chile and Cobreloa 1 bonus point for Campeonato Oficial 


Campeonato Oficial

Final Table:

 1.COBRELOA		30 19  6  5  69-23  1  45  (Calama) - Champions
 2.Colo Colo		30 14 11  5  41-21  2  41    
 3.Universidad de Chile	30 15  9  6  58-38  1  40               
 4.Magallanes		30 15  9  6  63-38  0  39   
 5.Naval		30 14 10  6  52-33  0  38  (Talcahuano)    
 6.Universidad Católica	30 13 11  6  50-33  1  38      
 7.O'Higgins     	30 12 10  8  48-39  0  34  (Rancagua)  
 8.Iquique		30 12  6 12  39-44  0  30  (Iquique)    
 9.Atacama		30 10  8 12  36-43  0  28  (Copiapó)    
10.Arica    		30 11  6 13  37-47  0  28  (Arica)   
11.Audax Italiano	30 10  7 13  41-44  0  27   
12.Unión Española	30 10  5 15  39-56  0  25  
13.Palestino		30  6 12 12  30-44  0  24             
14.La Serena		30  5  9 16  26-53  0  19  (La Serena) - Relegated   
15.Santiago Morning	30  4  7 19  34-58  0  15  - Relegated
16.Rangers		30  5  5 20  25-74  0  15  (Talca) - Relegated

Round 1
Cobreloa		7-0 Iquique
Universidad Católica	3-3 Santiago Morning
Naval			2-1 Audax Italiano
Magallanes		2-0 La Serena
Atacama			2-0 Rangers
Colo Colo		2-3 Palestino
Universidad de Chile	7-3 Unión Española
Arica 			1-3 O'Higgins

Round 2
Iquique			0-1 O'Higgins
Unión Española		0-2 Arica				
Rangers			1-5 Universidad de Chile		
Palestino		1-2 Atacama
La Serena		0-2 Colo Colo
Audax Italiano		1-1 Magallanes
Santiago Morning	0-2 Naval	
Cobreloa		2-0 Universidad Católica

Round 3
Universidad Católica	3-1 Iquique		 
Naval			0-0 Cobreloa	
Magallanes		0-0 Santiago Morning
Colo Colo		2-0 Audax Italiano
Atacama			0-0 La Serena				
Universidad de Chile	1-1 Palestino
Arica			2-0 Rangers
O'Higgins		3-1 Unión Española

Round 4
Iquique			1-0 Unión Española	
Rangers			2-3 O'Higgins
Palestino		0-1 Arica		
La Serena		1-3 Universidad de Chile			
Audax Italiano		2-3 Atacama
Santiago Morning	0-2 Colo Colo
Cobreloa		4-1 Magallanes
Universidad Católica	2-2 Naval	

Round 5
Naval			2-1 Iquique	
Magallanes		0-1 Universidad Católica
Colo Colo		1-0 Cobreloa
Atacama			2-0 Santiago Morning
Universidad de Chile	2-1 Audax Italiano	
Arica			2-1 La Serena
O'Higgins		0-1 Palestino
Unión Española		7-2 Rangers

Round 6
Iquique			1-0 Rangers
Palestino		0-0 Unión Española			
La Serena		1-1 O'Higgins
Audax Italiano		2-0 Arica		
Santiago Morning	0-2 Universidad de Chile
Cobreloa		3-1 Atacama
Universidad Católica	1-1 Colo Colo
Naval			2-1 Magallanes	

Round 7
Magallanes		0-0 Iquique
Colo Colo		0-0 Naval			 
Atacama			0-0 Universidad Católica
Universidad de Chile	1-0 Cobreloa			
Arica			0-0 Santiago Morning
O'Higgins		1-2 Audax Italiano	
Unión Española		2-1 La Serena
Rangers			0-0 Palestino

Round 8
Iquique			2-1 Palestino
La Serena		1-0 Rangers
Audax Italiano		0-2 Unión Española
Santiago Morning	1-1 O'Higgins	
Cobreloa		3-0 Arica			
Universidad Católica	2-3 Universidad de Chile
Naval			2-0 Atacama
Magallanes		1-1 Colo Colo

Round 9
Colo Colo		3-1 Iquique		 
Atacama			1-3 Magallanes			
Universidad de Chile	1-1 Naval	
Arica			1-1 Universidad Católica
O'Higgins		1-1 Cobreloa
Unión Española		0-4 Santiago Morning
Rangers			1-0 Audax Italiano
Palestino		1-0 La Serena

Round 10
Iquique			3-1 La Serena
Audax Italiano		1-1 Palestino		 
Santiago Morning	9-1 Rangers
Cobreloa		1-0 Unión Española			
Universidad Católica	2-1 O'Higgins	
Naval			3-1 Arica		
Magallanes		1-1 Universidad de Chile
Colo Colo		2-1 Atacama

Round 11
Atacama			2-0 Iquique
Universidad de Chile	0-1 Colo Colo
Arica			4-2 Magallanes
O'Higgins		0-0 Naval	
Unión Española		1-1 Universidad Católica
Rangers			2-1 Cobreloa
Palestino		1-2 Santiago Morning
La Serena		0-0 Audax Italiano

Round 12
Iquique			0-0 Audax Italiano				
Santiago Morning	0-0 La Serena		 
Cobreloa		3-0 Palestino	
Universidad Católica	3-0 Rangers
Naval			2-1 Unión Española
Magallanes		2-2 O'Higgins	
Colo Colo		0-0 Arica		
Atacama			2-2 Universidad de Chile

Round 13
Universidad de Chile	2-0 Iquique
Arica			1-1 Atacama	
O'Higgins		1-0 Colo Colo		 
Unión Española		1-6 Magallanes	
Rangers			2-0 Naval	
Palestino		1-1 Universidad Católica
La Serena		1-1 Cobreloa
Audax Italiano		1-0 Santiago Morning

Round 14
Iquique			1-0 Santiago Morning
Cobreloa		2-0 Audax Italiano
Universidad Católica	0-0 La Serena	
Naval			4-1 Palestino
Magallanes		2-0 Rangers			
Colo Colo		3-0 Unión Española
Atacama			0-1 O'Higgins
Universidad de Chile	3-0 Arica		

Round 15
Arica			2-1 Iquique
O'Higgins		2-2 Universidad de Chile
Unión Española		2-0 Atacama
Rangers			0-2 Colo Colo	
Palestino		0-0 Magallanes
La Serena		2-2 Naval	
Audax Italiano		0-2 Universidad Católica
Santiago Morning	0-2 Cobreloa

Round 16
Iquique			2-2 Cobreloa	
Santiago Morning	2-3 Universidad Católica		 
Audax Italiano		4-1 Naval	
La Serena		0-5 Magallanes	
Palestino		2-2 Colo Colo
Rangers			0-0 Atacama
Unión Española		2-0 Universidad de Chile
O'Higgins		3-1 Arica	

Round 17
O'Higgins		4-0 Iquique
Arica			3-1 Unión Española	
Universidad de Chile	2-1 Rangers		 
Atacama			2-2 Palestino
Colo Colo		1-1 La Serena
Magallanes		3-1 Audax Italiano
Naval			5-1 Santiago Morning
Universidad Católica	2-1 Cobreloa

Round 18
Iquique			1-1 Universidad Católica
Cobreloa		1-0 Naval	
Santiago Morning	1-2 Magallanes	 
Audax Italiano		0-0 Colo Colo
La Serena		2-1 Atacama
Palestino		0-3 Universidad de Chile
Rangers			0-1 Arica	
Unión Española		0-0 O'Higgins

Round 19
Unión Española		1-1 Iquique
O'Higgins		0-1 Rangers			
Arica			2-3 Palestino		
Universidad de Chile	2-0 La Serena
Atacama			0-0 Audax Italiano
Colo Colo		4-1 Santiago Morning
Magallanes		1-4 Cobreloa
Naval			3-1 Universidad Católica	

Round 20
Iquique			2-0 Naval			 
Universidad Católica	0-1 Magallanes	
Cobreloa		0-0 Colo Colo
Santiago Morning	0-1 Atacama
Audax Italiano		2-1 Universidad de Chile			
La Serena		0-0 Arica	
Palestino		1-2 O'Higgins
Rangers			0-2 Unión Española	

Round 21
Rangers			2-1 Iquique	
Unión Española		1-0 Palestino
O'Higgins		2-1 La Serena
Arica			4-3 Audax Italiano			
Universidad de Chile	2-1 Santiago Morning
Atacama			1-3 Cobreloa
Colo Colo		0-1 Universidad Católica
Magallanes		1-0 Naval		

Round 22
Iquique			1-2 Magallanes
Naval			0-0 Colo Colo
Universidad Católica	3-1 Atacama
Cobreloa		1-0 Universidad de Chile
Santiago Morning	1-2 Arica		
Audax Italiano		1-0 O'Higgins
La Serena		3-4 Unión Española	
Palestino		1-1 Rangers

Round 23
Palestino		1-1 Iquique
Rangers			1-2 La Serena			
Unión Española		1-0 Audax Italiano
O'Higgins		3-3 Santiago Morning
Arica			1-3 Cobreloa
Universidad de Chile	1-1 Universidad Católica
Atacama			1-1 Naval	
Colo Colo		1-0 Magallanes

Round 24
Iquique			1-2 Colo Colo
Magallanes		5-3 Atacama		 
Naval			0-0 Universidad de Chile
Universidad Católica	2-0 Arica				
Cobreloa		3-1 O'Higgins
Santiago Morning	1-0 Unión Española		
Audax Italiano		3-2 Rangers
La Serena		2-1 Palestino	

Round 25
La Serena		1-2 Iquique
Palestino		1-1 Audax Italiano
Rangers			1-1 Santiago Morning
Unión Española		1-4 Cobreloa
O'Higgins		1-0 Universidad Católica	
Arica			1-1 Naval	
Universidad de Chile	4-4 Magallanes
Atacama			1-0 Colo Colo

Round 26
Iquique			2-0 Atacama		 
Colo Colo		2-2 Universidad de Chile			
Magallanes		2-0 Arica	
Naval			4-3 O'Higgins
Universidad Católica	2-2 Unión Española	
Cobreloa		6-1 Rangers
Santiago Morning	0-2 Palestino	
Audax Italiano		4-1 La Serena

Round 27
Audax Italiano		2-4 Iquique
La Serena		4-1 Santiago Morning	 
Palestino		0-0 Cobreloa
Rangers			1-6 Universidad Católica			
Unión Española		2-1 Naval		
O'Higgins		2-2 Magallanes
Arica			2-3 Colo Colo
Universidad de Chile	2-1 Atacama

Round 28
Iquique			3-1 Universidad de Chile
Atacama			2-1 Arica	
Colo Colo		3-4 O'Higgins
Magallanes		3-1 Unión Española	
Naval			4-1 Rangers
Universidad Católica	1-2 Palestino
Cobreloa		5-0 La Serena
Santiago Morning	0-4 Audax Italiano	

Round 29
Santiago Morning	1-4 Iquique				
Audax Italiano		4-3 Cobreloa		 
La Serena		0-1 Universidad Católica	
Palestino		2-4 Naval	
Rangers			0-5 Magallanes
Unión Española		0-3 Colo Colo
O'Higgins		0-1 Atacama
Arica			2-1 Universidad de Chile

Round 30
Iquique			2-0 Arica	
Universidad de Chile	2-2 O'Higgins	
Atacama			2-1 Unión Española			 
Colo Colo		0-0 Rangers	
Magallanes		5-2 Palestino
Naval			4-0 La Serena	
Universidad Católica	4-1 Audax Italiano
Cobreloa		3-1 Santiago Morning

Final Table:

 1.COBRELOA		30 19  6  5  69-23  1  45  (Calama) - Champions
 2.Colo Colo		30 14 11  5  41-21  2  41      
 3.Universidad de Chile	30 15  9  6  58-38  1  40               
 4.Magallanes		30 15  9  6  63-38  0  39     
 5.Naval		30 14 10  6  52-33  0  38  (Talcahuano)    
 6.Universidad Católica	30 13 11  6  50-33  1  38      
 7.O'Higgins     	30 12 10  8  48-39  0  34  (Rancagua)  
 8.Iquique		30 12  6 12  39-44  0  30  (Iquique)    
 9.Atacama		30 10  8 12  36-43  0  28  (Copiapó)    
10.Arica    		30 11  6 13  37-47  0  28  (Arica)   
11.Audax Italiano	30 10  7 13  41-44  0  27   
12.Unión Española	30 10  5 15  39-56  0  25  
13.Palestino		30  6 12 12  30-44  0  24             
14.La Serena		30  5  9 16  26-53  0  19  (La Serena) - Relegated   
15.Santiago Morning	30  4  7 19  34-58  0  15  - Relegated
16.Rangers		30  5  5 20  25-74  0  15  (Talca) - Relegated

Relegated: La Serena (La Serena) and Santiago Morning (Santiago)         
Promoted : Fernández Vial (Concepción), Everton (Viña del Mar), Trasandino (Los Andes)
           Unión San Felipe (San Felipe), Antofagasta (Antofagasta), Santiago Wanderers 
           (Valparaíso), Green Cross (Temuco) and Huachipato (Talcahuano).

Note: Valparaíso with Santiago Wanderers was considered a “good venue” because
      of good attendance and so were promoted. On the other hand and by the 
      same reason, Rangers (Talca) remained in the first division. 
      Green Cross (Temuco) and Huachipato (Talcahuano) were promoted after 
      the Second Division Campeonato de Apertura 1983.
      The number of teams for Campeonato Oficial 1983 was increased to 22.

Liguilla Pre-Libertadores

Participants:

Colo Colo		runners-up in Campeonato Oficial  
Universidad de Chile	third place in Campeonato Oficial  
Magallanes		fourth place in Campeonato Oficial  
Naval        		fifth place in Campeonato Oficial  

Round 1
Universidad de Chile	3-1 Naval
Magallanes		0-0 Colo Colo

Round 2
Magallanes		1-0 Naval        
Colo Colo		3-2 Universidad de Chile

Round 3
Colo Colo		2-0 Naval
Universidad de Chile	4-1 Magallanes

Final Table:

 1.Colo Colo		 3  2  1  0   5- 2   5  - Winners   
 2.Universidad de Chile	 3  2  0  1   9- 5   4      
 3.Magallanes		 3  1  1  1   2- 4   3      
 4.Naval        	 3  0  0  3   1- 6   0      

Colo Colo were winners of Liguilla Pre-Libertadores


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

(C) Copyright Eduardo Espina and RSSSF 2006

INFORMACIÓN

El Campeonato Nacional de Primera División del Fútbol Profesional (por motivos de patrocinio, Campeonato Nacional Petrobras de Primera División) es la máxima categoría del fútbol profesional en Chile. Participan de la competencia 18 equipos y funciona con un sistema de ascensos y descensos con la categoría inmediatamente inferior, la Primera B. Es organizado por la Asociación Nacional de Fútbol Profesional, perteneciente a la Federación de Fútbol de Chile.



  USO DE MEMORIA  
4,375,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.0906
Total Execution Time  0.0933
  CADENA URL  
/apertura_chile1982/grupo1
  GET DATOS  
$_GET['/apertura_chile1982/grupo1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_chile1982'
0.0038  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_chile' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1982 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=187
0.0020  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 = 28497 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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='1982' WHERE c.parentId=41 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:20:34' 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 13:20:34' 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=4 AND last_update > '2024-04-27 13:20:34' 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 13:20:34' 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 = 'apertura_chile' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1982 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 events1982 e WHERE e.league_id IN (28497) 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.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 (28497) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1982 e WHERE e.league_id IN (28497) 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 (28497) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1982 e WHERE e.league_id IN (28497) 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 (28497) 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 events1982 e WHERE e.league_id IN (28497) AND (e.action IN (22) ) 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 (28497) 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 = 28497 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 28497 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0023  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=28497 AND rel.round=10
0.0019  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 = 28497 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 28497 AND esl.points > 0
0.0019  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` = 28497 ORDER BY creation_date DESC LIMIT 0, 10
0.0022  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` = 28497
0.0019  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 `calendars1982` 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` = 28497 AND c.`round` = 10 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 `events1982` e INNER JOIN calendars1982 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 = 10 AND e.real_date IS NOT NULL AND e.league_id = 28497 ORDER BY total DESC LIMIT 40
0.0021  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 `events1982` e INNER JOIN calendars1982 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 = 28497 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0021  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 `tables1982` 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 = 28497 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1982` 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 = 28497 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 28497 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0021  SELECT data1, data2 FROM services_tags WHERE categoryId=41
0.0021  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 41 AND l.year = 1982 ORDER BY l.group_code ASC
0.0021  SELECT group_code, extraName from `leagues` WHERE categoryId=41 AND year=1982