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 - Apertura 1989
1988/1989

Liga MX - Apertura 1989

Información Histórica
						

Regular Season

week 1
[Oct 15]
U de G 2 Atlas 8
UANL 1 Necaxa 2
América 0 Cobras 0
[Oct 16]
Toluca 1 UAG 2
UNAM 3 Irapuato 2
Puebla 1 Cruz Azul 1
Guadalajara 1 Atlético Potosino 0
UAT 3 Monterrey 0
Tampico-Madero 3 Atlante 1
Santos Laguna 1 Atlético Morelia 1

Week 2
[Oct 21]
Necaxa 3 Tampico-Madero 0
UAG 1 América 0
Atlético Potosino 0 U de G 0
[Oct 22]
Monterrey 0 UNAM 3
Cobras 3 UAT 0
Atlas 2 Toluca 3
Cruz Azul 1 Atlético Morelia 1
[Oct 23]
Atlante 1 Guadalajara 1
Santos Laguna 2 UANL 1
Irapuato 1 Puebla 0

Week 3
[Oct 28]
UNAM 3 Cobras 0
[Oct 29]
UANL 3 Cruz Azul 2
U de G 0 Atlante 1
[Oct 30]
Toluca 5 Atlético Potosino 3
América 1 Atlas 1
Guadalajara 3 Necaxa 2
UAT 0 UAG 1
Tampico-Madero 4 Santos Laguna 1
Irapuato 2 Monterrey 0
Puebla 4 Atlético Morelia 1

Week 4
[Nov 4]
Atlante 1 Toluca 0
UAG 0 UNAM 1
Atlético Potosino 1 América 2
[Nov 5]
Cruz Azul 1 Tampico-Madero 2
Cobras 1 Irapuato 1
Atlas 2 UAT 1
Monterrey 0 Puebla 2
[Nov 6]
Necaxa 1 U de G 2
Santos Laguna 1 Guadalajara 0
Atlético Morelia 4 UANL 2

Week 5
[Nov 11]
América 0 Atlante 2
[Nov 12]
Monterrey 0 Cobras 0
U de G 3 Santos Laguna 0
[Nov 13]
Toluca 2 Necaxa 3
Puebla 3 UANL 1
Guadalajara 3 Cruz Azul 1
UAT 1 Atlético Potosino 0
Irapuato 1 UAG 4
Tampico-Madero 3 Atlético Morelia 0
[Nov 15]
UNAM 2 Atlas 0

Week 6
[Nov 18]
Atlante 2 UAT 1
UAG 1 Monterrey 3
[Nov 19]
Cruz Azul 2 U de G 1
UANL 1 Tampico-Madero 0
Cobras 0 Puebla 0
Atlas 5 Irapuato 1
Atlético Potosino 1 UNAM 1
[Nov 20]
Necaxa 0 América 0
Santos Laguna 2 Toluca 1
Atlético Morelia 3 Guadalajara 2

Week 7
[Nov 25]
América 2 Santos Laguna 1
[Nov 26]
Monterrey 2 Atlas 1
UNAM 1 Atlante 1
U de G 1 Atlético Morelia 1
[Nov 27]
Toluca 2 Cruz Azul 3
Puebla 1 Tampico-Madero 1
Guadalajara 3 UANL 1
UAT 3 Necaxa 1
Cobras 0 UAG 0
Irapuato 3 Atlético Potosino 0

Week 8
[Dec 2]
Atlante 3 Irapuato 1
UAG 0 Puebla 0
[Dec 3]
Cruz Azul 1 América 3
UANL 1 U de G 0
Atlas 2 Cobras 1
Atlético Potosino 1 Monterrey 1
[Dec 4]
Necaxa 0 UNAM 2
Tampico-Madero 0 Guadalajara 1
Santos Laguna 1 UAT 0
Atlético Morelia 3 Toluca 3

Week 9
[Dec 9]
UAG 3 Atlas 0
América 1 Atlético Morelia 0
[Dec 10]
Monterrey 1 Atlante 2
U de G 0 Tampico-Madero 0
[Dec 11]
Toluca 4 UANL 1
UNAM 1 Santos Laguna 1
Puebla 2 Guadalajara 0
UAT 1 Cruz Azul 0
Cobras 0 Atlético Potosino 0
Irapuato 0 Necaxa 0

