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

Liga MX - Apertura 1942

Información Histórica 
						

Regular Season

Round 1
[Aug 10, 1941]
España 1 Marte 1
  [José Iraragorri; José 'Che'Gómez (pen)]
Moctezuma 6 América 2
  [Honorio Arteaga, Rafael Ángel Meza (2), Becerra, Dolores Araujo, 
   Pedro Regueiro; Guido Matamoros 45, Octavio Vial 53]
Selección Jalisco 2 Necaxa 2
  [Teofilo 'Tilo' García 12pen, 30; Horacio Casarín 5, 43]
Bye: Asturias, Atlante

Round 2
[Aug 17]
Asturias 2 Atlante 3
  [Ordóñez, Tomás Regueiro; Antonio Hutt (2), Alberto 'Caballo' Mendoza]
Bye: América, Necaxa, España, Marte, Moctezuma, Selección Jalisco

Round 3
[Aug 24]
Necaxa 3 España 1 
  [Horacio Casarín (3); Luis Regueiro]
Selección Jalisco 0 Marte 1
  [Headley 40]
Bye: América, Atlante, Asturias, Moctezuma

Round 4
[Aug 31]
América 6 Atlante 3
  [Luis García Cortina 2, 85, Hernán Cabalceta 60, 73, Octavio Vial 80, 87; 
   Martín Vantolrá, Alberto Mendoza, Guián]
Moctezuma 1 Asturias 4
  [Becerra; Tomás Regueiro, Enrique Larriñaga (2), Ordóñez]
Bye: España, Necaxa, Marte, Selección Jalisco

Round 5
[Sep 7]
Marte 2 Moctezuma 0
  [Luis de la Fuente (2)]
Bye: América, Asturias, Atlante, España, Necaxa, Selección Jalisco

Round 6 
[Sep 14]
Atlante 5 España 2 
  [Martín Vantolrá (2), Alberto Mendoza (2), (og); Martín Cuburu, 
   José Iraragorri]
Bye: América, Asturias, Marte, Necaxa, Moctezuma, Selección Jalisco

Round 7
[Sep 21]
Necaxa 5 Asturias 2
  [Horacio Casarín (3), Vicente 'Chamaco' García, Luis Luébano; ¿?, 
   'Chanclas' Zamudio]
Selección Jalisco 5 América 3
  [Teofilo 'Tilo' García 5, Pablo González 35, 60, 86, Guadalupe Velásquez 66; 
   Julio Lorez 40, Octavio Vial 50, 55]
Bye: Atlante, España, Marte, Moctezuma

Round 8
[Sep 28]
Marte 5 América 3
  [Luis de la Fuente (2), José Gómez, Armando Frank (og), Headley; 
   Luis García Cortina 25pen, 30, 43]
Moctezuma 3 Atlante 1
  [Alfonso Arnaiz, Rafael Ángel Meza, Honorio Arteaga; Alberto Mendoza]
Bye: Asturias, España, Necaxa, Selección Jalisco

Round 9
[Oct 5]
Atlante 2 Selección Jalisco 0
  [Martín Vantolrá 43, Alberto Mendoza]
Bye: América, Asturias, España, Marte, Moctezuma, Necaxa

Round 10
[Oct 12]
Selección Jalisco 2 Moctezuma 1
  [Max Prieto 33, Rodrigo Ruiz 88pen; Pedro Regueiro 42]
Necaxa 1 América 3
  [Tomás Lozano; Luis García Cortina 24, 75, Guido Matamoros 82]
Bye: Atlante, Asturias, España, Marte
 
Round 11
[Oct 16]
Asturias 6 Marte 0
  [Eguirao (4), ¿?, 'Chanclas' Zamudio]
[Oct 19]
Necaxa 1 Moctezuma 2
  [Tomás Lozano; Antonio 'Gura' Villegas, Rafael Ángel Meza]
Bye: América, Atlante, España, Selección Jalisco

Round 12
[Oct 23]
Asturias 2 Selección Jalisco 2
  [Eguirao 15, Ordóñez 60; Roberto González 17, 28]
[Oct 26]
América 3 España 5 
  [Octavio Vial 7, 60, Hernán Cabalceta 52; Juan Tuñas (3), 
   José Iraragorri (2)]
Bye: Atlante, Marte, Moctezuma, Necaxa

Round 13
[Oct 30]
Marte 2 Atlante 2
  [Luis de la Fuente, René Hansen; Antonio Hutt, Martín Vantolrá (pen)]
