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

Liga MX - Apertura 1971

Información Histórica 
						

Group Corsairs:           P   W   T   L  GF  GA  GAVG PTS
  1.- Toluca             34  14  15   5  38  21  1.81  43  Championship Playoff
  2.- Jalisco            34  12  14   8  35  29  1.21  38
  2.- Zacatepec          34  14  10  10  39  37  1.05  38
  4.- Cruz Azul          34  11  15   8  39  39  1.00  37
  5.- U.N.A.M.           34  10  15   9  43  38  1.13  35
  6.- Necaxa             34  10  11  13  44  39  1.13  31
  7.- Irapuato           34   8  13  13  34  53  0.64  29
  8.- Laguna             34  10   8  16  37  47  0.79  28
  9.- Atlas              34   5  12  17  32  48  0.67  22  Relegation Playoff
 
Group Pirates:            P   W   T   L  GF  GA  GAVG PTS
  1.- América            34  17  10   7  56  33  1.70  44  Championship Playoff
  2.- Monterrey          34  15  10   9  46  37  1.24  40
  3.- León               34  14  10  10  50  41  1.22  38
  4.- Atlante            34   9  16   9  33  31  1.06  34 
  5.- Veracruz           34  12   9  13  39  40  0.98  33
  6.- Puebla             34  11  10  13  43  49  0.88  32
  7.- Torreón            34  11   9  14  27  35  0.77  31
  8.- Guadalajara        34  11   8  15  34  44  0.77  30
  9.- Pachuca            34  11   7  16  38  46  0.83  29  Relegation Playoff

Round 1                                       
América              2 - 0 Puebla              
León                 1 - 2 Atlante             
Veracruz             0 - 1 Monterrey           
Cruz Azul            0 - 4 Necaxa              
Guadalajara          1 - 2 Zacatepec           
Atlas                2 - 3 A.Pachuca           
U.N.A.M.             1 - 0 Torreón             
Toluca               1 - 1 Jalisco             
Laguna               2 - 0 Irapuato            
                                               
Round 2                                        
A.Pachuca            2 - 1 América             
Puebla               1 - 1 U.N.A.M.            
Zacatepec            0 - 0 Veracruz            
Torreón              0 - 1 Cruz Azul           
Atlante              3 - 0 Guadalajara         
Jalisco              0 - 3 Atlas               
Irapuato             1 - 1 León                
Monterrey            1 - 1 Toluca              
Necaxa               1 - 1 Laguna              
                                               
Round 3                                        
Cruz Azul            1 - 0 Laguna              
Torreón              2 - 0 Puebla              
Toluca               1 - 0 Zacatepec           
U.N.A.M.             0 - 1 A.Pachuca           
Veracruz             0 - 1 Atlante             
América              2 - 1 Jalisco             
Guadalajara          2 - 0 Irapuato            
Atlas                2 - 1 Monterrey           
León                 0 - 3 Necaxa              
                                               
Round 4                                        
Jalisco              3 - 1 U.N.A.M.            
Puebla               2 - 0 Cruz Azul           
Atlante              0 - 0 Toluca              
A.Pachuca            1 - 0 Torreón             
Necaxa               1 - 3 Guadalajara         
Monterrey            2 - 1 América             
Irapuato             2 - 0 Veracruz            
Zacatepec            1 - 0 Atlas               
Laguna               2 - 0 León                
                                               
Round 5                                        
Torreón              0 - 1 Jalisco             
Guadalajara          1 - 0 Laguna              
Atlas                0 - 1 Atlante             
Puebla               3 - 1 A.Pachuca           
Toluca               4 - 1 Irapuato            
U.N.A.M.             2 - 2 Monterrey           
Veracruz             2 - 1 Necaxa              
América              2 - 4 Zacatepec           
Cruz Azul            0 - 1 León                
                                               
Round 6                                       
Necaxa               0 - 2 Toluca              
Jalisco              1 - 1 Puebla              
Monterrey            2 - 0 Torreón             
Atlante              3 - 1 América             
León                 1 - 2 Guadalajara         
A.Pachuca            3 - 1 Cruz Azul           
Irapuato             1 - 0 Atlas               
Laguna               1 - 0 Veracruz            
Zacatepec            1 - 0 U.N.A.M.            
                                               
