4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Publicidad 600x120.gif
Liga MX - Clausura 1998
  • Liga MX
Información Histórica
						

Tables:

Group 1

 1.Atlante       17  5  8  4 19-18 23  
 2.Puebla        17  4  6  7 24-32 18
 3.León          17  4  5  8 20-32 17
 4.Celaya        17  3  6  8 13-23 15
 5.Veracruz      17  3  5  9 20-29 14  Relegated

Group 2

 1.Toluca        17 10  3  4 39-25 33  
 2.Cruz Azul     17  8  6  3 32-18 30  
 3.Tigres        17  7  2  8 15-22 23  [formerly U.A.N.L.]
 4.Guadalajara   17  5  4  8 19-17 19
 5.Monterrey     17  4  6  7 20-25 18

Group 3

 1.Santos        17  8  2  7 24-22 26
 2.Neza          17  7  3  7 21-24 24  [Toros]
 3.Morelia       17  5  6  6 26-30 21
 4.U.N.A.M.      17  6  3  8 25-29 21  [Pumas]

Group 4

 1.Necaxa        17 10  2  5 34-18 32  
 2.Atlas         17  9  3  5 29-23 30  
 3.U.A.G.        17  9  3  5 23-21 30  [Tecos]  
 4.América       17  7  5  5 27-22 26


Round 1
[Jan 3]
Toluca      2-1 Monterrey
  [José Cardozo 6, 77; Cleomar Pires 24]
Veracruz    1-1 UAG
  [Ariel Grazziani 3; Mauricio Gallaga 8pen]
Tigres      0-3 Atlante  
  [José Damasceno 15, Carlos Alfaro Moreno 36, Martín Félix Ubaldi 85]
Cruz Azul   1-0 Santos
  [Juan Francisco Palencia 52]
[Jan 4]
Puebla      1-2 Atlas  
  [Luis Humberto Salazar 82; Daniel Guzmán 33, Facundo Villalba 54]
Leon        2-1 America
  [Sigifredo Mercado 37pen, Lorenzo Sáez 61; Christian Torres 72]
UNAM        0-1 Necaxa
  [Sergio Vázquez 57]
Guadalajara 0-0 Celaya
Toros Neza  2-1 Morelia
  [Rodrigo Ruiz 46, Antonio Mohamed 85; Rodolfo García 54]  

Round 2
[Jan 8]
America     5-2 Veracruz
  [Alberto García Aspe 26pen 53, Sergio Zárate 36, Juan Hernández 68, 
  Ricardo Peláez 86; Francisco Uribe 11, René Higuita 99pen]
[Jan 9]  
UAG         3-2 Puebla
  [Roberto Palacios 33, Carlos Hernández 68, David Embé 78; 
  Miguel Pardeza 44, Oscar Olvera 49]
[Jan 10]  
Necaxa      4-0 Monterrey
  [Pedro Pineda 13, 64, Cuauhtemoc Blanco 70, 73] 
Tigres      0-3 Toluca
  [Enrique Alfaro 55, José Cardozo 79, Antonio Taboada 88]  
Celaya      1-1 Toros Neza
  [Emilio Butragueño 61; Guillermo Vázquez 78pen]
Atlas       3-2 Guadalajara
  [Miguel Zepeda 19, Pavel Pardo 45, Juan Pablo Rodríguez 81; 
  Ramón Ramírez 22, Alberto Coyote 86pen]
[Jan 11] 
Atlante     0-2 Cruz Azul
  [Julio César Yegros 39, Carlos Hermosillo 85] 
Morelia     0-0 UNAM
Santos      3-0 Leon
  [Gabriel Caballero 39, Jared Borguetti 75, 88]

Round 3
[Jan 17]
Toluca      2-0 Necaxa
  [Fabián Estay 40pen, José Cardozo 77]
Monterrey   1-1 Morelia
  [David Patiño 62; René Iván Valenciano 7]
Cruz Azul   2-0 Tigres
  [Juan Reynoso 11, 55]  
