4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1982
Temporada Siguiente »
Publicidad 600x120.gif
Liga MX - Apertura 1982
1981/1982

Liga MX - Apertura 1982

Información Histórica 
						
Regular Season

Final Tables:

Group 1                   P   W   T   L  GF  GA   PTS
  1.- America            38  16  13   9  54  31    45  Championship Playoff
  2.- U.A.N.L.           38  16  12  10  58  43    44  Championship Playoff
  3.- Puebla             38  15  11  12  59  56    41
  4.- U.N.A.M.           38  12  14  12  64  51    38
  5.- Atlas              38   9   8  21  35  67    26  Relegation Playoff
  
Group 2                   P   W   T   L  GF  GA   PTS
  1.- U. de Guadalajara  38  13  17   8  49  35    43  Championship Playoff
  2.- Deportivo Neza     38  13  17   8  54  43    43  Championship Playoff
  3.- Cruz Azul          38  14  15   9  51  44    43
  4.- Atletico Potosino  38  14  13  11  55  53    41
  5.- Leon               38   6  15  17  41  65    27

Group 3                   P   W   T   L  GF  GA   PTS
  1.- Zacatepec          38  14  17   7  44  29    45  Championship Playoff
  2.- Atletico Español   38  12   9  17  48  55    33  Championship Playoff
  3.- Atletico Morelia   38   9  14  15  37  49    32
  4.- Guadalajara        38   6  15  17  39  55    27
  5.- Tampico            38   8  10  20  45  72    26  Relegation Playoff

Group 4                   P   W   T   L  GF  GA   PTS 
  1.- Atlante            38  21  11   6  62  31    53  Championship Playoff
  2.- Monterrey          38  13  14  11  49  56    40  Championship Playoff
  3.- Atletas Campesinos 38  14  11  13  44  42    39
  4.- Toluca             38  12  14  12  53  57    38
  5.- U.A.G.             38  11  14  13  48  55    36

Round  1                                       
Cruz Azul            1 - 1 Toluca              
A.Español            2 - 2 A.Potosino          
Neza                 1 - 1 América             
U.N.A.M.             0 - 0 Zacatepec           
Tigres               1 - 0 U.de G.             
León                 1 - 0 Tampico             
A.Morelia            0 - 1 Atlante             
Atlas                0 - 2 Monterrey           
U.A.G.               2 - 0 Guadalajara         
Puebla               1 - 2 A.Campesinos        
                                               
Round  2                                       
Atlante              3 - 1 Cruz Azul           
Tampico              2 - 0 A.Español           
Toluca               2 - 1 Neza                
U.de G.              3 - 1 U.N.A.M.            
Guadalajara          2 - 1 Tigres              
Zacatepec            4 - 1 León                
A.Potosino           1 - 0 A.Morelia           
A.Campesinos         1 - 1 Atlas               
Monterrey            2 - 2 U.A.G.              
América              3 - 0 Puebla              
                                               
Round  3                                       
Neza                 1 - 3 Atlante             
A.Potosino           5 - 2 Tampico             
Puebla               4 - 1 Toluca              
León                 0 - 1 U.de G.             
U.N.A.M.             2 - 1 Guadalajara         
A.Español            0 - 0 Zacatepec           
A.Morelia            1 - 0 Cruz Azul           
U.A.G.               1 - 1 A.Campesinos        
Tigres               3 - 0 Monterrey           
Atlas                0 - 3 América             
                                               
Round  4                                       
Cruz Azul            1 - 1 Neza                
Zacatepec            3 - 1 A.Potosino          
Atlante              0 - 1 Puebla              
Guadalajara          2 - 1 León                
Monterrey            1 - 5 U.N.A.M.            
U.de G.              0 - 1 A.Español           
Tampico              2 - 3 A.Morelia           
América              2 - 1 U.A.G.              
A.Campesinos         1 - 0 Tigres              
Toluca               3 - 1 Atlas               
                                               
Round  5                                       
Puebla               3 - 4 Cruz Azul           
Tampico              0 - 0 Zacatepec           
Atlas                1 - 2 Atlante             
A.Español            3 - 1 Guadalajara         
León                 1 - 2 Monterrey           
A.Potosino           1 - 1 U.de G.             
A.Morelia            0 - 1 Neza                
Tigres               2 - 1 América             
U.N.A.M.             0 - 0 A.Campesinos        
U.A.G.               2 - 2 Toluca              
                                               
