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

Liga MX - Apertura 1992

Información Histórica 
						
 
Regular Season 1991-92

Group I
UNAM		38	15	14	9	53:41	+12	44 [quarterfinal]
Veracruz	38	16	8	14	53:44	+9	40 [repesca]
Atlas		38	9	17	12	36:37	-1	35
UAG		38	8	13	17	35:47	-12	29
Cobras		38	5	10	23	33:59	-26	20 [relegated]

Group II
Guadalajara	38	13	19	6	41:31	+10	45 [quarterfinal]
Puebla		38	13	15	10	44:42	+2	41 [quarterfinal]
UAT		38	14	12	12	47:43	+4	40 [repesca]
Monterrey	38	12	13	13	41:49	-8	37
Querétaro	38	9	13	16	37:49	-12	31

Group III
Necaxa		38	16	14	8	67:46	+21	46 [quarterfinal]
León		38	15	15	8	47:38	+9	45 [quarterfinal]
Cruz Azul	38	15	14	9	60:51	+9	44 [repesca]
Toluca		38	13	12	13	47:49	-2	38
Santos Laguna	38	12	10	16	42:51	-9	34

Group IV
Atlante		38	19	12	7	65:48	+17	50 [quarterfinal]
América		38	13	14	11	46:45	+1	40 [repesca]
UANL		38	14	11	13	53:51	+2	39
A Morelia	38	10	15	13	41:47	-6	35
U de G		38	8	11	19	42:60	-18	27

Date 1
[Sep 14]
Cruz Azul 3 Querétaro 1
Veracruz 1 Atlas 0
Puebla 1 UANL 1
U de G 1 UAG 0
[Sep 15]
Guadalajara 1 UAT 0
Morelia 0 Necaxa 0
Toluca 2 América 2
UNAM 3 Cobras 1
León 1 Santos Laguna 1       [in Querétaro]
Monterrey 2 Atlante 2

Date 2
[Sep 20]
Necaxa 0 León 0
UAG 1 Veracruz 0
[Sep 21]
Atlante 1 Toluca 0
UANL 3 Cruz Azul 1
Cobras 0 Puebla 1
Atlas 1 UNAM 0
[Sep 22]
América 1 Guadalajara 1
Santos Laguna 2 Monterrey 0
UAT 4 U de G 0
Querétaro 2 Morelia 1

Date 3
[Sep 28]
Veracruz 2 UAT 0
Morelia 0 León 0
Cruz Azul 2 Cobras 3
Puebla 1 Atlas 2
U de G 0 América 1
Monterrey 4 Necaxa 0
[Sep 29]
Toluca 1 Santos Laguna 1
UNAM 2 UAG 1
Guadalajara 1 Atlante 1
Querétaro 2 UANL 2

Date 4
[Oct 4]
Necaxa 4 Toluca 0
UAG 1 Puebla 2
[Oct 5]
Atlante 0 U de G 0
UANL 0 Morelia 2
Cobras 0 Querétaro 0
Atlas 0 Cruz Azul 1
[Oct 6]
América 2 Veracruz 0
UAT 3 UNAM 1
León 1 Monterrey 1           [in Monterrey]
Santos Laguna 2 Guadalajara 1

Date 5
[Oct 12] 
Veracruz 2 Atlante 1
UANL 1 Cobras 0
Puebla 1 UAT 0
U de G 4 Santos Laguna 0
[Oct 13]
Cruz Azul 2 UAG 1
Guadalajara 1 Necaxa 1
Querétaro 0 Atlas 3
Toluca 1 León 1
Morelia 2 Monterrey 0
[Jan 8]
UNAM 0 América 2

Date 6
[Oct 18]
Necaxa 3 U de G 0
UAG 0 Querétaro 0
[Oct 19]
Atlante 4 UNAM 2
Monterrey 0 Toluca 0
Cobras 2 Morelia 3
Atlas 2 UANL 1
[Oct 20]
América 2 Puebla 2
León 4 Guadalajara 0
UAT 1 Cruz Azul 1
Santos Laguna 2 Veracruz 1

