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

Liga MX - Apertura 1951

Información Histórica 
						
Regular Season

Round 1
[Sep 24]
América 3 Tampico 4
  [Salvador Farfán 59, Joaquín Fernández 70, José Luis Lamadrid 81; Ángel Gilardoni 37, 
   Guillermo Flores 60, Juan José Quiroga 74, 89]
Guadalajara 0 Necaxa 0
Puebla 1 Atlas 1
  [Walter Meneses 54; Edwin Cubero 68]
Veracruz 2 Oro 0
  [Daniel Muñoz 14, Rufino Lecca 76]
León 2 Marte 1
  [Arturo Orozco 35, Julián Durán 40; Mario Ochoa]
posponed match
Atlante - San Sebastián -

Round 2
[Sep 28]
Necaxa 1 Atlante 4
  [Carlos Guevara 22; Leopoldo Escandón 55, Carlos Septién 61, Luis Fernández 17, 
   Guillermo García Vélez 89]
Oro 3 América 1
  [Rodrigo Solano 51, Luis Acosta 74, José Francisco Rivas 83; Joaquín Fernández 85]
[Oct 1]
Tampico 2 Guadalajara 1
  [Felipe Altube 16, Ángel Gilardoni 85; Fernando Figueroa 23]
San Sebastián 1 Puebla 2
  [Antonio Ruiz Pizano 70; Manuel Martínez 61, Walter Meneses 80]
Atlas 0 León 0
Marte 2 Veracruz 2
  [Enrique Pradere 40, Enrique Sesma 44; Goro Ortiz 42, Luis de la Fuente 82]

Round 3
[Oct 5]
América 0 Guadalajara 2
  [Jesús Ponce 59, Felipe Martín del Campo 85]
[Oct 7]
Oro 3 Marte 2
  [Luis Acosta 33, 51, Rodrigo Solano 81; Luis Vázquez 49, Narciso López 77og]
[Oct 8]
Puebla 0 Necaxa 4
  [Pérez 30, Horacio Casarín 35, 50, 70]
Atlante 1 Tampico 0
  [Guillermo García Vélez 70]
León 2 San Sebastián 2
  [Enrique González López 42, Alfredo Costa 87; Antonio Ruiz Pizano 1, José Ramírez 70]
Veracruz 2 Atlas 4
  [Ricardo Álvarez 47, 88; Edwin Cubero 9, 40, José Mercado 14, Antonio Flores 75]

Round 4
[Oct 12]
Marte 3 América 1
  [Enrique Llorente 4og, Mario Pérez 12, 30; José Luis Borbolla 40pen]
Guadalajara 3 Atlante 2
  [Felipe Martín del Campo 4, 38, Raúl Cárdenas 88; Guillermo García Vélez 34, 
   Leopoldo Escandón 62]
[Oct 15]
San Sebastián 3 Veracruz 2
  [José Solórzano 22, 71, Carlos Chavira García 89pen; Luis de la Fuente 36, Ricardo Álvarez 70]
Necaxa 1 León 4
  [Horacio Casarín 66pen; Julio Ayllón 14, 39, Luis Luna 37, 82]
Atlas 3 Oro 0
  [Adalberto López 33, 62, Edwin Cubero 55]
Tampico 1 Puebla 0
  [Juan José Quiroga 76]

Round 5
[Oct 19]
Marte 3 Atlas 1
  [Sabino Morales 4, Enrique Pradere 11, Enrique Sesma 79; Edwin Cubero 89pen]
[Oct 22]
Veracruz 2 Necaxa 3
  [Luis de la Fuente 45pen, Daniel Muñoz 52; Horacio Casarín 20, 84pen, Carlos Guevara 41]
América 3 Atlante 3
  [Pedro Maupomé 4, 24, Mario Sánchez 62; Thelmo García 10, Guillermo García Vélez 58, 
   Alberto Mendoza 72]
León 2 Tampico 0
  [Luis Luna 9, Arturo Orozco 60]
Oro 1 San Sebastián 0
  [Jorge Arroyo 43]
Puebla 1 Guadalajara 1
  [Juan Castillo 48pen; Raúl Cárdenas 7]