Veracruz    5-1 Santos
  [Luis Fernando García 19, Ariel Grazziani 44, 80, Armando González 69, 
  René Higuita 89pen; Pedro Duana 41]
[Jan 18]
Puebla      1-3 America
  [Eduardo Medina 53; Ricardo Peláez 10, Germán Villa 27, Isaac Terrazas 77]
Leon        2-2 Atlante
  [Flavio Davino 5, Lorenzo Sáez 51; Gilberto Jiménez 35, Carlos Alfaro Moreno 46]
UNAM        3-1 Celaya
  [Jesús Olalde 28pen, 64, Rafael García 87; Emilio Butragueño 58pen]
Guadalajara 1-2 UAG
  [Gustavo Nápoles 30; Mauricio Gallaga 45pen, David Embé 82]
Toros Neza  1-1 Atlas
  [Javier Saavedra 10; Hugo Castillo 33]

Round 4 
[Jan 23]
Atlante     1-0 Veracruz
  [Luis Flores Anaya 87]
UAG         1-0 Toros Neza
  [Carlos Hernández 61]
[Jan 24]
Cruz Azul   3-1 Toluca
  [Carlos Hermosillo 4pen, 34, Juan Francisco Palencia 18; José Cardozo 53]
Tigres      2-1 Leon
  [Jorge Santillana 8, Ailton Goncalvez 66; Everaldo Bejines 69]
Atlas       4-1 UNAM
  [Daniel Guzmán 15, 37, Hugo Castillo 67, Jafet Soto 71; Antonio Sancho 76]
Celaya      0-0 Monterrey
[Jan 25]
Morelia     2-1 Necaxa
  [Claudio da Silva 21, Darío Franco 44; Cuauhtemoc Blanco 79pen]
Santos      3-0 Puebla
  [Jared Borguetti 21pen, 79, Nicolás Ramírez 84]
America     0-0 Guadalajara

Round 5 
[Jan 27]
UNAM        1-1 UAG
  [Vicente Nieto 53; Carlos Hernández 86]
[Jan 28]
Toluca      2-0 Morelia
  [Fabián Estay 30, José Manuel Abundis 75]
Toros Neza  1-2 America
  [Germán Arangio 60; Sergio Zárate 48, Alberto García Aspe 55]
Puebla      1-1 Atlante
  [Francisco Higuera 59; Carlos Alfaro Moreno 69]
Veracruz    0-2 Tigres
  [Javier Lozano 23, Marco Antonio Ruiz 69]
Necaxa      2-1 Celaya
  [Luis Hernández 63, Alex Aguinaga 88; Luis Miguel Salvador 67]
Leon        1-1 Cruz Azul
  [Flavio Davino 26; Carlos Hermosillo 45pen]
[Jan 29]
Monterrey   0-0 Atlas
Guadalajara 0-2 Santos
  [Antonio Carlos Santos 1, José Antonio Noriega 62]

Round 6 
[Jan 31]
Tigres      1-1 Puebla
  [Ailton Goncalvez 12; Carlos Muñoz 65]
Cruz Azul   1-2 Veracruz
  [Julio César Yegros 22; Ricardo Rayas 37, José Alfredo Gutiérrez 76]
America     1-3 UNAM
  [Duilio Davino 36; Roberto de Moura 10, Braulio Luna 47, Horacio Sánchez 75]
Celaya      0-2 Morelia
  [Claudio da Silva 16, Daniel Deeke 42]
Atlas       1-2 Necaxa
  [Daniel Guzmán 7pen; Alex Aguinaga 25, Pedro Pineda 39]
[Feb 1]
Leon        1-5 Toluca
  [Hernán Medford 69; Fabián Estay 16pen, Darko Vukic 45, 88, Enrique Alfaro 48, José Cardozo 58]
Atlante     1-0 Guadalajara
  [Martín Félix Ubaldi 28]
UAG         1-0 Monterrey
  [Roberto Palacios 56]
Santos      2-0 Toros Neza
  [José Antonio Noriega 33, Nicolás Ramírez 68]