Round 7                                       
Toluca               3 - 2 Laguna              
U.N.A.M.             1 - 1 Atlante             
Puebla               2 - 0 Monterrey           
A.Pachuca            1 - 1 Jalisco             
Torreón              1 - 0 Zacatepec           
Veracruz             0 - 1 León                
Atlas                1 - 1 Necaxa              
Cruz Azul            2 - 1 Guadalajara         
América              2 - 0 Irapuato            
                                               
Round 8                                        
Guadalajara          0 - 1 Veracruz            
Atlante              1 - 0 Torreón             
Necaxa               1 - 0 América             
León                 2 - 0 Toluca              
Irapuato             2 - 1 U.N.A.M.            
Laguna               4 - 1 Atlas               
Zacatepec            2 - 1 Puebla              
Jalisco              1 - 1 Cruz Azul           
Monterrey            0 - 2 A.Pachuca           
                                               
Round 9                                        
U.N.A.M.             2 - 2 Necaxa              
Jalisco              2 - 0 Monterrey           
Cruz Azul            0 - 2 Veracruz            
Atlas                2 - 1 León                
América              2 - 1 Laguna              
Toluca               3 - 0 Guadalajara         
Puebla               0 - 0 Atlante             
A.Pachuca            1 - 0 Zacatepec           
Torreón              1 - 0 Irapuato            
                                               
Round 10                                      
León                 1 - 1 América             
Atlante              1 - 0 A.Pachuca           
Irapuato             3 - 3 Puebla              
Zacatepec            2 - 2 Jalisco             
Monterrey            0 - 2 Cruz Azul           
Veracruz             1 - 1 Toluca              
Laguna               1 - 1 U.N.A.M.            
Guadalajara          2 - 1 Atlas               
Necaxa               0 - 0 Torreón             
                                               
Round 11                                       
U.N.A.M.             1 - 1 León                
Puebla               2 - 1 Necaxa              
A.Pachuca            1 - 2 Irapuato            
Monterrey            4 - 0 Zacatepec           
Cruz Azul            0 - 0 Toluca              
América              5 - 2 Guadalajara         
Jalisco              1 - 1 Atlante             
Torreón              3 - 0 Laguna              
Atlas                0 - 0 Veracruz            
                                               
Round 12                                       
Atlante              1 - 1 Monterrey           
Zacatepec            1 - 2 Cruz Azul           
Guadalajara          1 - 1 U.N.A.M.            
Necaxa               2 - 1 A.Pachuca           
Toluca               0 - 0 Atlas               
León                 3 - 0 Torreón             
Irapuato             1 - 0 Jalisco             
Veracruz             0 - 0 América             
Laguna               3 - 1 Puebla              
                                               
Round 13                                       
U.N.A.M.             3 - 0 Veracruz            
América              1 - 0 Toluca              
Jalisco              0 - 0 Necaxa              
A.Pachuca            4 - 1 Laguna              
Torreón              1 - 1 Guadalajara         
Zacatepec            1 - 3 Atlante             
Puebla               0 - 1 León                
Monterrey            1 - 0 Irapuato            
Cruz Azul            1 - 1 Atlas               
                                               
Round 14                                       
Laguna               0 - 0 Jalisco             
Toluca               2 - 1 U.N.A.M.            
Irapuato             0 - 0 Zacatepec           
Necaxa               2 - 2 Monterrey           
Veracruz             0 - 0 Torreón             
León                 5 - 1 A.Pachuca           
Atlas                0 - 1 América             
Guadalajara          0 - 0 Puebla              
Atlante              0 - 0 Cruz Azul           
                                               
Round 15                                       
Atlante              0 - 0 Irapuato            
Jalisco              0 - 0 León                
U.N.A.M.             0 - 0 Atlas               
A.Pachuca            0 - 1 Guadalajara         
Puebla               1 - 1 Veracruz            
Torreón              0 - 0 Toluca              
Zacatepec            1 - 0 Necaxa              
Monterrey            1 - 0 Laguna              
Cruz Azul            1 - 1 América             
                                               