Round  6                                       
Neza                 0 - 0 Puebla              
U.de G.              3 - 0 Tampico             
Cruz Azul            0 - 1 Atlas               
Monterrey            1 - 0 A.Español           
A.Campesinos         4 - 0 León                
Guadalajara          2 - 3 A.Potosino          
Zacatepec            2 - 2 A.Morelia           
Toluca               1 - 1 Tigres              
América              2 - 0 U.N.A.M.            
Atlante              3 - 1 U.A.G.              
                                               
Round  7                                       
Atlas                2 - 2 Neza                
Zacatepec            1 - 0 U.de G.             
U.A.G.               0 - 0 Cruz Azul           
A.Potosino           2 - 1 Monterrey           
A.Español            0 - 1 A.Campesinos        
Tampico              4 - 0 Guadalajara         
A.Morelia            2 - 4 Puebla              
U.N.A.M.             3 - 2 Toluca              
León                 3 - 2 América             
Tigres               2 - 2 Atlante             
                                               
Round  8                                       
Puebla               1 - 0 Atlas               
Guadalajara          1 - 3 Zacatepec           
Neza                 5 - 0 U.A.G.              
A.Campesinos         2 - 1 A.Potosino          
América              2 - 2 A.Español           
Monterrey            4 - 3 Tampico             
U.de G.              2 - 0 A.Morelia           
Atlante              3 - 1 U.N.A.M.            
Toluca               3 - 3 León                
Cruz Azul            0 - 1 Tigres              
                                               
Round  9                                       
U.A.G.               0 - 1 Puebla              
U.de G.              1 - 1 Guadalajara         
Tigres               2 - 2 Neza                
Tampico              2 - 3 A.Campesinos        
A.Potosino           2 - 1 América             
Zacatepec            3 - 1 Monterrey           
A.Morelia            3 - 2 Atlas               
León                 2 - 4 Atlante             
A.Español            2 - 2 Toluca              
U.N.A.M.             1 - 0 Cruz Azul           
                                               
Round 10                                       
Atlas                1 - 0 U.A.G.              
Monterrey            1 - 1 U.de G.             
Puebla               2 - 0 Tigres              
América              0 - 1 Tampico             
Toluca               1 - 1 A.Potosino          
A.Campesinos         1 - 1 Zacatepec           
Guadalajara          0 - 0 A.Morelia           
Cruz Azul            2 - 0 León                
Atlante              2 - 0 A.Español           
Neza                 1 - 1 U.N.A.M.            
                                               
Round 11                                       
Tigres               0 - 1 Atlas               
Guadalajara          1 - 2 Monterrey           
U.N.A.M.             3 - 3 Puebla              
Zacatepec            0 - 0 América             
Tampico              0 - 0 Toluca              
U.de G.              2 - 1 A.Campesinos        
A.Morelia            2 - 2 U.A.G.              
A.Español            1 - 3 Cruz Azul           
A.Potosino           1 - 0 Atlante             
León                 0 - 0 Neza                
                                               
Round 12                                       
U.A.G.               1 - 0 Tigres              
A.Campesinos         1 - 1 Guadalajara         
Atlas                2 - 1 U.N.A.M.            
Toluca               0 - 1 Zacatepec           
Atlante              4 - 1 Tampico             
América              1 - 0 U.de G.             
Monterrey            4 - 2 A.Morelia           
Neza                 4 - 3 A.Español           
Cruz Azul            1 - 1 A.Potosino          
Puebla               2 - 0 León                
                                               
Round 13                                       
U.N.A.M.             2 - 2 U.A.G.              
Monterrey            2 - 0 A.Campesinos        
León                 0 - 0 Atlas               
U.de G.              0 - 1 Toluca              
Zacatepec            1 - 2 Atlante             
Guadalajara          2 - 0 América             
A.Morelia            1 - 0 Tigres              
A.Potosino           3 - 1 Neza                
Tampico              0 - 1 Cruz Azul           
A.Español            3 - 0 Puebla              
                                               
