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

Liga MX - Apertura 1944

Información Histórica 
						

Regular Season

Round 1
[Oct 17, 1943]
España 2 Moctezuma 3
  [Isidro Lángara, Carlos Septién; Ernesto Candia 6, Luis Ponce, 
   Antonio Villegas]
Veracruz 3 Marte 3
  [José Miguel Díez, Félix de los Heros, Rafael Fernández Oroza; 
   Alberto Mendoza (2), Hernán Cabalceta]
ADO 1 América 6
  [Luis V. Aussín; Luis García Cortina 9, 39, Octavio Vial 18, 19, 
   Julio Orvañanos 40, Leopoldo Proal 76]
Atlas 2 Asturias 4
  [Agustín Medina 14, 52; José Menéndez 66, Ismael Zavaleta 76, 84pen,
   José Noguera 79
Bye: Atlante, Guadalajara

Round 2
[Oct 21]
Atlante 1 Guadalajara 4
  [Martín Vantolrá 52; Pablo González 13, 21, Luis Reyes 33, 
   Maximiliano Prieto 79]
[Oct 24]
Moctezuma 5 Veracruz 1
  [Antonio Villegas, Ernesto Candia (3), Honorio Arteaga; 
   Carlos Leblanc]
Asturias 4 América 2
  [José Noguera, Ismael Zavaleta, Salvador Arizméndi (2); 
   Julio Orvañanos 6, 62]
Bye: ADO, Atlas, España, Marte

Round 3
[Oct 28]
España 6 Atlas 2
  [José Iraragorri (2), Isidro Lángara (2), Carlos Septién, 
   Jorge Quezada; Agustín Medina, Guadalupe Velázquez]
[Oct 31]
Guadalajara 5 ADO 1
  [Luis Reyes 6, Maximiliano Prieto 19, 85, Manuel 'Cosas' López 60, 
   Pablo González 89; Antonio Toledo 87]
Atlante 0 Marte 0
Bye: América, Asturias, Moctezuma, Veracruz

Round 4
[Nov 4]
América 1 Moctezuma 0
  [Julio Orvañanos 43]
[Nov 7]
España 1 Asturias 2
  [José Iraragorri (pen); José Menéndez (2)]
Veracruz 1 Atlante 0
  [Félix de los Heros 'Tache' 21]
ADO 9 Atlas 2
  [Salvador “Choco” Méndez (3), Antonio Toledo (3), Enrique Pradere (2), 
   Rigoberto Rubalcava (og); Agustín Medina (2)]
Bye: Guadalajara, Marte

Round 5
[Nov 11]
Marte 2 América 3
  [José 'Che' Gómez 9, Alberto 'Caballo' Mendoza 70; Miguel Ángel Segura 33, 
   Leopoldo Proal 47, Luis García Cortina 59]
[Nov 14]
Atlante 2 ADO 2
  [Vicente García, José Antonio Hutt; José Leonardo Zamudio, José de la Luz Soto]
Guadalajara 3 España 5
  [Carlos Laviada 20og, Luis Reyes 39, José Gutiérrez 84pen; 
   Isidro Lángara (4), Juan Tuñas]
Moctezuma 1 Asturias 2
[Ernesto Candia; Ismael Zavaleta, José Menéndez]
Bye: Atlas, Veracruz

Round 6
[Nov 18]
Marte 1 Atlas 1
  [José Luis Borbolla 32; José Alberto Valdivieso 75pen]
Bye: ADO, América, Asturias, Atlante, España, Guadalajara, Moctezuma, 
     Veracruz 

Round 7
[Nov 25]
España 6 América 1
  [José Iraragorri 8, 25, 66, Carlos Septién 35, Juan Tuñas 55, 68; 
   Luis García Cortina 64]
[Nov 28]
ADO 4 Marte 0
  [Antonio Toledo (2), Enrique Pradere (2)]
Asturias 3 Guadalajara 2
  [Salvador Arizméndi, José Menéndez, ¿?; Teofilo García 16, 
   Pablo González 52]
Atlas 3 Veracruz 1
  [Guadalupe Velásquez 9 21, Roberto Zárate 83; Luis de la Fuente 20]
Bye: Atlante, Moctezuma

Round 8
[Dec 2]
Atlante 0 Moctezuma 1
  [Julio Pascual Cupido 35]
[Dec 5]
Atlas 3 Guadalajara 7
  [José Alberto Valdivieso (2; 1pen), Agustín Medina; Luis Reyes 16, 39, 
   Pablo González 20, 59, 62, Javier de la Torre 73, Ricardo Ornelas 75og] 
América 4 Veracruz 6
  [Guido Matamoros 9, Leopoldo Proal 35, Luis García Cortina 53, 82; 
   Luis de la Fuente (3), José Miguel Díez, Samuel Cuburu (2)]
Bye: ADO, Asturias, España, Marte 

Round 9
[Dec 9]
España 3 Marte 2
  [Isidro Lángara (2), José Iraragorri; Alberto Mendoza (2)]
[Dec 12]
Veracruz 3 Guadalajara 1
  [José Miguel Díez, Luis de la Fuente, Samuel Cuburu; Pablo González 11]
Atlante 1 Asturias 1
  [Noriega; José Noguera]
Moctezuma 3 ADO 1
  [Alfonso Arnaiz (2), Julio Pascual Cupido; Enrique Pradere]
Bye: Atlas, América

Round 10
[Dec 16]
América 3 Atlas 2
  [Julio Orvañanos 14, Luis García Cortina 17, 40; 
   Agustín Medina, Rodrigo Solano]
[Dec 19]
España 9 Veracruz 3
  [Isidro Lángara (4), José Iraragorri (2), Jorge Quezada, Juan Tuñas, 
   Carlos Septién; Samuel Cuburu, José Miguel Díez, Vicente Castellanos]
Guadalajara 3 Moctezuma 1
  [Luis Reyes 50, Dolores Araujo 58og, Rafael Orozco 69; Antonio Villegas 71]
Bye: ADO, Asturias, Atlante, Marte

Round 11
[Dec 23]
Asturias 4 ADO 1
  [Ismael Zavaleta 21, Tomás Ordóñez 54, Ignacio Cabezón 68, 
   Salvador Arizméndi 79; Antonio Toledo 66]
[Dec 26]
Marte 1 Guadalajara 2
  [Manuel 'Gitano' López; Luis Reyes 40, Pablo González 60]
Atlas 3 Atlante 3
  [Agustín Medina 22, 80, Guadalupe Velásquez 64; Baldomero Arce 35, 
   Adalberto 'Dumbo' López 43, 53]
Bye: América, España, Moctezuma, Veracruz

Round 12
[Dec 30]
Asturias 6 Veracruz 2
  [Ismael Zavaleta 24, 72, Tomás Ordóñez 43, 47, José Noguera 60, 
   Salvador Arizméndi 62; Samuel Cuburu 70, José Valdivia 85]
[Jan 2]
Atlante 2 España 1
  [Horacio Casarín 2, Martín Vantolrá (pen); Carlos Septién]
Bye: ADO, América, Atlas, Guadalajara, Marte, Moctezuma

Round 13
[Jan 6]
Marte 3 Asturias 0
  [Alberto Mendoza 5, 62, José Luis Borbolla 12]
[Jan 9]
Moctezuma 5 Atlas 1
  [Honorio Arteaga (4), Alfonso Arnaiz; Agustín Medina]
Veracruz 2 ADO 2
  [José Valdivia (2); Salvador “Choco” Méndez, Luis V. Aussín]
América 2 Atlante 5
  [Octavio Vial 80, Florencio Cafaratti 82; Horacio Casarín (2), 
   Martín Vantolrá, José Antonio Hutt (2)]
Bye: Guadalajara, España

Round 14
[Jan 16]
Marte 4 Moctezuma 2
  [Manuel 'Gitano' López, José 'Che' Gómez (3); Julio Pascual Cupido, 
   Epigmenio Trueba (og)]
ADO 2 España 8
  [Justo Couto (pen), Antonio Toledo; José Iraragorri (3), 
   Isidro Lángara (3), Enrique Larriñaga (2)]
Guadalajara 3 América 1
  [Manuel 'Cosas' López 2, Pablo González 47pen, 59; Florencio Cafaratti 82]
Bye: Asturias, Atlante, Atlas, Veracruz

Round 15
[Jan 23]
Veracruz 2 Atlas 3
  [Luis de la Fuente, Julián 'Pachuco' Durán (pen); Antonio Flores, 
   Agustín Medina, Manuel “Mariachi” Romero]
Marte 1 España 4
  [Manuel Alonso; Enrique Larriñaga (2), Isidro Lángara (2)]
Moctezuma 2 Atlante 1
  [Ernesto Candia, Alfonso Arnaiz; José Antonio Hutt]
Guadalajara 1 Asturias 5
  [Maximiliano Prieto 79; Rodolfo Hidalgo 9og, Ismael Zavaleta 51, 63, 
   José Menéndez 61, José Noguera 70] 
Bye: ADO, América

Round 16
[Jan 27]
América 1 ADO 3
  [Roberto Scarone 15;¿? 7, Salvador “Choco” Méndez 22, 
   Enrique Pradere 55]
[Jan 30]
Atlas 3 Marte 0
  [Luis 'Pulgón' Acosta 68, Agustín 'Chino' Medina 76, 87]
Asturias 1 Atlante 2
  [José Noguera; Horacio Casarín, Noriega]
Moctezuma 1 España 2
  [Ricardo Álvarez 13; José Iraragorri 42pen, Enrique Larriñaga]
Bye: Guadalajara, Veracruz

Round 17
[Feb 6]
Marte 0 ADO 2
  [José Antonio Cuburu, Enrique Pradere]
Moctezuma 3 América 1
  [Ernesto Candia (pen), Alfonso Arnaiz (2); Roberto Scarone 23pen]
Guadalajara 0 Atlante 1
  [Martín Vantolrá 82]
Bye: Asturias, Atlas, España, Veracruz

Round 18
[Feb 10]
Asturias 2 Atlas 3
  [Ismael Zavaleta 76, Tomás Ordóñez 85; Antonio 'Niño' Flores 32, 54, 
   Agustín 'Chino' Medina 36]
[Feb 13]
Atlante 3 América 3
  [Martín Vantolrá, Horacio Casarín, Felipe Olivares; 
   Florencio Cafaratti 8, 42, Luis García Cortina 15]
Moctezuma 3 Marte 3
  [Ernesto Candia (2), Alfonso Arnaiz; Martín Gómez (2), Manuel Alonso]
Guadalajara 5 Veracruz 1
  [Pablo González 15, 18, 52, 89, Javier de la Torre 59; José Miguel Díez 63] 
Bye: ADO, España 

Round 19
[Feb 17]
España 5 ADO 1
  [Isidro Lángara 44, 47, 85, Jorge Quezada 52, Enrique Larriñaga 62; 
   José Leonardo 'Chanclitas' Zamudio 39]
[Feb 20]
Atlas 3 Moctezuma 3
  [Agustín Medina 21, 62, Manuel Romero 36; Alfonso Arnaiz 48, 
   Julio Pascual Cupido 60, Antonio Villegas 87]
América 7 Guadalajara 2
  [Leopoldo Proal 7, 15, 25, 67, Guido Matamoros 66, 90, 
   Luis García Cortina 70; Luis Reyes 19, Javier de la Torre 90]
Veracruz 1 Asturias 2
  [Martín Cuburu 47; Ismael Zavaleta, José Noguera 86]
Bye: Atlante, Marte

Round 20
[Feb 24]
España 2 Atlante 0
  [Jorge Quezada 53, Enrique Larriñaga 68]
[Feb 27]
Asturias 7 Marte 2
  [Ismael Zavaleta 10, Francisco Fandiño 40, Tomás Regueiro 43, 86, 
   José Menéndez 53, 69, José Noguera 89; Manuel Alonso 74, 82]
ADO 2 Veracruz 3
  [Salvador “Choco” Méndez 35, Julio Pisapía 86; Julián Durán 52, 54, 61]
Bye: América, Atlas, Guadalajara, Moctezuma

Round 21
[Mar 2]
España 8 Guadalajara 2
  [Emilio Alonso 16, 81, Jorge Quezada 18, Isidro Lángara 25, 49, 70, 
   Enrique Larriñaga 30, 42; Luis Reyes 55, 57]
[Mar 5]
Marte 4 Veracruz 2
  [Alberto Mendoza 32, 45, Manuel 'Gitano' López 54, Hernán Cabalceta 72; 
   Julián Durán 6, 79]
Atlas 3 América 0
  [Pedro Vera 16og, Antonio Flores 24, Agustín Medina 74] 
ADO 0 Atlante 1
  [Horacio Casarín]
Bye: Asturias, Moctezuma

Round 22
[Mar 9]
Asturias 2 Moctezuma 2
  [Ismael Zavaleta 7, José Menéndez 10; Antonio Villegas 22, 88]
[Mar 12]
Atlante 2 Atlas 2
  [Martín Vantolrá 30, Horacio Casarín 60; Antonio Flores 39pen, 49]
ADO 3 Guadalajara 2
  [Julio Pisapía (2), ¿?; Luis Reyes 31, Pablo González 70]
Veracruz 7 España 2
Bye: América, Marte

Round 23
[Mar 16]
América 2 Marte 0
  [Leopoldo Proal 15, Miguel Ángel Segura 51]
[Mar 19]
Asturias 1 España 1
  [José Noguera 56; Isidro Lángara 49]
Atlas 3 ADO 0
  [Agustín Medina 37, 69, Agustín Lozano 64og]
Veracruz 5 Moctezuma 2
Bye: Atlante, Guadalajara

Round 24
[Mar 23]
Marte 5 Atlante 1
  [José Luis Borbolla 55, Alberto Mendoza 64, 66, 67, Manuel López 72; 
   Vicente Villar 78]
[Mar 26]
Guadalajara 1 Atlas 3
  [Javier de la Torre 39; Manuel Romero 1, Fidencio Casillas 4, 
   Agustín Medina 10] 
América 2 España 4
  [Roberto Scarone 8, Florencio Caffarati 80; ¿? 35, 80, 85, 89]
ADO 3 Asturias 4
Bye: Moctezuma, Veracruz

Round 25
[Mar 30]
Atlante 3 Veracruz 1
  [Horacio Casarín; ¿?]
[Apr 2]
América 2 Asturias 7
  [Luis García Cortina 45, Octavio Vial 51; 
   Roberto Aballay 5, 13, 39, 58, José Menéndez 64, 85, 
   Tomás Regueiro 88]
Guadalajara 5 Marte 1
  [Diego Martínez 3, 40, Javier de la Torre 25, 78, 85; 
   Manuel 'Gitano' López 83]
ADO 0 Moctezuma 3
  [Antonio Villegas 7, 77, Ricardo Álvarez 15] 
Bye: Atlas, España

Round 26
[Apr 9]
Atlas 0 España 1
  [José Iraragorri 34]
Moctezuma 3 Guadalajara 2
  [¿?; Javier de la Torre 3, Diego Martínez 49]
Veracruz 4 América 1
  [¿?; Octavio Vial 23]
Bye: ADO, Asturias, Atlante, Marte

Final Table
España			18  13  1  4  70:35 +35  27 [Mexico City] [playoff]
Asturias		18  12  3  3  57:32 +25  27 [Mexico City] [playoff]
Moctezuma		18   9  3  6  43:34  +9  21 [Orizaba]
Atlante			18   6  6  6  28:31  -3  18 [Mexico City]
Atlas			18   7  4  7  42:50  -8  18 [Guadalajara]
Guadalajara		18   8  0 10  50:51  -1  16
Veracruz		18   7  2  9  48:57  -9  16
América	      		18   6  1 11  42:58 -16  13 [Mexico City]
Marte			18   4  4 10  32:47 -15  12 [Mexico City]
ADO			18   5  2 11  37:54 -17  12 [Orizaba]

Playoff
[Apr 16]
Parque Asturias, Mexico City
Asturias 4 España 1
  [José Menéndez 11, Roberto Aballay 13, 54, Tomás Regueiro 84; 
   Isidro Lángara 90]

Before the start of Cup Tournament 1943-44, León and Puebla joined the league.




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

Last updated: 5 Feb 2015

(C) Copyright Erik Francisco Lugo
and RSSSF 2010/15

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,253,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6153
Total Execution Time  0.6174
  CADENA URL  
/apertura_mexico1944
  GET DATOS  
$_GET['/apertura_mexico1944']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0144  SELECT type FROM routes WHERE alias = 'apertura_mexico1944'
0.0290  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 = 1944 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0148  SELECT text_es as historical_text FROM leagues_text WHERE id=2040
0.0145  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 = 30301 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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='1944' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:23:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:23:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:23:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:23:14' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  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 = 1944 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1944 e WHERE e.league_id IN (30301) 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.0144  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 (30301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events1944 e WHERE e.league_id IN (30301) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1944 e WHERE e.league_id IN (30301) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0146  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 (30301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events1944 e WHERE e.league_id IN (30301) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  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 (30301) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  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 = 30301 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0146  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 = 30301 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0147  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=30301 AND rel.round=18
0.0146  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 = 30301 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0148  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 = 30301 AND esl.points > 0
0.0146  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` = 30301 ORDER BY creation_date DESC LIMIT 0, 10
0.0169  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` = 30301
0.0147  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 `calendars1944` 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` = 30301 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0144  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 `events1944` e INNER JOIN calendars1944 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 = 18 AND e.real_date IS NOT NULL AND e.league_id = 30301 ORDER BY total DESC LIMIT 40
0.0156  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 `events1944` e INNER JOIN calendars1944 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 = 30301 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0153  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 `tables1944` 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 = 30301 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1944` 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 = 30301 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 30301 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0153  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0153  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 68 AND l.year = 1944 ORDER BY l.group_code ASC
0.0153  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1944