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

Liga MX - Apertura 1972

Información Histórica 
						

Group A                   P   W   T   L  GF  GA  GAVG PTS
  1.- Cruz Azul          34  22   7   5  65  36  1.81  51  Championship Playoff
  2.- América            34  20   8   6  70  35  2.00  48  Championship Playoff
  3.- Jalisco            34  15   9  10  57  48  1.19  39
  4.- León               34  12  11  11  76  58  1.31  35
  5.- Zacatepec          34  11  12  11  34  36  0.94  34
  6.- Laguna             34   9  15  10  34  34  1.00  33
  7.- San Luis           34  11  10  13  37  47  0.79  32
  8.- Veracruz           34   8  13  13  40  51  0.78  29  Relegation Playoff
  9.- Atlético Español   34   8   8  18  48  72  0.67  24  Relegation Playoff

Group B                   P   W   T   L  GF  GA  GAVG PTS
  1.- Monterrey          34  14  12   8  41  37  1.11  40  Championship Playoff
  2.- Guadalajara        34  14  11   9  37  33  1.12  39  Championship Playoff
  3.- Puebla             34  13   9  12  47  42  1.12  35
  3.- Atlante            34  13   9  12  30  28  1.07  35
  5.- Pachuca            34  10  13  11  38  46  0.83  33
  6.- U.N.A.M.           34  11   9  14  36  38  0.95  31
  6.- Toluca             34  11   9  14  46  51  0.90  31
  8.- Torreón            34   8  11  15  35  55  0.64  27  Relegation Playoff
  9.- Irapuato           34   2  12  20  26  50  0.52  16  Relegation Playoff
 
Round 1                                      
León                 1 - 1 Puebla              
Jalisco              2 - 1 Cruz Azul           
Veracruz             0 - 0 A.Pachuca           
Atlante              2 - 0 Torreón             
Toluca               3 - 2 A.Español           
Laguna               0 - 0 U.N.A.M.            
América              6 - 1 San Luis            
Monterrey            2 - 0 Guadalajara         
Irapuato             0 - 0 Zacatepec           
                                               
Round 2                                        
A.Español            0 - 5 León                
Torreón              1 - 1 Jalisco             
U.N.A.M.             3 - 1 Veracruz            
Puebla               0 - 0 Atlante             
San Luis             0 - 2 Toluca              
Guadalajara          1 - 0 Laguna              
Zacatepec            0 - 0 América             
Cruz Azul            1 - 3 Monterrey           
A.Pachuca            1 - 0 Irapuato            
                                               
Round 3                                        
Atlante              0 - 1 A.Español           
Monterrey            1 - 0 Torreón             
Irapuato             0 - 1 U.N.A.M.            
Jalisco              3 - 1 Puebla              
León                 3 - 1 San Luis            
Veracruz             2 - 2 Guadalajara         
América              5 - 1 Toluca              
Laguna               1 - 1 Cruz Azul           
Zacatepec            2 - 0 A.Pachuca           
                                               
Round 4                                        
San Luis             4 - 0 Atlante             
Puebla               0 - 0 Monterrey           
Guadalajara          2 - 0 Irapuato            
A.Español            1 - 1 Jalisco             
Toluca               0 - 0 León                
Cruz Azul            1 - 0 Veracruz            
A.Pachuca            0 - 3 América             
Torreón              0 - 2 Laguna              
U.N.A.M.             1 - 0 Zacatepec           
                                               
Round 5                                        
Jalisco              0 - 1 San Luis            
Laguna               1 - 0 Puebla              
Zacatepec            1 - 1 Guadalajara         
Monterrey            1 - 0 A.Español           
Atlante              2 - 1 Toluca              
Irapuato             2 - 3 Cruz Azul           
América              3 - 1 León                
Veracruz             3 - 2 Torreón             
A.Pachuca            0 - 0 U.N.A.M.            
                                               
Round 6                                        
Toluca               2 - 1 Jalisco             
A.Español            3 - 1 Laguna              
Cruz Azul            3 - 0 Zacatepec           
San Luis             2 - 0 Monterrey           
León                 3 - 1 Atlante             
Torreón              2 - 0 Irapuato            
U.N.A.M.             0 - 1 América             
Puebla               4 - 2 Veracruz            
Guadalajara          2 - 2 A.Pachuca           
                                               