Round 14                                       
Tigres               3 - 2 U.N.A.M.            
América              5 - 0 Monterrey           
U.A.G.               1 - 1 León                
Atlante              1 - 1 U.de G.             
Cruz Azul            1 - 1 Zacatepec           
Toluca               0 - 0 Guadalajara         
A.Campesinos         1 - 0 A.Morelia           
Puebla               2 - 2 A.Potosino          
Neza                 3 - 0 Tampico             
Atlas                2 - 1 A.Español           
                                               
Round 15                                       
León                 0 - 1 Tigres              
A.Campesinos         2 - 1 América             
A.Español            3 - 1 U.A.G.              
Guadalajara          0 - 2 Atlante             
U.de G.              1 - 1 Cruz Azul           
Monterrey            0 - 1 Toluca              
A.Morelia            0 - 2 U.N.A.M.            
Tampico              3 - 2 Puebla              
Zacatepec            1 - 1 Neza                
A.Potosino           1 - 1 Atlas               
                                               
Round 16                                       
U.N.A.M.             7 - 2 León                
Toluca               2 - 1 A.Campesinos        
Tigres               1 - 0 A.Español           
Cruz Azul            4 - 2 Guadalajara         
Neza                 1 - 1 U.de G.             
Atlante              0 - 0 Monterrey           
América              1 - 0 A.Morelia           
Atlas                0 - 0 Tampico             
Puebla               2 - 1 Zacatepec           
U.A.G.               2 - 1 A.Potosino          
                                               
Round 17                                       
A.Español            2 - 2 U.N.A.M.            
América              1 - 1 Toluca              
A.Potosino           2 - 2 Tigres              
Monterrey            1 - 1 Cruz Azul           
Guadalajara          2 - 3 Neza                
A.Campesinos         2 - 2 Atlante             
A.Morelia            1 - 1 León                
Zacatepec            1 - 0 Atlas               
U.de G.              5 - 1 Puebla              
Tampico              0 - 0 U.A.G.              
                                               
Round 18                                       
León                 1 - 1 A.Español           
Atlante              0 - 0 América             
U.N.A.M.             1 - 1 A.Potosino          
Neza                 1 - 1 Monterrey           
Puebla               2 - 2 Guadalajara         
Cruz Azul            2 - 1 A.Campesinos        
A.Morelia            2 - 4 Toluca              
U.A.G.               1 - 0 Zacatepec           
Atlas                3 - 3 U.de G.             
Tigres               4 - 1 Tampico             
                                               
Round 19                                       
A.Potosino           2 - 3 León                
Toluca               1 - 3 Atlante             
Tampico              1 - 1 U.N.A.M.            
A.Campesinos         0 - 2 Neza                
Monterrey            0 - 0 Puebla              
América              1 - 1 Cruz Azul           
A.Español            2 - 0 A.Morelia           
U.de G.              0 - 1 U.A.G.              
Guadalajara          3 - 0 Atlas               
Zacatepec            1 - 1 Tigres              
                                               
Round 20                                       
Toluca               1 - 2 Cruz Azul           
A.Potosino           2 - 0 A.Español           
América              1 - 0 Neza                
Zacatepec            0 - 2 U.N.A.M.            
U.de G.              5 - 2 Tigres              
Tampico              1 - 1 León                
Atlante              4 - 1 A.Morelia           
Monterrey            2 - 1 Atlas               
Guadalajara          2 - 2 U.A.G.              
A.Campesinos         2 - 1 Puebla              
                                               
Round 21                                       
Neza                 0 - 1 Toluca              
A.Morelia            1 - 0 A.Potosino          
Puebla               1 - 3 América             
León                 0 - 0 Zacatepec           
U.N.A.M.             1 - 1 U.de G.             
A.Español            2 - 0 Tampico             
Cruz Azul            0 - 0 Atlante             
U.A.G.               1 - 1 Monterrey           
Tigres               0 - 0 Guadalajara         
Atlas                0 - 0 A.Campesinos        
                                               
Round 22                                       
Atlante              1 - 1 Neza                
Tampico              1 - 1 A.Potosino          
Toluca               0 - 1 Puebla              
U.de G.              1 - 0 León                
Guadalajara          0 - 1 U.N.A.M.            
Zacatepec            2 - 1 A.Español           
Cruz Azul            0 - 1 A.Morelia           
A.Campesinos         1 - 0 U.A.G.              
Monterrey            1 - 1 Tigres              
América              3 - 0 Atlas               
                                               