Date 7
[Oct 26]
U de G 0 León 0
Veracruz 5 Necaxa 3
Cobras 1 Atlas 3
Cruz Azul 1 América 1
[Oct 27]
Puebla 2 Atlante 3
UNAM 0 Santos Laguna 0
Guadalajara 0 Monterrey 0
UANL 0 UAG 2
Querétaro 0 UAT 0
Morelia 1 Toluca 1

Date 8
[Nov 1]
Necaxa 1 UNAM 1
[Nov 2]
Atlante 1 Cruz Azul 1
Atlas 1 Morelia 1
Monterrey 4 U de G 1
[Nov 3]
UAG 2 Cobras 0
UAT 4 UANL 1
Santos Laguna 1 Puebla 1
América 3 Querétaro 1
León 3 Veracruz 1
Toluca 1 Guadalajara 1

Date 9
[Nov 6]
Morelia 2 Guadalajara 0
Atlas 1 UAG 1
UNAM 0 León 0
Veracruz 1 Monterrey 2
Cobras 0 UAT 0
Querétaro 2 Atlante 3
Puebla 1 Necaxa 0
UANL 3 América 2
[Nov 7]
U de G 3 Toluca 2
Cruz Azul 1 Santos Laguna 0

Date 10
[Nov 9]
América 1 Cobras 0
Monterrey 1 UNAM 4
UAG 3 Morelia 2
[Nov 10]
Toluca 1 Veracruz 0
Necaxa 0 Cruz Azul 1
León 0 Puebla 0
UAT 2 Atlas 1
Santos Laguna 1 Querétaro 0
[Nov 11]
Atlante 2 UANL 0
[Dec 10]
Guadalajara 1 U de G 1

Date 11
[Nov 15]
UAG 0 UAT 0
[Nov 16]
Atlas 1 América 0
Veracruz 0 Guadalajara 1
Cobras 2 Atlante 3
UANL 2 Santos Laguna 2
UNAM 3 Toluca 0
[Nov 17]
Cruz Azul 3 León 1
Morelia 2 U de G 1
Querétaro 1 Necaxa 0
Puebla 0 Monterrey 0

Date 12
[Nov 22]
Necaxa 3 UANL 2
[Nov 23]
Atlante 1 Atlas 1
U de G 1 Veracruz 1
Monterrey 2 Cruz Azul 1
[Nov 24]
UAT 1 Morelia 0
Santos Laguna 2 Cobras 0
Guadalajara 0 UNAM 0
América 2 UAG 0
León 1 Querétaro 0
Toluca 0 Puebla 2

Date 13
[Nov 29]
UAG 2 Atlante 2
[Nov 30]
Cruz Azul 2 Toluca 3
UANL 3 León 1
Atlas 0 Santos Laguna 0
[Dec 1]
UNAM 4 U de G 0
Puebla 1 Guadalajara 0
Querétaro 1 Monterrey 0
Morelia 0 Veracruz 0
UAT 5 América 1
Cobras 2 Necaxa 0

Date 14
[Dec 6]
Necaxa 1 Atlas 1
[Dec 7]
Veracruz 1 UNAM 1
Atlante 2 UAT 0
Monterrey 0 UANL 1
U de G 2 Puebla 0
[Dec 8]
Toluca 0 Querétaro 0
América 2 Morelia 2
Guadalajara 1 Cruz Azul 1
León 1 Cobras 0
Santos Laguna 4 UAG 1

Date 15
[Dec 11]
Puebla 1 Veracruz 0
Morelia 2 UNAM 5
Cobras 2 Monterrey 0
Querétaro 0 Guadalajara 0
Atlas 0 León 0
UANL 2 Toluca 0
UAT 2 Santos Laguna 0          [in Ciudad Juárez]
Cruz Azul 1 U de G 1
[Dec 12]
América 1 Atlante 3
UAG 2 Necaxa 2