Round 7 
[Feb 7]
Toluca      3-3 Celaya
  [José Manuel Abundis 14, Jaime Ordiales 56, Eduardo Lillingston 67; 
  Emilio Butragueño 22, Luis Miguel Salvador 63, 64]
Monterrey   3-2 America
  [Heriberto Ramón Morales 16, Andrés Garza 33, Edson Zwaricz 63; 
  Alberto García Aspe 81pen, Néstor Cedres 88]
Necaxa      1-2 UAG
  [Pedro Pineda 88; Zdenko Muf 15, Eustacio Rizo 25]
Veracruz    1-2 León 
  [Richard Tavares 61; Lorenzo Sáez 57, Fabián Prátola 66]
[Feb 8]
Puebla      1-1 Cruz Azul
  [Luis Humberto Salazar 85; Benjamín Galindo 42pen]
UNAM        0-1 Santos
  [José Antonio Noriega 8]
Morelia     4-3 Atlas
  [Rodolfo García 3, 52, Claudio da Silva 13, 18; Jorge Francisco Almirón 55, 
  Jafet Soto 61, Daniel Guzmán 71]
Toros Neza  0-0 Atlante
[Feb 11]
Guadalajara 0-1 Tigres
  [Marco Antonio Ruiz 15pen]

Round 8 
[Feb 16]
America     2-0 Necaxa
[Ricardo Peláez 15, Sergio Zárate 43]
[Feb 18]
Atlante     2-3 UNAM     
  [Martín Félix Ubaldi 50, 77; Jesús Olalde 2, José Damasceno 36og, Israel López 73]
Tigres      3-0 Toros Neza
  [Jorge Santillana 12, Ailton Goncalvez 71, Israel García 89]
Santos      2-1 Monterrey
  [Francisco Gabriel de Anda 5, José Antonio Noriega 23; Sergio Luis de Souza 69]
Veracruz    2-2 Toluca
  [Ariel Graziani 27, Romeo Wouden 68; Salvador Carmona 73, Enrique Alfaro 81]
UAG         3-1 Morelia
  [Eustacio Rizo 32, Rubén da Silva 60, 90pen; Claudio da Silva 58]
Leon        0-0 Puebla
Atlas       2-0 Celaya
  [Jorge Francisco Almirón 67, Nelson Esqueda 73]
[Feb 19]
Cruz Azul   2-2 Guadalajara
  [Eduardo Fuentes 21, Carlos Hermosillo 84; Jesús Arellano 32, Paulo César Chávez 91]

Round 9 
[Feb 21]
Toluca      4-1 Atlas
  [Enrique Alfaro 10, José Cardozo 12, Alberto Macías 55, José Manuel Abundis 88; 
  Daniel Guzmán 37]  
Monterrey   1-1 Atlante
  [Edson Zwaricz 2; Carlos Alfaro Moreno 47]
Necaxa      3-0 Santos
  [Cuauhtemoc Blanco 21, Sergio Vázquez 30, José Luis Montes de Oca 84]
Celaya      1-2 UAG
  [Luis Fernando Soto 49; Zdenko Muf 37, Eustacio Rizo 82]
[Feb 22]
Puebla      1-0 Veracruz
  [Felipe del Ángel Malibrán 90]
Morelia     1-2 America
  [René Iván Valenciano 49pen; Ricardo Peláez 38, Isaac Terrazas 52]
UNAM        2-0 Tigres
  [Jorge Campos 80, 92pen]       
Guadalajara 1-1 Leon
  [Paulo César Chávez 18pen; Hernán Medford 41]
Toros Neza  1-0 Cruz Azul
  [Rodrigo Ruiz 74]

Round 10
[Feb 27]
Atlante     0-3 Necaxa
  [Cuauhtemoc Blanco 26, Sergio Almaguer 57, Joaquín del Olmo 60]
UAG         1-2 Atlas     [In León]
  [Rubén da Silva 37; Hugo Castillo 36, 40]
[Feb 28]
Tigres      1-0 Monterrey
  [Juan Manuel Guerra 82]