Week 10
[Dec 16]
Necaxa 2 Monterrey 2
Atlético Potosino 0 UAG 1
[Dec 17]
Cruz Azul 1 UNAM 0
UANL 0 América 0
Atlas 1 Puebla 2
[Dec 18]
Atlante 3 Cobras 1
Guadalajara 2 U de G 3
Santos Laguna 0 Irapuato 0
Tampico-Madero 7 Toluca 2
Atlético Morelia 1 UAT 1

Week 11
[Dec 21]
Atlas 4 Atlético Potosino 1
Monterrey 1 Santos Laguna 0
[Dec 22]
América 3 Tampico-Madero 2
Toluca 1 Guadalajara 0
Cobras 2 Necaxa 1
Puebla 2 U de G 1
UAG 3 Atlante 0
Irapuato 2 Cruz Azul 2
UAT 1 UANL 1
[Dec 23]
UNAM 0 Atlético Morelia 0

Week 12
[Dec 28]
Cruz Azul 2 Monterrey 2
U de G 2 Toluca 1
[Dec 29]
Guadalajara 2 América 2
Necaxa 1 UAG 0
Santos Laguna 0 Cobras 0
UANL 0 UNAM 3
Tampico-Madero 5 UAT 5
[Dec 30]
Atlante 2 Atlas 0
Atlético Potosino 2 Puebla 2
Atlético Morelia 1 Irapuato 1

Week 13
[Jan 6]
UNAM 3 Tampico-Madero 1
UAG 2 Santos Laguna 0
[Jan 7]
Atlas 0 Necaxa 0
Monterrey 2 Atlético Morelia 2
[Jan 8]
América 0 U de G 0
Puebla 3 Toluca 0
Atlético Potosino 1 Atlante 1
UAT 1 Guadalajara 0
Cobras 1 Cruz Azul 1
Irapuato 0 UANL 2

Week 14
[Jan 13]
Necaxa 4 Atlético Potosino 3
[Jan 14]
Cruz Azul 3 UAG 4
UANL 1 Monterrey 3
U de G 2 UAT 2
[Jan 15]
Atlante 0 Puebla 2
Guadalajara 1 UNAM 1
Santos Laguna 0 Atlas 0
Atlético Morelia 4 Cobras 0
Miércoles 18 de Enero 
América 3 Toluca 0
[Jan 31]
Tampico-Madero 2 Irapuato 0

Week 15
[Jan 20]
UNAM 1 U de G 1
UAG 2 Atlético Morelia 2
[Jan 21]
Monterrey 3 Tampico-Madero 1
Atlas 2 Cruz Azul 1
[Jan 22]
Atlante 2 Necaxa 0
Puebla 3 América 1
Atlético Potosino 3 Santos Laguna 1
UAT 2 Toluca 1
Cobras 4 UANL 1
Irapuato 1 Guadalajara 1

Week 16
[Jan 27]
Necaxa 1 Puebla 0
[Jan 28]
Cruz Azul 2 Atlético Potosino 1
UANL 1 UAG 1
U de G 2 Irapuato 0
[Jan 29]
Toluca 0 UNAM 1
América 3 UAT 1
Guadalajara 3 Monterrey 1
Santos Laguna 1 Atlante 0
Tampico-Madero 3 Cobras 2
Atlético Morelia 3 Atlas 2

Week 17
[Feb 3]
UNAM 1 América 2
UAG 0 Tampico-Madero 2
[Feb 4]
Necaxa 2 Santos Laguna 0
Monterrey 1 U de G 1
Atlas 1 UANL 1
[Feb 5]
Atlante 2 Cruz Azul 2
Puebla 2 UAT 2
Cobras 1 Guadalajara 1
Irapuato 1 Toluca 3
Atlético Potosino 0 Atlético Morelia 0

Week 18
[Feb 10]
América 3 Irapuato 0
[Feb 11]
Cruz Azul 2 Necaxa 0
UANL 2 Atlético Potosino 1
U de G 1 Cobras 2
[Feb 12]
Toluca 3 Monterrey 3
Puebla 6 Santos Laguna 0
Guadalajara 2 UAG 2
UAT 2 UNAM 0
Tampico-Madero 2 Atlas 1
Atlético Morelia 1 Atlante 0