Date 16
[Dec 14]
Veracruz 1 Cruz Azul 0
Atlante 1 Morelia 0
Monterrey 2 Atlas 1
U de G 1 Querétaro 0
UNAM 3 Puebla 0
[Dec 15]
Toluca 3 Cobras 1
Necaxa 2 UAT 0
Guadalajara 3 UANL 1
León 3 UAG 1
Santos Laguna 0 América 1
 
Date 17
[Dec 20]
UAG 4 Monterrey 0
Cruz Azul 1 UNAM 2
[Dec 21]
Atlante 2 Santos Laguna 2
UANL 4 U de G 1
Atlas 1 Toluca 1
[Dec 22]
América 1 Necaxa 5
UAT 1 León 0
Querétaro 2 Veracruz 3
Cobras 1 Guadalajara 1
Morelia 0 Puebla 0

Date 18
[Dec 28]
UNAM 2 Querétaro 1
Veracruz 1 UANL 1
Monterrey 0 UAT 0
U de G 1 Cobras 1
[Dec 29]
Necaxa 1 Atlante 2
Toluca 3 UAG 1
Guadalajara 1 Atlas 0
Puebla 2 Cruz Azul 1
Morelia 2 Santos Laguna 2
León 1 América 0

Date 19
[Jan 3]
Atlante 2 León 2
[Jan 4]
Cruz Azul 1 Morelia 0
UANL 2 UNAM 0
Atlas 2 U de G 2
[Jan 5]
América 2 Monterrey 0
UAG 0 Guadalajara 0
UAT 1 Toluca 0
Querétaro 1 Puebla 1
Cobras 1 Veracruz 1
Santos Laguna 0 Necaxa 2

Date 20
[Jan 10]
Necaxa 0 Morelia 0
[Jan 11]
Atlante 3 Monterrey 0
Atlas 1 Veracruz 2
[Jan 12]
UAG 2 U de G 1
UANL 3 Puebla 1
América 3 Toluca 2
Querétaro 0 Cruz Azul 3
UAT 1 Guadalajara 0
Cobras 1 UNAM 1
Santos Laguna 4 León 1

Date 21
[Jan 18]
UNAM 2 Atlas 0
Veracruz 1 UAG 0
Monterrey 2 Santos Laguna 1
[Jan 19]
Cruz Azul 2 UANL 1
Guadalajara 0 América 0
Toluca 4 Atlante 2
León 3 Necaxa 1
Puebla 3 Cobras 1
Morelia 2 Querétaro 1
[Feb 27]
U de G 2 UAT 2

Date 22
[Jan 24]
Necaxa 5 Monterrey 1
UAG 2 UNAM 2
[Jan 25]
Atlante 1 Guadalajara 1
UANL 3 Querétaro 1
[Jan 26]
Atlas 0 Puebla 0
América 1 U de G 0
León 2 Morelia 2
UAT 1 Veracruz 3
Cobras 1 Cruz Azul 1
Santos Laguna 3 Toluca 1

Date 23
[Jan 29]
Toluca 3 Necaxa 3
Puebla 1 UAG 1
Morelia 1 UANL 0
Querétaro 0 Cobras 1
Monterrey 2 León 0
Cruz Azul 1 Atlas 1
Guadalajara 1 Santos Laguna 0
Veracruz 1 América 1
[Jan 30]
UNAM 0 UAT 0
U de G 1 Atlante 1

Date 24
[Feb 1]
Necaxa 1 Guadalajara 1
Monterrey 1 Morelia 1
Atlas 1 Querétaro 1
[Feb 2]
América 0 UNAM 1
UAG 1 Cruz Azul 2           [in Estadio Jalisco]
León 1 Toluca 0
UAT 3 Puebla 2
Cobras 0 UANL 0
Santos Laguna 2 U de G 1
[Feb 3]
Atlante 1 Veracruz 2

