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

Liga MX - Apertura 1954

Información Histórica 
						

Regular Season

Round 1
[Aug 8]
Tampico 2 Marte 4
[Aug 9]
América 3 Atlas 1
  [Raúl Salamanca 14, Eduardo González Palmer 63, 83; Juan Gómez 67pen]
Puebla 1 Necaxa 4
  [Salvador Saucedo 73; Juan Ángel Pérez 15og, José Luis Lamadrid 53, 57, Jorge Molina 69]
Zacatepec 3 Oro 2
  [Mateo de la Tijera 20, 71, Ernesto Candia 65; José Naranjo 70, Juan José Copado 85]
Guadalajara 3 León 2
  [Tomás Balcázar 18, 36, Raúl Arellano 88; Agustín Santillán 83, Luis Leonel Bossa 89]
Toluca 2 Atlante 1
  [Carlos Carús 17, 37; Rafael Ávalos 82]

Round 2
[Aug 16]
Marte 1 América 1
  [Mario Ochoa 14pen; José Santiago 62]
Atlante 2 Guadalajara 1
  [Juárez 24, Solares; Gregorio Gómez 41pen]
Atlas 2 Puebla 2
  [Alfredo Torres 17, Rodolfo Franco 80; Edmundo Manzotti 53, Salvador Saucedo 65]
León 3 Zacatepec 0
  [Juan José Olivero 50, Agustín Santillán 60, Marcos Aurelio 84]
[Aug 19]
Oro 1 Tampico 1
  [Carlos Chavira García 7; Carlos Septién 38]
Necaxa 2 Toluca 1
  [Carlos Iturralde 9, 83; Carlos Carús 34]

Round 3
[Aug 23]
Zacatepec 1 Tampico 3
  [Francisco Hernández 54; José Vela og, José Luis Molina 19, Grimaldo González 83]
Toluca 2 Atlas 2
  [Higinio Palos 33, 62; Lorenzo Carrillo 28, Alfredo Torres 82]
América 3 Oro 0
  [José González 7, 72, José Santiago 83]
Guadalajara 3 Necaxa 2
  [Raúl Arellano 13, 53, Adalberto López 73; José Luis Lamadrid 43, Julio María Palleiro 80]
León 2 Atlante 0
  [Agustín Santillán 36, Marcos Aurelio 62]
Puebla 0 Marte 0

Round 4
[Aug 29]
Tampico 5 América 1
  [Carlos Septién 26, 30, Grimaldo González 55, Rufino Lecca 76, Nicolás Téllez 79; José Santiago 67pen]
[Aug 30]
Necaxa 0 León 2
  [Juan José Olivero 11, Agustín Santillán 83]
Oro 1 Puebla 3
  [Narciso López 32pen; José Francisco Rivas 53, Edmundo Manzotti 63, Edwin Cubero 87]
Marte 0 Toluca 2
  [Torres 15, 61]
[Sep 2]
Atlante 2 Zacatepec 0
  [Ricardo Escandón 51, Thelmo García 76pen]
Atlas 1 Guadalajara 1
  [Alfredo Torres 11; Adalberto López 62]

Round 5
[Sep 6]
Atlante 1 Necaxa 3
Guadalajara 0 Marte 1
  [Carlos Turcato 60]
León 4 Atlas 2
  [José Reyes Rodríguez 10, Juan José Olivero 16, 53, Marcos Aurelio 71; Alfredo Torres 61, José Mercado 75]
Puebla 0 Tampico 0
Zacatepec 2 América 3
  [Pedro Arnauda 47, Mateo de la Tijera 84; Sergio López 25, 60, Pedro Nájera 50]
Toluca 2 Oro 3
  [Carlos Lázcares 38, Rubén Malanchane 59; Arnulfo Cortés 13, 18, Juan José Copado 47]

Round 6
[Sep 12]
Tampico 1 Toluca 1
  [Julio Ayllón 35; Humberto Pérez 18pen]
[Sep 13]
América 1 Puebla 1
  [Sergio López 32; Raúl Cárdenas 18]
