4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 1990
Temporada Siguiente »
Publicidad 600x120.gif
Copa México - Apertura 1990
1989/1990

Copa México - Apertura 1990

Información Histórica 
						

Copa México 1989-90 (Cup Tournament)

Teams were seeded 1-20 based on points at the end of the round 19
in the 1989-90 league:

( 1) Puebla             (11) Irapuato
( 2) America            (12) Ciudad Juarez
( 3) U. de Guadalajara  (13) Santos
( 4) U.N.A.M.           (14) U.A.G.
( 5) Necaxa             (15) U.A.T.
( 6) Morelia            (16) Toluca
( 7) Monterrey          (17) Atlante
( 8) U.A.N.L.           (18) Guadalajara
( 9) Cruz Azul          (19) Veracruz
(10) Atlas              (20) Tampico - Madero

Preliminary Round

First Legs
[Jan 17, 1990]
Tampico - Madero 1 Santos Laguna 0
  [Ricardo Moreno 76pen]
Veracruz 0 UAG 2
  [Néstor de la Torre 36, Fernando Sánchez Limón 81]
Atlante 1 Toluca 1
  [Luis Miguel Salvador 10; Antonio Zúñiga 53]
[Jan 18]
Guadalajara 2 UAT 0
  [Demetrio Madero 6, René Paúl Moreno 9]

Second Legs
[Jan 31]
Santos Laguna 2 Tampico - Madero 1 (2-2agg, Tampico - Madero on away goals)
  [Víctor López 68, Dolmo Flores 72; Juan Pablo Muciño 76]
UAG 1 Veracruz 0 (3-0agg)
  [Ignacio Ruvalcaba 36]
UAT 1 Guadalajara 1 (1-3agg)
  [Rolando Reséndiz 30; Luis Rodríguez 38]
Toluca 2 Atlante 1 (3-2agg)
  [Rafael Chávez Carretero 1, Jorge Rodríguez 61; Víctor Medina 46]

Round of 16

First Legs
[Feb 13]
Guadalajara 4 U de G 2
  [Manuel Castañeda 18, Javier Aceves 35, 53, Everaldo Bejines 66; Rodolfo Michel 47, Fernando Quirarte 69]
[Feb 14]
Tampico - Madero 1 Puebla 0
  [Graciano del Castillo 5]
Toluca 0 América 3
  [Carlos Hermosillo 8, Gonzalo Farfán 40, Antonio Alcántara 60og]
UAG 4 UNAM 1
  [Fernando Sánchez Limón 28, Alejandro Cárdenas 35, Ricardo Chávez Medrano 65, Jorge Martínez 84; Roberto Medina 86]
Irapuato 0 Necaxa 3
  [Ismael Herrera 26, Mario Franco 64, Javier Ferreira 85]
Cobras 2 Morelia 0
  [Carlos Ramírez 61, Víctor Cosío 68]
Cruz Azul 2 Monterrey 3
  [Patricio Hernández 27, Jorge Guerra 41; Héctor Gutiérrez 23, 45, Héctor Becerra 50]
[Feb 15]
Atlas 3 UANL 2
  [Jorge Castañeda 3, Arturo Beltrán 45, Jaime Rodríguez 83og; Jorge Gama 14, 42]

Second Legs
[Feb 27]
América 0 Toluca 0 (3-0agg)
Monterrey 0 Cruz Azul 0 (3-2agg)
[Feb 28]
Puebla 4 Tampico - Madero 2 (4-3agg)
  [Jorge Aravena 9, 27, Luis Fernando de la Torre 19og, Edivaldo Martins 22; Miguel Ángel Gómez 49, José Luis Malibrán 84]
U de G 1 Guadalajara 0 (3-4agg)
  [Rodolfo Michel 39]
UNAM 2 UAG 1 (5-3agg)
  [Antonio Torres Servín 68, Jorge Campos 88; Ricardo Viera 30]
Morelia 2 Cobras 2 (2-4agg)
  [Marco Antonio Figueroa 27pen, Luis González 90; Mario Rodríguez 60, Luis González 70og]
[Mar 1]
Necaxa 0 Irapuato 0 (3-0agg)
UANL 2 Atlas 0 (4-3agg)
  [Marco Antonio Díaz Ávalos 5pen, Jorge Gama 90]