Round 7                                        
Monterrey            1 - 0 Toluca              
Veracruz             1 - 2 A.Español           
A.Pachuca            0 - 0 Cruz Azul           
Laguna               1 - 1 San Luis            
Jalisco              2 - 3 León                
Zacatepec            1 - 1 Torreón             
América              0 - 0 Atlante             
Irapuato             3 - 1 Puebla              
U.N.A.M.             0 - 1 Guadalajara         
                                               
Round 8                                        
León                 5 - 2 Monterrey           
San Luis             0 - 0 Veracruz            
Torreón              1 - 1 A.Pachuca           
Toluca               2 - 2 Laguna              
Atlante              2 - 0 Jalisco             
Puebla               2 - 0 Zacatepec           
Guadalajara          1 - 3 América             
A.Español            0 - 0 Irapuato            
Cruz Azul            1 - 0 U.N.A.M.            
                                               
Round 9                                        
Laguna               1 - 1 León                
Irapuato             2 - 3 San Luis            
U.N.A.M.             0 - 1 Torreón             
Veracruz             1 - 1 Toluca              
Monterrey            1 - 0 Atlante             
A.Pachuca            0 - 1 Puebla              
América              3 - 0 Jalisco             
Zacatepec            2 - 1 A.Español           
Guadalajara          0 - 2 Cruz Azul           
                                               
Round 10                                       
Atlante              1 - 0 Laguna              
Toluca               1 - 0 Irapuato            
Puebla               0 - 3 U.N.A.M.            
León                 3 - 0 Veracruz            
Jalisco              1 - 1 Monterrey           
A.Español            1 - 3 A.Pachuca           
Cruz Azul            2 - 1 América             
San Luis             1 - 1 Zacatepec           
Torreón              2 - 1 Guadalajara         
                                               
Round 11                                       
Veracruz             2 - 2 Atlante             
Zacatepec            2 - 1 Toluca              
Guadalajara          0 - 0 Puebla              
Irapuato             1 - 1 León                
Laguna               1 - 2 Jalisco             
U.N.A.M.             3 - 1 A.Español           
América              2 - 0 Monterrey           
A.Pachuca            0 - 2 San Luis            
Cruz Azul            3 - 1 Torreón             
                                               
Round 12                                       
Jalisco              1 - 0 Veracruz            
León                 2 - 2 Zacatepec           
A.Español            0 - 1 Guadalajara         
Atlante              1 - 0 Irapuato            
Monterrey            1 - 1 Laguna              
San Luis             0 - 0 U.N.A.M.            
Torreón              0 - 1 América             
Toluca               1 - 3 A.Pachuca           
Puebla               1 - 2 Cruz Azul           
                                               
Round 13                                        
Irapuato             1 - 1 Jalisco             
A.Pachuca            2 - 0 León                
Cruz Azul            2 - 0 A.Español           
Zacatepec            0 - 0 Atlante             
Veracruz             2 - 3 Monterrey           
Guadalajara          0 - 0 San Luis            
América              2 - 0 Laguna              
U.N.A.M.             2 - 2 Toluca              
Torreón              2 - 2 Puebla              
                                               
Round 14                                       
Monterrey            1 - 0 Irapuato            
Atlante              0 - 1 A.Pachuca           
San Luis             0 - 3 Cruz Azul           
Jalisco              3 - 0 Zacatepec           
Laguna               0 - 2 Veracruz            
Toluca               1 - 2 Guadalajara         
Puebla               3 - 0 América             
León                 3 - 1 U.N.A.M.            
A.Español            4 - 0 Torreón             
                                               
Round 15                                       
Zacatepec            2 - 0 Monterrey           
U.N.A.M.             0 - 2 Atlante             
Torreón              0 - 2 San Luis            
A.Pachuca            1 - 1 Jalisco             
Irapuato             0 - 2 Laguna              
Cruz Azul            1 - 0 Toluca              
América              3 - 0 Veracruz            
Guadalajara          1 - 0 León                
Puebla               1 - 2 A.Español           
                                               