Atlas 1 Atlante 1
  [Alfredo Torres 15; Lucio Gómez 53]
Marte 2 León 1
  [Luis Luna 30og, Enrique Sesma 44; Agustín Santillán 24]
[Sep 15]
Oro 3 Guadalajara 4
  [José Naranjo, Juan Carlos Carrera ¿?, 75; Adalberto López 4, 12, Javier de la Torre 8, Raúl Arellano 60]
[Sep 16]
Necaxa 2 Zacatepec 4

Round 7
[Sep 20]
Necaxa 3 Atlas 2
  [Domingo de la Mora 14, Julio María Palleiro 36, ¿?; Leonardo Navarro 78, Alfredo Torres 83pen]
Guadalajara 7 Tampico 1
  [Javier de la Torre 15, Adalberto López 32, 52pen, 86, Rafael Rivera 35, Crescencio Gutiérrez 66, 89; 
   Julio Ayllón]
León 3 Oro 1
  [Agustín Santillán 49, 78, Juan José Olivero 68pen; José Naranjo]
Zacatepec 0 Puebla 2
  [Salvador Saucedo 1, Raúl Cárdenas 11]
Toluca 1 América 1
  [Humberto Pérez 71; Pedro Nájera 29]
[Sep 23]
Atlante 0 Marte 0

Round 8
[Sep 26]
Tampico 4 León 1
  [Grimaldo González 15, 35, Carlos Septién 40, Nicolás Téllez 55; Agustín Santillán 18]
[Sep 27]
América 0 Guadalajara 2
  [Adalberto López 68, 86]
Oro 4 Atlante 3
  [Juan Carlos Carrera 38, Arnulfo Cortés 41, 78, 89; Ligorio López 8, 33, Alcides Zamaro 75]
Puebla 3 Toluca 1
  [Mario Sánchez 44, 57, Ricardo Zárate 75; Humberto Pérez 89pen]
Marte 2 Necaxa 1
  [Carlos Turcato 5, Enrique González López 44; Julio María Palleiro 12pen]
[Sep 30]
Atlas 1 Zacatepec 2
  [Alfredo Torres 70; Francisco Hernández 20, Mateo de la Tijera 64]

Round 9
[Oct 4]
Atlante 1 Tampico 0
  [Moisés Jinich 39]
Guadalajara 4 Puebla 0
  [Adalberto López 18, 80, Raúl Arellano 44, 60]
León 5 América 0
  [Agustín Santillán 5, Juan José Olivero 27, 43, 52, 59]
Zacatepec 3 Toluca 4
  [Ernesto Candia 21, Horacio Casarín 25, Mateo de la Tijera 80; Carlos Lázcares 6, Carlos Carús 50, 
   Rubén Malanchane 72, 85]
[Oct 7]
Necaxa 2 Oro 3
  [Julio María Palleiro 62, 79pen; Arnulfo Cortés 27, 42, Luis Hermosillo 36]
*Atlas – Marte –
*Suspended by rain
[Oct 8]
Atlas 1 Marte 5
  [Ángel Vázquez 42; Mario Pérez 25, 28, 53, 77, Mario Ochoa 82]

Round 10
[Oct 10]
Tampico 4 Necaxa 0
  [Carlos Septién 7, Julio Ayllón 34, Grimaldo González 54, 70]
[Oct 11]
América 5 Atlante 2
  [José González 1, 19, Eduardo González Palmer 39, 89, José Buendía 84; Norberto Rozas 20, Alcides Zamaro 87]
Oro 1 Atlas 3
  [Juan Carlos Carrera 18; Sigfredo Mercado 19, Ángel Vázquez 26, Alfredo Torres 32]
Puebla 2 León 1
  [Edwin Cubero 46, Gonzalo Iturbe 54; Marcos Aurelio 87]
Zacatepec 0 Marte 2
  [Enrique González López 54, Mario Pérez 70]
Toluca 2 Guadalajara 2
  [Carlos Carús 25, Humberto Pérez 28pen; Juan Jasso 80, Raúl Arellano 85]