Quarterfinals

First Legs
[Mar 7]
Guadalajara 0 Puebla 0
Monterrey 2 Necaxa 1
  [Antonio González 13, Juan Antonio Flores Barrera 17; Roberto Alderete 50]
Cobras 2 UANL 1
  [Mario Rodríguez 7, Martín Soto 58; Sergio Almirón 60]
[Mar 8]
UAG 1 América 1
  [Franco Navarro 49; Carlos Hermosillo 55]

Second Legs
[Mar 14]
Puebla 2 Guadalajara 1 (2-1agg)
  [Jorge Aravena 16, Carlos Poblete 29; Juan Carlos Vázquez 7]
América 0 UAG 0 (1-1agg, América on away goals)
UANL 3 Cobras 1 (4-3agg)
  [Jaime Rodríguez 51, Víctor Manuel Escalera 58, Jorge Patiño 92; Jorge Patiño 22og]
Necaxa 0 Monterrey 1 (1-3agg)

Semifinals

First Legs
[Mar 21]
Monterrey 1 Puebla 1
  [Francisco Javier Cruz 69; Sergio Almaguer 54]
[Mar 28]
UANL 1 América 1
  [Sergio Almirón 84pen; Jesús Eduardo Córdova 91]

Second Legs
[Mar 28]
Puebla 1 Monterrey 0 (2-1agg)
  [Jorge Aravena 24]
[Apr 4]
América 2 UANL 2 (3-3agg, UANL on away goals)
  [Raúl Vicente Amarilla 15, Gonzalo Farfán 71; Sergio Almirón 47pen, Miguel Ángel Esparza 73]

Final

First Leg
[Apr 11] 
UANL 2 Puebla 0
  [Sergio Almirón 28, Jorge Gama 33]

Second Leg
[Apr 18]
Puebla 4 UANL 1 (4-3agg)
  [Carlos Poblete 3, 20, Jorge Aravena 39, Marcelino Bernal 83; Sergio Almirón 36]




Authors: Erik Francisco Lugo
(eaglelugo@yahoo.com.mx)
and Héctor Villa Martínez
Last updated: 6 Mar 2009

(C) Copyright Erik Francisco Lugo,
Héctor Villa Martínez and RSSSF 1995/2009


  USO DE MEMORIA  
4,238,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0022
Controller Execution Time ( Home / Category )  0.1156
Total Execution Time  0.1179
  CADENA URL  
/copa_mexico_apertura1990
  GET DATOS  
$_GET['/copa_mexico_apertura1990']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT type FROM routes WHERE alias = 'copa_mexico_apertura1990'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_mexico_apertura' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT text_es as historical_text FROM leagues_text WHERE id=2063
0.0025  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 = 30324 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='1990' WHERE c.parentId=695 GROUP BY c.id ORDER BY c.order_id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:01:36' 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-28 17:01:36' 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=4 AND last_update > '2024-04-28 17:01:36' 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-28 17:01:36' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_mexico_apertura' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0026  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1990
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (30324) 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.0021  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 (30324) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1990
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (30324) 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 (30324) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1990
0.0018  SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (30324) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0062  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 (30324) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0056  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 695 AND l.year = 1990
0.0019  SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (30324) AND (e.action IN (22) ) 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 (30324) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0019  SELECT SUM(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.category_id = 695 AND rp.year = 1990 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0018  SELECT SUM(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.category_id = 695 AND rp.year = 1990 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0022  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=30324 AND rel.round=8
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 = 30324 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 = 30324 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-29" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30324 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-29" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30324
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 `calendars1990` 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` = 30324 AND c.`round` = 8 ORDER BY shedule ASC LIMIT 200
0.0019  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 `events1990` e INNER JOIN calendars1990 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 = 8 AND e.real_date IS NOT NULL AND e.league_id = 30324 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 `events1990` e INNER JOIN calendars1990 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 = 30324 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 `tables1990` 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 = 30324 AND t.round = 6 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 `tables1990` 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 = 30324 AND t.round = 8 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 = 30324 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0020  SELECT data1, data2 FROM services_tags WHERE categoryId=695
0.0020  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 695 AND l.year = 1990 ORDER BY l.group_code ASC
0.0020  SELECT group_code, extraName from `leagues` WHERE categoryId=695 AND year=1990