Round 16                                       
San Luis             1 - 0 Puebla              
León                 0 - 3 Cruz Azul           
Atlante              0 - 1 Guadalajara         
Monterrey            1 - 1 A.Pachuca           
A.Español            1 - 2 América             
Jalisco              3 - 1 U.N.A.M.            
Toluca               2 - 0 Torreón             
Veracruz             0 - 0 Irapuato            
Laguna               0 - 1 Zacatepec           
                                               
Round 17                                       
A.Español            2 - 1 San Luis            
Cruz Azul            2 - 1 Atlante             
U.N.A.M.             2 - 1 Monterrey           
Guadalajara          0 - 0 Jalisco             
Irapuato             1 - 3 América             
A.Pachuca            2 - 1 Laguna              
Puebla               3 - 1 Toluca              
Zacatepec            0 - 0 Veracruz            
Torreón              2 - 1 León                
                                               
Round 18                                       
U.N.A.M.             0 - 0 Laguna              
Cruz Azul            2 - 2 Jalisco             
A.Español            1 - 2 Toluca              
Guadalajara          0 - 0 Monterrey           
A.Pachuca            2 - 0 Veracruz            
Puebla               3 - 1 León                
Zacatepec            2 - 1 Irapuato            
Torreón              2 - 1 Atlante             
San Luis             2 - 1 América             
                                               
Round 19                                       
Atlante              2 - 0 Puebla              
América              1 - 1 Zacatepec           
Jalisco              1 - 0 Torreón             
León                 5 - 1 A.Español           
Toluca               1 - 1 San Luis            
Irapuato             1 - 1 A.Pachuca           
Monterrey            3 - 0 Cruz Azul           
Veracruz             1 - 0 U.N.A.M.            
Laguna               2 - 0 Guadalajara         
                                               
Round 20                                        
Guadalajara          1 - 0 Veracruz            
Torreón              1 - 1 Monterrey           
San Luis             0 - 1 León                
Cruz Azul            1 - 1 Laguna              
U.N.A.M.             1 - 0 Irapuato            
A.Español            0 - 1 Atlante             
A.Pachuca            0 - 2 Zacatepec           
Puebla               1 - 1 Jalisco             
Toluca               1 - 2 América             
                                               
Round 21                                       
Irapuato             0 - 0 Guadalajara         
Laguna               1 - 0 Torreón             
Atlante              2 - 0 San Luis            
Veracruz             1 - 3 Cruz Azul           
Zacatepec            1 - 0 U.N.A.M.            
Jalisco              3 - 0 A.Español           
América              4 - 1 A.Pachuca           
Monterrey            0 - 0 Puebla              
León                 4 - 1 Toluca              
                                               
Round 22                                       
Cruz Azul            2 - 0 Irapuato            
Puebla               1 - 1 Laguna              
Toluca               1 - 0 Atlante             
Torreón              2 - 0 Veracruz            
Guadalajara          2 - 0 Zacatepec           
San Luis             0 - 1 Jalisco             
U.N.A.M.             1 - 1 A.Pachuca           
A.Español            2 - 3 Monterrey           
León                 2 - 2 América             
                                               
Round 23                                       
Zacatepec            0 - 2 Cruz Azul           
Veracruz             1 - 1 Puebla              
Jalisco              2 - 1 Toluca              
Irapuato             0 - 0 Torreón             
A.Pachuca            1 - 2 Guadalajara         
Monterrey            3 - 1 San Luis            
América              0 - 1 U.N.A.M.            
Laguna               3 - 4 A.Español           
Atlante              1 - 1 León                
                                               
Round 24                                       
Torreón              0 - 0 Zacatepec           
A.Español            0 - 2 Veracruz            
León                 3 - 7 Jalisco             
Puebla               2 - 1 Irapuato            
Cruz Azul            3 - 1 A.Pachuca           
Toluca               4 - 0 Monterrey           
Guadalajara          2 - 1 U.N.A.M.            
San Luis             1 - 1 Laguna              
Atlante              1 - 2 América             
                                               
Round 25                                       
A.Pachuca            2 - 1 Torreón             
Irapuato             4 - 4 A.Español           
Monterrey            1 - 1 León                
Zacatepec            1 - 2 Puebla              
U.N.A.M.             1 - 3 Cruz Azul           
Laguna               1 - 1 Toluca              
América              2 - 0 Guadalajara         
Veracruz             4 - 2 San Luis            
Jalisco              2 - 1 Atlante             
                                               