week 19
[Feb 17]
UNAM 1 Puebla 1
UAG 2 U de G 1
[Feb 18]
Monterrey 1 América 1
Atlas 2 Guadalajara 2
Necaxa 1 Atlético Morelia 1
[Feb 19]
Atlante 3 UANL 0
Santos Laguna 1 Cruz Azul 1
Atlético Potosino 2 Tampico-Madero 1
Cobras 1 Toluca 1
Irapuato 1 UAT 1

Week 20
[Feb 24]
Atlante 0 Tampico-Madero 0
UAG 1 Toluca 1
[Feb 25]
Cruz Azul 0 Puebla 0
Monterrey 0 UAT 1
Atlas 0 U de G 2
[Feb 26]
Necaxa 3 UANL 0
Atlético Potosino 0 Guadalajara 1
Cobras 3 América 2
Irapuato 1 UNAM 0
Atlético Morelia 0 Santos Laguna 0

Week 21
[Mar 1]
Toluca 2 Atlas 1
UANL 1 Santos Laguna 1
América 3 UAG 0
UNAM 1 Monterrey 1
Puebla 2 Irapuato 0
U de G 4 Atlético Potosino 2
UAT 1 Cobras 1
Atlético Morelia 3 Cruz Azul 3
[Mar 2]
Guadalajara 2 Atlante 1
Tampico-Madero 2 Necaxa 1

Week 22
[Mar 4]
Cruz Azul 4 UANL 0
Monterrey 0 Irapuato 0
Atlas 1 América 5
[Mar 5]
Necaxa 1 Guadalajara 0
UAG 3 UAT 0
Cobras 1 UNAM 3
Atlético Potosino 2 Toluca 0
Santos Laguna 0 Tampico-Madero 0
Atlético Morelia 2 Puebla 1
[Mar 8]
Atlante 2 U de G 1

Week 23
[Mar 10]
América 4 Atlético Potosino 0
[Mar 11]
Puebla 3 Monterrey 0
U de G 1 Necaxa 0
UANL 2 Atlético Morelia 1
[Mar 12]
Toluca 1 Atlante 1
  [Javier Barajas 87; Dante Juárez 72]
UNAM 1 UAG 0
  [Manuel Negrete 65]
Guadalajara 5 Santos Laguna 2
UAT 2 Atlas 0
Tampico-Madero 5 Cruz Azul 0
  [Sergio Lira 9pen, Mario Hernández 17, Eduardo Bacas 37, Reinaldo Güeldini 49, Aurelio Rivera 80]
Irapuato 4 Cobras 0

week 24
[Mar 17]
Necaxa 0 Toluca 0
UAG 2 Irapuato 2
Atlético Potosino 2 UAT 1
[Mar 18]
Cruz Azul 0 Guadalajara 1
UANL 0 Puebla 0
Atlas 1 UNAM 0
[Mar 19]
Atlante 3 América 0
Santos Laguna 0 U de G 1
Cobras 2 Monterrey 2
Atlético Morelia 1 Tampico-Madero 0

Week 25
[Mar 22]
América 0 Necaxa 2
  [Roberto Alderete 24, Ismael Herrera 78]
[Mar 25]
Monterrey 3 UAG 2
Puebla 3 Cobras 0
U de G 1 Cruz Azul 1
[Mar 26]
Toluca 2 Santos Laguna 0
UNAM 0 Atlético Potosino 0
UAT 2 Atlante 1
Tampico-Madero 3 UANL 0
Irapuato 1 Atlas 0
Guadalajara 2 Atlético Morelia 1

Week 26
[Mar 31]
Necaxa 3 UAT 1
UAG 0 Cobras 0
Atlético Potosino 1 Irapuato 0
[Apr 1]
Cruz Azul 4 Toluca 2
UANL 1 Guadalajara 0
Atlas 2 Monterrey 0
Tampico-Madero 5 Puebla 1
[Apr 2]
Atlante 1 UNAM 0
Santos Laguna 1 América 2
Atlético Morelia 1 U de G 2

Week 27
[Apr 5]
UAT 0 Santos Laguna 0
Irapuato 2 Atlante 0
Cobras 3 Atlas 0
América 1 Cruz Azul 2
U de G 0 UANL 0
Monterrey 1 Atlético Potosino 1
Puebla 4 UAG 1
[Apr 6]
Guadalajara 4 Tampico-Madero 1
UNAM 0 Necaxa 0
[Apr 12]
Toluca 1 Atlético Morelia 0