Round 23                                       
Puebla               2 - 1 Atlante             
A.Morelia            1 - 0 Tampico             
Atlas                2 - 5 Toluca              
A.Español            1 - 1 U.de G.             
León                 1 - 1 Guadalajara         
A.Potosino           2 - 1 Zacatepec           
Neza                 3 - 2 Cruz Azul           
Tigres               4 - 0 A.Campesinos        
U.N.A.M.             0 - 0 Monterrey           
U.A.G.               0 - 2 América             
                                               
Round 24                                       
Cruz Azul            2 - 0 Puebla              
Zacatepec            3 - 0 Tampico             
Atlante              1 - 0 Atlas               
Guadalajara          1 - 2 A.Español           
Monterrey            1 - 1 León                
U.de G.              1 - 0 A.Potosino          
Neza                 0 - 0 A.Morelia           
América              0 - 1 Tigres              
A.Campesinos         0 - 1 U.N.A.M.            
Toluca               1 - 3 U.A.G.              
                                               
Round 25                                       
Atlas                1 - 3 Cruz Azul           
A.Morelia            0 - 0 Zacatepec           
U.A.G.               0 - 0 Atlante             
A.Potosino           1 - 1 Guadalajara         
A.Español            3 - 2 Monterrey           
Tampico              0 - 1 U.de G.             
Puebla               3 - 1 Neza                
U.N.A.M.             0 - 0 América             
León                 0 - 2 A.Campesinos        
Tigres               1 - 1 Toluca              
                                               
Round 26                                       
Neza                 1 - 0 Atlas               
U.de G.              1 - 1 Zacatepec           
Cruz Azul            2 - 3 U.A.G.              
Monterrey            2 - 1 A.Potosino          
A.Campesinos         1 - 1 A.Español           
Guadalajara          4 - 0 Tampico             
Puebla               1 - 0 A.Morelia           
Toluca               2 - 2 U.N.A.M.            
América              2 - 1 León                
Atlante              1 - 1 Tigres              
                                               
Round 27                                       
U.A.G.               1 - 1 Neza                
A.Morelia            4 - 1 U.de G.             
Tigres               1 - 1 Cruz Azul           
Tampico              4 - 2 Monterrey           
A.Potosino           1 - 0 A.Campesinos        
Zacatepec            0 - 0 Guadalajara         
Atlas                1 - 3 Puebla              
León                 3 - 1 Toluca              
A.Español            1 - 2 América             
U.N.A.M.             1 - 2 Atlante             
                                               
Round 28                                       
Puebla               1 - 1 U.A.G.              
Guadalajara          0 - 0 U.de G.             
Neza                 2 - 1 Tigres              
A.Campesinos         2 - 0 Tampico             
América              1 - 0 A.Potosino          
Monterrey            0 - 2 Zacatepec           
Atlas                2 - 1 A.Morelia           
Atlante              1 - 0 León                
Toluca               2 - 0 A.Español           
Cruz Azul            2 - 1 U.N.A.M.            
                                               
Round 29                                       
Tigres               1 - 2 Puebla              
A.Morelia            1 - 0 Guadalajara         
U.N.A.M.             1 - 2 Neza                
Zacatepec            1 - 0 A.Campesinos        
Tampico              1 - 1 América             
U.de G.              1 - 1 Monterrey           
U.A.G.               2 - 1 Atlas               
A.Español            1 - 2 Atlante             
A.Potosino           1 - 0 Toluca              
León                 1 - 1 Cruz Azul           
                                               
Round 30                                       
Atlas                1 - 3 Tigres              
Monterrey            4 - 2 Guadalajara         
Puebla               1 - 1 U.N.A.M.            
América              0 - 0 Zacatepec           
Toluca               2 - 1 Tampico             
A.Campesinos         1 - 1 U.de G.             
U.A.G.               0 - 0 A.Morelia           
Cruz Azul            1 - 0 A.Español           
Atlante              0 - 0 A.Potosino          
Neza                 2 - 1 León                
                                               
Round 31                                       
U.N.A.M.             6 - 0 Atlas               
A.Morelia            1 - 1 Monterrey           
León                 1 - 1 Puebla              
U.de G.              2 - 2 América             
Zacatepec            4 - 0 Toluca              
Guadalajara          1 - 1 A.Campesinos        
Tigres               1 - 3 U.A.G.              
A.Potosino           2 - 2 Cruz Azul           
Tampico              1 - 4 Atlante             
A.Español            0 - 0 Neza                
                                               