[Nov 2]
España 4 Moctezuma 3
  [Emilio Alonso 'Emilín', Juan Tuñas, Rodolfo Muñoz 'Buch'; 
   Pedro Regueiro (2), Antonio 'Gura' Villegas]
Bye: América, Asturias, Necaxa, Selección Jalisco

Round 14
[Nov 9]
América 4 Asturias 2
  [Octavio Vial 50, Luis García Cortina 53pen, Guido Matamoros 71, 
   Hernán Cabalceta 86; Enrique Larriñaga, ¿?]
Atlante 0 Necaxa 2
Bye: España, Marte, Moctezuma, Selección Jalisco

Round 15
[Nov 13]
España 5 Selección Jalisco 2
  [Martín Cuburu 29, 35, 43, 65, José Iraragorri 31; Luis Reyes, 
   Guadalupe Velásquez]
[Nov 16]
Marte 0 Necaxa 1
  [Vicente 'Chamaco' García 34]
Bye: América, Asturias, Atlante, Moctezuma 

Round 16
[Nov 23]
España 3 Asturias 0
  [Martín Cuburu (2), Emilio Alonso]
Bye: América, Atlante, Necaxa, Marte, Moctezuma, Selección Jalisco

Round 17
[Nov 27]
América 2 Moctezuma 3
  [Leopoldo Proal 34, 50; Rafael Ángel Meza (2), Alfonso Arnaiz]
[Nov 30]
Asturias 1 Necaxa 0
  [Tomás Regueiro]
Bye: Atlante, España, Marte, Selección Jalisco

Round 18
[Dec 4]
Marte 2 Selección Jalisco 3
  [José 'Che' Gómez (2); Guadalupe Velásquez 46, Roberto González 50, 
   Pablo González 86]
[Dec 7]
España 2 Atlante 2
  [Martín Cuburu, Félix De los Heros 'Tache'; Martín Vantolrá (pen), 
   Alberto Mendoza]
Bye: América, Asturias, Moctezuma, Necaxa

Round 19
[Dec 11]
América 2 Marte 4
  [Hernán Cabalceta 8, 50; Arturo Chávez (2), José 'Che' Gómez, 
   Antonio López]
[Dec 14]
Moctezuma 3 Selección Jalisco 0
  [Rafael Ángel Meza (2), Becerra]
España 1 Necaxa 1
  [Juan Tuñas; Salvador 'Negro' Cervantes]
Bye: Asturias, Atlante

Round 20
[Mar 1, 1942]
Selección Jalisco 2 Atlante 3
  [Guadalupe Velásquez 49, Margarito Corona 63pen; Felipe Olivares 15, 
   Antonio Hutt 27, Alberto Mendoza 35]
España 5 América 1
  [José Iraragorri (2), Félix De los Heros (2), Juan Tuñas; Octavio Vial 12]
Bye: Necaxa, Marte, Asturias, Moctezuma 

Round 21
[Mar 5]
Marte 6 Asturias 3 
  [Antonio López, José Gómez, Luis de la Fuente (3), Arturo Chávez; 
   Ruvalcaba, Tomás Regueiro, Sabino Aguirre (pen)]
[Mar 9]
Necaxa 5 Atlante 4
  [Baldomero Arce, Horacio Casarín (2), Salvador Cervantes, Vicente García; 
   Alberto Mendoza, Julio Munloch (3)]
Moctezuma 3 España 2
  [Rafael Ángel Meza (2), Antonio Villegas; José Iraragorri, Emilio Alonso]
Bye: América, Selección Jalisco

Round 22
[Mar 12]
Asturias 2 América 1
  [Tomás Regueiro (2); Octavio Vial 88]
[Mar 15]
Selección Jalisco 1 España 1
  [Guadalupe Velásquez 57; Emilio Alonso 40]
Atlante 4 Marte 3
  [Alberto Mendoza, Martín Vantolrá (pen), Antonio Hutt, Julio Munloch;
   Arturo Chávez (2), José 'Che' Gómez]
Bye: Necaxa, Moctezuma

Round 23
[Mar 19]
América 3 Necaxa 3
  [Octavio Vial 30, 75, Guido Matamoros 62; Horacio Casarín (2), 
   Salvador Cervantes]
[Mar 22]
Atlante 4 Asturias 2
  [Alberto Mendoza, Julio Munloch, Pizano, antonio Hutt;
   Enrique Larriñaga, Ruvalcaba]
Bye: España, Marte, Moctezuma, Selección Jalisco