Week 28
[Apr 8]
Cruz Azul 3 UAT 2
UANL 2 Toluca 0
Atlas 0 UAG 0
Tampico-Madero 5 U de G 1
[Apr 9] 
Atlante 3 Monterrey 2
Guadalajara 2 Puebla 1
Atlético Potosino 1 Cobras 2
Santos Laguna 0 UNAM 0
Atlético Morelia 2 América 1
[Apr 10]
Necaxa 2 Irapuato 0

Week 29
[Apr 14]
América 4 UANL 0
UAG 1 Atlético Potosino 0
[Apr 15]
Monterrey 0 Necaxa 1
Cobras 1 Atlante 1
U de G 1 Guadalajara 0
Puebla 3 Atlas 1
[Apr 16]
Toluca 4 Tampico-Madero 2
UNAM 1 Cruz Azul 2
Irapuato 3 Santos Laguna 2
UAT 3 Atlético Morelia 2

Week 30
[Apr 21]
Necaxa 1 Cobras 1
Atlético Potosino 1 Atlas 2
[Apr 22]
Cruz Azul 2 Irapuato 1
UANL 1 UAT 0
U de G 0 Puebla 4
*Tampico-Madero vs. América
*Abandoned at 24’ due to croud trouble, the 66 minutes left were played on May 10
[Apr 23]
Atlante 1 UAG 0
Guadalajara 2 Toluca 1
Santos Laguna 2 Monterrey 0
Atlético Morelia 1 UNAM 0
[May 10]
Tampico-Madero 2 América 0

Week 31
[Apr 28]
UAG 2 Necaxa 3
[Apr 29]
UNAM 1 UANL 1
Monterrey 1 Cruz Azul 4
Cobras 2 Santos Laguna 2
Atlas 0 Atlante 2
[Apr 30]
Toluca 0 U de G 0
América 3 Guadalajara 1
Puebla 4 Atlético Potosino 0
UAT 2 Tampico-Madero 2
Irapuato 1 Atlético Morelia 1

Week 32
[May 5]
Atlante 1 Atlético Potosino 0
[May 6]
Cruz Azul 1 Cobras 1
UANL 0 Irapuato 0
U de G 1 América 0
Tampico-Madero 1 UNAM 1
[May 7]
Toluca 0 Puebla 1
Necaxa 6 Atlas 0
Guadalajara 4 UAT 2
Santos Laguna 1 UAG 1
Atlético Morelia 1 Monterrey 1

Week 33
[May 12]
UAG 1 Cruz Azul 4
Atlético Potosino 0 Necaxa 0
[May 13]
Monterrey 1 UANL 0
Atlas 1 Santos Laguna 1
Cobras 0 Atlético Morelia 0
[May 14]
UNAM 0 Guadalajara 3
Puebla 1 Atlante 1
Toluca 0 América 2
UAT 0 U de G 1
Irapuato 1 Tampico-Madero 2

Week 34
[May 19]
América 0 Puebla 1
[May 20]
Cruz Azul 5 Atlas 0
UANL 3 Cobras 2
U de G 1 UNAM 0
Tampico-Madero 4 Monterrey 2
[May 21]
Toluca 4 UAT 1
Necaxa 3 Atlante 1
Guadalajara 3 Irapuato 0
Santos Laguna 3 Atlético Potosino 1
Atlético Morelia 4 UAG 2

Week 35
[May 26]
UAG 1 UANL 1
Atlético Potosino 0 Cruz Azul 2
[May 27]
UNAM 1 Toluca 1
Monterrey 1 Guadalajara 1
Cobras 3 Tampico-Madero 5
Atlas 2 Atlético Morelia 2
[May 28]
Atlante 4 Santos Laguna 2
Puebla 2 Necaxa 2
UAT 0 América 0
Irapuato 4 U de G 2

Week 36
[Jun 3]
Cruz Azul 0 Atlante 3
UANL 1 Atlas 0
Tampico-Madero 1 UAG 3
U de G 2 Monterrey 2
[Jun 4]
Toluca 3 Irapuato 3
América 0 UNAM 1
Guadalajara 3 Cobras 0
UAT 1 Puebla 1
Santos Laguna 0 Necaxa 0
Atlético Morelia 4 Atlético Potosino 0

