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

Liga MX - Apertura 1973

Información Histórica 
						

Tables:

Group 'Pirata Fuente'     P   W   T   L  GF  GA  GAVG PTS 
  1.- Cruz Azul          34  19   8   7  60  37  1.62  46  Championship Playoff
  2.- Atlético Español   34  12  12  10  43  43  1.00  36  Championship Playoff
  3.- U.N.A.M.           34  14   7  13  37  32  1.16  35
  4.- Puebla             34  12   9  13  46  46  1.00  33
  5.- Guadalajara        34  10  12  12  38  39  0.97  32
  5.- Monterrey          34  10  12  12  31  38  0.82  32
  5.- Veracruz           34  10  12  12  41  51  0.80  32
  8.- Zacatepec          34   8  12  14  41  50  0.82  28  Relegation Playoff
  9.- Pachuca            34   9   6  19  40  68  0.59  24  Relegation Playoff

Group 'Juan Carreño'      P   W   T   L  GF  GA  GAVG PTS
  1.- León               34  18   8   8  59  34  1.74  44  Championship Playoff
  1.- Atlas              34  18   8   8  63  38  1.66  44  Championship Playoff
  3.- América            34  13  16   5  52  33  1.58  42
  4.- Toluca             34  13  13   8  51  39  1.31  39
  5.- Atlante            34   9  14  11  40  47  0.85  32
  6.- Jalisco            34  12   7  15  45  57  0.79  31
  7.- San Luis           34   9  11  14  49  57  0.86  29
  8.- Torreón            34   9   9  16  37  54  0.69  27  Relegation Playoff
  9.- Laguna             34   8  10  16  36  46  0.78  26  Relegation Playoff

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

Group 'Pirata Fuente'     P   W   T   L  GF  GA  GAVG PTS 
  1.- Cruz Azul          34  19   8   7  60  37  1.62  46  Championship Playoff
  2.- Atlético Español   34  12  12  10  43  43  1.00  36  Championship Playoff
  3.- U.N.A.M.           34  14   7  13  37  32  1.16  35
  4.- Puebla             34  12   9  13  46  46  1.00  33
  5.- Guadalajara        34  10  12  12  38  39  0.97  32
  5.- Monterrey          34  10  12  12  31  38  0.82  32
  5.- Veracruz           34  10  12  12  41  51  0.80  32
  8.- Zacatepec          34   8  12  14  41  50  0.82  28  Relegation Playoff
  9.- Pachuca            34   9   6  19  40  68  0.59  24  Relegation Playoff

Group 'Juan Carreño'      P   W   T   L  GF  GA  GAVG PTS
  1.- León               34  18   8   8  59  34  1.74  44  Championship Playoff
  1.- Atlas              34  18   8   8  63  38  1.66  44  Championship Playoff
  3.- América            34  13  16   5  52  33  1.58  42
  4.- Toluca             34  13  13   8  51  39  1.31  39
  5.- Atlante            34   9  14  11  40  47  0.85  32
  6.- Jalisco            34  12   7  15  45  57  0.79  31
  7.- San Luis           34   9  11  14  49  57  0.86  29
  8.- Torreón            34   9   9  16  37  54  0.69  27  Relegation Playoff
  9.- Laguna             34   8  10  16  36  46  0.78  26  Relegation Playoff

Championship Playoff

Semifinals

First Legs
Atlas                2 - 3 Cruz Azul 
Atlético Español     0 - 0 León 

Second Legs
Cruz Azul            1 - 0 Atlas  
León                 3 - 3 Atlético Español 

Semifinal Decider (in Pachuca)
León                 1 - 1 Atlético Español   [aet, 4-5 pen]

Final

First Leg
León                 1 - 1 Cruz Azul 

Second Leg
Cruz Azul            0 - 0 León

Final Decider (in Puebla)
Cruz Azul            2 - 1 León               [aet]

Champions: Cruz Azul


Relegation Playoff

First Legs
Laguna               1 - 0 Zacatepec 
Torreón              0 - 0 Pachuca 

Second Legs 
Pachuca              1 - 3 Torreón 
Zacatepec            1 - 0 Laguna

Semifinal Decider (in Guadalajara)
Laguna               3 - 0 Zacatepec 

Relegation Final
Pachuca              0 - 0 Zacatepec 

Relegation Final Replay
Pachuca              0 - 1 Zacatepec

Relegated: Pachuca



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,284,520 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0032
Controller Execution Time ( Home / Category )  0.1175
Total Execution Time  0.1207
  CADENA URL  
/apertura_mexico1973
  GET DATOS  
$_GET['/apertura_mexico1973']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0019  SELECT type FROM routes WHERE alias = 'apertura_mexico1973'
0.0040  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 = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0098  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.0020  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.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=2014
0.0019  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 = 30276 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='1973' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:00:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 22:00:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 22:00:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 22:00:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'apertura_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1973 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (30276) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30276) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (30276) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0018  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30276) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (30276) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0020  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 (30276) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1973 e WHERE e.league_id IN (30276) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (30276) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  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 = 30276 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 30276 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0021  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=30276 AND rel.round=34
0.0020  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 = 30276 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 30276 AND esl.points > 0
0.0028  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` = 30276 ORDER BY creation_date DESC LIMIT 0, 10
0.0023  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` = 30276
0.0025  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 `calendars1973` 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` = 30276 AND c.`round` = 34 ORDER BY shedule ASC LIMIT 200
0.0042  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 `events1973` e INNER JOIN calendars1973 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 = 30276 ORDER BY total DESC LIMIT 40
0.0022  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 `events1973` e INNER JOIN calendars1973 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 = 30276 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0025  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 `tables1973` 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 = 30276 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1973` 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 = 30276 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30276 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0025  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0025  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1973 ORDER BY l.group_code ASC
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1973