Round 16                                       
Atlas                0 - 0 Torreón             
América              0 - 0 U.N.A.M.            
Guadalajara          0 - 1 Jalisco             
Veracruz             4 - 1 A.Pachuca           
León                 0 - 0 Monterrey           
Toluca               1 - 1 Puebla              
Necaxa               1 - 0 Atlante             
Laguna               3 - 1 Zacatepec           
Cruz Azul            0 - 1 Irapuato            
                                               
Round 17                                       
U.N.A.M.             2 - 0 Cruz Azul           
Jalisco              2 - 1 Veracruz            
Atlante              1 - 2 Laguna              
Irapuato             0 - 0 Necaxa              
A.Pachuca            0 - 0 Toluca              
Monterrey            3 - 2 Guadalajara         
Torreón              1 - 1 América             
Zacatepec            2 - 1 León                
Puebla               2 - 0 Atlas               
                                               
Round 18                                       
Atlante              1 - 1 León                
Jalisco              1 - 0 Toluca              
Necaxa               1 - 1 Cruz Azul           
Irapuato             1 - 1 Laguna              
A.Pachuca            0 - 0 Atlas               
Torreón              2 - 0 U.N.A.M.            
Zacatepec            2 - 2 Guadalajara         
Puebla               0 - 2 América             
Monterrey            4 - 1 Veracruz            
                                               
Round 19                                       
Cruz Azul            3 - 1 Torreón             
Guadalajara          0 - 0 Atlante             
América              1 - 1 A.Pachuca           
Toluca               1 - 1 Monterrey           
Atlas                1 - 0 Jalisco             
U.N.A.M.             3 - 0 Puebla              
León                 2 - 2 Irapuato            
Laguna               0 - 0 Necaxa              
Veracruz             2 - 0 Zacatepec           
                                               
Round 20                                       
Laguna               2 - 2 Cruz Azul           
Necaxa               0 - 2 León                
Jalisco              1 - 0 América             
Monterrey            0 - 1 Atlas               
A.Pachuca            1 - 2 U.N.A.M.            
Atlante              2 - 2 Veracruz            
Puebla               1 - 2 Torreón             
Irapuato             3 - 2 Guadalajara         
Zacatepec            0 - 0 Toluca              
                                               
Round 21                                       
Atlas                1 - 1 Zacatepec           
U.N.A.M.             3 - 0 Jalisco             
Guadalajara          1 - 3 Necaxa              
Cruz Azul            4 - 1 Puebla              
América              2 - 3 Monterrey           
León                 4 - 0 Laguna              
Toluca               2 - 0 Atlante             
Veracruz             1 - 0 Irapuato            
Torreón              3 - 1 A.Pachuca           
                                               
Round 22                                       
Atlante              0 - 0 Atlas               
Jalisco              0 - 1 Torreón             
Monterrey            1 - 1 U.N.A.M.            
Necaxa               2 - 0 Veracruz            
Laguna               1 - 2 Guadalajara         
León                 1 - 4 Cruz Azul           
Irapuato             1 - 3 Toluca              
A.Pachuca            1 - 1 Puebla              
Zacatepec            1 - 1 América             
                                               
Round 23                                     
Guadalajara          1 - 2 León                
América              2 - 0 Atlante             
Puebla               2 - 0 Jalisco             
Cruz Azul            1 - 0 A.Pachuca           
Atlas                1 - 1 Irapuato            
U.N.A.M.             0 - 1 Zacatepec           
Toluca               2 - 0 Necaxa              
Torreón              1 - 2 Monterrey           
Veracruz             1 - 0 Laguna              
                                               
Round 24                                       
Jalisco              1 - 0 A.Pachuca           
Necaxa               3 - 1 Atlas               
Guadalajara          1 - 1 Cruz Azul           
Monterrey            2 - 0 Puebla              
Atlante              2 - 2 U.N.A.M.            
León                 2 - 1 Veracruz            
Irapuato             1 - 2 América             
Zacatepec            3 - 1 Torreón             
Laguna               0 - 1 Toluca              
                                               