Week 37
[Jun 9]
UAG 1 Guadalajara 1
Atlético Potosino 1 UANL 0
Atlante 4 Atlético Morelia 3
[Jun 10]
Necaxa 4 Cruz Azul 1
Monterrey 0 Toluca 2
Cobras 2 U de G 1
Atlas 2 Tampico-Madero 4
[Jun 11]
UNAM 3 UAT 0
Irapuato 1 América 1
Santos Laguna 1 Puebla 4

Week 38
[Jun 17]
Cruz Azul 1 Santos Laguna 0
UANL 2 Atlante 2
U de G 3 UAG 1
Puebla 1 UNAM 1
[Jun 18]
UAT 1 Irapuato 1
Toluca 1 Cobras 1
América 3 Monterrey 1
Guadalajara 3 Atlas 0
Tampico-Madero 4 Atlético Potosino 0
Atlético Morelia 2 Necaxa 1

Final Table
Group I
*América		38	17	9	12	58:39	+19	43
*Cruz Azul		38	16	11	11	68:59	+9	43
Toluca			38	11	10	17	58:67	-9	32
Irapuato		38	9	14	15	43:57	-14	32
Monterrey		38	7	15	16	44:66	-22	29

Group II
*Puebla			38	20	13	5	73:31	+42	53
*Atlante		38	20	9	9	59:41	+18	49
U de G			38	15	11	12	48:51	-3	41
UANL			38	11	11	16	38:61	-23	33
Santos Laguna		38	7	15	16	31:56	-25	29

Group III
*Tampico-Madero		38	20	7	11	87:56	+31	47
*Guadalajara		38	19	9	10	66:43	+23	47
Necaxa			38	17	11	10	57:38	+19	45
Atlético Morelia	38	12	17	9	60:53	+7	41
+Atlético Potosino	38	6	10	22	31:68	-37	22

Group IV
*UNAM			38	13	15	10	42:30	+12	41
*UAG			38	13	12	13	51:51	0	38
Ciudad Juárez		38	8	19	11	44:56	-12	35
UAT			38	11	12	15	48:58	-10	34
Atlas			38	9	8	21	47:73	-26	26
*Qualified to playoffs
+Relegated

Liguilla Final (Playoffs)
Semifinals (Round Robin)
Week 1
[Jun 21]
UNAM 2 Atlante 2
  [Luis García 32, Manuel Negrete 89; Constantino López 2, Dante Juárez 33]
Cruz Azul 2 Tampico Madero 1
  [Pedro Duana 11, Patricio Hernández 84; Sergio Lira 37pen]
UAG 2 Puebla 2
  [José Guadalupe Zavala 41, Javier Hernández 65; Marcelino Bernal 76, 85]
[Jun 22]
América 2 Guadalajara 1
  [Juan Hernández 76, Carlos Alberto Seixas 87; Luis Antonio Valdez 7]

Week 2
[Jun 24]
Atlante 1 UNAM 1
  [Rubén Omar Romano 53; Alberto García Aspe 79]
Tampico Madero 1 Cruz Azul 0
  [Sergio Lira 32pen]
[Jun 25]
Puebla 2 UAG 1
  [Carlos Poblete 60, Jorge Aravena 86; Ricardo Viera 84]
Guadalajara 2 América 1
  [Demetrio Madero 8, Benjamín Galindo 14; Antonio Carlos Santos 44]

Week 3
[Jun 28]
UNAM 5 Tampico Madero 1               [in Morelia]
  [Guillermo Vázquez 23, 46, Alberto García Aspe 34, David Patiño 71, 83; Fabián Rosas 66]
Cruz Azul 3 Atlante 1
  [Patricio Hernández 23pen, Agustín Manzo 50, Narciso Cuevas 62; Eduardo Moses 46]
UAG 1 Guadalajara 0
  [Ricardo Chávez Medrano 73]
[Jun 29]
América 2 Puebla 2
  [Cecilio de los Santos 37, Héctor Rosete 62og; Carlos Poblete 74, Jorge Aravena 78]