Round 32                                       
U.A.G.               1 - 3 U.N.A.M.            
A.Campesinos         2 - 0 Monterrey           
Atlas                1 - 1 León                
Toluca               0 - 0 U.de G.             
Atlante              0 - 1 Zacatepec           
América              1 - 1 Guadalajara         
Tigres               1 - 1 A.Morelia           
Neza                 6 - 1 A.Potosino          
Cruz Azul            3 - 0 Tampico             
Puebla               3 - 4 A.Español           
                                               
Round 33                                       
León                 2 - 0 U.A.G.              
A.Morelia            0 - 0 A.Campesinos        
A.Español            2 - 0 Atlas               
Guadalajara          1 - 1 Toluca              
U.de G.              1 - 3 Atlante             
Monterrey            1 - 0 América             
U.N.A.M.             1 - 2 Tigres              
Tampico              2 - 0 Neza                
Zacatepec            1 - 1 Cruz Azul           
A.Potosino           2 - 1 Puebla              
                                               
Round 34                                       
Tigres               3 - 1 León                
América              3 - 0 A.Campesinos        
U.A.G.               4 - 0 A.Español           
Atlante              0 - 1 Guadalajara         
Cruz Azul            0 - 0 U.de G.             
Toluca               2 - 1 Monterrey           
U.N.A.M.             1 - 1 A.Morelia           
Puebla               1 - 1 Tampico             
Neza                 0 - 0 Zacatepec           
Atlas                2 - 0 A.Potosino          
                                               
Round 35                                       
A.Español            0 - 2 Tigres              
A.Morelia            1 - 1 América             
A.Potosino           4 - 1 U.A.G.              
Monterrey            1 - 0 Atlante             
Guadalajara          1 - 2 Cruz Azul           
A.Campesinos         3 - 0 Toluca              
León                 3 - 1 U.N.A.M.            
Zacatepec            1 - 1 Puebla              
U.de G.              2 - 0 Neza                
Tampico              4 - 2 Atlas               
                                               
Round 36                                       
Atlante              1 - 0 A.Campesinos        
León                 3 - 3 A.Morelia           
Cruz Azul            1 - 1 Monterrey           
Tigres               3 - 1 A.Potosino          
U.A.G.               4 - 2 Tampico             
U.N.A.M.             3 - 0 A.Español           
Toluca               3 - 0 América             
Puebla               0 - 0 U.de G.             
Atlas                2 - 0 Zacatepec           
Neza                 0 - 0 Guadalajara         
                                               
Round 37                                       
A.Potosino           2 - 1 U.N.A.M.            
A.Español            3 - 0 León                
Monterrey            0 - 0 Neza                
Guadalajara          0 - 3 Puebla              
Toluca               1 - 1 A.Morelia           
U.de G.              3 - 0 Atlas               
A.Campesinos         1 - 2 Cruz Azul           
América              0 - 0 Atlante             
Tampico              2 - 2 Tigres              
Zacatepec            3 - 1 U.A.G.              
                                               
Round 38                                       
U.N.A.M.             2 - 3 Tampico             
León                 1 - 1 A.Potosino          
Cruz Azul            0 - 5 América             
Tigres               3 - 0 Zacatepec           
U.A.G.               1 - 2 U.de G.             
Atlante              4 - 2 Toluca              
Atlas                1 - 0 Guadalajara         
Puebla               2 - 3 Monterrey           
A.Morelia            0 - 1 A.Español           
Neza                 4 - 3 A.Campesinos        

Final Tables:

Group 1                   P   W   T   L  GF  GA   PTS
  1.- America            38  16  13   9  54  31    45  Championship Playoff
  2.- U.A.N.L.           38  16  12  10  58  43    44  Championship Playoff
  3.- Puebla             38  15  11  12  59  56    41
  4.- U.N.A.M.           38  12  14  12  64  51    38
  5.- Atlas              38   9   8  21  35  67    26  Relegation Playoff
  
Group 2                   P   W   T   L  GF  GA   PTS
  1.- U. de Guadalajara  38  13  17   8  49  35    43  Championship Playoff
  2.- Deportivo Neza     38  13  17   8  54  43    43  Championship Playoff
  3.- Cruz Azul          38  14  15   9  51  44    43
  4.- Atletico Potosino  38  14  13  11  55  53    41
  5.- Leon               38   6  15  17  41  65    27