Round 24
[Mar 26]
Marte 1 España 4 
  [José Gómez (pen); Juan Tuñas (4)]
[Mar 29]
América 4 Selección Jalisco 3
  [Octavio Vial 14, Hanmeken 53, 57, Leopoldo Proal 86; 
   Margarito Corona 11, Luis Reyes 43, Guadalupe Velásquez 59]
Bye: Asturias, Atlante, Necaxa, Moctezuma

Round 25
[Apr 2]
Atlante 5 Moctezuma 1
  [Martín Vantolrá (2), Alberto Mendoza (2), Felipe Olivares; 
   Rafael Ángel Meza]
[Apr 5]
Necaxa 3 Marte 7
  [Salvador Cervantes, Horacio Casarín (2); Arturo Chávez (2), 
   Luis de la Fuente (2), José Gómez (2), Antonio López] 
Selección Jalisco 3 Asturias 1
  [Teofilo García 49, Guadalupe Velásquez 58, Rodrigo Ruiz 62; 
   Enrique Larriñaga 37]
Bye: América, España

Round 26
[Apr 9]
Atlante 6 América 4
  [Felipe Olivares (2), Martín Vantolrá (3), Antonio Hutt; 
   Aguirre 10, 36, 55, Romero 83]
[Apr 12]
Asturias 0 España 2 
  [Félix De los Heros 'Tache' (2)]
Moctezuma 3 Marte 0
  [Rafael Ángel Meza (2), Antonio 'Gura' Villegas]
Bye: Necaxa, Selección Jalisco

Round 27
[Apr 16]
Necaxa 3 Selección Jalisco 3
  [Salvador Cervantes, Baldomero Arce, Horacio Casarín; 
   Teofilo García, Flores, Margarito Corona]
Bye: América, Asturias, Atlante, España, Marte, Moctezuma

Round 28
[Apr 26]
Moctezuma 1 Necaxa 1
  [Rafael Ángel Meza; 'Cachetón' Aguilar 82]
Bye: América, Asturias, Atlante, España, Marte, Selección Jalisco

Round 29
[May 3]
Asturias 3 Moctezuma 8

Final Table
*España		   14	7  4  3	 38-26	+12   18  [Mexico City]
*Atlante	   14   8  2  4  44-36	 +8   18  [Mexico City]
Moctezuma	   14   8  1  5  38-29	 +9   17  [Orizaba]
Necaxa 		   14   5  5  4  31-30	 +1   15  [Mexico City]
Marte	           14   6  2  6  34-35	 -1   14  [Mexico City]
Selección Jalisco  14   4  4  6  28-33	 -5   12  [Guadalajara]
América            14   4  1  9  41-53	-12    9  [Mexico City]
Asturias           14   4  1  9  30-42	-12    9  [Mexico City]


Playoff
[May 10]
España 5 Atlante 4
  [Emilio Alonso, José Iraragorri, Juan Tuñas (3); Martín Vantolrá, 
   Julio Munloch, Alberto Mendoza, Antonio Hutt]



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

Last updated: 7 May 2010

(C) Copyright Erik Francisco Lugo
and RSSSF 2010

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,233,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.3447
Total Execution Time  0.3470
  CADENA URL  
/apertura_mexico1942
  GET DATOS  
$_GET['/apertura_mexico1942']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0106  SELECT type FROM routes WHERE alias = 'apertura_mexico1942'
0.0214  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 = 1942 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0107  SELECT text_es as historical_text FROM leagues_text WHERE id=2042
0.0109  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 = 30303 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  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='1942' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 23:34:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 23:34:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 23:34:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0108  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 23:34:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0115  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 = 1942 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0112  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=30303 AND rel.round=14
0.0112  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 = 30303 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0112  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 = 30303 AND esl.points > 0
0.0109  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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30303 ORDER BY creation_date DESC LIMIT 0, 10
0.0125  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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30303
0.0117  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 `calendars1942` 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` = 30303 AND c.`round` = 14 ORDER BY shedule ASC LIMIT 200
0.0116  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 `events1942` e INNER JOIN calendars1942 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 = 14 AND e.real_date IS NOT NULL AND e.league_id = 30303 ORDER BY total DESC LIMIT 40
0.0112  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 `events1942` e INNER JOIN calendars1942 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 = 30303 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0119  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 `tables1942` 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 = 30303 AND t.round = 12 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1942` 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 = 30303 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  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 = 30303 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0110  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0110  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1942