Round 6
[Oct 26]
Atlante 2 Puebla 4
  [Guillermo García Vélez 64, Alberto Mendoza 71; Walter Meneses 1, 47, 59, Manuel Martínez 87]
Atlas 1 América 1
  [Juan José Novo 10; José Luis Lamadrid 40]
[Oct 29]
Marte 3 San Sebastián 1
  [José Cázares 10, Enrique Sesma 32, Enrique Pradere 62; Antonio Ruiz Pizano 48]
León 1 Guadalajara 1
  [Enrique González López 59; Rodrigo Noriega 26]
Tampico 0 Veracruz 1
  [Daniel Muñoz 42]
Oro 2 Necaxa 1
  [José Naranjo 42, José Francisco Rivas 78; Horacio Casarín 15]

Round 7
[Nov 2]
Necaxa 2 Marte 0
  [Francisco Hernández 10, Pedro Arnauda 49]
Atlas 4 San Sebastián 1
  [Edwin Cubero 65, José Mercado 70, Antonio Flores 73, Adalberto López 84pen; Aceves 57pen]
[Nov 5]
León 2 Atlante 2
  [Julio Ayllón 15, Enrique González López 75; Luis Fernández 25, Carlos Septién 80pen]
América 1 Puebla 0
  [José Luis Borbolla 34]
Oro 0 Tampico 3
  [Juan José Quiroga 17, 75, Felipe Altube 87]
Veracruz 2 Guadalajara 1
  [Ricardo Álvarez 44, 50; Ángel Vázquez 65]

Round 8
[Nov 9]
Necaxa 1 Atlas 1
  [Francisco Hernández 83; Juan José Novo 11]
[Nov 12]
Atlante 1 Veracruz 1
  [Norberto Rozas 18; Gisleno Medina 58og]
Puebla 1 León 3
  [Walter Meneses 85; Luis Luna 20, Julio Ayllón 55, 64]
Guadalajara 3 Oro 2
  [Tomás Balcázar 48, Javier de la Torre 70, Rodrigo Noriega 89; Santiago Piola Mendoza 13, 
   Luis Acosta 68]
San Sebastián 1 América 1
  [Manuel Cañibe 68og; José Luis Borbolla 83]
Tampico 2 Marte 1
  [Arnulfo Avilán 15, Felipe Altube 82; Enrique Pradere 87]

Round 9
[Nov 16]
Guadalajara 4 Marte 2
  [Tomás Balcázar 1, 9, Rodrigo Noriega 3, Raúl Cárdenas 23; Sabino Morales 34, Mario Pérez 65]
América 1 León 2
  [José Luis Borbolla 8; Sergio Bravo 48, Julio Ayllón 78]
[Nov 19]
Atlas 4 Tampico 1
  [Adalberto López 34, 43, 69, 87; Felipe Altube 59]
San Sebastián 0 Necaxa 2
  [Carlos Guevara 30, Pérez 87]
Veracruz 3 Puebla 1
  [Daniel Muñoz 28, Luis de la Fuente 39pen, Nicolás Téllez 54; Rodolfo Torres Ruiz 35]
Posponed match
Atlante – Oro –

Round 10
[Nov 23]
Atlante 5 Marte 0
  [Leopoldo Escandón 33, 58, Norberto Rozas 48, Carlos Septién 76, Guillermo García Vélez 89]
[Nov 26]
Guadalajara 0 Atlas 4
  [José Mercado 17, 47, 71, Adalberto López 62]
Tampico 2 San Sebastián 0
  [Aurelio Romero 18og, Guillermo Flores 84]
Puebla 4 Oro 3
  [Rodolfo Torres Ruiz 20, Hernán Cabalceta 35, 36, 52; Maximiano Prieto 50, 70, José Naranjo 53]
Necaxa 2 América 1
  [Horacio Casarín 50, 73; Mario Sánchez 83]
León 2 Veracruz 0
  [Arturo Orozco 19, 22]

Round 11
[Nov 30]
Necaxa 1 Tampico 0
  [La Fuente 82]
Atlas 0 Atlante 2
  [Leopoldo Escandón 47, 61]
[Dec 3]
Marte 1 Puebla 4
  [Mario Ochoa; Manuel Martínez 47, Walter Meneses 51, Roberto Zárate 66, Diego Guerrero 84]