Cruz Azul   2-2 UNAM
  [Juan Francisco Palencia 54, Carlos Hermosillo 70pen; Jesús Olalde 72pen, 90]
Veracruz    0-2 Guadalajara
  [Paulo César Chávez 35, Gustavo Nápoles 68]
[Mar 1]
Leon        1-2 Toros Neza
  [Kalusha Bwualya 39; Germán Arangio 49, Rodrigo Ruiz 58]
Puebla      3-1 Toluca
  [Miguel Pardeza 48, 55, Luis Humberto Salazar 70; José Cardozo 12]
America     1-0 Celaya
  [Christian Torres 78]
Santos      2-2 Morelia
  [Antonio Carlos Santos 14, Sergio Verdirame 87; Claudio da Silva 7, Jared Borguetti 47og]

Round 11
[Mar 4]
Monterrey   1-2 Cruz Azul
  [Cleomar Pires 22; Benjamín Galindo 79, Rubén Oscar Capria 83]
[Mar 7]
Celaya      1-0 Santos
  [Emilio Butragueño 29pen]
Toluca      2-1 UAG
  [José Cardozo 47, Fabián Estay 55; David Embé 35]
Necaxa      4-0 Tigres
  [Sergio Vázquez 25, Luis Hernández 77, Cuauhtemoc Blanco 79pen, Edson Alvarado 87]
Atlas       1-1 America
  [Pavel Pardo 83pen; Christian Torres 87]
[Mar 8]
Morelia     2-2 Atlante
  [Claudio da Silva 67, Darío Franco 81; Martín Félix Ubaldi 35, Carlos Alfaro Moreno 58]
Guadalajara 2-0 Puebla
  [Gerardo Mascareño 43, Jesús Arellano 75]
UNAM        3-1 Leon
  [Roberto de Moura 18, Jesús Olalde 35, Rafael García 65; Sigifredo Mercado 56pen]
Toros Neza  2-0 Veracruz
  [Richard Tavares 70og, Germán Arangio 83]

Round 12 
[Mar 10]
America     0-1 UAG
  [Rubén da Silva 41]
[Mar 11]
Atlante     0-0 Celaya
Santos      2-3 Atlas
  [Gabriel Caballero 42, 71; Héctor López 2, Hugo Castillo 26, 77]
Veracruz    1-2 UNAM
  [Sasa Milosevski 17; Antonio Sancho 41, Cristian Domizzi 85pen]
Cruz Azul   1-1 Necaxa         [also for CONCACAF CWC 1997]
  [Julio César Yegros 24; Luis Hernández 34]
Leon        2-1 Monterrey
  [Sigifredo Mercado 42, David Alba 93; Marcelino Bernal 55pen]
Tigres      2-0 Morelia
  [Ailton Goncalvez 5, Mario Barilko 15]
[Mar 12]
Puebla      2-4 Toros Neza
  [Jesús Eduardo Córdova 13, Francisco Higuera 50; Germán Arangio 3, 78, 
  Antonio Mohamed 28, Esteve Padilla 90]
Guadalajara 2-0 Toluca
  [Joel Sánchez 15, 31]

Round 13 
[Mar 14]
Necaxa      2-0 Leon
  [Alberto García 50og, Luis Hernández 87]
Monterrey   2-2 Veracruz
  [Sergio Luis de Souza 47, Marcelino Bernal 85; Armando González 32, Salvador Mercado 90]
Celaya      1-0 Tigres
  [Marco Antonio Figueroa 90pen]
Atlas       1-0 Atlante
  [Pablo Hernán Lavallén 53]
[Mar 15]
UNAM        0-2 Puebla
  [Manuel Sol 50, Jesús Eduardo Córdova 67]
Morelia     2-1 Cruz Azul
  [Rodolfo García 41, René Iván Valenciano 82; Héctor Adomaitis 44]
UAG         1-2 Santos
  [Carlos Hernández 82; Gabriel Caballero 13, Nicolás Ramírez 52]
Toluca      1-3 America
  [José Cardozo 19; Ricardo Peláez 22, 49, Christian Torres 47]
