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

Liga MX - Apertura 1978

Información Histórica 
						
Regular Season

Final Tables:

Group 1                   P   W   T   L  GF  GA   PTS
  1.- U.N.A.M.           38  20   8  10  81  53    48  Championship Playoff
  2.- U.A.G.             38  17  12   9  73  46    46  Championship Playoff
  3.- Laguna             38   8  19  11  45  49    35
  4.- Atletico Potosino  38  11  10  17  41  64    32
  5.- U. de Curtidores   38   8  10  20  42  71    26  Relegation Playoff

Group 2                   P   W   T   L  GF  GA   PTS
  1.- America            38  19  13   6  55  38    51  Championship Playoff
  2.- U.A.N.L.           38  18   8  12  50  40    44  Championship Playoff
  3.- Jalisco            38  16   8  14  61  60    40
  4.- Monterrey          38  15   8  15  63  56    38
  5.- Leon               38  13  10  15  60  61    36
  
Group 3                   P   W   T   L  GF  GA   PTS
  1.- Cruz Azul          38  14  15   9  56  44    43  Championship Playoff
  2.- Tampico            38  11  13  14  53  55    35  Championship Playoff
  3.- Guadalajara        38  12  10  16  48  56    34
  4.- Atlante            38  11  12  15  44  55    34
  5.- Veracruz           38  12   9  17  50  62    33

Group 4                   P   W   T   L  GF  GA   PTS
  1.- Toluca             38  20   7  11  55  37    47  Championship Playoff
  2.- U. de Guadalajara  38  17   7  14  61  50    41  Championship Playoff
  3.- Atletico Español   38  13  15  10  58  51    41
  4.- Puebla             38  10   8  20  35  52    28
  5.- Atlas              38  10   8  20  36  67    28  Relegation Playoff

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

Final Tables:

Group 1                   P   W   T   L  GF  GA   PTS
  1.- U.N.A.M.           38  20   8  10  81  53    48  Championship Playoff
  2.- U.A.G.             38  17  12   9  73  46    46  Championship Playoff
  3.- Laguna             38   8  19  11  45  49    35
  4.- Atletico Potosino  38  11  10  17  41  64    32
  5.- U. de Curtidores   38   8  10  20  42  71    26  Relegation Playoff

Group 2                   P   W   T   L  GF  GA   PTS
  1.- America            38  19  13   6  55  38    51  Championship Playoff
  2.- U.A.N.L.           38  18   8  12  50  40    44  Championship Playoff
  3.- Jalisco            38  16   8  14  61  60    40
  4.- Monterrey          38  15   8  15  63  56    38
  5.- Leon               38  13  10  15  60  61    36
  
Group 3                   P   W   T   L  GF  GA   PTS
  1.- Cruz Azul          38  14  15   9  56  44    43  Championship Playoff
  2.- Tampico            38  11  13  14  53  55    35  Championship Playoff
  3.- Guadalajara        38  12  10  16  48  56    34
  4.- Atlante            38  11  12  15  44  55    34
  5.- Veracruz           38  12   9  17  50  62    33

Group 4                   P   W   T   L  GF  GA   PTS
  1.- Toluca             38  20   7  11  55  37    47  Championship Playoff
  2.- U. de Guadalajara  38  17   7  14  61  50    41  Championship Playoff
  3.- Atletico Español   38  13  15  10  58  51    41
  4.- Puebla             38  10   8  20  35  52    28
  5.- Atlas              38  10   8  20  36  67    28  Relegation Playoff

RELEGATION FINAL

First Leg
U.de Curtidores      0 - 0 Atlas   

Second Leg
Atlas                2 - 4 U.de Curtidores

Relegated : Atlas

CHAMPIONSHIP QUARTERFINALS

First Legs
Tigres               1 - 0 U.A.G.         
Cruz Azul            1 - 0 Toluca          
U.de G.              2 - 1 U.N.A.M.       
Tampico              2 - 2 América        

Second Legs
U.A.G.               2 - 3 Tigres          
Toluca               2 - 2 Cruz Azul       
U.N.A.M.             2 - 0 U.de G.        
América              1 - 1 Tampico            [aet, 2-4 pen]      

CHAMPIONSHIP SEMIFINALS

First Legs
Cruz Azul            1 - 0 Tigres          
Tampico              2 – 1 U.N.A.M.

Second Legs
Tigres               3 – 0 Cruz Azul
U.N.A.M.             4 – 0 Tampico

CHAMPIONSHIP FINAL

First Leg
Tigres               2 – 0 U.N.A.M.

Second Legs
U.N.A.M.             1 – 1 Tigres

Champions : Tigres



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

Last updated: 27 Mar 2004

(C) Copyright Fernando Castro and RSSSF 2004

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,299,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5168
Total Execution Time  0.5188
  CADENA URL  
/apertura_mexico1978
  GET DATOS  
$_GET['/apertura_mexico1978']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0106  SELECT type FROM routes WHERE alias = 'apertura_mexico1978'
0.0213  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 = 1978 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0177  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 68 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1304130,1303039,1297779,1295604,1295599) ORDER BY n.cover_points DESC, update_date DESC
0.0113  SELECT text_es as historical_text FROM leagues_text WHERE id=2007
0.0106  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 = 30269 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0118  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='1978' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:29:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:29:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 13:29:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 13:29:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0124  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 = 1978 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0111  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (30269) 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.0112  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 (30269) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (30269) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0107  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 (30269) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (30269) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0106  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 (30269) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT e.action, count(e.action) as total, e.player_id FROM events1978 e WHERE e.league_id IN (30269) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0105  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 (30269) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0105  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 = 30269 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0105  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 = 30269 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0121  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=30269 AND rel.round=38
0.0118  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 = 30269 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0116  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 = 30269 AND esl.points > 0
0.0116  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` = 30269 ORDER BY creation_date DESC LIMIT 0, 10
0.0136  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` = 30269
0.0114  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 `calendars1978` 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` = 30269 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0106  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 `events1978` e INNER JOIN calendars1978 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 = 30269 ORDER BY total DESC LIMIT 40
0.0109  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 `events1978` e INNER JOIN calendars1978 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 = 30269 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0111  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 `tables1978` 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 = 30269 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1978` 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 = 30269 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 30269 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0111  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0111  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1978 ORDER BY l.group_code ASC
0.0111  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1978