Round 25                                       
U.N.A.M.             0 - 0 Irapuato            
Atlas                0 - 1 Laguna              
Cruz Azul            0 - 0 Jalisco             
Veracruz             1 - 0 Guadalajara         
Toluca               2 - 0 León                
A.Pachuca            4 - 0 Monterrey           
América              2 - 1 Necaxa              
Torreón              1 - 0 Atlante             
Puebla               1 - 1 Zacatepec           
                                               
Round 26                                       
Atlante              1 - 2 Puebla              
Guadalajara          0 - 0 Toluca              
Veracruz             1 - 2 Cruz Azul           
Monterrey            0 - 0 Jalisco             
Laguna               0 - 2 América             
Zacatepec            1 - 0 A.Pachuca           
León                 3 - 2 Atlas               
Necaxa               1 - 3 U.N.A.M.            
Irapuato             0 - 0 Torreón             
                                               
Round 27                                       
Jalisco              1 - 1 Zacatepec           
América              1 - 1 León                
A.Pachuca            1 - 0 Atlante             
Cruz Azul            1 - 1 Monterrey           
Puebla               3 - 2 Irapuato            
Toluca               1 - 0 Veracruz            
U.N.A.M.             1 - 0 Laguna              
Atlas                1 - 2 Guadalajara         
Torreón              2 - 0 Necaxa              
                                               
Round 28                                       
Necaxa               1 - 3 Puebla              
Guadalajara          1 - 2 América             
León                 2 - 0 U.N.A.M.            
Zacatepec            2 - 1 Monterrey           
Toluca               0 - 1 Cruz Azul           
Atlante              1 - 2 Jalisco             
Irapuato             2 - 1 A.Pachuca           
Veracruz             4 - 2 Atlas               
Laguna               1 - 0 Torreón             
                                               
Round 29                                         
U.N.A.M.             1 - 0 Guadalajara         
Jalisco              0 - 0 Irapuato            
Atlas                1 - 1 Toluca              
Monterrey            1 - 0 Atlante             
América              4 - 1 Veracruz            
A.Pachuca            0 - 3 Necaxa              
Cruz Azul            0 - 0 Zacatepec           
Torreón              1 - 1 León                
Puebla               1 - 1 Laguna              
                                               
Round 30                                       
Guadalajara          1 - 0 Torreón             
Atlante              2 - 1 Zacatepec           
Toluca               0 - 0 América             
León                 4 - 1 Puebla              
Veracruz             3 - 1 U.N.A.M.            
Laguna               3 - 1 A.Pachuca           
Necaxa               0 - 2 Jalisco             
Irapuato             1 - 3 Monterrey           
Atlas                2 - 2 Cruz Azul           
                                               
Round 31                                       
América              2 - 1 Atlas               
Cruz Azul            0 - 0 Atlante             
Jalisco              5 - 1 Laguna              
Monterrey            1 - 1 Necaxa              
Torreón              1 - 1 Veracruz            
Zacatepec            3 - 0 Irapuato            
A.Pachuca            2 - 1 León                
Puebla               0 - 1 Guadalajara         
U.N.A.M.             2 - 2 Toluca              
                                               
Round 32                                        
Atlas                2 - 3 U.N.A.M.            
Necaxa               0 - 1 Zacatepec           
Guadalajara          0 - 0 A.Pachuca           
América              3 - 0 Cruz Azul           
León                 1 - 1 Jalisco             
Toluca               3 - 0 Torreón             
Irapuato             2 - 2 Atlante             
Veracruz             3 - 0 Puebla              
Laguna               0 - 1 Monterrey           
                                               
Round 33                                        
U.N.A.M.             2 - 2 América             
Jalisco              2 - 0 Guadalajara         
Monterrey            4 - 1 León                
Atlante              1 - 1 Necaxa              
Irapuato             4 - 4 Cruz Azul           
A.Pachuca            2 - 2 Veracruz            
Torreón              2 - 1 Atlas               
Zacatepec            2 - 1 Laguna              
Puebla               3 - 0 Toluca              
                                               