Toros Neza  0-1 Guadalajara
  [Ramón Ramírez 79]

Round 14 
[Mar 21]
Toluca      4-1 Toros Neza
  [José Cardozo 23, Miguel Herrera 62og, Alberto Macías 72, Darko Vukic 76; Germán Arangio 31]
Tigres      0-2 Atlas
  [Miguel Zepeda 30, Jafet Soto 55]
Cruz Azul   5-0 Celaya
  [Agustín Morales 27, Benjamín Galindo 66, Carlos Hermosillo 69, Joahan Rodríguez 77, 
  Julio César Yegros 85]
Puebla      1-1 Monterrey     [In Ciudad Nezahualcoyotl]
  [Miguel Pardaza 18; Sergio Pérez 65]
Veracruz    2-2 Necaxa
  [Narciso Cuevas 43, Ariel Graziani 68; Luis Hernández 5, Sergio Vázquez 60]
Guadalajara 4-0 UNAM
  [Ramón Ramírez 37, Jesús Arellano 41, Paulo César Chávez 46, Joel Sánchez 68]
[Mar 22]    
Leon        3-3 Morelia
  [Lorenzo Sáez 2, Sigifredo Mercado 38, Misael Espinosa 81; René Iván Valenciano 73, 
Claudio da Silva 87, 91] 
Atlante     2-0 UAG
  [Martín Félix Ubaldi 73, 89]
[Apr 1]
Santos      1-1 America
  [Jared Borguetti 85; Ignacio Hierro 81]

Round 15
[Mar 24]
Necaxa      5-2 Puebla
  [Luis Hernández 23, 53, Sergio Vázquez 44, Cuauhtemoc Blanco 51, Pedro Pineda 81pen; 
  Jesús Eduardo Córdova 23, Carlos Muñoz 76]
[Mar 25]
Morelia     1-1 Veracruz
  [Claudio da Silva 66; Ariel Graziani 35]
Santos      1-3 Toluca
  [Antonio Carlos Santos 17; Fabián Estay 29, José Cardozo 37, José Manuel Abundis 63]
Celaya      4-1 Leon
  [Luis Miguel Salvador 54, 57, Marco Antonio Figueroa 86, 92; Everaldo Bejines 79]
UAG         0-0 Tigres
America     1-1 Atlante
  [Juan Hernández 86; Luis García 80]
UNAM        1-2 Toros Neza
  [Jesús Olalde 17; Esteve Padilla 29, Rodrigo Ruiz 54]
Atlas       1-2 Cruz Azul
  [Hugo Castillo 28; Carlos Hermosillo 50, Benjamín Galindo 55pen]
[Mar 26]
Monterrey   2-1 Guadalajara
  [Cleomar Pires 50, Edson Zwaricz 85; Noé Zárate 38pen]

Round 16
[Mar 28]
Guadalajara 1-2 Necaxa
  [Ramón Ramírez 60; Luis Hernández 52, 82]
Veracruz    1-0 Celaya
  [Francisco Uribe 30]
Atlante     1-0 Santos
  [Víctor Saavedra 84]
Tigres      3-1 America
  [Fabián Peña 6, Ailton Goncalvez 18, Juan Manuel Guerra 90; Ricardo Peláez 12]
[Mar 29]
Puebla      5-3 Morelia
  [Manuel Sol 2, Carlos Muñoz 19, 42, 47, 74; Darío Franco 43, René Iván Valenciano 54, 
  Jaime López 80]
Toluca      2-1 UNAM
  [José Cardozo 43, José Manuel Abundis 71; Antonio Sancho 40]
Leon        2-0 Atlas
  [Everaldo Bejines 28, 55]
Toros Neza  2-3 Monterrey
  [Jesús López Meneses 20, Javier Saavedra 31; Zoran Djuric 9, Edson Zwaricz 52, 
  Marcelino Bernal 82]
Cruz Azul   5-2 UAG
  [Carlos Hermosillo 26, 51, 54, Juan Francisco Palencia 71, Rubén Oscar Capria 77; 
  Rubén da Silva 39pen, Reynaldo Parks 61]