Date 25
[Feb 8]
Cruz Azul 2 UAT 2
UANL 2 Atlas 3
U de G 1 Necaxa 2
[Feb 9]
UNAM 0 Atlante 2
Toluca 1 Monterrey 0
Guadalajara 4 León 1
Puebla 3 América 1
Veracruz 2 Santos Laguna 0
Morelia 2 Cobras 1
Querétaro 1 UAG 1

Date 26
[Feb 14]
Necaxa 1 Veracruz 1
UAG 0 UANL 0
[Feb 15]
Atlante 1 Puebla 0
Monterrey 1 Guadalajara 1
Atlas 1 Cobras 1
[Feb 16]
Toluca 1 Morelia 1
América 1 Cruz Azul 1
León 3 U de G 2
UAT 0 Querétaro 1
Santos Laguna 0 UNAM 1

Date 27
[Feb 19]
Puebla 2 Santos Laguna 2
UNAM 1 Necaxa 1
Morelia 1 Atlas 0
Cobras 0 UAG 0
UANL 2 UAT 0
U de G 2 Monterrey 0
Querétaro 3 América 3            [in León]
Veracruz 0 León 1
[Feb 20]
Cruz Azul 3 Atlante 1
Guadalajara 1 Toluca 0

Date 28
[Feb 22]
Necaxa 1 Puebla 0
UAG 1 Atlas 0
Monterrey 3 Veracruz 2
[Feb 23]
Toluca 1 U de G 0
América 0 UANL 0
Guadalajara 2 Morelia 0
León 2 UNAM 1
UAT 1 Cobras 0
Santos Laguna 1 Cruz Azul 2
[Feb 24] 
Atlante 2 Querétaro 1

Date 29
[Feb 29]
Cruz Azul 1 Necaxa 4
UANL 1 Atlante 0
Atlas 4 UAT 1
Veracruz 3 Toluca 0
[Mar 1]
UNAM 0 Monterrey 0
Querétaro 2 Santos Laguna 0
U de G 0 Guadalajara 1
Puebla 1 León 0
Morelia 2 UAG 1
Cobras 0 América 1
 
Date 30
[Mar 13]
Necaxa 2 Querétaro 2
[Mar 14]
Atlante 2 Cobras 0           [in Estadio Azteca]
Monterrey 1 Puebla 1
U de G 1 Morelia 0
[Mar 15]
América 0 Atlas 0
Toluca 2 UNAM 2
León 2 Cruz Azul 2
Guadalajara 2 Veracruz 0
UAT 0 UAG 0
Santos Laguna 2 UANL 0

Date 31
[Mar 7]
UAG 0 América 1
[Mar 21]
Veracruz 2 U de G 1
Cruz Azul 2 Monterrey 2
UANL 1 Necaxa 2
Atlas 2 Atlante 2
[Mar 22]
UNAM 1 Guadalajara 0
Puebla 0 Toluca 3
Querétaro 1 León 0
Morelia 2 UAT 3
Cobras 4 Santos Laguna 0

Date 32
[Mar 27]
Necaxa 3 Cobras 1
[Mar 28]
Veracruz 2 Morelia 0
Atlante 3 UAG 0
Monterrey 1 Querétaro 1
U de G 0 UNAM 0
[Mar 29]
Toluca 1 Cruz Azul 1
América 1 UAT 1
León 1 UANL 1
Guadalajara 1 Puebla 1
Santos Laguna 0 Atlas 0

Date 33
[Apr 3]
UAG 1 Santos Laguna 0
[Apr 4]
Cruz Azul 2 Guadalajara 4
UANL 1 Monterrey 1
Atlas 0 Necaxa 0
[Apr 5]
UAT 2 Atlante 3
Morelia 0 América 0
Puebla 2 U de G 0
Querétaro 1 Toluca 0
UNAM 2 Veracruz 1
Cobras 0 León 1

Date 34
[Apr 10]
Atlante 1 América 0
[Apr 11]
Veracruz 3 Puebla 1
Monterrey 3 Cobras 1
UNAM 2 Morelia 1
U de G 1 Cruz Azul 2
[Apr 12]
Toluca 3 UANL 0
Necaxa 2 UAG 1
Guadalajara 2 Querétaro 0
León 3 Atlas 0
Santos Laguna 1 UAT 0