Group 3                   P   W   T   L  GF  GA   PTS
  1.- Zacatepec          38  14  17   7  44  29    45  Championship Playoff
  2.- Atletico Español   38  12   9  17  48  55    33  Championship Playoff
  3.- Atletico Morelia   38   9  14  15  37  49    32
  4.- Guadalajara        38   6  15  17  39  55    27
  5.- Tampico            38   8  10  20  45  72    26  Relegation Playoff

Group 4                   P   W   T   L  GF  GA   PTS 
  1.- Atlante            38  21  11   6  62  31    53  Championship Playoff
  2.- Monterrey          38  13  14  11  49  56    40  Championship Playoff
  3.- Atletas Campesinos 38  14  11  13  44  42    39
  4.- Toluca             38  12  14  12  53  57    38
  5.- U.A.G.             38  11  14  13  48  55    36


RELEGATION FINAL

First Leg
Atlas                1 - 0 Tampico 

Second Leg
Tampico              0 - 1 Atlas           

Third Match
Tampico              1 – 3 Atlas        (In San Luis Potosi)

Relegated : Tampico

CHAMPIONSHIP QUARTERFINALS

First Legs
U.de G.              1 - 1 Tigres         
Monterrey            2 - 1 América         
A.Español            1 - 3 Atlante        
Neza                 2 - 0 Zacatepec      

Second Legs
Tigres               2 - 1 U.de G.         
América              4 - 1 Monterrey       
Atlante              2 - 2 A.Español     
Zacatepec            2 - 1 Neza           

CHAMPIONSHIP SEMIFINALS

First Legs
Tigres               2 - 0 América         
Neza                 0 – 1 Atlante 

Second Legs
América              1 – 0 Tigres   
Atlante              0 – 0 Neza    

CHAMPIONSHIP FINAL

First Legs
Tigres               2 – 1 Atlante           

Second Legs 
Atlante              1 – 0 Tigres          [aet, 1-3 pen]

Champions : Tigres



Author: Fernando Castro
(fdo_castro@yahoo.com.mx)

Last updated: 5 Mar 2005

(C) Copyright Fernando Castro and RSSSF 2004/05

INFORMACIÓN

La Primera División (conocida comercialmente como Liga BBVA Bancomer MX) es la liga de fútbol profesional más importante de México, es el primer nivel en el Sistema de ligas de fútbol en México. Se juegan dos torneos cortos por ciclo anual futbolistico (cada uno con su campeón) denominados Apertura y Clausura (en ese orden), antes llamados Invierno y Verano respectivamente. El campeonato se define por medio de una fase final posterior a cada fase regular, conocida como liguilla; la clasificación a esta, se hará con base en la tabla general.

  USO DE MEMORIA  
4,296,752 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6286
Total Execution Time  0.6306
  CADENA URL  
/apertura_mexico1982
  GET DATOS  
$_GET['/apertura_mexico1982']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0145  SELECT type FROM routes WHERE alias = 'apertura_mexico1982'
0.0291  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' 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.0293  SELECT text_es as historical_text FROM leagues_text WHERE id=2002
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 = 30264 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 20:07:52' 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=2 AND last_update > '2024-04-27 20:07:52' 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=4 AND last_update > '2024-04-27 20:07:52' 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=3 AND last_update > '2024-04-27 20:07:52' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' 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.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1982 e WHERE e.league_id IN (30264) 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 (30264) 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 events1982 e WHERE e.league_id IN (30264) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0144  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 (30264) 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 events1982 e WHERE e.league_id IN (30264) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (30264) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1982 e WHERE e.league_id IN (30264) AND (e.action IN (22) ) 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 (30264) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 30264 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  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 = 30264 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=30264 AND rel.round=38
0.0150  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 = 30264 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0147  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 = 30264 AND esl.points > 0
0.0147  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` = 30264 ORDER BY creation_date DESC LIMIT 0, 10
0.0149  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` = 30264
0.0147  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` = 30264 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0144  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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 30264 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 `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 = 30264 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 `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 = 30264 AND t.round = 36 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 `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 = 30264 AND t.round = 38 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 = 30264 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0146  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0146  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1982 ORDER BY l.group_code ASC
0.0146  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1982