Round 17
[Apr 5]
America     1-1 Cruz Azul
  [José Luis Salgado 24; Julio César Yegros 52]
UAG         1-0 Leon
  [Zdenko Muf 74]
Monterrey   3-1 UNAM
  [Zoran Djuric 14, Sergio Pérez 49, Carlos González 53; Jesús Olalde 3]
Necaxa      1-2 Toros Neza     [at Estadio Azul]
  [Pedro Pineda 28; Rodrigo Ruiz 17, Germán Arangio 54]
Celaya      0-0 Puebla
Atlas       2-0 Veracruz
  [Rafael Márquez 21, Hugo Castillo 79]
Atlante     2-2 Toluca     [at Estadio Olímpico (UNAM)]
  [José Damasceno 3, Ricardo Carvajal 51; José Manuel Abundis 16, Antonio Taboada 62]
Santos      2-0 Tigres
  [Jared Borguetti 39pen, Gabriel Caballero 64]
[Apr 6]
Morelia     1-0 Guadalajara
  [Claudio da Silva 19]

Tables:

Group 1

 1.Atlante       17  5  8  4 19-18 23  
 2.Puebla        17  4  6  7 24-32 18
 3.León          17  4  5  8 20-32 17
 4.Celaya        17  3  6  8 13-23 15
 5.Veracruz      17  3  5  9 20-29 14  Relegated

Group 2

 1.Toluca        17 10  3  4 39-25 33  
 2.Cruz Azul     17  8  6  3 32-18 30  
 3.Tigres        17  7  2  8 15-22 23  [formerly U.A.N.L.]
 4.Guadalajara   17  5  4  8 19-17 19
 5.Monterrey     17  4  6  7 20-25 18

Group 3

 1.Santos        17  8  2  7 24-22 26
 2.Neza          17  7  3  7 21-24 24  [Toros]
 3.Morelia       17  5  6  6 26-30 21
 4.U.N.A.M.      17  6  3  8 25-29 21  [Pumas]

Group 4

 1.Necaxa        17 10  2  5 34-18 32  
 2.Atlas         17  9  3  5 29-23 30  
 3.U.A.G.        17  9  3  5 23-21 30  [Tecos]  
 4.América       17  7  5  5 27-22 26

Topscorers:
Jose Cardozo (Toluca)         13
Claudinho (Morelia)           11
Carlos Hermosillo (Cruz Azul) 11


Playoff for Quarterfinal Places:

First Legs [Apr 8,10]
Puebla      2-1 UAG
[Carlos Muñoz 50, Manuel Sol 66; Rubén da Silva 29pen]
Toros Neza  1-2 America
  [Rodrigo Ruiz 1; Christian Torres 10, Néstor Cedros 28]

Second Legs [Apr 11,13]
UAG         4-1 Puebla
  [Eustacio Rizo 4, Mario Rosales 27, Rubén da Silva 56, Zdenko Muf 70; Aurelio Rivera 87]
America     4-2 Toros Neza
  [Christian Torres 27, Luis Roberto Alves 47, Néstor Cedros 77, Oscar Pantoja 87; Juan Ramón Fleita 17, 65]

Quarterfinals:

First Legs [Apr 15,16]
UAG         2-1 Atlas
  [Rubén da Silva 65, 90; Gastón Obledo 17]
Atlante     0-1 Toluca
  [José Cardozo 28]
Santos      0-0 Necaxa
America     2-1 Cruz Azul
  [Raúl Rodrigo Lara 17, Sergio Zárate 62; Benjamín Galindo 89]

Second Legs [Apr 18,19]
Atlas       4-2 UAG
  [Miguel Zepeda 24, 66, Daniel Guzmán 42, Gastón Obledo 54; Reynaldo Parks 63, Marco Garcés 68]
Toluca      5-1 Atlante
  [Darko Vukic 35, José Manuel Abundis 40, José Cardozo 81, 85, Víctor Ruiz 91; Carlos Alfaro Moreno 77pen]