Round 11
[Oct 18]
Necaxa 1 América 1
  [José Luis Lamadrid 41; Eduardo González Palmer 59]
Atlas 2 Tampico 3
  [Ángel Vázquez 50, Sigfredo Mercado 52; Julio Ayllón 31, 55, Juan Lecca 66]
León 2 Toluca 0
  [Juan José Olivero 70, 89]
Marte 2 Oro 1
  [Mario Pérez 30, Enrique González López 53; Juan Carlos Carrera 60]
[Oct 21]
Atlante 4 Puebla 2
  [Thelmo García 3pen, Walter Meneses 17, Norberto Rozas 73, 80; Miguel Torra 20, Salvador Saucedo]
Guadalajara 1 Zacatepec 2
  [Adalberto López 28; Martínez 35, Mateo de la Tijera 60]

Round 12
[Oct 25]
Atlante 0 Toluca 0
Atlas 2 América 1
  [Ángel Vázquez 35, Rodolfo Franco 78; Eduardo González Palmer 7]
León 1 Guadalajara 3
  [Marcos Aurelio 33; Adalberto López 19, 72, Felipe Velázquez 30]
*Marte – Tampico –
*Suspended at 56' by storm, Tampico was winning 1-3
[Oct 26]
*Marte 3 Tampico 4
*33 minutes left were played
[Oct 27]
Oro 5 Zacatepec 1
  [Arnulfo Cortés 4, 63, Ricardo Torres 40, Juan Carlos Carrera 42, 65; Ernesto Candia 88]
[Oct 28]
Necaxa 0 Puebla 0

Round 13
[Oct 31]
Tampico 1 Oro 3
  [Carlos Septién 80pen; Juan Carlos Carrera 15, 24, Arnulfo Cortés]
[Nov 1]
América 2 Marte 1
  [Adolfo Lugo Verduzco 20, José Santiago 49; Mario Pérez 12]
Guadalajara 2 Atlante 2
  [Adalberto López 3, 37; Ligorio López 29, 40]
Puebla 0 Atlas 2
  [Rodolfo Franco 30, Alfredo Torres 87]
Zacatepec 2 León 1
  [Pedro Arnauda 24, Héctor Ortiz 80pen; Luis Luna 56pen]
Toluca 3 Necaxa 0
  [Humberto Pérez 17, Higinio Palos 35, Carlos Carús 80]

Round 14
[Nov 7]
Tampico 1 Zacatepec 2
  [Juan Lecca 30; Mateo de la Tijera 28, Pedro Arnauda 80]
[Nov 8]
Necaxa 0 Guadalajara 0
Oro 6 América 2
  [Juan Carlos Carrera 10pen, 36, Arnulfo Cortés 19, 53, Ignacio Aguilar Colio 59, 89; José González 20, 
   José Buendía 24]
Marte 1 Puebla 4
  [Carlos Turcato 24; José Francisco Rivas 40, 73pen, Raúl Cárdenas 46, 60]
[Nov 10]
Atlas 2 Toluca 0
  [Ángel Vázquez 15, Lorenzo Carrillo 78]
[Nov 11]
Atlante 0 León 1
  [Julián Briseño 36]

Round 15
[Nov 15]
América 3 Tampico 3
  [Eduardo González Palmer 29, José Buendía 43, Sergio López 63; Juan Lecca 25, Grimaldo González 66, 
   Nicolás Telléz 69]
Guadalajara 5 Atlas 1
  [Crescencio Gutiérrez 18, Adalberto López 30, 42, Felipe Velázquez 39, Gregorio Gómez 87; 
   Miguel de la Torre 57]
León 1 Necaxa 2
  [Mauro Franco 70; Julio María Palleiro 28, Raúl Varela 56og]
Puebla 4 Oro 2
  [Gonzalo Iturbe 20, Ricardo Zárate 29, Edmundo Manzotti 62, Mariano Fernández 64; Juan Carlos Carrera 15, 70]
Zacatepec 5 Atlante 1
Toluca 2 Marte 0
  [Carlos Carús 30, 79]