Round 26                                       
Puebla               2 - 1 A.Pachuca           
San Luis             1 - 0 Irapuato            
Atlante              1 - 0 Monterrey           
A.Español            0 - 4 Zacatepec           
Torreón              0 - 0 U.N.A.M.            
León                 0 - 1 Laguna              
Cruz Azul            3 - 1 Guadalajara         
Toluca               5 - 2 Veracruz            
Jalisco              4 - 3 América             
                                               
Round 27                                       
U.N.A.M.             3 - 2 Puebla              
Zacatepec            0 - 0 San Luis            
Laguna               0 - 0 Atlante             
A.Pachuca            1 - 1 A.Español           
Guadalajara          0 - 1 Torreón             
Veracruz             1 - 1 León                
América              2 - 2 Cruz Azul           
Irapuato             2 - 2 Toluca              
Monterrey            4 - 3 Jalisco             
                                               
Round 28                                       
A.Español            3 - 1 U.N.A.M.            
Toluca               2 - 0 Zacatepec           
Jalisco              0 - 1 Laguna              
San Luis             1 - 2 A.Pachuca           
Puebla               1 - 0 Guadalajara         
Atlante              0 - 0 Veracruz            
Torreón              5 - 2 Cruz Azul           
León                 2 - 5 Irapuato            
Monterrey            0 - 1 América             
                                               
Round 29                                       
Guadalajara          5 - 3 A.Español           
A.Pachuca            3 - 0 Toluca              
Veracruz             4 - 2 Jalisco             
U.N.A.M.             4 - 1 San Luis            
Cruz Azul            3 - 2 Puebla              
Irapuato             0 - 0 Atlante             
América              0 - 0 Torreón             
Zacatepec            2 - 1 León                
Laguna               1 - 1 Monterrey           
                                               
Round 30                                       
San Luis             1 - 1 Guadalajara         
León                 6 - 1 A.Pachuca           
Monterrey            1 - 1 Veracruz            
Toluca               0 - 0 U.N.A.M.            
A.Español            1 - 1 Cruz Azul           
Jalisco              2 - 0 Irapuato            
Puebla               4 - 1 Torreón             
Atlante              2 - 1 Zacatepec           
Laguna               1 - 1 América             
                                               
Round 31                                       
Cruz Azul            3 - 1 San Luis            
U.N.A.M.             4 - 3 León                
Irapuato             0 - 2 Monterrey           
Guadalajara          3 - 1 Toluca              
Torreón              3 - 3 A.Español           
Zacatepec            3 - 1 Jalisco             
América              3 - 1 Puebla              
A.Pachuca            0 - 2 Atlante             
Veracruz             2 - 0 Laguna              
                                               
Round 32                                         
Toluca               2 - 1 Cruz Azul           
Atlante              1 - 0 U.N.A.M.            
Laguna               2 - 0 Irapuato            
León                 1 - 1 Guadalajara         
San Luis             1 - 0 Torreón             
Monterrey            1 - 0 Zacatepec           
A.Español            0 - 3 Puebla              
Jalisco              2 - 2 A.Pachuca           
Veracruz             3 - 2 América             
                                               
Round 33                                       
Torreón              1 - 1 Toluca              
Guadalajara          1 - 1 Atlante             
Zacatepec            1 - 3 Laguna              
Cruz Azul            1 - 1 León                
Puebla               1 - 2 San Luis            
A.Pachuca            1 - 1 Monterrey           
América              2 - 2 A.Español           
U.N.A.M.             1 - 2 Jalisco             
Irapuato             0 - 0 Veracruz            
                                               
Round 34                                       
León                11 - 3 Torreón             
Jalisco              0 - 2 Guadalajara         
Veracruz             2 - 2 Zacatepec           
Atlante              0 - 2 Cruz Azul           
Toluca               0 - 1 Puebla              
Laguna               1 - 1 A.Pachuca           
San Luis             2 - 2 A.Español           
Monterrey            1 - 1 U.N.A.M.            
América              4 - 2 Irapuato            