Necaxa      2-1 Santos
  [Pedro Pineda 73, Alex Aguinaga 89; Jared Borguetti 82]
Cruz Azul   1-1 America
  [Julio César Yegros 48; Luis Roberto Alves 52]

Semifinals:

First Legs [Apr 25,26]
Atlas       1-2 Necaxa
  [Hugo Castillo 46; Pedro Pineda 24, Alex Aguinaga 43]
America     0-1 Toluca
  [Enrique Alfaro 52]

Second Legs [May 2,3]
Necaxa      1-1 Atlas
  [Pedro Pineda 48; Hugo Castillo 57]
Toluca      2-1 America
  [José Manuel Abundis 14, Fabián Estay 65; Néstor Cedrés 83]

Final:

   - 1st leg:
   07.May.98  Mexico City  18:00
Necaxa   2-1 Toluca
  [Pedro Pineda 56, 87; Víctor Ruiz 76]

   - 2nd leg:
   10.May.98  Toluca, Edo. de Mexico  12:00
Toluca   5-2 Necaxa 
  [Antonio Taboada 3, José Manuel Abundis 35, 52, José Cardozo 58, 89; 
  José Luis Montes de Oca 1, Alex Aguinaga 2]



Authors: Roger Z. Rios-Mercado and Erik Francisco Lugo

Last updated: 29 Jan 2009

(C) Copyright Roger Z. Rios-Mercado, Erik Francisco Lugo
and RSSSF 1998/2009
						

La Primera División de México (conocida comercialmente como Liga Bancomer MX) es el torneo de fútbol profesional más importante de México, es el primer nivel de la Liga Mexicana de Fútbol. Este se estableció en 1943; la clasificación a la liguilla se hará con base en la tabla general. Se juegan dos torneos por año denominados Clausura y Apertura (en ese orden), antes denominados Verano e Invierno respectivamente.


  USO DE MEMORIA  
4,337,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.1055
Total Execution Time  0.1080
  CADENA URL  
/clausura_mexico1998
  GET DATOS  
$_GET['/clausura_mexico1998']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0018  SELECT type FROM routes WHERE alias = 'clausura_mexico1998'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clausura_mexico' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=141 AND type_rel = 3
0.0077  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 141 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0025  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 (1312419,1312319,1312165,1312016,1311929) ORDER BY n.cover_points DESC, update_date DESC
0.0021  SELECT text_es as historical_text FROM leagues_text WHERE id=2097
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 = 30355 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=68 ORDER BY l.group_code ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 00:43:24' 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-25 00:43:24' 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-25 00:43:24' 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-25 00:43:24' 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 = 'clausura_mexico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1998 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 events1998 e WHERE e.league_id IN (30355) 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 (30355) 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 events1998 e WHERE e.league_id IN (30355) 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 (30355) 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 events1998 e WHERE e.league_id IN (30355) AND (e.action IN (3,4) ) 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 (30355) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events1998 e WHERE e.league_id IN (30355) AND (e.action IN (22) ) 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 (30355) 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 = 30355 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0019  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 = 30355 AND rp.events > 0 ORDER BY rp.events 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=30355 AND rel.round=17
0.0021  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 = 30355 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 = 30355 AND esl.points > 0
0.0021  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-26" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30355 ORDER BY creation_date DESC LIMIT 0, 10
0.0025  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-26" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30355
0.0021  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 `calendars1998` 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` = 30355 AND c.`round` = 17 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 `events1998` e INNER JOIN calendars1998 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 = 17 AND e.real_date IS NOT NULL AND e.league_id = 30355 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 `events1998` e INNER JOIN calendars1998 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 = 30355 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0024  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 `tables1998` 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 = 30355 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1998` 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 = 30355 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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-25 00:00:00' AND c.`shedule` < '2024-04-29 23:59:59' AND l.id = 30355 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0024  SELECT data1, data2 FROM services_tags WHERE categoryId=141
0.0024  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 141 AND l.year = 1998 ORDER BY l.group_code ASC
0.0024  SELECT group_code, extraName from `leagues` WHERE categoryId=141 AND year=1998