Round 16
[Nov 21]
Tampico 1 Puebla 1
  [Julio Ayllón 33; Salvador Saucedo 5]
[Nov 22]
Necaxa 3 Atlante 1
  [Julio María Palleiro 7, 15, José Luis Lamadrid 46; Salvador Arizmendi 89]
Atlas 1 León 0
  [Armando Maciel 47]
Marte 2 Guadalajara 1
  [Mario Pérez 50, Enrique Sesma 55; Crescencio Gutiérrez 90]
[Nov 24]
Oro 4 Toluca 1
  [Juan Carlos Carrera 2, 17, 33, Héctor Hernández 5; Carlos Lázcares 8]
[Nov 25]
América 4 Zacatepec 0
  [Gerardo Nava 54, José Santiago 57, Manuel Cañibe 74, Eduardo González Palmer 78pen]

Round 17
[Nov 29]
Atlante 1 Atlas 0
  [Alcides Zamaro 43]
Guadalajara 2 Oro 3
  [Juan Jasso 7pen, Salvador Reyes 72; Arnulfo Cortés 25, 57, Héctor Hernández 68]
León 0 Marte 2
  [Mario Ochoa 30, Enrique González López 85]
Puebla 2 América 2
  [Gonzalo Iturbe 1, Raúl Cárdenas 4; Sergio López 37, José Santiago 70]
Zacatepec 1 Necaxa 1
  [Ernesto Candia 60pen; Julio María Palleiro 34}
Toluca 2 Tampico 3
  [Carlos Carús 44, Humberto Pérez 72; Julio Ayllón 55, 64, Grimaldo González 66]

Round 18
[Dec 5]
Tampico 3 Guadalajara 2
  [Julio Ayllón (2), Juan Lecca; Tomás Balcázar 73, Crescencio Gutiérrez 86]
[Dec 6]
América 1 Toluca 2
  [José Santiago 82; Carlos Carús 42, 44]
Oro 4 León 0
  [Juan Carlos Carrera 11, 51pen, 80, Arnulfo Cortés 89]
Marte 2 Atlante 0
  [Mario Pérez, Enrique Sesma 86]
Puebla 1 Zacatepec 0
  [Mario Sánchez 12]
[Dec 8]
Atlas 5 Necaxa 2
  [Rodolfo Franco ¿?, 67, 75, Ángel Vázquez 38, Joaquín González 58; Julio María Palleiro 54, 87]


Tournament suspended due to visit of Independiente Santa Fe (COL) and Gremio (BRA) from Dec. 12, to Jan. 12, 1954
 

Round 19
[Jan 17]
Necaxa 3 Marte 1
  [Julio María Palleiro 36, 62, José Luis Lamadrid 60; Enrique Sesma]
Toluca 1 Puebla 1
  [Humberto Pérez 42; Miguel Torra 12]
Zacatepec 1 Atlas 0
  [Héctor Ortiz 90pen]
Guadalajara 1 América 0
  [Adalberto López 23]
León 3 Tampico 0
[Jan 20]
Atlante 1 Oro 2
  [Norberto Rozas 59; Constantino Perales 64pen, José Naranjo 81]

Round 20
[Jan 23]
Tampico 1 Atlante 2
  [Julio Ayllón; Walter Meneses 7, Norberto Rozas 84]
[Jan 24]
América 2 León 1
  [Raúl Varela 35og, Alberto López 86; Agustín Santillán 36]
Oro 2 Necaxa 0
  [Héctor Hernández 10, Juan Carlos Carrera 66]
Marte 0 Atlas 1
  [Ángel Vázquez 56]
Toluca 3 Zacatepec 1
  [Carlos Láscarez 7, 32, Rubén Pichardo 38; Mateo Nicolau 44]
Puebla 1 Guadalajara 0
  [Raúl Cárdenas 15]

Round 21
[Jan 31]
Atlante 3 América 0
  [Raúl de Alba 10, 86, Norberto Rozas 89]
Atlas 2 Oro 6
  [Ángel Vázquez 6, 62; José Naranjo 11, Constantino Perales 47, Héctor Hernández 56, Juan Carlos Carrera 63, 
   Ricardo Torres 80, Arnulfo Cortés 85]