Group A                   P   W   T   L  GF  GA  GAVG PTS
  1.- Cruz Azul          34  22   7   5  65  36  1.81  51  Championship Playoff
  2.- América            34  20   8   6  70  35  2.00  48  Championship Playoff
  3.- Jalisco            34  15   9  10  57  48  1.19  39
  4.- León               34  12  11  11  76  58  1.31  35
  5.- Zacatepec          34  11  12  11  34  36  0.94  34
  6.- Laguna             34   9  15  10  34  34  1.00  33
  7.- San Luis           34  11  10  13  37  47  0.79  32
  8.- Veracruz           34   8  13  13  40  51  0.78  29  Relegation Playoff
  9.- Atlético Español   34   8   8  18  48  72  0.67  24  Relegation Playoff

Group B                   P   W   T   L  GF  GA  GAVG PTS
  1.- Monterrey          34  14  12   8  41  37  1.11  40  Championship Playoff
  2.- Guadalajara        34  14  11   9  37  33  1.12  39  Championship Playoff
  3.- Puebla             34  13   9  12  47  42  1.12  35
  3.- Atlante            34  13   9  12  30  28  1.07  35
  5.- Pachuca            34  10  13  11  38  46  0.83  33
  6.- U.N.A.M.           34  11   9  14  36  38  0.95  31
  6.- Toluca             34  11   9  14  46  51  0.90  31
  8.- Torreón            34   8  11  15  35  55  0.64  27  Relegation Playoff
  9.- Irapuato           34   2  12  20  26  50  0.52  16  Relegation Playoff
 
Championship Playoff

Semifinals

First Legs
Cruz Azul            0 - 1 Guadalajara 
América              1 - 0 Monterrey

Second Legs
Guadalajara          0 - 2 Cruz Azul 
Monterrey            2 - 1 América    

Semifinal Decider (in León)
América              3 - 1 Monterrey 

Final (Estadio Azteca, Cdad. de México)
Cruz Azul            4 - 1 América 
 
Champion: Cruz Azul 

Relegation Playoffs

Semifinals

First Legs
Torreón              1 - 1 Atlético Español 
Veracruz             3 - 1 Irapuato 

Second Legs
Atlético Español     3 - 2 Torreón 
Irapuato             0 - 0 Veracruz 

Relegation Final (in Guadalajara)
Torreón              1 - 0 Irapuato 

Relegated: Irapuato



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

Last updated: 27 Mar 2004

(C) Copyright Fernando Castro and RSSSF 2003/04

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,325,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.5909
Total Execution Time  0.5929
  CADENA URL  
/apertura_mexico1972
  GET DATOS  
$_GET['/apertura_mexico1972']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0125  SELECT type FROM routes WHERE alias = 'apertura_mexico1972'
0.0254  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 = 1972 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0203  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.0128  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.0132  SELECT text_es as historical_text FROM leagues_text WHERE id=2015
0.0126  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 = 30277 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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='1972' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0125  SELECT type,rule FROM rules WHERE categoryId = 68 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 13:34:37' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 13:34:37' 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=4 AND last_update > '2024-04-27 13:34:37' 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 13:34:37' 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 = 1972 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0126  SELECT e.action, count(e.action) as total, e.player_id FROM events1972 e WHERE e.league_id IN (30277) 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 (30277) 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 events1972 e WHERE e.league_id IN (30277) 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 (30277) 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 events1972 e WHERE e.league_id IN (30277) 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 (30277) 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 events1972 e WHERE e.league_id IN (30277) 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 (30277) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0125  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 = 30277 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 = 30277 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=30277 AND rel.round=34
0.0127  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 = 30277 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0127  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 = 30277 AND esl.points > 0
0.0126  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` = 30277 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  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` = 30277
0.0127  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 `calendars1972` 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` = 30277 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0124  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 `events1972` e INNER JOIN calendars1972 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 = 30277 ORDER BY total DESC LIMIT 40
0.0127  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 `events1972` e INNER JOIN calendars1972 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 = 30277 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0126  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 `tables1972` 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 = 30277 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1972` 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 = 30277 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 30277 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0126  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0126  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1972 ORDER BY l.group_code ASC
0.0126  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1972