Week 4
[Jul 1]
Tampico Madero 1 UNAM 0
  [Eduardo Bacas 43]
[Jul 2]
Atlante 2 Cruz Azul 3
  [Oswaldo Ingrao 11, Dante Juárez 16; Porfirio Jiménez 30, Narciso Cuevas 65, Ricardo Mojica 76]
Puebla 1 América 1
  [José Francisco Romero 81; Gonzalo Farfán 57]
Guadalajara 2 UAG 0
  [Javier Aguirre 3, Benjamín Galindo 74pen]

Week 5
[Jul 5]
UNAM 0 Cruz Azul 1                    [in Estadio Azulgrana (Atlante)]
  [Pedro Duana 9]
UAG 0 América 2
  [Carlos Alberto Seixas 72, 78]
Tampico Madero 3 Atlante 0
  [Mario Hernández 7, 20, Eduardo Bacas 31]
[Jul 6]
Guadalajara 1 Puebla 0
  [Omar Arellano 18]

Week 6
[Jul 8]
Cruz Azul 1 UNAM 4
  [Raúl Arias 29pen; David Patiño 7, 89, Manuel Negrete 10pen, Israel Castillo 17]
Atlante 2 Tampico Madero 2
  [Víctor Medina 30, Jacinto Ambriz 81; Sergio Lira 15, Eduardo Bacas 79]
[Jul 9]
Puebla 0 Guadalajara 3
  [Benjamín Galindo 68, 79, Omar Arellano 76]
América 4 UAG 0
  [Carlos Alberto Seixas 43, Gonzalo Farfán 54, Guillermo Huerta 64, Carlos Hermosillo 75]

Table
Group 1
*América         6  3  2  1 12   6   +6   8
Guadalajara      6  4  0  2  9   4   +5   8
Puebla           6  1  3  2  7  10   -3   5
UAG              6  1  1  4  4  12   -8   3

Group 2
*Cruz Azul       6  4  0  2 10   9  +1    8
Tampico Madero   6  3  1  2  9   9   0    7
UNAM             6  2  2  2 12   7  +5    6
Atlante          6  0  3  3  8  15  -7    3
*Qualified to Final

Final
First Leg
[Jul 13]
Cruz Azul 2 América 3
  [Porfirio Jiménez 45, Narciso Cuevas 47+; Luis Roberto Alves 1, Carlos Hermosillo 31, Antonio Carlos Santos 58pen]

Second Leg
[Jul 16]
América 2 Cruz Azul 2
  [Juan Hernández 6, Carlos Hermosillo 77; Patricio Hernández 20, Ricardo Mojica 27] 


Campeón de Campeones 1988-89 (Super Cup)
[Estadio Azteca, Ciudad de México]
[Jul 20]
América 2 Toluca 1 [aet]
  [Carlos Hermosillo 23, Carlos Alberto Seixas 93; Roberto Masciarelli 63]

Promoted: Potros Neza (the franchise was sold to Veracruz)
Relegated: Atlético Potosino

For the 1989-90 season Atlante moved to Querétaro





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

Last updated: 6 Feb 2014

(C) Copyright Erik Francisco Lugo and RSSSF 2009/14
						

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,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0027
Controller Execution Time ( Home / Category )  0.0822
Total Execution Time  0.0850
  CADENA URL  
/apertura_mexico1989
  GET DATOS  
$_GET['/apertura_mexico1989']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0020  SELECT type FROM routes WHERE alias = 'apertura_mexico1989'
0.0045  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 = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0024  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 = 30251 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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='1989' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 15:28:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 15:28:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0022  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 15:28:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 15:28:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0031  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 = 1989 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0025  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=30251 AND rel.round=38
0.0020  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 = 30251 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 = 30251 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` = 30251 ORDER BY creation_date DESC LIMIT 0, 10
0.0024  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` = 30251
0.0023  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 `calendars1989` 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` = 30251 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0022  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 `events1989` e INNER JOIN calendars1989 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 30251 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 `events1989` e INNER JOIN calendars1989 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 = 30251 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0031  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 `tables1989` 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 = 30251 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1989` 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 = 30251 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  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 = 30251 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0023  SELECT data1, data2 FROM services_tags WHERE categoryId=68
0.0023  SELECT group_code, extraName from `leagues` WHERE categoryId=68 AND year=1989