Oro 4 León 1
  [José Francisco Rivas 17, 73, Enrique Escareño 25pen, Rodrigo Solano 52; Arturo Orozco]
Veracruz 2 América 0
  [Nicolás Téllez 22, Luis de la Fuente 63]
San Sebastián 2 Guadalajara 2
  [José Ramírez 60, 89; Javier de la Torre 1, Felipe Martín del Campo 3]
 
Pending match round 1
[Dec 7]
Atlante 1 San Sebastián 0
  [Leopoldo Escandón 32]

Pending match round 9
[Dec 17]
Atlante 0 Oro 1
  [Maximiano Prieto 70]


Tournament suspended due to visit of CA Boca Juniors and CA San Lorenzo de Almagro (ARG) from Jan. 7 to Feb. 6


Round 12
[Feb 8]
Necaxa 2 Guadalajara 1
  [Horacio Casarín 40, 87; Ángel Vázquez 65]
Oro 4 Veracruz 1
  [José Francisco Rivas 24, Luis Acosta 30, Maximiano Prieto 74, 76; Honorio Arteaga 89] 
[Feb 11]
Atlas 4 Puebla 2
  [Antonio Flores 40, 45, Adalberto López, Edwin Cubero; Walter Meneses (2)]
Tampico 0 América 1
  [Salvador Farfán 66]
San Sebastián 2 Atlante 2
  [Torres 73, José Solórzano 80; Leopoldo Escandón 74, Guillermo García Vélez 76]
Marte 0 León 3
  [Julio Ayllón 15, Izaguirre 53og, José Luis Molina 62]

Round 13
[Feb 15]
Atlante 2 Necaxa 1
  [Carlos Septién 19, Luis Fernández 78; Horacio Casarín 24pen]
[Feb 18]
León 1 Atlas 2
  [Julio Ayllón 77; Juan José Novo 5, Edwin Cubero 70]
América 4 Oro 1
  [Javier Rico 21, 60, José Luis Lamadrid 54, 61; Rodrigo Solano 64]
Guadalajara 5 Tampico 1
  [Javier de la Torre 27, 74, Alfredo Bocanegra 58, Ángel Vázquez 78pen, Manuel Enciso 83; 
   Guillén 61]
Puebla 4 San Sebastián 3
  [Lucio Gómez 30, Manuel Martínez 51, 59, Walter Meneses 86; Luquín 10, José Agüeros 30, 46]
Veracruz 3 Marte 2
  [Daniel Muñoz 16, Luis Quiñónes 55, 86; Mario Pérez 58, Enrique Sesma 81]

Round 14
[Feb 22]
Guadalajara 0 América 0
Marte 4 Oro 0
  [Enrique Sesma 4, 6, Mario Pérez, Luis Vázquez 74] 
[Feb 25]
Necaxa 1 Puebla 2
  [Barberena 20; Walter Meneses 23, Lucio Gómez 40]
Tampico 1 Atlante 2
  [Felipe Altube 61; Thelmo García 79, Luis Fernández 84]
Atlas 3 Veracruz 0
  [Edwin Cubero 32, Adalberto López 68, 75]
San Sebastián 3 León 4
  [Antonio Ruiz Pizano 31, 62, 70pen; Arturo Orozco 5, Alfredo Costa 22, Luis Luna 56, 67]

Round 15
[Mar 1]
América 1 Marte 2
  [Mario Sánchez 28; Mario Pérez 47, Sabino Morales 55]
[Mar 4]
León 1 Necaxa 1
  [Julio Ayllón 22; Horacio Casarín 65]
Oro 2 Atlas 4
  [José Francisco Rivas 41, José Naranjo 87; Juan José Novo 3, Adalberto López 60, 63, 
   Edwin Cubero 80]
Puebla 2 Tampico 0
  [Cuadrado Sánchez 6og, Samuel Cuburu 59pen]
Veracruz 3 San Sebastián 0
  [Luis Quiñónez 40, 68, Aurelio Romero 86og]
Atlante 2 Guadalajara 0
  [Norberto Rozas 41, 86]

Round 16
[Mar 8]
Atlante 0 América 1
  [René Masson 66]