Date 35
[Apr 18]
Cruz Azul 2 Veracruz 1
UANL 1 Guadalajara 1
Atlas 0 Monterrey 1
[Apr 19]
América 3 Santos Laguna 0
Querétaro 5 U de G 2
UAG 0 León 1
Morelia 2 Atlante 2
Puebla 1 UNAM 1
Cobras 0 Toluca 1
UAT 2 Necaxa 2

Date 36
[Apr 24]
Monterrey 2 UAG 0
[Apr 25]
UNAM 2 Cruz Azul 2
Veracruz 0 Querétaro 0
[Apr 26]
Toluca 1 Atlas 0
Necaxa 2 América 1
León 2 UAT 2
Puebla 1 Morelia 1
Santos Laguna 0 Atlante 1
[Apr 29]
U de G 2 UANL 2
[May 6]
Guadalajara 2 Cobras 1

Date 37
[May 1]
Atlante 1 Necaxa 3
UAG 0 Toluca 1
[May 2]
Cruz Azul 2 Puebla 2
UANL 2 Veracruz 1
Atlas 2 Guadalajara 2
[May 3]
América 1 León 1
Querétaro 2 UNAM 0
Cobras 1 U de G 5
UAT 1 Monterrey 0
Santos Laguna 3 Morelia 1
  
Date 38
[May 9]
UNAM 1 UANL 3
Puebla 3 Querétaro 0
Veracruz 5 Cobras 2
Monterrey 2 América 1
U de G 0 Atlas 1
[May 10]
Toluca 3 UAT 1
Necaxa 4 Santos Laguna 1
Guadalajara 1 UAG 1
León 2 Atlante 0
Morelia 0 Cruz Azul 2

Group I
UNAM		38	15	14	9	53:41	+12	44 [quarterfinal]
Veracruz	38	16	8	14	53:44	+9	40 [repesca]
Atlas		38	9	17	12	36:37	-1	35
UAG		38	8	13	17	35:47	-12	29
Cobras		38	5	10	23	33:59	-26	20 [relegated]

Group II
Guadalajara	38	13	19	6	41:31	+10	45 [quarterfinal]
Puebla		38	13	15	10	44:42	+2	41 [quarterfinal]
UAT		38	14	12	12	47:43	+4	40 [repesca]
Monterrey	38	12	13	13	41:49	-8	37
Querétaro	38	9	13	16	37:49	-12	31

Group III
Necaxa		38	16	14	8	67:46	+21	46 [quarterfinal]
León		38	15	15	8	47:38	+9	45 [quarterfinal]
Cruz Azul	38	15	14	9	60:51	+9	44 [repesca]
Toluca		38	13	12	13	47:49	-2	38
Santos Laguna	38	12	10	16	42:51	-9	34

Group IV
Atlante		38	19	12	7	65:48	+17	50 [quarterfinal]
América		38	13	14	11	46:45	+1	40 [repesca]
UANL		38	14	11	13	53:51	+2	39
A Morelia	38	10	15	13	41:47	-6	35
U de G		38	8	11	19	42:60	-18	27

Playoffs
Repesca
First Legs
[May 13]
Cruz Azul 4 América 0
  [José Manuel de la Torre 2, 53, Mario Ordiales 68, Carlos Hermosillo 88]
UAT 2 Veracruz 0
  [Martín Arturo Vázquez 4og, Orlando Polo 28]

Second Legs
[May 16]
Veracruz 4 UAT 1
  [Francisco Sánchez 2og, José Luis Malibrán 46+, Horacio Rocha 49, Jorge Comas 54; René Mendieta 6]
América 2 Cruz Azul 0
  [Jesús Eduardo Córdova 7, Luis Roberto Alves 38]

Quarterfinals
First Legs
[May 20]
UNAM 0 León 1
  [Zé Roberto 89]