Round 34                                       
Guadalajara          1 - 0 Monterrey           
América              5 - 0 Torreón             
Cruz Azul            1 - 1 U.N.A.M.            
Atlas                2 - 4 Puebla              
Necaxa               7 - 0 Irapuato            
León                 2 - 1 Zacatepec           
Toluca               1 - 0 A.Pachuca           
Veracruz             3 - 2 Jalisco             
Laguna               2 - 2 Atlante             

Group Corsairs:           P   W   T   L  GF  GA  GAVG PTS
  1.- Toluca             34  14  15   5  38  21  1.81  43  Championship Playoff
  2.- Jalisco            34  12  14   8  35  29  1.21  38
  2.- Zacatepec          34  14  10  10  39  37  1.05  38
  4.- Cruz Azul          34  11  15   8  39  39  1.00  37
  5.- U.N.A.M.           34  10  15   9  43  38  1.13  35
  6.- Necaxa             34  10  11  13  44  39  1.13  31
  7.- Irapuato           34   8  13  13  34  53  0.64  29
  8.- Laguna             34  10   8  16  37  47  0.79  28
  9.- Atlas              34   5  12  17  32  48  0.67  22  Relegation Playoff
 
Group Pirates:            P   W   T   L  GF  GA  GAVG PTS
  1.- América            34  17  10   7  56  33  1.70  44  Championship Playoff
  2.- Monterrey          34  15  10   9  46  37  1.24  40
  3.- León               34  14  10  10  50  41  1.22  38
  4.- Atlante            34   9  16   9  33  31  1.06  34 
  5.- Veracruz           34  12   9  13  39  40  0.98  33
  6.- Puebla             34  11  10  13  43  49  0.88  32
  7.- Torreón            34  11   9  14  27  35  0.77  31
  8.- Guadalajara        34  11   8  15  34  44  0.77  30
  9.- Pachuca            34  11   7  16  38  46  0.83  29  Relegation Playoff

 
Championship Finals

First Leg         
Toluca               0 - 0 América 

Second Leg
América              2 - 0 Toluca 

Champions: América

Relegation Playoffs

First Leg
Atlas                2 - 2 Pachuca 

Second Leg
Pachuca              1 - 1 Atlas 

Third Match (in León)
Pachuca              2 - 0 Atlas
 
Relegated: Atlas
 
Promoted: San Luis
 
After this season Necaxa changed its name to Atletico Español and Cruz Azul
moved to Mexico City.


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

Last updated: 3 Apr 2009

(C) Copyright Fernando Castro and RSSSF 2003/09

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,282,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.5455
Total Execution Time  0.5490
  CADENA URL  
/apertura_mexico1971
  GET DATOS  
$_GET['/apertura_mexico1971']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0126  SELECT type FROM routes WHERE alias = 'apertura_mexico1971'
0.0257  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 = 1971 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0130  SELECT text_es as historical_text FROM leagues_text WHERE id=2017
0.0129  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 = 30279 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0133  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='1971' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0148  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:15:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:15:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:15:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:15:35' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  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 = 1971 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1971 e WHERE e.league_id IN (30279) 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.0125  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 (30279) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1971 e WHERE e.league_id IN (30279) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30279) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  SELECT e.action, count(e.action) as total, e.player_id FROM events1971 e WHERE e.league_id IN (30279) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30279) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1971 e WHERE e.league_id IN (30279) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0125  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 (30279) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0126  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 = 30279 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0125  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 = 30279 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0128  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=30279 AND rel.round=34
0.0128  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 = 30279 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0128  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 = 30279 AND esl.points > 0
0.0128  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` = 30279 ORDER BY creation_date DESC LIMIT 0, 10
0.0171  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` = 30279
0.0139  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 `calendars1971` 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` = 30279 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0127  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 `events1971` e INNER JOIN calendars1971 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 = 34 AND e.real_date IS NOT NULL AND e.league_id = 30279 ORDER BY total DESC LIMIT 40
0.0132  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 `events1971` e INNER JOIN calendars1971 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 = 30279 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0130  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 `tables1971` 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 = 30279 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1971` 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 = 30279 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 30279 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0130  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0130  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1971 ORDER BY l.group_code ASC
0.0130  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1971