León 1 Puebla 0
  [Leocadio 58]
Marte 1 Zacatepec 1
  [Carlos Turcato 49; Agustín Díaz 37]
[Feb 3]
Necaxa 5 Tampico 4
  [Julio María Palleiro 8pen, 17, 80, José Luis Lamadrid 44, 76; Rufino Lecca 14, Juan Lecca 36, 
   Carlos Septién ¿?pen, Julio Ayllón 87]
Guadalajara 1 Toluca 2
  [Adalberto López 16; Carlos Lázcares 39, Rubén Pichardo 56]

Round 22
[Feb 6]
Tampico 4 Atlas 0
  [José Luis Molina 49, Grimaldo González 70, Juan Lecca 85, 89]
[Feb 7]
América 1 Necaxa 3
  [Manuel Cañibe 29pen; Jaime Salazar 5, Julio María Palleiro 40, Jorge Molina 61] 
Oro 0 Marte 2
  [Enrique González López 2, Carlos Turcato 30]
Puebla 1 Atlante 1
  [Mariano Fernández 65; Walter Meneses 30]
Zacatepec 3 Guadalajara 1
  [Guillermo García Vélez 6, ¿?pen, Ernesto Candia 48; Adalberto López 56]
Toluca 1 León 1
  [Carlos Lázcares 53; Marcos Aurelio 40]

FINAL TABLE
Marte			22	11	4	 7	34:27	 +7	26 [Cuernavaca] (champion)
Oro			22	12	1	 9	57:45	+12	25 [Guadalajara]
Puebla			22	 8	9	 5	31:29	 +2	25
Tampico			22	 9	5	 8	49:45	 +4	23
Toluca			22	 8	7	 7	35:34	 +1	23
Guadalajara		22	 9	4	 9	46:34	+12	22
Necaxa			22	 9	4	 9	39:43	 -4	22 [Mexico City]
León			22	10	1	11	36:31	 +5	21
América			22	 7	6	 9	37:45	 -8	20 [Mexico City]
Zacatepec		22	 9	2	11	34:44	-10	20
Atlante			22	 7	5	10	29:37	 -8	19 [Mexico City]
--------------------------------------------------------------------------
Atlas			22	 7	4	11	34:47	-13	18 [Guadalajara] (relegated)


Promoted: Irapuato
Relegated: Atlas



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

Last updated: 14 Apr 2016

(C) Copyright Erik Francisco Lugo
and RSSSF 2015/16

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,259,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1134
Total Execution Time  0.1153
  CADENA URL  
/apertura_mexico1954
  GET DATOS  
$_GET['/apertura_mexico1954']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0019  SELECT type FROM routes WHERE alias = 'apertura_mexico1954'
0.0039  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 = 1954 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.0097  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.0021  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.0022  SELECT text_es as historical_text FROM leagues_text WHERE id=2024
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 = 30286 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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='1954' 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:09:59' 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=2 AND last_update > '2024-04-27 22:09:59' 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:09:59' 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 22:09:59' 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 = 1954 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 events1954 e WHERE e.league_id IN (30286) 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 (30286) 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 events1954 e WHERE e.league_id IN (30286) 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 (30286) 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 events1954 e WHERE e.league_id IN (30286) 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 (30286) 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 events1954 e WHERE e.league_id IN (30286) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0023  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 (30286) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  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 = 30286 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 = 30286 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0024  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=30286 AND rel.round=22
0.0019  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 = 30286 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0021  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 = 30286 AND esl.points > 0
0.0019  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` = 30286 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` = 30286
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 `calendars1954` 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` = 30286 AND c.`round` = 22 ORDER BY shedule ASC LIMIT 200
0.0017  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 `events1954` e INNER JOIN calendars1954 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 = 30286 ORDER BY total DESC LIMIT 40
0.0021  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 `events1954` e INNER JOIN calendars1954 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 = 30286 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 `tables1954` 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 = 30286 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 `tables1954` 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 = 30286 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-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 30286 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 = 1954 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1954