Atlas 2 Marte 0
  [Adalberto López 49, Felipe Velázquez 76]
[Mar 11]
Tampico 1 León 2
  [Felipe Altube 45; Julio Ayllón 42, Enrique González López 49]
Guadalajara 2 Puebla 0
  [Jesús Ponce 11, Tomás Balcázar 30]
San Sebastián 2 Oro 4
  [José Agüeros 32, Torres 83; José Naranjo 15, 25, Maximiano Prieto 35, José Francisco Rivas 45]
Necaxa 4 Veracruz 2
  [Pedro Arnauda 50, 87, Carlos Guevara 72, 79; Luis Quiñónez 47, 52]

Round 17
[Mar 15]
América 1 Atlas 1
  [René Masson 28; José Mercado 49]
[Mar 18]
Puebla 3 Atlante 1
  [Gonzalo Iturbe 45, Hernán Cabalceta 65, Rodolfo Torres Ruiz 80; Leonardo Navarro 30]
Veracruz 3 Tampico 1
  [Rufino Lecca 43, Luis Quiñonez 44, Mata 47; Juan José Quiroga 67]
San Sebastián 0 Marte 0
Guadalajara 2 León 2
  [Javier de la Torre 10, Jesús Ponce 42; Luis Leonel Bossa 40, Enrique González López 49]
Necaxa 2 Oro 1
  [Pedro Arnauda 68, Horacio Casarín 85; Rodrigo Solano 70]

Round 18
[Mar 29]
Marte 0 Necaxa 2
  [Osnaya 82, Horacio Casarín 87]
[Apr 1]
Atlante 1 León 0
  [Leopoldo Escandón 87]
San Sebastián 1 Atlas 1
  [Torres 14; Juan José Novo 59]
Puebla 2 América 2
  [Walter Meneses 6, Alberto Mendoza 50; Mario Sánchez 30, José Luis Lamadrid 76]
Tampico 6 Oro 1
  [Guillermo Flores 8, Ernesto Candia 20, 61pen, 68, Ángel Gilardoni 30, Edgar Murillo 85; 
   Maximiano Prieto 14]
Guadalajara 7 Veracruz 3
  [Javier de la Torre 7, Jesús Ponce 11, 65, 68, 74, Rodrigo Noriega 18, 56; Luis Quiñónez 59, 79, 
   Jesús Segovia 90]

Round 19
[Apr 5]
Atlas 1 Necaxa 0
  [Juan José Novo 68]
América 0 San Sebastián 3
  [Florencio Caffaratti 2, Torres 23, Augusto Arrasco 65]
[Apr 8]
Marte 2 Tampico 2
  [Héctor Ortiz pen, Luis Vázquez 46; Ángel Gilardoni, Juan José Quiroga 60] 
León 4 Puebla 0
  [Enrique González López 25, Luis Luna 40, 84, Julio Ayllón 57]
Veracruz 1 Atlante 1
  [Mata; Luis Fernández]
Oro 1 Guadalajara 2
  [Gregorio Gómez 59og; Tomás Balcázar 51, Javier de la Torre 75pen]

Round 20
[Apr 12]
Marte 2 Guadalajara 2
  [Gregorio Gómez 22og, Enrique Sesma 43; Tomás Balcázar 36, 63]
[Apr 15]
Tampico 2 Atlas 1
  [Edgar Murillo 15, Ernesto Candia 65; Edmundo Manzotti 57]
León 0 América 1
  [Manuel Cañizo 34]
Necaxa 1 San Sebastián 1
  [Carlos Guevara 85; ¿? 87]
Oro 2 Atlante 6
  [Maximiano Prieto 10, José Naranjo; Carlos Septién 4, Raúl de Alba 58, Luis Fernández (2), 
   Norberto Rozas, Leopoldo Escandón]
Puebla 4 Veracruz 3
  [Roberto Zárate 25, 82, Walter Meneses 27, Alberto Mendoza 55; Luis Quiñónez 33, 
   Grimaldo González 75, 86]

Round 21
[Apr 19]
Marte 0 Atlante 6
  [Leopoldo Escandón 33, Luis Fernández 35, Norberto Rozas 57, 66, Raúl de Alba 68, Carlos Septién 87]