Veracruz 2 Necaxa 2
  [Pascual Ramírez 59, José Luis González China 73; Alberto García Aspe 46, 76]
[May 21]
Cruz Azul 1 Atlante 3
  [José Manuel de la Torre 89pen; Rubén Omar Romano 31, Marcelo Fabián Espina 60, 67]
Puebla 3 Guadalajara 1
  [Milton Nunhez 7, Salvador Luis Reyes 51, Carlos Poblete 89pen; Jaime Ordiales 88]

Second Legs
[May 23]
Necaxa 4 Veracruz 0
  [Ivo Basay 36, Ignacio Ambriz 73, Ricardo Peláez 84, Octavio Becerril 88og]
[May 24]
Atlante 2 Cruz Azul 4*
  [Marcelo Fabián Espina 65, Daniel Guzmán 72; Carlos Hermosillo 18, 48, Pedro Duana 57, Héctor Esparza 59]
León 1 UNAM 0
  [Milton Queiroz 50]
Guadalajara 2 Puebla 1
  [Armando González 54, Gerardo Silva 82; Carlos Poblete 38]

Semifinals
First Legs
[May 27]
Puebla 3 Necaxa 2
  [Carlos Poblete 5, 12, 67; Ivo Basay 29, Ricardo Peláez 57]
[May 28]
Cruz Azul 3 León 1
  [Carlos Hermosillo 15, 94, Mario Ordiales 17; Marco Antonio Benatto 89]

Second Legs
[May 30]
Necaxa 0 Puebla 0
[May 31]
*León 2 Cruz Azul 0
  [Milton Queiroz 55, Martín Castañeda 65]

Final
First Leg
[Jun 4]
Puebla 0 León 0

Second Leg
[Jun 7]
León 2 Puebla 0   [aet]
[Carlos Turrubiates 105, Aurelio Rivera 112og]


Final Second Level
Zacatepec 1 Pachuca 0
Pachuca 2 Zacatepec 1 [aet; 11-10pen] 

Promoted: Pachuca
Relegated: Cobras Ciudad Juárez


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

Last updated: 2 Oct 2009

(C) Copyright Erik Francisco Lugo and RSSSF 2009

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,349,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1372
Total Execution Time  0.1391
  CADENA URL  
/apertura_mexico1992
  GET DATOS  
$_GET['/apertura_mexico1992']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0020  SELECT type FROM routes WHERE alias = 'apertura_mexico1992'
0.0049  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 = 1992 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0023  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=68 AND type_rel = 3
0.0392  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 68 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0028  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 (1304130,1303039,1297779,1295604,1295599) ORDER BY n.cover_points DESC, update_date DESC
0.0023  SELECT text_es as historical_text FROM leagues_text WHERE id=1986
0.0023  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 = 30248 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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='1992' WHERE c.parentId=68 GROUP BY c.id ORDER BY c.order_id ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-18 11:11:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-18 11:11:29' 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-18 11:11:29' 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-18 11:11:29' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  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 = 1992 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 events1992 e WHERE e.league_id IN (30248) 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 (30248) 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 events1992 e WHERE e.league_id IN (30248) 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 (30248) 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 events1992 e WHERE e.league_id IN (30248) 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 (30248) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0021  SELECT e.action, count(e.action) as total, e.player_id FROM events1992 e WHERE e.league_id IN (30248) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0019  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 (30248) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0018  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 = 30248 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0018  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 = 30248 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=30248 AND rel.round=38
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 = 30248 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0020  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 = 30248 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-19" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 30248 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-19" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 30248
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 `calendars1992` 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` = 30248 AND c.`round` = 38 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 `events1992` e INNER JOIN calendars1992 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 = 30248 ORDER BY total DESC LIMIT 40
0.0023  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 `events1992` e INNER JOIN calendars1992 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 = 30248 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0023  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 `tables1992` 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 = 30248 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1992` 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 = 30248 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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-18 00:00:00' AND c.`shedule` < '2024-04-22 23:59:59' AND l.id = 30248 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=1992