Oro 3 Puebla 1
  [Maximiano Prieto 42, José Francisco Rivas 78, Jorge Arroyo 80; Rodolfo Torres Ruiz 44]
[Apr 22]
América 0 Necaxa 1
  [Horacio Casarín 49]
San Sebastián 1 Tampico 2
  [Luquín 65; Edgar Murillo 40, 75]
Veracruz 1 León 0
  [Grimaldo González 84]
Atlas 1 Guadalajara 0
  [Edwin Cubero 55pen]

Round 22
[Apr 26]
América 2 Veracruz 2
  [José Luis Lamadrid 26, Joaquín Fernández 30; Juan Paratore 13, Daniel Muñoz 25]
[Apr 28]
Guadalajara 3 San Sebastián 1
  [Jesús Ponce 41, Rodrigo Noriega 32, Javier de la Torre 74; Torres 30]
[Apr 29]
Puebla 0 Marte 3
  [Mario Pérez 30, Núñez 33, Enrique Sesma 75]
León 1 Oro 2
  [Julio Ayllón 65; Salvador Rivera 8, Maximiano Prieto 35]
Tampico 3 Necaxa 4
  [Enrique Carretero 42, Ernesto Candia 47, 49; Pedro Arnauda 24, Gutiérrez 30, 40, Horacio Casarín 75]
Atlante 2 Atlas 1
  [Raúl de Alba 28, Leopoldo Escandón; Juan José Novo 37]




FINAL TABLE
Atlas			22	12	6	4	44:23	+21	30 [Guadalajara] (champion)
Atlante			22	12	5	5	48:27	+21	29 [Mexico City]
Necaxa			22	12	4	6	37:28	 +9	28 [Mexico City]
León			22	10	6	6	39:27	+12	26 
Guadalajara		22	 9	7	6	42:33	 +9	25 
Veracruz		22	 9	4	9	41:45	 -4	22
Puebla			22	 9	3	10	38:47	 -9	21
Oro			22	10	0	12	40:53	-13	20 [Guadalajara]
Tampico			22	 9	1	12	34:38	 -4	19
América			22	 5	7	10	26:35	 -9	17 [Mexico City]
Marte			22	 6	4	12	33:48	-15	16 [Mexico City]
--------------------------------------------------------------------------
San Sebastián		22	 2	7	13	28:46	-18	11 [León]


Promoted: Zacatepec

Relegated: San Sebastián



Author: Erik Francisco Lugo
(eaglelugo@yahoo.com.mx)

Last updated: 2 Oct 2014

(C) Copyright Erik Francisco Lugo
and RSSSF 2014

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,260,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0023
Controller Execution Time ( Home / Category )  0.1168
Total Execution Time  0.1192
  CADENA URL  
/apertura_mexico1951
  GET DATOS  
$_GET['/apertura_mexico1951']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0018  SELECT type FROM routes WHERE alias = 'apertura_mexico1951'
0.0045  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 = 1951 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=2029
0.0049  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 = 30291 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0037  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='1951' 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 16:14:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:14:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:14:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:14:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  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 = 1951 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0028  SELECT e.action, count(e.action) as total, e.player_id FROM events1951 e WHERE e.league_id IN (30291) 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.0034  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 (30291) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1951 e WHERE e.league_id IN (30291) 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 (30291) 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 events1951 e WHERE e.league_id IN (30291) AND (e.action IN (3,4) ) 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 (30291) 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 events1951 e WHERE e.league_id IN (30291) 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 (30291) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30291 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 = 30291 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=30291 AND rel.round=22
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 = 30291 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019  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 = 30291 AND esl.points > 0
0.0020  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` = 30291 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 30291
0.0020  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 `calendars1951` 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` = 30291 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0018  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 `events1951` e INNER JOIN calendars1951 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 = 22 AND e.real_date IS NOT NULL AND e.league_id = 30291 ORDER BY total DESC LIMIT 40
0.0020  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 `events1951` e INNER JOIN calendars1951 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 = 30291 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0020  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 `tables1951` 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 = 30291 AND t.round = 20 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1951` 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 = 30291 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 30291 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1951 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1951